public ActionResult Create(Company company)
{
db = new EMSEntities12();
if (ModelState.IsValid)
{
List<Company> companyList = db.Companies.ToList();
bool companyExists = false;
for (int x = 0; x < companyList.Count; ++x)
{
if (companyList[x].CompanyName == company.CompanyName)
{
companyExists = true;
}
}
if (!companyExists && company.CompanyName != null)
{
company.EnrolledSince = DateTime.Now;
db.Companies.Add(company);
db.SaveChanges();
}
return RedirectToAction("Index");
}
return View(company);
}
public ActionResult Edit(Company company)
{
db = new EMSEntities12();
if (ModelState.IsValid)
{
db.Entry(company).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(company);
}
public ActionResult ReportsHome()
{
Company company = new Company();
ViewBag.CompName = EMSPSSUtilities.GetCompList();
return View();
}
// GET: /Reports/
public ActionResult SeniorityReport(string CompList)
{
db = new EMSEntities12();
Company MyComp = new Company();
foreach (Company mycmp in db.Companies)
{
if (mycmp.CompanyName == CompList)
{
MyComp.CompanyId = mycmp.CompanyId;
}
}
//Dictionary<EmployeeType, String> emplist = new Dictionary<EmployeeType,String>();
Dictionary<EmployeeType, String> emplist2 = new Dictionary<EmployeeType, String>();
List<EmployeeType> emplist = new List<EmployeeType>();
List<String> strlst = new List<String>();
foreach (EmployeeType emptype in db.EmployeeTypes)
{
if (emptype.CompanyId == MyComp.CompanyId && emptype.Employee.Completed && emptype.Employee.Active)
{
emplist.Add(emptype);
ViewBag.CompanyName = emptype.Company.CompanyName;
// strlst.Add(ParseDays(emptype.DateofHire));
}
}
foreach (EmployeeType emptypes in emplist.OrderBy(x => x.DateofHire))
{
emplist2.Add(emptypes, ParseDays(emptypes.DateofHire));
}
//ViewBag.EmplList = strlst;
return View(emplist2);
}
public ActionResult HoursIndex(Nullable<DateTime> DateTimeQuery, string CompList)
{
db = new EMSEntities12();
//if (DateTimeQuery != null)
//{
// return View("HoursWorkedReport" );
//}
DateTime timeofweek = DateTime.Now ;
Company MyComp = new Company();
EmployeeType MyEmp = new EmployeeType();
TimeCard TimeCardEnt = new TimeCard();
Dictionary<EmployeeType, decimal?> emplist2 = new Dictionary<EmployeeType, decimal?>();
List<TimeCard> tmcard = new List<TimeCard>();
if (DateTimeQuery != null)
{
ViewBag.ThisCompany = CompList;
timeofweek = (DateTime)DateTimeQuery;
foreach (Company mycmp in db.Companies)
{
if (mycmp.CompanyName == CompList)
{
MyComp.CompanyId = mycmp.CompanyId;
}
}
while (timeofweek.DayOfWeek != DayOfWeek.Sunday)
{
timeofweek = timeofweek.AddDays(+1);
}
ViewBag.DateWeek = timeofweek;
}
List<EmployeeType> emplist = new List<EmployeeType>();
foreach (EmployeeType EmpTime in db.EmployeeTypes)
{
if (EmpTime.CompanyId == MyComp.CompanyId)
{
if (EmpTime.Employee.Completed && EmpTime.Employee.Active)
{
if (EmpTime.EmployeeType1 != "Contract ")
{
emplist.Add(EmpTime);
}
}
}
}
foreach (TimeCard TimecrdEnt in db.TimeCards)
{
if (TimecrdEnt.EmployedWith5Id == MyComp.CompanyId)
{
tmcard.Add(TimecrdEnt);
}
}
foreach (EmployeeType EMP in emplist)
{
foreach (TimeCard tmcrd in tmcard)
{
if (EMP.EmployeeId == tmcrd.EmployeeRef5Id)
{
if (DateTimeQuery == tmcrd.WeekOf)
{
emplist2.Add(EMP, TotalHours(tmcrd));
}
}
}
}
return View("HoursWorkedReport", emplist2);
}