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"); } }