public void cancelBooking(string id)
        {
            var info = context.bookinginfoes.Where(x => x.id.ToString() == id).First();

            info.status = "cancelled";
            context.SaveChanges();
        }
        public void deleteMyTravelPlace(string id)
        {
            int placeid = Int32.Parse(id);
            var place   = context.travelplaces.Where(x => x.id == placeid).First();

            context.travelplaces.Remove(place);
            context.SaveChanges();
        }
        public void deleteHotelinfo(string email)
        {
            var count = context.hotelinfoes.Where(x => x.hotelempmail == email).ToList();

            if (count.Count > 0)
            {
                var info = context.hotelinfoes.Where(x => x.hotelempmail == email).First();

                context.hotelinfoes.Remove(info);

                context.SaveChanges();
            }
        }
        public void createNewUser(string[] info)
        {
            userinfo newuserinfo = new userinfo
            {
                usermail  = info[0],
                firstname = info[1],
                lastname  = info[2],
                address   = info[3],
                phoneno   = info[4],
                password  = info[5],
                usertype  = info[6]
            };

            context.userinfoes.Add(newuserinfo);
            user newuser = new user
            {
                usermail = info[0],
                password = info[5],
                usertype = info[6]
            };

            context.users.Add(newuser);

            context.SaveChanges();
        }
        public void addCustCareSalary(string email, string salary)
        {
            customercaresalary custSalary = new customercaresalary
            {
                custcaremail  = email,
                currentsalary = salary
            };

            context.customercaresalaries.Add(custSalary);
            context.SaveChanges();
        }