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) { } }