public static ItemClassCollection GetbyUser(string CreatedUser) { ItemClassCollection collection = new ItemClassCollection(); ItemClass obj; using (var reader = SqlHelper.ExecuteReader("tblItemClass_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static ItemClassCollection GetAllItem() { ItemClassCollection collection = new ItemClassCollection(); using (var reader = SqlHelper.ExecuteReader("tblItemClass_GetAll", null)) { while (reader.Read()) { ItemClass obj = new ItemClass(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }