public IHttpActionResult Add([FromBody] DashboardModels.Add dashboard)
{
string logForm = "Form : " + Startup._jsSerializer.Serialize(dashboard);
string logAPI = "[Post] " + Request.RequestUri.ToString();
if (!ModelState.IsValid || dashboard == null)
{
Startup._sfAppLogger.Warn(logAPI + " || Input Parameter not expected || " + logForm);
return(BadRequest("Invalid data"));
}
try
{
DashboardModels dashboardModel = new DashboardModels();
int newDashboardId = dashboardModel.addDashboard(dashboard);
return(Json(new { id = newDashboardId }));
}
catch (Exception ex)
{
StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
logMessage.AppendLine(logForm);
Startup._sfAppLogger.Error(logAPI + logMessage);
return(InternalServerError(ex));
}
}
public IHttpActionResult Delete(int id)
{
try
{
DashboardModels dashboardModel = new DashboardModels();
dashboardModel.deleteDashboard(id);
return(Ok("Success"));
}
catch (Exception ex)
{
string logAPI = "[Delete] " + Request.RequestUri.ToString();
StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
Startup._sfAppLogger.Error(logAPI + logMessage);
return(InternalServerError());
}
}
public DashboardModels DashboardStats()
{
DashboardModels _DashboardModels = new DashboardModels();
using (SqlConnection conn = new SqlConnection(DBCon))
{
conn.Open();
SqlCommand cmd = new SqlCommand("DashboardStats", conn);//call Stored Procedure
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
_DashboardModels.UsersList = reader["UsersList"].ToString();
_DashboardModels.ActiveUsers = reader["ActiveUsers"].ToString();
_DashboardModels.InActiveUsers = reader["InActiveUsers"].ToString();
_DashboardModels.ArchivedUsers = reader["ArchivedUsers"].ToString();
}
return(_DashboardModels);
}
}