public void ValidateDate() { if (hiddenfildYear.Value == "") { if (Session["FY"] != null) { strChetanaCompanyName = Session["ChetanaCompanyName"].ToString(); strFY = Session["FY"].ToString(); DataTable dt = Customer_cs.Idv_Chetana_Customer_BlackList(2, "", "", 0, 0, 0, Convert.ToInt32(strFY)).Tables[0]; if (dt.Rows.Count > 0) { hiddenfildYear.Value = dt.Rows[0][0].ToString(); } string year = hiddenfildYear.Value; MaskedEditValidator1.MinimumValue = "01/04/" + year; MaskedEditValidator1.MaximumValue = "31/03/" + (Convert.ToInt32(year) + 1).ToString(); MaskedEditValidator1.MinimumValueMessage = "Date should be greater than 01/04/" + year; MaskedEditValidator1.MaximumValueMessage = "Date should be less than 31/03/" + (Convert.ToInt32(year) + 1).ToString(); } else { Session.Clear(); } } }
public DataTable BindGvCustDetail(string CustCode) { DataTable dt = new DataTable(); dt = Customer_cs.Get_CustList("", CustCode); return(dt); }
protected void grdBankDetails_RowEditing(object sender, GridViewEditEventArgs e) { try { pnlBank.Visible = false; Panel1.Visible = true; btnsave.Visible = true; filter.Visible = false; txtbankCode.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblBnkCode")).Text; DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state"); DDLstate.DataBind(); DDLstate.Items.Insert(0, new ListItem("--Select State--", "0")); DDLstate.Enabled = true; // pnlBank.Visible = false; Panel1.Visible = true; lblBankId.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblbankID")).Text; txtbankName.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblBnkName")).Text; txtbDesc.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblbankdecp")).Text; txtcountry.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblcountry")).Text; DDLCity.SelectedValue = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblcity")).Text; DDLstate.SelectedValue = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblstate")).Text; DDLCity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString()); DDLCity.DataBind(); DDLCity.Items.Insert(0, new ListItem("--Select City--", "0")); DDLCity.Enabled = true; chekactive.Checked = ((CheckBox)grdBankDetails.Rows[e.NewEditIndex].FindControl("chkactive")).Checked; } catch { } }
protected void Page_Load(object sender, EventArgs e) { try { SetView(); if (!Page.IsPostBack) { grdCustomerMaster.DataSource = BindCustomerMasterDetail(); grdCustomerMaster.DataBind(); //MessageBox("coming1" + grdCustomerMaster.Rows.Count.ToString()); DataView dv = new DataView(BindCustomerMasterDetail().Table); Session["data"] = dv; //Bind_DDL_SDZone(); repAlfabets.DataSource = Customer_cs.GetAlphabets(); repAlfabets.DataBind(); pnlCustomerMaster.Visible = true; } else { pnlCustomerMaster.Visible = true; } } catch (Exception ex) { MessageBox(ex.ToString()); } }
protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e) { DDLCity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString()); DDLCity.DataBind(); DDLCity.Items.Insert(0, new ListItem("--Select City--", "0")); DDLCity.Enabled = true; }
protected void grdCustDetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { bool _objct = new CustomerToTransport().isDelete("customer", (((Label)grdCustDetails.Rows[e.RowIndex].FindControl("lblCustID")).Text)); if (_objct) { Customer_cs _objCM = new Customer_cs(); _objCM.CustID = Convert.ToInt32(((Label)grdCustDetails.Rows[e.RowIndex].FindControl("lblCustID")).Text); _objCM.CustCode = ((Label)grdCustDetails.Rows[e.RowIndex].FindControl("lblCustCode")).Text; _objCM.CustName = ((Label)grdCustDetails.Rows[e.RowIndex].FindControl("lblCustName")).Text; _objCM.IsActive = Convert.ToBoolean(false); _objCM.IsDeleted = Convert.ToBoolean(true); _objCM.IsDeleted1 = Convert.ToBoolean(true); try { _objCM.Update(); MessageBox("Your record is Deleted"); PnlDetails.Visible = true; PnlAdd.Visible = false; } catch { } } else { MessageBox("You Can not Delete This Customer"); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { DataView dv = new DataView(BindGvCustDetail().Table); Session["data"] = dv; grdCustDetails.DataSource = dv; grdCustDetails.DataBind(); DdlSection.Enabled = false; DdlSection.DataSource = SectionMaster.Get_SectionList(); DdlSection.DataBind(); repAlfabets.DataSource = Customer_cs.GetAlphabets(); repAlfabets.DataBind(); LblCustId.Text = "0"; fillzones(); TxtCustCode.Focus(); custRating(); getDDLdata(); getDDLarezo(); getDDLarea(); SetView(); //dv = (DataView)Session["data"]; ////string val = ((LinkButton)(sender)).Text; //dv.RowFilter = "CustName='A'"; //grdCustDetails.DataSource = dv; //grdCustDetails.DataBind(); //((LinkButton)(sender)).BackColor = System.Drawing.Color.Red; //((LinkButton)(sender)).ForeColor = System.Drawing.Color.White; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["ChetanaCompanyName"] != "" || Session["ChetanaCompanyName"] != null) { if (Session["FY"] != null) { strChetanaCompanyName = Session["ChetanaCompanyName"].ToString(); strFY = Session["FY"].ToString(); } } if (!Page.IsPostBack) { Session["data"] = null; //DataView dv = new DataView(BindGvBookDetail().Table); DataView dv = new DataView(BindGvBookDetail(strChetanaCompanyName).Table); Session["data"] = dv; grdBookDetails.DataSource = dv; grdBookDetails.DataBind(); repAlfabets.DataSource = Customer_cs.GetAlphabets(); repAlfabets.DataBind(); SetView(); //txtcode.Focus(); } else { } }
protected void btnSave_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = Customer_cs.Get_CustList("ActiveNonActive", strFY.ToString(), DDLSuperZone.SelectedValue.ToString()); ViewState["ActiveNonActive"] = dt; ShowDetails(dt); }
public void getdata(int a) { string fromdate = txtFromdate.Text.Split('/')[1] + "/" + txtFromdate.Text.Split('/')[0] + "/" + txtFromdate.Text.Split('/')[2]; string todate = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2]; string custCode = ""; ReportDocument crystalReport = new ReportDocument(); if (ddlZone.SelectedIndex != 0) { txtcustomer.Text = ""; lblCustName.Text = ""; custCode = "1"; } else { custCode = txtcustomer.Text; } DataSet dt = new DataSet(); if (a == 1 || Session["tstlData"] == null) { dt = Customer_cs.Get_TStyle_Report(custCode, Convert.ToInt32(ddlZone.SelectedValue), Convert.ToInt32(strFY), "parent", Convert.ToDateTime(fromdate), Convert.ToDateTime(todate)); Session["tstlData"] = dt; } else { dt = (DataSet)Session["tstlData"]; } crystalReport.Load(Server.MapPath("Report/TStyleReport.rpt")); crystalReport.SetDataSource(dt.Tables[0]); crystalReport.OpenSubreport("test").SetDataSource(dt.Tables[1]); crystalReport.OpenSubreport("tstlCr").SetDataSource(dt.Tables[2]); crystalReport.OpenSubreport("monthlysummery").SetDataSource(dt.Tables[3]); if (dt.Tables[0].Rows.Count > 0) { crtcustomer.ReportSource = crystalReport; } else { if (a == 1) { MessageBox("No Data Found!!!"); } } if (txtcustomer.Enabled == true) { txtcustomer.Focus(); } else { ddlZone.Focus(); } }
public DataView BindGvCustDetail() { DataTable dt = new DataTable(); dt = Customer_cs.Get_CustList(); DataView dv = new DataView(dt); return(dv); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { lblBankId.Visible = false; Panel1.Visible = true; BindGvBankDetails(); DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state"); DDLstate.DataBind(); DDLstate.Items.Insert(0, new ListItem("--Select State--", "0")); SetView(); } }
protected void btnget_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); if (rdbselect.SelectedValue == "Customer") { dt = Customer_cs.Get_CustListReport("SuperZone", DDLCC.SelectedValue.ToString(), DDLSuperZone.SelectedValue.ToString(), ddlZone.SelectedValue.ToString()); } else { dt = Customer_cs.Get_CustList("Supplier", ddlSupplier.SelectedValue.ToString()); } ViewState["Data"] = dt; BindData(dt); }
public DataView BindCustomerMasterDetail() { try { DataTable dt = new DataTable(); dt = Customer_cs.Get_CustList("ExportCustomer", ""); DataView dv = new DataView(dt); return(dv); } catch (Exception ex) { DataView dv = new DataView(); return(dv); } }
protected void Page_Load(object sender, EventArgs e) { SetView(); if (!Page.IsPostBack) { grdSuperZoneDetails.DataSource = BindGvSuperZoneDetail(); grdSuperZoneDetails.DataBind(); DataView dv = new DataView(BindGvSuperZoneDetail().Table); Session["data"] = dv; repAlfabets.DataSource = Customer_cs.GetAlphabets(); repAlfabets.DataBind(); } else { // pnlSuperZone.Visible = true; } }
protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e) { if (DDLstate.SelectedValue == "0") { DDLcity.Items.Clear(); //rajnish DDLcity.Items.Insert(0, new ListItem("--Select City--", "0")); //rajnish } else { DDLcity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString()); DDLcity.DataBind(); DDLcity.Items.Insert(0, new ListItem("--Select City--", "0")); //DDLcity.Items.Insert(0, new ListItem("--Select City--", "0")); DDLcity.Enabled = true; DDLcity.Focus(); } }
public void fillReport(int ISPRINT) { if (txtRs.Text.Trim() == "") { txtRs.Text = "0"; } DataTable dt = new DataTable(); string date = ""; if (ISPRINT == 1) { if (txtcustomer.Text != "") { if (txttoDate.Text != "") { date = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2]; Session["DATAREP"] = Customer_cs.Idv_Chetana_Customer_BlackList(0, "_C$" + txtcustomer.Text, date, Convert.ToDecimal(txtRs.Text.Trim()), Convert.ToInt32(HidFY.Value), 0, 0).Tables[0]; } } else { if (txttoDate.Text != "") { date = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2]; Session["DATAREP"] = Customer_cs.Idv_Chetana_Customer_BlackList(0, "_Z$" + txtcustomer.Text, date, Convert.ToDecimal(txtRs.Text.Trim()), Convert.ToInt32(HidFY.Value), 0, Convert.ToInt32(ddlZone.SelectedValue.Trim())).Tables[0]; } } } if (Session["DATAREP"] != null) { dt = (DataTable)Session["DATAREP"]; } if (dt.Rows.Count > 0) { fillReport(); } else { lblMessage.Visible = true; } if (ISPRINT == 1) { //crystalReport.PrintToPrinter(0, false, 0, 0); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { LblEmpID.Visible = false; DdlRole.DataSource = Rolemaster.Get_RoleMaster(); DdlRole.DataBind(); fillQualification(); fillDesignation(); PnlLoginDetails.Visible = false; grdEmpDetails.DataSource = BindGvEmpDetail(); grdEmpDetails.DataBind(); // // DDLsuperzone.DataSource = SuperZone.GetSuperzonemaster(); // DDLsuperzone.DataBind(); DDLSDZone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(0, "SDZone"); DDLSDZone.DataBind(); DDLSDZone.Items.Insert(0, new ListItem("All", "0")); DDLsuperzone.Items.Insert(0, new ListItem("All", "0")); DDLzone.Items.Insert(0, new ListItem("All", "0")); DDLareazone.Items.Insert(0, new ListItem("All", "0")); // DDLarea.Items.Insert(0, new ListItem("All", "0")); // DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state"); DDLstate.DataBind(); DDLstate.Items.Insert(0, new ListItem("--Select State--", "0")); DDLcity.Items.Insert(0, new ListItem("--Select City--", "0")); SetView(); // txtjoin.Text = DateTime.Now.ToString("dd/MM/yyyy"); txtResign.Text = "30/01/2050"; EmpId(); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (ConfigurationManager.AppSettings["access"].ToString() != ConfigurationManager.AppSettings["accessok"].ToString()) { string page = Request.Url.Segments[Request.Url.Segments.Length - 1].ToString(); if (Session["Role"] != null) { if (!Other.Get_UserAccess(page, Session["Role"].ToString())) { Response.Redirect("dashboard.aspx"); } } } EmpCode = Convert.ToString(Session["UserName"]); DataSet ds = new DataSet(); ds = Customer_cs.GetSchool_Names(EmpCode); DdlCustomer.DataSource = ds; DdlCustomer.DataBind(); DdlCustomer.Items.Insert(0, new ListItem("-Select-", "0")); }
public DataSet getBlackListedCustomer(int showdata, int view) { DataSet ds = new DataSet(); if (txtRs.Text == "") { txtRs.Text = "0"; } try { string date = ""; if (view != 1) { date = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2]; } ds = Customer_cs.Idv_Chetana_Customer_BlackList(view, "", date, Convert.ToDecimal(txtRs.Text.Trim()), 1, IsShowData, 0); lblTotalOS.Text = "Total Outstanding : " + ds.Tables[1].Rows[0][0].ToString(); } catch (Exception ex) { return(ds = null); } return(ds); }
protected void grdACC_RowEditing(object sender, GridViewEditEventArgs e) { try { int CustId; string CustCode = ""; decimal NETBILLAMT = 0; decimal NETCNAMT = 0; decimal NETAMT = 0; decimal NETADDDIS = 0; decimal GROSSBILLAMT = 0; decimal GROSSCNAMT = 0; decimal GROSSNETAMT = 0; decimal GROSSADDDIS = 0; decimal Amount = 0; string Details = ""; int DACId; Customer_cs objDAC = new Customer_cs(); for (int i = 0; i <= grdACC.Rows.Count - 1; i++) { System.Web.UI.WebControls.CheckBox cb = (System.Web.UI.WebControls.CheckBox)grdACC.Rows[i].Cells[0].Controls[1]; if (cb.Checked == true) { try { System.Web.UI.WebControls.Label WbCustCode = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[1].Controls[1]; CustCode = WbCustCode.Text.ToString(); System.Web.UI.WebControls.Label Wb1 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[11].Controls[1]; NETBILLAMT = Convert.ToDecimal(Wb1.Text.ToString()); // try //{ if (NETBILLAMT > 0) { PnlAddDAC.Visible = true; System.Web.UI.WebControls.Label Wb2 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[12].Controls[1]; NETCNAMT = Convert.ToDecimal(Wb2.Text.ToString()); System.Web.UI.WebControls.Label Wb3 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[13].Controls[1]; NETAMT = Convert.ToDecimal(Wb3.Text.ToString()); System.Web.UI.WebControls.Label Wb4 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[14].Controls[1]; NETADDDIS = Convert.ToDecimal(Wb4.Text.ToString()); System.Web.UI.WebControls.Label Wb5 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[15].Controls[1]; GROSSBILLAMT = Convert.ToDecimal(Wb5.Text.ToString()); System.Web.UI.WebControls.Label Wb6 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[16].Controls[1]; GROSSCNAMT = Convert.ToDecimal(Wb6.Text.ToString()); System.Web.UI.WebControls.Label Wb7 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[17].Controls[1]; GROSSNETAMT = Convert.ToDecimal(Wb7.Text.ToString()); System.Web.UI.WebControls.Label Wb8 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[18].Controls[1]; GROSSADDDIS = Convert.ToDecimal(Wb8.Text.ToString()); System.Web.UI.WebControls.Label Wb9 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[19].Controls[1]; System.Web.UI.WebControls.Label Wb10 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[20].Controls[1]; txtAmount.Text = ((Label)grdACC.Rows[e.NewEditIndex].FindControl("lblDACAmount")).Text; // txtDetails.Text = ((Label)grdACC.Rows[e.NewEditIndex].FindControl("lblDetails")).Text; } else { MessageBox("Bill Amount Should not be Zero"); } //} // catch // { // MessageBox("Bill Amount Should not be Zero"); // } } catch (Exception ex) { MessageBox(ex.Message); } } } } catch { } }
protected void Save_Click(object sender, EventArgs e) { try { int CustId; string CustCode = ""; decimal NETBILLAMT = 0; decimal NETCNAMT = 0; decimal NETAMT = 0; decimal NETADDDIS = 0; decimal GROSSBILLAMT = 0; decimal GROSSCNAMT = 0; decimal GROSSNETAMT = 0; decimal GROSSADDDIS = 0; decimal Amount = 0; string Details = ""; int DACId; Customer_cs objDAC = new Customer_cs(); for (int i = 0; i <= grdACC.Rows.Count - 1; i++) { System.Web.UI.WebControls.CheckBox cb = (System.Web.UI.WebControls.CheckBox)grdACC.Rows[i].Cells[0].Controls[1]; if (cb.Checked == true) { try { System.Web.UI.WebControls.Label WbCustCode = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[1].Controls[1]; CustCode = WbCustCode.Text.ToString(); System.Web.UI.WebControls.Label Wb1 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[11].Controls[1]; NETBILLAMT = Convert.ToDecimal(Wb1.Text.ToString()); try { if (NETBILLAMT > 0) { System.Web.UI.WebControls.Label Wb2 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[12].Controls[1]; NETCNAMT = Convert.ToDecimal(Wb2.Text.ToString()); System.Web.UI.WebControls.Label Wb3 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[13].Controls[1]; NETAMT = Convert.ToDecimal(Wb3.Text.ToString()); System.Web.UI.WebControls.Label Wb4 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[14].Controls[1]; NETADDDIS = Convert.ToDecimal(Wb4.Text.ToString()); System.Web.UI.WebControls.Label Wb5 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[15].Controls[1]; GROSSBILLAMT = Convert.ToDecimal(Wb5.Text.ToString()); System.Web.UI.WebControls.Label Wb6 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[16].Controls[1]; GROSSCNAMT = Convert.ToDecimal(Wb6.Text.ToString()); System.Web.UI.WebControls.Label Wb7 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[17].Controls[1]; GROSSNETAMT = Convert.ToDecimal(Wb7.Text.ToString()); System.Web.UI.WebControls.Label Wb8 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[18].Controls[1]; GROSSADDDIS = Convert.ToDecimal(Wb8.Text.ToString()); System.Web.UI.WebControls.Label Wb9 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[19].Controls[1]; System.Web.UI.WebControls.Label Wb10 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[20].Controls[1]; objDAC.Idv_Chetana_Rep_Customer_SaveDisburseAdditionalCommission(CustCode, NETBILLAMT, NETCNAMT, NETAMT, NETADDDIS, GROSSBILLAMT, GROSSCNAMT, GROSSNETAMT, GROSSADDDIS, Convert.ToDecimal(txtAmount.Text), txtDetails.Text.ToString(), Convert.ToInt32(strFY), Convert.ToString(Session["UserName"]), out DACId); MessageBox("Record saved successfully"); PnlAddDAC.Visible = false; ShowDetails(); } else { MessageBox("Bill Amount Should not be Zero"); } } catch (Exception ex) { MessageBox(ex.Message); } } catch (Exception ex) { MessageBox(ex.Message); } } } } catch { } }
protected void btnSave_Click(object sender, EventArgs e) { // DdlSection.Text = "----"; try { //string Area = TxtArea.Text.Split(':')[0].Trim(); Customer_cs _objCust = new Customer_cs(); _objCust.CustID = Convert.ToInt32(LblCustId.Text); _objCust.CustCode = TxtCustCode.Text.Trim(); _objCust.ShortForm = TxtShortForm.Text.Trim(); _objCust.FamilyCode = TxtFamilyCode.Text.Trim(); _objCust.Address = TxtAddress.Text.Trim(); _objCust.Zip = TxtZip.Text.Trim(); _objCust.Phone1 = TxtPhone1.Text.Trim(); _objCust.Phone2 = TxtPhone2.Text.Trim(); _objCust.EmailID = TxtEmailID.Text.Trim(); _objCust.CUSTOMERTYPE = TxtCustomerType.Text.Trim(); _objCust.IsDeleted = false; _objCust.IsActive = true; _objCust.CreatedBy = Convert.ToString(Session["UserName"]); _objCust.CustName = TxtCustName.Text.Trim(); _objCust.ZoneID = Convert.ToInt32(DDLzone.SelectedValue); _objCust.SuperZoneID = Convert.ToInt32(DDLsuperzone.SelectedValue); _objCust.AreaZoneID = Convert.ToInt32(DDLareazone.SelectedValue); _objCust.AreaID = Convert.ToInt32(DDLarea.SelectedValue); _objCust.DMID = Convert.ToInt32(ddLStates.SelectedValue); _objCust.City = Convert.ToInt32(ddlCity.SelectedValue); _objCust.CustRating = Convert.ToInt32(DdlCustRating.SelectedValue); string TxtPrincipalDOB1 = ""; string TxtKeyPersonDOB1 = ""; try { TxtPrincipalDOB1 = TxtPrincipalDOB.Text.Split('/')[1] + "/" + TxtPrincipalDOB.Text.Split('/')[0] + "/" + TxtPrincipalDOB.Text.Split('/')[2]; TxtKeyPersonDOB1 = TxtKeyPersonDOB.Text.Split('/')[1] + "/" + TxtKeyPersonDOB.Text.Split('/')[0] + "/" + TxtKeyPersonDOB.Text.Split('/')[2]; } catch { } if (LblCustId.Text == "0") { _objCust.Save(out CID); // TxtCustId.Text = Convert.ToString(CID); string Medium = TxtMedium.Text.Split(':')[0].Trim(); CustomerDetails _objCustDetails = new CustomerDetails(); _objCustDetails.CustId = CID; _objCustDetails.CustCode = TxtCustCode.Text.Trim(); _objCustDetails.CreditLimit = TxtCreditLimit.Text.Trim(); // _objCustDetails.Creditdays = txtcreditdays.Text.Trim(); _objCustDetails.BlackList = ChkBlacklist.Checked; _objCustDetails.CreatedBy = Convert.ToString(Session["UserName"]); _objCustDetails.PrincipalName = TxtPrincipalName.Text.Trim(); _objCustDetails.PrincipalMobile = TxtPrincipalMobile.Text.Trim(); _objCustDetails.PrincipalDOB = TxtPrincipalDOB1; _objCustDetails.KeyPersonName = TxtKeyPersonName.Text.Trim(); _objCustDetails.KeyPersonMobile = TxtKeyPersonMobile.Text.Trim(); _objCustDetails.KeyPersonDOB = TxtKeyPersonDOB.Text.Trim(); _objCustDetails.AdditinalDis = TxtAdditinalDis.Text.Trim(); _objCustDetails.VIPRemark = TxtVIPRemark.Text.Trim(); _objCustDetails.SectionID = 0; //_objCustDetails.SectionID = Convert.ToInt32(DdlSection.SelectedValue); _objCustDetails.Medium = Medium; _objCustDetails.Save(); grdCustDetails.Visible = true; PnlDetails.Visible = true; MessageBox("Record saved successfully"); if (btnSave.Text == "Update") { PnlDetails.Visible = true; PnlAdd.Visible = false; btnSave.Visible = false; filter.Visible = true; } else { PnlDetails.Visible = false; PnlAdd.Visible = true; btnSave.Visible = true; } } else { string Medium = TxtMedium.Text.Split(':')[0].Trim(); _objCust.CustID = Convert.ToInt32(LblCustId.Text); _objCust.CustDetailID = Convert.ToInt32(LblCustDetailID1.Text); if (TxtCreditLimit.Text == "") { TxtCreditLimit.Text = "0"; } _objCust.CreditLimit = Convert.ToInt32(TxtCreditLimit.Text.Trim()); _objCust.CreditDays = txtcreditdays.Text.Trim(); _objCust.BlackList = ChkBlacklist.Checked; _objCust.IsDeleted1 = false; _objCust.PrincipalName = TxtPrincipalName.Text.Trim(); _objCust.PrincipalMobile = TxtPrincipalMobile.Text.Trim(); _objCust.PrincipalDOB = TxtPrincipalDOB.Text.Trim(); _objCust.KeyPersonName = TxtKeyPersonName.Text.Trim(); _objCust.KeyPersonMobile = TxtKeyPersonMobile.Text.Trim(); _objCust.KeyPersonDOB = TxtKeyPersonDOB.Text.Trim(); _objCust.AdditinalDis = TxtAdditinalDis.Text.Trim(); _objCust.VIPRemark = TxtVIPRemark.Text.Trim(); //_objCust.SectionID = Convert.ToInt32(DdlSection.SelectedValue); _objCust.SectionID = 0; _objCust.Medium = Medium; _objCust.Update(); DataView dv1 = new DataView(BindGvCustDetail().Table); Session["data"] = dv1; grdCustDetails.DataSource = dv1; grdCustDetails.DataBind(); MessageBox("Record updated successfully"); TxtCustCode.Enabled = true; if (btnSave.Text.ToLower() == "update") { PnlDetails.Visible = true; PnlAdd.Visible = false; btnSave.Visible = false; filter.Visible = true; } else { PnlDetails.Visible = false; PnlAdd.Visible = true; btnSave.Visible = true; } } TxtCustCode.Text = ""; TxtShortForm.Text = ""; TxtFamilyCode.Text = ""; TxtAddress.Text = ""; TxtZip.Text = ""; TxtPhone1.Text = ""; TxtPhone2.Text = ""; TxtEmailID.Text = ""; TxtCustName.Text = ""; TxtCreditLimit.Text = ""; TxtPrincipalName.Text = ""; TxtPrincipalMobile.Text = ""; TxtPrincipalDOB.Text = ""; TxtKeyPersonName.Text = ""; TxtKeyPersonMobile.Text = ""; TxtKeyPersonDOB.Text = ""; TxtAdditinalDis.Text = ""; TxtVIPRemark.Text = ""; TxtMedium.Text = ""; TxtCustomerType.Text = ""; DDLzone.SelectedValue = "0"; DDLareazone.SelectedValue = "0"; DDLarea.SelectedValue = "0"; ddLStates.SelectedValue = "0"; DDLsuperzone.SelectedValue = "0"; DdlCustRating.SelectedValue = "0"; } catch (SqlException ex) { Response.Write(ex.Message.ToString()); } catch (Exception ex1) { Response.Write(ex1.Message.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { if (ChkBlacklist.Checked == true) { lblblkremark.Visible = true; LblblkDate.Visible = true; TxtblkRemark.Visible = true; TxtblkDate.Visible = true; } else { lblblkremark.Visible = false; LblblkDate.Visible = false; TxtblkRemark.Visible = false; TxtblkDate.Visible = false; } if (Session["ChetanaCompanyName"] != "" || Session["ChetanaCompanyName"] != null) { if (Session["FY"] != "" || Session["FY"] != null) { strChetanaCompanyName = Session["ChetanaCompanyName"].ToString(); strFY = Session["FY"].ToString(); } else { Session.Clear(); } } if (!Page.IsPostBack) { btnAddAccess.Enabled = false; txtBookType.Enabled = false; txtFromQty.Enabled = false; txtToQty.Enabled = false; txtDiscount.Enabled = false; DdlSection.Enabled = false; DdlSection.DataSource = SectionMaster.Get_SectionList(); DdlSection.DataBind(); repAlfabets.DataSource = Customer_cs.GetAlphabets(); repAlfabets.DataBind(); LblCustId.Text = "0"; fillzones(); custRating(); getDDLdata(); getDDLarezo(); getDDLarea(); GetSBUCode(); Session["saved"] = null; Session["TempDataTable"] = null; Session["TempAssorted"] = null; checkAction.Checked = true; SetView(); TxtCustCode.Focus(); if (ChkBlacklist.Checked == true) { lblblkremark.Visible = true; LblblkDate.Visible = true; TxtblkRemark.Visible = true; TxtblkDate.Visible = true; } else { lblblkremark.Visible = false; LblblkDate.Visible = false; TxtblkRemark.Visible = false; TxtblkDate.Visible = false; } } }
protected void grdEmpDetails_RowEditing(object sender, GridViewEditEventArgs e) { try { pnlEmployeeDetails.Visible = false; Panel1.Visible = true; btnSavE.Visible = false; filter.Visible = false; txtempCode.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblEmpcode")).Text; //DDLsuperzone.DataSource = SuperZone.GetSuperzonemaster(); //DDLsuperzone.DataBind(); // DDLsuperzone.Items.Insert(0, new ListItem("--Select SuperZone--", "0")); // DDLSDZone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(0, "SDZone"); DDLSDZone.DataBind(); DDLSDZone.Items.Insert(0, new ListItem("All", "0")); DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state"); DDLstate.DataBind(); DDLstate.Items.Insert(0, new ListItem("--Select State--", "0")); // pnlEmployeeDetails.Visible = false; Panel1.Visible = true; LblEmpID.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblEID")).Text; txtFname.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblFName")).Text; txtMname.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblMiddleName")).Text; txtLname.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblLastName")).Text; Rdogender.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblGender")).Text; txtDob.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblDOB")).Text; // txtphne1.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblPhone1")).Text; txtphne2.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblPhone2")).Text; txtzipCode.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblZip")).Text; txtEmail.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblEmailID")).Text; txtAdd.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblAddress")).Text; /// DDLSDZone.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblSDZoneId")).Text; DDLsuperzone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLSDZone.SelectedValue.ToString()), "SuperZone1"); DDLsuperzone.DataBind(); DDLsuperzone.Items.Insert(0, new ListItem("All", "0")); /// // DDLsuperzone.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblSuperZoneID")).Text; DDLzone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLsuperzone.SelectedValue.ToString()), "Zone"); DDLzone.DataBind(); DDLzone.Items.Insert(0, new ListItem("All", "0")); DDLzone.Enabled = true; //// DDLzone.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblZoneID")).Text; DDLareazone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLzone.SelectedValue.ToString()), "AreaZone"); DDLareazone.DataBind(); DDLareazone.Items.Insert(0, new ListItem("All", "0")); DDLareazone.Enabled = true; //// DDLareazone.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblAreaZoneID")).Text; Chkarea.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLareazone.SelectedValue.ToString()), "Area"); Chkarea.DataBind(); Chkarea.Items.Insert(0, new ListItem("All", "0")); Chkarea.Enabled = true; selectArea(Convert.ToInt32(LblEmpID.Text.Trim())); //Chkarea.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblAreaID")).Text; txtDepCode.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblDeptId")).Text; string JoinDate = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblJoinDate")).Text; string ResignationDate = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblResignationDate")).Text; Chekacv.Checked = ((CheckBox)grdEmpDetails.Rows[e.NewEditIndex].FindControl("chkisActive")).Checked; txtjoin.Text = JoinDate; txtResign.Text = ResignationDate; DDLstate.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblState")).Text; DDLcity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString()); DDLcity.DataBind(); DDLcity.Items.Insert(0, new ListItem("--Select City--", "0")); DDLcity.Enabled = true; DDLcity.Focus(); // DDLcity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString()); // DDLcity.DataBind(); // DDLcity.Items.Insert(0, new ListItem("--Select City--", "0")); // DDLcity.Enabled = true; DDLcity.SelectedItem.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblCity")).Text; imgprof.ImageUrl = "../Images/profileimg/" + ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblphoto")).Text; lblImage.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblphoto")).Text; ddlqulification.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblQualification")).Text; fillQualification(); DDlDesignation.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblDesignation")).Text; fillDesignation(); } catch { } }