public ActionResult MyRequests() { if (!CSessionManager.IsLoggedIn()) { return(RedirectToAction("Index")); } else { var usr = _functionCall.GetEmployeeInfo(CSessionManager.IWSessionID); var employee = new CEmployeeInfo(); foreach (DataRow rw in usr.Rows) { employee.EmpID = rw["EmpID"].ToString(); employee.Name = rw["Name"].ToString(); employee.Email = rw["Email1"].ToString(); employee.City = rw["City"].ToString(); employee.Country = rw["Country"].ToString(); employee.Birthday = rw["Birthday"].ToString(); employee.Gender = rw["Gender"].ToString(); employee.Nationality = rw["Nationality"].ToString(); employee.Title = rw["Title"].ToString(); employee.Phone = rw["Phone1"].ToString(); employee.State = rw["State"].ToString(); } var EmpID = employee.EmpID; ViewData["AnnualLeave"] = _data.AnnualLeaveTaken(GetCommandDataParam("ESS_004", CSessionManager.IWSessionID, EmpID)); ViewData["Type"] = _data.TimeOffType(GetCommandData("ESS_002", CSessionManager.IWSessionID)); return(View()); } }
public ActionResult MyRequests(VMRequestTO request) { if (!CSessionManager.IsLoggedIn()) { return(RedirectToAction("Index")); } try { ViewData["Type"] = _data.TimeOffType(GetCommandData("ESS_002", CSessionManager.IWSessionID)); if (!ModelState.IsValid) { return(View(request)); } if (request.EndDate < request.StartDate) { ViewBag.Error = "Start Date is less than Current date or End Date is less than StartDate"; return(View(request)); } var usr = _functionCall.GetEmployeeInfo(CSessionManager.IWSessionID); var employee = new CEmployeeInfo(); foreach (DataRow rw in usr.Rows) { employee.EmpID = rw["EmpID"].ToString(); employee.Name = rw["Name"].ToString(); employee.Email = rw["Email1"].ToString(); employee.City = rw["City"].ToString(); employee.Country = rw["Country"].ToString(); employee.Birthday = rw["Birthday"].ToString(); employee.Gender = rw["Gender"].ToString(); employee.Nationality = rw["Nationality"].ToString(); employee.Title = rw["Title"].ToString(); employee.Phone = rw["Phone1"].ToString(); employee.State = rw["State"].ToString(); } var EmpID = employee.EmpID; //var param = IWServices.CreateParameters("-1", CSessionManager.IWSessionID, EmpID, request.Type, Common.FormatEx.FormatDT(request.StartDate), Common.FormatEx.FormatDT(request.EndDate), "", "", "", "Pending", request.Comment, "", "0"); var param = IWServices.CreateParameters("-1", EmpID, request.Type, Common.FormatEx.FormatDT(request.StartDate), Common.FormatEx.FormatDT(request.EndDate), DateTime.Now.Year.ToString(), "", "", "Pending", request.Comment, "", "0"); var done = GetCommandDataParam("ESS_003", CSessionManager.IWSessionID, param); //if (!string.IsNullOrEmpty(done.ToString())) //{ // ViewBag.ErrorMessage = "Sorry your request cannot be processed at this time, please contact HR"; // return View("MyRequests"); //} return(RedirectToAction("History")); } catch (Exception ex) { ViewBag.Error = ex.Message; return(View("Error")); } }
public ActionResult Dashboard(VMLogin model) { if (!CSessionManager.IsLoggedIn()) { return(RedirectToAction("Index")); } var data = GetData("HRESSGetEmpInfo", CSessionManager.IWSessionID, CSessionManager.LoggedInUser.UserID); var info = new CEmployeeInfo(); foreach (DataRow row in data.Rows) { info.EmpID = Common.ConvertEx.ToString(row["EmpID"]); info.Name = Common.ConvertEx.ToString(row["Name"]); info.Title = Common.ConvertEx.ToString(row["Title"]); info.Gender = Common.ConvertEx.ToString(row["Gender"]); info.City = Common.ConvertEx.ToString(row["City"]); info.State = Common.ConvertEx.ToString(row["State"]); info.Country = Common.ConvertEx.ToString(row["Country"]); info.Email = Common.ConvertEx.ToString(row["Email1"]); info.Phone = Common.ConvertEx.ToString(row["Phone1"]); info.Birthday = Common.ConvertEx.ToDateTime(row["Birthday"]).ToString(Common.DateHelper.FMT_DT); info.Nationality = Common.ConvertEx.ToString(row["Nationality"]); } ; var lastLogonDate = GetCommandDataParam("ESS_006", CSessionManager.IWSessionID, info.EmpID); string LogDate = null; foreach (DataRow row in lastLogonDate.Rows) { LogDate = Common.ConvertEx.ToDateTime(row["LastLogonDate"]).ToString(Common.DateHelper.FMT_DT); } string TodayDate = Common.ConvertEx.ToDateTime(DateTime.Today.ToShortDateString()).ToString(Common.DateHelper.FMT_DT); if (LogDate == TodayDate) { ViewBag.Message = true; } else { ViewBag.Message = false; } return(View()); }
public ActionResult ViewCommittments(CEmployeePoints model) { if (!CSessionManager.IsLoggedIn()) { return(RedirectToAction("Index")); } try { var usr = _functionCall.GetEmployeeInfo(CSessionManager.IWSessionID); var employee = new CEmployeeInfo(); foreach (DataRow rw in usr.Rows) { employee.EmpID = rw["EmpID"].ToString(); } var EmpID = employee.EmpID; ViewBag.EmpID = EmpID; //ViewData["EmpID"] = EmpID; var GetUsr = GetCommandDataParam("P_00050", CSessionManager.IWSessionID, model.EmpID); var GetID = new CEmployeeID(); foreach (DataRow rw in GetUsr.Rows) { GetID.ID = rw["ID#"].ToString(); } var MyEmpID = GetID.ID; ViewBag.MyEmpID = MyEmpID; Session["MyEmpID"] = MyEmpID; //var Committments = GetCommandDataParam("P_00041", CSessionManager.IWSessionID, MyEmpID); ViewData["Committments"] = _data.Committment(GetCommandDataParam("P_00041", CSessionManager.IWSessionID, MyEmpID)); ViewBag.Commitments = GetCommandDataParam("P_00041", CSessionManager.IWSessionID, MyEmpID); ViewBag.EmployeeGP = _functionCall.GetEmployeeGP(CSessionManager.IWSessionID, MyEmpID, model.StartDate, model.EndDate); ViewBag.EmployeeCGPA = _functionCall.GetEmployeeCGPA(CSessionManager.IWSessionID, MyEmpID); //var param = IWServices.CreateParameters(EmpID); ViewData["Surbodinates"] = _data.GetSurbordinates(GetCommandDataParam("ESS_005", CSessionManager.IWSessionID, EmpID)); } catch (Exception ex) { ViewBag.Error = ex.Message; return(View("Error")); } return(View(model)); }
public ActionResult ViewCommittments() { if (!CSessionManager.IsLoggedIn()) { return(RedirectToAction("Index")); } CEmployeePoints model = new CEmployeePoints(); try { var usr = _functionCall.GetEmployeeInfo(CSessionManager.IWSessionID); var employee = new CEmployeeInfo(); foreach (DataRow rw in usr.Rows) { employee.EmpID = rw["EmpID"].ToString(); } var EmpID = employee.EmpID; var GetUsr = GetCommandDataParam("P_00050", CSessionManager.IWSessionID, EmpID); var GetID = new CEmployeeID(); foreach (DataRow rw in GetUsr.Rows) { GetID.ID = rw["ID#"].ToString(); } var MyEmpID = GetID.ID; ViewBag.MyEmpID = MyEmpID; Session["MyEmpID"] = MyEmpID; string AppraisalPeriodStartDate = ""; string AppraisalPeriodEndDate = ""; ViewBag.Commitments = GetCommandDataParam("P_00041", CSessionManager.IWSessionID, MyEmpID); ViewBag.EmployeeGP = _functionCall.GetEmployeeGP(CSessionManager.IWSessionID, MyEmpID, AppraisalPeriodStartDate, AppraisalPeriodEndDate); ViewBag.EmployeeCGPA = _functionCall.GetEmployeeCGPA(CSessionManager.IWSessionID, MyEmpID); ViewData["Surbodinates"] = _data.GetSurbordinates(GetCommandDataParam("ESS_005", CSessionManager.IWSessionID, EmpID)); model.StartDate = string.Format("{0}-01-01", DateTime.Today.Year); model.EndDate = string.Format("{0}-12-31", DateTime.Today.Year); } catch (Exception ex) { ViewBag.Error = ex.Message; return(View("Error")); } return(View(model)); }
public ActionResult PayStubList() { if (!CSessionManager.IsLoggedIn()) { return(RedirectToAction("Index")); } try { var data = GetData("HRESSGetEmpInfo", CSessionManager.IWSessionID, CSessionManager.LoggedInUser.UserID); //var empID = _data.EmployeeInfo(GetData("HRESSGetEmpInfo", CSessionManager.IWSessionID, CSessionManager.LoggedInUser.UserID)) var info = new CEmployeeInfo(); foreach (DataRow row in data.Rows) { info.EmpID = Common.ConvertEx.ToString(row["EmpID"]); info.Name = Common.ConvertEx.ToString(row["Name"]); info.Title = Common.ConvertEx.ToString(row["Title"]); info.Gender = Common.ConvertEx.ToString(row["Gender"]); info.City = Common.ConvertEx.ToString(row["City"]); info.State = Common.ConvertEx.ToString(row["State"]); info.Country = Common.ConvertEx.ToString(row["Country"]); info.Email = Common.ConvertEx.ToString(row["Email1"]); info.Phone = Common.ConvertEx.ToString(row["Phone1"]); info.Birthday = Common.ConvertEx.ToDateTime(row["Birthday"]).ToString(Common.DateHelper.FMT_DT); info.Nationality = Common.ConvertEx.ToString(row["Nationality"]); } ; ViewBag.EmpID = info.EmpID; ViewData["Info"] = _data.SalaryDetails(GetData("HRESSGetPayStubList", CSessionManager.IWSessionID, (string)Session["EmpID"])); return(View()); } catch (Exception ex) { ViewBag.Error = ex.Message; return(View("Error")); } }
public ActionResult ViewAppraisals(string empID) { if (!CSessionManager.IsLoggedIn()) { return(RedirectToAction("Index")); } try { var usr = _functionCall.GetEmployeeInfo(CSessionManager.IWSessionID); var employee = new CEmployeeInfo(); foreach (DataRow rw in usr.Rows) { employee.EmpID = rw["EmpID"].ToString(); } var EmpID = employee.EmpID; var GetUsr = GetCommandDataParam("P_00050", CSessionManager.IWSessionID, empID); var GetID = new CEmployeeID(); foreach (DataRow rw in GetUsr.Rows) { GetID.ID = rw["ID#"].ToString(); } var MyEmpID = GetID.ID; ViewData["Appraisals"] = _data.Appraisals(GetCommandDataParam("P_00055", CSessionManager.IWSessionID, MyEmpID)); ViewData["Surbodinates"] = _data.GetSurbordinates(GetCommandDataParam("ESS_005", CSessionManager.IWSessionID, EmpID)); } catch (Exception ex) { ViewBag.Error = ex.Message; return(View("Error")); } return(View()); }