public ActionResult Dashboard() { MemberCookie pc = Getmember(); ViewBag.Organization = pc.MemberID; return(View()); }
public ActionResult LeaveStaff() { MemberCookie mc = Getmember(); int paid = 13; int casual = 6; int sick = 30; int EmpId = mc.EmpId; HumanResourceContext context = new HumanResourceContext(); var result1 = context.LeaveSet.Where(e => e.EmpId == mc.EmpId && e.Reason == "Paid Leave").FirstOrDefault(); if (result1 != null) { paid = context.LeaveSet.Where(e => e.EmpId == mc.EmpId && e.Reason == "Paid Leave").Sum(a => a.Days); paid = 13 - paid; } var result2 = context.LeaveSet.Where(e => e.EmpId == mc.EmpId && e.Reason == "Casual Leave").FirstOrDefault(); if (result2 != null) { casual = context.LeaveSet.Where(e => e.EmpId == mc.EmpId && e.Reason == "Sick Leave").Sum(a => a.Days); casual = 6 - casual; } var result3 = context.LeaveSet.Where(e => e.EmpId == mc.EmpId && e.Reason == "Sick Leave").FirstOrDefault(); if (result3 != null) { sick = context.LeaveSet.Where(e => e.EmpId == mc.EmpId && e.Reason == "Sick Leave").Sum(a => a.Days); sick = 30 - sick; } ViewBag.paid = paid; ViewBag.casual = casual; ViewBag.sick = sick; ViewBag.EmpId = EmpId; return(View()); }
public ActionResult Award() { MemberCookie mc = Getmember(); ViewBag.memberRole = mc.Role; return(View()); }
public ActionResult Message() { MemberCookie mc = Getmember(); ViewBag.Role = mc.Role; ViewBag.EmpId = mc.EmpId; return(View()); }
public MemberCookie Getmember() { MemberCookie mc = new MemberCookie(); if (Request.Cookies["hrCookie"] != null) { mc.MemberID = Convert.ToInt32(Request.Cookies["hrCookie"]["AdminID"]); mc.Role = Request.Cookies["hrCookie"]["Role"]; mc.EmpId = Convert.ToInt32(Request.Cookies["hrCookie"]["EmpId"]); } return(mc); }
public ActionResult Pay() { HumanResourceContext context = new HumanResourceContext(); MemberCookie mc = Getmember(); if (mc.Role == "Admin") { var result = context.SalaryCheckSet.ToList(); return(Json(new { data = result }, JsonRequestBehavior.AllowGet)); } else { var result = context.SalaryCheckSet.Where(e => e.EmpId == mc.EmpId).ToList(); return(Json(new { data = result }, JsonRequestBehavior.AllowGet)); } }
public ActionResult LeaveStaffList() { MemberCookie mc = Getmember(); HumanResourceContext context = new HumanResourceContext(); int[] total = new int[49]; var result = context.LeaveSet.Where(e => e.EmpId == mc.EmpId).GroupBy(x => new { x.EmpId }) .Select(g => new { Days = g.Sum(p => p.Days), Name = g.Select(b => b.Name).FirstOrDefault(), Department = g.Select(b => b.Department).FirstOrDefault(), Position = g.Select(b => b.Position).FirstOrDefault(), Remain = 49 - g.Sum(p => p.Days), Total = 49, EmpId = g.Select(b => b.EmpId).FirstOrDefault() }).ToList(); return(Json(new { data = result }, JsonRequestBehavior.AllowGet)); }