public List <Cart> GetOrdersInCart(string userId)
{
var db = new VegetableDBEntities();
var orders = (from x in db.Cart
where x.ClientId == userId && x.IsInCart
orderby x.DatePurchased
select x).ToList();
return(orders);
}
public string InsertProduct(Product product)
{
try {
var db = new VegetableDBEntities();
db.Product.Add(product);
db.SaveChanges();
return(product.Name + " был успешно создан");
}
catch (Exception e) {
return("Error" + e);
}
}
public Product GetProduct(int id)
{
try {
using (var db = new VegetableDBEntities()) {
var product = db.Product.Find(id);
return(product);
}
}
catch (Exception) {
return(null);
}
}
public string InsertCart(Cart cart)
{
try {
var db = new VegetableDBEntities();
db.Cart.Add(cart);
db.SaveChanges();
return(cart.DatePurchased + " товар был успешно добавлен в корзину");
}
catch (Exception e) {
return("Error" + e);
}
}
public List <Product> GetAllProducts()
{
try {
using (var db = new VegetableDBEntities()) {
var products = (from x in db.Product
select x).ToList();
return(products);
}
}
catch (Exception) {
return(null);
}
}
public List <Product> GetProductsByType(int typeId)
{
try {
using (var db = new VegetableDBEntities()) {
var products = (from x in db.Product
where x.TypeId == typeId
select x).ToList();
return(products);
}
}
catch (Exception) {
return(null);
}
}
public string UpdateProductTypes(int id, ProductTypes productTypes)
{
try {
var db = new VegetableDBEntities();
var p = db.ProductTypes.Find(id);
p.Name = productTypes.Name;
db.SaveChanges();
return(productTypes.Name + " был успешно обновлён");
}
catch (Exception e) {
return("Error" + e);
}
}
public string DeleteProduct(int id)
{
try {
var db = new VegetableDBEntities();
var product = db.Product.Find(id);
db.Product.Attach(product);
db.Product.Remove(product);
db.SaveChanges();
return(product.Name + " был успешно удалён");
}
catch (Exception e) {
return("Error" + e);
}
}
public void MarkOrdersAsPurchased(List <Cart> orders)
{
var db = new VegetableDBEntities();
if (orders != null)
{
foreach (var cart in orders)
{
var oldCart = db.Cart.Find(cart.Id);
oldCart.DatePurchased = DateTime.Now;
oldCart.IsInCart = false;
}
db.SaveChanges();
}
}
public string DeleteCart(int id)
{
try {
var db = new VegetableDBEntities();
var cart = db.Cart.Find(id);
db.Cart.Attach(cart);
db.Cart.Remove(cart);
db.SaveChanges();
return(cart.DatePurchased + " товар был успешно удален из корзины");
}
catch (Exception e) {
return("Error" + e);
}
}
public string UpdateProduct(int id, Product product)
{
try {
var db = new VegetableDBEntities();
var p = db.Product.Find(id);
p.TypeId = product.TypeId;
p.Name = product.Name;
p.Price = product.Price;
p.Description = product.Description;
p.Image = product.Image;
db.SaveChanges();
return(product.Name + " был успешно обновлён");
}
catch (Exception e) {
return("Error" + e);
}
}
public string UpdateCart(int id, Cart cart)
{
try {
var db = new VegetableDBEntities();
var p = db.Cart.Find(id);
p.ClientId = cart.ClientId;
p.ProductId = cart.ProductId;
p.Amount = cart.Amount;
p.DatePurchased = cart.DatePurchased;
p.IsInCart = cart.IsInCart;
db.SaveChanges();
return(cart.DatePurchased + " товар был успешно обновлён в корзине");
}
catch (Exception e) {
return("Error" + e);
}
}
