Example #1
0
        public ActionResult Update(int?HT_id)
        {
            //  ModelState.Clear();
            var model  = HT_id.HasValue ? db.nvQTHocTap.Find(HT_id) : new nvQTHocTap();
            var prefix = "" + Request.Form["Prefix"];

            TryUpdateModel(model, !HT_id.HasValue ? prefix : prefix + ".item");
            if (ModelState.IsValid)
            {
                if (!HT_id.HasValue)
                {
                    //check db khi deploy
                    if (!model.QuocGia_id.HasValue)
                    {
                        model.QuocGia_id = 1;
                    }
                    if (!model.XepLoaiTotNghiep_id.HasValue)
                    {
                        model.XepLoaiTotNghiep_id = 4;
                    }
                    if (!model.HienTrang_id.HasValue)
                    {
                        model.HienTrang_id = 1;
                    }
                    db.nvQTHocTap.Add(model);
                }
                else
                {
                    db.Entry(model).State = EntityState.Modified;
                }
                db.SaveChanges();
                if (model.KetThucChinhThuc.HasValue)
                {
                    try
                    {
                        int tmp = 0;
                        tmp = db.nvBangCap.Where(m => m.HoTro == model.id).Select(m => m.id).FirstOrDefault();
                        nvBangCap bc = db.nvBangCap.Find(tmp);
                        if (tmp != 0)
                        {
                            bc.Xoa = false;
                            db.SaveChanges();
                        }
                        else
                        {
                            themBangCap(Convert.ToInt32(model.NV_id), Convert.ToInt32(model.LoaiBangCap_id), 1, model.TenTruong, Convert.ToInt32(model.ChuyenNganh_id), model.ChuyenNganh, Convert.ToInt32(model.LoaiHinhDaoTao_id), Convert.ToDateTime(model.KetThucChinhThuc), Convert.ToInt32(model.XepLoaiTotNghiep_id), false, model.GhiChu, Convert.ToInt32(model.NoiHoc_id), Convert.ToInt32(model.QuocGia_id), false, model.id);
                        }
                    }
                    catch { }
                }

                TempData["Message"] = "Thành công";
            }
            else
            {
                TempData["Model"] = model;
            }
            TempData["ModelState"] = ModelState;
            return(RedirectToAction("Index"));
        }
 public string Create(string dm, DanhMuc model)
 {
     if (ModelState.IsValid)
     {
         var danhmuc = db.makeDanhMuc(dm, model);
         TryValidateModel(danhmuc);
         if (ModelState.IsValid)
         {
             if (model.stt.HasValue)
             {
                 db.updateSTT(dm, model.stt.Value);
             }
             db.Entry(danhmuc).State = EntityState.Added;
             db.SaveChanges();
             // for unit testing
             model.id = (int)danhmuc.GetType().GetProperty("id").GetValue(danhmuc, null);
             return("OK");
         }
     }
     foreach (var state in ModelState.Values)
     {
         if (state.Errors.Count > 0)
         {
             return(state.Errors[0].ErrorMessage);
         }
     }
     return("ModelState Invalid!");
 }
        public ActionResult Update(int NV_id, int[] CT_id)
        {
            ModelState.Clear();
            var models = db.nvQLTapSu.Where(ct => CT_id.Contains(ct.CT_id));

            foreach (var item in models)
            {
                TryUpdateModel <nvQLTapSu>(item, String.Format("{0}.{1}", NV_id, item.CT_id));
            }
            if (ModelState.IsValid)
            {
                foreach (var item in models)
                {
                    db.Entry(item).State = EntityState.Modified;
                }
                db.SaveChanges();
                TempData["Message"] = "CapNhatThanhCong";
            }
            else
            {
                TempData["Message"] = "CapNhatKhongThanhCong";
            }
            TempData["NV_id"] = NV_id;
            return(RedirectToAction("Index", new { From = Request["From"], To = Request["To"], All = Request["All"] }));
        }
