void Reload() { using (var db = new DbDataContext()) { Raidb.BasketItem bi = db.BasketItems.SingleOrDefault(t => t.id == id); if (null != bi) { LoadFromDbBasketItem(bi); } } }
void LoadFromDbBasketItem(Raidb.BasketItem bi) { idMe = bi.idMe; SellType = (SellTypeEnum)Enum.ToObject(typeof(SellTypeEnum), bi.idSellType); idAbonentBasket = bi.idAbonentBaskets; isPurchased = bi.isPurchased; isRetrieved = bi.isRetrieved; price = bi.price; id = bi.id; }
public void Delete() { using (var db = new DbDataContext()) { Raidb.BasketItem bi = db.BasketItems.SingleOrDefault(t => t.id == id); if (null != bi) { db.BasketItems.DeleteOnSubmit(bi); db.SubmitChanges(); } } }
/// <summary> /// Creates new BasketItem in database /// </summary> public BasketItem(int idAbonentBasket, int idMe, SellTypeEnum sellType, decimal price) { this.idAbonentBasket = idAbonentBasket; this.idMe = idMe; this.sellType = sellType; this.price = price; using (var db = new DbDataContext()) { var bi = new Raidb.BasketItem { idAbonentBaskets = idAbonentBasket, idMe = idMe, idSellType = ((int) sellType), isPurchased = false, isRetrieved = false, price = price, dateModified = DateTime.Now, datePurchased = DateTime.Now }; db.BasketItems.InsertOnSubmit(bi); db.SubmitChanges(); id = bi.id; } }
/// <summary> /// Creates new BasketItem in database /// </summary> public BasketItem(int idAbonentBasket, int idMe, SellTypeEnum sellType, decimal price) { this.idAbonentBasket = idAbonentBasket; this.idMe = idMe; this.sellType = sellType; this.price = price; using (var db = new DbDataContext()) { var bi = new Raidb.BasketItem { idAbonentBaskets = idAbonentBasket, idMe = idMe, idSellType = ((int)sellType), isPurchased = false, isRetrieved = false, price = price, dateModified = DateTime.Now, datePurchased = DateTime.Now }; db.BasketItems.InsertOnSubmit(bi); db.SubmitChanges(); id = bi.id; } }
public BasketItem(Raidb.BasketItem bi) { id = bi.id; LoadFromDbBasketItem(bi); }