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