public IHttpActionResult removeComplete(rmTask r) { try { DataManager.removeComplete(r); return(Ok()); } catch (Exception) { return(InternalServerError()); } }
public static void removeComplete(rmTask r) { string query = "removeComplete"; using (MySqlConnection conn = new MySqlConnection(CONN_STRING)) { using (MySqlCommand cmd = new MySqlCommand(query, conn)) { cmd.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter(cmd); cmd.Parameters.AddWithValue("id", r.id); cmd.Parameters.AddWithValue("tsid", r.tsid);; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } }