public int AddToOrders(int reservedID, string adress, string phone, string e_mail)
{
using (var context = new eshopContext())
{
var reserved = context.Reserved.FirstOrDefault(res => res.ReservedId == reservedID);
if (reserved != null)
{
reserved.ReservedOrdered = true;
context.SaveChanges();
Orders order = new Orders();
order.CartId = reserved.CartId;
order.CategoryId = reserved.CategoryId;
order.ProductId = reserved.ProductId;
order.UserId = reserved.UserId;
order.ReservedId = reserved.ReservedId;
order.OrderDate = DateTime.Now;
order.OrderAdress = adress;
order.OrderPhoneNumber = phone;
order.OrderEmail = e_mail;
context.Orders.Add(order);
}
return(context.SaveChanges());
}
}
public int JsonStringBody([FromBody] RegistrationModel content)
{
using (var context = new eshopContext())
{
if (!context.Users.ToList().Any(mail => mail.EMail == content.EMail))
{
Users newUser = new Users();
{
newUser.FirstName = content.FirstName;
newUser.LastName = content.LastName;
newUser.BirthDate = content.BirthDate;
newUser.EMail = content.EMail;
newUser.Password = CreateMD5(content.Password);
context.Users.Add(newUser);
context.SaveChanges();
RoleList roleList = new RoleList();
roleList.UserId = newUser.UserId;
roleList.RoleId = context.Roles.FirstOrDefault(r => r.RoleName.Equals("User")).RoleId;
Cart cart = new Cart();
cart.UserId = newUser.UserId;
cart.CartAddDate = DateTime.Now;
context.Cart.Add(cart);
context.RoleList.Add(roleList);
}
}
return(context.SaveChanges());
}
}
public int AddToCart(int ID, int prodID, int amount)
{
using (var context = new eshopContext())
{
var product = context.Products.FirstOrDefault(prod => prod.ProductId == prodID);
if (product != null && amount > 0 && amount <= product.ProductAmount)
{
product.ProductAmount -= amount;
context.SaveChanges();
Reserved reserved = new Reserved();
reserved.ProductId = prodID;
reserved.CategoryId = product.CategoryId;
reserved.UserId = ID;
reserved.CartId = context.Cart.FirstOrDefault(cart => cart.UserId == ID).CartId;
reserved.ReservedAmount = amount;
reserved.ReservedOrdered = false;
context.Reserved.Add(reserved);
}
return(context.SaveChanges());
}
}
public string JsonStringBody([FromBody] EditProductModel content)
{
using (var context = new eshopContext())
{
var productDB = context.Products.FirstOrDefault(item => item.ProductId == content.productId);
if (productDB != null && productDB.CategoryId != content.category)
{
var reserved = context.Reserved.Where(item => item.ProductId == content.productId);
var ordered = context.Orders.Where(i => i.ProductId == content.productId);
context.Reserved.RemoveRange(reserved);
context.Orders.RemoveRange(ordered);
context.Products.Remove(productDB);
context.SaveChanges();
Products product = new Products();
product.ProductName = content.tittle;
product.ProductPrice = content.price;
product.ProductAmount = content.amount;
product.ProductDescription = content.description;
product.ProductPhoto = content.photo;
product.CategoryId = content.category;
context.Products.Add(product);
context.SaveChanges();
return(product.ProductId.ToString());
}
else
{
productDB.ProductName = content.tittle;
productDB.ProductPrice = content.price;
productDB.ProductAmount = content.amount;
productDB.ProductDescription = content.description;
productDB.ProductPhoto = content.photo;
context.SaveChanges();
return(productDB.ProductId.ToString());
}
}
return(null);
}
public int JsonStringBody([FromBody] CategoryModel content)
{
using (var context = new eshopContext())
{
Category category = new Category();
category.CategoryName = content.categoryName;
context.Category.Add(category);
return(context.SaveChanges());
}
}
public int BlockUser([FromBody] UserManagmentModel content)
{
using (var context = new eshopContext())
{
var itemToRemove = context.RoleList.Where(user => user.UserId == content.ID);
if (itemToRemove != null)
{
context.RoleList.RemoveRange(itemToRemove);
}
return(context.SaveChanges());
}
}
public int GetVisits()
{
using (var context = new eshopContext())
{
if (context.Logs.ToList().Count == 0)
{
Logs log = new Logs();
log.LogCounter = 1;
context.Logs.Add(log);
context.SaveChanges();
return(1);
}
else
{
var log = context.Logs.FirstOrDefault();
log.LogCounter++;
context.SaveChanges();
return((int)log.LogCounter);
}
}
}
public int EditUser([FromBody] EditUserModel content)
{
using (var context = new eshopContext())
{
var user = context.Users.FirstOrDefault(u => u.UserId == content.ID);
if (user != null)
{
user.FirstName = content.FirstName;
user.LastName = content.LastName;
user.BirthDate = content.BirthDate;
}
return(context.SaveChanges());
}
}
public int AddComment(int userID, int productID, string text)
{
using (var context = new eshopContext())
{
Comment comment = new Comment();
comment.UserId = userID;
comment.ProductId = productID;
comment.CategoryId = context.Products.FirstOrDefault(prod => prod.ProductId == productID).CategoryId;
comment.CommentText = text;
context.Comment.Add(comment);
return(context.SaveChanges());
}
}
public int DeleteReservation([FromBody] ReservedProduct content)
{
using (var context = new eshopContext())
{
var reserved = context.Reserved.FirstOrDefault(res => res.ReservedId == content.ID);
if (reserved != null)
{
var prod = context.Products.FirstOrDefault(p => p.ProductId == reserved.ProductId);
prod.ProductAmount += reserved.ReservedAmount;
context.Reserved.Remove(reserved);
}
return(context.SaveChanges());
}
}
public int DeleteProduct(int ID)
{
using (var context = new eshopContext())
{
var itemToRemove = context.Products.SingleOrDefault(product => product.ProductId == ID); //returns a single item.
var removeFromReserved = context.Reserved.Where(product => product.ProductId == ID);
if (removeFromReserved != null)
{
context.Reserved.RemoveRange(removeFromReserved);
}
if (itemToRemove != null)
{
context.Products.Remove(itemToRemove);
}
return(context.SaveChanges());
}
}
public ActionResult <IEnumerable <News> > AddNews([FromBody] NewsModel content)
{
using (var context = new eshopContext())
{
if (!context.News.ToList().Any(newsses => newsses.NewsTittle == content.NewsTittle))
{
News newNews = new News();
newNews.NewsTittle = content.NewsTittle;
newNews.NewsDescription = content.NewsDescription;
newNews.NewsBody = content.NewsBody;
newNews.NewsDateTime = DateTime.Now;
newNews.UserId = content.UserId;
context.News.Add(newNews);
context.SaveChanges();
}
}
return(new List <News>());
}
public ActionResult <IEnumerable <Products> > JsonStringBody([FromBody] AddProductModel content)
{
using (var context = new eshopContext())
{
if (!context.Products.ToList().Any(prod => prod.ProductName == content.tittle))
{
Products newProduct = new Products();
newProduct.ProductName = content.tittle;
newProduct.ProductPrice = content.price;
newProduct.ProductAmount = content.amount;
newProduct.ProductDescription = content.description;
newProduct.ProductPhoto = content.photo;
newProduct.CategoryId = content.category;
context.Products.Add(newProduct);
context.SaveChanges();
}
}
return(new List <Products>());
}
public int DeleteUser([FromBody] UserManagmentModel content)
{
using (var context = new eshopContext())
{
var deleteRoleList = context.RoleList.Where(user => user.UserId == content.ID);
if (deleteRoleList != null)
{
context.RoleList.RemoveRange(deleteRoleList);
context.SaveChanges();
}
var itemToRemove = context.Users.SingleOrDefault(user => user.UserId == content.ID); //returns a single item.
var deleteOrdered = context.Orders.Where(user => user.UserId == content.ID);
if (deleteOrdered != null)
{
context.Orders.RemoveRange(deleteOrdered);
context.SaveChanges();
}
var deleteComments = context.Comment.Where(user => user.UserId == content.ID);
if (deleteComments != null)
{
context.Comment.RemoveRange(deleteComments);
context.SaveChanges();
}
var deleteReserved = context.Reserved.Where(user => user.UserId == content.ID);
if (deleteReserved != null)
{
context.Reserved.RemoveRange(deleteReserved);
context.SaveChanges();
}
var deleteCart = context.Cart.Where(user => user.UserId == content.ID);
if (deleteCart != null)
{
context.Cart.RemoveRange(deleteCart);
context.SaveChanges();
}
var deleteNews = context.News.Where(user => user.UserId == content.ID);
if (deleteNews != null)
{
context.News.RemoveRange(deleteNews);
context.SaveChanges();
}
if (itemToRemove != null)
{
context.Users.Remove(itemToRemove);
}
return(context.SaveChanges());
}
}