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