Example #4
0
        public ActionResult Update(int?BC_id)
        {
            var model  = BC_id.HasValue ? db.nvBangCap.Find(BC_id) : new nvBangCap();
            var prefix = "" + Request.Form["Prefix"];

            TryUpdateModel(model, !BC_id.HasValue ? prefix : prefix + ".item");
            if (ModelState.IsValid)
            {
                if (!BC_id.HasValue)
                {
                    db.nvBangCap.Add(model);
                }
                else
                {
                    db.Entry(model).State = EntityState.Modified;
                }
                db.SaveChanges();
                TempData["Message"] = "Thành công";
            }
            else
            {
                TempData["Model"] = model;
            }
            TempData["ModelState"] = ModelState;
            return(RedirectToAction("Details/" + model.NV_id, "HSNhanSu", new { tab = "QTHocTap" }));
        }
        public ActionResult Update(int?TH_id)
        {
            var model  = TH_id.HasValue ? db.TapHuan.Find(TH_id) : new TapHuan();
            var prefix = "" + Request.Form["Prefix"];

            TryUpdateModel(model, !TH_id.HasValue ? prefix : prefix + ".item");
            if (ModelState.IsValid)
            {
                if (!TH_id.HasValue)
                {
                    db.TapHuan.Add(model);
                }
                else
                {
                    db.Entry(model).State = EntityState.Modified;
                }
                db.SaveChanges();
                TempData["Message"] = "CapNhatThanhCong";
            }
            else
            {
                TempData["Model"] = model;
            }
            TempData["ModelState"] = ModelState;
            return(RedirectToAction("Details/" + model.id, "HSNhanSu", new { tab = "SoTayCT" }));
        }
Example #6
0
        public ActionResult Update(int?BD_id)
        {
            var model  = BD_id.HasValue ? db.BoiDuongChuyenMon.Find(BD_id) : new BoiDuongChuyenMon();
            var prefix = String.Format("{0}", Request.Form["Prefix"]);

            TryUpdateModel(model, !BD_id.HasValue ? prefix : prefix + ".item");
            if (ModelState.IsValid)
            {
                if (!BD_id.HasValue)
                {
                    db.BoiDuongChuyenMon.Add(model);
                }
                else
                {
                    db.Entry(model).State = EntityState.Modified;
                }
                db.SaveChanges();
                TempData["Message"] = "CapNhatThanhCong";
            }
            else
            {
                TempData["Model"] = model;
            }
            TempData["ModelState"] = ModelState;
            return(RedirectToAction("Details/" + model.NV_id, "HSNhanSu", new { tab = "BoiDuongChuyenMon" }));
        }
        public PartialViewResult Index()
        {
            var model = (from donvi in db.dmDonVi
                         orderby donvi.stt
                         select donvi).ToList();

            for (int i = 0, c = 1; i < model.Count; i++, c++)
            {
                if (model[i].stt != c)
                {
                    model[i].stt             = c;
                    db.Entry(model[i]).State = EntityState.Modified;
                }
            }
            db.SaveChanges();
            return(PartialView(model));
        }
        public PartialViewResult Index()
        {
            var model = (from ngach in db.dmNgachVienChuc
                         orderby ngach.stt
                         select ngach).ToList();

            for (int i = 0, c = 1; i < model.Count; i++, c++)
            {
                if (model[i].stt != c)
                {
                    model[i].stt             = c;
                    db.Entry(model[i]).State = EntityState.Modified;
                }
            }
            db.SaveChanges();
            return(PartialView(model));
        }
Example #9
0
 public ActionResult Edit(QuaTrinhHoc quatrinhhoc)
 {
     if (ModelState.IsValid)
     {
         db.Entry(quatrinhhoc).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(quatrinhhoc));
 }
 public string Edit(dmBangLuong model)
 {
     if (ModelState.IsValid)
     {
         db.Entry(model).State = EntityState.Modified;
         db.SaveChanges();
         return("OK");
     }
     return("ModelState Invalid!");
 }
Example #11
0
 public string Edit(dmPhuongXa model)
 {
     if (ModelState.IsValid)
     {
         db.Entry(model).State = EntityState.Modified;
         db.SaveChanges();
         return("OK");
     }
     return(ModelState.getErrorMessage());
 }
