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));
}
