public JsonResult GetEmployeeNumber(string firstname, string surname) { oeg_lookupsEntities db2 = new oeg_lookupsEntities(); var retset = db2.getEmployeeIDByName(firstname, surname).ToList(); string ret = retset.Count() > 0 ? retset.FirstOrDefault().EntityID.ToString() : "No Match Found!"; return(Json(ret, JsonRequestBehavior.AllowGet)); }
static void runCleanup() { try { oeg_reportsEntities db = new oeg_reportsEntities(); oeg_lookupsEntities db2 = new oeg_lookupsEntities(); System.Diagnostics.Debug.WriteLine("Starting Remove unmatched"); db.Database.ExecuteSqlCommand("UpdatePreGroupID"); System.Diagnostics.Debug.WriteLine("Finished Remove unmatched"); System.Diagnostics.Debug.WriteLine("Starting Remove unmatched"); db.Database.ExecuteSqlCommand("RemoveIncompletes"); System.Diagnostics.Debug.WriteLine("Finished Remove unmatched"); System.Diagnostics.Debug.WriteLine("Starting EmployeeNumber Update"); db.Database.ExecuteSqlCommand("UpdateEmployeeNumber"); System.Diagnostics.Debug.WriteLine("Finished EmployeeNumber Update"); ////update lookup table from Gaia db.Database.ExecuteSqlCommand("CleanoutLookups"); var source = from f in db.ReportDatas select f; var employees = (from f in source where f.EmployeeName != null select new { EmployeeNumber = f.EmployeeNumber }).Distinct(); string emp = ""; foreach (string s in employees.Select(o => o.EmployeeNumber)) { emp += s + ","; } emp = emp.Remove(emp.Length - 1); var lkEmployess = db2.GetEmployees(emp).ToList(); foreach (GetEmployees_Result r in lkEmployess) { tblHR_Entities hr = new tblHR_Entities(); hr.EntityID = r.EntityID; hr.FullName = r.FullName; db.tblHR_Entities.Add(hr); } db.SaveChanges(); //get jobcodes for every user var users = (from f in db.Users where f.EmployeeNumber != null select new { EmployeeNumber = f.EmployeeNumber }).Distinct(); string u = ""; foreach (string s in users.Select(o => o.EmployeeNumber)) { int n; bool isNumeric = int.TryParse(s, out n); if (isNumeric) { u += s + ","; } } u = u.Remove(u.Length - 1); var lkUsers = db2.GetRosteredJobcodesCSVByEmployeeNumbers(u, null, null).ToList(); foreach (GetRosteredJobcodesCSVByEmployeeNumbers_Result r in lkUsers) { User us = db.Users.Where(x => x.EmployeeNumber == r.EmployeeID.ToString()).FirstOrDefault(); if (us != null && r.Jobcodes_CSV != null) { us.JobCodes = r.Jobcodes_CSV.Replace(" ", ""); db.Entry(us).State = EntityState.Modified; } } db.SaveChanges(); var jobcodes = (from f in source select new { JobCode = f.JobCode }).Distinct(); string jc = ""; foreach (string s in jobcodes.Select(o => o.JobCode)) { jc += s + ","; } jc = jc.Remove(jc.Length - 1); var lkjobcodes = db2.GetPrograms(jc).ToList(); foreach (GetPrograms_Result r in lkjobcodes) { tblProgram j = new tblProgram(); j.Duration = r.Duration; j.JobCode = r.JobCode; j.JobFrom = r.JobFrom; j.SchoolCode = r.Client; j.Venue = r.Venue; j.Year = r.Year.ToString(); j.YearLvl = r.YearLvl; db.tblPrograms.Add(j); } db.SaveChanges(); System.Diagnostics.Debug.WriteLine("Starting ATLAS Data Update"); db.Database.ExecuteSqlCommand("UpdateATLASData"); System.Diagnostics.Debug.WriteLine("Finished ATLAS Data Update"); System.Diagnostics.Debug.WriteLine("Starting EmployeeName Update"); db.Database.ExecuteSqlCommand("UpdateEmployeeName"); System.Diagnostics.Debug.WriteLine("Finished EmployeeName Update"); System.Diagnostics.Debug.WriteLine("Starting Question Text Update"); db.Database.ExecuteSqlCommand("UpdateQuestionText"); System.Diagnostics.Debug.WriteLine("Finished Question Text Update"); System.Diagnostics.Debug.WriteLine("Starting Factor Text Update"); db.Database.ExecuteSqlCommand("UpdateFactorText"); System.Diagnostics.Debug.WriteLine("Finished Factor Text Update"); System.Diagnostics.Debug.WriteLine("Complete!"); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.Message); } }