Example #12
0
        public static void updateSTT(this HRMDBEntities db, string name, int start)
        {
            var dbset = db.GetType().GetProperty("dm" + name).GetValue(db, null) as IEnumerable <object>;

            dbset.Where(dm => dm.stt() >= start).ToList().ForEach(
                dm =>
            {
                dm.stt(dm.stt().Value + 1);
                db.Entry(dm).State = EntityState.Modified;
            });
        }
 public ActionResult Edit(DanhHieu danhhieu)
 {
     if (ModelState.IsValid)
     {
         db.Entry(danhhieu).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.TenDanhHieu_id = new SelectList(db.dmDanhHieu, "id", "TenDanhHieu", danhhieu.TenDanhHieu_id);
     ViewBag.NV_id          = new SelectList(db.NhanVien, "id", "MaNV", danhhieu.NV_id);
     return(View(danhhieu));
 }
 public static void taoNhanVienMoi_Ten(string maHS, string maNV, string HoTen)
 {
     taoNhanVienMoi(maHS, maNV);
     using (var db = new HRMDBEntities())
     {
         var nv   = db.NhanViens.All.Single(n => n.MaNV == maNV);
         var syll = nv.nvSoYeuLyLiches.First();
         syll.HoVaTen         = HoTen;
         db.Entry(syll).State = EntityState.Modified;
         db.SaveChanges();
     }
 }
 public string Edit(dmLoaiNghiNganHan model)
 {
     if (model.stt <= 0)
     {
         return("STT phải lớn hơn 0!");
     }
     if (ModelState.IsValid)
     {
         var nghi = db.dmLoaiNghiNganHan.AsNoTracking().Single(dm => dm.id == model.id);
         if (nghi.stt != model.stt)
         {
             db.dmLoaiNghiNganHan.Where(dm => dm.stt >= model.stt).ToList().ForEach(
                 dm => { dm.stt++;
                         db.Entry(dm).State = EntityState.Modified; });
         }
         db.Entry(model).State = EntityState.Modified;
         db.SaveChanges();
         return("OK");
     }
     return("ModelState Invalid!");
 }
 public ActionResult Rename(TaiNguyen model, string folder)
 {
     if (ModelState.IsValid)
     {
         using (var scope = new TransactionScope())
             try
             {
                 db.Entry(model).State = EntityState.Modified;
                 db.SaveChanges();
                 model.Include(db);
                 if (model.laThuMuc)
                 {
                     Rename(folder, model.getFolder());
                 }
                 scope.Complete();
                 return(RedirectToAction("Index", new { parent = model.idTaiNguyen }));
             }
             catch (Exception e)
             {
                 ModelState.AddModelError("tenTaiNguyen", e.Message);
             }
     }
     return(View(model));
 }
Example #17
0
        public ActionResult Update(int NV_id)
        {
            var model = db.NhanViens.All.Find(NV_id).nvTTMoRongs.Single();

            ModelState.Clear();
            TryUpdateModel(model);
            if (ModelState.IsValid)
            {
                db.Entry(model).State = EntityState.Modified;
                db.SaveChanges();
                TempData["Message"] = "CapNhatThanhCong";
            }
            ViewBag.DB             = db;
            TempData["ModelState"] = ModelState;
            return(RedirectToAction("Details/" + NV_id, "HSNhanSu", new { tab = "nvTTMoRong" }));
        }
Example #18
0
        public static IEnumerable <DanhMuc> loadDanhMuc(this HRMDBEntities db, string name)
        {
            var dbset = db.GetType().GetProperty("dm" + name).GetValue(db, null);
            var list  = (dbset as IEnumerable <object>).ToList();

            list.Sort(new Comparison <object>((o1, o2) => o1.CompareTo(o2)));
            for (int i = 0, c = 1; i < list.Count; i++, c++)
            {
                if (list[i].stt() != c)
                {
                    list[i].stt(c);
                    db.Entry(list[i]).State = EntityState.Modified;
                }
            }
            db.SaveChanges();
            return((from dm in list select new DanhMuc(name, dm)).ToList());
        }
Example #19
0
        public ActionResult Update(int NV_id, int[] KhoaGiangDay, int[] NganhGiangDay)
        {
            var model = db.NhanViens.All.Find(NV_id).nvTTThongKes.Single();

            ModelState.Clear();
            TryUpdateModel(model);
            if (ModelState.IsValid)
            {
                using (var scope = new TransactionScope())
                {
                    db.Entry(model).State = EntityState.Modified;
                    // khoa giang day
                    db.SaveChanges();
                    model.NhanVien.nvKhoaGiangDays.ToList().ForEach(kgd => db.nvKhoaGiangDay.Remove(kgd));
                    db.SaveChanges();
                    if (KhoaGiangDay != null)
                    {
                        KhoaGiangDay.ToList().ForEach(id => db.nvKhoaGiangDay.Add(new nvKhoaGiangDay {
                            NV_id = model.NV_id, KhoaGiangDay = id
                        }));
                    }
                    db.SaveChanges();
                    // nganh giang day
                    model.NhanVien.nvNganhGiangDays.ToList().ForEach(ngd => db.nvNganhGiangDay.Remove(ngd));
                    db.SaveChanges();
                    if (NganhGiangDay != null)
                    {
                        NganhGiangDay.ToList().ForEach(id => db.nvNganhGiangDay.Add(new nvNganhGiangDay {
                            NV_id = model.NV_id, NganhGiangDay = id
                        }));
                    }
                    db.SaveChanges();
                    scope.Complete();
                    TempData["Controller"] = "nvTTThongKe";
                    TempData["Message"]    = "CapNhatThanhCong";
                }
            }
            TempData["ModelState"] = ModelState;
            return(RedirectToAction("Details/" + NV_id, "HSNhanSu", new { tab = "QTCongTac" }));
        }
Example #20
0
        public override void Execute()
        {
            #line 5 "..\..\Views\nvTTThongKe\Import.cshtml"

            ViewBag.Title = "Import";
            var excel = new LinqToExcel.ExcelQueryFactory(ViewBag.File);



            #line default
            #line hidden
            WriteLiteral("<table>\r\n<tr>\r\n    <th>MaNV</th>\r\n    <th>KhoaGiangDayChinh</th>\r\n    <th>KhoaGia" +
                         "ngDay</th>\r\n    <th>NganhGiangDayChinh</th>\r\n    <th>NganhGiangDay</th>\r\n</tr>\r\n" +
                         "");



            #line 17 "..\..\Views\nvTTThongKe\Import.cshtml"
            using (var db = new HRMDBEntities())
            {
                foreach (var row in excel.Worksheet())
                {
                    var MaNV     = row["(MaNV)"].Value as string;
                    var NhanVien = db.NhanViens.All.SingleOrDefault(nv => nv.MaNV == MaNV);
                    if (NhanVien == null)
                    {
            #line default
            #line hidden
                        WriteLiteral("            <tr><td>");



            #line 25 "..\..\Views\nvTTThongKe\Import.cshtml"
                        Write(MaNV);


            #line default
            #line hidden
                        WriteLiteral(" not found!</td></tr>\r\n");



            #line 26 "..\..\Views\nvTTThongKe\Import.cshtml"
                        break;
                    }
                    var maLoai = row["(PhanLoaiCBGVNV)"].Value as string;
                    var Loai   = db.dmPhanLoaiCBGVNV.SingleOrDefault(l => l.maPhanLoaiCBGVNV == maLoai);
                    if (Loai == null && !String.IsNullOrEmpty(maLoai))
                    {
            #line default
            #line hidden
                        WriteLiteral("            <tr><td>");



            #line 32 "..\..\Views\nvTTThongKe\Import.cshtml"
                        Write(maLoai);


            #line default
            #line hidden
                        WriteLiteral(" not found!</td></tr>\r\n");



            #line 33 "..\..\Views\nvTTThongKe\Import.cshtml"
                        break;
                    }
                    var maKhoa = row["(KhoaGiangDayChinh)"].Value as string;
                    var Khoa   = db.dmKhoaGiangDay.SingleOrDefault(k => k.maKhoaGiangDay == maKhoa);
                    if (Khoa == null && !String.IsNullOrEmpty(maKhoa))
                    {
            #line default
            #line hidden
                        WriteLiteral("            <tr><td>");



            #line 39 "..\..\Views\nvTTThongKe\Import.cshtml"
                        Write(maKhoa);


            #line default
            #line hidden
                        WriteLiteral(" not found!</td></tr>\r\n");



            #line 40 "..\..\Views\nvTTThongKe\Import.cshtml"
                        break;
                    }
                    var maKhoas = (row["(KhoaGiangDay)"].Value as string ?? "").Split(',').Where(m => !String.IsNullOrEmpty(m));
                    var Khoas   = (from m in maKhoas select db.dmKhoaGiangDay.SingleOrDefault(k => k.maKhoaGiangDay == m));
                    if (Khoas.Contains(null) && !String.IsNullOrEmpty(String.Join("", maKhoas)))
                    {
            #line default
            #line hidden
                        WriteLiteral("            <tr><td>");



            #line 46 "..\..\Views\nvTTThongKe\Import.cshtml"
                        Write(maKhoas);


            #line default
            #line hidden
                        WriteLiteral(" not found!</td></tr>\r\n");



            #line 47 "..\..\Views\nvTTThongKe\Import.cshtml"
                        break;
                    }
                    var maNganh = row["(NganhGiangDayChinh)"].Value as string;
                    var Nganh   = db.dmNganhGiangDay.SingleOrDefault(n => n.maNganhGiangDay == maNganh);
                    if (Nganh == null && !String.IsNullOrEmpty(maNganh))
                    {
            #line default
            #line hidden
                        WriteLiteral("            <tr><td>");



            #line 53 "..\..\Views\nvTTThongKe\Import.cshtml"
                        Write(maNganh);


            #line default
            #line hidden
                        WriteLiteral(" not found!</td></tr>\r\n");



            #line 54 "..\..\Views\nvTTThongKe\Import.cshtml"
                        break;
                    }
                    var maNganhs = (row["(NganhGiangDay)"].Value as string ?? "").Split(',').Where(m => !String.IsNullOrEmpty(m));
                    var Nganhs   = (from m in maNganhs select db.dmNganhGiangDay.SingleOrDefault(n => n.maNganhGiangDay == m));
                    if (Nganhs.Contains(null) && !String.IsNullOrEmpty(String.Join("", maNganhs)))
                    {
            #line default
            #line hidden
                        WriteLiteral("            <tr><td>");



            #line 60 "..\..\Views\nvTTThongKe\Import.cshtml"
                        Write(maNganhs);


            #line default
            #line hidden
                        WriteLiteral(" not found!</td></tr>\r\n");



            #line 61 "..\..\Views\nvTTThongKe\Import.cshtml"
                        break;
                    }
                    var nvTTThongKe = NhanVien.nvTTThongKes.SingleOrDefault();
                    if (nvTTThongKe == null)
                    {
                        using (var controller = new nvTTThongKeController())
                        {
                            controller.Create(NhanVien.id);
                        }
                    }
                    nvTTThongKe.dmPhanLoaiCBGVNV = Loai;
                    nvTTThongKe.dmKhoaGiangDay   = Khoa;
                    NhanVien.nvKhoaGiangDays.ToList().ForEach(k => db.Entry(k).State = EntityState.Deleted);
                    Khoas.ToList().ForEach(k => db.nvKhoaGiangDay.Add(new nvKhoaGiangDay {
                        NV_id = NhanVien.id, KhoaGiangDay = k.id
                    }));
                    nvTTThongKe.dmNganhGiangDay = Nganh;
                    NhanVien.nvNganhGiangDays.ToList().ForEach(n => db.Entry(n).State = EntityState.Deleted);
                    Nganhs.ToList().ForEach(n => db.nvNganhGiangDay.Add(new nvNganhGiangDay {
                        NV_id = NhanVien.id, NganhGiangDay = n.id
                    }));
                    db.Entry(nvTTThongKe).State = EntityState.Modified;


            #line default
            #line hidden
                    WriteLiteral("    <tr>\r\n        <td>");



            #line 80 "..\..\Views\nvTTThongKe\Import.cshtml"
                    Write(row["(MaNV)"]);


            #line default
            #line hidden
                    WriteLiteral("</td>\r\n        <td>");



            #line 81 "..\..\Views\nvTTThongKe\Import.cshtml"
                    Write(row["(KhoaGiangDayChinh)"]);


            #line default
            #line hidden
                    WriteLiteral("</td>\r\n        <td>");



            #line 82 "..\..\Views\nvTTThongKe\Import.cshtml"
                    Write(row["(KhoaGiangDay)"]);


            #line default
            #line hidden
                    WriteLiteral("</td>\r\n        <td>");



            #line 83 "..\..\Views\nvTTThongKe\Import.cshtml"
                    Write(row["(NganhGiangDayChinh)"]);


            #line default
            #line hidden
                    WriteLiteral("</td>\r\n        <td>");



            #line 84 "..\..\Views\nvTTThongKe\Import.cshtml"
                    Write(row["(NganhGiangDay)"]);


            #line default
            #line hidden
                    WriteLiteral("</td>\r\n    </tr>\r\n");



            #line 86 "..\..\Views\nvTTThongKe\Import.cshtml"
                }
                db.SaveChanges();
            }


            #line default
            #line hidden
            WriteLiteral("</table>\r\n");
        }