Exemple #1
0
        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);
        }
Exemple #2
0
 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());
        }
Exemple #5
0
 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));
        }
Exemple #8
0
        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();
        }
Exemple #10
0
 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));
 }
Exemple #11
0
        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;
        }
Exemple #15
0
 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();
     }
 }
Exemple #16
0
        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);
        }
Exemple #17
0
        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);
        }
Exemple #18
0
        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);
        }
Exemple #19
0
        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);
        }
Exemple #20
0
        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();
     }
 }
Exemple #23
0
        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();
     }
 }
Exemple #26
0
 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();
     }
 }
Exemple #27
0
 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();
     }
 }
Exemple #28
0
 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;
 }