public async Task <IActionResult> Index()
{
try
{
IEnumerable <LeaveRequest> leaveRequests = (await leaveRequestService.GetLeaveRequests()).Select(lvlRequst =>
{
lvlRequst.LeveRequestEncryptedId = protector.Protect(lvlRequst.Id.ToString());
return(lvlRequst);
});
var leaveTypes = await leaveTypeService.GetLeaveTypes();
var employees = await employeeService.GetEmployees();
LeaveRequestListViewModel model = new LeaveRequestListViewModel
{
Employees = employees,
LeaveTypes = leaveTypes,
LeaveRequests = leaveRequests
};
return(View(model));
}
catch (Exception ex)
{
ViewBag.ErrorTitle = "Resource not available:";
ViewBag.ErrorMessage = ex.Message;
return(View("CustomError"));
}
}
public ActionResult LeaveRuleAdd()
{
var leaveTypes = _leaveTypeService.GetLeaveTypes().ToList();
LeaveRuleAddViewModel lrVM = new LeaveRuleAddViewModel();
lrVM.Params = leaveTypes;
return(View(lrVM));
}
public ActionResult LeaveType()
{
if (!ViewBag.AllowView)
{
ViewBag.Error = "You are not Authorize to use this Page";
return(PartialView("_partialviewNotFound"));
}
var leaveTypeList = _leaveTypeService.GetLeaveTypes();
return(View(leaveTypeList));
}
public async Task <IActionResult> Index()
{
IEnumerable <LeaveType> leaveTypes = (await leaveTypeService.GetLeaveTypes()).Select(lvlType =>
{
lvlType.LeaveTypeEncryptedId = protector.Protect(lvlType.Id.ToString());
return(lvlType);
});
return(View(leaveTypes));
}
public DataTable AttendanceMonthlySummary(DateTime sdate, DateTime enddate, int office)
{
try
{
SqlConnection conn = DbConnectHelper.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_AttendanceTotalDaysReportsSummary", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@startdate", sdate);
cmd.Parameters.AddWithValue("@endate", enddate);
cmd.Parameters.AddWithValue("@officeId", office);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
SqlCommand cmd1 = new SqlCommand("sp_AttendanceLeaveReports", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@StartDate", sdate);
cmd1.Parameters.AddWithValue("@EndDate", enddate);
cmd1.Parameters.AddWithValue("@officeId", office);
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
IEnumerable <LeaveTypeDTO> ltd = _leave.GetLeaveTypes();
foreach (var row in ltd)
{
dt.Columns.Add(row.LeaveTypeName);
}
int x = dt1.Rows.Count;
string[] array = new string[x];
int i = 0;
foreach (var row in ltd)
{
foreach (DataRow item in dt1.Rows)
{
array[i] = item[row.LeaveTypeName].ToString();
i++;
}
i = 0;
foreach (DataRow item in dt.Rows)
{
if (string.IsNullOrEmpty(array[i]))
{
array[i] = 0.ToString();
}
item[row.LeaveTypeName] = array[i];
i++;
}
i = 0;
}
da.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
return(dt);
}
catch (Exception Mg)
{
return(null);
}
}
