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;
}
}
public string CheckCustomer(string custNo)
{
try
{
DataSet dsCustDetail = customerDetails.GetDataToDateset("CustomerMaster (NOLOCK)", "pCustMstrID,fBillToNo,CustCd,CustNo", "CustNo='" + custNo + "' or CustSearchKey='" + custNo + "'");
Session["CustometDetail"] = dsCustDetail;
if (dsCustDetail != null && dsCustDetail.Tables[0].Rows.Count > 0)
{
DataTable dtLock = customerDetails.CustomerLock("Lock", dsCustDetail.Tables[0].Rows[0][0].ToString().Trim());
if (dtLock != null && dtLock.Rows.Count > 0)
{
return(dtLock.Rows[0][0].ToString().Trim() + "~" + dtLock.Rows[0][1].ToString().Trim() + "~" + custNo);
}
else
{
return("");
}
}
else
{
return("");
}
}
catch (Exception ex) { return(""); }
}
public void GetSearch()
{
try
{
DataSet dsCustomer = (DataSet)customerDetails.GetDataToDateset("CustomerMaster (NOLOCK) ", "pCustMstrID,fBillToNo,CustCd,CustNo", "CustNo='" + CustomerNumber + "' or CustSearchKey='" + CustomerNumber + "'");;
if (dsCustomer != null && dsCustomer.Tables[0].Rows.Count > 0)
{
customerDetails.ReleaseLock();
customerDetails.SetLock(dsCustomer.Tables[0].Rows[0]["pCustMstrID"].ToString().Trim());
CustomerID = dsCustomer.Tables[0].Rows[0]["pCustMstrID"].ToString().Trim();
CustomerNumber = dsCustomer.Tables[0].Rows[0]["CustNo"].ToString().Trim();
txtCustomer.Text = dsCustomer.Tables[0].Rows[0]["CustNo"].ToString().Trim();
BillToCustomerNo = dsCustomer.Tables[0].Rows[0]["fBillToNo"].ToString().Trim();
string customerCd = dsCustomer.Tables[0].Rows[0]["CustCd"].ToString().Trim();
if (BillToCustomerNo == "" && customerCd.ToUpper() == "BT")
{
CustType = CustomerType.BT;
BillToCustomerNo = CustomerNumber;
BillToCustomerID = CustomerID;
}
else if (BillToCustomerNo == CustomerNumber && customerCd.ToUpper() == "BTST")
{
CustType = CustomerType.BTST;
BillToCustomerNo = CustomerNumber;
BillToCustomerID = CustomerID;
}
else if (BillToCustomerNo != CustomerNumber && customerCd.ToUpper() == "ST")
{
CustType = CustomerType.ST;
DataSet dsBillToCustomer = customerDetails.GetDataToDateset("CustomerMaster (NOLOCK) ", "pCustMstrID,fBillToNo,CustCd,CustNo", "CustNo='" + BillToCustomerNo + "'");
if (dsBillToCustomer != null && dsBillToCustomer.Tables[0].Rows.Count > 0)
{
BillToCustomerID = dsBillToCustomer.Tables[0].Rows[0]["pCustMstrID"].ToString();
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(txtCustomer, txtCustomer.GetType(), "Customer", "alert('Invalid Customer.');document.getElementById('" + txtCustomer.ClientID + "').focus();document.getElementById('" + txtCustomer.ClientID + "').select();", true);
}
}
catch (Exception ex)
{
}
}
/// <summary>
/// Function to bind the location details
/// </summary>
/// <param name="vendorNumber"></param>
public void BindLocationDetails()
{
try
{
MenuFrameTV.Nodes.Clear();
DataSet dsCustomer = customerDetails.GetDataToDateset("CustomerMaster (NOLOCK) ", "'Code - '+CustNo as 'Name',CustNo", "pCustMstrID=" + BillToCustomerID);
if (dsCustomer != null && dsCustomer.Tables[0].Rows.Count > 0)
{
dsDetails = customerDetails.GetTreeviewDetails(dsCustomer.Tables[0].Rows[0]["CustNo"].ToString());
TreeNode tvCaption = new TreeNode(dsCustomer.Tables[0].Rows[0]["Name"].ToString().Trim(), dsCustomer.Tables[0].Rows[0]["Name"].ToString().Trim());
MenuFrameTV.Nodes.Add(tvCaption);
tvCaption.SelectAction = TreeNodeSelectAction.Expand;
TreeNode tvSoldTo = new TreeNode("<div style=\"cursor:hand;\" onclick=\"javascript:BindDetails('0','ST','Add');\">Sold To <span style=\"color:red;\">" + ((Session["SecurityCode"].ToString().Trim() == "" || Session["CustomerLock"].ToString().Trim() == "L") ? "" : "New") + "</span></div>", "Sold To");
tvCaption.ChildNodes.Add(tvSoldTo);
tvSoldTo.SelectAction = TreeNodeSelectAction.Expand;
if (dsDetails != null && dsDetails.Tables[0].Rows.Count > 0)
{
MenuFrameTV.Style.Add(HtmlTextWriterStyle.Display, "");
//if (CustType == CustomerType.BTST)
//{
// DataRow dr = dsDetails.Tables[0].NewRow();
// dr[""]
//}
Session["SoldToAddressCount"] = dsDetails.Tables[0].Rows.Count.ToString();
DataTable dtShipTo = dsDetails.Tables[1].Copy();
foreach (DataRow dr in dsDetails.Tables[0].Rows)
{
TreeNode tvSold = new TreeNode("<div style=\"cursor:hand;\" onclick=\"javascript:BindDetails('" + dr["pCustMstrID"].ToString().Trim() + "','ST','Edit');\">" + dr["Name"].ToString().Trim() + "</div>", dr["Name"].ToString().Trim());
tvSoldTo.ChildNodes.Add(tvSold);
tvSold.SelectAction = TreeNodeSelectAction.Expand;
if (dtShipTo != null && dtShipTo.Rows.Count > 0)
{
dtShipTo.DefaultView.RowFilter = "fCustomerMasterID=" + dr["pCustMstrID"].ToString().Trim();
DataTable dtCurrent = dtShipTo.DefaultView.ToTable();
foreach (DataRow drow in dtCurrent.Rows)
{
TreeNode tvShip = new TreeNode("<div style=\"cursor:hand;\" onclick=\"javascript:BindDetails('" + drow["pCustomerAddressID"].ToString().Trim() + "~" + drow["fCustomerMasterID"].ToString().Trim() + "','SH','Edit');\">" + dr["CustNo"].ToString() + " - " + drow["Name"].ToString().Trim() + "</div>", drow["Name"].ToString().Trim());
tvSold.ChildNodes.Add(tvShip);
tvShip.SelectAction = TreeNodeSelectAction.Expand;
}
}
if (Session["SecurityCode"].ToString().Trim() != "" && Session["CustomerLock"].ToString().Trim() != "L")
{
TreeNode tvNewShip = new TreeNode("<div style=\"color:red;cursor:Hand;\" onclick=\"javascript:BindDetails('" + dr["pCustMstrID"].ToString().Trim() + "','SH','Add');\">New Ship To</div>", "New Ship To");
tvSold.ChildNodes.Add(tvNewShip);
tvNewShip.SelectAction = TreeNodeSelectAction.Expand;
}
// }
}
}
else
{
Session["SoldToAddressCount"] = "0";
}
}
else
{
MenuFrameTV.Style.Add(HtmlTextWriterStyle.Display, "none");
}
}
catch (Exception ex) { }
}
