public ActionResult AdjustLeaveQuotaStepOne() { string EmpNo = Request.Form["AdjustEmpNo"].ToString(); User LoggedInUser = Session["LoggedUser"] as User; var emp = db.Emps.Where(aa => aa.EmpNo == EmpNo && aa.Status == true).ToList(); if (emp.Count > 0) { //Check for Employee lies under user permission if (CheckEmpValidation(emp)) { int EmpID = emp.FirstOrDefault().EmpID; var lvType = db.LvConsumeds.Where(aa => aa.EmpID == EmpID).ToList(); if (lvType.Count > 0) { //go to next page LeaveQuotaModel lvModel = new LeaveQuotaModel(); lvModel.EmpID = emp.FirstOrDefault().EmpID; lvModel.EmpNo = emp.FirstOrDefault().EmpNo; lvModel.EmpName = emp.FirstOrDefault().EmpName; lvModel.SectionName = emp.FirstOrDefault().Section.SectionName; foreach (var lv in lvType) { switch (lv.LeaveType) { case "A": //CL lvModel.CL = (float)lv.YearRemaining; break; case "B": //AL lvModel.AL = (float)lv.YearRemaining; break; case "C": //SL lvModel.SL = (float)lv.YearRemaining; break; } } return(View("AdjustLeaves", lvModel)); } } else { ViewBag.CMessage = "Employee No " + Request.Form["AdjustEmpNo"].ToString() + ": Create Leave Quota for this employee"; } } else { ViewBag.CMessage = "Employee No " + Request.Form["EmpNo"].ToString() + " not found"; } ViewBag.LocationID = new SelectList(db.Locations.OrderBy(s => s.LocName), "LocID", "LocName"); ViewBag.CatID = new SelectList(db.Categories.OrderBy(s => s.CatName), "CatID", "CatName"); ViewBag.TypeID = new SelectList(db.EmpTypes.OrderBy(s => s.TypeName), "TypeID", "TypeName"); return(View("Index")); }
public ActionResult LvQuotaList(string searchString, string currentFilter, int?page) { if (searchString != null) { page = 1; } else { searchString = currentFilter; } List <LvConsumed> LeavesQuota = new List <LvConsumed>(); LeavesQuota = db.LvConsumeds.ToList(); List <LeaveQuotaModel> _leavesQuotaModel = new List <LeaveQuotaModel>(); foreach (var item in LeavesQuota) { if (_leavesQuotaModel.Where(aa => aa.EmpID == item.EmpID).Count() > 0) { switch (item.LeaveType) { case "A": //casual _leavesQuotaModel.Where(aa => aa.EmpID == item.EmpID).FirstOrDefault().CL = (float)item.YearRemaining; break; case "B": //anual _leavesQuotaModel.Where(aa => aa.EmpID == item.EmpID).FirstOrDefault().AL = (float)item.YearRemaining; break; case "C": //sick _leavesQuotaModel.Where(aa => aa.EmpID == item.EmpID).FirstOrDefault().SL = (float)item.YearRemaining; break; } } else { LeaveQuotaModel lvModel = new LeaveQuotaModel(); lvModel.EmpID = item.Emp.EmpID; lvModel.EmpNo = item.Emp.EmpNo; lvModel.EmpName = item.Emp.EmpName; lvModel.SectionName = item.Emp.Section.SectionName; switch (item.LeaveType) { case "A": //casual lvModel.CL = (float)item.YearRemaining; break; case "B": //anual lvModel.AL = (float)item.YearRemaining; break; case "C": //sick lvModel.SL = (float)item.YearRemaining; break; } _leavesQuotaModel.Add(lvModel); } } ViewBag.CurrentFilter = searchString; if (!String.IsNullOrEmpty(searchString)) { try { _leavesQuotaModel = _leavesQuotaModel.Where(s => s.EmpName.ToUpper().Contains(searchString.ToUpper()) || s.EmpNo.ToUpper().Contains(searchString.ToUpper()) || s.SectionName.ToUpper().Contains(searchString.ToUpper())).ToList(); } catch (Exception ex) { } } int pageSize = 10; int pageNumber = (page ?? 1); return(View(_leavesQuotaModel.ToPagedList(pageNumber, pageSize))); //return View(_leavesQuotaModel); }
public ActionResult AdjustLeaveQuotaStepOne() { string EmpNo= Request.Form["AdjustEmpNo"].ToString(); int CompanyID = Convert.ToInt32(Request.Form["CompanyID"].ToString()); User LoggedInUser = Session["LoggedUser"] as User; var emp = db.Emps.Where(aa => aa.CompanyID == CompanyID && aa.EmpNo == EmpNo && aa.Status==true).ToList(); if (emp.Count > 0) { //Check for Employee lies under user permission if (CheckEmpValidation(emp)) { int EmpID = emp.FirstOrDefault().EmpID; var lvType = db.LvConsumeds.Where(aa => aa.EmpID == EmpID).ToList(); if (lvType.Count > 0) { //go to next page LeaveQuotaModel lvModel = new LeaveQuotaModel(); lvModel.EmpID = emp.FirstOrDefault().EmpID; lvModel.EmpNo = emp.FirstOrDefault().EmpNo; lvModel.EmpName = emp.FirstOrDefault().EmpName; lvModel.SectionName = emp.FirstOrDefault().Section.SectionName; foreach (var lv in lvType) { switch (lv.LeaveType) { case "A"://CL lvModel.CL = (float)lv.YearRemaining; break; case "B"://AL lvModel.AL = (float)lv.YearRemaining; break; case "C"://SL lvModel.SL = (float)lv.YearRemaining; break; } } return View("AdjustLeaves", lvModel); } } else { ViewBag.CMessage = "Employee No " + Request.Form["AdjustEmpNo"].ToString() + ": Create Leave Quota for this employee"; } } else { ViewBag.CMessage = "Employee No " + Request.Form["EmpNo"].ToString() + " not found"; } ViewBag.CompanyID = new SelectList(db.Companies.OrderBy(s=>s.CompName), "CompID", "CompName"); ViewBag.CompanyIDEmp = new SelectList(db.Companies.OrderBy(s=>s.CompName), "CompID", "CompName"); ViewBag.LocationID = new SelectList(db.Locations.OrderBy(s=>s.LocName), "LocID", "LocName"); ViewBag.CatID = new SelectList(db.Categories.OrderBy(s=>s.CatName), "CatID", "CatName"); return View("Index"); }
public ActionResult LvQuotaList(string searchString, string currentFilter, int? page) { if (searchString != null) { page = 1; } else { searchString = currentFilter; } List<LvConsumed> LeavesQuota = new List<LvConsumed>(); LeavesQuota = db.LvConsumeds.ToList(); List<LeaveQuotaModel> _leavesQuotaModel = new List<LeaveQuotaModel>(); foreach (var item in LeavesQuota) { if (_leavesQuotaModel.Where(aa => aa.EmpID == item.EmpID).Count() > 0) { switch (item.LeaveType) { case "A"://casual _leavesQuotaModel.Where(aa => aa.EmpID == item.EmpID).FirstOrDefault().CL = (float)item.YearRemaining; break; case "B"://anual _leavesQuotaModel.Where(aa => aa.EmpID == item.EmpID).FirstOrDefault().AL = (float)item.YearRemaining; break; case "C"://sick _leavesQuotaModel.Where(aa => aa.EmpID == item.EmpID).FirstOrDefault().SL = (float)item.YearRemaining; break; } } else { LeaveQuotaModel lvModel = new LeaveQuotaModel(); lvModel.EmpID = item.Emp.EmpID; lvModel.EmpNo = item.Emp.EmpNo; lvModel.EmpName = item.Emp.EmpName; lvModel.SectionName = item.Emp.Section.SectionName; switch (item.LeaveType) { case "A"://casual lvModel.CL = (float)item.YearRemaining; break; case "B"://anual lvModel.AL = (float)item.YearRemaining; break; case "C"://sick lvModel.SL = (float)item.YearRemaining; break; } _leavesQuotaModel.Add(lvModel); } } ViewBag.CurrentFilter = searchString; if (!String.IsNullOrEmpty(searchString)) { try { _leavesQuotaModel = _leavesQuotaModel.Where(s => s.EmpName.ToUpper().Contains(searchString.ToUpper()) || s.EmpNo.ToUpper().Contains(searchString.ToUpper()) || s.SectionName.ToUpper().Contains(searchString.ToUpper())).ToList(); } catch (Exception ex) { } } int pageSize = 10; int pageNumber = (page ?? 1); return View(_leavesQuotaModel.ToPagedList(pageNumber, pageSize)); //return View(_leavesQuotaModel); }
public ActionResult AdjustLeaveQuotaStepOne() { string EmpNo = Request.Form["AdjustEmpNo"].ToString(); DateTime dt = DateTime.Today; if (Request.Form["ALQDate"].ToString() != "") { string date = Request.Form["ALQDate"].ToString(); dt = Convert.ToDateTime(date); } int CompanyID = Convert.ToInt32(Request.Form["CompanyID"].ToString()); User LoggedInUser = Session["LoggedUser"] as User; var emp = db.Emps.Where(aa => aa.CompanyID == CompanyID && aa.EmpNo == EmpNo && aa.Status == true).ToList(); if (emp.Count > 0) { //Check for Employee lies under user permission if (CheckEmpValidation(emp)) { int EmpID = emp.FirstOrDefault().EmpID; string year = dt.Year.ToString(); var lvType = db.LvConsumeds.Where(aa => aa.EmpID == EmpID && aa.Year == year).ToList(); if (lvType.Count > 0) { //go to next page LeaveQuotaModel lvModel = new LeaveQuotaModel(); lvModel.EmpID = emp.FirstOrDefault().EmpID; lvModel.EmpNo = emp.FirstOrDefault().EmpNo; lvModel.EmpName = emp.FirstOrDefault().EmpName; lvModel.Year = year; lvModel.SectionName = emp.FirstOrDefault().Section.SectionName; foreach (var lv in lvType) { switch (lv.LeaveType) { case "A": //CL if (lv.YearRemaining != null) { lvModel.CL = (float)lv.YearRemaining; } break; case "B": //AL if (lv.YearRemaining != null) { lvModel.AL = (float)lv.YearRemaining; } break; case "C": //SL if (lv.YearRemaining != null) { lvModel.SL = (float)lv.YearRemaining; } break; case "E": //CPL if (lv.YearRemaining != null) { lvModel.CPL = (float)lv.YearRemaining; } break; } } return(View("AdjustLeaves", lvModel)); } } else { ViewBag.CMessage = "Employee No " + Request.Form["AdjustEmpNo"].ToString() + ": Create Leave Quota for this employee"; } } else { ViewBag.CMessage = "Employee No " + Request.Form["EmpNo"].ToString() + " not found"; } ViewBag.CompanyID = new SelectList(CustomFunction.GetCompanies(db.Companies.ToList(), LoggedInUser), "CompID", "CompName", LoggedInUser.CompanyID); ViewBag.CompanyIDEmp = new SelectList(CustomFunction.GetCompanies(db.Companies.ToList(), LoggedInUser), "CompID", "CompName", LoggedInUser.CompanyID); ViewBag.LocationID = new SelectList(db.Locations.OrderBy(s => s.LocName), "LocID", "LocName"); ViewBag.CatID = new SelectList(db.Categories.OrderBy(s => s.CatName), "CatID", "CatName"); return(View("Index")); }