protected void ibtnUpdate_Click(object sender, ImageClickEventArgs e) { if (Page.IsValid) { if (ddlCode.SelectedValue == "P") { customerDetails.UpdateCustomerDetails("CustomerContact", "ContactCd='A'", "fCustAddrID=" + hidAddressID.Value.Trim()); } if (Mode == "Add") { //[fCustAddrID],CustNo,ContactType,ContactCd,[Name],[JobTitle],[Phone],[PhoneExt],[FaxNo],[MobilePhone], //[EmailAddr],[Department],[EntryID],[EntryDt],[ChangeID],[ChangeDt] string columnValue = AddressID + "," + "'" + CustomerNumber + "'," + "'" + ddlType.SelectedValue + "'," + "'" + ddlCode.SelectedValue + "'," + "'" + txtName.Text.Trim().Replace("'", "''") + "'," + "'" + txtJobTitle.Text.Trim().Replace("'", "''") + "'," + "'" + phContact.GetPhoneNumber.Trim().Replace("'", "''") + "'," + "'" + txtExt.Text.Trim().Replace("'", "''") + "'," + "'" + fxContact.GetPhoneNumber.Trim().Replace("'", "''") + "'," + "'" + txtMphone.GetPhoneNumber.Trim().Replace("'", "''") + "'," + "'" + txtEmail.Text.Trim().Replace("'", "''") + "'," + "'" + txtDepartment.Text.Trim().Replace("'", "''") + "'," + "'" + ((Session["UserName"] != null) ? Session["UserName"].ToString() : "") + "'," + "'" + DateTime.Now.ToShortDateString() + "'"; hidContactID.Value = customerDetails.InsertContactDetails(columnValue); } else if (hidMode.Value == "Edit") { string updateValue = "ContactType='" + ddlType.SelectedValue + "'," + "ContactCd='" + ddlCode.SelectedValue + "'," + "Name='" + txtName.Text.Trim().Replace("'", "''") + "'," + "JobTitle='" + txtJobTitle.Text.Trim().Replace("'", "''") + "'," + "Phone='" + phContact.GetPhoneNumber.Trim().Replace("'", "''") + "'," + "PhoneExt='" + txtExt.Text.Trim().Replace("'", "''") + "'," + "FaxNo='" + fxContact.GetPhoneNumber.Trim().Replace("'", "''") + "'," + "MobilePhone='" + txtMphone.GetPhoneNumber.Trim().Replace("'", "''") + "'," + "EmailAddr='" + txtEmail.Text.Trim().Replace("'", "''") + "'," + "Department='" + txtDepartment.Text.Trim().Replace("'", "''") + "'," + "ChangeID='" + ((Session["UserName"] != null) ? Session["UserName"].ToString() : "") + "'," + "ChangeDt='" + DateTime.Now.ToShortDateString() + "'"; customerDetails.UpdateCustomerDetails("CustomerContact", updateValue, "pCustContactsID=" + hidContactID.Value.Trim()); } if (ddlCode.SelectedValue == "P") { customerDetails.UpdateCustomerDetails("CustomerAddress", "fCustContactsID=" + hidContactID.Value.Trim(), "pCustomerAddressID=" + hidAddressID.Value.Trim()); } tblContactEntry.Visible = false; btnAdd.Visible = true; BindContactDetails(); divDisplay.Style.Add(HtmlTextWriterStyle.Display, ""); } }
private void UpdateCustomer() { //[pCustMstrID],[CustNo],[CustName],[],[SortName],[CustSearchKey],[CustSlsRank], //[ShipLocation],[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],CustShipLocation,UsageLocation if (Type != "SH") { string updateString = "CustName='" + txtCustName.Text.Replace("'", "''") + "'," + "SortName='" + txtSortName.Text.Replace("'", "''") + "'," + "CustSearchKey='" + txtSearchKey.Text.Replace("'", "''") + "'," + "AltCustName='" + txtAltCustName.Text.Replace("'", "''") + "'," + "ChangeDt='" + DateTime.Now.ToShortDateString() + "'," + "ChangeID='" + Session["UserName"].ToString().Replace("'", "''") + "'"; customerDetails.UpdateCustomerDetails(updateString, CustomerID); } }
/// <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; } } }