public void AddV(Violations c)
{
OleDbConnection con = new OleDbConnection(Connstring);
OleDbCommand cmd = con.CreateCommand();
con.Open();
cmd.CommandText = "INSERT INTO Violationlog(Description, violationID, v_date, resolved, dept_id, rating) VALUES(@Description, @violationID, @v_date, @resolved, @dept_id, @rating)";
cmd.Connection = con;
cmd.Parameters.AddWithValue("@Description", c.Description);
cmd.Parameters.AddWithValue("@violationID", c.ViolationID);
cmd.Parameters.AddWithValue("@v_date", c.Vdate);
cmd.Parameters.AddWithValue("@resolved", c.Resolved);
cmd.Parameters.AddWithValue("@dept_id", c.DeptID);
cmd.Parameters.AddWithValue("@rating", c.Rating);
cmd.ExecuteNonQuery();
con.Close();
}