public List <IncidentHistoryModel> GetIncidents(MySqlCommand getUserData, bool prepare = true)
{
List <IncidentHistoryModel> modelList = new List <IncidentHistoryModel>();
MySqlConnection conn = GetSqlConnection();
{
getUserData.Connection = conn;
try
{
conn.Open();
if (prepare == true)
{
getUserData.Prepare();
}
var executeString = getUserData.ExecuteReader();
while (executeString.Read())
{
IncidentHistoryModel incidentHistoryModel = new IncidentHistoryModel();
incidentHistoryModel.IncidentID = executeString.GetInt32(0);
incidentHistoryModel.Location = executeString.GetString(1);
incidentHistoryModel.Description = executeString.GetString(4);
incidentHistoryModel.currentStatus = (IncidentHistoryModel.CurrentStatus)executeString.GetInt32(6);
incidentHistoryModel.Email = executeString.GetString(8);
modelList.Add(incidentHistoryModel);
}
conn.Close();
}
catch (Exception e)
{
Console.WriteLine("error: " + e.Message);
}
}
return(modelList);
}
public IActionResult EditAction(IncidentHistoryModel incidentHistory)
{
if (incidentHistory.currentStatus == IncidentHistoryModel.CurrentStatus.Gerepareerd)
{
MySqlCommand UpdateStatus = new MySqlCommand("UPDATE `alert` SET `description`= @val1,`status_id`= @val2,`solvedate`= @val3 WHERE `id` = @val4");
UpdateStatus.Parameters.AddWithValue("@val1", incidentHistory.Description);
UpdateStatus.Parameters.AddWithValue("@val2", (int)incidentHistory.currentStatus);
UpdateStatus.Parameters.AddWithValue("@val3", DateTime.Now);
UpdateStatus.Parameters.AddWithValue("@val4", incidentHistory.IncidentID);
_context.UpdateStatus(UpdateStatus, true);
}
else
{
MySqlCommand UpdateStatus = new MySqlCommand("UPDATE `alert` SET `description`= @val1,`status_id`= @val2 WHERE `id` = @val4");
UpdateStatus.Parameters.AddWithValue("@val1", incidentHistory.Description);
UpdateStatus.Parameters.AddWithValue("@val2", (int)incidentHistory.currentStatus);
UpdateStatus.Parameters.AddWithValue("@val4", incidentHistory.IncidentID);
_context.UpdateStatus(UpdateStatus, true);
}
return(RedirectToAction("Index"));
}
