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