public IllustrationCollection FetchByQuery(Query qry)
{
IllustrationCollection coll = new IllustrationCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public IllustrationCollection FetchAll()
{
IllustrationCollection coll = new IllustrationCollection();
Query qry = new Query(Illustration.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static AVManager.DAL.IllustrationCollection GetIllustrationCollection(int varProductModelID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Illustration INNER JOIN ProductModelIllustration ON " +
"Illustration.IllustrationID=ProductModelIllustration.IllustrationID WHERE ProductModelIllustration.ProductModelID=@ProductModelID", ProductModel.Schema.Provider.Name);
cmd.AddParameter("@ProductModelID", varProductModelID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
IllustrationCollection coll = new IllustrationCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static void SaveIllustrationMap(int varProductModelID, IllustrationCollection items)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductModelIllustration WHERE ProductModelID=@ProductModelID", ProductModel.Schema.Provider.Name);
cmdDel.AddParameter("@ProductModelID", varProductModelID);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (Illustration item in items)
{
ProductModelIllustration varProductModelIllustration = new ProductModelIllustration();
varProductModelIllustration.SetColumnValue("ProductModelID", varProductModelID);
varProductModelIllustration.SetColumnValue("IllustrationID", item.GetPrimaryKeyValue());
varProductModelIllustration.Save();
}
}
public IllustrationCollection FetchByID(object IllustrationID)
{
IllustrationCollection coll = new IllustrationCollection().Where("IllustrationID", IllustrationID).Load();
return(coll);
}