public static ProjectattributesCollection Select_ProjectAttributess_By_ProjectSysId(System.Nullable<int> ProjectSysId) { resourceSchema.Dal.Projectattributes dbo = null; try { dbo = new resourceSchema.Dal.Projectattributes(); System.Data.DataSet ds = dbo.Select_ProjectAttributess_By_ProjectSysId(ProjectSysId); ProjectattributesCollection collection = new ProjectattributesCollection(); if (GlobalTools.IsSafeDataSet(ds)) { for (int i = 0; (i < ds.Tables[0].Rows.Count); i = (i + 1)) { Projectattributes obj = new Projectattributes(); 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(); } } }
public virtual void Update() { resourceSchema.Dal.Projectattributes dbo = null; try { dbo = new resourceSchema.Dal.Projectattributes(); dbo.ProjectAttributes_Update(this.Sysid, this._projectsysid, this.Createdate, this.Lastmodifieddate, this.Description); } catch (System.Exception ) { throw; } finally { if ((dbo != null)) { dbo.Dispose(); } } }
public virtual void Load() { resourceSchema.Dal.Projectattributes dbo = null; try { dbo = new resourceSchema.Dal.Projectattributes(); System.Data.DataSet ds = dbo.ProjectAttributes_Select_One(this.Sysid); if (GlobalTools.IsSafeDataSet(ds)) { if ((ds.Tables[0].Rows.Count > 0)) { this.Fill(ds.Tables[0].Rows[0]); } } } catch (System.Exception ) { throw; } finally { if ((dbo != null)) { dbo.Dispose(); } } }
public virtual void Delete() { resourceSchema.Dal.Projectattributes dbo = null; try { dbo = new resourceSchema.Dal.Projectattributes(); dbo.ProjectAttributes_Delete(this.Sysid); } catch (System.Exception ) { throw; } finally { if ((dbo != null)) { dbo.Dispose(); } } }
public static Projectattributes Load(System.Nullable<int> SysId) { resourceSchema.Dal.Projectattributes dbo = null; try { dbo = new resourceSchema.Dal.Projectattributes(); System.Data.DataSet ds = dbo.ProjectAttributes_Select_One(SysId); Projectattributes obj = null; if (GlobalTools.IsSafeDataSet(ds)) { if ((ds.Tables[0].Rows.Count > 0)) { obj = new Projectattributes(); obj.Fill(ds.Tables[0].Rows[0]); } } return obj; } catch (System.Exception ) { throw; } finally { if ((dbo != null)) { dbo.Dispose(); } } }