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