// GET: MonHoc
public ActionResult Index()
{
try
{
using (var db = new UMC_SKILLEntities())
{
var list = db.MONHOCs.Where(m => m.Removed == 0).ToList();
using (var dbGA = new GA_UMCEntities())
{
ViewBag.Depts = dbGA.MS_Department.ToList();
}
if (list != null)
{
return(View(list));
}
else
{
return(View(new List <MONHOC>()));
}
}
}
catch (Exception e)
{
Console.Write(e.ToString());
return(View(new List <MONHOC>()));
}
}
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));
}
}
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());
}
}
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();
}
}
}
