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