static bool Update(Project_Crew j)
{
return UpdateByID(j);
}
public Project_Crew(Project_Crew o)
{
Copy(o);
}
static bool Delete(Project_Crew p)
{
pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter();
return ta.DeleteByID(p.project_id) == 0 ? false : true;
}
static Project_Crew LoadFromModel(pmanAPI.App_Data.pmanDB.Project_CrewRow row)
{
Project_Crew d = new Project_Crew();
LoadProject_Crew(row, d);
return d;
}
public void Copy(Project_Crew o)
{
this.project_id = o.project_id;
this.director = o.director;
this.camera = o.camera;
this.audio_tech = o.audio_tech;
this.gaffer = o.gaffer;
this.grip = o.grip;
this.script = o.script;
this.makeup = o.makeup;
this.notes = o.notes;
this.createdate = o.createdate;
this.modifydate = o.modifydate;
}
public bool Equals(Project_Crew o)
{
if(this.project_id != o.project_id)return false;
if(this.director != o.director)return false;
if(this.camera != o.camera)return false;
if(this.audio_tech != o.audio_tech)return false;
if(this.gaffer != o.gaffer)return false;
if(this.grip != o.grip)return false;
if(this.script != o.script)return false;
if(this.makeup != o.makeup)return false;
if(this.notes != o.notes)return false;
if(this.createdate.ToString() != o.createdate.ToString())return false;
if(this.modifydate.ToString() != o.modifydate.ToString())return false;
return true;
}
public static bool Save(Project_Crew j)
{
if (!Project_Crew.isValid(j))
return false;
if (Exists(j))
{
return Project_Crew.Update(j);
}
return Project_Crew.Insert(j);
}
public static bool UpdateByID(Project_Crew o)
{
o.modifydate = DateTime.Now;
pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter();
int ret = ta.UpdateByID(
o.director,
o.camera,
o.audio_tech,
o.gaffer,
o.grip,
o.script,
o.makeup,
o.notes,
o.createdate,
o.modifydate,
o.project_id
);
if(ret == 1) return true;
return false;
}
public static bool Remove(Project_Crew j)
{
if (Exists(j))
{
return Delete(j);
}
return false;
}
public static void LoadProject_Crew(pmanAPI.App_Data.pmanDB.Project_CrewRow row, Project_Crew d)
{
try { d.project_id = row.project_id; }
catch (Exception) { }
try { d.director = row.director; }
catch (Exception) { }
try { d.camera = row.camera; }
catch (Exception) { }
try { d.audio_tech = row.audio_tech; }
catch (Exception) { }
try { d.gaffer = row.gaffer; }
catch (Exception) { }
try { d.grip = row.grip; }
catch (Exception) { }
try { d.script = row.script; }
catch (Exception) { }
try { d.makeup = row.makeup; }
catch (Exception) { }
try { d.notes = row.notes; }
catch (Exception) { }
try { d.createdate = row.createdate; }
catch (Exception) { }
try { d.modifydate = row.modifydate; }
catch (Exception) { }
}
public static bool isValid(Project_Crew o)
{
//if (o.project_id == 0)
// return false;
return true;
}
public static bool Insert(Project_Crew o)
{
o.createdate = o.modifydate = DateTime.Now;
pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter();
ta.InsertQuery(
o.project_id,
o.director,
o.camera,
o.audio_tech,
o.gaffer,
o.grip,
o.script,
o.makeup,
o.notes,
o.createdate,
o.modifydate
);
return true;
}
public static bool Exists(Project_Crew o)
{
return Exists(o.project_id);
}
