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"));
}
public ActionResult sua_PB1(PHONGBAN pb)
{
var phongban = db.PHONGBANs.Find(pb.MA_PhongBan);
if (phongban == null)
{
return(HttpNotFound());
}
if (TryUpdateModel(phongban, "", new string[] { "MA_PhongBan", "Ten_PB" }))
{
try
{
phongban.Ten_PB = pb.Ten_PB;
db.Entry(phongban).State = EntityState.Modified;
db.SaveChanges();
}
catch (RetryLimitExceededException)
{
ModelState.AddModelError("", "loi");
}
}
var listPB = from s in db.PHONGBANs select s;
return(View("ListPB", listPB));
}
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"));
}
public ActionResult xoa_HT1(int?id)
{
HOTRO hotro = db.HOTROes.SingleOrDefault(s => s.MA_HT == id);
db.HOTROes.Remove(hotro);
db.SaveChanges();
return(RedirectToAction("ListHT"));
}
public ActionResult Change_Password1(string id, string password)
{
NHANVIEN nv = new NHANVIEN();
if (!ModelState.IsValid)
{
return(View(nv));
}
if (TryUpdateModel(nv, "", new string[] { "MA_NhanVien", "MatKhau" }))
{
try
{
NL2_QLVAEntities1 db = new NL2_QLVAEntities1();
var nhanVienCu = db.NHANVIENs.FirstOrDefault(nvc => nvc.MA_NhanVien == nv.MA_NhanVien);
nhanVienCu.MatKhau = nv.MatKhau;
db.SaveChanges();
}
catch (RetryLimitExceededException)
{
ModelState.AddModelError("", "Lỗi");
}
}
return(RedirectToAction("Index1", "TrangCaNhan"));
}
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 them_HT(HOTRO ht, FormCollection form)
{
if (!ModelState.IsValid)
{
return(View(ht));
}
db.HOTROes.Add(ht);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ChangeAvatar(HttpPostedFileBase file)
{
NHANVIEN nv = (NHANVIEN)Session["TaiKhoan"];
//string[] filename = file.FileName.Split('.');
string newPath = Path.Combine(Server.MapPath("~/Content/images" + file.FileName + ".png"));
file.SaveAs(newPath);
NHANVIEN nv1 = db.NHANVIENs.FirstOrDefault(avt => avt.MA_NhanVien == nv.MA_NhanVien);
nv1.Avatar = file.FileName + ".png";
db.SaveChanges();
Session["TaiKhoan"] = nv1;
return(RedirectToAction("Index1", "TrangCaNhan"));
}
public ActionResult them_VT(SUB_MENU sub, FormCollection form)
{
//if (db.SUB_MENU.Any(x => x.ID_SUB == sub.ID_SUB))
//{
// return View(sub);
//}
ViewBag.vt = new SelectList(db.QUYEN_NSD.OrderBy(x => x.MA_QNSD), "MA_QNSD", "Ten_QNSD");
ViewBag.main = new SelectList(db.MAIN_MENU.OrderBy(x => x.ID_Main), "ID_Main", "Ten_Main");
sub.MA_QNSD = form["vt"].ToString();
sub.ID_Main = int.Parse(form["main"].ToString());
sub.MA_Action = form["action"].ToString();
//if (!ModelState.IsValid)
// return View(sub);
db.SUB_MENU.Add(sub);
db.SaveChanges();
return(RedirectToAction("ListMenu"));
}
public void themChiTietDuongSu(CHITIET_DS ctds)
{
db.CHITIET_DS.Add(ctds);
db.SaveChanges();
}
public ActionResult themLXX(XETXU xx, FormCollection form, string troVe)
{
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);
if (troVe == "troVe")
{
return(RedirectToAction("ListHS", "HoSoVuAn"));
}
return(RedirectToAction("ListXX"));
}