protected void btnupdate_Click(object sender, EventArgs e) { godownmaster objgodown = new godownmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objgodown.godownmaster_SRNO = -1; objgodown.godownmaster_GODOWNNAME = txtgodownname.Text.ToString().Trim(); objgodown.godownmaster_STATEID = General.Parse<int>(ddlstate.SelectedValue.ToString()); objgodown.godownmaster_STATENAME = ddlstate.SelectedItem.Text.Trim().ToString(); objgodown.godownmaster_CITYID = General.Parse<int>(ddlcity.SelectedValue.ToString()); objgodown.godownmaster_CITYNAME = ddlcity.SelectedItem.Text.Trim().ToString(); objgodown.godownmaster_PHONE = txtphone.Text.ToString().Trim(); objgodown.godownmaster_FAX = txtfax.Text.ToString().Trim(); objgodown.godownmaster_EMAIL = txtemail.Text.ToString().Trim(); objgodown.godownmaster_ADDRESS = txtaddress.Text.ToString().Trim(); objgodown.godownmaster_PIN = txtpin.Text.ToString().Trim(); objgodown.godownmaster_STATUS = General.Parse<int>(ddlstatus.SelectedValue.Trim().ToString()); string condition = "SRNO=" + ViewState["DEPOTID"].ToString().Trim(); if (objgodown.Insert(false, "godownmaster", condition)) { if (memberrepeater.Items.Count > 0) { int membercount = ((DataTable)ViewState["personrecord"]).Rows.Count; for (int i = 0; i < memberrepeater.Items.Count; i++) { TextBox name = (TextBox)memberrepeater.Items[i].FindControl("txtpersonname"); DropDownList department = (DropDownList)memberrepeater.Items[i].FindControl("ddldepartment"); DropDownList designation = (DropDownList)memberrepeater.Items[i].FindControl("ddldesignation"); TextBox phone = (TextBox)memberrepeater.Items[i].FindControl("txtperphone"); TextBox email = (TextBox)memberrepeater.Items[i].FindControl("txtperemailid"); TextBox mobile = (TextBox)memberrepeater.Items[i].FindControl("txtpermobile"); if (i < membercount) { personalmaster objpersonal = new personalmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal.personalmaster_SRNO = -1; objpersonal.personalmaster_PERSONNAME = name.Text.ToString().Trim(); objpersonal.personalmaster_DEPARTMENT = department.SelectedItem.Text.Trim().ToString(); objpersonal.personalmaster_DESIGNATION = designation.SelectedItem.Text.Trim().ToString(); objpersonal.personalmaster_EMAILID = email.Text.ToString().Trim(); objpersonal.personalmaster_PHONENO = phone.Text.ToString().Trim(); objpersonal.personalmaster_MOBILE = mobile.Text.ToString().Trim(); objpersonal.personalmaster_PERSONRELATIONID = -1; string condition1 = "SRNO=" + ViewState["DEPOTID"].ToString().Trim(); if (objpersonal.Insert(false, "personalmaster", condition1)) { } } else { personalmaster objpersonal = new personalmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal.personalmaster_SRNO = -1; objpersonal.personalmaster_PERSONNAME = name.Text.ToString().Trim(); objpersonal.personalmaster_DEPARTMENT = department.SelectedItem.Text.Trim().ToString(); objpersonal.personalmaster_DESIGNATION = designation.SelectedItem.Text.Trim().ToString(); objpersonal.personalmaster_EMAILID = email.Text.ToString().Trim(); objpersonal.personalmaster_PHONENO = phone.Text.ToString().Trim(); objpersonal.personalmaster_MOBILE = mobile.Text.ToString().Trim(); objpersonal.personalmaster_PERSONRELATIONID = General.Parse<int>(ViewState["DEPOTID"].ToString().Trim()); objpersonal.personalmaster_PERSONTYPE = "GODOWN"; if (objpersonal.Insert(true, "personalmaster")) { } } } Response.Redirect("godownlist.aspx"); } } }
protected void btnsubmit_Click(object sender, EventArgs e) { godownmaster objgodown = new godownmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objgodown.godownmaster_SRNO = -1; objgodown.godownmaster_GODOWNNAME = txtgodownname.Text.ToString().Trim(); objgodown.godownmaster_STATEID = General.Parse<int>(ddlstate.SelectedValue.ToString()); objgodown.godownmaster_STATENAME = ddlstate.SelectedItem.Text.Trim().ToString(); objgodown.godownmaster_CITYID = General.Parse<int>(ddlcity.SelectedValue.ToString()); objgodown.godownmaster_CITYNAME = ddlcity.SelectedItem.Text.Trim().ToString(); objgodown.godownmaster_PHONE = txtphone.Text.ToString().Trim(); objgodown.godownmaster_FAX = txtfax.Text.ToString().Trim(); objgodown.godownmaster_EMAIL = txtemail.Text.ToString().Trim(); objgodown.godownmaster_ADDRESS = txtaddress.Text.ToString().Trim(); objgodown.godownmaster_PIN = txtpin.Text.ToString().Trim(); objgodown.godownmaster_STATUS = 0; if (objgodown.Insert(true, "godownmaster")) { string sqlmax = "SELECT MAX(SRNO) AS SRNO FROM GODOWNMASTER GM WHERE STATUS=0 AND GODOWNNAME='" + txtgodownname.Text.ToString().Trim() + "' AND CITYNAME='" + ddlcity.SelectedItem.Text.ToString().Trim() + "'"; Handler hdnmax = new Handler(); DataTable dtmax = hdnmax.GetTable(sqlmax); if (dtmax.Rows.Count > 0 && memberrepeater.Items.Count > 0) { for (int i = 0; i < memberrepeater.Items.Count; i++) { TextBox name = (TextBox)memberrepeater.Items[i].FindControl("txtpersonname"); DropDownList department = (DropDownList)memberrepeater.Items[i].FindControl("ddldepartment"); DropDownList designation = (DropDownList)memberrepeater.Items[i].FindControl("ddldesignation"); TextBox phone = (TextBox)memberrepeater.Items[i].FindControl("txtperphone"); TextBox email = (TextBox)memberrepeater.Items[i].FindControl("txtperemailid"); TextBox mobile = (TextBox)memberrepeater.Items[i].FindControl("txtpermobile"); personalmaster objpersonal = new personalmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal.personalmaster_SRNO = -1; objpersonal.personalmaster_PERSONNAME = name.Text.ToString().Trim(); objpersonal.personalmaster_DEPARTMENT = department.SelectedItem.Text.Trim().ToString(); objpersonal.personalmaster_DESIGNATION = designation.SelectedItem.Text.Trim().ToString(); objpersonal.personalmaster_EMAILID = email.Text.ToString().Trim(); objpersonal.personalmaster_PHONENO = phone.Text.ToString().Trim(); objpersonal.personalmaster_MOBILE = mobile.Text.ToString().Trim(); objpersonal.personalmaster_PERSONRELATIONID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objpersonal.personalmaster_PERSONTYPE = "GODOWN"; if (objpersonal.Insert(true, "personalmaster")) { } } Response.Redirect("depotdetails.aspx?DEPOTID=" + dtmax.Rows[0][0].ToString().Trim()); } } }