public static string GenerateRegID()
        {
            var             id  = "";
            EasyTicketsData _db = new EasyTicketsData();

            System.Text.StringBuilder builder = new StringBuilder();
            builder.Append(RandomNumber(1000, 9999));
            id = "ET" + builder.ToString();
            var regGen = _db.Registrations.Where(x => x.RegistrtationID == id).FirstOrDefault();

            if (regGen != null)
            {
                builder.Append(RandomNumber(10000, 99999));
                id = "ET" + builder.ToString();
            }
            return(id);
        }
        public static string GenerateBookingNumber()
        {
            var             id  = "";
            EasyTicketsData _db = new EasyTicketsData();

            System.Text.StringBuilder builder = new StringBuilder();
            builder.Append(RandomNumber(1000, 9999));
            id = "TEM" + builder.ToString();
            var bookingNum = _db.BookedTickets.Where(x => x.TicketID == id).FirstOrDefault();

            if (bookingNum != null)
            {
                builder.Append(RandomNumber(10000, 99999));
                id = "TEM" + builder.ToString();
            }
            return(id);
        }