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 btnupdate_Click(object sender, EventArgs e) { transportermaster objtransporter = new transportermaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtransporter.transportermaster_SRNO = -1; objtransporter.transportermaster_TRANSPORTERNAME = txttransportername.Text.Trim().ToString(); objtransporter.transportermaster_TRANSPORTERCODE = txttransportercode.Text.Trim().ToString(); if (rdlocal.Checked == true) { objtransporter.transportermaster_TRANTYPE = "LOCAL"; objtransporter.transportermaster_TRANTYPECODE = 1; } else { objtransporter.transportermaster_TRANTYPE = "REMOTE"; objtransporter.transportermaster_TRANTYPECODE = 2; } objtransporter.transportermaster_MOBILENO = txtphone.Text.Trim().ToString(); objtransporter.transportermaster_FAX = txtfax.Text.Trim().ToString(); objtransporter.transportermaster_EMAILID = txtemail.Text.Trim().ToString(); objtransporter.transportermaster_PANNO = txtpanno.Text.Trim().ToString(); objtransporter.transportermaster_SERVICETAXNO = txtservicetaxno.Text.Trim().ToString(); objtransporter.transportermaster_ADDRESS = txtaddress.Text.Trim().ToString(); objtransporter.transportermaster_STATUS = General.Parse<int>(ddlstatus.SelectedValue.Trim().ToString()); string condition = "SRNO=" + ViewState["TRANSPORTERID"].ToString().Trim(); if (objtransporter.Insert(false, "transportermaster", condition)) { string sqltax = "SELECT SRNO,TAXNAME,TAXUNIT,TAXVALUE FROM TAXMASTER TM WHERE TM.STATUS=0 AND TM.TAXNAME='SERVICE TAX'"; Handler hdntax = new Handler(); DataTable dttax = hdntax.GetTable(sqltax); string sqlchecktax = "SELECT SRNO,STATUS FROM TAXATIONMASTER TM WHERE TAXPARTYTYPE='TRANSPORTER' AND TAXPARTYID="+ViewState["TRANSPORTERID"].ToString().Trim()+" AND TAXID="+dttax.Rows[0]["SRNO"].ToString(); Handler hdntax1 = new Handler(); DataTable dtchecktax = hdntax1.GetTable(sqlchecktax); if(dtchecktax.Rows.Count > 0 && dtchecktax.Rows[0][0].ToString() != string.Empty) { if (rdserviceapplicable.Checked == true && dtchecktax.Rows[0][1].ToString() == "1") { taxationmaster objtax = new taxationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtax.taxationmaster_SRNO = -1; objtax.taxationmaster_TAXPARTYID =-1; objtax.taxationmaster_TAXID =-1; objtax.taxationmaster_TAXVALUE = -1; objtax.taxationmaster_STATUS = 0; string taxcondition="SRNO="+dtchecktax.Rows[0][0].ToString(); if (objtax.Insert(false, "taxationmaster",taxcondition)) { } } else if (rdservicenotapplicable.Checked == true && dtchecktax.Rows[0][1].ToString() == "0") { taxationmaster objtax = new taxationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtax.taxationmaster_SRNO = -1; objtax.taxationmaster_TAXPARTYID =-1; objtax.taxationmaster_TAXID =-1; objtax.taxationmaster_TAXVALUE = -1; objtax.taxationmaster_STATUS =1; string taxcondition="SRNO="+dtchecktax.Rows[0][0].ToString(); if (objtax.Insert(false, "taxationmaster",taxcondition)) { } } } 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"); 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_EMAILID = email.Text.ToString().Trim(); objpersonal.personalmaster_PHONENO = phone.Text.ToString().Trim(); objpersonal.personalmaster_MOBILE = mobile.Text.ToString().Trim(); objpersonal.personalmaster_PERSONRELATIONID =-1; string taxcondition = "SRNO=" + ((DataTable)ViewState["personrecord"]).Rows[i]["SRNO"].ToString().Trim(); if (objpersonal.Insert(false, "personalmaster",taxcondition)) { } } 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_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["TRANSPORTERID"].ToString().Trim()); objpersonal.personalmaster_PERSONTYPE = "TRANSPORTER"; if (objpersonal.Insert(true, "personalmaster")) { } } } } MessageBox("Transporter Details Updated Successfully"); Response.Redirect("transporterlist.aspx?ID=1"); } }
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()); } } }
protected void btnsubmit_Click(object sender, EventArgs e) { Handler hdnpartycode=new Handler(); DataTable dtpartycode=hdnpartycode.GetTable("SELECT SRNO FROM PARTYMASTER PM WHERE PARTYCODE='"+txtpartycode.Text.Trim().ToString()+"'"); if (dtpartycode.Rows.Count == 0) { DataTable dtmax = new DataTable(); partymaster objpartymaster = new partymaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartymaster.partymaster_SRNO = -1; objpartymaster.partymaster_PARTYNAME = txtpartyname.Text.Trim().ToString(); objpartymaster.partymaster_PARTYCODE = txtpartycode.Text.Trim().ToString(); objpartymaster.partymaster_PARTYTYPE = ddlpartytype.SelectedItem.Text.ToString(); objpartymaster.partymaster_PARTYTYPECODE = General.Parse<int>(ddlpartytype.SelectedValue.ToString()); if (rdaddonyes.Checked == true) { objpartymaster.partymaster_PARTYADDON = 1; } else { objpartymaster.partymaster_PARTYADDON = 0; } objpartymaster.partymaster_PHONENO = txtphone.Text.Trim().ToString(); if (txtfax.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_FAX = txtfax.Text.Trim().ToString(); } if (txtemail.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_EMAIL = txtemail.Text.Trim().ToString(); } if (txtwebsite.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_WEBSITE = txtwebsite.Text.Trim().ToString(); } if (txtpanno.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_PANNO = txtpanno.Text.Trim().ToString(); } if (txtcstno.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_CSTNO = txtcstno.Text.Trim().ToString(); } if (txtvatno.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_VATNO = txtvatno.Text.Trim().ToString(); } if (txtservicetaxno.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_SERVICETAXNO = txtservicetaxno.Text.Trim().ToString(); } if (txtexciseno.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_EXCISENO = txtexciseno.Text.Trim().ToString(); } if (txtexciserange.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_EXCISERANGE = txtexciserange.Text.Trim().ToString(); } if (txtexcisedivision.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_EXCISEDIVISION = txtexcisedivision.Text.Trim().ToString(); } if (txtexcisecollectrate.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_EXCISECOLLECTRATE = txtexcisecollectrate.Text.Trim().ToString(); } if (objpartymaster.Insert(true, "partymaster")) { string sqlmax = "SELECT MAX(SRNO) AS SRNO FROM partymaster WHERE PARTYNAME='" + txtpartyname.Text.Trim().ToString() + "' AND PARTYCODE='" + txtpartycode.Text.Trim().ToString() + "' "; Handler hdnmax = new Handler(); dtmax = hdnmax.GetTable(sqlmax); if (dtmax.Rows.Count > 0) { personaltable objpersonal1 = new personaltable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal1.personaltable_RELATIONSHIPID = -1; objpersonal1.personaltable_FIRSTNAME = txtpartyname.Text.Trim().ToString(); objpersonal1.personaltable_BRANCHID = General.Parse<int>(Session["branchid"].ToString()); Handler branch = new Handler(); DataTable dtbranch = branch.GetTable("select BRANCHNAME from branchmaster where branchid=" + Session["branchid"].ToString()); objpersonal1.personaltable_BRANCHNAME = dtbranch.Rows[0][0].ToString().Trim(); if (objpersonal1.Insert(true, "personaltable")) { string sql = "SELECT MAX(PR.RELATIONSHIPID) AS RELATIONSHIPID FROM personaltable PR WHERE PR.BRANCHID=1 AND PR.FIRSTNAME='" + txtpartyname.Text.Trim().ToString() + "'"; Handler hdn = new Handler(); DataTable dt = hdn.GetTable(sql); personalrelation objpersonalrelation = new personalrelation(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonalrelation.personalrelation_SRNO = -1; objpersonalrelation.personalrelation_RELATIONSHIPID = General.Parse<int>(dt.Rows[0][0].ToString()); objpersonalrelation.personalrelation_ASSOSIATEDFEILD = "MAIN ACCOOUNT"; objpersonalrelation.personalrelation_ASSOSIATEDBRANCH = General.Parse<int>(Session["branchid"].ToString()); objpersonalrelation.personalrelation_GROUPID = 100; objpersonalrelation.personalrelation_STATUS = 0; if (objpersonalrelation.Insert(true, "personalrelation")) { } } partyaddressmaster objpartyaddressmaster = new partyaddressmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartyaddressmaster.partyaddressmaster_SRNO = -1; objpartyaddressmaster.partyaddressmaster_PARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objpartyaddressmaster.partyaddressmaster_ADDRESSTYPE = 1; objpartyaddressmaster.partyaddressmaster_ADDRESS = txtaddress.Text.Trim().ToString(); objpartyaddressmaster.partyaddressmaster_CITYID = General.Parse<int>(ddlcity.SelectedValue.ToString()); ; objpartyaddressmaster.partyaddressmaster_CITYNAME = ddlcity.SelectedItem.Text.Trim().ToString(); ; objpartyaddressmaster.partyaddressmaster_STATEID = General.Parse<int>(ddlstate.SelectedValue.ToString()); ; objpartyaddressmaster.partyaddressmaster_STATENAME = ddlstate.SelectedItem.Text.Trim().ToString(); ; objpartyaddressmaster.partyaddressmaster_PINCODE = txtpin.Text.Trim().ToString(); ; objpartyaddressmaster.partyaddressmaster_STATUS = 0; if (objpartyaddressmaster.Insert(true, "partyaddressmaster")) { } partyaddressmaster objpartyworkaddressmaster = new partyaddressmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartyworkaddressmaster.partyaddressmaster_SRNO = -1; objpartyworkaddressmaster.partyaddressmaster_PARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objpartyworkaddressmaster.partyaddressmaster_ADDRESSTYPE = 2; objpartyworkaddressmaster.partyaddressmaster_ADDRESS = txtworkaddress.Text.Trim().ToString(); objpartyworkaddressmaster.partyaddressmaster_CITYID = General.Parse<int>(ddlworkcity.SelectedValue.ToString()); ; objpartyworkaddressmaster.partyaddressmaster_CITYNAME = ddlworkcity.SelectedItem.Text.Trim().ToString(); ; objpartyworkaddressmaster.partyaddressmaster_STATEID = General.Parse<int>(ddlworkstate.SelectedValue.ToString()); ; objpartyworkaddressmaster.partyaddressmaster_STATENAME = ddlworkstate.SelectedItem.Text.Trim().ToString(); ; objpartyworkaddressmaster.partyaddressmaster_PINCODE = txtworkpin.Text.Trim().ToString(); ; objpartyworkaddressmaster.partyaddressmaster_STATUS = 0; if (objpartyworkaddressmaster.Insert(true, "partyaddressmaster")) { } 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 = "PARTY"; if (objpersonal.Insert(true, "personalmaster")) { } } } string sqltax = "SELECT SRNO AS TAXID,TAXNAME,TAXVALUE,TAXUNIT FROM taxmaster WHERE STATUS=0"; Handler hdntax = new Handler(); DataTable dttax = hdntax.GetTable(sqltax); for (int k = 0; k < dttax.Rows.Count; k++) { if (dttax.Rows[k]["TAXNAME"].ToString().Trim() == "VAT" && rdvat.Checked == true) { partytaxmaster objpartytax = new partytaxmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartytax.partytaxmaster_SRNO = -1; objpartytax.partytaxmaster_PARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objpartytax.partytaxmaster_TAXID = General.Parse<int>(dttax.Rows[k]["TAXID"].ToString()); objpartytax.partytaxmaster_TAXNAME = dttax.Rows[k]["TAXNAME"].ToString(); objpartytax.partytaxmaster_TAXVALUE = General.Parse<double>(dttax.Rows[k]["TAXVALUE"].ToString()); objpartytax.partytaxmaster_TAXUNIT = dttax.Rows[k]["TAXUNIT"].ToString(); if (objpartytax.Insert(true, "partytaxmaster")) { } } if (dttax.Rows[k]["TAXNAME"].ToString().Trim() == "CST" && rdexcise.Checked == true) { partytaxmaster objpartytax = new partytaxmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartytax.partytaxmaster_SRNO = -1; objpartytax.partytaxmaster_PARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objpartytax.partytaxmaster_TAXID = General.Parse<int>(dttax.Rows[k]["TAXID"].ToString()); objpartytax.partytaxmaster_TAXNAME = dttax.Rows[k]["TAXNAME"].ToString(); objpartytax.partytaxmaster_TAXVALUE = General.Parse<double>(dttax.Rows[k]["TAXVALUE"].ToString()); objpartytax.partytaxmaster_TAXUNIT = dttax.Rows[k]["TAXUNIT"].ToString(); if (objpartytax.Insert(true, "partytaxmaster")) { } } if (dttax.Rows[k]["TAXNAME"].ToString().Trim() == "SERVICE TAX" && rdserviceapplicable.Checked == true) { partytaxmaster objpartytax = new partytaxmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartytax.partytaxmaster_SRNO = -1; objpartytax.partytaxmaster_PARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objpartytax.partytaxmaster_TAXID = General.Parse<int>(dttax.Rows[k]["TAXID"].ToString()); objpartytax.partytaxmaster_TAXNAME = dttax.Rows[k]["TAXNAME"].ToString(); objpartytax.partytaxmaster_TAXVALUE = General.Parse<double>(dttax.Rows[k]["TAXVALUE"].ToString()); objpartytax.partytaxmaster_TAXUNIT = dttax.Rows[k]["TAXUNIT"].ToString(); if (objpartytax.Insert(true, "partytaxmaster")) { } } if (dttax.Rows[k]["TAXNAME"].ToString().Trim() == "EXCISE" && rdexciseapplicable.Checked == true) { partytaxmaster objpartytax = new partytaxmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartytax.partytaxmaster_SRNO = -1; objpartytax.partytaxmaster_PARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objpartytax.partytaxmaster_TAXID = General.Parse<int>(dttax.Rows[k]["TAXID"].ToString()); objpartytax.partytaxmaster_TAXNAME = dttax.Rows[k]["TAXNAME"].ToString(); objpartytax.partytaxmaster_TAXVALUE = General.Parse<double>(dttax.Rows[k]["TAXVALUE"].ToString()); objpartytax.partytaxmaster_TAXUNIT = dttax.Rows[k]["TAXUNIT"].ToString(); if (objpartytax.Insert(true, "partytaxmaster")) { } } } } Response.Redirect("partylist.aspx?ID=2"); } else { MessageBox("Party Code Already Present"); } } }
protected void btnupdate_Click(object sender, EventArgs e) { DataTable dtmax = new DataTable(); partymaster objpartymaster = new partymaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartymaster.partymaster_SRNO = -1; //objpartymaster.partymaster_PARTYNAME = txtpartyname.Text.Trim().ToString(); objpartymaster.partymaster_PARTYCODE = txtpartycode.Text.Trim().ToString(); objpartymaster.partymaster_PARTYTYPE = ddlpartytype.SelectedItem.Text.ToString(); objpartymaster.partymaster_PARTYTYPECODE = General.Parse<int>(ddlpartytype.SelectedValue.ToString()); if (rdaddonyes.Checked == true) { objpartymaster.partymaster_PARTYADDON = 1; } else { objpartymaster.partymaster_PARTYADDON = 0; } objpartymaster.partymaster_PHONENO = txtphone.Text.Trim().ToString(); if (txtfax.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_FAX = txtfax.Text.Trim().ToString(); } objpartymaster.partymaster_EMAIL = txtemail.Text.Trim().ToString(); if (txtwebsite.Text.Trim().ToString() != string.Empty) { objpartymaster.partymaster_WEBSITE = txtwebsite.Text.Trim().ToString(); } objpartymaster.partymaster_PANNO = txtpanno.Text.Trim().ToString(); objpartymaster.partymaster_CSTNO = txtcstno.Text.Trim().ToString(); objpartymaster.partymaster_VATNO = txtvatno.Text.Trim().ToString(); objpartymaster.partymaster_SERVICETAXNO = txtservicetaxno.Text.Trim().ToString(); objpartymaster.partymaster_EXCISENO = txtexciseno.Text.Trim().ToString(); objpartymaster.partymaster_EXCISERANGE = txtexciserange.Text.Trim().ToString(); objpartymaster.partymaster_EXCISEDIVISION = txtexcisedivision.Text.Trim().ToString(); objpartymaster.partymaster_EXCISECOLLECTRATE = txtexcisecollectrate.Text.Trim().ToString(); string condition = "SRNO=" + ViewState["PARTYID"].ToString().Trim(); if (objpartymaster.Insert(false, "partymaster", condition)) { { partyaddressmaster objpartyaddressmaster = new partyaddressmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartyaddressmaster.partyaddressmaster_SRNO = -1; objpartyaddressmaster.partyaddressmaster_PARTYID = -1; objpartyaddressmaster.partyaddressmaster_ADDRESSTYPE = -1; objpartyaddressmaster.partyaddressmaster_ADDRESS = txtaddress.Text.Trim().ToString(); objpartyaddressmaster.partyaddressmaster_CITYID = General.Parse<int>(ddlcity.SelectedValue.ToString()); ; objpartyaddressmaster.partyaddressmaster_CITYNAME = ddlcity.SelectedItem.Text.Trim().ToString(); ; objpartyaddressmaster.partyaddressmaster_STATEID = General.Parse<int>(ddlstate.SelectedValue.ToString()); ; objpartyaddressmaster.partyaddressmaster_STATENAME = ddlstate.SelectedItem.Text.Trim().ToString(); ; objpartyaddressmaster.partyaddressmaster_PINCODE = txtpin.Text.Trim().ToString(); ; objpartyaddressmaster.partyaddressmaster_STATUS = 0; string condition1 = "PARTYID=" + ViewState["PARTYID"].ToString().Trim() + " AND ADDRESSTYPE=1"; if (objpartyaddressmaster.Insert(false, "partyaddressmaster", condition1)) { } partyaddressmaster objpartyworkaddressmaster = new partyaddressmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartyworkaddressmaster.partyaddressmaster_SRNO = -1; objpartyworkaddressmaster.partyaddressmaster_PARTYID = -1; objpartyworkaddressmaster.partyaddressmaster_ADDRESSTYPE = -1; objpartyworkaddressmaster.partyaddressmaster_ADDRESS = txtworkaddress.Text.Trim().ToString(); objpartyworkaddressmaster.partyaddressmaster_CITYID = General.Parse<int>(ddlworkcity.SelectedValue.ToString()); ; objpartyworkaddressmaster.partyaddressmaster_CITYNAME = ddlworkcity.SelectedItem.Text.Trim().ToString(); ; objpartyworkaddressmaster.partyaddressmaster_STATEID = General.Parse<int>(ddlworkstate.SelectedValue.ToString()); ; objpartyworkaddressmaster.partyaddressmaster_STATENAME = ddlworkstate.SelectedItem.Text.Trim().ToString(); ; objpartyworkaddressmaster.partyaddressmaster_PINCODE = txtworkpin.Text.Trim().ToString(); ; objpartyworkaddressmaster.partyaddressmaster_STATUS = 0; string condition2 = "PARTYID=" + ViewState["PARTYID"].ToString().Trim() + " AND ADDRESSTYPE=2"; if (objpartyworkaddressmaster.Insert(false, "partyaddressmaster", condition2)) { } if (memberrepeater.Items.Count > 0) { int membercount = ((DataTable)ViewState["personaldata"]).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_EMAILID = email.Text.ToString().Trim(); objpersonal.personalmaster_PHONENO = phone.Text.ToString().Trim(); objpersonal.personalmaster_MOBILE = mobile.Text.ToString().Trim(); objpersonal.personalmaster_PERSONRELATIONID = -1; string taxcondition = "SRNO=" + ((DataTable)ViewState["personaldata"]).Rows[i]["SRNO"].ToString().Trim(); if (objpersonal.Insert(false, "personalmaster", taxcondition)) { } } 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_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["PARTYID"].ToString().Trim()); objpersonal.personalmaster_PERSONTYPE = "PARTY"; if (objpersonal.Insert(true, "personalmaster")) { } } } } string sqltax = "SELECT SRNO AS TAXID,TAXNAME,TAXVALUE,TAXUNIT FROM taxmaster WHERE STATUS=0"; Handler hdntax = new Handler(); DataTable dttax = hdntax.GetTable(sqltax); SqlConnection Connection = new SqlConnection("Data Source=50.28.62.129,1433;Network Library=DBMSSOCN;Initial Catalog=db_fuel;User ID=fuel;Password= lSa2@11h"); string qry = "delete from partytaxmaster where partyid=" + ViewState["PARTYID"].ToString(); Connection.Open(); SqlCommand com = new SqlCommand(qry, Connection); com.ExecuteNonQuery(); Connection.Close(); for (int k = 0; k < dttax.Rows.Count; k++) { if (dttax.Rows[k]["TAXNAME"].ToString().Trim() == "VAT" && rdvat.Checked == true) { partytaxmaster objpartytax = new partytaxmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartytax.partytaxmaster_SRNO = -1; objpartytax.partytaxmaster_PARTYID = General.Parse<int>(ViewState["PARTYID"].ToString()); objpartytax.partytaxmaster_TAXID = General.Parse<int>(dttax.Rows[k]["TAXID"].ToString()); objpartytax.partytaxmaster_TAXNAME = dttax.Rows[k]["TAXNAME"].ToString(); objpartytax.partytaxmaster_TAXVALUE = General.Parse<double>(dttax.Rows[k]["TAXVALUE"].ToString()); objpartytax.partytaxmaster_TAXUNIT = dttax.Rows[k]["TAXUNIT"].ToString(); if (objpartytax.Insert(true, "partytaxmaster")) { } } if (dttax.Rows[k]["TAXNAME"].ToString().Trim() == "CST" && rdexcise.Checked == true) { partytaxmaster objpartytax = new partytaxmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartytax.partytaxmaster_SRNO = -1; objpartytax.partytaxmaster_PARTYID = General.Parse<int>(ViewState["PARTYID"].ToString()); objpartytax.partytaxmaster_TAXID = General.Parse<int>(dttax.Rows[k]["TAXID"].ToString()); objpartytax.partytaxmaster_TAXNAME = dttax.Rows[k]["TAXNAME"].ToString(); objpartytax.partytaxmaster_TAXVALUE = General.Parse<double>(dttax.Rows[k]["TAXVALUE"].ToString()); objpartytax.partytaxmaster_TAXUNIT = dttax.Rows[k]["TAXUNIT"].ToString(); if (objpartytax.Insert(true, "partytaxmaster")) { } } if (dttax.Rows[k]["TAXNAME"].ToString().Trim() == "SERVICE TAX" && rdserviceapplicable.Checked == true) { partytaxmaster objpartytax = new partytaxmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartytax.partytaxmaster_SRNO = -1; objpartytax.partytaxmaster_PARTYID = General.Parse<int>(ViewState["PARTYID"].ToString()); objpartytax.partytaxmaster_TAXID = General.Parse<int>(dttax.Rows[k]["TAXID"].ToString()); objpartytax.partytaxmaster_TAXNAME = dttax.Rows[k]["TAXNAME"].ToString(); objpartytax.partytaxmaster_TAXVALUE = General.Parse<double>(dttax.Rows[k]["TAXVALUE"].ToString()); objpartytax.partytaxmaster_TAXUNIT = dttax.Rows[k]["TAXUNIT"].ToString(); if (objpartytax.Insert(true, "partytaxmaster")) { } } if (dttax.Rows[k]["TAXNAME"].ToString().Trim() == "EXCISE" && rdexciseapplicable.Checked == true) { partytaxmaster objpartytax = new partytaxmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpartytax.partytaxmaster_SRNO = -1; objpartytax.partytaxmaster_PARTYID = General.Parse<int>(ViewState["PARTYID"].ToString()); objpartytax.partytaxmaster_TAXID = General.Parse<int>(dttax.Rows[k]["TAXID"].ToString()); objpartytax.partytaxmaster_TAXNAME = dttax.Rows[k]["TAXNAME"].ToString(); objpartytax.partytaxmaster_TAXVALUE = General.Parse<double>(dttax.Rows[k]["TAXVALUE"].ToString()); objpartytax.partytaxmaster_TAXUNIT = dttax.Rows[k]["TAXUNIT"].ToString(); if (objpartytax.Insert(true, "partytaxmaster")) { } } } } } MessageBox("Party Updated Successfully"); Response.Redirect("partylist.aspx?id=1"); }
protected void btnsubmit_Click(object sender, EventArgs e) { string sqlcheck = "SELECT RTRIM(SRNO) AS TRANSPORTERNO FROM TRANSPORTERMASTER TM WHERE TRANSPORTERCODE='" + txttransportercode.Text.Trim().ToString() + "'"; Handler hdncheck = new Handler(); DataTable dtcheck = hdncheck.GetTable(sqlcheck); if (dtcheck.Rows.Count == 0) { transportermaster objtransporter = new transportermaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtransporter.transportermaster_SRNO = -1; objtransporter.transportermaster_TRANSPORTERNAME = txttransportername.Text.Trim().ToString(); objtransporter.transportermaster_TRANSPORTERCODE = txttransportercode.Text.Trim().ToString(); if (rdlocal.Checked == true) { objtransporter.transportermaster_TRANTYPE = "LOCAL"; objtransporter.transportermaster_TRANTYPECODE = 1; } else { objtransporter.transportermaster_TRANTYPE = "REMOTE"; objtransporter.transportermaster_TRANTYPECODE = 2; } objtransporter.transportermaster_MOBILENO = txtphone.Text.Trim().ToString(); objtransporter.transportermaster_FAX = txtfax.Text.Trim().ToString(); if (txtemail.Text.Trim().ToString() != string.Empty) { objtransporter.transportermaster_EMAILID = txtemail.Text.Trim().ToString(); } objtransporter.transportermaster_PANNO = txtpano.Text.Trim().ToString(); objtransporter.transportermaster_SERVICETAXNO = txtservicetaxno.Text.Trim().ToString(); objtransporter.transportermaster_ADDRESS = txtaddress.Text.Trim().ToString(); objtransporter.transportermaster_STATUS = 0; if (objtransporter.Insert(true, "transportermaster")) { string sqlmax = "SELECT MAX(SRNO) AS SRNO FROM TRANSPORTERMASTER TM WHERE STATUS=0 AND TRANSPORTERNAME='" + txttransportername.Text.Trim().ToString() + "' AND TRANSPORTERCODE='" + txttransportercode.Text.Trim().ToString() + "'"; Handler hdnmax = new Handler(); DataTable dtmax = hdnmax.GetTable(sqlmax); if (rdserviceapplicable.Checked == true) { string sqltax = "SELECT SRNO,TAXNAME,TAXUNIT,TAXVALUE FROM TAXMASTER TM WHERE TM.STATUS=0 AND TM.TAXNAME='SERVICE TAX'"; Handler hdntax = new Handler(); DataTable dttax = hdntax.GetTable(sqltax); taxationmaster objtax = new taxationmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objtax.taxationmaster_SRNO = -1; objtax.taxationmaster_TAXPARTYTYPE = "TRANSPORTER"; objtax.taxationmaster_TAXPARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objtax.taxationmaster_TAXID = General.Parse<int>(dttax.Rows[0]["SRNO"].ToString()); objtax.taxationmaster_TAXNAME = dttax.Rows[0]["TAXNAME"].ToString().Trim(); objtax.taxationmaster_TAXVALUE = General.Parse<double>(dttax.Rows[0]["TAXVALUE"].ToString().Trim()); objtax.taxationmaster_TAXUNIT = dttax.Rows[0]["TAXUNIT"].ToString().Trim(); objtax.taxationmaster_STATUS = 0; if (objtax.Insert(true, "taxationmaster")) { } } 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"); 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(); if (email.Text.ToString().Trim() != string.Empty) { 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 = "TRANSPORTER"; if (objpersonal.Insert(true, "personalmaster")) { } } } personaltable objpersonal1 = new personaltable(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal1.personaltable_RELATIONSHIPID = -1; objpersonal1.personaltable_FIRSTNAME = txttransportername.Text.Trim().ToString(); objpersonal1.personaltable_BRANCHID = General.Parse<int>(Session["branchid"].ToString()); Handler branch = new Handler(); DataTable dtbranch = branch.GetTable("select BRANCHNAME from branchmaster where branchid=" + Session["branchid"].ToString()); objpersonal1.personaltable_BRANCHNAME = dtbranch.Rows[0][0].ToString().Trim(); if (objpersonal1.Insert(true, "personaltable")) { string sql = "SELECT MAX(PR.RELATIONSHIPID) AS RELATIONSHIPID FROM personaltable PR WHERE PR.BRANCHID=1 AND PR.FIRSTNAME='" + txttransportername.Text.Trim().ToString() + "'"; Handler hdn = new Handler(); DataTable dt = hdn.GetTable(sql); personalrelation objpersonalrelation = new personalrelation(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonalrelation.personalrelation_SRNO = -1; objpersonalrelation.personalrelation_RELATIONSHIPID = General.Parse<int>(dt.Rows[0][0].ToString()); objpersonalrelation.personalrelation_ASSOSIATEDFEILD = "MAIN ACCOOUNT"; objpersonalrelation.personalrelation_ASSOSIATEDBRANCH = General.Parse<int>(Session["branchid"].ToString()); objpersonalrelation.personalrelation_GROUPID = 100; objpersonalrelation.personalrelation_STATUS = 0; if (objpersonalrelation.Insert(true, "personalrelation")) { } } MessageBox("Transporter Added Successfully"); Response.Redirect("transporterlist.aspx?ID=2"); //Response.Redirect("transporterdetails.aspx?ID=1&TRANSPORTERID=" + dtmax.Rows[0][0].ToString()); } } else { MessageBox("Transporter Code Already Exist"); } }
protected void btnsubmit_Click(object sender, EventArgs e) { inventorymaster objmaster = new inventorymaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objmaster.inventorymaster_SRNO = -1; objmaster.inventorymaster_CMPID = General.Parse<int>(Session["cmpid"].ToString()); objmaster.inventorymaster_COALID = General.Parse<int>(ddlcoaltype.SelectedValue.Trim().ToString()); objmaster.inventorymaster_COALTYPE = ddlcoaltype.SelectedItem.Text.Trim().ToString(); objmaster.inventorymaster_DATE = txtdate.Text.Trim().ToString(); objmaster.inventorymaster_DEPOTID = General.Parse<int>(ddldepot.SelectedValue.Trim().ToString()); objmaster.inventorymaster_DOID = -1; objmaster.inventorymaster_GRADEID = General.Parse<int>(ddlcoalgrade.SelectedValue.Trim().ToString()); objmaster.inventorymaster_GRADE = ddlcoalgrade.SelectedItem.Text.Trim().ToString(); objmaster.inventorymaster_QUANTITY = General.Parse<double>(txtquantity.Text.Trim().ToString()); objmaster.inventorymaster_TRNASACTIONTYPE = "OUTWARD"; objmaster.inventorymaster_TRANSPORTERID = General.Parse<int>(ddltransporter.SelectedValue.Trim().ToString()); objmaster.inventorymaster_VEHICLEID = General.Parse<int>(ddlvehicle.SelectedValue.Trim().ToString()); objmaster.inventorymaster_DESTINATION = txtdestination.Text.Trim(); objmaster.inventorymaster_TYPE = "DIRECTCUSTOMER"; objmaster.inventorymaster_STATUS = 0; objmaster.inventorymaster_PARTYID = -1; if (objmaster.Insert(true, "inventorymaster")) { string sqlmax = "SELECT MAX(SRNO) AS SRNO FROM INVENTORYMASTER IM WHERE CMPID=" + Session["cmpid"].ToString() + " AND COALID=" + ddlcoaltype.SelectedValue.Trim().ToString() + " AND GRADEID=" + ddlcoalgrade.SelectedValue.Trim().ToString() + " AND QUANTITY='" + txtquantity.Text.Trim().ToString() + "'"; Handler hdnmax = new Handler(); DataTable dtmax = hdnmax.GetTable(sqlmax); personalmaster objpersonal = new personalmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objpersonal.personalmaster_SRNO = -1; objpersonal.personalmaster_PERSONNAME = txtpersonname.Text.ToString().Trim(); objpersonal.personalmaster_DESIGNATION = ddldesignation.SelectedItem.Text.Trim().ToString(); objpersonal.personalmaster_EMAILID = txtemailid.Text.ToString().Trim(); objpersonal.personalmaster_MOBILE = txtpersonno.Text.ToString().Trim(); objpersonal.personalmaster_PERSONRELATIONID = General.Parse<int>(dtmax.Rows[0][0].ToString()); objpersonal.personalmaster_PERSONTYPE = "SALE"; if (objpersonal.Insert(true, "personalmaster")) { string sqlmax1 = "SELECT MAX(SRNO) AS SRNO FROM PERSONALMASTER GM WHERE PERSONTYPE='SALE' AND PERSONRELATIONID='" + dtmax.Rows[0][0].ToString() + "'"; Handler hdnmax1 = new Handler(); DataTable dtmax1 = hdnmax1.GetTable(sqlmax1); inventorymaster objmaster1 = new inventorymaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objmaster1.inventorymaster_SRNO = -1; objmaster1.inventorymaster_CMPID = -1; objmaster1.inventorymaster_COALID = -1; objmaster1.inventorymaster_DEPOTID = -1; objmaster1.inventorymaster_DOID = -1; objmaster1.inventorymaster_GRADEID = -1; objmaster1.inventorymaster_QUANTITY = -1; objmaster1.inventorymaster_TRANSPORTERID = -1; objmaster1.inventorymaster_VEHICLEID = -1; objmaster1.inventorymaster_STATUS = -1; objmaster1.inventorymaster_PARTYID = General.Parse<int>(dtmax.Rows[0][0].ToString().Trim()); string condition = "SRNO=" + dtmax.Rows[0][0].ToString(); if (objmaster1.Insert(false, "inventorymaster", condition)) { } } } ClearControls(); MessageBox("Sales Successfully"); }