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