//This function adds the information to a user object and adds it to the DB
public static void RegisterUser(User user)
{
OnlineShopEntities db = new OnlineShopEntities();
db.Users.Add(user);
db.SaveChanges();
}
public void DeleteCustomers()
{
using (var context = new OnlineShopEntities())
{
var customersToDel = context
.Customers
.Where(x => x.Lastname == "Ivanov")
.ToList();
foreach (var customer in customersToDel)
{
var ordersToDelete = context.Orders.Where(o => o.CustomerId == customer.Id);
foreach (var order in ordersToDelete)
{
var orderItemsToDelete = context.OrderItems.Where(oi => oi.OrderId == order.Id);
foreach (var orderItem in orderItemsToDelete)
{
context.OrderItems.Remove(orderItem);
}
context.Orders.Remove(order);
}
context.Customers.Remove(customer);
}
context.SaveChanges();
}
}
private static bool CheckTag(string id)
{
using (var db = new OnlineShopEntities())
{
return(db.Tags.Count(x => x.ID == id) > 0);
}
}
//This function puts product items into a list
public static List <Product> GenerateProductList()
{
OnlineShopEntities db = new OnlineShopEntities();
List <Product> products = db.Products.ToList();
return(products);
}
public static User GetUserByID(string UserName)
{
using (var db = new OnlineShopEntities())
{
return(db.Users.SingleOrDefault(x => x.UserName.Equals(UserName)));
}
}
public static int InsertContent(Content content)
{
using (var db = new OnlineShopEntities())
{
if (string.IsNullOrEmpty(content.MetaTitle))
{
content.MetaTitle = StringHelper.ToUnsignString(content.Name);
}
db.Contents.Add(content);
var result = db.SaveChanges();
if (!string.IsNullOrEmpty(content.Tags))
{
string[] tags = content.Tags.Split('-').ToArray();
for (int i = 0; i < tags.Length; i++)
{
var tagID = StringHelper.ToUnsignString(tags[i]);
var existedTag = CheckTag(tagID);
if (!existedTag)
{
InsertTag(tagID, tags[i]);
}
InsertContentTag(content.ID, tagID);
}
}
return(result);
}
}
public static bool CheckEmail(string email)
{
using (var db = new OnlineShopEntities())
{
return(db.Users.Count(x => x.Email.Equals(email)) > 0);
}
}
//This adds a product to the session cart
public static List <Product> AddItemToCartList(int id)
{
OnlineShopEntities db = new OnlineShopEntities();
//check if cart alreay exists
if (HttpContext.Current.Session["Cart"] == null)
{
//make a new list
List <Product> cart = new List <Product>();
//add this product to it
cart.Add((from p in db.Products
where p.ProductID == id
select p).Single());
//add the list to the session
HttpContext.Current.Session.Add("Cart", cart);
return(cart);
}
else
{
//if the cart isn't empty
List <Product> cart = (List <Product>)(HttpContext.Current.Session["Cart"]);
//add book to cart
cart.Add((from p in db.Products
where p.ProductID == id
select p).Single());
return(cart);
}
}
public static bool CheckUser(string userName)
{
using (var db = new OnlineShopEntities())
{
return(db.Users.Count(x => x.UserName.Equals(userName)) > 0);
}
}
public void DeleteCustomer(int id)
{
using (var context = new OnlineShopEntities())
{
var customerToDel = context.Customers.First(x => x.Id == id);
if (customerToDel != null)
{
var ordersToDelete = context.Orders.Where(o => o.CustomerId == customerToDel.Id);
foreach (var order in ordersToDelete)
{
var orderItemsToDelete = context.OrderItems.Where(oi => oi.OrderId == order.Id);
foreach (var orderItem in orderItemsToDelete)
{
context.OrderItems.Remove(orderItem);
}
context.Orders.Remove(order);
}
context.Customers.Remove(customerToDel);
}
context.SaveChanges();
}
}
public static List <ProductDTO> SearchProduct(string keyword, ref int totalRecord, int pageIndex, int pageSize)
{
var db = new OnlineShopEntities();
totalRecord = db.Products.Where(x => x.Name.Contains(keyword)).Count();
var products = from a in db.Products
join b in db.ProductCategories
on a.CategoryID equals b.ID
where a.Name.Contains(keyword)
select new ProductDTO
{
ID = a.ID,
Images = a.Image,
Name = a.Name,
Price = a.Price,
CategoryName = b.Name,
CategoryMetaTitle = b.MetaTitle,
MetaTitle = a.MetaTitle,
CreatedDate = a.CreatedDate,
};
products.OrderByDescending(x => x.CreatedDate)
.Skip((pageIndex - 1) * pageSize)
.Take(pageSize);
return(products.ToList());
}
public static List <User> GetAllUser()
{
using (var db = new OnlineShopEntities())
{
var users = db.Users.ToList();
return(users);
}
}
public static List <ProductCategory> GetAllProductCategory()
{
using (var db = new OnlineShopEntities())
{
var productCategories = db.ProductCategories.Where(x => x.Status == true).OrderBy(x => x.DisplayOrder).ToList();
return(productCategories);
}
}
public static List <string> SearchProduct(string keyword)
{
using (var db = new OnlineShopEntities())
{
var products = db.Products.Where(x => x.Name.Contains(keyword)).Select(x => x.Name).ToList();
return(products);
}
}
public static Content GetContentByID(int ID)
{
using (var db = new OnlineShopEntities())
{
var result = db.Contents.Find(ID);
return(result);
}
}
public static OrderDetail GetOrderDetail(int ID)
{
using (var db = new OnlineShopEntities())
{
var orderDetail = db.OrderDetails.Find(ID);
return(orderDetail);
}
}
public static Tag GetTag(string ID)
{
using (var db = new OnlineShopEntities())
{
var tag = db.Tags.Find(ID);
return(tag);
}
}
public static List <Menu> GetMenuByID(int TypeID)
{
using (var db = new OnlineShopEntities())
{
var menus = db.Menus.Where(x => (x.TypeID == TypeID) && (x.Status == true)).OrderBy(x => x.DisplayOrder).ToList();
return(menus);
}
}
public static Footer GetFooter()
{
using (var db = new OnlineShopEntities())
{
var footer = db.Footers.SingleOrDefault(x => x.Status == true);
return(footer);
}
}
public static List <Slide> GetAllSlide()
{
using (var db = new OnlineShopEntities())
{
var slides = db.Slides.Where(x => x.Status == true).OrderBy(x => x.DisplayOrder).ToList();
return(slides);
}
}
public static User GetDetail(int ID)
{
using (var db = new OnlineShopEntities())
{
var result = db.Users.Find(ID);
return(result);
}
}
public ActionResult Index1()
{
var db = new OnlineShopEntities();
var item = (from d in db.Images
select d).ToList();
return(View(item));
}
/// <summary>
/// List all content for client
/// </summary>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public static List <Content> ListAllPaging(int page, int pageSize)
{
using (var db = new OnlineShopEntities())
{
var model = db.Contents;
return(model.OrderByDescending(x => x.CreatedDate).ToPagedList(page, pageSize).ToList());
}
}
public static Product GetProductDetail(int ID)
{
using (var db = new OnlineShopEntities())
{
var product = db.Products.Find(ID);
return(product);
}
}
public static List <OrderDetail> GetOrderDetails()
{
using (var db = new OnlineShopEntities())
{
var orderDetails = db.OrderDetails.ToList();
return(orderDetails);
}
}
public static ProductCategory GetProductDetail(int ID)
{
using (var db = new OnlineShopEntities())
{
var productCategory = db.ProductCategories.Find(ID);
return(productCategory);
}
}
public static List <Content> GetAllContent()
{
using (var db = new OnlineShopEntities())
{
var contents = db.Contents.ToList();
return(contents);
}
}
public static List <Category> GetAllCategory()
{
using (var db = new OnlineShopEntities())
{
var categories = db.Categories.Where(x => x.Status == true).ToList();
return(categories);
}
}
public static void RemoveAllContentTag(long contentId)
{
using (var db = new OnlineShopEntities())
{
db.ContentTags.RemoveRange(db.ContentTags.Where(x => x.ContentID == contentId));
db.SaveChanges();
}
}
public static Contact GetActiveContact()
{
using (var db = new OnlineShopEntities())
{
var contact = db.Contacts.SingleOrDefault(x => x.Status == true);
return(contact);
}
}
