public ContactTypeCollection FetchByQuery(Query qry) { ContactTypeCollection coll = new ContactTypeCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public ContactTypeCollection FetchAll() { ContactTypeCollection coll = new ContactTypeCollection(); Query qry = new Query(ContactType.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static AVManager.DAL.ContactTypeCollection GetContactTypeCollection(int varVendorID) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand( "SELECT * FROM ContactType INNER JOIN VendorContact ON " + "ContactType.ContactTypeID=VendorContact.ContactTypeID WHERE VendorContact.VendorID=@VendorID", Vendor.Schema.Provider.Name); cmd.AddParameter("@VendorID", varVendorID, DbType.Int32); IDataReader rdr = SubSonic.DataService.GetReader(cmd); ContactTypeCollection coll = new ContactTypeCollection(); coll.LoadAndCloseReader(rdr); return(coll); }
public static void SaveContactTypeMap(int varVendorID, ContactTypeCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM VendorContact WHERE VendorID=@VendorID", Vendor.Schema.Provider.Name); cmdDel.AddParameter("@VendorID", varVendorID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (ContactType item in items) { VendorContact varVendorContact = new VendorContact(); varVendorContact.SetColumnValue("VendorID", varVendorID); varVendorContact.SetColumnValue("ContactTypeID", item.GetPrimaryKeyValue()); varVendorContact.Save(); } }
public ContactTypeCollection FetchByID(object ContactTypeID) { ContactTypeCollection coll = new ContactTypeCollection().Where("ContactTypeID", ContactTypeID).Load(); return(coll); }