public static Projecttypes Load(System.Nullable<int> SysId) { resourceSchema.Dal.Projecttypes dbo = null; try { dbo = new resourceSchema.Dal.Projecttypes(); System.Data.DataSet ds = dbo.ProjectTypes_Select_One(SysId); Projecttypes obj = null; if (GlobalTools.IsSafeDataSet(ds)) { if ((ds.Tables[0].Rows.Count > 0)) { obj = new Projecttypes(); obj.Fill(ds.Tables[0].Rows[0]); } } return obj; } catch (System.Exception ) { throw; } finally { if ((dbo != null)) { dbo.Dispose(); } } }
public static ProjecttypesCollection GetAll() { resourceSchema.Dal.Projecttypes dbo = null; try { dbo = new resourceSchema.Dal.Projecttypes(); System.Data.DataSet ds = dbo.ProjectTypes_Select_All(); ProjecttypesCollection collection = new ProjecttypesCollection(); if (GlobalTools.IsSafeDataSet(ds)) { for (int i = 0; (i < ds.Tables[0].Rows.Count); i = (i + 1)) { Projecttypes obj = new Projecttypes(); 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(); } } }