public Product GetProduct(int id) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { return(onlineShoppingContext.products.Where(product => product.ProductId == id).FirstOrDefault()); } }
public Category GetCategory(int id) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { return(onlineShoppingContext.Categories.Where(category => category.CategoryId == id).FirstOrDefault()); } }
public Account Login(Account account) { using (OnlineShoppingContext context = new OnlineShoppingContext()) { var result = context.Accounts.Where(value => value.EmailId == account.EmailId && value.Password == account.Password).FirstOrDefault(); return(result); } }
public void AddUser(Account account) { using (OnlineShoppingContext context = new OnlineShoppingContext()) { context.Accounts.Add(account); context.SaveChanges(); } }
public List <Category> DropDownList() { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { List <Category> categories = onlineShoppingContext.Categories.ToList(); return(categories); } }
public void Update(Product product) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { onlineShoppingContext.Entry(product).State = System.Data.Entity.EntityState.Modified; onlineShoppingContext.SaveChanges(); } }
public void AddProduct(Product product) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { onlineShoppingContext.products.Add(product); onlineShoppingContext.SaveChanges(); } }
public Product Details(int id) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { Product product = onlineShoppingContext.products.Find(id); return(product); } }
public List <Product> ProductDetails() { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { List <Product> data = onlineShoppingContext.products.ToList(); return(data); } }
public void Update(Category category) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { onlineShoppingContext.Entry(category).State = System.Data.Entity.EntityState.Modified; onlineShoppingContext.SaveChanges(); } }
public Category Details(int id) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { Category category = onlineShoppingContext.Categories.Find(id); return(category); } }
public List <Category> CategoryDetails() { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { List <Category> data = onlineShoppingContext.Categories.ToList(); return(data); } }
public void AddCategory(Category category) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { onlineShoppingContext.Categories.Add(category); onlineShoppingContext.SaveChanges(); } }
public void Delete(int id) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { Product product = onlineShoppingContext.products.Find(id); onlineShoppingContext.products.Remove(product); onlineShoppingContext.SaveChanges(); } }
public void Delete(int id) { using (OnlineShoppingContext onlineShoppingContext = new OnlineShoppingContext()) { Category category = onlineShoppingContext.Categories.Find(id); onlineShoppingContext.Categories.Remove(category); onlineShoppingContext.SaveChanges(); } }