public static CompanyEventCollection GetbyUser(string CreatedUser) { CompanyEventCollection collection = new CompanyEventCollection(); //CompanyEvent obj; using (var reader = SqlHelper.ExecuteReader("tblCompanyEvent_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { collection.Add(GetItemFromReader(reader)); } } return(collection); }
public static CompanyEventCollection GetAllByGroupCode(string GroupCode) { CompanyEventCollection collection = new CompanyEventCollection(); using (var reader = SqlHelper.ExecuteReader("tblCompanyEvent_GetAllbyGroupCode", new SqlParameter("@GroupCode", GroupCode))) { while (reader.Read()) { CompanyEvent obj = new CompanyEvent(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static CompanyEventCollection GetAllItem() { CompanyEventCollection collection = new CompanyEventCollection(); using (var reader = SqlHelper.ExecuteReader("tblCompanyEvent_GetAll", null)) { while (reader.Read()) { CompanyEvent obj = new CompanyEvent(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }