public static ResponseViewModel <ProductAttribute> AddProductAttribute(ProductAttributeViewModel viewModel) { ResponseViewModel <ProductAttribute> responseViewModel = new ResponseViewModel <ProductAttribute>(); ProductAttribute productAtribute = new ProductAttribute(); productAtribute.Name = viewModel.attributeName; productAtribute.ProductCategoryID = viewModel.productCategoryId; productAtribute.ProductSubCategoryID = viewModel.productSubCategoryId; using (EcommerceEntities entities = new EcommerceEntities()) { if (CheckDuplicate(productAtribute)) { responseViewModel.errorViewModel = new ErrorViewModel(); responseViewModel.errorViewModel.statusCode = 400; } else { entities.ProductAttributes.Add(productAtribute); entities.SaveChanges(); ProductAttributeManager.AddOption(viewModel.options, productAtribute.ID); responseViewModel.Data = productAtribute; entities.SaveChanges(); } } return(responseViewModel); }
public ActionResult Create(Product_Image product_Image) { if (ModelState.IsValid) { Product_Image pi = new Product_Image(); pi.Product_ID = product_Image.Product_ID; var files = Request.Files; for (int i = 0; i < Request.Files.Count; i++) { HttpPostedFileBase file = Request.Files[i]; int fileSize = file.ContentLength; string fileName = file.FileName; string mimeType = file.ContentType; System.IO.Stream fileContent = file.InputStream; byte[] bytes; using (BinaryReader br = new BinaryReader(fileContent)) { bytes = br.ReadBytes(fileSize); } pi.Image = Path.GetFileName(fileName); pi.ContentType = mimeType; pi.Data = bytes; pi.Date_Created = DateTime.Now; db.Product_Image.Add(pi); db.SaveChanges(); return(RedirectToAction("Index")); } } ViewBag.Product_ID = new SelectList(db.Products, "Product_ID", "Product_Name", product_Image.Product_ID); return(View(product_Image)); }
[HttpPost] // created public ActionResult TaoMoi(SanPham sp, HttpPostedFileBase HinhAnh) { ViewBag.MaNCC = new SelectList(db.NhaCungCap.OrderBy(n => n.TenNCC), "MaNCC", "TenNCC"); ViewBag.MaNSX = new SelectList(db.NhaSanXuat.OrderBy(n => n.Ten), "MaNSX", "Ten"); ViewBag.MaLoaiSP = new SelectList(db.LoaiSanPham.OrderBy(n => n.TenLoai), "MaLoaiSP", "TenLoai"); // kiểm tra hình ảnh if (HinhAnh.ContentLength > 0) { // lấy tên hình var fileName = Path.GetFileName(HinhAnh.FileName); // chuyển hình ảnh vào thư mục images var path = Path.Combine(Server.MapPath("~/Content/images"), fileName); if (System.IO.File.Exists(path)) { ViewBag.upload = "Hình ảnh đã tồn tại"; } else { HinhAnh.SaveAs(path); sp.HinhAnh = fileName; } } db.SanPham.Add(sp); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult NhapHang(PhieuNhap model, IEnumerable <ChiTietPhieuNhap> listModel) { ViewBag.MaNCC = db.NhaCungCap; ViewBag.ListSP = db.SanPham; // thêm phiếu nhập model.DaXoa = false; db.PhieuNhap.Add(model); db.SaveChanges(); SanPham sp; // thêm chi tiết phiếu nhập foreach (var item in listModel) { item.MaPN = model.MaPN; // cập nhật số lượng tồn cho sản phẩm sp = db.SanPham.Single(n => n.MaSP == item.MaSP); sp.SoLuongTon += item.SoLuongNhap; } db.ChiTietPhieuNhap.AddRange(listModel); db.SaveChanges(); return(View()); }
private void salvar_Click(object sender, RoutedEventArgs e) { salvar(); bancoDados.SaveChanges(); clienteList.pesquisar(); this.Close(); }
public ActionResult Create([Bind(Include = "id,nom_produit,id_categorie,prix,image,description,stock,quantite_lots,niveau_reapprovisionnement")] Produit produit) { if (ModelState.IsValid) { db.Produit.Add(produit); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(produit)); }
public ActionResult Create([Bind(Include = "Id,Title,Price")] Fruit fruit) { if (ModelState.IsValid) { db.Fruits.Add(fruit); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fruit)); }
public ActionResult Create([Bind(Include = "id,id_client,id_produit,quantite")] Panier panier) { if (ModelState.IsValid) { db.Panier.Add(panier); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(panier)); }
public void editcategory(categoryviewmodel item) { category c = db.categories.Where(x => x.cat_id == item.cat_id).SingleOrDefault(); c.cat_id = item.cat_id; c.cat_name = item.cat_name; c.cat_createon = item.cat_createon; c.cat_icon = item.cat_icon; c.cat_fk_ad_id = item.cat_fk_ad_id; db.categories.Add(c); db.SaveChanges(); }
public ActionResult Create(Category category) { if (ModelState.IsValid) { Category categoryobj = new Category(); categoryobj.Category1 = category.Category1; categoryobj.Date_Created = DateTime.Now; db.Categories.Add(categoryobj); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Use([Bind(Include = "id,id_client,email,numero_telephone,pays,ville,adresse,code_postale")] Coordonnees_de_livraison coordonnees_de_livraison) { if (ModelState.IsValid) { Client c = getClientByMail(User.Identity.Name); coordonnees_de_livraison.id_client = c.id; db.Coordonnees_de_livraison.Add(coordonnees_de_livraison); db.SaveChanges(); return(RedirectToAction("Etape3", "Commandes", new { id_livraison = coordonnees_de_livraison.id })); } return(View(coordonnees_de_livraison)); }
public static ResponseViewModel <Customer> RegisterCustomer() { ResponseViewModel <Customer> responseViewModel = new ResponseViewModel <Customer>(); using (EcommerceEntities entities = new EcommerceEntities()) { string imageName = null; HttpRequest httpRequest = HttpContext.Current.Request; var postedFile = httpRequest.Files["Image"]; imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-"); imageName = imageName + DateTime.Now.ToString("yymmssff") + Path.GetExtension(postedFile.FileName); var filePath = HttpContext.Current.Server.MapPath("~/Images/" + imageName); postedFile.SaveAs(filePath); CustomerViewModel viewModel = JsonConvert.DeserializeObject <CustomerViewModel>(httpRequest["customerDetails"]); if (CheckDuplicate(viewModel)) { responseViewModel.errorViewModel = new ErrorViewModel(); responseViewModel.errorViewModel.statusCode = 100; } else { Customer customer = new Customer(); customer.FirstName = viewModel.firstName; customer.LastName = viewModel.lastName; customer.EmailId = viewModel.emailId; customer.City = viewModel.city; customer.State = viewModel.state; customer.Street = viewModel.street; customer.ZipCode = viewModel.zipCode; customer.Image = imageName; customer.PhoneNumber = viewModel.PhoneNumber; User user = new User(); user.Password = Guid.NewGuid().ToString(); user.RoleId = 2; user.Username = viewModel.emailId; user.Password = viewModel.password; user.LastLoginTime = null; entities.Users.Add(user); Cart cart = new Cart(); entities.Carts.Add(cart); entities.SaveChanges(); customer.CartID = cart.ID; customer.UserID = user.ID; entities.Customers.Add(customer); entities.SaveChanges(); responseViewModel.Data = customer; } } return(responseViewModel); }
public void editproduct(productviewmodel pro) { product p = db.products.Where(x => x.pro_id == pro.pro_id).SingleOrDefault(); p.pro_id = pro.pro_id; p.pro_name = pro.pro_name; p.pro_price = pro.pro_price; p.pro_image1 = pro.pro_image1; p.pro_image2 = pro.pro_image2; p.pro_image3 = pro.pro_image3; p.pro_desc = pro.pro_desc; p.pro_fk_cat_id = pro.pro_fk_cat_id; db.SaveChanges(); }
public static ResponseViewModel<List<Product>> AddProduct() { ResponseViewModel<List<Product>> responseViewModel = new ResponseViewModel<List<Product>>(); string imageName = null; HttpRequest httpRequest = HttpContext.Current.Request; var postedFile = httpRequest.Files["Image"]; imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-"); imageName = imageName + DateTime.Now.ToString("yymmssff") + Path.GetExtension(postedFile.FileName); var filePath = HttpContext.Current.Server.MapPath("~/Images/" + imageName); postedFile.SaveAs(filePath); Product productObj = new Product(); /*productObj.Name = httpRequest["name"]; productObj.Price = Convert.ToInt32(httpRequest["price"]); productObj.Description = httpRequest["description"]; productObj.ProductCateogoryID = Convert.ToInt32(httpRequest["category"]); productObj.Quentity = Convert.ToInt32(httpRequest["quentity"]); productObj.Discount = Convert.ToInt32(httpRequest["discount"]); productObj.ProductSubCategoryID = Convert.ToInt32(httpRequest["subcategory"]);*/ productObj = JsonConvert.DeserializeObject<Product>(httpRequest["product"]); productObj.Image = imageName; List<OptionViewModel> options = JsonConvert.DeserializeObject<List<OptionViewModel>>(httpRequest["option"]); using (EcommerceEntities entities = new EcommerceEntities()) { if (CheckDuplicate(productObj)) { responseViewModel.errorViewModel = new ErrorViewModel(); responseViewModel.errorViewModel.statusCode = 400; return responseViewModel; } else { entities.Products.Add(productObj); responseViewModel.Data.Add(productObj); entities.SaveChanges(); foreach(var option in options) { Product_Attribute productAttribute = new Product_Attribute(); //option.productId = Convert.ToInt32(productObj.ID); productAttribute.ProductID = productObj.ID; productAttribute.OptionID = option.id; entities.Product_Attribute.Add(productAttribute); } entities.SaveChanges(); } } return responseViewModel; }
public static void GenerateOrder() { using (EcommerceEntities entites = new EcommerceEntities()) { HttpRequest httpRequest = HttpContext.Current.Request; List <OrderItemViewModel> orderItems = JsonConvert.DeserializeObject <List <OrderItemViewModel> >(httpRequest["orderItems"]); Order order = new Order(); order.CustomerID = Convert.ToInt16(httpRequest["custmerId"]); order.GrandTotal = Convert.ToInt16(httpRequest["GrandTotal"]); order.Date = DateTime.UtcNow; OrderStatu orderStatus = entites.OrderStatus.FirstOrDefault(); order.OrderStatusID = orderStatus.ID; foreach (var orderItem in orderItems) { order.OrderItems.Add(new OrderItem { ItemName = orderItem.itemName, ItemDiscount = orderItem.itemDiscount, ItemImage = orderItem.itemImage, ItemPrice = Convert.ToInt16(orderItem.itemPrice), ItemQuentity = Convert.ToInt16(orderItem.itemQuentity), ProductID = orderItem.productId }); } entites.Orders.Add(order); entites.SaveChanges(); } }
public bool removeCategory(int categoryId) { bool retVal = false; try { using (var database = new EcommerceEntities()) { var categoryEntities = database.Categories; Category category = categoryEntities.Where(i => i.CategotyId == categoryId).FirstOrDefault(); if (category != null) { categoryEntities.Remove(category); database.SaveChanges(); retVal = true; } } } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } return(retVal); }
public ICategoriesDTO editCategory(ICategoriesDTO categoryDTO) { ICategoriesDTO retVal = null; try { using (var database = new EcommerceEntities()) { var category = database.Categories.Where(c => c.CategotyId == categoryDTO.CategotyId).FirstOrDefault(); if (category != null) { category.CategoryName = categoryDTO.CategoryName; database.SaveChanges(); retVal = (ICategoriesDTO)DTOFactory.Instance.Create(DTOType.Category, null); EntityConverter.FillDTOFromEntity(category, retVal); } } } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } return(retVal); }
public bool removeItem(int itemId) { bool retVal = false; try { using (var database = new EcommerceEntities()) { var itemEntities = database.Items; Item item = itemEntities.Where(i => i.ItemId == itemId).FirstOrDefault(); if (item != null) { itemEntities.Remove(item); database.SaveChanges(); retVal = true; } } } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } return(retVal); }
public bool EditSubCategory(ISubCategoriesDTO sub) { bool retVal = false; using (EcommerceEntities employeePortalEntities = new EcommerceEntities()) { try { var employeeEntity = employeePortalEntities.SubCategories.FirstOrDefault(employee => employee.SubCategotyId == sub.SubCategotyId); if (employeeEntity != null) { employeeEntity.CategotyId = sub.CategotyId; employeeEntity.SubCategoryName = sub.SubCategoryName; employeePortalEntities.SaveChanges(); retVal = true; } } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } } return(retVal); }
public static ResponseViewModel <CartItem> AddItemtoCart(IdViewModel viewModel) { List <OptionList> optionList = new List <OptionList>(); optionList = viewModel.optionsList; Cart cart = GetCart(viewModel.Id); ResponseViewModel <CartItem> responseViewModel = new ResponseViewModel <CartItem>(); using (EcommerceEntities entities = new EcommerceEntities()) { CartItem cartItemDb = entities.CartItems.Where(entry => entry.ProductID == viewModel.ProductId && entry.CartID == cart.ID).FirstOrDefault(); if (cartItemDb != null) { Product productDb = entities.Products.Where(entry => entry.ID == viewModel.ProductId).FirstOrDefault(); if (cartItemDb.Quentity != productDb.Quentity) { cartItemDb.Quentity = cartItemDb.Quentity + 1; responseViewModel.Data = cartItemDb; } else { responseViewModel.errorViewModel = new ErrorViewModel(); responseViewModel.errorViewModel.statusCode = 400; } } else { CartItem cartItem = new CartItem(); cartItem.ProductID = viewModel.ProductId; cartItem.Quentity = 1; cartItem.CartID = Convert.ToInt16(cart.ID); entities.CartItems.Add(cartItem); responseViewModel.Data = cartItem; entities.SaveChanges(); foreach (var option in optionList) { CartItemOption cartItemOption = new CartItemOption(); cartItemOption.CartItemID = cartItem.ID; cartItemOption.OptionsID = option.optionId; entities.CartItemOptions.Add(cartItemOption); } entities.SaveChanges(); } entities.SaveChanges(); } return(responseViewModel); }
public static Product UpdateProduct() { string imageName = null; HttpRequest httpRequest = HttpContext.Current.Request; var postedFile = httpRequest.Files["Image"]; imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-"); imageName = imageName + DateTime.Now.ToString("yymmssff") + Path.GetExtension(postedFile.FileName); var filePath = HttpContext.Current.Server.MapPath("~/Images/" + imageName); postedFile.SaveAs(filePath); Product productObj = new Product(); int id = Convert.ToInt16(httpRequest["id"]); productObj = JsonConvert.DeserializeObject<Product>(httpRequest["product"]); productObj.Image = imageName; List<OptionViewModel> options = JsonConvert.DeserializeObject<List<OptionViewModel>>(httpRequest["option"]); using (EcommerceEntities entities = new EcommerceEntities()) { Product productDb = entities.Products.Where(entry => entry.ID == id).FirstOrDefault(); if (productDb != null) { productDb.Name = productObj.Name; productDb.Price = productObj.Price; productDb.Image = productObj.Image; productDb.ProductCateogoryID = productObj.ProductCateogoryID; productDb.Discount = productObj.Discount; productDb.Quentity = productObj.Quentity; entities.SaveChanges(); foreach (var option in options) { Product_Attribute productAttribute = new Product_Attribute(); //option.productId = Convert.ToInt32(productObj.ID); productAttribute.ProductID = productObj.ID; productAttribute.OptionID = option.id; if (ProductManager.CheckDuplicateOption(option.id, productObj.ID)) { continue; } else { entities.Product_Attribute.Add(productAttribute); } entities.SaveChanges(); } } } return productObj; }
public static void AddCustomer(Customer customer) { using (EcommerceEntities entities = new EcommerceEntities()) { entities.Customers.Add(customer); entities.SaveChanges(); } }
public static ResponseViewModel <ProductAttribute> UpdateProductAttribute(ProductAttributeViewModel viewModel) { ResponseViewModel <ProductAttribute> responseViewModel = new ResponseViewModel <ProductAttribute>(); using (EcommerceEntities entities = new EcommerceEntities()) { ProductAttribute productAtributeDb = entities.ProductAttributes.Where(entry => entry.ID == viewModel.ID).FirstOrDefault(); productAtributeDb.Name = viewModel.attributeName; productAtributeDb.ProductCategoryID = viewModel.productCategoryId; productAtributeDb.ProductSubCategoryID = viewModel.productSubCategoryId; entities.SaveChanges(); ProductAttributeManager.AddOption(viewModel.options, productAtributeDb.ID); responseViewModel.Data = productAtributeDb; entities.SaveChanges(); return(responseViewModel); } }
public static void DeleteCustomer(int id) { using (EcommerceEntities entities = new EcommerceEntities()) { Customer customer = entities.Customers.Where(entry => entry.ID == id).FirstOrDefault(); entities.Customers.Remove(customer); entities.SaveChanges(); } }
public static void DeleteProductSubCategory(int id) { using (EcommerceEntities entities = new EcommerceEntities()) { ProductSubCategory productSubCategory = entities.ProductSubCategories.Where(entry => entry.ID == id).FirstOrDefault(); entities.ProductSubCategories.Remove(productSubCategory); entities.SaveChanges(); } }
public static void DeleteProductOptionById(int id) { using (EcommerceEntities entities = new EcommerceEntities()) { ProductAttributeOption propductAttributeOption = entities.ProductAttributeOptions.Where(entry => entry.ID == id).FirstOrDefault(); entities.ProductAttributeOptions.Remove(propductAttributeOption); entities.SaveChanges(); } }
public static void DeleteOrderStatus(int id) { using (EcommerceEntities entities = new EcommerceEntities()) { OrderStatu orderStatus = entities.OrderStatus.Where(entry => entry.ID == id).FirstOrDefault(); entities.OrderStatus.Remove(orderStatus); entities.SaveChanges(); } }
public static void DeleteProductAttribute(int id) { using (EcommerceEntities entities = new EcommerceEntities()) { ProductAttribute productAttribute = entities.ProductAttributes.Where(entry => entry.ID == id).FirstOrDefault(); ProductAttributeManager.DeleteOptionByAttributeId(productAttribute.ID); entities.ProductAttributes.Remove(productAttribute); entities.SaveChanges(); } }
public static User UpdateLastLogin(string emailId) { using (EcommerceEntities entities = new EcommerceEntities()) { User user = entities.Users.Where(entry => entry.Username == emailId).FirstOrDefault(); user.LastLoginTime = null; entities.SaveChanges(); return(user); } }
public static ResponseViewModel <User> ChangePassword(PasswordViewModel viewModel) { ResponseViewModel <User> responseViewModel = new ResponseViewModel <User>(); using (EcommerceEntities entities = new EcommerceEntities()) { if (viewModel.oldPassword != null) { User user = entities.Users.Where(entry => entry.ID == viewModel.id).FirstOrDefault(); if (user.Password == viewModel.oldPassword) { user.Password = viewModel.newPassword; user.LastLoginTime = DateTime.Now; responseViewModel.Data = user; entities.SaveChanges(); } else { responseViewModel.errorViewModel = new ErrorViewModel(); responseViewModel.errorViewModel.statusCode = 300; } return(responseViewModel); } else { User user = entities.Users.Where(entry => entry.Username == viewModel.emailId).FirstOrDefault(); if (user != null) { user.Password = viewModel.newPassword; responseViewModel.Data = user; entities.SaveChanges(); } else { responseViewModel.errorViewModel = new ErrorViewModel(); responseViewModel.errorViewModel.statusCode = 300; } return(responseViewModel); } } }
public int addItem(IItemDTO category) { int retVal = default(int); using (EcommerceEntities employeePortalEntities = new EcommerceEntities()) { try { Item employee = new Item(); EntityConverter.FillEntityFromDTO(category, employee); Item addedEmployee = employeePortalEntities.Items.Add(employee); employeePortalEntities.SaveChanges(); retVal = addedEmployee.ItemId; } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } } return retVal; }
public bool removeItem(int itemId) { bool retVal = false; try { using (var database = new EcommerceEntities()) { var itemEntities = database.Items; Item item = itemEntities.Where(i => i.ItemId == itemId).FirstOrDefault(); if (item != null) { itemEntities.Remove(item); database.SaveChanges(); retVal = true; } } } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } return retVal; }
public bool deleteSubCategory(int categoryId) { bool retVal = false; using (EcommerceEntities employeePortalEntities = new EcommerceEntities()) { try { SubCategory cat = employeePortalEntities.SubCategories.Where(category => category.SubCategotyId == categoryId).FirstOrDefault(); employeePortalEntities.SubCategories.Remove(cat); employeePortalEntities.SaveChanges(); retVal = true; } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } } return retVal; }
public ICategoriesDTO editCategory(ICategoriesDTO categoryDTO) { ICategoriesDTO retVal = null; try { using (var database = new EcommerceEntities()) { var category = database.Categories.Where(c => c.CategotyId == categoryDTO.CategotyId).FirstOrDefault(); if (category != null) { category.CategoryName = categoryDTO.CategoryName; database.SaveChanges(); retVal = (ICategoriesDTO)DTOFactory.Instance.Create(DTOType.Category, null); EntityConverter.FillDTOFromEntity(category, retVal); } } } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } return retVal; }
public bool EditSubCategory(ISubCategoriesDTO sub) { bool retVal = false; using (EcommerceEntities employeePortalEntities = new EcommerceEntities()) { try { var employeeEntity = employeePortalEntities.SubCategories.FirstOrDefault(employee => employee.SubCategotyId == sub.SubCategotyId); if (employeeEntity != null) { employeeEntity.CategotyId = sub.CategotyId; employeeEntity.SubCategoryName = sub.SubCategoryName; employeePortalEntities.SaveChanges(); retVal = true; } } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } } return retVal; }
public bool removeCategory(int categoryId) { bool retVal = false; try { using (var database = new EcommerceEntities()) { var categoryEntities = database.Categories; Category category = categoryEntities.Where(i => i.CategotyId == categoryId).FirstOrDefault(); if (category != null) { categoryEntities.Remove(category); database.SaveChanges(); retVal = true; } } } catch (Exception ex) { ExceptionManager.HandleException(ex); throw new DACException(ex.Message, ex); } return retVal; }