public static PMProjectCollection GetbyUser(string CreatedUser) { PMProjectCollection collection = new PMProjectCollection(); PMProject obj; using (var reader = SqlHelper.ExecuteReader("PMProject_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static PMProjectCollection GetAllItem(int CompanyID) { PMProjectCollection collection = new PMProjectCollection(); var sqlParams = new SqlParameter[] { new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("PMProject_GetAll", sqlParams)) { while (reader.Read()) { PMProject obj = new PMProject(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }