public static void saveAssignment(newAssignmentViewModel Assignment)
{
using (NpgsqlConnection connection = new NpgsqlConnection("Server=localhost;Port=5432;User Id=postgres;Password=nikola000;Database=BugTrackerDB;"))
{
connection.Open();
connection.Query <string>("INSERT INTO \"Rok\" VALUES(" + Assignment.zadatakID + ",'" + Assignment.rokDo + "')");
connection.Query <string>("UPDATE \"Listić\" SET \"statusID\"=" + 3 + "WHERE \"listićID\"=" + Assignment.zadatakID);
string query = @"INSERT INTO ""Zadatak"" VALUES(" + Assignment.zadatakID + "," + Assignment.timID + "," + Assignment.zadatakID + ",'" + Assignment.zadatakOpis + "'," + DapperORM.getUserID(Assignment.username) + ",'" + Assignment.zadatakIme + "'," + Assignment.zadatakID + ")";
connection.Query <string>(query);
};
}
public ActionResult assignTicketToTeam(newAssignmentViewModel assignment)
{
assignment.username = DapperORM.getUsername();
assignment.zadatakID = currentID;
if (assignment.zadatakIme == null || assignment.rokDo == null)
{
assignTicketToTeam(currentID);
}
DapperORM.saveAssignment(assignment);
return(RedirectToAction("addAssignments", "Assignments"));
}
