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