static bool Delete(Address p) { pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter(); return ta.DeleteByID(p.id) == 0 ? false : true; }
public static bool UpdateByID(Address o) { o.modifydate = DateTime.Now; pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter(); int ret = ta.UpdateByID( o.name, o.address_1, o.address_2, o.city, o.state, o.zip, o.contact_id, o.createdate , o.modifydate, o.id ); if(ret == 1) return true; return false; }
public static bool Insert(Address o) { o.createdate = o.modifydate = DateTime.Now; pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter(); o.id = Convert.ToInt32(ta.InsertQuery( o.name, o.address_1, o.address_2, o.city, o.state, o.zip, o.contact_id, o.createdate, o.modifydate )); return true; }
public static Address GetByID(int id) { try{ pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter(); pmanAPI.App_Data.pmanDB.AddressDataTable table = ta.GetDataByID(id); pmanAPI.App_Data.pmanDB.AddressRow row = (pmanAPI.App_Data.pmanDB.AddressRow)table.Rows[0]; return Address.LoadFromModel(row); } catch(Exception){ return null; } }
public static List<Address> GetAll() { pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter(); pmanAPI.App_Data.pmanDB.AddressDataTable table = ta.GetData(); return LoadFromModel(table); }
public static bool Exists(int id) { pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.AddressTableAdapter(); if (ta.GetSumByID(id) == 0) return false; return true; }