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