示例#1
0
        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);
 }