/// <summary>
/// Code to insert the vendor address details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibtnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
string updateString = "ASNFormat='" + txtASNFormat.Text.Replace("'", "''") + "'," +
"SpecialLbl='" + txtSpecialLabel.Text.Replace("'", "''") + "'," +
"UPSNo='" + txtUPSAccount.Text.Replace("'", "''") + "'," +
"ShipViaCd='" + ddlCarrier.SelectedValue.Trim() + "'," +
"ConsMethCd='" + ddlConsolidationMethod.SelectedValue.Trim() + "'," +
"ExpediteCd='" + ddlExpedite.SelectedValue.Trim() + "'," +
"ShipMethCd='" + ddlMethod.SelectedValue.Trim() + "'," +
"PriorityCd='" + ddlPriority.SelectedValue.Trim() + "'," +
"ShipInstr='" + ddlShippingInstruction.SelectedValue.Trim() + "'," +
"InvSortOrd='" + ddlSortOrder.SelectedValue.Trim() + "'," +
"ShipLocation='" + ddlShippingLoc.SelectedValue.Trim() + "'," +
"UsageLocation='" + ddlUsageLoc.SelectedValue.Trim() + "'," +
"TransferLocation='" + ddlTrfLoc.SelectedValue.Trim() + "'," +
"AllowDelProofInd='" + ((chkList.Items[0].Selected) ? "Y" : "N") + "'," +
"AllowPartialsInd='" + ((chkList.Items[1].Selected) ? "Y" : "N") + "'," +
"AllowSubsInd='" + ((chkList.Items[2].Selected) ? "Y" : "N") + "'," +
"ASNInd='" + ((chkList.Items[3].Selected) ? "Y" : "N") + "'," +
"BackOrderInd='" + ((chkList2.Items[0].Selected) ? "Y" : "N") + "'," +
"EDI870Ind='" + ((chkList2.Items[1].Selected) ? "Y" : "N") + "'," +
"ResidentialDeliveryInd='" + ((chkList2.Items[2].Selected) ? "1" : "0") + "'," +
"PackSlipRequired='" + ((chkList2.Items[3].Selected) ? "Y" : "N") + "'," +
"ChangeDt='" + DateTime.Now.ToShortDateString() + "'," +
"ChangeID='" + Session["UserName"].ToString().Replace("'", "''") + "'";
customerDetails.UpdateCustomerDetails(updateString, CustomerID);
//BindControls();
// Update Change Dt & ID in header section
AddressHeader customerHeader = this.Parent.FindControl("ucCustomerHeader") as AddressHeader;
customerHeader.SetChangeIDAndDt();
UpdatePanel pnHeaderDetails = this.Parent.FindControl("pnHeaderDetails") as UpdatePanel;
pnHeaderDetails.Update();
}
catch (Exception ex) { }
}
}
/// <summary>
/// Code to insert the vendor address details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibtnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
string updateString = "ZeroBalMo='" + txtZeroBalance.Text.Replace("'", "''") + "'," +
"CreditInd='" + txtCreditIndicator.Text.Replace("'", "''") + "'," +
"CreditLmt='" + txtCreditLimeit.Text.Replace("'", "''") + "'," +
"CreditRvwDT='" + dpCreditReviewdt.SelectedDate.Replace("'", "''") + "'," +
"DunsNo='" + txtDunsNo.Text.Replace("'", "''") + "'," +
"DunsRating='" + txtDunsRating.Text.Replace("'", "''") + "'," +
"LateChrgPct=" + ((txtLateCharge.Text == "")?"null":"'" + txtLateCharge.Text.Replace("'", "''") + "'") + "," +
"SvcChrgMo='" + txtServiceCharge.Text.Replace("'", "''") + "'," +
"MultiTaxCd='" + txtMultiTaxCd.Text.Replace("'", "''") + "'," +
"WriteOffDt='" + dpWriteOffDate.SelectedDate.Replace("'", "''") + "'," +
"CashDiscCd='" + ddlCashDiscount.SelectedValue.Trim() + "'," +
"CreditAppInd='" + ddlCreditApp.SelectedValue.Trim() + "'," +
"CreditRvwInd='" + ddlCreditReview.SelectedValue.Trim() + "'," +
"CycBillInd='" + ddlCycleBilling.SelectedValue.Trim() + "'," +
"GLPostCd='" + ddlGLPosting.SelectedValue.Trim() + "'," +
"TaxCd='" + ddlTaxCode.SelectedValue.Trim() + "'," +
"TradeTermCd='" + ddlTradeTerm.SelectedValue.Trim() + "'," +
"SummBillInd='" + ((chkList.Items[0].Selected) ? "Y" : "N") + "'," +
"DelinqInd='" + ((chkList.Items[1].Selected) ? "Y" : "N") + "'," +
"TaxStat='" + ((chkList.Items[2].Selected) ? "Y" : "N") + "'," +
"ChgBackInd='" + ((chkList.Items[3].Selected) ? "Y" : "N") + "'," +
"FinChrgInd='" + ((chkList.Items[4].Selected) ? "Y" : "N") + "'," +
"Rebate='" + ((chkList.Items[5].Selected) ? "Y" : "N") + "'," +
"ChangeDt='" + DateTime.Now.ToShortDateString() + "'," +
"ChangeID='" + Session["UserName"].ToString().Replace("'", "''") + "'";
customerDetails.UpdateCustomerDetails(updateString, CustomerID);
// Update Change Dt & ID in header section
AddressHeader customerHeader = this.Parent.FindControl("ucCustomerHeader") as AddressHeader;
customerHeader.SetChangeIDAndDt();
UpdatePanel pnHeaderDetails = this.Parent.FindControl("pnHeaderDetails") as UpdatePanel;
pnHeaderDetails.Update();
}
catch (Exception ex) { }
}
}
/// <summary>
/// Code to insert the vendor address details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibtnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
string updateString = "ContractNo='" + txtContractNo.Text + "'," +
"PriceCd='" + ddlPriceCode.SelectedValue.Trim() + "'," +
"FirstActivityDt='" + dpFirstActivity.SelectedDate + "'," +
"SoldSinceDt='" + dpLastPurchaseDate.SelectedDate + "'," +
"MinBillAmt=" + ((txtMinBillingAmt.Text == "") ? "null" : "'" + txtMinBillingAmt.Text + "'") + "," +
"CustSlsRank='" + ddlSalesRank.SelectedValue.Trim() + "'," +
"ABCCd='" + ddlAbcCode.SelectedValue.Trim() + "'," +
"ChainCd='" + ddlChainCode.SelectedValue.Trim() + "'," +
"CLTradeCd='" + ddlClassTrade.SelectedValue.Trim() + "'," +
"ContractSchd1='" + ddlcSchedule1.SelectedValue.Trim() + "'," +
"ContractSchd2='" + ddlcSchedule2.SelectedValue.Trim() + "'," +
"ContractSchd3='" + ddlcSchedule3.SelectedValue.Trim() + "'," +
"ContractSchedule4='" + ddlcSchedule4.SelectedValue.Trim() + "'," +
"ContractSchedule5='" + ddlcSchedule5.SelectedValue.Trim() + "'," +
"ContractSchedule6='" + ddlcSchedule6.SelectedValue.Trim() + "'," +
"ContractSchedule7='" + ddlcSchedule7.SelectedValue.Trim() + "'," +
"CustomerDefaultPrice='" + ddlCustDefPrice.SelectedValue.Trim() + "'," +
"CustomerPriceInd='" + ddlCustPriceInd.SelectedValue.Trim() + "'," +
"WebDiscountPct='" + ((txtWebDiscPct.Text != "") ? txtWebDiscPct.Text : "0") + "'," +
"WebDiscountInd='" + ((chkWebDiscInd.Checked) ? "1" : "0") + "'," +
"SODocSortInd='" + ddlSODocSort.SelectedValue.Trim() + "'," +
"IRSEINNo='" + txtIRSEINNo.Text + "'," +
"SupportRepNo='" + ddlcSupportRep.SelectedValue.Trim() + "'," +
"CustType='" + ddlCustomerType.SelectedValue.Trim() + "'," +
"DiscTypeCd='" + ddlDiscountType.SelectedValue.Trim() + "'," +
"CustShipLocation='" + ddlIMLocation.SelectedValue.Trim() + "'," +
"InvInstr='" + ddlInvoiceIns.SelectedValue.Trim() + "'," +
"InvDeliveryInd='" + ddlInvDelivery.SelectedValue.Trim() + "'," +
"BuyGroup='" + ddlBuyGroup.SelectedValue.Trim() + "'," +
"RebateGroup='" + ddlRebateGroup.SelectedValue.Trim() + "'," +
"LOB='" + ddlLOB.SelectedValue.Trim() + "'," +
"ReasonCd='" + ddlReasonCode.SelectedValue.Trim() + "'," +
"CustReg='" + ddlRegion.SelectedValue.Trim() + "'," +
"SalesOrgNo='" + ddlSalesOrganization.SelectedValue.Trim() + "'," +
"SlsRepNo='" + ddlSalesRep.SelectedValue.Trim() + "'," +
"SerialNoCd='" + ddlSerialCode.SelectedValue.Trim() + "'," +
"ShipTermsCd='" + ddlShippingTerms.SelectedValue.Trim() + "'," +
"SIC='" + ddlSIC.SelectedValue.Trim() + "'," +
"SalesTerritory='" + ddlTerritory.SelectedValue.Trim() + "'," +
"TypeofOrder='" + ddlTypeOrder.SelectedValue.Trim() + "'," +
"NetPriceInd='" + ((chkList.Items[0].Selected) ? "Y" : "N") + "'," +
"NextPriceInd='" + ((chkList.Items[1].Selected) ? "Y" : "N") + "'," +
"NickelSurChrgInd='" + ((chkList.Items[2].Selected) ? "Y" : "N") + "'," +
"PORequiredInd='" + ((chkList2.Items[0].Selected) ? "1" : "0") + "'," +
"CertRequiredInd='" + ddlCertsInd.SelectedValue + "'," +
"ChangeDt='" + DateTime.Now.ToShortDateString() + "'," +
"ChangeID='" + Session["UserName"].ToString().Replace("'", "''") + "'";
customerDetails.UpdateCustomerDetails(updateString, CustomerID);
// Update Change Dt & ID in header section
AddressHeader customerHeader = this.Parent.FindControl("ucCustomerHeader") as AddressHeader;
customerHeader.SetChangeIDAndDt();
UpdatePanel pnHeaderDetails = this.Parent.FindControl("pnHeaderDetails") as UpdatePanel;
pnHeaderDetails.Update();
}
catch (Exception ex) { throw ex; }
}
}