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);
}
