示例#1
0
 public ActionResult them_NV(NHANVIEN Nv, FormCollection form)
 {
     Nv.MA_NhanVien = UUID.GetUUID(5);
     Nv.MA_ChucVu   = form["cv"].ToString();;
     Nv.MA_PhongBan = form["pb"].ToString();
     Nv.MA_QNSD     = form["qsd"].ToString();
     if (form["GioiTinh_NV"] != null)
     {
         if ((form["GioiTinh_NV"].ToString() == "on"))
         {
             Nv.GioiTinh_NV = true;
         }
         else
         {
             Nv.GioiTinh_NV = false;
         }
     }
     else
     {
         Nv.GioiTinh_NV = false;
     }
     db.NHANVIENs.Add(Nv);
     db.SaveChanges();
     return(RedirectToAction("ListNV"));
 }
示例#2
0
        public ActionResult Edit_XX1(XETXU xx, FormCollection form)
        {
            XETXU newXetXu = db.XETXUs.FirstOrDefault(nxx => nxx.MA_XetXu == xx.MA_XetXu);

            newXetXu.Ngay_XetXu = xx.Ngay_XetXu;
            newXetXu.MA_DiaDiem = form["dd"].ToString();

            CHITIET_XX newThuKy = db.CHITIET_XX.FirstOrDefault(ntk => ntk.MA_XetXu == xx.MA_XetXu && ntk.MA_VaiTro == "C1");

            newThuKy.MA_NhanVien = form["tk"].ToString();

            CHITIET_XX newKiemSat = db.CHITIET_XX.FirstOrDefault(nks => nks.MA_XetXu == xx.MA_XetXu && nks.MA_VaiTro == "C3");

            newKiemSat.MA_NhanVien = form["ks"].ToString();

            ClearHoiDong(xx.MA_XetXu);
            List <string> selectedHoiDongList = form["hd"].Split(',').ToList();

            for (int i = 0; i < selectedHoiDongList.Count; i++)
            {
                CHITIET_XX hoidong = new CHITIET_XX
                {
                    MA_NhanVien  = selectedHoiDongList[i],
                    MA_VaiTro    = "C4",
                    MA_XetXu     = xx.MA_XetXu,
                    MA_ChiTietXX = UUID.GetUUID(5)
                };
                themChiTietXetXu(hoidong);
            }
            db.SaveChanges();
            return(RedirectToAction("ListXX"));
        }
        public ActionResult them_KQ(KETQUA_XX kqxx, FormCollection form, string troVe)
        {
            var listKetQua = from s in db.KETQUA_XX select s;

            if (db.KETQUA_XX.Any(x => x.MA_KetQuaXX == kqxx.MA_KetQuaXX))
            {
                return(RedirectToAction("ListKQ", new { error = 1 }));
            }
            kqxx.MA_XetXu = Convert.ToInt32(form["lxx"]);
            if (!ModelState.IsValid)
            {
                return(View(kqxx));
            }

            kqxx.MA_KetQuaXX = UUID.GetUUID(5);

            db.KETQUA_XX.Add(kqxx);
            db.SaveChanges();

            KETQUA_XX newKQXX = db.KETQUA_XX.Where(newKQ => newKQ.MA_KetQuaXX == kqxx.MA_KetQuaXX).FirstOrDefault();
            XETXU     newXX   = db.XETXUs.Where(xx => xx.MA_XetXu == newKQXX.MA_XetXu).FirstOrDefault();
            string    maHoSo  = newXX.MA_HoSo;
            HOSO_VUAN hoSo    = db.HOSO_VUAN.Where(hs => hs.MA_HoSo == maHoSo).FirstOrDefault();

            hoSo.MA_TrangThai = "03";
            db.SaveChanges();

            if (troVe == "troVe")
            {
                return(RedirectToAction("ListHS", "HoSoVuAn"));
            }
            return(RedirectToAction("ListKQ"));
        }
        //[ValidateInput(false)]
        ///[ValidateAntiForgeryToken]
        public ActionResult sua_HS1(HOSO_VUAN hs, FormCollection form, string id)
        {
            //ViewBag.lva = new SelectList(db.LOAI_VUAN.OrderBy(x => x.Ten_LoaiVA), "MA_LoaiVA", "Ten_LoaiVA");
            //ViewBag.tths = new SelectList(db.TRANGTHAI_HS.OrderBy(x => x.Ten_TT), "MA_TrangThai", "Ten_TT");

            //ViewBag.mnv = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV");

            hs.MA_LoaiVA = form["lva"].ToString();;

            hs.MA_NhanVien = form["mnv"].ToString();
            //hs.MA_HoSo = id;

            HOSO_VUAN hoSo = db.HOSO_VUAN.Where(newHoSo => newHoSo.MA_HoSo == hs.MA_HoSo).FirstOrDefault();

            hoSo.MA_NhanVien = hs.MA_NhanVien;
            hoSo.MA_LoaiVA   = hs.MA_LoaiVA;
            hoSo.Ten_VuAn    = hs.Ten_VuAn;
            hoSo.NoiDung_VA  = hs.NoiDung_VA;
            hoSo.Loai_HS     = hs.Loai_HS;
            hoSo.NgayNhan_HS = hs.NgayNhan_HS;

            //   db.Entry(hs).State = EntityState.Modified;
            db.SaveChanges();



            ClearNguyenDonBiDon(hs.MA_HoSo);

            List <string> selectedNguyenDonList = form["nd"].Split(',').ToList();

            for (int i = 0; i < selectedNguyenDonList.Count; i++)
            {
                CHITIET_DS nguyendon = new CHITIET_DS
                {
                    MA_DuongSu   = selectedNguyenDonList[i],
                    MA_LoaiDS    = "ND",
                    MA_HoSo      = hs.MA_HoSo,
                    MA_ChiTietDS = UUID.GetUUID(5)
                };
                themChiTietDuongSu(nguyendon);
            }
            List <string> selectedBiDonList = form["bd"].Split(',').ToList();

            for (int i = 0; i < selectedBiDonList.Count; i++)
            {
                CHITIET_DS bidon = new CHITIET_DS
                {
                    MA_DuongSu   = selectedBiDonList[i],
                    MA_LoaiDS    = "BD",
                    MA_HoSo      = hs.MA_HoSo,
                    MA_ChiTietDS = UUID.GetUUID(5)
                };
                themChiTietDuongSu(bidon);
            }
            return(RedirectToAction("ListHS"));
        }
        public ActionResult them_HS(HOSO_VUAN hs, FormCollection form)
        {
            //Tao ma tu dong
            hs.MA_HoSo = UUID.GetUUID(5);

            hs.MA_LoaiVA    = form["lva"].ToString();
            hs.MA_TrangThai = "01";
            hs.MA_NhanVien  = form["mnv"].ToString();

            db.HOSO_VUAN.Add(hs);
            db.SaveChanges();
            List <string> selectedNguyenDonList = form["nd"].Split(',').ToList();

            for (int i = 0; i < selectedNguyenDonList.Count; i++)
            {
                CHITIET_DS nguyendon = new CHITIET_DS
                {
                    MA_DuongSu   = selectedNguyenDonList[i],
                    MA_LoaiDS    = "ND",
                    MA_HoSo      = hs.MA_HoSo,
                    MA_ChiTietDS = UUID.GetUUID(5)
                };
                themChiTietDuongSu(nguyendon);
            }
            List <string> selectedBiDonList = form["bd"].Split(',').ToList();

            for (int i = 0; i < selectedBiDonList.Count; i++)
            {
                CHITIET_DS bidon = new CHITIET_DS
                {
                    MA_DuongSu   = selectedBiDonList[i],
                    MA_LoaiDS    = "BD",
                    MA_HoSo      = hs.MA_HoSo,
                    MA_ChiTietDS = UUID.GetUUID(5)
                };
                themChiTietDuongSu(bidon);
            }

            var list_HS = from s in db.HOSO_VUAN select s;

            ViewBag.lva  = new SelectList(db.LOAI_VUAN.OrderBy(x => x.Ten_LoaiVA), "MA_LoaiVA", "Ten_LoaiVA");
            ViewBag.tths = new SelectList(db.TRANGTHAI_HS.OrderBy(x => x.Ten_TT), "MA_TrangThai", "Ten_TT");
            ViewBag.nd   = new SelectList(db.DUONGSUs.OrderBy(x => x.HoTen_DS), "MA_DuongSu", "HoTen_DS");
            ViewBag.bd   = new SelectList(db.DUONGSUs.OrderBy(x => x.HoTen_DS), "MA_DuongSu", "HoTen_DS");
            ViewBag.mnv  = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV");

            return(RedirectToAction("ListHS"));
        }
