public ActionResult Edit(long ID)
        {
            context = new ShopLaptionDbContextDataContext();
            var user = context.Users.SingleOrDefault(x => x.ID == ID);

            return(View(user));
        }
        public ActionResult Index()
        {
            context = new ShopLaptionDbContextDataContext();
            var hd = context.Orders.Where(x => x.TinhTrang == false).ToList();

            return(View(hd));
        }
Exemplo n.º 3
0
        public ActionResult Index()
        {
            context = new ShopLaptionDbContextDataContext();
            List <Product> products = context.Products.ToList();

            return(View(products));
        }
        public ActionResult Edit(string MaHD)
        {
            context = new ShopLaptionDbContextDataContext();
            var hd = context.Orders.SingleOrDefault(x => x.MaDH.Equals(MaHD));

            return(View(hd));
        }
Exemplo n.º 5
0
        public ActionResult Details(long ID)
        {
            context = new ShopLaptionDbContextDataContext();
            var product = context.Products.SingleOrDefault(x => x.ID == ID);

            return(View(product));
        }
        public ActionResult Create(Category category)
        {
            context = new ShopLaptionDbContextDataContext();
            if (ModelState.IsValid)
            {
                var check_name = context.Categories.Any(a => a.Name.Equals(category.Name));
                if (check_name)
                {
                    ModelState.AddModelError("", "Thương hiệu này đã tồn tại !");
                    return(View());
                }
                else
                {
                    category.CreatedBy   = Session[CommonConstants.NAME_SESSION].ToString();
                    category.CreatedDate = DateTime.Now;
                    category.Name.ToUpper();

                    context.Categories.InsertOnSubmit(category);
                    context.SubmitChanges();

                    return(RedirectToAction("Index"));
                }
            }
            return(RedirectToAction("Index"));
        }
        public ActionResult HoaDonDaXuLy()
        {
            context = new ShopLaptionDbContextDataContext();
            var hd = context.Orders.Where(x => x.TinhTrang == true).ToList();

            return(View(hd));
        }
        public void SetRelatedProduct()
        {
            context = new ShopLaptionDbContextDataContext();
            var listRelatedPro = context.Products.ToList();

            ViewBag.RelatedProducts = listRelatedPro;
        }
        public ActionResult Index()
        {
            context = new ShopLaptionDbContextDataContext();
            List <User> users = context.Users.ToList();

            return(View(users));
        }
        public ActionResult Index(LoginModel model)
        {
            using (ShopLaptionDbContextDataContext context = new ShopLaptionDbContextDataContext())
            {
                int check = 0;
                if (ModelState.IsValid)
                {
                    var res = context.Users.SingleOrDefault(x => x.UserName.Equals(model.UserName));
                    if (res == null)
                    {
                        check = 0;
                    }
                    else
                    {
                        if (res.Password == model.Password)
                        {
                            check = 1;
                        }
                        else
                        {
                            check = -1;
                        }
                    }
                    switch (check)
                    {
                    case 0:
                    {
                        ModelState.AddModelError("", "Tài khoản không tồn tại !");
                        break;
                    }

                    case 1:
                    {
                        var user        = context.Users.SingleOrDefault(x => x.UserName == model.UserName);
                        var userSession = new UserLogin
                        {
                            UserName   = user.UserName,
                            Name       = user.Name,
                            UserID     = user.ID,
                            Permission = (int)user.Permission
                        };

                        Session.Add(CommonConstants.USER_SESSION, userSession);
                        Session.Add(CommonConstants.NAME_SESSION, userSession.Name);
                        Session.Add(CommonConstants.IDUSER_SESSION, userSession.UserID);
                        Session.Add(CommonConstants.PERMISSION_SESSION, userSession.Permission);

                        return(RedirectToActionPermanent("Index", "Home"));
                    }

                    case -1:
                    {
                        ModelState.AddModelError("", "Mật khẩu không đúng !");
                        break;
                    }
                    }
                }
                return(View("Index"));
            }
        }
        public ActionResult Index()
        {
            context = new ShopLaptionDbContextDataContext();
            List <Category> categories = context.Categories.ToList();

            return(View(categories));
        }
Exemplo n.º 12
0
        public ActionResult FullProduct()
        {
            SetViewbag();
            context = new ShopLaptionDbContextDataContext();
            List <Product> products = context.Products.ToList();

            return(View(products));
        }
