public int CreateBooking(DateTime BookingDate, DateTime ExpiryDate) { SqlConnection conn = cc.GetConnection(); using (conn) { SqlCommand cmd = new SqlCommand("sp_CreateBooking", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BookingDate", BookingDate); cmd.Parameters.AddWithValue("@ExpiryDate", ExpiryDate); cmd.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); int iID = Convert.ToInt32(cmd.Parameters["@ID"].Value); conn.Close(); return(iID); } }