public JsonResult GetSkillOfStaffListWithDept(string dept)
{
var user = SessionHelper.Get <Member>(Constant.SESSION_LOGIN);
if (user == null)
{
return(Json(new { body = "" }, JsonRequestBehavior.AllowGet));
}
using (var db = new UMC_SKILLEntities())
{
var listUser = new List <Member>();
if (string.IsNullOrEmpty(dept) || dept == Constant.DEPT_ALL)
{
listUser = db.Members.Where(m => m.Removed == 0).Take(10).ToList();
}
else
{
listUser = db.Members.Where(m => m.Dept == dept && m.Removed == 0).Take(200).ToList();
}
return(GetSkills(listUser));
}
}
public JsonResult ThemKiNangChoNV(string userID, string CapDo, string NgayCap, string NgayThiXacNhan, string SkillID)
{
try
{
var user = SessionHelper.Get <Member>(Constant.SESSION_LOGIN);
if (user != null)
{
using (var db = new UMC_SKILLEntities())
{
var cer = new Certification();
cer.UserID = int.Parse(userID);
cer.SkillID = int.Parse(SkillID);
var cerInDb = db.Certifications.Where(m => m.UserID == cer.UserID && m.SkillID == cer.SkillID).FirstOrDefault();
if (cerInDb != null)
{
return(Json(new { body = "Đã thêm kĩ năng này cho " + cerInDb.Member.Name + " rồi!", }, JsonRequestBehavior.AllowGet));
}
cer.CapDo = CapDo;
cer.NgayCap = DateTime.Parse(NgayCap);
cer.NgayThiXacNhan = DateTime.Parse(NgayThiXacNhan);
cer.SoLanThi = 1;
cer.Mark = "100";
cer.Result = "PASS";
cer.Updator = user.ID;
cer.UpdateTime = DateTime.Now;
cer.Code = db.Members.Where(m => m.ID == cer.UserID).FirstOrDefault().Code;
cer.TypeSkill = "Skill";
db.Certifications.Add(cer);
db.SaveChanges();
}
return(Json(new { body = "OK" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
}
return(Json(new { body = "NG" }, JsonRequestBehavior.AllowGet));
}
private ResultInfo AddNewSkill(Skill skill, string levels)
{
try
{
var user = SessionHelper.Get <Member>(Constant.SESSION_LOGIN);
skill.Creator = user.ID;
skill.CreateTime = DateTime.Now;
skill.Updator = user.ID;
skill.UpdateTime = DateTime.Now;
using (var db = new UMC_SKILLEntities())
{
db.Skills.Add(skill);
db.SaveChanges();
var levelsArr = levels.Split(',');
foreach (var level in levelsArr)
{
var skillLevel = new SkillLevel();
skillLevel.Name = level;
skillLevel.SkillID = skill.ID;
db.SkillLevels.Add(skillLevel);
db.SaveChanges();
}
return(new ResultInfo()
{
code = RESULT.SUCCESS
});
}
}
catch (Exception)
{
return(new ResultInfo()
{
code = RESULT.ERROR, message = "Có lỗi xảy ra khi thêm vào DB"
});
}
}
public ActionResult ViewSkillForStaff(int ID = 0)
{
var user = SessionHelper.Get <Member>(Constant.SESSION_LOGIN);
if (user != null)
{
if (ID != 0)
{
using (var db = new UMC_SKILLEntities())
{
var u = db.Members.Where(m => m.ID == ID).FirstOrDefault();
var skills = db.Certifications.Include("Skill")
.Where(m => m.UserID == u.ID && m.Skill.Removed == 0)
.ToList();
var cerByUser = new CertificateByUser()
{
userID = u.ID,
Code = u.Code,
FullName = u.Name,
Dept = u.Dept,
DateEnter = u.DateEnter.ToShortDateString(),
ListSkills = skills,
Customer = u.Customer
};
if (cerByUser != null)
{
return(View(cerByUser));
}
}
}
return(RedirectToAction("Index", "Home"));
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public JsonResult SuaMonHoc(string MaMonHoc, string TenMonHoc, string loaihinh, string dept)
{
try
{
using (var db = new UMC_SKILLEntities())
{
var user = SessionHelper.Get <Member>(Constant.SESSION_LOGIN);
var monhoc = db.MONHOCs.Where(m => m.MaBoMon == MaMonHoc).FirstOrDefault();
monhoc.TenBoMon = TenMonHoc;
monhoc.LoaiMonHoc = loaihinh;
monhoc.Dept = dept;
monhoc.ModifyBy = user.ID;
monhoc.ModifyDate = DateTime.Now;
db.SaveChanges();
var listMonHoc = db.MONHOCs.Where(m => m.Removed == 0).OrderByDescending(m => m.ModifyDate).ToList();
var message = Utils.ConvertViewToString("~/Views/MonHoc/_ListMonHoc.cshtml", listMonHoc, ViewData, ControllerContext);
return(Json(new { code = RESULT.SUCCESS, message = message }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
return(Json(new { code = RESULT.ERROR, message = "Có lỗi xảy ra khi thêm vào DB" }));
}
}
public void Execute(IJobExecutionContext context)
{
try
{
using (var db = new UMC_SKILLEntities())
{
GA_UMCEntities gaDB = new GA_UMCEntities();
object[] param =
{
new SqlParameter()
{
ParameterName = "@deptCode", Value = DBNull.Value, SqlDbType = SqlDbType.NVarChar
},
new SqlParameter("@Out_Parameter", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
var reports = gaDB.sp_Get_All_Staff_2().ToList();
var list = db.Members.ToList();
foreach (var mem in list)
{
//Nếu không có trên ds Ga
if (reports.Where(m => m.StaffCode == mem.Code).FirstOrDefault() == null && mem.Removed == 0)
{
var memInDb = db.Members.Where(m => m.Code == mem.Code).FirstOrDefault();
memInDb.Removed = 1;
db.SaveChanges();
}
}
foreach (var employee in reports)
{
// Nếu không có trên ds member thì thêm vào
var eInSkillMap = db.Members.Where(m => m.Code == employee.StaffCode).FirstOrDefault();
if (eInSkillMap == null)
{
var mem = new Member()
{
Code = employee.StaffCode,
Name = employee.FullName,
Dept = employee.DeptCode,
RoleID = 1,
Removed = 0,
Pass = "******",
Pos = employee.PosName,
Customer = employee.Customer
};
if (employee.EntryDate is DateTime date)
{
mem.DateEnter = date;
}
db.Members.Add(mem);
db.SaveChanges();
}
else
{
bool isChanged = false;
if (eInSkillMap.Dept != employee.DeptCode)
{
eInSkillMap.Dept = employee.DeptCode;
isChanged = true;
}
if (eInSkillMap.Pos != employee.PosName)
{
eInSkillMap.Pos = employee.PosName;
isChanged = true;
}
if (eInSkillMap.Customer != employee.Customer)
{
eInSkillMap.Customer = employee.Customer;
isChanged = true;
}
if (isChanged)
{
db.SaveChanges();
}
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
public ActionResult SuaChungChiChoNV(Certification cer)
{
if (SessionHelper.IsLogIn())
{
try
{
using (var db = new UMC_SKILLEntities())
{
var user = SessionHelper.Get <Member>(Constant.SESSION_LOGIN);
var member = db.Members.Where(m => m.Code == cer.Code).FirstOrDefault();
if (member == null)
{
ModelState.AddModelError("Error", "Không tồn tại user " + cer.Code);
ViewBag.Skills = db.Skills.Where(m => m.Removed == 0).ToList();
ViewBag.SkillLevels = db.SkillLevels.Where(m => m.SkillID == cer.SkillID).ToList();
return(View(cer));
}
else
{
cer.UserID = member.ID;
if (cer.ID == 0)
{
var cerInDb = db.Certifications.Where(m => m.Code == cer.Code && m.SkillID == cer.SkillID).FirstOrDefault();
if (cerInDb != null)
{
ModelState.AddModelError("Error", "Nhân viên " + cer.Code + " Đã học môn này rồi!");
ViewBag.Skills = db.Skills.Where(m => m.Removed == 0).ToList();
ViewBag.SkillLevels = db.SkillLevels.Where(m => m.SkillID == cer.SkillID).ToList();
return(View(cer));
}
else
{
ModelState.AddModelError("Error", "Không tồn tại chứng chỉ này!");
ViewBag.SkillLevels = db.SkillLevels.Where(m => m.SkillID == cer.SkillID).ToList();
return(View(cer));
}
}
else
{
var cerInDb = db.Certifications.Where(m => m.ID == cer.ID).FirstOrDefault();
if (cerInDb != null)
{
cerInDb.Updator = user.ID;
cerInDb.UpdateTime = DateTime.Now;
cerInDb.NguoiChamDiem = user.ID;
cerInDb.Mark = cer.Mark;
cerInDb.Note = cer.Note;
cerInDb.Result = cer.Result;
cerInDb.NgayThiXacNhan = cer.NgayThiXacNhan;
cerInDb.NgayThiThucTe = cer.NgayThiThucTe;
cerInDb.TypeSkill = cer.TypeSkill;
cerInDb.SkillID = cer.SkillID;
if (cer.CapDo != null)
{
if (cer.NgayCap == null)
{
ModelState.AddModelError("Error", "Bạn cần chọn Ngày Cấp!");
ViewBag.SkillLevels = db.SkillLevels.Where(m => m.SkillID == cer.SkillID).ToList();
return(View(cer));
}
cerInDb.CapDo = cer.CapDo;
cerInDb.NgayCap = cer.NgayCap;
}
if (cer.NangCap != null)
{
if (cer.NgayNangCap == null)
{
ModelState.AddModelError("Error", "Bạn cần chọn Ngày Nâng Cấp!");
ViewBag.SkillLevels = db.SkillLevels.Where(m => m.SkillID == cer.SkillID).ToList();
return(View(cer));
}
cerInDb.NangCap = cer.NangCap;
cerInDb.NgayNangCap = cer.NgayNangCap;
}
if (cer.CNNguoiDaoTao != null)
{
if (cer.NgayCNNguoiDaoTao == null)
{
ModelState.AddModelError("Error", "Bạn cần chọn Ngày CN Người Đào tạo!");
ViewBag.SkillLevels = db.SkillLevels.Where(m => m.SkillID == cer.SkillID).ToList();
return(View(cer));
}
cerInDb.CNNguoiDaoTao = cer.CNNguoiDaoTao;
cerInDb.NgayCNNguoiDaoTao = cer.NgayCNNguoiDaoTao;
}
db.SaveChanges();
}
else
{
ModelState.AddModelError("Error", "Không tồn tại chứng chỉ này cho nhân viên!");
ViewBag.Skills = db.Skills.Where(m => m.Removed == 0).ToList();
ViewBag.SkillLevels = db.SkillLevels.Where(m => m.SkillID == cer.SkillID).ToList();
return(View(cer));
}
}
return(RedirectToAction("ViewSkillForStaff", new { ID = cer.UserID }));
}
}
}
catch (Exception e)
{
ModelState.AddModelError("Error", "Có lỗi xảy ra!");
return(View(cer));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public JsonResult UpdateNewStaff()
{
try
{
var user = SessionHelper.Get <Member>(Constant.SESSION_LOGIN);
if (user == null)
{
return(Json(new { body = "" }, JsonRequestBehavior.AllowGet));
}
using (var db = new UMC_SKILLEntities())
{
GA_UMCEntities context = new GA_UMCEntities();
object[] param =
{
new SqlParameter()
{
ParameterName = "@deptCode", Value = DBNull.Value, SqlDbType = SqlDbType.NVarChar
},
new SqlParameter("@Out_Parameter", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
var reports = context.Database.SqlQuery <Employees>("EXEC [dbo].[sp_Get_All_Staff] @deptCode", param).ToList();
var list = db.Members.ToList();
foreach (var mem in list)
{
if (reports.Where(m => m.StaffCode == mem.Code).FirstOrDefault() == null)
{
var memInDb = db.Members.Where(m => m.Code == mem.Code).FirstOrDefault();
memInDb.Removed = 1;
db.SaveChanges();
}
}
foreach (var employee in reports)
{
var eInSkillMap = db.Members.Where(m => m.Code == employee.StaffCode).FirstOrDefault();
if (eInSkillMap == null)
{
var mem = new Member()
{
Code = employee.StaffCode,
Name = employee.FullName,
Dept = employee.DeptCode,
RoleID = 1,
Removed = 0,
Pass = "******",
Pos = employee.PosName
};
if (employee.EntryDate is DateTime date)
{
mem.DateEnter = date;
}
db.Members.Add(mem);
db.SaveChanges();
}
else
{
bool isChanged = false;
if (eInSkillMap.Dept != employee.DeptCode)
{
eInSkillMap.Dept = employee.DeptCode;
isChanged = true;
}
if (eInSkillMap.Pos != employee.PosName)
{
eInSkillMap.Pos = employee.PosName;
isChanged = true;
}
if (isChanged)
{
db.SaveChanges();
}
}
}
return(Json(new { body = "OK" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json(new { body = "NG" }, JsonRequestBehavior.AllowGet));
}
}
private void UpdateData()
{
var gaDB = new GA_UMCEntities();
var db = new UMC_SKILLEntities();
var listCheckEyes = gaDB.sp_Get_All_CheckEye(null, null).ToList();
foreach (var checkEye in listCheckEyes)
{
var staff = db.Members.Where(m => m.Code == checkEye.StaffCode).FirstOrDefault();
if (staff != null)
{
var cerInDb = db.Certifications.Where(m => m.UserID == staff.ID && m.SkillID == 17).FirstOrDefault();
if (cerInDb == null)
{
cerInDb = new Certification();
cerInDb.UserID = staff.ID;
cerInDb.Code = staff.Code;
cerInDb.Updator = 2309;
cerInDb.UpdateTime = DateTime.Now;
cerInDb.NguoiChamDiem = 2309;
cerInDb.Mark = "100";
cerInDb.Note = "";
cerInDb.Result = "PASS";
cerInDb.NgayThiXacNhan = checkEye.NgayThi;
cerInDb.NgayThiThucTe = checkEye.NgayThiThucTe;
cerInDb.TypeSkill = "Skill";
cerInDb.SkillID = 17;
cerInDb.CapDo = checkEye.CapDo;
cerInDb.NgayCap = checkEye.NgayCap;
cerInDb.NangCap = checkEye.NangCap;
cerInDb.NgayNangCap = checkEye.NgayNangCap;
cerInDb.CNNguoiDaoTao = checkEye.CNNguoiDaoTao;
cerInDb.NgayCNNguoiDaoTao = checkEye.NgayCNNguoiDaoTao;
db.Certifications.Add(cerInDb);
}
else
{
cerInDb.Updator = 2309;
cerInDb.UpdateTime = DateTime.Now;
cerInDb.NgayThiXacNhan = checkEye.NgayThi;
cerInDb.NgayThiThucTe = checkEye.NgayThiThucTe;
cerInDb.CapDo = checkEye.CapDo;
cerInDb.NgayCap = checkEye.NgayCap;
cerInDb.NangCap = checkEye.NangCap;
cerInDb.NgayNangCap = checkEye.NgayNangCap;
cerInDb.CNNguoiDaoTao = checkEye.CNNguoiDaoTao;
cerInDb.NgayCNNguoiDaoTao = checkEye.NgayCNNguoiDaoTao;
}
db.SaveChanges();
}
}
var listHan = gaDB.sp_Get_All_Check_Solders(null).ToList();
foreach (var han in listHan)
{
var staff = db.Members.Where(m => m.Code == han.StaffCode).FirstOrDefault();
if (staff != null)
{
var cerInDb = db.Certifications.Where(m => m.UserID == staff.ID && m.SkillID == 16).FirstOrDefault();
if (cerInDb == null)
{
cerInDb = new Certification();
cerInDb.UserID = staff.ID;
cerInDb.Code = staff.Code;
cerInDb.Updator = 2309;
cerInDb.UpdateTime = DateTime.Now;
cerInDb.NguoiChamDiem = 2309;
cerInDb.Mark = "100";
cerInDb.Note = "";
cerInDb.Result = "PASS";
cerInDb.NgayThiXacNhan = han.NgayThiXacNhan;
cerInDb.NgayThiThucTe = han.NgayThiThucTe;
cerInDb.TypeSkill = "Skill";
cerInDb.SkillID = 16;
cerInDb.CapDo = han.CapDoHan;
cerInDb.NgayCap = han.NgayCap;
cerInDb.NangCap = han.NangCapDo;
cerInDb.NgayNangCap = han.NgayNangCap;
cerInDb.CNNguoiDaoTao = han.CNNguoiDaoTao;
cerInDb.NgayCNNguoiDaoTao = han.NgayCNNguoiDaoTao;
db.Certifications.Add(cerInDb);
}
else
{
cerInDb.Updator = 2309;
cerInDb.UpdateTime = DateTime.Now;
cerInDb.NgayThiXacNhan = han.NgayThiXacNhan;
cerInDb.NgayThiThucTe = han.NgayThiThucTe;
cerInDb.CapDo = han.CapDoHan;
cerInDb.NgayCap = han.NgayCap;
cerInDb.NangCap = han.NangCapDo;
cerInDb.NgayNangCap = han.NgayNangCap;
cerInDb.CNNguoiDaoTao = han.CNNguoiDaoTao;
cerInDb.NgayCNNguoiDaoTao = han.NgayCNNguoiDaoTao;
}
db.SaveChanges();
}
}
}