示例#6
0
        public ActionResult AddVT(QUYEN_NSD vt, FormCollection form)
        {
            if (db.QUYEN_NSD.Any(x => x.MA_QNSD == vt.MA_QNSD))
            {
                return(View(vt));
            }

            if (!ModelState.IsValid)
            {
                return(View(vt));
            }
            vt.MA_QNSD = UUID.GetUUID(5);
            db.QUYEN_NSD.Add(vt);
            db.SaveChanges();
            return(RedirectToAction("ListVT"));
        }
 public ActionResult them_DS(DUONGSU ds, FormCollection form)
 {
     ds.MA_DuongSu = UUID.GetUUID(5);
     if (form["GioiTinh_DS"] != null)
     {
         if ((form["GioiTinh_DS"].ToString() == "on"))
         {
             ds.GioiTinh_DS = true;
         }
         else
         {
             ds.GioiTinh_DS = false;
         }
     }
     db.DUONGSUs.Add(ds);
     db.SaveChanges();
     return(RedirectToAction("ListDS"));
 }
        public ActionResult themLXX(XETXU xx, FormCollection form)
        {
            ViewBag.dd  = new SelectList(db.DIADIEM_XX.OrderBy(x => x.Ten_DiaDiem), "MA_DiaDiem", "Ten_DiaDiem");
            ViewBag.hs  = new SelectList(db.HOSO_VUAN.OrderBy(x => x.MA_HoSo), "MA_HoSo", "Ten_VuAn");
            ViewBag.hd  = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV");
            ViewBag.ks  = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV");
            ViewBag.tk  = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV");
            ViewBag.cxx = new SelectList(db.CAPXETXUs.OrderBy(x => x.MA_CapXetXu), "MA_CapXetXu", "TenCapXetXu");
            if (db.XETXUs.Any(x => x.MA_XetXu == xx.MA_XetXu))
            {
                return(RedirectToAction("ListXX", new { error = 1 }));
            }
            xx.MA_CapXetXu = form["cxx"].ToString();
            xx.MA_DiaDiem  = form["dd"].ToString();
            xx.MA_HoSo     = form["hs"].ToString();

            if (!ModelState.IsValid)
            {
                return(View(xx));
            }

            db.XETXUs.Add(xx);
            db.SaveChanges();

            HOSO_VUAN hoSo = db.HOSO_VUAN.Where(hs => hs.MA_HoSo == xx.MA_HoSo).FirstOrDefault();

            hoSo.MA_TrangThai = "02";
            db.SaveChanges();
            List <string> selectedHoiDongList = form["hd"].Split(',').ToList();

            for (int i = 0; i < selectedHoiDongList.Count; i++)
            {
                CHITIET_XX hoidong = new CHITIET_XX
                {
                    MA_NhanVien  = selectedHoiDongList[i],
                    MA_VaiTro    = "C4",
                    MA_XetXu     = xx.MA_XetXu,
                    MA_ChiTietXX = UUID.GetUUID(5)
                };
                themChiTietXetXu(hoidong);
            }
            CHITIET_XX kiemSat = new CHITIET_XX
            {
                MA_NhanVien  = form["ks"].ToString(),
                MA_VaiTro    = "C3",
                MA_XetXu     = xx.MA_XetXu,
                MA_ChiTietXX = UUID.GetUUID(5)
            };

            themChiTietXetXu(kiemSat);
            CHITIET_XX thuky = new CHITIET_XX
            {
                MA_NhanVien  = form["tk"].ToString(),
                MA_VaiTro    = "C1",
                MA_XetXu     = xx.MA_XetXu,
                MA_ChiTietXX = UUID.GetUUID(5)
            };

            themChiTietXetXu(thuky);
            return(RedirectToAction("ListXX"));
        }