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