public Picture GetPictureById(int id) { using (var db = new BatikStoreEntities()) { return db.Pictures.SingleOrDefault(c => c.Id == id); } }
public List<Picture> GetPicturesByProductId(int productId) { using (var db = new BatikStoreEntities()) { return db.Pictures.Where(c => c.Product_ProductId == productId).ToList(); } }
public User GetUserByEmail(string email) { using (var db = new BatikStoreEntities()) { return db.Users.SingleOrDefault(c => c.Email == email); } }
public Product GetByNumber(string number) { using (var db = new BatikStoreEntities()) { return db.Products.Include("Model").Include("Size").Include("Type").Include("Origin").Include("Pictures").SingleOrDefault(c => c.Number.Equals(number)); } }
public List<Model> GetAll() { using (var db = new BatikStoreEntities()) { return db.Models.ToList(); } }
public List<Size> GetAll() { using (var db = new BatikStoreEntities()) { return db.Sizes.ToList(); } }
public List<Origin> GetAll() { using (var db = new BatikStoreEntities()) { return db.Origins.ToList(); } }
public Origin GetOriginById(int id) { using (var db = new BatikStoreEntities()) { return db.Origins.FirstOrDefault(c => c.Id == id); } }
public List<Product> GetLatestProducts() { using (var db = new BatikStoreEntities()) { return db.Products.Include("Model").Include("Size").Include("Type").Include("Origin").Include("Pictures").OrderByDescending(c => c.DateEntered).Take(Constant.LatestProducts).ToList(); } }
public Product GetById(int Id) { using (var db = new BatikStoreEntities()) { return db.Products.Include("Model").Include("Size").Include("Type").Include("Origin").Include("Pictures").SingleOrDefault(c => c.Id == Id); } }
public Model GetModelById(int id) { using (var db = new BatikStoreEntities()) { return db.Models.FirstOrDefault(c => c.Id == id); } }
public List<Product> GetAll() { using (var db = new BatikStoreEntities()) { return db.Products.Include("Model").Include("Size").Include("Type").Include("Origin").Include("Pictures").ToList(); } }
public Size GetSizeById(int id) { using (var db = new BatikStoreEntities()) { return db.Sizes.FirstOrDefault(c => c.Id == id); } }
public void Add(Size entity) { using (var db = new BatikStoreEntities()) { db.Sizes.AddObject(entity); db.SaveChanges(); } }
public void Add(Product entity) { using (var db = new BatikStoreEntities()) { db.Products.AddObject(entity); db.SaveChanges(); } }
public List<Product> GetRandomPromotedProducts() { using (var db = new BatikStoreEntities()) { var products = db.Products.Include("Model").Include("Size").Include("Type").Include("Origin").Include("Pictures").Where(c => c.Promoted == true).ToList(); return products.GetRandomFromList(Constant.PromotedProducts).ToList(); } }
public void Delete(int id) { using (var db = new BatikStoreEntities()) { var existing = db.Sizes.SingleOrDefault(c => c.Id == id); if (existing != null) { db.Sizes.DeleteObject(existing); db.SaveChanges(); } } }
public void Update(Size entity) { using (var db = new BatikStoreEntities()) { var existing = db.Sizes.SingleOrDefault(c => c.Id == entity.Id); if (existing != null) { db.Sizes.ApplyCurrentValues(entity); db.SaveChanges(); } } }
public bool IsOriginAlreadyUsed(int originId) { using (var db = new BatikStoreEntities()) { return db.Products.Any(c => c.Origin_OriginId == originId); } }
public bool IsTypeAlreadyUsed(int typeId) { using (var db = new BatikStoreEntities()) { return db.Products.Any(c => c.Type_TypeId == typeId); } }
public List<Product> Search(string searchCriteria, int skip) { using (var db = new BatikStoreEntities()) { if(String.IsNullOrEmpty(searchCriteria)) return db.Products.Include("Model").Include("Size").Include("Type").Include("Origin").Include("Pictures").OrderByDescending(c => c.DateEntered).Skip(skip).Take(Constant.ItemPerPage).ToList(); else return db.Products.Include("Model").Include("Size").Include("Type").Include("Origin").Include("Pictures").Where(searchCriteria).OrderByDescending(c => c.DateEntered).Skip(skip).Take(Constant.ItemPerPage).ToList(); } }
public bool IsModelAlreadyUsed(int modelId) { using (var db = new BatikStoreEntities()) { return db.Products.Any(c => c.Model_ModelId == modelId); } }
public bool IsSizeAlreadyUsed(int sizeId) { using (var db = new BatikStoreEntities()) { return db.Products.Any(c => c.Size_SizeId == sizeId); } }