public ActionResult Sua(CANBO cb)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
CANBO canbo = db.CANBOes.SingleOrDefault(n => n.IdCB == cb.IdCB);
if (canbo != null)
{
canbo.HoTen = cb.HoTen;
canbo.ChucVu = cb.ChucVu;
canbo.BangCap = cb.BangCap;
canbo.QueQuan = cb.QueQuan;
canbo.Email = cb.Email;
if (cb.NgaySinh == null)
{
canbo.NgaySinh = canbo.NgaySinh;
}
else
{
canbo.NgaySinh = cb.NgaySinh;
}
canbo.NgayCapNhat = DateTime.Parse(DateTime.Now.ToString());
canbo.SoDT = cb.SoDT;
canbo.AnhMoTa = cb.AnhMoTa;
canbo.ChiTiet = cb.ChiTiet;
canbo.IdTaiKhoan = cb.IdTaiKhoan;
canbo.IdPhongBan = cb.IdPhongBan;
ViewBag.IdPhongBan = new SelectList(db.PHONGBANs.ToList(), "IdPB", "TenPhong", canbo.IdPhongBan);
ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen");
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
public ActionResult DeleteConfirmed(string id)
{
CANBO cANBO = db.CANBOes.Find(id);
db.CANBOes.Remove(cANBO);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: CANBOes/Create
public ActionResult Create()
{
ViewBag.COQUAN_CQ_MA = new SelectList(db.COQUANs, "CQ_MA", "CQ_TEN");
ViewBag.KHENTHUONGCB_KTCB_MA = new SelectList(db.KHENTHUONGCBs, "KTCB_MA", "KTCB_THANHTICH");
ViewBag.KYLUATCB_KLCB_MA = new SelectList(db.KYLUATCBs, "KLCB_MA", "KLCB_HT");
CANBO obj = new CANBO();
obj.CB_MA = CreateID.CreateID_ByteText();
return(View(obj));
}
// POST: Admin/CanBoNhanVien/Xoa
public ActionResult Xoa(int id)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
CANBO canbo = db.CANBOes.SingleOrDefault(n => n.IdCB == id);
db.CANBOes.Remove(canbo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Them(CANBO cb)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
cb.NgayCapNhat = DateTime.Parse(DateTime.Now.ToString());
ViewBag.IdPhongBan = new SelectList(db.PHONGBANs.ToList(), "IdPb", "TenPhongBan");
ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen");
db.CANBOes.Add(cb);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Edit([Bind(Include = "CB_MA,CB_HOTEN,CB_GIOITINH,CB_DIACHI,CB_NGAYSINH,CB_CMND,COQUAN_CQ_MA,KYLUATCB_KLCB_MA,KHENTHUONGCB_KTCB_MA")] CANBO cANBO)
{
if (ModelState.IsValid)
{
db.Entry(cANBO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.COQUAN_CQ_MA = new SelectList(db.COQUANs, "CQ_MA", "CQ_TEN", cANBO.COQUAN_CQ_MA);
ViewBag.KHENTHUONGCB_KTCB_MA = new SelectList(db.KHENTHUONGCBs, "KTCB_MA", "KTCB_NGAY", cANBO.KHENTHUONGCB_KTCB_MA);
ViewBag.KYLUATCB_KLCB_MA = new SelectList(db.KYLUATCBs, "KLCB_MA", "KLCB_NGAY", cANBO.KYLUATCB_KLCB_MA);
return(View(cANBO));
}
// GET: CANBOes/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CANBO cANBO = db.CANBOes.Find(id);
if (cANBO == null)
{
return(HttpNotFound());
}
return(View(cANBO));
}
// GET: CANBOes/Create
public ActionResult Create()
{
ViewBag.CHITIET_CHUCVU_CT_CV_ID = new SelectList(db.CHITIET_CHUCVU, "CT_CV_ID", "CT_CV_TEN");
ViewBag.COQUAN_CQ_MA = new SelectList(db.COQUANs, "CQ_MA", "CQ_TEN");
ViewBag.KHENTHUONGCB_KTCB_MA = new SelectList(db.KHENTHUONGCBs, "KTCB_MA", "KTCB_THANHTICH");
ViewBag.KYLUATCB_KLCB_MA = new SelectList(db.KYLUATCBs, "KLCB_MA", "KLCB_HT");
ViewBag.THONGTINDAOTAO_TTDT_MA = new SelectList(db.THONGTINDAOTAOs, "TTDT_MA", "HINHTHUCs_HT_MA");
ViewBag.THONGTINLUONG_TTL_MA = new SelectList(db.THONGTINLUONGs, "TTL_MA", "TTL_NGAYNHANLUONG");
CANBO obj = new CANBO();
obj.CB_MA = CreateID.CreateID_ByteText();
return(View(obj));
}
//GET: Admin/CanBoNhanVien/ChiTiet
public ActionResult ChiTiet(int id = 0)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
CANBO cb = db.CANBOes.SingleOrDefault(n => n.IdCB == id);
ViewBag.IdPhongBan = new SelectList(db.PHONGBANs.ToList(), "IdPB", "TenPhong");
ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen");
if (cb == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(cb));
}
}
public ActionResult Edit([Bind(Include = "CB_MA,CB_HOTEN,CB_GIOITINH,CB_DIACHI,CB_NGAYSINH,CB_CMND,COQUAN_CQ_MA,CHITIET_CHUCVU_CT_CV_ID,KYLUATCB_KLCB_MA,KHENTHUONGCB_KTCB_MA,THONGTINDAOTAO_TTDT_MA,THONGTINLUONG_TTL_MA")] CANBO cANBO)
{
if (ModelState.IsValid)
{
db.Entry(cANBO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CHITIET_CHUCVU_CT_CV_ID = new SelectList(db.CHITIET_CHUCVU, "CT_CV_ID", "CT_CV_TEN", cANBO.CHITIET_CHUCVU_CT_CV_ID);
ViewBag.COQUAN_CQ_MA = new SelectList(db.COQUANs, "CQ_MA", "CQ_TEN", cANBO.COQUAN_CQ_MA);
ViewBag.KHENTHUONGCB_KTCB_MA = new SelectList(db.KHENTHUONGCBs, "KTCB_MA", "KTCB_NGAY", cANBO.KHENTHUONGCB_KTCB_MA);
ViewBag.KYLUATCB_KLCB_MA = new SelectList(db.KYLUATCBs, "KLCB_MA", "KLCB_NGAY", cANBO.KYLUATCB_KLCB_MA);
ViewBag.THONGTINDAOTAO_TTDT_MA = new SelectList(db.THONGTINDAOTAOs, "TTDT_MA", "HINHTHUCs_HT_MA", cANBO.THONGTINDAOTAO_TTDT_MA);
ViewBag.THONGTINLUONG_TTL_MA = new SelectList(db.THONGTINLUONGs, "TTL_MA", "TTL_NGAYNHANLUONG", cANBO.THONGTINLUONG_TTL_MA);
return(View(cANBO));
}
// GET: CANBOes/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CANBO cANBO = db.CANBOes.Find(id);
if (cANBO == null)
{
return(HttpNotFound());
}
ViewBag.COQUAN_CQ_MA = new SelectList(db.COQUANs, "CQ_MA", "CQ_TEN", cANBO.COQUAN_CQ_MA);
ViewBag.KHENTHUONGCB_KTCB_MA = new SelectList(db.KHENTHUONGCBs, "KTCB_MA", "KTCB_NGAY", cANBO.KHENTHUONGCB_KTCB_MA);
ViewBag.KYLUATCB_KLCB_MA = new SelectList(db.KYLUATCBs, "KLCB_MA", "KLCB_NGAY", cANBO.KYLUATCB_KLCB_MA);
return(View(cANBO));
}
// GET: CANBOes/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CANBO cANBO = db.CANBOes.Find(id);
if (cANBO == null)
{
return(HttpNotFound());
}
ViewBag.CHITIET_CHUCVU_CT_CV_ID = new SelectList(db.CHITIET_CHUCVU, "CT_CV_ID", "CT_CV_TEN", cANBO.CHITIET_CHUCVU_CT_CV_ID);
ViewBag.COQUAN_CQ_MA = new SelectList(db.COQUANs, "CQ_MA", "CQ_TEN", cANBO.COQUAN_CQ_MA);
ViewBag.KHENTHUONGCB_KTCB_MA = new SelectList(db.KHENTHUONGCBs, "KTCB_MA", "KTCB_NGAY", cANBO.KHENTHUONGCB_KTCB_MA);
ViewBag.KYLUATCB_KLCB_MA = new SelectList(db.KYLUATCBs, "KLCB_MA", "KLCB_NGAY", cANBO.KYLUATCB_KLCB_MA);
ViewBag.THONGTINDAOTAO_TTDT_MA = new SelectList(db.THONGTINDAOTAOs, "TTDT_MA", "HINHTHUCs_HT_MA", cANBO.THONGTINDAOTAO_TTDT_MA);
ViewBag.THONGTINLUONG_TTL_MA = new SelectList(db.THONGTINLUONGs, "TTL_MA", "TTL_NGAYNHANLUONG", cANBO.THONGTINLUONG_TTL_MA);
return(View(cANBO));
}
public ActionResult Create([Bind(Include = "CB_MA,CB_HOTEN,CB_GIOITINH,CB_DIACHI,CB_NGAYSINH,CB_CMND,COQUAN_CQ_MA,CHITIET_CHUCVU_CT_CV_ID,KYLUATCB_KLCB_MA,KHENTHUONGCB_KTCB_MA,THONGTINDAOTAO_TTDT_MA,THONGTINLUONG_TTL_MA")] CANBO cANBO)
{
string duongdan = "Index/" + cANBO.THONGTINLUONG_TTL_MA;
string duongdan1 = "Index/" + cANBO.THONGTINLUONG_TTL_MA;
if (ModelState.IsValid)
{
db.CANBOes.Add(cANBO);
db.SaveChanges();
return(RedirectToAction(duongdan, duongdan1));
}
ViewBag.CHITIET_CHUCVU_CT_CV_ID = new SelectList(db.CHITIET_CHUCVU, "CT_CV_ID", "CT_CV_TEN", cANBO.CHITIET_CHUCVU_CT_CV_ID);
ViewBag.COQUAN_CQ_MA = new SelectList(db.COQUANs, "CQ_MA", "CQ_TEN", cANBO.COQUAN_CQ_MA);
ViewBag.KHENTHUONGCB_KTCB_MA = new SelectList(db.KHENTHUONGCBs, "KTCB_MA", "KTCB_NGAY", cANBO.KHENTHUONGCB_KTCB_MA);
ViewBag.KYLUATCB_KLCB_MA = new SelectList(db.KYLUATCBs, "KLCB_MA", "KLCB_NGAY", cANBO.KYLUATCB_KLCB_MA);
ViewBag.THONGTINDAOTAO_TTDT_MA = new SelectList(db.THONGTINDAOTAOs, "TTDT_MA", "HINHTHUCs_HT_MA", cANBO.THONGTINDAOTAO_TTDT_MA);
ViewBag.THONGTINLUONG_TTL_MA = new SelectList(db.THONGTINLUONGs, "TTL_MA", "TTL_NGAYNHANLUONG", cANBO.THONGTINLUONG_TTL_MA);
return(RedirectToAction(duongdan));
}
