public async Task <JsonResult> ListAllAppointments()
{
var uniqueName = HttpContext.User.Claims.First(claim => claim.Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name").Value;
SourceDataTablesFormat dataTablesSource = new SourceDataTablesFormat();
try
{
var existentAppointments = await Util.ConnectToRemoteService <List <AppointmentViewModel> >(HttpMethod.Get, Util.KanbanURL + "api/appointment/list", uniqueName, "");
foreach (AppointmentViewModel a in existentAppointments)
{
IList <string> dataRow = new List <string>();
dataRow.Add(a._WorkloadTitle.ToString());
dataRow.Add(a._AppointmentDate.ToString("dd/MM/yyyy"));
dataRow.Add(a._AppointmentHoursDispensed.ToString());
dataRow.Add(Util.GetUserAlias(a._AppointmentUserUniqueName.ToString()));
dataRow.Add($"<div class='data-sorting-buttons'><a href='/appointment/details/{a._AppointmentID}' class='ds-button-detail'><i class='fa fa-align-justify' aria-hidden='true'></i> Details</a></div> <div class='data-sorting-buttons'><a href='/appointment/edit/{a._AppointmentID}' class='ds-button-edit'><i class='fa fa-pencil-square-o' aria-hidden='true'></i> Edit</a></div> <div class='data-sorting-buttons'><a href='#' onclick=\"detailsWorkloadState(); HideAllButtons(); loadWorkload('{a._AppointmentWorkloadWBID}');\" data-toggle='modal' data-target='#WorkloadModal' class='ds-button-workload'><i class='fa fa-tasks' aria-hidden='true'></i> Workload</a></div> <div class='data-sorting-buttons'><a data-toggle='modal' data-target='#generic-modal' onclick=\"ModalDelete_Appointment('{a._AppointmentID}','{a._WorkloadTitle}','{a._AppointmentDate.ToString("dd/MM/yyyy")}','{a._AppointmentHoursDispensed}','{a._AppointmentUserUniqueName}');\" class='ds-button-delete'><i class='fa fa-trash' aria-hidden='true'></i> Delete</a></div>");
dataTablesSource.aaData.Add(dataRow);
}
}
catch (Exception)
{
throw;
}
return(Json(dataTablesSource));
}
public async Task <JsonResult> ListPendingUsers()
{
var uniqueName = User.Claims.First(claim => claim.Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name").Value;
SourceDataTablesFormat dataTablesSource = new SourceDataTablesFormat();
try
{
var users = await Util.ConnectToRemoteService <List <UserMainViewModel> >(HttpMethod.Get, Util.PermissionsURL + "api/useroperations/getpendingusers", uniqueName, "");
// Mouting rows data
foreach (UserMainViewModel user in users)
{
IList <string> dataRow = new List <string>();
dataRow.Add(user.Name.ToString());
dataRow.Add(user.Email.ToString());
dataRow.Add($"<div class=\"data-sorting-buttons\"><a onclick=\"ModalSelectUser('{user.Email}','{user.Name}');\" class=\"ds-button-detail\"><i class=\"fa fa-align-justify\" aria-hidden=\"true\"></i>Details</a></div>");
dataTablesSource.aaData.Add(dataRow);
}
}
catch (Exception)
{
throw;
}
return(Json(dataTablesSource));
}
public async Task <JsonResult> ListAllMetrics()
{
var uniqueName = HttpContext.User.Claims.First(claim => claim.Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name").Value;
SourceDataTablesFormat dataTablesSource = new SourceDataTablesFormat();
try
{
var existentMetrics = await Util.ConnectToRemoteService <List <MetricViewModel> >(HttpMethod.Get, Util.KanbanURL + "api/metric/list", uniqueName, "");
foreach (MetricViewModel m in existentMetrics)
{
IList <string> dataRow = new List <string>();
dataRow.Add(m.TextualFiscalYear.ToString());
dataRow.Add(m.MetricCategory.ToString());
dataRow.Add(m.MetricName.ToString());
dataRow.Add($"<div class='data-sorting-buttons'><a href='/metric/details/{m.MetricID}' class='ds-button-detail'><i class='fa fa-align-justify' aria-hidden='true'></i> Details</a></div> <div class='data-sorting-buttons'><a href='/metric/edit/{m.MetricID}' class='ds-button-edit'><i class='fa fa-pencil-square-o' aria-hidden='true'></i> Edit</a></div> <div class='data-sorting-buttons'><a data-toggle='modal' data-target='#generic-modal' onclick=\"ModalDelete_Metric('{m.MetricID}','{m.MetricCategory}','{m.MetricName}');\" class='ds-button-delete'><i class='fa fa-trash' aria-hidden='true'></i> Delete</a></div>");
dataTablesSource.aaData.Add(dataRow);
}
}
catch (Exception)
{
throw;
}
return(Json(dataTablesSource));
}
public async Task <JsonResult> ListAllUsers()
{
// Getting uniqueName
var uniqueName = HttpContext.User.Claims.First(claim => claim.Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name").Value;
// Creating the final expected object to datatable
SourceDataTablesFormat dataTablesSource = new SourceDataTablesFormat();
try
{
// Getting the response of remote service
var existentUsers = await Util.ConnectToRemoteService <List <UserMainViewModel> >(HttpMethod.Get, Util.PermissionsURL + "api/useroperations/getusers", uniqueName, "");
// Mouting rows data
foreach (UserMainViewModel user in existentUsers)
{
IList <string> dataRow = new List <string>();
dataRow.Add(user.Name.ToString());
dataRow.Add(user.Email.ToString());
dataRow.Add(getUserSituation(user.Status));
dataRow.Add($"<div class='data-sorting-buttons'><a href='/users/details?userID={user.Email}' class='ds-button-detail'><i class='fa fa-align-justify' aria-hidden='true'></i>Details</div></a><div class='data-sorting-buttons'><a href='/users/edit?userID={user.Email}' class='ds-button-edit'><i class='fa fa-pencil-square-o' aria-hidden='true'></i>Edit</a></div><div class='data-sorting-buttons'><a data-toggle='modal' data-target='#DeleteUserModal' onclick=\"ModalDeleteUser('{user.Email}','{user.Name}');\" class='ds-button-delete'><i class='fa fa-trash' aria-hidden='true'></i>Delete</a></div>");
dataTablesSource.aaData.Add(dataRow);
}
}
catch (Exception)
{
throw;
}
return(Json(dataTablesSource));
}
// List all fiscal years in database.
public JsonResult ListAllFiscalYears()
{
// Getting uniqueName
var uniqueName = HttpContext.User.Claims.First(claim => claim.Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name").Value;
// Creating the final expected object to datatable
SourceDataTablesFormat dataTablesSource = new SourceDataTablesFormat();
try
{
// Getting the response of remote service
var existentFiscalYears = Util.ConnectToRemoteService <List <FiscalYearViewModel> >(HttpMethod.Get, Util.KanbanURL + "api/fiscalyear/list", uniqueName, "").Result;
// Mouting rows data
foreach (FiscalYearViewModel fy in existentFiscalYears)
{
IList <string> dataRow = new List <string>();
dataRow.Add(fy.TextualFiscalYearMain.ToString());
dataRow.Add(fy.FullNumericFiscalYearMain.ToString());
dataRow.Add($"<div class='data-sorting-buttons'><a href='/fiscalyear/details/{fy.FiscalYearID}' class='ds-button-detail'><i class='fa fa-align-justify' aria-hidden='true'></i>Details</a></div><div class='data-sorting-buttons'><a href='/fiscalyear/edit/{fy.FiscalYearID}' class='ds-button-edit'><i class='fa fa-pencil-square-o' aria-hidden='true'></i>Edit</a></div><div class='data-sorting-buttons'><a href='javascript:void()' data-toggle='modal' data-target='#generic-modal' onclick=\"ModalDelete_FiscalYear('{fy.FiscalYearID}','{fy.TextualFiscalYearMain}');\" class='ds-button-delete'><i class='fa fa-trash' aria-hidden='true'></i>Delete</a></div>");
dataTablesSource.aaData.Add(dataRow);
}
}
catch (Exception)
{
throw;
}
return(Json(dataTablesSource));
}
