public ActionResult Edit([Bind(Include = "ReportDataID,JobCode,Group,ID,QuestionID,PrePost,Score,QualResponse,PQA1,PQA2,PQA3,Factor,School,YearLevel,Days,Venue,Year,ProgramStartDate")] ReportData reportData)
{
if (ModelState.IsValid)
{
db.Entry(reportData).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(reportData));
}
public ActionResult Edit([Bind(Include = "UserGroupID,UserGroupName")] UserGroup userGroup)
{
if (ModelState.IsValid)
{
db.Entry(userGroup).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userGroup));
}
public ActionResult Edit([Bind(Include = "SurveyID,SurveyName,SurveyCode,SurveyType,CreatedBy,CreatedDate,ModifedBy,ModifiedDate")] Surveys surveys)
{
if (ModelState.IsValid)
{
User u = UserHelper.getMember(db);
surveys.ModifedBy = u.UserID;
surveys.ModifiedDate = DateTime.Now;
db.Entry(surveys).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SurveyType = new SelectList(new[]
{
new { Value = "Participant", Text = "Participant" },
new { Value = "OEG Staff", Text = "OEG Staff" },
new { Value = "School Staff", Text = "School Staff" }
}
, "Value", "Text");
return(View(surveys));
}
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);
}
}
public ActionResult Edit(string Hidden_Schools, string Hidden_JobCodes, [Bind(Include = "EmployeeNumber,School,UserID,UserGUID,UserGroupID,Email,PWD,FirstName,Surname,CreatedBy,CreatedDate,ModifedBy,ModifiedDate")] User user)
{
if (ModelState.IsValid)
{
User u = UserHelper.getMember(db);
user.ModifedBy = u.UserID;
user.ModifiedDate = DateTime.Now;
if (user.UserGroupID == 1006 || user.UserGroupID == 1007 || user.UserGroupID == 1009)
{
user.JobCodes = Hidden_JobCodes;
}
if (user.UserGroupID == 1008)
{
user.Schools = Hidden_Schools;
}
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
if (User.IsInRole("Senior Manager"))
{
ViewBag.UserGroupID = new SelectList(new[]
{
new { Value = "1009", Text = "School Coordinator" }
}
, "Value", "Text", user.UserGroupID);
}
else if (User.IsInRole("Director"))
{
ViewBag.UserGroupID = new SelectList(new[]
{
new { Value = "1006", Text = "Program Leader" },
new { Value = "1008", Text = "Senior Manager" }
}
, "Value", "Text", user.UserGroupID);
}
else if (User.IsInRole("Head of Teaching Team"))
{
ViewBag.UserGroupID = new SelectList(new[]
{
new { Value = "1007", Text = "Group Leader" }
}
, "Value", "Text", user.UserGroupID);
}
else
{
ViewBag.UserGroupID = new SelectList(db.UserGroups, "UserGroupID", "UserGroupName", user.UserGroupID);
}
var source = from f in db.ReportDatas
select f;
if (User.IsInRole("Senior Manager"))
{
User u = UserHelper.getMember(db);
source = from f in db.ReportDatas
where u.Schools.Contains(f.School)
select f;
}
var jobcodes = (from f in source
select new { JobCode = f.JobCode }).Distinct();
ViewBag.JobCodes = new SelectList(jobcodes.OrderBy(x => x.JobCode), "JobCode", "JobCode");
var schools = (from f in source
select new { School = f.School }).Distinct();
ViewBag.Schools = new SelectList(schools.OrderBy(x => x.School), "School", "School");
ViewBag.Hidden_JobCodes = Hidden_JobCodes;
ViewBag.Hidden_Schools = Hidden_Schools;
return(View(user));
}
