public void insertNoOfInvigilatorsReq(TimeslotVenue timeslotVenue) { try { /*Step 2: Create Sql Insert statement and Sql Insert Object*/ strInsert = "Insert Into InvigilationDuty (VenueID, TimeslotID, NoOfInvigilators Values (@VenueID, @TimeslotID, @NoOfInvigilators)"; cmdInsert = new SqlCommand(strInsert, conn); cmdInsert.Parameters.AddWithValue("@TimeslotID", timeslotVenue.TimeslotID); cmdInsert.Parameters.AddWithValue("@VenueID", timeslotVenue.VenueID); cmdInsert.Parameters.AddWithValue("@Location", timeslotVenue.NoOfInvigilatorRequired); cmdInsert.ExecuteNonQuery(); } catch (SqlException) { throw; } }
public void insertNoOfInvigilatorRequired(TimeslotVenue timeslotVenue) { timeslotVenueDA.insertNoOfInvigilatorsReq(timeslotVenue); }