public ActionResult XacNhanThemMoi(string data)
{
dynamic dataJson = JObject.Parse(data);
var maNV = dataJson.mnv;
var maCC = dataJson.mcc;
var ngayCap = DateTime.ParseExact(Convert.ToString(dataJson.ngaycap), "dd/MM/yyyy", CultureInfo.InvariantCulture)
.ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);
var ngayTra = DateTime.ParseExact(Convert.ToString(dataJson.ngaytra), "dd/MM/yyyy", CultureInfo.InvariantCulture)
.ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);
var sohieu = dataJson.sohieu + "";
using (QUANGHANHABCEntities db = new QUANGHANHABCEntities())
{
try
{
ChungChi_NhanVien ccnv = new ChungChi_NhanVien {
MaNV = maNV, MaChungChi = maCC, NgayCap = Convert.ToDateTime(ngayCap), NgayTra = Convert.ToDateTime(ngayTra), SoHieu = sohieu
};
if (ccnv.SoHieu != null && !ccnv.SoHieu.Equals(""))
{
db.ChungChi_NhanVien.Add(ccnv);
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult EditCertificateEmp(string id)
{
using (QUANGHANHABCEntities db = new QUANGHANHABCEntities())
{
List <ChungChi> listdata_chungchi = db.ChungChis.ToList <ChungChi>();
List <NhanVien> listdata_nv = db.NhanViens.ToList <NhanVien>();
SelectList listCirtificate = new SelectList(listdata_chungchi, "MaChungChi", "TenChungChi");
SelectList listEmployee = new SelectList(listdata_nv, "MaNV", "MaNV");
ViewBag.List_chungchi = listCirtificate;
ViewBag.List_nhanvien = listEmployee;
var cirtificate_emp = db.ChungChi_NhanVien.Where(x => x.SoHieu == id).FirstOrDefault <ChungChi_NhanVien>();
if (cirtificate_emp != null)
{
var emp = db.NhanViens.Where(x => x.MaNV == cirtificate_emp.MaNV).FirstOrDefault <NhanVien>();
if (emp != null)
{
ViewBag.nameEmp = emp.Ten;
ViewBag.first_cir = cirtificate_emp.MaChungChi;
}
}
ChungChi_NhanVien chungchinv = db.ChungChi_NhanVien.Where(x => x.SoHieu == id).FirstOrDefault <ChungChi_NhanVien>();
return(View(chungchinv));
}
}
public ActionResult DeleteCertificateEmp(string id)
{
using (QUANGHANHABCEntities db = new QUANGHANHABCEntities())
{
ChungChi_NhanVien chungchi_nv = db.ChungChi_NhanVien.Where(x => x.SoHieu == id).FirstOrDefault <ChungChi_NhanVien>();
db.ChungChi_NhanVien.Remove(chungchi_nv);
db.SaveChanges();
return(Json(new { success = true, message = "Delete successful" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditCertificateEmp(ChungChi_NhanVien chungchinv)
{
using (QUANGHANHABCEntities db = new QUANGHANHABCEntities())
{
if (chungchinv != null)
{
db.Entry(chungchinv).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("List"));
}
}
public ActionResult AddCertificateEmployee(ChungChi_NhanVien chungChi_nhanVien)
{
using (QUANGHANHABCEntities db = new QUANGHANHABCEntities())
{
if (chungChi_nhanVien != null)
{
db.ChungChi_NhanVien.Add(chungChi_nhanVien);
db.SaveChanges();
}
return(RedirectToAction("List"));
}
}
public ActionResult updateGiayTo(String json)
{
dynamic js = JObject.Parse(json);
String manv = js.manv;
String sohieu = js.sohieu;
String kieu = js.kieu;
String ngaytra = js.ngaytra;
using (QUANGHANHABCEntities db = new QUANGHANHABCEntities())
{
// GiayChungNhan_NhanVien x = (from a in db.GiayChungNhan_NhanVien where a.MaNV == manv & a.SoHieu==sohieu select a).SingleOrDefault() ;
ChungChi_NhanVien x = (from a in db.ChungChi_NhanVien where a.MaNV == manv & a.SoHieu == sohieu select a).SingleOrDefault();
ChiTiet_BangCap_GiayChungNhan y = (from a in db.ChiTiet_BangCap_GiayChungNhan where a.MaNV == manv & a.SoHieu == sohieu select a).SingleOrDefault();
if (x != null)
{
if (isValidateDateTime(ngaytra))
{
x.NgayTra = Convert.ToDateTime(ngaytra);
}
}
if (y != null)
{
if (isValidateDateTime(ngaytra))
{
y.NgayTra = Convert.ToDateTime(ngaytra);
}
}
//if (z != null)
//{
// if (isValidateDateTime(ngaytra))
// z.NgayTra = Convert.ToDateTime(ngaytra);
//}
db.SaveChanges();
return(Json(new { success = true, draw = Request["draw"] }, JsonRequestBehavior.AllowGet));;
}
}
