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