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