/// <summary> /// Page Load Event Handler /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { lnkListMaster.Attributes.Add("onclick", "Javascript:ShowDetail(this.id);return false;"); if (!IsPostBack) { Session["UserSecurity"] = "t"; CustomerDetail = customerMaintenance.GetCustomerDetail(CustomerID); if (CustomerDetail != null && CustomerDetail.Rows.Count > 0) { lblCustNumber.Text = CustomerDetail.Rows[0]["CustNo"].ToString(); lblCustName.Text = CustomerDetail.Rows[0]["CustName"].ToString(); BindDataGrid(); ViewState["Mode"] = "ADD"; } BindState(); } if (Session["SecurityCode"].ToString().Trim() != "" && Session["CustomerLock"].ToString().Trim() != "L") { ibtnSave.Visible = true; } else { ibtnSave.Visible = false; } }
/// <summary> /// Page Load Event Handler /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { CustomerDetail = customerMaintenance.GetCustomerDetail(CustomerID); if (!IsPostBack) { if (CustomerDetail != null && CustomerDetail.Rows.Count > 0) { lblCustNumber.Text = CustomerDetail.Rows[0]["CustNo"].ToString(); BindDataGrid(); ViewState["Mode"] = "ADD"; } BindNotesType(); } if (Session["SecurityCode"].ToString().Trim() != "" && Session["CustomerLock"].ToString().Trim() != "L") { ibtnSave.Visible = true; } else { ibtnSave.Visible = false; } }
private void BindControls() { dtValues = customerDetails.GetCustomerDetail(CustomerID); if (dtValues != null && dtValues.Rows.Count > 0) { dpLastPurchaseDate.SelectedDate = (dtValues.Rows[0]["SoldSinceDt"].ToString() == "") ? "" : Convert.ToDateTime(dtValues.Rows[0]["SoldSinceDt"].ToString()).ToShortDateString(); dpFirstActivity.SelectedDate = (dtValues.Rows[0]["FirstActivityDt"].ToString() == "") ? "" : Convert.ToDateTime(dtValues.Rows[0]["FirstActivityDt"].ToString()).ToShortDateString(); customerDetails.SetValueListControl(ddlIMLocation, dtValues.Rows[0]["CustShipLocation"].ToString()); customerDetails.SetValueListControl(ddlAbcCode, dtValues.Rows[0]["ABCCd"].ToString()); customerDetails.SetValueListControl(ddlPriceCode, dtValues.Rows[0]["PriceCd"].ToString()); customerDetails.SetValueListControl(ddlChainCode, dtValues.Rows[0]["ChainCd"].ToString()); customerDetails.SetValueListControl(ddlCustomerType, dtValues.Rows[0]["CustType"].ToString()); txtContractNo.Text = dtValues.Rows[0]["ContractNo"].ToString(); customerDetails.SetValueListControl(ddlcSchedule1, dtValues.Rows[0]["ContractSchd1"].ToString()); customerDetails.SetValueListControl(ddlcSchedule2, dtValues.Rows[0]["ContractSchd2"].ToString()); customerDetails.SetValueListControl(ddlcSchedule3, dtValues.Rows[0]["ContractSchd3"].ToString()); customerDetails.SetValueListControl(ddlcSchedule4, dtValues.Rows[0]["ContractSchedule4"].ToString()); customerDetails.SetValueListControl(ddlcSchedule5, dtValues.Rows[0]["ContractSchedule5"].ToString()); customerDetails.SetValueListControl(ddlcSchedule6, dtValues.Rows[0]["ContractSchedule6"].ToString()); customerDetails.SetValueListControl(ddlcSchedule7, dtValues.Rows[0]["ContractSchedule7"].ToString()); customerDetails.SetValueListControl(ddlSODocSort, dtValues.Rows[0]["SODocSortInd"].ToString().Trim()); customerDetails.SetValueListControl(ddlCustDefPrice, dtValues.Rows[0]["CustomerDefaultPrice"].ToString()); customerDetails.SetValueListControl(ddlCustPriceInd, dtValues.Rows[0]["CustomerPriceInd"].ToString()); txtWebDiscPct.Text = String.Format("{0:0.00}", dtValues.Rows[0]["WebDiscountPct"]); chkWebDiscInd.Checked = (dtValues.Rows[0]["WebDiscountInd"].ToString().ToUpper().Trim() == "1"); txtIRSEINNo.Text = dtValues.Rows[0]["IRSEINNo"].ToString(); customerDetails.SetValueListControl(ddlSerialCode, dtValues.Rows[0]["SerialNoCd"].ToString()); customerDetails.SetValueListControl(ddlTypeOrder, dtValues.Rows[0]["TypeofOrder"].ToString()); customerDetails.SetValueListControl(ddlShippingTerms, dtValues.Rows[0]["ShipTermsCd"].ToString()); customerDetails.SetValueListControl(ddlReasonCode, dtValues.Rows[0]["ReasonCd"].ToString()); customerDetails.SetValueListControl(ddlClassTrade, dtValues.Rows[0]["CLTradeCd"].ToString()); customerDetails.SetValueListControl(ddlRegion, dtValues.Rows[0]["CustReg"].ToString()); customerDetails.SetValueListControl(ddlSalesOrganization, dtValues.Rows[0]["SalesOrgNo"].ToString()); customerDetails.SetValueListControl(ddlTerritory, dtValues.Rows[0]["SalesTerritory"].ToString()); customerDetails.SetValueListControl(ddlSalesRep, dtValues.Rows[0]["SlsRepNo"].ToString()); customerDetails.SetValueListControl(ddlcSupportRep, dtValues.Rows[0]["SupportRepNo"].ToString()); customerDetails.SetValueListControl(ddlSalesRank, dtValues.Rows[0]["CustSlsRank"].ToString()); customerDetails.SetValueListControl(ddlInvoiceIns, dtValues.Rows[0]["InvInstr"].ToString()); customerDetails.SetValueListControl(ddlInvDelivery, dtValues.Rows[0]["InvDeliveryInd"].ToString()); customerDetails.SetValueListControl(ddlDiscountType, dtValues.Rows[0]["DiscTypeCd"].ToString()); customerDetails.SetValueListControl(ddlBuyGroup, dtValues.Rows[0]["BuyGroup"].ToString()); customerDetails.SetValueListControl(ddlRebateGroup, dtValues.Rows[0]["RebateGroup"].ToString()); txtMinBillingAmt.Text = dtValues.Rows[0]["MinBillAmt"].ToString(); customerDetails.SetValueListControl(ddlLOB, dtValues.Rows[0]["LOB"].ToString()); customerDetails.SetValueListControl(ddlSIC, dtValues.Rows[0]["SIC"].ToString()); chkList.Items[0].Selected = (dtValues.Rows[0]["NetPriceInd"].ToString().ToUpper().Trim() == "Y"); chkList.Items[1].Selected = (dtValues.Rows[0]["NextPriceInd"].ToString().ToUpper().Trim() == "Y"); chkList.Items[2].Selected = (dtValues.Rows[0]["NickelSurChrgInd"].ToString().ToUpper().Trim() == "Y"); chkList2.Items[0].Selected = (dtValues.Rows[0]["PORequiredInd"].ToString().ToUpper().Trim() == "1"); //chkList2.Items[1].Selected = (dtValues.Rows[0]["CertRequiredInd"].ToString().ToUpper().Trim() == "1"); customerDetails.SetValueListControl(ddlCertsInd, dtValues.Rows[0]["CertRequiredInd"].ToString()); } else { ClearControl(); } }
private void BindControls() { // Unknown ZeroBalanceMo,SurchrgInd //"[pCustMstrID],[CustNo],[CustName],[AltCustName],[SortName],[CustSearchKey],[CustSlsRank],[IMLoc], //[fBillToNo],[ARGLAcctID],[CustType],[ContractNo],[DunsNo],[DunsRating],[Territory],[CustReg], //[SalesOrgNo],[SlsRepNo],[SupportRepNo],[ResaleNo],[UPSNo],[TaxStat],[CreditInd],[SummBillInd], //[CycBillInd],[DunInd],[BackOrderInd],[CreditAppInd],[CreditRvwInd],[NetPriceInd],[NextPriceInd], //[AllowSubsInd],[AllowPartialsInd],[AllowDelProofInd],[AllowPTLInd],[ASNInd],[DelinqInd],[ChgBackInd], //[NickelSurChrgInd],[EDI870Ind],[FinChrgInd],[StmtCopies],[InvCopies],[CashStatus],[InvSortOrd], //[TaxCd],[CustCd],[ReasonCd],[CLTradeCd],[PriorityCd],[ExpediteCd],[ShipMethCd],[ShipViaCd], //[ShipTermsCd],[TradeTermCd],[ConsMethCd],[DateCdLimit],[SerialNoCd],[MultiTaxCd],[CashDiscCd], //[GLPostCd],[DiscTypeCd],[SIC],[LOB],[Rebate],[InvInstr],[ShipInstr],[CreditLmt],[FirstActivityDt], //[CreditRvwDT],[SoldSinceDt],[WriteOffDt],[DeleteDt],[LateChrgPct],[ContractSchd1],[ContractSchd2], //[ContractSchd3],[MinBillAmt],[SvcChrgMo],[ZeroBalMo],[SpecialLbl],[ASNFormat],[TypeofOrder], //[EntryID],[EntryDt],[ChangeID],[ChangeDt],[StatusCd],[ABCCd],[ChainCd],[PriceCd]"; dtValues = customerDetails.GetCustomerDetail(CustomerID); if (dtValues != null && dtValues.Rows.Count > 0) { txtASNFormat.Text = dtValues.Rows[0]["ASNFormat"].ToString(); txtSpecialLabel.Text = dtValues.Rows[0]["SpecialLbl"].ToString(); txtUPSAccount.Text = dtValues.Rows[0]["UPSNo"].ToString(); customerDetails.SetValueListControl(ddlCarrier, dtValues.Rows[0]["ShipViaCd"].ToString()); customerDetails.SetValueListControl(ddlConsolidationMethod, dtValues.Rows[0]["ConsMethCd"].ToString()); customerDetails.SetValueListControl(ddlExpedite, dtValues.Rows[0]["ExpediteCd"].ToString()); customerDetails.SetValueListControl(ddlMethod, dtValues.Rows[0]["ShipMethCd"].ToString()); customerDetails.SetValueListControl(ddlPriority, dtValues.Rows[0]["PriorityCd"].ToString()); customerDetails.SetValueListControl(ddlShippingInstruction, dtValues.Rows[0]["ShipInstr"].ToString()); customerDetails.SetValueListControl(ddlSortOrder, dtValues.Rows[0]["InvSortOrd"].ToString()); customerDetails.SetValueListControl(ddlShippingLoc, dtValues.Rows[0]["ShipLocation"].ToString()); customerDetails.SetValueListControl(ddlUsageLoc, dtValues.Rows[0]["UsageLocation"].ToString()); customerDetails.SetValueListControl(ddlTrfLoc, dtValues.Rows[0]["TransferLocation"].ToString()); chkList.Items[0].Selected = (dtValues.Rows[0]["AllowDelProofInd"].ToString().ToUpper().Trim() == "Y"); chkList.Items[1].Selected = (dtValues.Rows[0]["AllowPartialsInd"].ToString().ToUpper().Trim() == "Y"); chkList.Items[2].Selected = (dtValues.Rows[0]["AllowSubsInd"].ToString().ToUpper().Trim() == "Y"); chkList.Items[3].Selected = (dtValues.Rows[0]["ASNInd"].ToString().ToUpper().Trim() == "Y"); chkList2.Items[0].Selected = (dtValues.Rows[0]["BackOrderInd"].ToString().ToUpper().Trim() == "Y"); chkList2.Items[1].Selected = (dtValues.Rows[0]["EDI870Ind"].ToString().ToUpper().Trim() == "Y"); chkList2.Items[2].Selected = (dtValues.Rows[0]["ResidentialDeliveryInd"].ToString().ToUpper().Trim() == "1"); chkList2.Items[3].Selected = (dtValues.Rows[0]["PackSlipRequired"].ToString().ToUpper().Trim() == "Y"); } else { ClearControl(); } }
private void BindControls() { // Unknown ZeroBalanceMo, //"[pCustMstrID],[CustNo],[CustName],[AltCustName],[SortName],[CustSearchKey],[CustSlsRank],[IMLoc], //[fBillToNo],[ARGLAcctID],[CustType],[ContractNo],[DunsNo],[DunsRating],[Territory],[CustReg], //[SalesOrgNo],[SlsRepNo],[SupportRepNo],[ResaleNo],[UPSNo],[TaxStat],[CreditInd],[SummBillInd], //[CycBillInd],[DunInd],[BackOrderInd],[CreditAppInd],[CreditRvwInd],[NetPriceInd],[NextPriceInd], //[AllowSubsInd],[AllowPartialsInd],[AllowDelProofInd],[AllowPTLInd],[ASNInd],[DelinqInd],[ChgBackInd], //[NickelSurChrgInd],[EDI870Ind],[FinChrgInd],[StmtCopies],[InvCopies],[CashStatus],[InvSortOrd], //[TaxCd],[CustCd],[ReasonCd],[CLTradeCd],[PriorityCd],[ExpediteCd],[ShipMethCd],[ShipViaCd], //[ShipTermsCd],[TradeTermCd],[ConsMethCd],[DateCdLimit],[SerialNoCd],[MultiTaxCd],[CashDiscCd], //[GLPostCd],[DiscTypeCd],[SIC],[LOB],[Rebate],[InvInstr],[ShipInstr],[CreditLmt],[FirstActivityDt], //[CreditRvwDT],[SoldSinceDt],[WriteOffDt],[DeleteDt],[LateChrgPct],[ContractSchd1],[ContractSchd2], //[ContractSchd3],[MinBillAmt],[SvcChrgMo],[ZeroBalMo],[SpecialLbl],[ASNFormat],[TypeofOrder], //[EntryID],[EntryDt],[ChangeID],[ChangeDt],[StatusCd],[ABCCd],[ChainCd],[PriceCd]"; dtValues = customerDetails.GetCustomerDetail(CustomerID); if (dtValues != null && dtValues.Rows.Count > 0) { txtZeroBalance.Text = dtValues.Rows[0]["ZeroBalMo"].ToString(); txtCreditIndicator.Text = dtValues.Rows[0]["CreditInd"].ToString(); txtCreditLimeit.Text = dtValues.Rows[0]["CreditLmt"].ToString(); dpCreditReviewdt.SelectedDate = (dtValues.Rows[0]["CreditRvwDT"].ToString() == "") ? "" : Convert.ToDateTime(dtValues.Rows[0]["CreditRvwDT"].ToString()).ToShortDateString(); txtDunsNo.Text = dtValues.Rows[0]["DunsNo"].ToString(); txtDunsRating.Text = dtValues.Rows[0]["DunsRating"].ToString(); txtLateCharge.Text = dtValues.Rows[0]["LateChrgPct"].ToString(); txtServiceCharge.Text = dtValues.Rows[0]["SvcChrgMo"].ToString(); txtMultiTaxCd.Text = dtValues.Rows[0]["MultiTaxCd"].ToString(); dpWriteOffDate.SelectedDate = (dtValues.Rows[0]["WriteOffDt"].ToString() == "") ? "" : Convert.ToDateTime(dtValues.Rows[0]["WriteOffDt"].ToString()).ToShortDateString(); customerDetails.SetValueListControl(ddlCashDiscount, dtValues.Rows[0]["CashDiscCd"].ToString()); customerDetails.SetValueListControl(ddlCreditApp, dtValues.Rows[0]["CreditAppInd"].ToString()); customerDetails.SetValueListControl(ddlCreditReview, dtValues.Rows[0]["CreditRvwInd"].ToString()); customerDetails.SetValueListControl(ddlCycleBilling, dtValues.Rows[0]["CycBillInd"].ToString()); customerDetails.SetValueListControl(ddlGLPosting, dtValues.Rows[0]["GLPostCd"].ToString()); customerDetails.SetValueListControl(ddlTaxCode, dtValues.Rows[0]["TaxCd"].ToString()); customerDetails.SetValueListControl(ddlTradeTerm, dtValues.Rows[0]["TradeTermCd"].ToString()); chkList.Items[0].Selected = (dtValues.Rows[0]["SummBillInd"].ToString().ToUpper().Trim() == "Y"); chkList.Items[1].Selected = (dtValues.Rows[0]["DelinqInd"].ToString().ToUpper().Trim() == "Y"); chkList.Items[2].Selected = (dtValues.Rows[0]["TaxStat"].ToString().ToUpper().Trim() == "Y"); chkList.Items[3].Selected = (dtValues.Rows[0]["ChgBackInd"].ToString().ToUpper().Trim() == "Y"); chkList.Items[4].Selected = (dtValues.Rows[0]["FinChrgInd"].ToString().ToUpper().Trim() == "Y"); chkList.Items[5].Selected = (dtValues.Rows[0]["Rebate"].ToString().ToUpper().Trim() == "Y"); } else { ClearControl(); } }
public void BindcustomerDetails() { try { DataTable dtCustomerDetail = customerDetails.GetCustomerDetail(CustomerID); if (dtCustomerDetail != null && dtCustomerDetail.Rows.Count > 0) { txtAltCustName.Text = dtCustomerDetail.Rows[0]["AltCustName"].ToString(); txtCustName.Text = dtCustomerDetail.Rows[0]["CustName"].ToString(); // txtCustName2.Text = dtCustomerDetail.Rows[0][""].ToString(); txtCustNo.Text = dtCustomerDetail.Rows[0]["CustNo"].ToString(); txtSearchKey.Text = dtCustomerDetail.Rows[0]["CustSearchKey"].ToString(); txtSortName.Text = dtCustomerDetail.Rows[0]["SortName"].ToString(); customerDetails.SetSelectedValuesInListControl(ddlCode, dtCustomerDetail.Rows[0]["CustCd"].ToString()); } else { ClearCustomer(); } } catch (Exception ex) { } }