public static bool UpdateReportState(int report_uid, int state)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
SqlCommand cmd1 = new SqlCommand("usp_update_report_state", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@report_uid", report_uid);
cmd1.Parameters.AddWithValue("@new_state", state);
cmd1.ExecuteNonQuery();
}
catch (System.Exception)
{
return false;
}
}
return true;
}