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; }