public static Projects Load(System.Nullable<int> SysId) {
resourceSchema.Dal.Projects dbo = null;
try {
dbo = new resourceSchema.Dal.Projects();
System.Data.DataSet ds = dbo.Projects_Select_One(SysId);
Projects obj = null;
if (GlobalTools.IsSafeDataSet(ds)) {
if ((ds.Tables[0].Rows.Count > 0)) {
obj = new Projects();
obj.Fill(ds.Tables[0].Rows[0]);
}
}
return obj;
}
catch (System.Exception ) {
throw;
}
finally {
if ((dbo != null)) {
dbo.Dispose();
}
}
}
public static ProjectsCollection GetAll() {
resourceSchema.Dal.Projects dbo = null;
try {
dbo = new resourceSchema.Dal.Projects();
System.Data.DataSet ds = dbo.Projects_Select_All();
ProjectsCollection collection = new ProjectsCollection();
if (GlobalTools.IsSafeDataSet(ds)) {
for (int i = 0; (i < ds.Tables[0].Rows.Count); i = (i + 1)) {
Projects obj = new Projects();
obj.Fill(ds.Tables[0].Rows[i]);
if ((obj != null)) {
collection.Add(obj);
}
}
}
return collection;
}
catch (System.Exception ) {
throw;
}
finally {
if ((dbo != null)) {
dbo.Dispose();
}
}
}