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