static void DeleteModel(int modelId)
{
using (var db = new BikeStoreContext())
{
var model = new Model { ModelId = modelId };
db.Models.Attach(model);
db.Models.Remove(model);
db.SaveChanges();
}
}
static int CreateModel()
{
int modelId = 0;
using (var db = new BikeStoreContext())
{
// Use stored procedure mapping
var model = new Model { Name = "Domane 5.2", ListPrice = 3499.99m };
db.Models.Add(model);
db.SaveChanges();
modelId = model.ModelId;
// Call sproc directly - not recommended ...
// to get the following to work, need to
// A) remove @Modelid output param from product.modelInsert
// B) change the identity select after insert to select all fields for loading into model
/*
var name = new SqlParameter("@name","Domane 5.2");
var manufacturerCode = new SqlParameter("@manufacturercode", DBNull.Value);
var categoryid = new SqlParameter("@categoryid", System.Data.SqlDbType.Int);
categoryid.Value = DBNull.Value;
var description = new SqlParameter("@description",DBNull.Value);
var features = new SqlParameter("@features", DBNull.Value);
var statusid = new SqlParameter("@statusid", System.Data.SqlDbType.Int);
statusid.Value = DBNull.Value;
var manufacturerid = new SqlParameter("@manufacturerid", System.Data.SqlDbType.Int);
manufacturerid.Value = DBNull.Value;
var listprice = new SqlParameter("@listprice", 3499.99m);
var imagecollection = new SqlParameter("@imagecollection", DBNull.Value);
var CategoryCustomData = new SqlParameter("@CategoryCustomData", DBNull.Value);
var ManufacturerCustomData = new SqlParameter("@ManufacturerCustomData", DBNull.Value);
var result = db.Database.SqlQuery<Model>("product.modelInsert @name, @manufacturercode, @categoryid, @Description, @features,@statusid, @manufacturerid, @listprice,@imagecollection,@CategoryCustomData, @ManufacturerCustomDAta",
name, manufacturerCode, categoryid, description, features, statusid, manufacturerid, listprice, imagecollection, CategoryCustomData, ManufacturerCustomData).SingleOrDefault();
modelId = result.ModelId;
*/
}
Console.WriteLine("New Model: " + modelId);
return modelId;
}
