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