protected void GvCustomer_Select(object sender, Obout.Grid.GridRecordEventArgs e) { try { CustomProfile profile = CustomProfile.GetProfile(); iCustomerClient ServiceAccountMaster = new iCustomerClient(); tCustomerHead objCutomerHead = new tCustomerHead(); clr(); Hashtable selectedrec = (Hashtable)GvCustomer.SelectedRecords[0]; HdnAccountId.Value = selectedrec["ID"].ToString(); GetVendorDetailByID(); GetVendorOpeningBal(); GetVendorRatecard(); Session.Add("PORRequestID", "Company"); FillUserControl(Convert.ToInt64(HdnAccountId.Value)); ActiveTab("Edit"); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Account Master", "GvCustomer_Select"); } finally { } }
public void bindDropdown() { try { CustomProfile profile = CustomProfile.GetProfile(); iCustomerClient ServiceAccountMaster = new iCustomerClient(); Ddl_CompanyType.DataSource = ServiceAccountMaster.GetCompanyType(profile.DBConnection._constr); Ddl_CompanyType.DataBind(); ListItem lst1 = new ListItem(); lst1.Text = "-Select-"; lst1.Value = "0"; Ddl_CompanyType.Items.Insert(0, lst1); Ddl_Sector.DataSource = ServiceAccountMaster.GetLeadSector(profile.DBConnection._constr); Ddl_Sector.DataBind(); Ddl_Sector.Items.Insert(0, lst1); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Account Master", "bindDropdown"); } finally { } }
protected void GetVendorOpeningBal() { CustomProfile profile = CustomProfile.GetProfile(); iCustomerClient ServiceAccountMaster = new iCustomerClient(); try { tOpeningBalance objTOpeningBal = new tOpeningBalance(); objTOpeningBal = ServiceAccountMaster.GetTOpeningBalanceDtls(Convert.ToInt64(HdnAccountId.Value), "Client", profile.DBConnection._constr); txt_OpeningBalance.Text = objTOpeningBal.OpeningBalance.ToString(); if (objTOpeningBal.FinancialYear != null) { ddl_FinancialYr.SelectedValue = objTOpeningBal.FinancialYear.ToString(); } if (objTOpeningBal.DrCr != null) { ddl_DrCr.SelectedValue = objTOpeningBal.DrCr.ToString(); } HdnOpeningBalId.Value = objTOpeningBal.ID.ToString(); } catch (Exception ex) { Login.Profile.ErrorHandling(ex, this, "Client Master", "GetVendorOpeningBal"); } finally { ServiceAccountMaster.Close(); } }
public void GetClientDetailByClientID() { CustomProfile profile = CustomProfile.GetProfile(); iCustomerClient ServiceAccountMaster = new iCustomerClient(); try { mClient client = new mClient(); client = ServiceAccountMaster.GetClientDetailByClientID(Convert.ToInt64(HdnAccountId.Value), profile.DBConnection._constr); FillCompany(); if (client.CompanyID != null) { ddlcompany.SelectedIndex = ddlcompany.Items.IndexOf(ddlcompany.Items.FindByValue(client.CompanyID.ToString())); } hdnCompanyid.Value = client.CompanyID.ToString(); getCustomer(long.Parse(client.CompanyID.ToString())); if (client.CustomerID != null) { ddlcustomer.SelectedIndex = ddlcustomer.Items.IndexOf(ddlcustomer.Items.FindByValue(client.CustomerID.ToString())); } hdncustomerid.Value = client.CustomerID.ToString(); txt_custname.Text = client.Name.ToString(); txt_custcode.Text = client.Code.ToString(); txt_turnOver.Text = client.TurnOver.ToString(); TxtWebsite.Text = client.Website.ToString(); txt_CreditDays.Text = client.Creditdays.ToString(); Ddl_CompanyType.SelectedValue = null; if (client.CompType != null) { Ddl_CompanyType.SelectedValue = (client.CompType).ToString(); } Ddl_Sector.SelectedValue = (client.Sector).ToString(); if (client.Active == "Y") { rbtnYes.Checked = true; } else { rbtnNo.Checked = true; } } catch (Exception ex) { Login.Profile.ErrorHandling(ex, this, "Client Master", "GetClientDetailByClientID"); } finally { ServiceAccountMaster.Close(); } }
protected void btnSubmit_Click(object sender, System.EventArgs e) { string Prime = "", Express = "", Regular = "", DID = ""; CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.AccountSearchService.iCustomerClient cust = new iCustomerClient(); mSLA sla = new mSLA(); if (txtPrime.Text == "NA") { Prime = "0"; } else { Prime = txtPrime.Text; } if (txtExpress.Text == "NA") { Express = "0"; } else { Express = txtExpress.Text; } if (txtRegular.Text == "NA") { Regular = "0"; } else { Regular = txtRegular.Text; } if (hdndeptid.Value == "NA") { DID = "0"; } else { DID = hdndeptid.Value; } sla.PrimeDays = long.Parse(Prime); sla.ExpressDays = long.Parse(Express); sla.RegularDays = long.Parse(Regular); sla.DeptID = long.Parse(DID); sla.CreatedBy = profile.Personal.UserID; sla.CreatedDate = DateTime.Now; cust.AddIntomSLA(sla, profile.DBConnection._constr); Response.Write("<script>window.close();</" + "script>"); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["Lang"] == "") { Session["Lang"] = Request.UserLanguages[0]; } loadstring(); string DptID = Request.QueryString["DEPTID"].ToString(); hdndeptid.Value = Request.QueryString["DEPTID"].ToString(); if (!IsPostBack) { if (DptID != "0") { CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.AccountSearchService.iCustomerClient cust = new iCustomerClient(); mSLA sla = new mSLA(); sla = cust.GetSLADetailsDeptWise(long.Parse(DptID), profile.DBConnection._constr); if (sla != null) { if (sla.PrimeDays == 0) { chkPrime.Checked = false; } else { chkPrime.Checked = true; txtPrime.Text = sla.PrimeDays.ToString(); txtPrime.Enabled = true; } if (sla.ExpressDays == 0) { chkExpress.Checked = false; } else { chkExpress.Checked = true; txtExpress.Text = sla.ExpressDays.ToString(); txtExpress.Enabled = true; } if (sla.RegularDays == 0) { chkRegular.Checked = false; } else { chkRegular.Checked = true; txtRegular.Text = sla.RegularDays.ToString(); txtRegular.Enabled = true; } } } } }
protected void GetVendorDetailByID() { CustomProfile profile = CustomProfile.GetProfile(); iCustomerClient ServiceAccountMaster = new iCustomerClient(); mVendor vendor = new mVendor(); vendor = ServiceAccountMaster.GetVendorDetailByVendorID(Convert.ToInt64(HdnAccountId.Value), profile.DBConnection._constr); //objCutomerHead = ServiceAccountMaster.GetCustomerHeadDetailByCustomerID(Convert.ToInt64(HdnAccountId.Value), profile.DBConnection._constr); FillCompany(); if (vendor.CompanyID != null) { ddlcompany.SelectedIndex = ddlcompany.Items.IndexOf(ddlcompany.Items.FindByValue(vendor.CompanyID.ToString())); } hdnCompanyid.Value = vendor.CompanyID.ToString(); getCustomer(long.Parse(vendor.CompanyID.ToString())); if (vendor.CustomerID != null) { ddlcustomer.SelectedIndex = ddlcustomer.Items.IndexOf(ddlcustomer.Items.FindByValue(vendor.CustomerID.ToString())); } hdncustomerid.Value = vendor.CustomerID.ToString(); if (vendor.VCType != null) { ddlvendortype.SelectedIndex = ddlvendortype.Items.IndexOf(ddlvendortype.Items.FindByValue(vendor.VCType.ToString())); } txt_custname.Text = vendor.Name.ToString(); txt_custcode.Text = vendor.Code.ToString(); txt_turnOver.Text = vendor.TurnOver.ToString(); TxtWebsite.Text = vendor.Website.ToString(); txt_CreditDays.Text = vendor.Creditdays.ToString(); Ddl_CompanyType.SelectedValue = null; if (vendor.CompType != null) { Ddl_CompanyType.SelectedValue = (vendor.CompType).ToString(); } Ddl_Sector.SelectedValue = (vendor.Sector).ToString(); if (vendor.Active == "Y") { rbtnYes.Checked = true; } else { rbtnNo.Checked = true; } }
public static int WMAddIntomSLA(string Prime, string Express, string Regular, string DID) { CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.AccountSearchService.iCustomerClient cust = new iCustomerClient(); mSLA sla = new mSLA(); sla.DeptID = long.Parse(DID); long Pr = 0, Exp = 0, Reg = 0; if (Prime == "NA") { Pr = 0; } else { Pr = Convert.ToInt64(Prime); } if (Express == "NA") { Exp = 0; } else { Exp = Convert.ToInt64(Express); } if (Regular == "NA") { Reg = 0; } else { Reg = Convert.ToInt64(Regular); } sla.PrimeDays = Pr; sla.ExpressDays = Exp; sla.RegularDays = Reg; sla.CreatedBy = profile.Personal.UserID; sla.CreatedDate = DateTime.Now; cust.AddIntomSLA(sla, profile.DBConnection._constr); return(1); }
protected void GetVendorOpeningBal() { CustomProfile profile = CustomProfile.GetProfile(); iCustomerClient ServiceAccountMaster = new iCustomerClient(); tOpeningBalance objTOpeningBal = new tOpeningBalance(); objTOpeningBal = ServiceAccountMaster.GetTOpeningBalanceDtls(Convert.ToInt64(HdnAccountId.Value), "Vendor", profile.DBConnection._constr); txt_OpeningBalance.Text = objTOpeningBal.OpeningBalance.ToString(); if (objTOpeningBal.FinancialYear != null) { ddl_FinancialYr.SelectedValue = objTOpeningBal.FinancialYear.ToString(); } if (objTOpeningBal.DrCr != null) { ddl_DrCr.SelectedValue = objTOpeningBal.DrCr.ToString(); } HdnOpeningBalId.Value = objTOpeningBal.ID.ToString(); }
public string checkDuplicate() { try { string result = ""; CustomProfile profile = CustomProfile.GetProfile(); //AccountSearchService.AccountSearchService ServiceAccountMaster = new AccountSearchService.AccountSearchService(); iCustomerClient ServiceAccountMaster = new iCustomerClient(); if (HdnAccountId.Value == string.Empty) { result = ServiceAccountMaster.checkDuplicateRecord(txt_custname.Text, txt_custcode.Text, profile.DBConnection._constr); if (result != string.Empty) { WebMsgBox.MsgBox.Show(result); txt_custname.Text = ""; txt_custcode.Text = ""; } txt_custname.Focus(); } else { int id = Convert.ToInt32(HdnAccountId.Value); result = ServiceAccountMaster.checkDuplicateRecordEdit(id, txt_custname.Text, txt_custcode.Text, profile.DBConnection._constr); if (result != string.Empty) { WebMsgBox.MsgBox.Show(result); txt_custname.Text = ""; txt_custcode.Text = ""; } } return(result); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Account Master", "checkDuplicate"); string result = ""; return(result); } finally { } }
protected void pageSave(Object sender, ToolbarService.iUCToolbarClient e) { try { CustomProfile profile = CustomProfile.GetProfile(); iCustomerClient ServiceAccountMaster = new iCustomerClient(); mVendor Objvendor = new mVendor(); tCustomerHead objCutomerHead = new tCustomerHead(); tOpeningBalance objOpeningBal = new tOpeningBalance(); int result; long Result1; if (checkDuplicate() == "") { if (HdnAccountId.Value != "" && HdnAccountId.Value != "0") { //objCutomerHead = ServiceAccountMaster.GetCustomerHeadDetailByCustomerID(Convert.ToInt64(HdnAccountId.Value), profile.DBConnection._constr); Objvendor = ServiceAccountMaster.GetVendorDetailByVendorID(Convert.ToInt64(HdnAccountId.Value), profile.DBConnection._constr); objOpeningBal = ServiceAccountMaster.GetTOpeningBalanceDtls(Convert.ToInt64(HdnAccountId.Value), "Vendor", profile.DBConnection._constr); objCutomerHead.LastModifiedBy = profile.Personal.UserID.ToString(); objCutomerHead.LastModifiedDate = DateTime.Now; } else { objCutomerHead.CreatedBy = profile.Personal.UserID.ToString(); objCutomerHead.CreationDate = DateTime.Now; } Objvendor.Name = txt_custname.Text; Objvendor.CompanyID = long.Parse(ddlcompany.SelectedItem.Value); Objvendor.Code = txt_custcode.Text; Objvendor.Sector = Convert.ToInt64(Ddl_Sector.SelectedItem.Value); Objvendor.VCType = Convert.ToInt64(ddlvendortype.SelectedItem.Value); Objvendor.Creditdays = Convert.ToInt64(txt_CreditDays.Text); Objvendor.TurnOver = decimal.Parse(txt_turnOver.Text); Objvendor.CompType = Convert.ToInt64(Ddl_CompanyType.SelectedItem.Value); if (rbtnYes.Checked == true) { Objvendor.Active = "Y"; } if (rbtnNo.Checked == true) { Objvendor.Active = "N"; } Objvendor.CustomerID = long.Parse(hdncustomerid.Value); Objvendor.Website = TxtWebsite.Text; Objvendor.AccountType = "Vendor"; /* if (Ddl_CompanyType.SelectedIndex > 0) objCutomerHead.CustomerTypeID = Convert.ToInt64(Ddl_CompanyType.SelectedItem.Value); * * objCutomerHead.CustomerCode = null; * if (txt_custcode.Text.ToString().Trim() != "") objCutomerHead.CustomerCode = (txt_custcode.Text).ToString(); * * if (Ddl_Sector.SelectedIndex > 0) objCutomerHead.SectorID = Convert.ToInt64(Ddl_Sector.SelectedItem.Value); * * objCutomerHead.Name = null; * if (txt_custname.Text.ToString().Trim() != "") objCutomerHead.Name = (txt_custname.Text).ToString(); * * objCutomerHead.WebSite = null; * if (TxtWebsite.Text.ToString().Trim() != "") objCutomerHead.WebSite = (TxtWebsite.Text).ToString(); * * objCutomerHead.TurnOver = null; * if (txt_turnOver.Text.ToString().Trim() != "") objCutomerHead.TurnOver = (txt_turnOver.Text).ToString(); * * * objCutomerHead.CreditDays = null; * if (txt_CreditDays.Text.ToString().Trim() != "") objCutomerHead.CreditDays = Convert.ToInt32(txt_CreditDays.Text); * * if (rbtnYes.Checked == true) objCutomerHead.Active = "Y"; * if (rbtnNo.Checked == true) objCutomerHead.Active = "N"; * * objCutomerHead.BillingAddressID = Convert.ToInt64(UCAddress1.BillingSeq); * objCutomerHead.ShippingAddressID = Convert.ToInt64(UCAddress1.ShippingSeq); * * objCutomerHead.ConperID = UCContactPerson1.ContactPersonIDs;*/ objOpeningBal.FinancialYear = null; if (ddl_FinancialYr.SelectedIndex > 0) { objOpeningBal.FinancialYear = ddl_FinancialYr.SelectedValue; } objOpeningBal.ObjectName = "Vendor"; objOpeningBal.OpeningBalance = null; if (txt_OpeningBalance.Text.ToString().Trim() != "") { objOpeningBal.OpeningBalance = Convert.ToDecimal((txt_OpeningBalance.Text).ToString()); } objOpeningBal.DrCr = null; if (ddl_DrCr.SelectedIndex > 0) { objOpeningBal.DrCr = ddl_DrCr.SelectedValue; } //objOpeningBal.ID = Convert.ToInt64(HdnOpeningBalId.Value.ToString()); if (HdnAccountId.Value == string.Empty) { //objCutomerHead.CreatedBy = profile.Personal.UserID.ToString(); //objCutomerHead.CreationDate = DateTime.Now; //objCutomerHead.CompanyID = profile.Personal.CompanyID; Objvendor.CreatedBy = profile.Personal.UserID.ToString(); Objvendor.CreationDate = DateTime.Now; // result = ServiceAccountMaster.SaveCustomerDetails(objCutomerHead, "AddNew", profile.DBConnection._constr); result = ServiceAccountMaster.SaveVendorDetails(Objvendor, "AddNew", profile.DBConnection._constr); } else { //objCutomerHead.LastModifiedBy = profile.Personal.UserID.ToString(); //objCutomerHead.LastModifiedDate = DateTime.Now; Objvendor.LastModifiedBy = profile.Personal.UserID.ToString(); Objvendor.LastModifiedDate = DateTime.Now; //result = ServiceAccountMaster.SaveCustomerDetails(objCutomerHead, "Edit", profile.DBConnection._constr); result = ServiceAccountMaster.SaveVendorDetails(Objvendor, "Edit", profile.DBConnection._constr); } objOpeningBal.ReferenceID = result; HdnAccountId.Value = result.ToString(); if (HdnOpeningBalId.Value == "0" || HdnOpeningBalId.Value == "") { objOpeningBal.CreatedBy = profile.Personal.UserID.ToString(); objOpeningBal.CreatedDate = DateTime.Now; // Result1 = ServiceAccountMaster.SaveOpeningBalance(objOpeningBal, "AddNew", profile.DBConnection._constr); Result1 = ServiceAccountMaster.SaveAccountOpeningBal(objOpeningBal, profile.DBConnection._constr); } else { objOpeningBal.LastModifiedBy = profile.Personal.UserID.ToString(); objOpeningBal.LastModifiedDate = DateTime.Now; // Result1 = ServiceAccountMaster.SaveOpeningBalance(objOpeningBal, "Edit", profile.DBConnection._constr); Result1 = ServiceAccountMaster.SaveAccountOpeningBal(objOpeningBal, profile.DBConnection._constr); } HdnOpeningBalId.Value = Result1.ToString(); UCAddress1.FinalSaveAddress(Address.ReferenceObjectName.Vendor, result); UCContactPerson1.FinalSaveContactPerson("Vendor", result); UC_AttachDocument1.FinalSaveDocument(result); /* UC_StatutoryDetails1.FinalSaveToStatutoryDetails(Convert.ToInt64(result), "Customer", profile.Personal.CompanyID);*/ if (result != 0) { WebMsgBox.MsgBox.Show("Record saved successfully"); } clr(); MainCustomerGridBind(); // FillUserControl(result); ActiveTab("Load"); } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Account Master", "pageSave"); } finally { } }