public virtual void Update() { resourceSchema.Dal.Projectstatus dbo = null; try { dbo = new resourceSchema.Dal.Projectstatus(); dbo.ProjectStatus_Update(this.Sysid, this.Publicid, this.Path, this.Createdate, this.Lastmodifieddate, this.Active); } catch (System.Exception ) { throw; } finally { if ((dbo != null)) { dbo.Dispose(); } } }
public virtual void Delete() { resourceSchema.Dal.Projectstatus dbo = null; try { dbo = new resourceSchema.Dal.Projectstatus(); dbo.ProjectStatus_Delete(this.Sysid); } catch (System.Exception ) { throw; } finally { if ((dbo != null)) { dbo.Dispose(); } } }
public static Projectstatus Load(System.Nullable<int> SysId) { resourceSchema.Dal.Projectstatus dbo = null; try { dbo = new resourceSchema.Dal.Projectstatus(); System.Data.DataSet ds = dbo.ProjectStatus_Select_One(SysId); Projectstatus obj = null; if (GlobalTools.IsSafeDataSet(ds)) { if ((ds.Tables[0].Rows.Count > 0)) { obj = new Projectstatus(); obj.Fill(ds.Tables[0].Rows[0]); } } return obj; } catch (System.Exception ) { throw; } finally { if ((dbo != null)) { dbo.Dispose(); } } }
public virtual void Load() { resourceSchema.Dal.Projectstatus dbo = null; try { dbo = new resourceSchema.Dal.Projectstatus(); System.Data.DataSet ds = dbo.ProjectStatus_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 static ProjectstatusCollection GetAll() { resourceSchema.Dal.Projectstatus dbo = null; try { dbo = new resourceSchema.Dal.Projectstatus(); System.Data.DataSet ds = dbo.ProjectStatus_Select_All(); ProjectstatusCollection collection = new ProjectstatusCollection(); if (GlobalTools.IsSafeDataSet(ds)) { for (int i = 0; (i < ds.Tables[0].Rows.Count); i = (i + 1)) { Projectstatus obj = new Projectstatus(); 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(); } } }