static bool Delete(Contact p) { pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter(); return ta.DeleteByID(p.id) == 0 ? false : true; }
public static bool UpdateByID(Contact o) { o.modifydate = DateTime.Now; pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter(); int ret = ta.UpdateByID( o.firstname, o.lastname, o.address_id, o.phone, o.email, o.notes, o.createdate, o.modifydate, o.id ); if(ret == 1) return true; return false; }
public static bool Insert(Contact o) { o.createdate = o.modifydate = DateTime.Now; pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter(); o.id = Convert.ToInt32(ta.InsertQuery( o.firstname, o.lastname, o.address_id, o.phone, o.email, o.notes, o.createdate, o.modifydate )); return true; }
public static Contact GetByID(int id) { try{ pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter(); pmanAPI.App_Data.pmanDB.ContactDataTable table = ta.GetDataByID(id); pmanAPI.App_Data.pmanDB.ContactRow row = (pmanAPI.App_Data.pmanDB.ContactRow)table.Rows[0]; return Contact.LoadFromModel(row); } catch(Exception){ return null; } }
public static List<Contact> GetAll() { pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter(); pmanAPI.App_Data.pmanDB.ContactDataTable table = ta.GetData(); return LoadFromModel(table); }
public static bool Exists(int id) { pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ContactTableAdapter(); if (ta.GetSumByID(id) == 0) return false; return true; }