protected void GetCustomerDetails() { var oCustomerDetails = new clsCustomerMaintenance(); var ldata = oCustomerDetails.RetrieveCustomerDetails(ddSearchBy.Text.Trim(), txtSearch.Text); grvCustomerDetails.DataSource = null; grvCustomerDetails.DataBind(); grvCustomerDetails.DataSource = ldata; grvCustomerDetails.DataBind(); grvCustomerDetails.GridLines = GridLines.None; }
public List <clsCustomerMaintenance> RetrieveCustomerDetails(string searchby, string searchname) { StringBuilder sQuery = new StringBuilder(); sQuery.Append("SELECT idCustomer, Customer_Code, Customer_Name, Address1, Address2, Address3, "); sQuery.Append("Address4, credit_term, Company_Name, Status, AddressShipping1, AddressShipping2, "); sQuery.Append("AddressShipping3, AddressShipping4, Customer_Type, Credit_Limit, "); sQuery.Append("Position, Contact_Number, TIN_Number, Salesman, Email_Address FROM a_Customer_Details "); if (searchby == "Customer Code") { sQuery.Append("WHERE Customer_Code LIKE '%" + searchname + "%' "); } else if (searchby == "Customer Name") { sQuery.Append("WHERE Customer_Name LIKE '%" + searchname + "%' "); } else if (searchby == "Company Name") { sQuery.Append("WHERE Company_Name LIKE '%" + searchname + "%' "); } sQuery.Append("ORDER BY Customer_Code ASC"); List <clsCustomerMaintenance> lData = new List <clsCustomerMaintenance>(); try { var oreader = execReader(sQuery.ToString()); while (oreader.Read()) { clsCustomerMaintenance obj = new clsCustomerMaintenance(); obj.idCustomer = oreader["idCustomer"].ToString(); obj.Customer_Code = oreader["Customer_Code"].ToString(); obj.Customer_Name = oreader["Customer_Name"].ToString(); obj.Address1 = oreader["Address1"].ToString(); obj.Address2 = oreader["Address2"].ToString(); obj.Address3 = oreader["Address3"].ToString(); obj.Address4 = oreader["Address4"].ToString(); obj.FullAddress = oreader["Address1"].ToString() + ", " + oreader["Address2"].ToString(); obj.credit_term = oreader["credit_term"].ToString(); obj.Company_Name = oreader["Company_Name"].ToString(); obj.Status = oreader["Status"].ToString(); obj.AddressShipping1 = oreader["AddressShipping1"].ToString(); obj.AddressShipping2 = oreader["AddressShipping2"].ToString(); obj.AddressShipping3 = oreader["AddressShipping3"].ToString(); obj.AddressShipping4 = oreader["AddressShipping4"].ToString(); obj.Customer_Type = oreader["Customer_Type"].ToString(); obj.Credit_Limit = oreader["Credit_Limit"].ToString(); obj.Position = oreader["Position"].ToString(); obj.Contact_Number = oreader["Contact_Number"].ToString(); obj.TIN_Number = oreader["TIN_Number"].ToString(); obj.Salesman = oreader["Salesman"].ToString(); obj.Email_Address = oreader["Email_Address"].ToString(); lData.Add(obj); } } catch (Exception ex) { //message } finally { CloseNewConnection(); } return(lData); }