public List <SubCategory> GetAllSubCategories() { using (var context = new eMarketContext()) { return(context.SubCategories.ToList()); } }
public List <Message> GetAllReadMessages(int memberID) { using (var context = new eMarketContext()) { return(context.Messages.Where(x => x.MessageToID == memberID && x.IsChecked == true).ToList()); } }
public Message GetByIdMessage(string id) { using (var context = new eMarketContext()) { return(context.Messages.Where(x => x.GuidNumber == id).FirstOrDefault()); } }
public List <Product> GetAllUnapprovedProductsById(int memberID) { using (var context = new eMarketContext()) { return(context.Products.Where(x => x.MemberID == memberID && x.IsApproved == false).ToList()); } }
public List <Product> GetAllApprovedProducts() { using (var context = new eMarketContext()) { return(context.Products.Where(x => x.IsApproved == true).ToList()); } }
public Blog GetByIdBlog(int id) { using (var context = new eMarketContext()) { return(context.Set <Blog>().Find(id)); } }
public List <Message> GetAllMessages(int memberID) { using (var context = new eMarketContext()) { return(context.Messages.Include("Member").Where(x => x.MessageToID == memberID).ToList()); } }
public List <Message> GetAllMessages() { using (var context = new eMarketContext()) { return(context.Messages.ToList()); } }
public List <SubCategory> GetAllSubCategoryById(int categoryID) { using (var context = new eMarketContext()) { var subCategories = context.SubCategories.Where(x => x.CategoryID == categoryID).ToList(); return(subCategories); } }
public List <Category> GetAllCategory() { using (var context = new eMarketContext()) { var categories = context.Categories.ToList(); return(categories); } }
public List <Product> GetUnapprovedMyProducts(int memberID) { using (var context = new eMarketContext()) { var products = context.Products.Where(x => x.MemberID == memberID && x.IsApproved == false).ToList(); return(products); } }
public List <Blog> GetAllBlogPost() { using (var context = new eMarketContext()) { var blogs = context.Blogs.ToList(); return(blogs); } }
public List <Product> GetAllUnapprovedProducts() { using (var context = new eMarketContext()) { var products = context.Products.Include("Member").Where(x => x.IsApproved == false && x.Member.IsActive == true).ToList(); return(products); } }
public Product GetByIdProduct(string id) { using (var context = new eMarketContext()) { return(context.Products.Include("ProductImages") .Include("Categories") .Include("Member") .Where(x => x.ProductNumber == id).FirstOrDefault()); } }
public bool CreateProductImage(ProductImage entity) { using (var context = new eMarketContext()) { context.Set <ProductImage>().Add(entity); context.SaveChanges(); return(true); } return(false); }
public bool UpdateBlog(Blog entity) { using (var context = new eMarketContext()) { context.Entry(entity).State = EntityState.Modified; context.SaveChanges(); return(true); } return(false); }
public bool DeleteBlog(Blog entity) { using (var context = new eMarketContext()) { context.Set <Blog>().Remove(entity); context.SaveChanges(); return(true); } return(false); }
public bool GetProductHomeImageCheck(int productID) { using (var context = new eMarketContext()) { var data = context.ProductImages.Where(x => x.ProductId == productID && x.IsHome == true).FirstOrDefault(); if (data != null) { return(true); } return(false); } }
public bool UpdateProductImage(int productImageID, string imageUrl) { using (var context = new eMarketContext()) { var product_image = context.ProductImages.Where(x => x.ProductImageId == productImageID).FirstOrDefault(); if (product_image != null) { product_image.Url = imageUrl; context.SaveChanges(); return(true); } return(false); } }
public bool DeleteProductImage(string imageUrl) { using (var context = new eMarketContext()) { var product_images = context.ProductImages.Where(x => x.Url == imageUrl).FirstOrDefault(); if (product_images != null) { context.Set <ProductImage>().Remove(product_images); context.SaveChanges(); return(true); } return(false); } }
public bool UpdateMessageChecked(bool check, string guidNumber) { using (var context = new eMarketContext()) { var message = context.Messages.Where(x => x.GuidNumber == guidNumber).FirstOrDefault(); if (message != null) { message.IsChecked = check; context.SaveChanges(); return(true); } return(false); } }
public bool UpdateProductApproval(bool check, int productID) { using (var context = new eMarketContext()) { var products = context.Products.Where(x => x.ProductId == productID && x.IsApproved == false).FirstOrDefault(); if (products != null) { products.IsApproved = check; context.SaveChanges(); return(true); } return(false); } }
public bool UpdateProductCategories(int CategoryId, int SubCategoryId, int product_id) { using (var context = new eMarketContext()) { var product = context.Products.Where(x => x.ProductId == product_id).FirstOrDefault(); if (product != null) { product.CategoryId = CategoryId; product.SubCategoryId = SubCategoryId; context.SaveChanges(); return(true); } return(false); } }
public bool UpdateProductInfo(string name, string description, double price, int Stock, int product_id) { using (var context = new eMarketContext()) { var product = context.Products.Where(x => x.ProductId == product_id).FirstOrDefault(); if (product != null) { product.Name = name; product.Description = description; product.Price = price; product.Stock = Stock; context.SaveChanges(); return(true); } return(false); } }