public ActionResult Index() { var user = (UserMaster)Session["User"]; if (Session.SessionID != "") { var x = db.EmployeeGIs.ToList(); var employees = db.EmployeeGIs.Where(emp => emp.CustomerId == user.CustomerId && emp.EmployeeCode != user.EmployeeCode).ToList(); ViewBag.NoOfStaff = employees.Count; DateTime extDateRange = DateTime.Now.Date.AddMonths(6); ViewBag.NeartoRetirement = employees.Where(emp => emp.DateOfRetirement <= extDateRange).Count(); var TenderAssesment = (from a in db.PrequalificationScorings where a.CustomerId == user.CustomerId select a).ToList().Count(); ViewBag.TenderAssesment = TenderAssesment; DateTime today = DateTime.Now.Date; var emponleave = (from a in db.LeaveApplications where a.LeaveFromDate >= today && a.LeaveToDate >= today && a.IsApproved == true select a).Count(); var empdueforleave = (from a in db.LeaveApplications where a.LeaveFromDate > today && a.IsApproved == true select a).Count(); var emponduty = (from a in db.EmployeeGIs select a).Count(); ViewBag.emponleave = emponleave; ViewBag.empdueforleave = empdueforleave; emponduty = emponduty - (emponleave + empdueforleave); ViewBag.emponduty = emponduty; ViewBag.Store = (from a in db.StoreMasters select a).Count(); ViewBag.Central = (from a in db.ItemMasters where a.StoreId == 1 select a).Count(); ViewBag.Stationary = (from a in db.ItemMasters where a.StoreId == 2 select a).Count(); ViewBag.Chemical = (from a in db.ItemMasters where a.StoreId == 3 select a).Count(); ViewBag.Fertilizer = (from a in db.ItemMasters where a.StoreId == 4 select a).Count(); ViewBag.JrStaff = (from a in db.EmployeeGIs where a.Cadre == "Junior" select a).Count(); ViewBag.SrStaff = (from a in db.EmployeeGIs where a.Cadre == "Senior" select a).Count(); ViewBag.NyscStaff = (from a in db.EmployeeGIs where a.Cadre == "NYSC Members" select a).Count(); ViewBag.OthersStaff = (from a in db.EmployeeGIs where a.Cadre == "Others" select a).Count(); List <GraphData> GraphDataList = new List <GraphData>(); var results = (from tn in db.EmployeeGIs group tn by tn.DateOfRetirement.Year into bGroup orderby bGroup.Key select new { label = bGroup.Key, value = bGroup.Count() }).ToList(); ViewBag.DataPoints = JsonConvert.SerializeObject(results); var resultstender = (from tn in db.TenderOpenings group tn by tn.YearofProject into bGroup orderby bGroup.Key select new { label = bGroup.Key, value = bGroup.Count() }).ToList(); ViewBag.DataTender = JsonConvert.SerializeObject(resultstender); EmployeeAll empall = new EmployeeAll(); empall.employeegi = (from a in db.EmployeeGIs select a).ToList(); empall.employeeai = (from a in db.EmployeeAIs select a).ToList(); empall.employeepi = (from a in db.EmployeePIs select a).ToList(); return(View(empall)); } else { return(RedirectToAction("AdminLogin", "Login")); } }
public ActionResult EmployeeGeneralReport() { EmployeeAll empall = new EmployeeAll(); empall.employeegi = (from a in db.EmployeeGIs select a).ToList(); empall.employeeai = (from a in db.EmployeeAIs select a).ToList(); empall.employeemi = (from a in db.EmployeeMIs select a).ToList(); empall.employeesi = (from a in db.EmployeeSIs select a).ToList(); empall.employeepi = (from a in db.EmployeePIs select a).ToList(); return(View(empall)); }
public ActionResult EmployeePersonalReport() { var user = (UserMaster)Session["User"]; EmployeeAll empall = new EmployeeAll(); empall.employeegi = (from a in db.EmployeeGIs where a.CustomerId == user.CustomerId select a).ToList(); empall.employeeai = (from a in db.EmployeeAIs where a.CustomerId == user.CustomerId select a).ToList(); empall.employeemi = (from a in db.EmployeeMIs where a.CustomerId == user.CustomerId select a).ToList(); empall.employeesi = (from a in db.EmployeeSIs where a.CustomerId == user.CustomerId select a).ToList(); empall.employeepi = (from a in db.EmployeePIs where a.CustomerId == user.CustomerId select a).ToList(); return(View(empall)); }
public async Task <EmployeeAll> GetEmployeeLeavesAllDetailsAsync(EmployeeLeavesAllDetailsRequestDTO employeeLeavesAllDetailsRequestDTO) { //String queryEmployee = @QueryConstants.EMPLOYEE_TRAINING + QueryConstants.EMPLOYEE_VACATION + QueryConstants.EMPLOYEE_WFH; //String queryEmployee = @QueryConstants.EMPLOYEE_TRAINING + QueryConstants.EMPLOYEE_VACATION + QueryConstants.EMPLOYEE_WFH; StringBuilder queryEmpDetails = new StringBuilder(); if (employeeLeavesAllDetailsRequestDTO.EmployeeId != null) { queryEmpDetails.Append(@QueryConstants.EMPLOYEE_DETAILS); queryEmpDetails.Append($" where emp.id=" + employeeLeavesAllDetailsRequestDTO.EmployeeId + ";"); queryEmpDetails.Append(QueryConstants.EMPLOYEE_TRAINING); queryEmpDetails.Append($" where emp.id=" + employeeLeavesAllDetailsRequestDTO.EmployeeId + " and "); queryEmpDetails.Append(" et.DateFrom >= CONVERT(varchar, '" + employeeLeavesAllDetailsRequestDTO.DateFrom + "',3) and et.DateTo <= CONVERT(varchar, '" + employeeLeavesAllDetailsRequestDTO.DateTo + "',3);"); queryEmpDetails.Append(QueryConstants.EMPLOYEE_VACATION); queryEmpDetails.Append($" where emp.id=" + employeeLeavesAllDetailsRequestDTO.EmployeeId + " and "); queryEmpDetails.Append("ev.DateFrom >= CONVERT(varchar, '" + employeeLeavesAllDetailsRequestDTO.DateFrom + "',3) and ev.DateTo <= CONVERT(varchar, '" + employeeLeavesAllDetailsRequestDTO.DateTo + "',3);"); queryEmpDetails.Append(QueryConstants.EMPLOYEE_WFH).Append($" where emp.id=" + employeeLeavesAllDetailsRequestDTO.EmployeeId + ";");; } else { queryEmpDetails.Append(@QueryConstants.EMPLOYEE_DETAILS + ";"); queryEmpDetails.Append(QueryConstants.EMPLOYEE_TRAINING + " and "); queryEmpDetails.Append(" et.DateFrom >= CONVERT(varchar, '" + employeeLeavesAllDetailsRequestDTO.DateFrom + "',3) and et.DateTo <= CONVERT(varchar, '" + employeeLeavesAllDetailsRequestDTO.DateTo + "',3);"); queryEmpDetails.Append(QueryConstants.EMPLOYEE_VACATION + " and "); queryEmpDetails.Append("ev.DateFrom >= CONVERT(varchar, '" + employeeLeavesAllDetailsRequestDTO.DateFrom + "',3) and ev.DateTo <= CONVERT(varchar, '" + employeeLeavesAllDetailsRequestDTO.DateTo + "',3);"); queryEmpDetails.Append(QueryConstants.EMPLOYEE_WFH); } EmployeeAll employeeAll = new EmployeeAll(); using (var conn = _context.Connection) { conn.Open(); var multi = await conn.QueryMultipleAsync(queryEmpDetails.ToString(), null); var employeeAllDetails = await multi.ReadAsync <EmployeeAllDetails>(); var employeesTrainingDetails = await multi.ReadAsync <EmployeeAllDetailsTraining>(); var employeeAllDetailsVacation = await multi.ReadAsync <EmployeeAllDetailsVacation>(); var employeeAllDetailsWFH = await multi.ReadAsync <EmployeeAllDetailsWFH>(); employeeAll.EmployeeAllDetails = employeeAllDetails.First(); employeeAll.EmployeeAllDetailsTraining = employeesTrainingDetails; employeeAll.EmployeeAllDetailsVacation = employeeAllDetailsVacation; employeeAll.EmployeeAllDetailsWFH = employeeAllDetailsWFH; conn.Close(); } return(employeeAll); }
// GET: EmployeeAIs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } /////// int year = DateTime.Now.Year; var list = new List <int>(); for (int i = 1950; i <= year; i++) { list.Add(i); } List <SelectListItem> YearOfGraduation1 = new List <SelectListItem>(); //YearOfGraduation1.Add(new SelectListItem { Text = "Select", Value = "0" }); for (int i = 1950; i <= year; i++) { YearOfGraduation1.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString() }); } ViewBag.YearOfGraduation1s = new SelectList(YearOfGraduation1, "Text", "Text"); ViewBag.YearOfGraduation2s = new SelectList(YearOfGraduation1, "Text", "Text"); ViewBag.YearOfGraduation3s = new SelectList(YearOfGraduation1, "Text", "Text"); /////// ViewBag.Qualification1s = new SelectList(db.QualificationMasters, "QualificationName", "QualificationName"); ViewBag.Qualification2s = new SelectList(db.QualificationMasters, "QualificationName", "QualificationName"); ViewBag.Qualification3s = new SelectList(db.QualificationMasters, "QualificationName", "QualificationName"); EmployeeAI employeeAI = db.EmployeeAIs.Find(id); if (employeeAI == null) { return(HttpNotFound()); } EmployeeAll empall = new EmployeeAll(); var empid = (from a in db.EmployeeAIs where a.EmployeeAIId == id select a.EmployeeCode).FirstOrDefault(); empall.employeeai = (from a in db.EmployeeAIs where a.EmployeeAIId == id select a).ToList(); empall.employeeassociation = (from a in db.EmpAIAssociations where a.EmployeeCode == empid select a).ToList(); empall.employeeconference = (from a in db.EmpAIConferences where a.EmployeeCode == empid select a).ToList(); ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "EmployeeCode", employeeAI.EmployeeCode); return(View(empall)); //return View(employeeAI); }
public ActionResult FullDetails(int?id) { EmployeeAll empall = new EmployeeAll(); empall.employeegi = (from a in db.EmployeeGIs where a.EmployeeCode == id select a).ToList(); empall.employeeai = (from a in db.EmployeeAIs where a.EmployeeCode == id select a).ToList(); empall.employeemi = (from a in db.EmployeeMIs where a.EmployeeCode == id select a).ToList(); empall.employeesi = (from a in db.EmployeeSIs where a.EmployeeCode == id select a).ToList(); empall.employeepi = (from a in db.EmployeePIs where a.EmployeeCode == id select a).ToList(); empall.employeeassociation = (from a in db.EmpAIAssociations where a.EmployeeCode == id select a).ToList(); empall.employeeconference = (from a in db.EmpAIConferences where a.EmployeeCode == id select a).ToList(); empall.employeeleaveledger = (from a in db.LeaveLedgers where a.EmployeeCode == id select a).ToList(); return(View(empall)); }