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;
}
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 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 Project_Crew GetByID(int id)
{
try{
pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter();
pmanAPI.App_Data.pmanDB.Project_CrewDataTable table = ta.GetDataByID(id);
pmanAPI.App_Data.pmanDB.Project_CrewRow row = (pmanAPI.App_Data.pmanDB.Project_CrewRow)table.Rows[0];
return Project_Crew.LoadFromModel(row);
}
catch(Exception){
return null;
}
}
public static List<Project_Crew> GetAll()
{
pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter();
pmanAPI.App_Data.pmanDB.Project_CrewDataTable table = ta.GetData();
return LoadFromModel(table);
}
public static bool Exists(int id)
{
pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_CrewTableAdapter();
if (ta.GetSumByID(id) == 0)
return false;
return true;
}
