protected void txtCustomerNumber_TextChanged(object sender, EventArgs e) { if (txtCustomerNumber.Text.Trim() != "") { string strCustNo = txtCustomerNumber.Text; int strCnt = 0; bool textIsNumeric = true; try { int.Parse(strCustNo); } catch { textIsNumeric = false; } if ((strCustNo != "") && !textIsNumeric) { if (isNumeric(strCustNo.Remove(strCustNo.Length - 1, 1), System.Globalization.NumberStyles.Integer) == false) { strCnt = Convert.ToInt32(cntCustName(strCustNo)); } else { strCnt = Convert.ToInt32(cntCustNo(strCustNo)); } int maxRowCount = customerDetail.GetSQLWarningRowCount(); if (strCnt < maxRowCount) { ScriptManager.RegisterClientScriptBlock(txtCustomerNumber, txtCustomerNumber.GetType(), "Customer", "LoadCustomerLookup('" + PFC.SOE.Securitylayer.Cryptor.Encrypt(strCustNo) + "');", true); } else { ScriptManager.RegisterClientScriptBlock(txtCustomerNumber, txtCustomerNumber.GetType(), "Customer", "alert('Maximum row exceeds for this search.please enter additional data.');", true); } } else { if (!customerDetail.IsValidCustomer(txtCustomerNumber.Text)) { utility.DisplayMessage(MessageType.Failure, invalidMessage, lblMessage); hidCustNo.Value = ""; txtCustomerNumber.Text = ""; } else { hidCustNo.Value = customerDetail.CustomerNumber; } } pnlStatusMessage.Update(); pnlPendingQuoteEntry.Update(); } else { utility.DisplayMessage(MessageType.Failure, "", lblMessage); hidCustNo.Value = ""; } ScriptManager.RegisterClientScriptBlock(txtCustomerNumber, txtCustomerNumber.GetType(), "tab", "document.getElementById(\"ddlOrderType\").focus();", true); }
/// <summary> /// Page Load Event Handler /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { Ajax.Utility.RegisterTypeForAjax(typeof(SOFind)); lblMessage.Text = ""; if (!IsPostBack) { //ShipLoc,SoNo,InventoryNo,PORef,Amount,Weight,Type,ShipDate,OrderDate,CustReq,Status,Carrier,CustomerNo ViewState["MaxRowCount"] = custDet.GetSQLWarningRowCount(); BindDropDown(); BindDataGrid(); dtpStatusStart.SelectedDate = DateTime.Now.AddDays(-7).ToShortDateString(); dtpStatusEnd.SelectedDate = DateTime.Now.ToShortDateString(); } PrintDialogue1.CustomerNo = txtCustomerNumber.Text; ExportSoFind(); // Set Print URL to User control PrintDialogue1.PageTitle = "SO Find for Customer #" + txtCustomerNumber.Text; }
public void BindCustomer() { try { int strCnt = 0; DataTable dtCustomer = new DataTable(); DataSet dsCustomer = service.GetCustomerSelect(customer.Replace("'", "''")); dtCustomer = dsCustomer.Tables[0]; // Filter DataTable dtCustomer.DefaultView.RowFilter = BindWhereClause(); strCnt = dtCustomer.DefaultView.ToTable().Rows.Count; dtCustomer = dtCustomer.DefaultView.ToTable(); int maxRowCount = custDetail.GetSQLWarningRowCount(); if (strCnt < maxRowCount) { if (dtCustomer.Rows.Count > 0) { if (hidSort.Value.Trim() != "") { dtCustomer.DefaultView.Sort = hidSort.Value; } else { dtCustomer.DefaultView.Sort = "CustName ASC"; } dgCustomerList.DataSource = dtCustomer; //dgCustomerList.DataBind(); gridPager.InitPager(dgCustomerList, 100); lblMessage.Visible = false; dgCustomerList.Visible = true;; } else { lblMessage.Text = "No record found"; lblMessage.Visible = true; dgCustomerList.Visible = false; } } else { lblMessage.Text = "Maximum rows exceeded. Please refine your filter with using the parameters above and then click Search."; lblMessage.Visible = true; dgCustomerList.Visible = false; } } catch (Exception ex) { lblMessage.Text = "No record found"; lblMessage.Visible = true; dgCustomerList.Visible = false; } pnlCustomerSearch.Update(); }
/// <summary>ear /// Function to load the customer details /// </summary> public void LoadCustomerDetails() { string strCustNo = custNumber = txtCustNo.Text; int strCnt = 0; if ((strCustNo != "") && (strCustNo.Contains("%") == true)) { if (isNumeric(strCustNo.Remove(strCustNo.Length - 1, 1), System.Globalization.NumberStyles.Integer) == false) { strCnt = Convert.ToInt32(cntCustName(strCustNo)); } else { strCnt = Convert.ToInt32(cntCustNo(strCustNo)); } int maxRowCount = custDet.GetSQLWarningRowCount(); if (strCnt < maxRowCount) { ScriptManager.RegisterClientScriptBlock(txtCustNo, txtCustNo.GetType(), "Customer", "LoadCustomerLookup('" + Server.UrlEncode(PFC.SOE.Securitylayer.Cryptor.Encrypt(strCustNo)) + "');", true); } else { ScriptManager.RegisterClientScriptBlock(txtCustNo, txtCustNo.GetType(), "Customer", "alert('Maximum row exceeds for this search.please enter additional data.');", true); } } else { if (strCustNo != "") { #region Code to fill the customer details in the controls // Call the webservice to get the customer address detail DataSet dsCustomer = orderEntry.GetCustomerDetails(txtCustNo.Text.Trim().Replace("'", "")); // Function to clear the value in the label ClearLabels(); if (dsCustomer != null && dsCustomer.Tables[0].Rows.Count != 0) { string creditStatus = ""; if (dsCustomer.Tables[0].Rows[0]["CustCd"].ToString() != "BT" && dsCustomer.Tables[0].Rows[0]["fBillToNo"].ToString() != "") { creditStatus = orderEntry.GetCreditReview(dsCustomer.Tables[0].Rows[0]["fBillToNo"].ToString().ToString(), dsCustomer.Tables[2].Rows[0]["CreditInd"].ToString().Trim(), "0", "Order"); if (creditStatus.ToUpper() == "OK") { hidCust.Value = txtCustNo.Text; Session["CustomerNumber"] = hidCust.Value.Trim(); Session["CustomerDetail"] = dsCustomer; CustPriceCode = dsCustomer.Tables[0].Rows[0]["Customer Price Code"].ToString().Trim(); CustomerName = dsCustomer.Tables[0].Rows[0]["Name"].ToString().Trim(); FillCustomerAddress(dsCustomer); lblCusNum.Text = hidCust.Value.Trim(); lblCustNum.Text = hidCust.Value.Trim(); lblChainValue.Text = dsCustomer.Tables[0].Rows[0]["Chain Name"].ToString().Trim(); lblBillCustNo.Text = dsCustomer.Tables[0].Rows[0]["fBillToNo"].ToString().Trim(); lblShip_Name.Text = dsCustomer.Tables[0].Rows[0]["Name"].ToString().Trim(); lblSold_Name.Text = dsCustomer.Tables[0].Rows[0]["Name"].ToString().Trim(); lblSoDate.Text = DateTime.Now.ToShortDateString(); // Code to bind the location details DataSet dsLocation = custDet.GetLocationDetails(); CreditInd = dsCustomer.Tables[2].Rows[0]["CreditInd"].ToString().Trim(); InsertHeaderDetail(); lblTermDesc.Text = termDesc; SetTermColor(); ISBillToCustomer = false; // txtSONumber.ReadOnly = true; txtCustNo.ReadOnly = true; } else { ScriptManager.RegisterClientScriptBlock(txtCustNo, typeof(TextBox), "invalid", "alert('" + creditStatus + "');", true); return; } } else { ISBillToCustomer = true; ScriptManager.RegisterClientScriptBlock(txtCustNo, typeof(TextBox), "invalid", "alert('Bill To Only Customer could not process order');document.getElementById('" + txtCustNo.ClientID + "').value='';document.getElementById('" + txtCustNo.ClientID + "').focus();document.getElementById('" + txtCustNo.ClientID + "').select();", true); } } else { hidCust.Value = ""; ScriptManager.RegisterClientScriptBlock(txtCustNo, typeof(TextBox), "invalid", "alert('Invalid Customer value');document.getElementById('" + txtCustNo.ClientID + "').value='';document.getElementById('" + txtCustNo.ClientID + "').focus();document.getElementById('" + txtCustNo.ClientID + "').select();", true); } #endregion } else { ClearLabels(); } } }
public void BindCustomer() { try { int strCnt = 0; DataTable dtCustomer = new DataTable(); DataSet dsCustomer = service.GetCustomerSelect(customer.Replace("'", "''")); dtCustomer = dsCustomer.Tables[0]; // Filter DataTable dtCustomer.DefaultView.RowFilter = BindWhereClause(); strCnt = dtCustomer.DefaultView.ToTable().Rows.Count; dtCustomer = dtCustomer.DefaultView.ToTable(); //if (isNumeric(customer.Remove(customer.Length - 1, 1), System.Globalization.NumberStyles.Integer) == false) // strCnt = Convert.ToInt32(cntCustName(customer)); //else // strCnt = Convert.ToInt32(cntCustNo(customer)); int maxRowCount = custDetail.GetSQLWarningRowCount(); if (strCnt < maxRowCount) { if (dtCustomer.Rows.Count > 0) { if (hidSort.Value.Trim() != "") { dtCustomer.DefaultView.Sort = hidSort.Value; } else { dtCustomer.DefaultView.Sort = "CustName ASC"; } dgCustomerList.DataSource = dtCustomer; dgCustomerList.DataBind(); lblMessage.Visible = false; dgCustomerList.Visible = true;; } else { lblMessage.Text = "No record found"; lblMessage.Visible = true; dgCustomerList.Visible = false; } } else { lblMessage.Text = "Maximum rows exceeded. Please refine your filter with using the parameters above and then click Search."; lblMessage.Visible = true; dgCustomerList.Visible = false; } } catch (Exception ex) { lblMessage.Text = "No record found"; lblMessage.Visible = true; dgCustomerList.Visible = false; } pnlCustomerSearch.Update(); }