public ActionResult SuaPYC(int id, FormCollection collection)
 {
     try
     {
         if (Session["ID"] == null)
         {
             return(RedirectToAction("Login", "Login"));
         }
         // TODO: Add update logic here
         PHIEUYEUCAU pyc = data.PHIEUYEUCAUs.FirstOrDefault(s => s.ID_PYC == id);
         var         nv  = collection["Nhanvien3"];
         var         lts = collection["Loaitaisan3"];
         var         kh  = collection["Khachhang3"];
         pyc.ID_NHANVIEN   = int.Parse(nv);
         pyc.ID_KH         = int.Parse(nv);
         pyc.ID_LOAITAISAN = int.Parse(lts);
         pyc.NGAYSUA       = DateTime.Now;
         UpdateModel(pyc);
         data.SubmitChanges();
         return(RedirectToAction("XemPYC", "Kinhdoanh", new { id = id }));
     }
     catch
     {
         if (Session["ID"] == null)
         {
             return(RedirectToAction("Login", "Login"));
         }
         var pyc = data.PHIEUYEUCAUs.FirstOrDefault(s => s.ID_PYC == id);
         ViewData["Nhanvien3"]   = new SelectList(data.NHANVIENs.ToList().OrderBy(s => s.TENNV).Where(s => s.PHONGBAN.ID_PHONGBAN == 2), "ID_NHANVIEN", "TENNV", pyc.ID_NHANVIEN);
         ViewData["Khachhang3"]  = new SelectList(data.KHACHHANGs.ToList().OrderBy(s => s.TENKH), "ID_KH", "TENKH", pyc.ID_KH);
         ViewData["Loaitaisan3"] = new SelectList(data.LOAITAISANs.ToList().OrderBy(s => s.TEN), "ID_LOAITAISAN", "TEN", pyc.ID_LOAITAISAN);
         return(View());
     }
 }
        public ActionResult ThemPYC(FormCollection collection, PHIEUYEUCAU pyc)
        {
            //try
            //{
            //TODO: Add insert logic here
            var nv  = collection["nv"];
            var lts = collection["lts"];
            var kh  = collection["kh"];

            //no lỗi ngay đây. nếu chặn lại thì ko sao.
            pyc.ID_NHANVIEN   = int.Parse(nv);
            pyc.ID_LOAITAISAN = int.Parse(lts);
            pyc.ID_KH         = int.Parse(kh);
            pyc.NGAYTAO       = DateTime.Now;
            pyc.TRANGTHAI     = true;
            data.PHIEUYEUCAUs.InsertOnSubmit(pyc);
            data.SubmitChanges();
            return(RedirectToAction("ThemPYC"));
            //}
            //catch
            //{

            //    ViewData["nv"] = new SelectList(data.NHANVIENs.ToList().OrderBy(s => s.TENNV), "ID_NHANVIEN", "TENNV");
            //    ViewData["kh"] = new SelectList(data.KHACHHANGs.ToList().OrderBy(s => s.TENKH), "ID_KH", "TENKH");
            //    ViewData["lts"] = new SelectList(data.LOAITAISANs.ToList().OrderBy(s => s.TEN), "ID_LOAITAISAN", "TEN");
            //    return View();
            //}
        }
 public ActionResult ThemPYC(FormCollection collection, PHIEUYEUCAU pyc, THONGBAO tb)
 {
     try
     {
         if (Session["ID"] == null)
         {
             return(RedirectToAction("Login", "Login"));
         }
         //TODO: Add insert logic here
         var nv  = collection["Nhanvien3"];
         var lts = collection["Loaitaisan3"];
         var kh  = collection["Khachhang3"];
         //no lỗi ngay đây. nếu chặn lại thì ko sao.
         pyc.SOPYC         = collection["SOPYC"] + "/2016/PYC-AMAX";
         pyc.NGAYTAO       = DateTime.Now;
         pyc.TRANGTHAI     = true;
         pyc.ID_NHANVIEN   = int.Parse(nv);
         pyc.ID_LOAITAISAN = int.Parse(lts);
         pyc.ID_KH         = int.Parse(kh);
         data.PHIEUYEUCAUs.InsertOnSubmit(pyc);
         data.SubmitChanges();
         var id = data.PHIEUYEUCAUs.FirstOrDefault(s => s.SOPYC == pyc.SOPYC);
         tb.ID_PYC       = id.ID_PYC;
         tb.ID_NGUOIGUI  = 1;
         tb.ID_NGUOINHAN = int.Parse(nv);
         tb.NOIDUNG      = "Bạn được giao: " + collection["SOPYC"] + "/2016/PYC-AMAX";
         tb.NGAYGUI      = DateTime.Now;
         tb.TRANGTHAIXEM = false;
         tb.TRANGTHAI    = true;
         data.THONGBAOs.InsertOnSubmit(tb);
         data.SubmitChanges();
         return(RedirectToAction("ThemPYC"));
     }
     catch
     {
         if (Session["ID"] == null)
         {
             return(RedirectToAction("Login", "Login"));
         }
         ViewData["Nhanvien3"]   = new SelectList(data.NHANVIENs.ToList().OrderBy(s => s.TENNV).Where(s => s.PHONGBAN.ID_PHONGBAN == 2), "ID_NHANVIEN", "TENNV");
         ViewData["Khachhang3"]  = new SelectList(data.KHACHHANGs.ToList().OrderBy(s => s.TENKH), "ID_KH", "TENKH");
         ViewData["Loaitaisan3"] = new SelectList(data.LOAITAISANs.ToList().OrderBy(s => s.TEN), "ID_LOAITAISAN", "TEN");
         ViewBag.Thongbao        = "0";
         return(View());
     }
 }