public ActionResult ThemCHCC(FormCollection collection, CANHOCHUNGCU chcc)
 {
     try
     {
         // TODO: Add insert logic here
         chcc.NGUOILAPPHIEU  = int.Parse(collection["nlp12"]);
         chcc.NGUOIKIEMDUYET = int.Parse(collection["nkd12"]);
         chcc.NGUOILAPPHIEU  = int.Parse(collection["nlp12"]);
         chcc.NGUOIKIEMDUYET = int.Parse(collection["nkd12"]);
         chcc.ID_DDPL        = int.Parse(collection["ddpl12"]);
         chcc.ID_TIENDO      = int.Parse(collection["tiendo12"]);
         var qh = collection["qqqq"];
         chcc.ID_QUANHUYEN   = int.Parse(qh);
         chcc.ID_LOAIHINH    = int.Parse(collection["loaihinh12"]);
         chcc.ID_LTT         = int.Parse(collection["loaithongtin12"]);
         chcc.ID_CHITIETLOAI = int.Parse(collection["chitietloai12"]);
         chcc.ID_CAPDUONG    = int.Parse(collection["capduong12"]);
         chcc.ID_KETCAUDUONG = int.Parse(collection["ketcau12"]);
         chcc.ID_CRMD        = int.Parse(collection["chieurongmatduong12"]);
         chcc.SOHIEU         = collection["SOHIEU"] + "/2016/PTT-CHCC";
         chcc.NGAYTAO        = DateTime.Now;
         chcc.TRANGTHAI      = true;
         data.CANHOCHUNGCUs.InsertOnSubmit(chcc);
         data.SubmitChanges();
         return(RedirectToAction("Index"));
     }
     catch
     {
         return(View());
     }
 }
 //sua CHCC
 public ActionResult SuaCHCC(int id)
 {
     if (int.Parse(Session["Quyen"].ToString()) == 1)
     {
         CANHOCHUNGCU chcc = data.CANHOCHUNGCUs.FirstOrDefault(s => s.ID_CHCC == id);
         ViewData["ct"] = new SelectList(data
                                         .CHUNGTHUTDGs
                                         .Where(s => s.TRANGTHAI == true)
                                         .ToList(), "ID_CHUNGTHU", "SOCHUNGTHU", chcc.ID_CHUNGTHU);
         ViewData["tp12"]                = new SelectList(data.TINHTHANHs, "ID_TINHTHANH", "TEN");
         ViewData["ct"]                  = new SelectList(data.CHUNGTHUTDGs.Where(s => s.TRANGTHAI == true).ToList(), "ID_CHUNGTHU", "SOCHUNGTHU");
         ViewData["tiendo12"]            = new SelectList(data.TIENDOs, "ID_TIENDO", "TEN");
         ViewData["nlp12"]               = new SelectList(data.NHANVIENs, "ID_NHANVIEN", "TENNV");
         ViewData["nkd12"]               = new SelectList(data.NHANVIENs, "ID_NHANVIEN", "TENNV");
         ViewData["chieurongmatduong12"] = new SelectList(data.CHIEURONGMATDUONGs, "ID_CRMD", "TEN");
         ViewData["loaihinh12"]          = new SelectList(data.LOAIHINHs, "ID_LOAIHINH", "TEN");
         ViewData["ddpl12"]              = new SelectList(data.DACDIEMPHAPLies.Where(s => s.ID_LOAITAISAN == 2), "ID_DDPL", "TEN");
         ViewData["loaithongtin12"]      = new SelectList(data.LOAITHONGTINs.Where(s => s.ID_LOAITAISAN == 2), "ID_LTT", "TEN");
         ViewData["chitietloai12"]       = new SelectList(data.CHITIETLOAIs.Where(s => s.ID_LOAITAISAN == 2), "ID_CHITIETLOAI", "TEN");
         ViewData["capduong12"]          = new SelectList(data.CAPDUONGs, "ID_CAPDUONG", "TEN");
         ViewData["ketcau12"]            = new SelectList(data.KETCAUDUONGs, "ID_KETCAUDUONG", "TEN");
         ViewData["quanhuyen12"]         = new SelectList(data.QUANHUYENs, "ID_QUANHUYEN", "TEN");
         return(View(chcc));
     }
     else
     {
         Response.StatusCode = 403;
         return(null);
     }
 }
        public ActionResult SuaCHCC(int id, FormCollection collection)
        {
            CANHOCHUNGCU chcc = data.CANHOCHUNGCUs.FirstOrDefault(s => s.ID_CHCC == id);

            chcc.NGUOILAPPHIEU  = int.Parse(collection["nlp12"]);
            chcc.NGUOIKIEMDUYET = int.Parse(collection["nkd12"]);
            chcc.ID_DDPL        = int.Parse(collection["ddpl12"]);
            chcc.ID_TIENDO      = int.Parse(collection["tiendo12"]);
            var qh = collection["quanhuyen12"];

            chcc.ID_QUANHUYEN   = int.Parse(qh);
            chcc.ID_LOAIHINH    = int.Parse(collection["loaihinh12"]);
            chcc.ID_LTT         = int.Parse(collection["loaithongtin12"]);
            chcc.ID_CHITIETLOAI = int.Parse(collection["chitietloai12"]);
            chcc.ID_CAPDUONG    = int.Parse(collection["capduong12"]);
            chcc.ID_KETCAUDUONG = int.Parse(collection["ketcau12"]);
            chcc.ID_CRMD        = int.Parse(collection["chieurongmatduong12"]);
            chcc.SOHIEU         = collection["SOHIEU"];
            chcc.NGAYTAO        = DateTime.Now;
            UpdateModel(chcc);
            data.SubmitChanges();
            return(RedirectToAction("Index"));
        }