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