public ourCustomerList SearchRecord(string updateitem, string itemdetail) { ourCustomerList searchresult = new ourCustomerList(); SqlDataReader sqlsearchresult; var sqlsearchcustomer = "SELECT * FROM customer WHERE " + updateitem.ToLower() + " = @_Detail"; try { using (var cmd = new SqlCommand(sqlsearchcustomer, conn)) { cmd.Parameters.AddWithValue("@_Detail", itemdetail); sqlsearchresult = cmd.ExecuteReader(); if (sqlsearchresult.HasRows) { while (sqlsearchresult.Read()) { DateTime dt = DateTime.Parse(sqlsearchresult[DOB].ToString()); ourCustomer acustomer = new ourCustomer(int.Parse(sqlsearchresult[CUSTOMERID].ToString())); acustomer.FirstName = sqlsearchresult[FRISTNAME].ToString(); acustomer.LastName = sqlsearchresult[LASTNAME].ToString(); acustomer.Email = sqlsearchresult[EMAIL].ToString(); acustomer.Website = sqlsearchresult[WEBSITE].ToString(); acustomer.DOB = dt.Day + "-" + dt.Month + "-" + dt.Year; acustomer.LoyaltyMember = (sqlsearchresult[LOYALTYMEMBER].ToString().CompareTo("True") == 0) ? "true" : "false"; acustomer.Phone = sqlsearchresult[PHONE].ToString(); acustomer.Mobile = sqlsearchresult[MOBILE].ToString(); acustomer.Fax = sqlsearchresult[FAX].ToString(); acustomer.MemberCard = sqlsearchresult[MEMBERCARD].ToString(); // searchresult.Addcustomer(acustomer); } } } if (searchresult != null) { return(searchresult); } else { throw new ApplicationException("[Error] Cannot retrieve the data!"); } } catch { throw new ApplicationException("[Error] Cannot retrieve the SQL server!"); } }
public ourCustomerList RetrievalCustomerList(string sortItem, Boolean desc) {//SELECT * FROM CUSTOMER ORDER BY firstname DESC; ourCustomerList customerlist = new ourCustomerList(); string storMode = (desc == true) ? "DESC" : "ASC"; var sqlgetcustomerlist = "SELECT * FROM CUSTOMER ORDER BY " + sortItem + " " + storMode; SqlDataReader customerreader; using (var cmd = new SqlCommand(sqlgetcustomerlist, conn)) { customerreader = cmd.ExecuteReader(); if (customerreader.HasRows) { while (customerreader.Read()) { DateTime dt = DateTime.Parse(customerreader[DOB].ToString()); ourCustomer acustomer = new ourCustomer(int.Parse(customerreader[CUSTOMERID].ToString())); acustomer.FirstName = customerreader[FRISTNAME].ToString(); acustomer.LastName = customerreader[LASTNAME].ToString(); acustomer.Email = customerreader[EMAIL].ToString(); acustomer.Website = customerreader[WEBSITE].ToString(); acustomer.DOB = dt.Day + "-" + dt.Month + "-" + dt.Year; acustomer.LoyaltyMember = (customerreader[LOYALTYMEMBER].ToString().CompareTo("True") == 0) ? "true" : "false"; acustomer.Phone = customerreader[PHONE].ToString(); acustomer.Mobile = customerreader[MOBILE].ToString(); acustomer.Fax = customerreader[FAX].ToString(); acustomer.MemberCard = customerreader[MEMBERCARD].ToString(); customerlist.Addcustomer(acustomer); } return(customerlist); } else { throw new ApplicationException("[Error] Cannot retrieve the data!"); } } }