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