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