public static int AddReview(Review review)
{
using (var _context = new EduShopEntities())
{
_context.ReviewSet.Add(review);
return(_context.SaveChanges());
}
}
public static int AddOrderRow(OrderRow orderRow)
{
using (var _context = new EduShopEntities())
{
_context.OrderRowSet.AddOrUpdate(orderRow);
return(_context.SaveChanges());
}
}
public static List <Product> GetProducts()
{
using (var _context = new EduShopEntities())
{
return
((from c in _context.ProductSet
select c).ToList());
}
}
public static UserModel GetUserOnEmail(string email)
{
using (var _context = new EduShopEntities())
{
return(ConvertToUserModel((from c in _context.UserSet
where c.Email == email
select c).FirstOrDefault()));
}
}
public static UserModel GetUser(string password)
{
using (var _context = new EduShopEntities())
{
return(ConvertToUserModel((from c in _context.UserSet
where c.Password == password
select c).FirstOrDefault()));
}
}
public static int AddUser(User user)
{
using (var _context = new EduShopEntities())
{
user.Password = PasswordHash.CreateHash(user.Password);
_context.UserSet.AddOrUpdate(user);
return(_context.SaveChanges());
}
}
public static OrderModel GetLastOrder()
{
using (var _context = new EduShopEntities())
{
return(ConvertToOrderModel((from c in _context.OrderSet
orderby c.Id descending
select c).FirstOrDefault()));
}
}
public static List <Product> GetProductsOnSearch(string search)
{
using (var _context = new EduShopEntities())
{
return((
from c in _context.ProductSet
where c.Category.Contains(search) || c.Name.Contains(search)
select c).ToList());
}
}
public static List <Product> GetProductsOnCategory(string category)
{
using (var _context = new EduShopEntities())
{
return((
from c in _context.ProductSet
where c.Category == category
select c).ToList());
}
}
public static Product GetProduct(int id)
{
using (var _context = new EduShopEntities())
{
return((
from c in _context.ProductSet
where c.Id == id
select c).FirstOrDefault());
}
}
public static User CheckForUser(UserModel userModel)
{
using (var _context = new EduShopEntities())
{
return((
from c in _context.UserSet
where c.Email == userModel.Email
select c).FirstOrDefault());
}
}
public static List <Review> GetReviews(int id)
{
using (var _context = new EduShopEntities())
{
return((
from c in _context.ReviewSet
where c.ProductId == id
orderby c.DateAdded descending
select c).ToList());
}
}
public static int AddOrUpdateProductRating(int id)
{
using (var _context = new EduShopEntities())
{
int rating = ReviewModel.CalculateAverageRating(id);
Product product = GetProduct(id);
product.AverageRating = rating;
_context.ProductSet.AddOrUpdate(product);
return(_context.SaveChanges());
}
}
public static List <UserModel> GetAllUsers()
{
using (var _context = new EduShopEntities())
{
var userModelList = new List <UserModel>();
List <User> userList = (from c in _context.UserSet
select c).ToList();
foreach (var item in userList)
{
userModelList.Add(ConvertToUserModel(item));
}
return(userModelList);
}
}
public static bool CheckIfUSerEmailIsUnique(User user)
{
using (var _context = new EduShopEntities())
{
var query = (from u in _context.UserSet
where u.Email == user.Email
select u).Count();
if (query > 0)
{
return(false);
}
AddUser(user);
return(true);
}
}