public ActionResult CommitIncident(incitingIncident ii)
{
int uniqueKey = 0;
List <incitingIncident> _list = TableUtils.queryToTable <incitingIncident>("SELECT * FROM shooters.IncitingIncident");
Boolean uniqueI = false;
while (uniqueI != true)
{
uniqueI = true;
uniqueKey++;
for (int k = 0; k < (_list.Count); k++)
{
if (uniqueKey == _list[k].iKey)
{
uniqueI = false;
}
}
}
ii.iKey = uniqueKey;
NpgsqlConnection connection = new NpgsqlConnection(RouteConfig.connectString);
connection.Open();
NpgsqlCommand command = new NpgsqlCommand("Insert Into shooters.IncitingIncident (First, Last, iDate, iDescription, iKey) values('" + ii.first + "','" + ii.last + "','" + ii.iDate + "', @iDescription,'" + ii.iKey + "')", connection);
command.Parameters.AddWithValue("@iDescription", ii.iDescription);
int num = command.ExecuteNonQuery();
connection.Close();
if (num > 0)
{
ViewBag.Message = "Query Succesful : " + num + " rows created";
}
else
{
ViewBag.Message = "Query Unsucessful: ";
}
return(RedirectToAction("EditShooter", new { first = ii.first, last = ii.last }));
}
public ActionResult CommitIncidentEdit(incitingIncident ii)
{
// string connstring = "Server=" + RouteConfig.ip + "; Port=5432; User Id=postgres; Password=Pixies2019; Database=postgres;";
NpgsqlConnection connection = new NpgsqlConnection(RouteConfig.connectString);
connection.Open();
NpgsqlCommand command = new NpgsqlCommand("Update shooters.incitingIncident set iDate = '" + ii.iDate + "', iDescription = @iDescription where iKey = '" + ii.iKey + "'", connection);
command.Parameters.AddWithValue("@iDescription", ii.iDescription);
int num = command.ExecuteNonQuery();
connection.Close();
if (num > 0)
{
ViewBag.Message = "Query Succesful : " + num + " rows modified";
}
else
{
ViewBag.Message = "Query Unsucessful";
}
return(RedirectToAction("EditShooter", new { first = ii.first, last = ii.last }));
}
