public void Update(Store storeObject)
{
using (var db = new CompaniesDBEntities())
{
db.Stores.Attach(storeObject);
db.Entry(storeObject).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Delete(Company companyObject)
{
using (var db = new CompaniesDBEntities())
{
Company companyItem = db.Companies.Find(companyObject.Id);
db.Companies.Remove(companyItem);
db.SaveChanges();
}
}
public void Delete(Store storeObject)
{
using (var db = new CompaniesDBEntities())
{
Store storeItem = db.Stores.Find(storeObject.Id);
db.Stores.Remove(storeItem);
db.Entry(storeItem).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void Add(Store storeObject)
{
using (var db = new CompaniesDBEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
db.Stores.Add(storeObject);
db.SaveChanges();
transaction.Commit();
}
}
}