public ActionResult ThemCT(FormCollection collection, CHUNGTHUTDG ct)
        {
            try
            {
                if (Session["ID"] == null)
                {
                    return(RedirectToAction("Login", "Login"));
                }
                // TODO: Add insert logic here
                var hd  = collection["hd"];
                var pyc = collection["pyc"];
                ct.SOCHUNGTHU = collection["SOCHUNGTHU"] + "/2016/CTTDG-AMAX";
                if (collection["hd"] != "")
                {
                    ct.ID_HOPDONG = int.Parse(hd);
                }

                ct.ID_PYC    = int.Parse(pyc);
                ct.NGAYTAO   = DateTime.Now;
                ct.TRANGTHAI = true;
                data.CHUNGTHUTDGs.InsertOnSubmit(ct);
                data.SubmitChanges();
                return(RedirectToAction("ThemCT"));
            }
            catch
            {
                if (Session["ID"] == null)
                {
                    return(RedirectToAction("Login", "Login"));
                }
                ViewData["hd"]  = new SelectList(data.HOPDONGs.ToList().OrderBy(s => s.SOHD), "ID_HOPDONG", "SOHD");
                ViewData["pyc"] = new SelectList(data.PHIEUYEUCAUs.ToList().OrderByDescending(s => s.NGAYVIETPHIEU), "ID_PYC", "SOPYC");
                return(View());
            }
        }
        public ActionResult SuaCT(int id, FormCollection collection)
        {
            try
            {
                if (Session["ID"] == null)
                {
                    return(RedirectToAction("Login", "Login"));
                }
                // TODO: Add update logic here
                CHUNGTHUTDG pyc = data.CHUNGTHUTDGs.FirstOrDefault(s => s.ID_CHUNGTHU == id);
                var         hd  = collection["hopdong3"];
                if (hd != "")
                {
                    pyc.ID_HOPDONG = int.Parse(hd);
                }
                var a = collection["pyc3"];

                pyc.ID_PYC  = int.Parse(a);
                pyc.NGAYSUA = DateTime.Now;
                UpdateModel(pyc);
                data.SubmitChanges();
                return(RedirectToAction("XemCTChungthu", "Kinhdoanh", new { id = id }));
            }
            catch
            {
                if (Session["ID"] == null)
                {
                    return(RedirectToAction("Login", "Login"));
                }
                var pyc = data.CHUNGTHUTDGs.FirstOrDefault(s => s.ID_CHUNGTHU == id && s.TRANGTHAI == true);
                ViewBag.Demfile      = data.FILEDINHKEMs.Where(s => s.ID_CHUNGTHU == id && s.TRANGTHAI == true).Count();
                ViewData["hopdong3"] = new SelectList(data.HOPDONGs.ToList().OrderBy(s => s.SOHD), "ID_HOPDONG", "SOHD", pyc.ID_HOPDONG);
                ViewData["PYC3"]     = new SelectList(data.PHIEUYEUCAUs.ToList().OrderBy(s => s.SOPYC), "ID_PYC", "SOPYC", pyc.ID_PYC);
                return(View());
            }
        }