private void BindDropDownList()
{
customerDetails.BindListControls(ddlConsolidationMethod, "ListDesc", "ListValue", customerDetails.GetListDetails("ConsolMethCd"), "-- Select --");
customerDetails.BindListControls(ddlShippingInstruction, "ListDesc", "ListValue", customerDetails.GetListDetails("ShipInstr"), "-- Select --");
customerDetails.BindListControls(ddlSortOrder, "ListDesc", "ListValue", customerDetails.GetListDetails("YesNoInd"), "-- Select --");
customerDetails.BindListControls(ddlCarrier, "ListDesc", "ListValue", customerDetails.GetTableValues("CAR"), "-- Select --");
customerDetails.BindListControls(ddlExpedite, "ListDesc", "ListValue", customerDetails.GetTableValues("EXPD"), "-- Select --");
customerDetails.BindListControls(ddlMethod, "ListDesc", "ListValue", customerDetails.GetTableValues("CAR"), "-- Select --");
customerDetails.BindListControls(ddlPriority, "ListDesc", "ListValue", customerDetails.GetTableValues("PRI"), "-- Select --");
customerDetails.BindListControls(ddlShippingLoc, "ListDesc", "ListValue", customerDetails.GetLocationList(), "-- Select --");
customerDetails.BindListControls(ddlUsageLoc, "ListDesc", "ListValue", customerDetails.GetLocationList(), "-- Select --");
customerDetails.BindListControls(ddlTrfLoc, "ListDesc", "ListValue", customerDetails.GetLocationList(), "-- Select --");
}
private void BindDropDownList()
{
customerDetails.BindListControls(ddlCashDiscount, "ListDesc", "ListValue", customerDetails.GetListDetails("CashDiscCd"), "-- Select --");
customerDetails.BindListControls(ddlCycleBilling, "ListDesc", "ListValue", customerDetails.GetListDetails("CycBillInd"), "-- Select --");
customerDetails.BindListControls(ddlGLPosting, "ListDesc", "ListValue", customerDetails.GetListDetails("GLTypeCd"), "-- Select --");
customerDetails.BindListControls(ddlTaxCode, "ListDesc", "ListValue", customerDetails.GetListDetails("TaxStatusCd"), "-- Select --");
customerDetails.BindListControls(ddlTradeTerm, "ListDesc", "ListValue", customerDetails.GetTableValues("TRM"), "-- Select --");
customerDetails.BindListControls(ddlCreditApp, "ListDesc", "ListValue", customerDetails.GetListDetails("YesNoInd"), "-- Select --");
customerDetails.BindListControls(ddlCreditReview, "ListDesc", "ListValue", customerDetails.GetListDetails("YesNoInd"), "-- Select --");
}
private void BindCostType()
{
try
{
string _tableName = "ListMaster (NOLOCK) LM ,ListDetail (NOLOCK) LD";
string _columnName = "(LD.ListValue + ' - ' + LD.ListdtlDesc) as ListDesc,LD.ListValue ";
string _whereClause = "LM.ListName = 'setcostbasis' And LD.fListMasterID = LM.pListMasterID order by SequenceNo asc";
DataSet dsCostBasis = SqlHelper.ExecuteDataset(Global.PFCERPConnectionString, "UGEN_SP_Select",
new SqlParameter("@tableName", _tableName),
new SqlParameter("@columnNames", _columnName),
new SqlParameter("@whereClause", _whereClause));
customerMaintenance.BindListControls(ddlCostBasis, "ListDesc", "ListValue", dsCostBasis.Tables[0]);
ddlCostBasis.Items.Insert(0, new ListItem("---- Select ----", ""));
}
catch (Exception ex)
{
}
}
private void BindState()
{
customerMaintenance.BindListControls(ddlState, "ListDesc", "ListValue", customerMaintenance.GetStates(), "-- Select State --");
}
private void BindListControl()
{
customerDetails.BindListControls(ddlCode, "ListDesc", "ListValue", customerDetails.GetListDetails("ContactCode"), "-- Select --");
customerDetails.BindListControls(ddlType, "ListDesc", "ListValue", customerDetails.GetListDetails("ContactType"), "-- Select --");
}
private void BindDropDownList()
{
customerDetails.BindListControls(ddlIMLocation, "ListDesc", "ListValue", customerDetails.GetLocationList(), "-- Select --");
customerDetails.BindListControls(ddlAbcCode, "ListDesc", "ListValue", customerDetails.GetListDetails("CustSlsRank"), "-- Select --");
customerDetails.BindListControls(ddlPriceCode, "ListDesc", "ListValue", customerDetails.GetListDetails("CustPriceCd"), "-- Select --");
customerDetails.BindListControls(ddlChainCode, "ListDesc", "ListValue", customerDetails.GetChainDetails(), "-- Select --");
customerDetails.BindListControls(ddlCustomerType, "ListDesc", "ListValue", customerDetails.GetListDetails("CustType"), "-- Select --");
customerDetails.BindListControls(ddlcSchedule1, "ListValue", "ListValue", customerDetails.GetListDetails("CustContractSchd1"), "-- Select --");
DataTable dtCustomerContractSchd = customerDetails.GetListDetails("CustContractSchd");
customerDetails.BindListControls(ddlcSchedule2, "ListValue", "ListValue", dtCustomerContractSchd, "-- Select --");
customerDetails.BindListControls(ddlcSchedule3, "ListValue", "ListValue", dtCustomerContractSchd, "-- Select --");
customerDetails.BindListControls(ddlcSchedule4, "ListValue", "ListValue", dtCustomerContractSchd, "-- Select --");
customerDetails.BindListControls(ddlcSchedule5, "ListValue", "ListValue", dtCustomerContractSchd, "-- Select --");
customerDetails.BindListControls(ddlcSchedule6, "ListValue", "ListValue", dtCustomerContractSchd, "-- Select --");
customerDetails.BindListControls(ddlcSchedule7, "ListValue", "ListValue", dtCustomerContractSchd, "-- Select --");
customerDetails.BindListControls(ddlSODocSort, "ListDesc", "ListValue", customerDetails.GetListDetails("SODocSortInd"), "-- Select --");
customerDetails.BindListControls(ddlCustDefPrice, "ListDesc", "ListValue", customerDetails.GetListDetails("CustDefPriceSchd"), "-- Select --");
customerDetails.BindListControls(ddlCustPriceInd, "ListDesc", "ListValue", customerDetails.GetListDetails("CustPriceInd"), "-- Select --");
customerDetails.BindListControls(ddlSerialCode, "ListDesc", "ListValue", customerDetails.GetListDetails("YesNoInd"), "-- Select --");
customerDetails.BindListControls(ddlTypeOrder, "ListDesc", "ListValue", customerDetails.GetListDetails("SOEOrderTypes"), "-- Select --");
customerDetails.BindListControls(ddlShippingTerms, "ListDesc", "ListValue", customerDetails.GetListDetails("ShipTermsCode"), "-- Select --");
customerDetails.BindListControls(ddlReasonCode, "ListDesc", "ListValue", customerDetails.GetTableValues("REAS"), "-- Select --");
customerDetails.BindListControls(ddlClassTrade, "ListDesc", "ListValue", customerDetails.GetTableValues("TRD"), "-- Select --");
customerDetails.BindListControls(ddlRegion, "ListDesc", "ListValue", customerDetails.GetListDetails("SOEOrderTypes"), "-- Select --");
customerDetails.BindListControls(ddlSalesOrganization, "ListDesc", "ListValue", customerDetails.GetLocationList(), "-- Select --");
customerDetails.BindListControls(ddlTerritory, "ListDesc", "ListValue", customerDetails.GetListDetails("SalesTerritory"), "-- Select --");
customerDetails.BindListControls(ddlSalesRep, "ListDesc", "ListValue", customerDetails.GetSalesRep(), "-- Select --");
customerDetails.BindListControls(ddlcSupportRep, "ListDesc", "ListValue", customerDetails.GetSalesRep(), "-- Select --");
customerDetails.BindListControls(ddlSalesRank, "ListDesc", "ListValue", customerDetails.GetListDetails("CustSlsRank"), "-- Select --");
customerDetails.BindListControls(ddlInvoiceIns, "ListDesc", "ListValue", customerDetails.GetListDetails("InvoiceInstr"), "-- Select --");
customerDetails.BindListControls(ddlInvDelivery, "ListDesc", "ListValue", customerDetails.GetListDetails("InvDeliveryInd"), "-- Select --");
customerDetails.BindListControls(ddlDiscountType, "ListDesc", "ListValue", customerDetails.GetListDetails("SalesDiscType"), "-- Select --");
customerDetails.BindListControls(ddlBuyGroup, "ListDesc", "ListValue", customerDetails.GetListDetails("BuyGrp"), "-- Select --");
customerDetails.BindListControls(ddlRebateGroup, "ListDesc", "ListValue", customerDetails.GetListDetails("CustRebateGrp"), "-- Select --");
customerDetails.BindListControls(ddlLOB, "ListDesc", "ListValue", customerDetails.GetListDetails("CustSalesLOB"), "-- Select --");
customerDetails.BindListControls(ddlSIC, "ListDesc", "ListValue", customerDetails.GetListDetails("CustSalesSIC"), "-- Select --");
//customerDetails.BindListControls(ddlCertsInd, "ListDesc", "ListValue", customerDetails.GetListDetails("CertsRequiredInd"), "-- Select --");
_ddlBind.BindFromList("CertsRequiredInd", ddlCertsInd, "", "-- Select --");
}
private void BindNotesType()
{
customerMaintenance.BindListControls(ddlType, "ListDesc", "ListValue", customerMaintenance.GetNotesType());
SelectItem(ddlType, "Credit");
}
