public ActionResult CreateLoc()
{
VMJCApplication vmDemo = new VMJCApplication();
vmDemo.LocEmployees = db.HR_Location.ToList();
vmDemo.TypeEmployees = db.HR_EmpType.ToList();
vmDemo.DeptEmployees = db.HR_Department.ToList();
vmDemo.SecEmployees = db.HR_Section.ToList();
vmDemo.ShiftEmployees = db.Att_Shift.ToList();
ViewBag.JobCardType = new SelectList(db.Att_JobCard.OrderBy(aa => aa.JCName).ToList(), "JCID", "JCName");
return(View(vmDemo));
}
public ActionResult SelectEmployee(FormCollection form)
{
try
{
string ErrorMessage = "";
List <EmpView> emps = new List <EmpView>();
ViewUserEmp LoggedInUser = Session["LoggedUser"] as ViewUserEmp;
emps = db.EmpViews.Where(aa => aa.Status == "Active").ToList();
List <EmpView> ViewEmps = new List <EmpView>();
List <EmpView> tempEmps = new List <EmpView>();
VMJCApplication vm = new VMJCApplication();
ViewEmps = emps.ToList();
vm.CardType = Request.Form["JobCardType"].ToString();
vm.DateEnded = Convert.ToDateTime(Request.Form["JobDateTo"]);
vm.JCValue = Convert.ToInt32(Request.Form["JCValue"]);
vm.DateStarted = Convert.ToDateTime(Request.Form["JobDateFrom"]);
if (Request.Form["SelectionRB"].ToString() == "rbAll")
{
ViewEmps = emps.ToList();
vm.JCCriteria = "A";
}
else
{
var checkedLoc = form.GetValues("cbLocation");
List <HR_Location> locs = new List <HR_Location>();
locs = db.HR_Location.ToList();
if (checkedLoc != null)
{
List <HR_Location> tempLocs = new List <HR_Location>();
foreach (var item in checkedLoc)
{
short id = Convert.ToInt16(item);
tempEmps.AddRange(ViewEmps.Where(aa => aa.LocID == id).ToList());
tempLocs.Add(locs.First(aa => aa.LocID == id));
}
ViewEmps = tempEmps.ToList();
vm.LocEmployees = tempLocs;
vm.JCCriteria = "L";
}
else
{
tempEmps = ViewEmps.ToList();
tempEmps.Clear();
}
//
var checkedType = form.GetValues("cbType");
List <HR_EmpType> types = new List <HR_EmpType>();
types = db.HR_EmpType.ToList();
if (checkedType != null)
{
List <HR_EmpType> tempTypes = new List <HR_EmpType>();
foreach (var item in checkedType)
{
short id = Convert.ToInt16(item);
string name = types.First(aa => aa.TypID == id).TypeName;
tempEmps.AddRange(ViewEmps.Where(aa => aa.TypeName == name).ToList());
tempTypes.Add(types.First(aa => aa.TypID == id));
}
ViewEmps = tempEmps.ToList();
vm.TypeEmployees = tempTypes;
vm.JCCriteria = "T";
}
else
{
tempEmps = ViewEmps.ToList();
tempEmps.Clear();
}
//
var checkedShift = form.GetValues("cbShift");
List <Att_Shift> shifts = new List <Att_Shift>();
shifts = db.Att_Shift.ToList();
if (checkedShift != null)
{
List <Att_Shift> tempShifts = new List <Att_Shift>();
tempEmps.Clear();
foreach (var item in checkedShift)
{
short id = Convert.ToInt16(item);
//string name = depts.First(aa => aa.DeptID == id).DeptID;
tempEmps.AddRange(ViewEmps.Where(aa => aa.ShftID == id).ToList());
tempShifts.Add(shifts.First(aa => aa.ShftID == id));
}
ViewEmps = tempEmps.ToList();
vm.ShiftEmployees = tempShifts;
vm.JCCriteria = "H";
}
else
{
tempEmps = ViewEmps.ToList();
}
}
foreach (var emp in tempEmps.ToList())
{
Att_JobCardApp jobCardApp = new Att_JobCardApp();
jobCardApp.JCTypeID = Convert.ToInt16(vm.CardType);
jobCardApp.DateCreated = DateTime.Now;
jobCardApp.UserID = LoggedInUser.UserID;
jobCardApp.DateStarted = vm.DateStarted;
jobCardApp.DateEnded = vm.DateEnded;
jobCardApp.Status = false;
jobCardApp.EmpID = emp.EmployeeID;
jobCardApp.TimeBased = false;
if (vm.JCValue != null)
{
jobCardApp.TotalMins = (short)vm.JCValue;
}
jobCardApp.Remarks = "ByApp";
jobCardApp.StatusID = "Approved";
jobCardApp.ApprovedDate = DateTime.Now;
db.Att_JobCardApp.Add(jobCardApp);
}
db.SaveChanges();
if (ErrorMessage == "")
{
return(View(vm));
}
else
{
VMJCApplication vmDemo = new VMJCApplication();
vmDemo.LocEmployees = db.HR_Location.ToList();
vmDemo.TypeEmployees = db.HR_EmpType.ToList();
vmDemo.DeptEmployees = db.HR_Department.ToList();
vmDemo.SecEmployees = db.HR_Section.ToList();
vmDemo.ShiftEmployees = db.Att_Shift.ToList();
ViewBag.JobCardType = new SelectList(db.Att_JobCard.OrderBy(aa => aa.JCName).ToList(), "JCID", "JCName");
return(View("Index", vmDemo));
}
}
catch (Exception)
{
throw;
}
}
