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);
}
