public bool DeleteEmployee(int id) { using (var contest = new PrkStoreEntities()) { var employee = contest.tblProduct.FirstOrDefault(x => x.Id == id); if (employee != null) { contest.tblProduct.Remove(employee); contest.SaveChanges(); return(true); } return(false); } }
public CategoryModal GetOne(int id) { using (var database = new PrkStoreEntities()) { var all = database.tblCategory.Where(x => x.ID == id). Select(X => new CategoryModal { Name = X.Name, Description = X.Description }).FirstOrDefault(); return(all); } }
public ProductModals GetOne(int id) { using (var database = new PrkStoreEntities()) { var all = database.tblProduct.Where(x => x.Id == id). Select(X => new ProductModals { Name = X.Name, Description = X.Description }).FirstOrDefault(); return(all); } }
//public static ConfigurationServices classObject { get // { // if (privateInmemory == null) // { // privateInmemory = new ConfigurationServices(); // } // return classObject; // } } // arko class bata get garna milos vanera //private static ConfigurationServices privateInmemory { get; set; } //private ConfigurationServices() //{ //} public config GetConfig(string key) { using (var database = new PrkStoreEntities()) { { var all = database.tblConfigurations.Where(x => x.Key == key). Select(x => new config { value = x.value }).FirstOrDefault(); return(all); } } }
public bool Edit(int id, ProductModals models) { using (var contest = new PrkStoreEntities()) { var employee = contest.tblProduct.FirstOrDefault(x => x.Id == id);// first or default use garda fast hucha where vanda if (employee != null) { employee.Name = models.Name; employee.Description = models.Description; employee.Price = models.Price; } contest.SaveChanges(); return(true); } }
public List <ProductModals> GetOne(List <int> ids) { using (var database = new PrkStoreEntities()) { var all = database.tblProduct.Where(product => ids.Contains(product.Id)). Select(X => new ProductModals { Name = X.Name, Description = X.Description, Price = (decimal)X.Price }).ToList(); return(all); } }
public int Save(ProductModals modal) { using (var database = new PrkStoreEntities()) { tblProduct CategoryTB = new tblProduct() { Name = modal.Name, Description = modal.Description, Price = modal.Price }; database.tblProduct.Add(CategoryTB); database.SaveChanges(); return(CategoryTB.Id); } }
public bool Edit(int id, CategoryModal models) { using (var contest = new PrkStoreEntities()) { var employee = contest.tblCategory.FirstOrDefault(x => x.ID == id);// first or default use garda fast hucha where vanda if (employee != null) { employee.Name = models.Name; employee.Description = models.Description; employee.IsFeatured = models.IsFeatured; } contest.SaveChanges(); return(true); } }
public List <CategoryModal> GetAll() { using (var database = new PrkStoreEntities()) { var all = database.tblCategory.Select(X => new CategoryModal() { ID = X.ID, Name = X.Name, Description = X.Description, ImageUrl = X.ImageUrl, IsFeatured = (bool)X.IsFeatured }).ToList(); return(all); } }
public int Save(CategoryModal modal) { using (var database = new PrkStoreEntities()) { tblCategory CategoryTB = new tblCategory() { Name = modal.Name, Description = modal.Description, ImageUrl = modal.ImageUrl, IsFeatured = modal.IsFeatured }; database.tblCategory.Add(CategoryTB); database.SaveChanges(); return(CategoryTB.ID); } }
public List <ProductModals> GetAll(int pageno) { int pageSize = 5; using (var database = new PrkStoreEntities()) { var all = database.tblProduct.OrderBy(x => x.Id).Skip((pageno - 1) * pageSize).Take(pageSize) .Select(X => new ProductModals() { Id = X.Id, Name = X.Name, Description = X.Description, Price = (decimal)X.Price, pagenumber = pageno, one = 1, }).ToList(); return(all); } }