public int getNumberOfStores()
{
using (var db = new CompaniesDBEntities())
{
return(db.Stores.Count());
}
}
//Finds a particular store
public Store Read(Guid Id)
{
using (var db = new CompaniesDBEntities())
{
db.Companies.Load();
return(db.Stores.Include(x => x.Company).Where(y => y.Id == Id).First());
}
}
public List <Store> List(int CurrentPage, int PageSize)
{
using (var db = new CompaniesDBEntities())
{
var query = db.Stores.Include(x => x.Company).OrderBy(n => n.Name).Skip((CurrentPage - 1) * PageSize).Take(PageSize);
return(query.ToList());
}
}
public List <Company> List()
{
using (var db = new CompaniesDBEntities())
{
var query = db.Companies.Include(x => x.Stores).OrderBy(n => n.Name);
return(query.ToList());
}
}
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();
}
}
}