Exemplo n.º 13
0
        public ActionResult ShowByBrand(string brand)
        {
            SetViewbag();
            SetRelatedProduct();
            context = new ShopLaptionDbContextDataContext();
            var brandThisProduct = context.Products.Where(x => x.Brand == brand).ToList();

            return(View(brandThisProduct));
        }
        public ActionResult XacNhanDonHang(string MaHD)
        {
            context = new ShopLaptionDbContextDataContext();

            var dh = context.Orders.SingleOrDefault(x => x.MaDH.Equals(MaHD));

            dh.TinhTrang = true;

            context.SubmitChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Delete(long ID)
        {
            try
            {
                context = new ShopLaptionDbContextDataContext();
                var category = context.Categories.FirstOrDefault(x => x.ID == ID);
                context.Categories.DeleteOnSubmit(category);
                context.SubmitChanges();

                return(RedirectToAction("Index"));
            }
            catch (Exception)
            {
                return(RedirectToAction("Index"));
            }
        }
        public ActionResult Details(string MaHD)
        {
            context = new ShopLaptionDbContextDataContext();
            List <OrderDetail> ctHD = context.OrderDetails.Where(x => x.MaDH.Equals(MaHD)).ToList();

            var temp = context.OrderDetails.FirstOrDefault(x => x.MaDH.Equals(MaHD));
            var dh   = context.Orders.SingleOrDefault(x => x.MaDH == MaHD);


            ViewBag.CTDonhang = dh;

            ViewBag.TongTien = temp.Tong; // Tổng này là tổng của 1 món hàng hóa thôi mà.
            ViewBag.MaHoaDon = temp.MaDH;


            return(View(ctHD));
        }
        public ActionResult Edit(User account)
        {
            context = new ShopLaptionDbContextDataContext();
            if (ModelState.IsValid)
            {
                var user = context.Users.SingleOrDefault(x => x.ID == account.ID);

                user.Name         = account.Name;
                user.Address      = account.Address;
                user.Email        = account.Email;
                user.Phone        = account.Phone;
                user.ModifiedDate = DateTime.Now;
                user.ModifiedBy   = Session[CommonConstants.NAME_SESSION].ToString();
                context.SubmitChanges();

                return(RedirectToAction("Index"));
            }
            return(View("Index"));
        }
        public ActionResult Create(User user)
        {
            context = new ShopLaptionDbContextDataContext();
            if (ModelState.IsValid)
            {
                var check_user  = context.Users.Any(a => a.UserName.Equals(user.UserName));
                var check_email = context.Users.Any(a => a.Email.Equals(user.Email));
                var res_val     = new MyValidate();

                if (check_user)
                {
                    ModelState.AddModelError("", "Tài khoản đã tồn tại !");
                    return(View());
                }
                else if (check_email)
                {
                    ModelState.AddModelError("", "Email đã tồn tại !");
                    return(View());
                }
                else if (res_val.isEmail(user.Email) == false)
                {
                    ModelState.AddModelError("", "Email không đúng định dạng !");
                    return(View());
                }
                else if (res_val.IsValidPhone(user.Phone) == false)
                {
                    ModelState.AddModelError("", "Số điện thoại không đúng !");
                    return(View());
                }
                else
                {
                    user.CreatedBy   = Session[CommonConstants.NAME_SESSION].ToString();
                    user.CreatedDate = DateTime.Now;

                    context.Users.InsertOnSubmit(user);
                    context.SubmitChanges();

                    return(RedirectToAction("Index"));
                }
            }
            return(RedirectToAction("Index"));
        }
        public ActionResult Delete(long ID)
        {
            try
            {
                context = new ShopLaptionDbContextDataContext();

                //if (Session[CommonConstants.PERMISSION_SESSION == 1])
                //{

                //}
                var user = context.Users.FirstOrDefault(x => x.ID == ID);
                context.Users.DeleteOnSubmit(user);
                context.SubmitChanges();

                return(RedirectToAction("Index"));
            }
            catch (Exception)
            {
                return(RedirectToAction("Index"));
            }
        }
        public ActionResult Edit(Order order)
        {
            context = new ShopLaptionDbContextDataContext();
            try
            {
                if (ModelState.IsValid)
                {
                    var hd = context.Orders.SingleOrDefault(x => x.MaDH.Equals(order.MaDH));

                    hd.DiaChi = order.DiaChi;
                    hd.GhiChu = order.GhiChu;

                    context.SubmitChanges();
                }
                return(RedirectToAction("Index"));
            }
            catch (Exception)
            {
                ModelState.AddModelError("", "Chỉnh sửa thất bại !");
                return(View());
            }
        }
        public ActionResult Delete(string MaHD)
        {
            try
            {
                context = new ShopLaptionDbContextDataContext();

                var hd   = context.Orders.FirstOrDefault(x => x.MaDH == MaHD);
                var cthd = context.OrderDetails.FirstOrDefault(x => x.MaDH == MaHD);

                context.Orders.DeleteOnSubmit(hd);
                context.SubmitChanges();

                context.OrderDetails.DeleteOnSubmit(cthd);
                context.SubmitChanges();

                return(RedirectToAction("Index"));
            }

            catch (Exception)
            {
                return(RedirectToAction("Index"));
            }
        }
Exemplo n.º 22
0
        public ActionResult Create(Product product, HttpPostedFileBase image)
        {
            context = new ShopLaptionDbContextDataContext();

            if (image != null && image.ContentLength > 0)
            {
                //product.ImageByte = new byte[image.ContentLength];
                //image.InputStream.Read(product.ImageByte, 0, image.ContentLength);
                string filename = System.IO.Path.GetFileName(image.FileName);
                string urlname  = Server.MapPath("~/Assets/Image/Product/General/" + filename);
                image.SaveAs(urlname);

                product.Image = "~/Assets/Image/Product/General/" + filename;
            }
            if (ModelState.IsValid)
            {
                var check_product_code = context.Products.Any(a => a.Code.Equals(product.Code));
                if (check_product_code)
                {
                    ModelState.AddModelError("", "Mã sản phẩm đã tồn tại !");
                    return(View());
                }
                else
                {
                    product.CreatedBy   = Session[CommonConstants.NAME_SESSION].ToString();
                    product.CreatedDate = DateTime.Now;
                    product.Name.ToUpper();

                    context.Products.InsertOnSubmit(product);
                    context.SubmitChanges();

                    return(RedirectToAction("Index"));
                }
            }
            SetViewbag();
            return(View(product));
        }
Exemplo n.º 23
0
        public ActionResult Edit(Product product, HttpPostedFileBase image)
        {
            SetViewbag();
            context = new ShopLaptionDbContextDataContext();

            if (ModelState.IsValid)
            {
                var proc = context.Products.SingleOrDefault(x => x.ID == product.ID);

                if (image != null && image.ContentLength > 0)
                {
                    string filename = System.IO.Path.GetFileName(image.FileName);
                    string urlname  = Server.MapPath("~/Assets/Image/Product/General/" + filename);
                    image.SaveAs(urlname);

                    proc.Image = "~/Assets/Image/Product/General/" + filename;
                }
                proc.Name         = product.Name;
                proc.Code         = product.Code;
                proc.Brand        = product.Brand;
                proc.Description  = product.Description;
                proc.Price        = product.Price;
                proc.Quantity     = product.Quantity;
                proc.Screen       = product.Screen;
                proc.CPU          = product.CPU;
                proc.RAM          = product.RAM;
                proc.Card         = product.Card;
                proc.Disk         = product.Disk;
                proc.ModifiedDate = DateTime.Now;
                proc.ModifiedBy   = Session[CommonConstants.NAME_SESSION].ToString();

                context.SubmitChanges();

                return(RedirectToAction("Index"));
            }
            return(View(product));
        }
Exemplo n.º 24
0
 public CategoryDao()
 {
     context = new ShopLaptionDbContextDataContext();
 }
        public ActionResult DatHang(FormCollection collection)
        {
            context = new ShopLaptionDbContextDataContext();
            SetViewbag();
            SetListOrder();
            ViewBag.TongTien = TongTien();

            var            res      = new MyValidate();
            Order          order    = new Order();
            List <GioHang> gioHangs = GetOrders();

            order.MaDH      = "HD" + DateTime.Now.ToString("yyyyMMddHHmmsss");
            order.TenKH     = collection["tenKH"];
            order.Sdt       = collection["sdt"];
            order.DiaChi    = collection["diachi"];
            order.NgayDat   = DateTime.Now;
            order.GhiChu    = collection["ghichu"];
            order.TinhTrang = false;

            //bool v = res.IsValidPhone(order.Sdt);

            if (String.IsNullOrEmpty(order.TenKH))
            {
                ViewData["err1"] = "Vui lòng nhập họ tên của bạn !";
            }
            else if (String.IsNullOrEmpty(order.Sdt))
            {
                ViewData["err2"] = "Vui lòng nhập số điện thoại liên lạc !";
            }
            else if (res.IsValidPhone(order.Sdt) == false)
            {
                ViewData["err3"] = "Số điện thoại bạn nhập không đúng định dạng!";
            }
            else if (String.IsNullOrEmpty(order.DiaChi))
            {
                ViewData["err4"] = "Vui lòng nhập địa chỉ giao hàng !";
            }
            else
            {
                context.Orders.InsertOnSubmit(order);
                context.SubmitChanges();

                foreach (var item in gioHangs)
                {
                    OrderDetail orderDetail = new OrderDetail();
                    orderDetail.MaDH    = order.MaDH;
                    orderDetail.MaSP    = item.masp;
                    orderDetail.TenSP   = item.tensp;
                    orderDetail.Soluong = item.sl;
                    orderDetail.DonGia  = (decimal)item.gia;
                    orderDetail.Tong    = (decimal)TongTien();

                    var pro = context.Products.SingleOrDefault(x => x.Code == orderDetail.MaSP);
                    pro.Quantity = pro.Quantity - orderDetail.Soluong;

                    context.OrderDetails.InsertOnSubmit(orderDetail);
                    context.SubmitChanges();
                }

                context.SubmitChanges();
                Session["order"] = null;
                return(RedirectToAction("XacNhanDonHang", "Card"));
            }
            return(View());
        }