public void Air_GroupBookingStatusUpdate(GroupBookingReportModel model)
        {
            Air_GroupBooking result = ent.Air_GroupBooking.Where(x => x.GroupBookingId == model.GroupBookingId).FirstOrDefault();

            result.GroupBookingStatusId = model.StatusId;

            ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
            ent.SaveChanges();
        }
        public GroupBookingReportModel GetGroupBookingDetail(int id)
        {
            Air_GroupBooking        result = ent.Air_GroupBooking.Where(x => x.GroupBookingId == id).FirstOrDefault();
            GroupBookingReportModel model  = new GroupBookingReportModel();

            model.GroupBookingId = (int)result.GroupBookingId;
            model.GroupName      = result.GroupName;
            model.CompanyName    = result.CompanyName;
            model.ContactName    = result.ContactName;
            model.MobilePhone    = result.MobileNo;
            model.ContactPhone   = result.PhoneNo;
            model.AddressLine1   = result.Address1;
            model.AddressLine2   = result.Address2;
            model.SuburbTownCity = result.City;
            model.PostCode       = result.Postcode;
            model.State          = result.StateName;
            model.CountryId      = result.CountryId;
            model.GroupTypeId    = result.GroupTypeId;
            //model.ExcessBaggage    = result.isExxessBaggageRequest;
            model.rdbExcessBaggage = result.isExxessBaggageRequest == true ? Baggage.Yes : Baggage.No;
            model.Comments         = result.Comments;

            return(model);
        }
        public ActionResult Detail(int id)
        {
            Air_GroupBooking bookingmodel = ser.GetGroupBookingInfo(id);
            //Air_GroupBookingItinerary Itinerarymodel = ser.GetGroupBookingItineraryInfo(id);
            GroupBookingReportModel model = new GroupBookingReportModel();



            model.GroupName      = bookingmodel.GroupName;
            model.CompanyName    = bookingmodel.CompanyName;
            model.ContactName    = bookingmodel.ContactName;
            model.MobilePhone    = bookingmodel.MobileNo;
            model.ContactPhone   = bookingmodel.PhoneNo;
            model.AddressLine1   = bookingmodel.Address1;
            model.AddressLine2   = bookingmodel.Address2;
            model.SuburbTownCity = bookingmodel.City;
            model.PostCode       = bookingmodel.Postcode;
            model.State          = bookingmodel.StateName;
            model.StatusId       = (int)bookingmodel.GroupBookingStatusId;
            // model.CountryName = bookingmodel.Countries.CountryName == "" ? "" : bookingmodel.Countries.CountryName;
            if (model.CountryName == null)
            {
                model.CountryName = "";
            }
            else
            {
                model.CountryName = bookingmodel.Countries.CountryName;
            }

            // model.GroupTypeName = bookingmodel.Air_GroupTypes.GroupName;

            if (model.GroupTypeName == null)
            {
                model.GroupTypeName = "";
            }
            else
            {
                model.GroupTypeName = bookingmodel.Air_GroupTypes.GroupName;
            }

            model.isExcessBaggage = bookingmodel.isExxessBaggageRequest;

            if (model.Comments == null)
            {
                model.Comments = "";
            }
            else
            {
                model.Comments = bookingmodel.Comments;
            }


            ViewData["GroupBookingStatus"] = new SelectList(ser.GetGroupBookingStatusList(), "GroupBookingStatusId", "StatusName");

            model.GroupBookingCommtList = ser.GetGroupBookingCommtList(id);

            model.GroupBookingList = ser.GetGroupBookingItineraryListById(id).ToPagedList(1, int.MaxValue);

            string        FromCityName = "";
            List <string> CityNameList = new List <string>();

            foreach (var item in model.GroupBookingList)
            {
                FromCityName = item.FromCityName;
                CityNameList.Add(FromCityName);
            }
            ViewData["FromCityName"] = CityNameList;

            string        ToCityName     = "";
            List <string> ToCityNameList = new List <string>();

            foreach (var item in model.GroupBookingList)
            {
                ToCityName = item.ToCityName;
                ToCityNameList.Add(ToCityName);
            }
            ViewData["ToCityName"] = ToCityNameList;

            string        DepartureDate     = "";
            List <string> DepartureDateList = new List <string>();

            foreach (var item in model.GroupBookingList)
            {
                DepartureDate = item.DepartDate.ToString();
                DepartureDateList.Add(DepartureDate);
            }
            ViewData["DepartureDate"] = DepartureDateList;

            int        AdultId   = 0;
            List <int> AdultList = new List <int>();

            foreach (var item in model.GroupBookingList)
            {
                AdultId = item.AdultsId;
                AdultList.Add(AdultId);
            }
            ViewData["AdultNo"] = AdultList;

            int        ChildrenNo   = 0;
            List <int> ChildrenList = new List <int>();

            foreach (var item in model.GroupBookingList)
            {
                ChildrenNo = item.ChildrenId;
                ChildrenList.Add(ChildrenNo);
            }
            ViewData["ChildNo"] = ChildrenList;

            int        InfantNo   = 0;
            List <int> InfantList = new List <int>();

            foreach (var item in model.GroupBookingList)
            {
                InfantNo = item.InfantsId;
                InfantList.Add(InfantNo);
            }
            ViewData["InfantNo"] = new SelectList(InfantList);

            string        CabinClass     = "";
            List <string> CabinClassList = new List <string>();

            foreach (var item in model.GroupBookingList)
            {
                CabinClass = item.CabinClass;
                CabinClassList.Add(CabinClass);
            }
            ViewData["CabinClass"] = CabinClassList;

            model.GroupBookingId = id;

            return(View(model));
        }