public ModelCustomer getCustomerByID(string ID) { using (DBAccess.DBAccess db = new DBAccess.DBAccess()) { string[,] param = { { "@Id", ID } }; using (SqlDataReader rdr = db.ExecuteReader("sprSelectCustomerByID", param)) { ModelCustomer item = new ModelCustomer(); while (rdr.Read()) { item.Id = Convert.ToInt32(rdr["Id"]); item.Name = rdr["Name"].ToString(); item.Address = rdr["Address"].ToString(); } return item; } } }
public DataTable getAllCustomer(string strWhere, string strOrderBy) { using (DBAccess.DBAccess db = new DBAccess.DBAccess()) { if (strOrderBy == "") { strOrderBy = " ORDER BY Id"; } string[,] param = { { "@strWhere", strWhere }, { "@strOrderBy", strOrderBy } }; using (SqlDataReader rdr = db.ExecuteReader("sprSelectAllCustomer", param)) { DataTable DT = new DataTable(); DT.Load(rdr); return DT; } } }