// GET: KPI_Dept/Create
public ActionResult Create()
{
eLeaveEntities eleave = new eLeaveEntities();
ViewBag.Dept_Name = new SelectList(eleave.v_eLeave_EmployeeDetails, "preDeptDesc", "preDeptDesc");
ViewBag.Dept_Mgr = new SelectList(eleave.v_eLeave_EmployeeDetails.OrderBy(x => x.empFullName), "empFullName", "empFullName");
return(View());
}
//GET :
public ActionResult GetDepartment()
{
var empno = Request.QueryString["empno"];
eLeaveEntities eLeave = new eLeaveEntities();
var data = eLeave.v_eLeave_EmployeeDetails.Where(m => m.empEmployeeNo == empno).ToList();
return(Content(data[0].preDeptDesc));
}
public ActionResult GetEmpName(string empNo)
{
eLeaveEntities eLeave = new eLeaveEntities();
var query = from x in eLeave.v_eLeave_EmployeeDetails
where x.empEmployeeNo == empNo
select x.empFullName;
var serialize = new JavaScriptSerializer();
var result = serialize.Serialize(query);
return(Content(result));
}
public ActionResult getEmpDetails()
{
var empEmail = Request.QueryString["empName"];
eLeaveEntities eleave = new eLeaveEntities();
var query = from x in eleave.v_eLeave_EmployeeDetails
where x.empFullName == empEmail
select x;
var serialize = new JavaScriptSerializer();
var result = serialize.Serialize(query);
return(Content(result));
}
public ActionResult getMgrDetail()
{
var mgrName = Request.QueryString["Dept_Mgr"];
eLeaveEntities eleave = new eLeaveEntities();
var queryEmail = from x in eleave.v_eLeave_EmployeeDetails
where x.empFullName == mgrName
select new { x.empEmail, x.empEmployeeNo };
var serialize = new JavaScriptSerializer();
var result = serialize.Serialize(queryEmail);
return(Content(result));
}
