public void SaveItems(IEnumerable <ShoppingCartItem> items) { //run this in a transaction var cmds = new List <DbCommand>(); foreach (var item in this.OrderItems) { cmds.Add(item.GetDeleteCommand()); } //now add in these items foreach (var item in items) { var newItem = new OrderItem(); newItem.SKU = item.Product.SKU; newItem.OrderID = this.OrderID; newItem.Quantity = item.Quantity; newItem.DateAdded = item.DateAdded; newItem.Discount = item.Discount; newItem.DiscountReason = item.DiscountReason; cmds.Add(newItem.GetInsertCommand()); } var db = new KonaDB(); db.ExecuteTransaction(cmds); }
public ActionResult Create(FormCollection form) { Widget newWidget = new Widget(); UpdateModel<Widget>(newWidget); //the category ID should be sent in as "categoryid" string categoryID = form["CategoryID"]; var widgetCommand = newWidget.GetInsertCommand(); //save the category too Categories_Widget map = new Categories_Widget(); int catid = 0; int.TryParse(categoryID, out catid); map.CategoryID = catid; map.WidgetID = newWidget.WidgetID; var mapCommand = map.GetInsertCommand(); KonaDB db = new KonaDB(); db.ExecuteTransaction(new List<DbCommand>() { widgetCommand, mapCommand }); //return a json result with the ID return Json(new { ID = newWidget.WidgetID, Zone = newWidget.Zone }); }
public ActionResult Create(FormCollection form) { Widget newWidget = new Widget(); UpdateModel <Widget>(newWidget); //the category ID should be sent in as "categoryid" string categoryID = form["CategoryID"]; var widgetCommand = newWidget.GetInsertCommand(); //save the category too Categories_Widget map = new Categories_Widget(); int catid = 0; int.TryParse(categoryID, out catid); map.CategoryID = catid; map.WidgetID = newWidget.WidgetID; var mapCommand = map.GetInsertCommand(); KonaDB db = new KonaDB(); db.ExecuteTransaction(new List <DbCommand>() { widgetCommand, mapCommand }); //return a json result with the ID return(Json(new { ID = newWidget.WidgetID, Zone = newWidget.Zone })); }
public void SaveWidgetOrder() { var commands = new List <DbCommand>(); KonaDB db = new KonaDB(); if (Request.Form["widgetid"] != null) { //pull out all widgetid's var ids = Request.Form.GetValues("widgetid").Where(x => !String.IsNullOrEmpty(x)).ToArray(); int listOrder = 0; foreach (var id in ids) { var widgetID = new Guid(id); //subsonic style... commands.Add(db.Update <Widget>().Set(x => x.ListOrder == listOrder).Where(x => x.WidgetID == widgetID).GetCommand().ToDbCommand()); listOrder++; } } //transaction :) db.ExecuteTransaction(commands); }
public void SaveItems(IEnumerable<ShoppingCartItem> items) { //run this in a transaction var cmds = new List<DbCommand>(); foreach (var item in this.OrderItems) { cmds.Add(item.GetDeleteCommand()); } //now add in these items foreach (var item in items) { var newItem = new OrderItem(); newItem.SKU = item.Product.SKU; newItem.OrderID = this.OrderID; newItem.Quantity = item.Quantity; newItem.DateAdded = item.DateAdded; newItem.Discount = item.Discount; newItem.DiscountReason = item.DiscountReason; cmds.Add(newItem.GetInsertCommand()); } var db = new KonaDB(); db.ExecuteTransaction(cmds); }
public void SaveWidgetOrder() { var commands = new List<DbCommand>(); KonaDB db = new KonaDB(); if (Request.Form["widgetid"] != null) { //pull out all widgetid's var ids = Request.Form.GetValues("widgetid").Where(x => !String.IsNullOrEmpty(x)).ToArray(); int listOrder = 0; foreach (var id in ids) { var widgetID = new Guid(id); //subsonic style... commands.Add(db.Update<Widget>().Set(x => x.ListOrder == listOrder).Where(x=>x.WidgetID==widgetID).GetCommand().ToDbCommand()); listOrder++; } } //transaction :) db.ExecuteTransaction(commands); }