public CategoryList GetAll()
{
Database database = new Database("Customer");
database.Command.Parameters.Clear();
database.Command.CommandType = CommandType.StoredProcedure;
database.Command.CommandText = "tblCategoryGetAll";
DataTable dt = database.ExecuteQuery();
Category select = new Category();
select.Id = Guid.Empty;
select.Name = "-- Please Select a Category --";
_List.Add(select);
foreach (DataRow dr in dt.Rows)
{
Category ca = new Category();
ca.Initialize(dr);
ca.InitializeBusinessData(dr);
ca.IsNew = false;
ca.IsDirty = false;
ca.Savable += Category_Savable;
_List.Add(ca);
}
return(this);
}
