public void BindAddressDetail() { //string condition = "CustomerAddress.fCustomerMasterID=customermaster.pCustMstrID and customermaster.custno ='" + customerNo + "' and CustomerAddress.[Type]<>'SHP' and CustomerAddress.[Type]<>'DSHP'"; DataTable dtAddressDetail = (Type != "SH") ? customerDetails.GetCustomerAddress(txtCustNo.Text) : customerDetails.GetCustomerShipToAddress(AddressID); if (dtAddressDetail != null) { txtAddress1.Text = dtAddressDetail.Rows[0]["AddrLine1"].ToString(); txtAddress2.Text = dtAddressDetail.Rows[0]["AddrLine2"].ToString(); txtCity.Text = dtAddressDetail.Rows[0]["City"].ToString(); txtCountry.Text = dtAddressDetail.Rows[0]["Country"].ToString(); txtPhone.GetPhoneNumber = dtAddressDetail.Rows[0]["PhoneNo"].ToString(); txtPostCode.Text = dtAddressDetail.Rows[0]["PostCd"].ToString(); txtState.Text = dtAddressDetail.Rows[0]["State"].ToString(); txtCustName.Text = dtAddressDetail.Rows[0]["Name1"].ToString(); txtCustName2.Text = dtAddressDetail.Rows[0]["Name2"].ToString(); AddressID = dtAddressDetail.Rows[0]["pCustomerAddressID"].ToString(); customerDetails.SetSelectedValuesInListControl(ddlAddType, dtAddressDetail.Rows[0]["Type"].ToString()); lblChangeDate.Text = (dtAddressDetail.Rows[0]["ChangeDt"].ToString() != "") ? Convert.ToDateTime(dtAddressDetail.Rows[0]["ChangeDt"].ToString()).ToShortDateString() : ""; lblChangeID.Text = dtAddressDetail.Rows[0]["ChangeID"].ToString(); lblEntryDate.Text = Convert.ToDateTime(dtAddressDetail.Rows[0]["EntryDt"].ToString()).ToShortDateString(); lblEntryID.Text = dtAddressDetail.Rows[0]["EntryID"].ToString(); } else { ClearAddress(); } if (Type == "SH") { DataSet dsCount = customerDetails.GetDataToDateset("customerAddress (NOLOCK) ", "count(*)", "fCustomerMasterID =" + CustomerID + " and (Type='DSHP' or Type ='SHP')"); if (dsCount != null && (dsCount.Tables[0].Rows[0][0].ToString() == "0" || dsCount.Tables[0].Rows[0][0].ToString() == "1")) { customerDetails.SetSelectedValuesInListControl(ddlAddType, "DSHP"); ddlAddType.Enabled = false; } else { ddlAddType.Enabled = true; } } if (Session["SoldToAddressCount"] != null && (((Session["SoldToAddressCount"].ToString() == "0" || Session["SoldToAddressCount"].ToString() == "1") && Mode == "Edit") || ((Session["SoldToAddressCount"].ToString() == "0" && Mode == "Edit"))) && hidType.Value == "ST") { customerDetails.SetSelectedValuesInListControl(ddlAddType, "P"); ddlAddType.Enabled = false; } else if (Type == "ST") { ddlAddType.Enabled = true; } }
private void BindBillToAddress() { //[pCustomerAddressID],[Type],[fCustomerMasterID],[Name2],[AddrLine1],[AddrLine2],[AddrLine3],[AddrLine4], //[AddrLine5],[City],[State],[PostCd],[Country],[PhoneNo],[CustContacts],[fCustContactsID],[UPSZone], //[FaxPhoneNo],[EDIPhoneNo],[UPSShipperNo],[Email],CustomerAddress.[EntryID],CustomerAddress.[EntryDt] //,CustomerAddress.[ChangeID],CustomerAddress.[ChangeDt],CustomerAddress.[StatusCd],[LocationName] if (CustomerNumber != "") { if (CustType == CustomerType.BT || CustType == CustomerType.BTST) { dsValue = customerDetails.GetCustomerAddress(CustomerNumber); } else { dsValue = customerDetails.GetCustomerAddress(BillToCustomerNo); } if (dsValue != null && dsValue.Rows.Count > 0) { lblBillCity.Text = dsValue.Rows[0]["City"].ToString(); lblBillCountry.Text = dsValue.Rows[0]["Country"].ToString(); lblBillFax.Text = customerDetails.FormatPhoneFax(dsValue.Rows[0]["FaxPhoneNo"].ToString()); lblBillLine1.Text = dsValue.Rows[0]["AddrLine1"].ToString(); lblBillName.Text = dsValue.Rows[0]["CustName"].ToString(); lblBillPhone.Text = customerDetails.FormatPhoneFax(dsValue.Rows[0]["PhoneNo"].ToString()); lblBillToCustomerNumber.Text = dsValue.Rows[0]["CustNo"].ToString(); lblBillChangeDate.Text = (dsValue.Rows[0]["ChangeDt"].ToString() == "") ? "" : Convert.ToDateTime(dsValue.Rows[0]["ChangeDt"].ToString()).ToShortDateString(); lblBillChangeID.Text = dsValue.Rows[0]["ChangeID"].ToString(); lblBillEntryDate.Text = (dsValue.Rows[0]["EntryDt"].ToString() == "") ? "" : Convert.ToDateTime(dsValue.Rows[0]["EntryDt"].ToString()).ToShortDateString(); lblBillEntryID.Text = dsValue.Rows[0]["EntryID"].ToString(); lblCustMastChnageDt.Text = (dsValue.Rows[0]["CustMasterChangeDt"].ToString() == "") ? "" : Convert.ToDateTime(dsValue.Rows[0]["CustMasterChangeDt"].ToString()).ToShortDateString(); lblCustMastChangeID.Text = dsValue.Rows[0]["CustMasterChangeID"].ToString(); lblCustMastEntryDt.Text = (dsValue.Rows[0]["CustMasterEntryDt"].ToString() == "") ? "" : Convert.ToDateTime(dsValue.Rows[0]["CustMasterEntryDt"].ToString()).ToShortDateString(); lblCustMastEntryID.Text = dsValue.Rows[0]["CustMasterEntryID"].ToString(); tblEntryPanel.Visible = true; } else { ClearBillControls(); } if (CustType == CustomerType.BTST) { DataTable dtsoldto = customerDetails.GetCustomerSoldToAddress(CustomerNumber); if (dtsoldto != null && dtsoldto.Rows.Count > 0) { dsValue = dtsoldto.Copy(); } BindSoldToAddress(); } else if (CustType == CustomerType.ST) { dsValue = customerDetails.GetCustomerAddress(CustomerNumber); BindSoldToAddress(); } else { tdSoldAddress.Style.Add(HtmlTextWriterStyle.Display, "none"); } } else { ClearBillControls(); ClearSoldControls(); } }