public override ObservableCollection <Sales> Load()
{
using (WholesaleStoreEntities db = new WholesaleStoreEntities())
{
var sales = db.Sales.Include("Products").Include("Sellers").ToList();
return(new ObservableCollection <Sales>(sales));
}
}
public override ObservableCollection <Products> Load()
{
using (WholesaleStoreEntities db = new WholesaleStoreEntities())
{
var products = db.Products.Include("UnitStorages").ToList();
return(new ObservableCollection <Products>(products));
}
}
public override ObservableCollection <Sellers> Load()
{
using (WholesaleStoreEntities db = new WholesaleStoreEntities())
{
db.Sellers.Load();
var sellers = db.Sellers.Local;
return(new ObservableCollection <Sellers>(sellers));
}
}
public override void Update(Sellers obj)
{
using (WholesaleStoreEntities db = new WholesaleStoreEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
public override void Add(Sellers obj)
{
using (WholesaleStoreEntities db = new WholesaleStoreEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Sellers.Add(obj);
db.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
public override void Delete(int id)
{
using (WholesaleStoreEntities db = new WholesaleStoreEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var product = db.Products.Find(id);
db.Entry(product).State = EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
public override void Add(Products obj)
{
using (WholesaleStoreEntities db = new WholesaleStoreEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
obj.UnitStorages = null;
db.Products.Add(obj);
db.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
