protected void btnsubmit_Click(object sender, EventArgs e)
{
branchmaster objbranch = new branchmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objbranch.branchmaster_BRANCHID = -1;
objbranch.branchmaster_BRANCHNAME=txtbranchname.Text.Trim().ToString();
objbranch.branchmaster_CITYID = General.Parse<int>(ddlcity.SelectedValue.ToString());
objbranch.branchmaster_CITYNAME=ddlcity.SelectedItem.Text.ToString().Trim();
objbranch.branchmaster_STATEID = General.Parse<int>(ddlstate.SelectedValue.ToString());
objbranch.branchmaster_STATENAME = ddlstate.SelectedItem.Text.ToString().Trim();
objbranch.branchmaster_STATUS=0;
objbranch.branchmaster_ADDRESS=txtaddress.Text.Trim().ToString();
objbranch.branchmaster_CMPID = General.Parse<int>(Session["cmpid"].ToString());
if (objbranch.Insert(true, "branchmaster"))
{
Handler hd = new Handler();
int branchid= Convert.ToInt32( hd.GetTable("select MAX(branchid) from branchmaster").Rows[0][0]);
//call procedurre
SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand(
"sp_createbranchledger", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(
new SqlParameter("@branch_id", branchid));
SqlDataReader rdr = cmd.ExecuteReader();
Response.Redirect("branchlist.aspx?id=1");
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
branchmaster objbranch = new branchmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objbranch.branchmaster_BRANCHID = -1;
objbranch.branchmaster_CITYID = General.Parse<int>(ddlcity.SelectedValue.ToString());
objbranch.branchmaster_CITYNAME=ddlcity.SelectedItem.Text.ToString().Trim();
objbranch.branchmaster_STATEID = General.Parse<int>(ddlstate.SelectedValue.ToString());
objbranch.branchmaster_STATENAME = ddlstate.SelectedItem.Text.ToString().Trim();
objbranch.branchmaster_STATUS = General.Parse<int>(ddlstatus.SelectedValue.ToString());
objbranch.branchmaster_ADDRESS=txtaddress.Text.Trim().ToString();
objbranch.branchmaster_CMPID = -1;
string condition = "BRANCHID=" + ViewState["BRANCHID"].ToString().Trim();
if (objbranch.Insert(false, "branchmaster", condition))
{
Response.Redirect("branchlist.aspx?id=2");
}
}
