public partial class _Default : System.Web.UI.Page
{
BalCity bal = new BalCity();
DataTable dt = null;
string cid = null;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindcity();
Bind();
}
}
void Bind()
{
if (Request.QueryString["id"]!=null)
{
cid = Convert.ToInt16(Request.QueryString["id"].ToString());
btnSubmit.Text = "Update";
bal.Action = "CityOnCondition";
bal.Id = cid;
//bal.City_Heading = cid;
dt=new DataTable();
dt=bal.BalBind();
txthead.Text = dt.Rows[0]["City_Heading"].ToString();
ddlcity.SelectedItem.Value = dt.Rows[0]["City_Name"].ToString();
}
}
private void bindcity()
{
bal.Action = "selectCity";
DataTable dt = bal.BalBind();
ddlcity.DataSource = dt;
ddlcity.DataTextField = "CityName";
ddlcity.DataValueField = "CityId";
ddlcity.Items.Insert(0, new ListItem("--Select--", "0"));
ddlcity.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (btnSubmit.Text!="Update")
{
Save();
}
else
{
Update();
}
}
void Update()
{
bal.Action = "NewUpdateCondition";
bal.Id = cid;
bal.City_Name = ddlcity.SelectedItem.ToString();
bal.City_Heading = txthead.Text;
if (imgupload.HasFile)
{
imgupload.SaveAs(Server.MapPath("~/uploadimage/" + imgupload.FileName));
string image = "~/uploadimage/" + imgupload.FileName;
bal.City_Image = image;
}
int t = bal.BalOperation();
if (t > 0)
{
Response.Write("<script>alert('updated!!')</script>");
}
}
void Save()
{
if (imgupload.HasFile)
{
bal.Action = "insert_citynews";
bal.City_Name = ddlcity.SelectedItem.ToString();
bal.City_Heading = txthead.Text;
imgupload.SaveAs(Server.MapPath("~/uploadimage/" + imgupload.FileName));
string image = "~/uploadimage/" + imgupload.FileName;
bal.City_Image = image;
int t = bal.BalOperation();
if (t > 0)
{
Response.Write("<script>alert('Insertted!!')</script>");
}
}
else
{
Response.Write("<script>alert('Pleae select File')</script>");
}
}
}