public ActionResult AdminHome()
{
db = new EMSEntities12();
Employee employee = new Employee();
List<Employee> emplist = new List<Employee>();
foreach(FullTimeEmployee FtCompleted in db.FullTimeEmployees )
{
if (!FtCompleted.Employee.Completed)
{
emplist.Add(FtCompleted.Employee);
}
}
foreach (PartTimeEmployee PtCompleted in db.PartTimeEmployees)
{
if (!PtCompleted.Employee.Completed)
{
emplist.Add(PtCompleted.Employee);
}
}
foreach (SeasonalEmployee SesonCompleted in db.SeasonalEmployees)
{
if (!SesonCompleted.Employee.Completed)
{
emplist.Add(SesonCompleted.Employee);
}
}
return View(emplist);
}
public static void AuditNewBaseEmployee(Employee newEmployee, String Username)
{
CompareFields("", newEmployee.FirstName, 3, 1, newEmployee.EmployeeId, Username);
CompareFields("", newEmployee.LastName, 2, 1, newEmployee.EmployeeId, Username);
CompareFields("", newEmployee.SIN_BN, 1, 1, newEmployee.EmployeeId, Username);
CompareFields("", newEmployee.DateOfBirth.ToString(), 4, 1, newEmployee.EmployeeId, Username);
}
public static void AuditExistingEmployee(int existingEmpId, Employee newEmployee,String Username)
{
Employee existingEmp = db.Employees.Find(existingEmpId);
CompareFields(existingEmp.FirstName, newEmployee.FirstName, 3, 2, existingEmp.EmployeeId, Username);
CompareFields(existingEmp.LastName, newEmployee.LastName, 2, 2, existingEmp.EmployeeId, Username);
CompareFields(existingEmp.SIN_BN.ToString(), newEmployee.SIN_BN.ToString(), 1, 2, existingEmp.EmployeeId, Username);
CompareFields(existingEmp.DateOfBirth.ToString(), newEmployee.DateOfBirth.ToString(), 4, 2, existingEmp.EmployeeId, Username);
}
public ActionResult Index()
{
db = new EMSEntities12();
if (User.IsInRole("Admin")) // find employees that need completion
{
Employee employee = new Employee();
List<Employee> emplist = new List<Employee>();
foreach (FullTimeEmployee FtCompleted in db.FullTimeEmployees)
{
if (!FtCompleted.Employee.Completed)
{
emplist.Add(FtCompleted.Employee);
}
}
foreach (PartTimeEmployee PtCompleted in db.PartTimeEmployees)
{
if (!PtCompleted.Employee.Completed)
{
emplist.Add(PtCompleted.Employee);
}
}
foreach (SeasonalEmployee SesonCompleted in db.SeasonalEmployees)
{
if (!SesonCompleted.Employee.Completed)
{
emplist.Add(SesonCompleted.Employee);
}
}
return View(emplist);
}
else // find employees that need time card entries for this week
{
List<Employee> emplist = new List<Employee>();
List<TimeCard> tcl = db.TimeCards.ToList();
List<Piece> pl = db.Pieces.ToList();
DateTime weekOf = DateTime.Now;
while (weekOf.DayOfWeek != DayOfWeek.Monday)
{
weekOf = weekOf.AddDays(-1);
}
Boolean Found = false;
foreach (FullTimeEmployee ft in db.FullTimeEmployees)
{
if (ft.Employee.Active && ft.Employee.Completed)
{
foreach (TimeCard tc in tcl)
{
if (tc.EmployeeRef5Id == ft.EmployeeRefId && tc.WeekOf.Day == weekOf.Day && tc.WeekOf.Month == weekOf.Month && tc.WeekOf.Year == weekOf.Year)
{
Found = true;
if (tc.Mon == null || tc.Sat == null || tc.Sun == null || tc.Thu == null || tc.Tue == null || tc.Wed == null || tc.Fri == null)
{
emplist.Add(ft.Employee);
}
}
}
if (!Found)
{
emplist.Add(ft.Employee);
}
Found = false;
}
}
foreach (PartTimeEmployee pt in db.PartTimeEmployees)
{
if (pt.Employee.Active && pt.Employee.Completed)
{
foreach (TimeCard tc in tcl)
{
if (tc.EmployeeRef5Id == pt.EmployeeRef2Id && tc.WeekOf.Day == weekOf.Day && tc.WeekOf.Month == weekOf.Month && tc.WeekOf.Year == weekOf.Year)
{
Found = true;
if (tc.Mon == null || tc.Sat == null || tc.Sun == null || tc.Thu == null || tc.Tue == null || tc.Wed == null || tc.Fri == null)
{
emplist.Add(pt.Employee);
}
}
}
if (!Found)
{
emplist.Add(pt.Employee);
}
Found = false;
}
}
foreach (SeasonalEmployee se in db.SeasonalEmployees)
{
if (se.Employee.Active && se.Employee.Completed)
{
foreach (TimeCard tc in tcl)
{
if (tc.EmployeeRef5Id == se.EmployeeRef3Id && tc.WeekOf.Day == weekOf.Day && tc.WeekOf.Month == weekOf.Month && tc.WeekOf.Year == weekOf.Year)
{
Found = true;
if (tc.Mon == null || tc.Sat == null || tc.Sun == null || tc.Thu == null || tc.Tue == null || tc.Wed == null || tc.Fri == null)
{
emplist.Add(se.Employee);
}
}
}
if (!Found)
{
emplist.Add(se.Employee);
}
Found = false;
}
}
return View(emplist);
}
}
public static Boolean ValidateEmployeeComplete(Employee e)
{
Boolean complete = true;
if (e.FirstName == null)
{
complete = false;
}
else if (e.LastName == null)
{
complete = false;
}
else if (e.DateOfBirth == null)
{
complete = false;
}
else if (e.SIN_BN == null)
{
complete = false;
}
return complete;
}
public ActionResult Seasonal(SeasonalEmployee Semployee, string CompList, string SeasonLst, string name, string last, string day, string month, string year, string sin)
{
db = new EMSEntities12();
ViewBag.SeasonName = EMSPSSUtilities.GetSeasonList();
ViewBag.CompName = EMSPSSUtilities.GetCompList();
EmployeeType ETemployee = new EmployeeType();
ViewBag.Employees = GetOptions();
Employee employee = new Employee();
employee.FirstName = name;
employee.LastName = last;
int Year = 0, Month = 0, Day = 0;
Int32.TryParse(year, out Year);
Int32.TryParse(day, out Day);
Int32.TryParse(month, out Month);
employee.DateOfBirth = new DateTime(Year, Month, Day);
employee.SIN_BN = sin;
employee.Completed = false;
foreach (Company mycmp in db.Companies)
{
if (mycmp.CompanyName == CompList)
{
Semployee.EmployedWith3Id = mycmp.CompanyId;
}
}
foreach (Season myseas in db.Seasons)
{
if (myseas.Season1 == SeasonLst)
{
Semployee.SeasonId = myseas.SeasonId;
}
}
ETemployee.CompanyId = Semployee.EmployedWith3Id;
ETemployee.EmployeeType1 = "Seasonal";
ETemployee.DateofHire = Semployee.SeasonYear;
if (CompList == "")
{
ModelState.AddModelError("comp", "This field is Required.");
}
if (SeasonLst == "")
{
ModelState.AddModelError("season", "This field is Required.");
}
if (!EMSPSSUtilities.DateIsElapsed(employee.DateOfBirth, Semployee.SeasonYear, 18))
{
ModelState.AddModelError("DOH", "A seasonal employee must be at least 18 years old.");
}
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
EMSPSSUtilities.AuditNewBaseEmployee(employee, User.Identity.Name);
Semployee.EmployeeRef3Id = employee.EmployeeId;
ETemployee.EmployeeId = Semployee.EmployeeRef3Id;
EMSPSSUtilities.CompareFields("", Semployee.SeasonId.ToString(), 17, 1, Semployee.EmployeeRef3Id, User.Identity.Name);
db.SeasonalEmployees.Add(Semployee);
db.EmployeeTypes.Add(ETemployee);
db.SaveChanges();
return RedirectToAction("SearchIndex", "Home", new { FirstName = Semployee.Employee.FirstName, LastName = Semployee.Employee.LastName, SINBN = Semployee.Employee.SIN_BN });
}
return View(Semployee);
}
public ActionResult PartTime(PartTimeEmployee PTemployee, string CompList, string name, string last, string day, string month, string year, string sin)
{
db = new EMSEntities12();
EmployeeType ETemployee = new EmployeeType();
ViewBag.Employees = GetOptions();
ViewBag.CompName = EMSPSSUtilities.GetCompList();
Employee employee = new Employee();
employee.FirstName = name;
employee.LastName = last;
int Year = 0, Month = 0, Day = 0;
Int32.TryParse(year, out Year);
Int32.TryParse(day, out Day);
Int32.TryParse(month, out Month);
employee.DateOfBirth = new DateTime(Year, Month, Day);
employee.SIN_BN = sin;
employee.Completed = false;
foreach (Company mycmp in db.Companies)
{
if (mycmp.CompanyName == CompList)
{
PTemployee.EmployedWith2Id = mycmp.CompanyId;
}
}
ETemployee.CompanyId = PTemployee.EmployedWith2Id;
ETemployee.EmployeeType1 = "Part Time";
ETemployee.DateofHire = PTemployee.DateOfHire;
PTemployee.Employee = employee;
if (CompList == "")
{
ModelState.AddModelError("comp", "This field is Required.");
}
if (!EMSPSSUtilities.DateIsElapsed(employee.DateOfBirth, PTemployee.DateOfHire, 16))
{
ModelState.AddModelError("DOH", "A part time employee must be at least 16 years old.");
}
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
EMSPSSUtilities.AuditNewBaseEmployee(employee, User.Identity.Name);
PTemployee.EmployeeRef2Id = employee.EmployeeId;
ETemployee.EmployeeId = PTemployee.EmployeeRef2Id;
EMSPSSUtilities.CompareFields("", PTemployee.DateOfHire.ToString(), 11, 1, PTemployee.EmployeeRef2Id, User.Identity.Name);
db.PartTimeEmployees.Add(PTemployee);
db.EmployeeTypes.Add(ETemployee);
db.SaveChanges();
return RedirectToAction("SearchIndex", "Home", new { FirstName = PTemployee.Employee.FirstName, LastName = PTemployee.Employee.LastName, SINBN = PTemployee.Employee.SIN_BN });
}
return View(PTemployee);
}
public ActionResult Fulltime(Employee employee, string name, string last, string day, string month, string year, string sin)
{
FullTimeEmployee FTemployee = new FullTimeEmployee();
ViewBag.Employees = GetOptions();
ViewBag.CompName = EMSPSSUtilities.GetCompList();
return View(FTemployee);
}
public ActionResult EmployeeCreation(Employee employee, string DDlist )
{
db = new EMSEntities12();
ViewBag.Employees = GetOptions();
String sin = employee.SIN_BN;
EMSPSSUtilities.SINValid(ref sin);
employee.SIN_BN = sin;
employee.Completed = false;
if (!EMSPSSUtilities.VerifySIN(employee.SIN_BN))
{
ModelState.AddModelError("SIN_BN", employee.SIN_BN + " is not a valid BN.");
}
if (!EMSPSSUtilities.DateIsElapsed(Convert.ToDateTime("1900-01-01"), employee.DateOfBirth))
{
ModelState.AddModelError("DOB", "Date of Birth must be past the year 1900.");
}
if (!EMSPSSUtilities.DateIsElapsed(employee.DateOfBirth, DateTime.Now))
{
ModelState.AddModelError("DOB", "Date of Birth must be in the past.");
}
if (ModelState.IsValid)
{
if ("Seasonal" == DDlist)
{
return RedirectToAction("Seasonal", new { name = employee.FirstName, last = employee.LastName, day = employee.DateOfBirth.Day.ToString(), month = employee.DateOfBirth.Month.ToString(), year = employee.DateOfBirth.Year.ToString(), sin = employee.SIN_BN });
}
else if ("PartTime" == DDlist)
{
return RedirectToAction("PartTime", new { name = employee.FirstName, last = employee.LastName, day = employee.DateOfBirth.Day.ToString(), month = employee.DateOfBirth.Month.ToString(), year = employee.DateOfBirth.Year.ToString(), sin = employee.SIN_BN });
}
else if ("FullTime" == DDlist)
{
return RedirectToAction("Fulltime", new { name = employee.FirstName, last = employee.LastName, day = employee.DateOfBirth.Day.ToString(), month = employee.DateOfBirth.Month.ToString(), year = employee.DateOfBirth.Year.ToString(), sin = employee.SIN_BN });
}
}
return View(employee);
}
public ActionResult EmployeeCreation()
{
Employee employee = new Employee();
ViewBag.Employees = GetOptions();
return View(employee);
}
