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();
}
}