public static bool Delete(Project_Location o) { pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter(); return ta.DeleteByID(o.id) == 0 ? false : true; }
public static bool UpdateByID(Project_Location o) { DateTime? d = null; o.modifydate = DateTime.Now; pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter(); int ret = ta.UpdateByID( o.location_id, o.details, o.createdate, o.modifydate, o.id ); if(ret == 1) return true; return false; }
public static bool Insert(Project_Location o) { o.createdate = o.modifydate = DateTime.Now; pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter(); o.id = Convert.ToInt32(ta.InsertQuery( o.id, o.location_id, o.details, o.createdate, o.modifydate )); return true; }
public static Project_Location GetByID(int id) { try{ pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter(); pmanAPI.App_Data.pmanDB.Project_LocationDataTable table = ta.GetDataByID(id); pmanAPI.App_Data.pmanDB.Project_LocationRow row = (pmanAPI.App_Data.pmanDB.Project_LocationRow)table.Rows[0]; return Project_Location.LoadFromModel(row); } catch(Exception){ return null; } }
public static List<Project_Location> GetAll() { pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter(); pmanAPI.App_Data.pmanDB.Project_LocationDataTable table = ta.GetData(); return LoadFromModel(table); }
public static bool Exists(int id) { pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_LocationTableAdapter(); if (ta.GetSumByID(id) == 0) return false; return true; }