private async void GetTravelsRequest() { try { List <Travel> travelList = new List <Travel>(); TravelModel model = await App.Client.GetTravels(); if (model.status == "true") { for (int i = 0; i < model.feeds.Count; i++) { var travel = new Travel() { id = model.feeds[i].id, active = model.feeds[i].active, gezi = model.feeds[i].gezi, image = model.filebase + model.feeds[i].image, pdf = model.feeds[i].pdf, priority = model.feeds[i].priority, shareLink = model.feeds[i].shareLink }; travelList.Add(travel); } travelListView.ItemsSource = travelList; } } catch (Exception) { } }
public List <TravelModel> EntitytoModel(List <Travel> entities) { List <TravelModel> models = new List <TravelModel>(); foreach (var entity in entities) { TravelModel model = new TravelModel(); model.Company = new CompanyModel(); model.DepartureDate = new DepartureDateModel(); model.ArrivalDate = new ArrivalDate(); model.objectId = entity.ObjectId; model.Company.Name = entity.Company; model.Origin = entity.Origin; model.Destination = entity.Destination; model.DepartureDate.iso = entity.DepartureDate; model.ArrivalDate.iso = entity.ArrivalDate; model.BusClass = entity.BussClass; model.createdAt = entity.CreatedAt; model.updatedAt = entity.UpdatedAt; model.Price = entity.Price; models.Add(model); } return(models); }
public ActionResult EditTravel(TravelModel travelModel) { try { if (!ModelState.IsValid) { return(View()); } travelProcessor.Edit(travelModel, travelModel.Id); return(RedirectToAction("Index")); } catch (Exception ex) { ModelState.AddModelError("", "Error al editar el viaje - " + ex.Message); return(View()); } }
public ActionResult CreateTravel(TravelModel travelModel) { if (!ModelState.IsValid) { return(View()); } try { travelModel.AgencyID = 1; travelProcessor.Create(travelModel); return(RedirectToAction("Index")); } catch (Exception ex) { ModelState.AddModelError("", "Error al agregar el viaje - " + ex.Message); return(View()); } }
public ActionResult EditTravel(int Id) { ViewBag.Message = "Edición del viaje seleccionado"; Object travelObjectDB = travelProcessor.GetModelById(Id); Travel selectedTravelDB = travelObjectDB as Travel; TravelModel travelModel = new TravelModel { Id = selectedTravelDB.Id, AgencyID = selectedTravelDB.AgencyID, Titular = selectedTravelDB.Titular, StartDate = selectedTravelDB.StartDate, EndDate = selectedTravelDB.EndDate, TotalCost = selectedTravelDB.TotalCost, Description = selectedTravelDB.Description, Notes = selectedTravelDB.Notes }; return(View(travelModel)); }
public long SaveTravelIns(TravelModel objTravelIns) { long returnCode = -1; using (TransactionScope transactionScope = new TransactionScope()) { try { returnCode = objMotorAppDAL.SaveTravelIns(objTravelIns); transactionScope.Complete(); transactionScope.Dispose(); } catch (Exception ex) { transactionScope.Dispose(); throw ex; } return(returnCode); } }
public TravelModel GetTravelList(TravelQueryModel query) { TravelModel result = new TravelModel(); result.DataList = new List <TravelDataModel>(); TravelModel fltTravelModel = GetFlight(query); TravelModel traTravelModel = GetTrain(query); if (fltTravelModel != null && fltTravelModel.DataList != null && fltTravelModel.DataList.Count > 0) { result.DataList.AddRange(fltTravelModel.DataList); } if (traTravelModel != null && traTravelModel.DataList != null && traTravelModel.DataList.Count > 0) { result.DataList.AddRange(traTravelModel.DataList); } result.DataList = result.DataList.OrderBy(n => n.DTime).ToList(); return(result); }
public TravelResponseViewModel GetTravel(TravelRequestViewModel request) { ContactInfoModel contactInfoModel = _getContactBll.GetCorpContactByCid(request.Cid); if (contactInfoModel == null) { throw new Exception("无法查询到对应的联系人信息"); } //1.查询机场信息 SearchCityAportModel aportModel = _getCityForFlightServiceBll.SearchAirport(new List <string>() { "N" }); TravelQueryModel query = Mapper.Map <TravelRequestViewModel, TravelQueryModel>(request); query.AportInfo = aportModel; query.ContactId = contactInfoModel.ContactId; TravelModel travelModel = _getTravelServiceBll.GetTravelList(query); TravelResponseViewModel viewModel = Mapper.Map <TravelModel, TravelResponseViewModel>(travelModel); return(viewModel); }
private TravelModel GetFlight(TravelQueryModel query) { if (!query.ContactId.HasValue) { throw new Exception("请传入ContactId参数"); } TravelModel travel = new TravelModel(); travel.DataList = new List <TravelDataModel>(); List <string> orderstatusList = new List <string>() { "N", "C", "W" }; List <SearchCityModel> cityModels = query.AportInfo.CountryList.SelectMany(n => n.CityList).ToList(); List <SearchAirportModel> airportModels = cityModels.SelectMany(n => n.AirportList).ToList(); int contactId = query.ContactId.Value; DateTime nowTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); List <string> indexList = new List <string>(); List <int> orderIdList = new List <int>(); List <TravelDataModel> travelDataModels = new List <TravelDataModel>(); #region 机票正单行程 List <FltFlightEntity> flightList = (from flight in base.Context.Set <FltFlightEntity>().AsNoTracking() join passenger in Context.Set <FltPassengerEntity>().AsNoTracking() on flight.OrderId equals passenger.OrderId join order in Context.Set <FltOrderEntity>().AsNoTracking() on flight.OrderId equals order.OrderId where flight.TackoffTime >= nowTime && !orderstatusList.Contains(order.Orderstatus) && (order.ProcessStatus & 8) == 8 && passenger.Contactid == contactId select flight).Distinct().ToList(); List <FltFlightModel> flightModels = Mapper.Map <List <FltFlightEntity>, List <FltFlightModel> >(flightList); flightModels.ForEach(n => { SearchAirportModel airportModel = airportModels.Find(x => x.AirportCode == n.Dport); if (airportModel != null) { n.DportName = airportModel.AirportName; SearchCityModel cityModel = cityModels.Find(x => x.CityCode == airportModel.CityCode); n.DportCity = cityModel.CityName; } SearchAirportModel airportModel2 = airportModels.Find(x => x.AirportCode == n.Aport); if (airportModel2 != null) { n.AportName = airportModel2.AirportName; SearchCityModel cityModel2 = cityModels.Find(x => x.CityCode == airportModel2.CityCode); n.AportCity = cityModel2.CityName; } orderIdList.Add(n.OrderId); }); List <TravelDataModel> flightTravelDataModels = (from n in flightModels select new TravelDataModel() { Type = OrderSourceTypeEnum.Flt.ToString(), AName = n.AportName, DName = n.DportName, ATime = n.ArrivalsTime, DTime = n.TackoffTime, Id = n.OrderId, Sequence = n.Sequence, TravelNo = n.FlightNo }).ToList(); travelDataModels.AddRange(flightTravelDataModels); #endregion #region 机票改签行程 List <FltModFlightEntity> modFlightList = (from modFlight in Context.Set <FltModFlightEntity>().AsNoTracking() join modOrder in Context.Set <FltModOrderEntity>().AsNoTracking() on modFlight.Rmid equals modOrder.Rmid join modPassenger in Context.Set <FltModPassengerEntity>().AsNoTracking() on modFlight.Rmid equals modPassenger.Rmid join passenger in Context.Set <FltPassengerEntity>().AsNoTracking() on modPassenger.Pid equals passenger.PId where modFlight.TackoffTime.HasValue && modFlight.TackoffTime.Value > nowTime && (modOrder.ProcessStatus & 8) == 8 && passenger.Contactid == contactId select modFlight).Distinct().ToList(); List <FltModFlightModel> modFlightModels = Mapper.Map <List <FltModFlightEntity>, List <FltModFlightModel> >(modFlightList); modFlightModels.ForEach(n => { SearchAirportModel airportModel = airportModels.Find(x => x.AirportCode == n.Dport); if (airportModel != null) { n.DportName = airportModel.AirportName; SearchCityModel cityModel = cityModels.Find(x => x.CityCode == airportModel.CityCode); n.DportCity = cityModel.CityName; } SearchAirportModel airportModel2 = airportModels.Find(x => x.AirportCode == n.Aport); if (airportModel2 != null) { n.AportName = airportModel2.AirportName; SearchCityModel cityModel2 = cityModels.Find(x => x.CityCode == airportModel2.CityCode); n.AportCity = cityModel2.CityName; } }); List <TravelDataModel> modFlightTravelDataModels = (from n in modFlightModels select new TravelDataModel() { Type = OrderSourceTypeEnum.FltMod.ToString(), AName = n.AportName, DName = n.DportName, ATime = n.ArrivalsTime.Value, DTime = n.TackoffTime.Value, Id = n.Orderid, Sequence = n.Sequence.Value, TravelNo = n.FlightNo }).ToList(); travelDataModels.AddRange(modFlightTravelDataModels); #endregion #region 过滤正单和改签单 //同一个订单,同一个行程Id,改签替换正单行程 travelDataModels.ForEach(n => { indexList.Add(n.Id + "|" + n.Sequence); }); indexList = indexList.Distinct().ToList(); foreach (string index in indexList) { int orderid = Convert.ToInt32(index.Split('|')[0]); int sequence = Convert.ToInt32(index.Split('|')[1]); List <TravelDataModel> fightTempList = travelDataModels.FindAll( n => n.Id == orderid && n.Sequence == sequence && n.Type == OrderSourceTypeEnum.Flt.ToString()); List <TravelDataModel> modFightTempList = travelDataModels.FindAll( n => n.Id == orderid && n.Sequence == sequence && n.Type == OrderSourceTypeEnum.FltMod.ToString()); if (fightTempList != null && fightTempList.Count > 0 && (modFightTempList == null || modFightTempList.Count == 0)) { travel.DataList.AddRange(fightTempList); } else if (modFightTempList != null && modFightTempList.Count > 0) { travel.DataList.AddRange(modFightTempList); } } #endregion #region 过滤退票订单 List <int> refundId = new List <int>(); if (travel.DataList != null && travel.DataList.Count > 0) { List <FltRefundOrderDetailEntity> fltRefundOrderDetailEntities = base.Context.Set <FltRefundOrderDetailEntity>().Where(n => orderIdList.Contains(n.OrderId)).ToList(); if (fltRefundOrderDetailEntities.Count > 0) { for (int i = 0; i < travel.DataList.Count; i++) { FltRefundOrderDetailEntity fltRefundOrderEntity = fltRefundOrderDetailEntities.Find( n => n.OrderId == travel.DataList[i].Id && n.Sequence == travel.DataList[i].Sequence); if (fltRefundOrderEntity != null) { refundId.Add(fltRefundOrderEntity.OrderId); } } } } #endregion if (refundId.Count > 0) { travel.DataList.RemoveAll(n => refundId.Contains(n.Id)); } return(travel); }
private TravelModel GetTrain(TravelQueryModel query) { if (!query.ContactId.HasValue) { throw new Exception("请传入ContactId参数"); } TravelModel travel = new TravelModel(); travel.DataList = new List <TravelDataModel>(); int contactId = query.ContactId.Value; DateTime nowTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); List <int> indexList = new List <int>(); List <TravelDataModel> travelDataModels = new List <TravelDataModel>(); #region 火车正单行程 List <TravelDataModel> trainTravelDataModels = (from detail in Context.Set <TraOrderDetailEntity>() join order in Context.Set <TraOrderEntity>() on detail.OrderId equals order.OrderId join status in Context.Set <TraOrderStatusEntity>() on detail.OrderId equals status.OrderId join passenger in Context.Set <TraPassengerEntity>() on detail.OdId equals passenger.OdId where passenger.ContactId.HasValue && passenger.ContactId == contactId && status.IsCancle == 0 && status.IsBuy == 1 && detail.StartTime > nowTime && !string.IsNullOrEmpty(detail.StartName) && !string.IsNullOrEmpty(detail.EndName) && detail.EndTime.HasValue select new TravelDataModel() { Type = OrderSourceTypeEnum.Tra.ToString(), AName = detail.EndName, DName = detail.StartName, ATime = detail.EndTime.Value, DTime = detail.StartTime, Id = detail.OrderId, Sequence = 1, TravelNo = detail.TrainNo }).Distinct().ToList(); travelDataModels.AddRange(trainTravelDataModels); #endregion #region 火车改签行程 List <TravelDataModel> trainModTravelDataModels = (from modDetail in Context.Set <TraModOrderDetailEntity>() join modOrder in Context.Set <TraModOrderEntity>() on modDetail.CorderId equals modOrder.CorderId join passenger in Context.Set <TraPassengerEntity>() on modDetail.Pid equals passenger.Pid.ToString() where passenger.ContactId.HasValue && passenger.ContactId == contactId && modDetail.SendTime.HasValue && modDetail.SendTime.Value > nowTime && !string.IsNullOrEmpty(modOrder.ProcessStatus) && modOrder.ProcessStatus.Contains("H") && !string.IsNullOrEmpty(modDetail.AddrName) && !string.IsNullOrEmpty(modDetail.EndName) && modDetail.EndTime.HasValue && modDetail.SendTime.HasValue select new TravelDataModel() { Type = OrderSourceTypeEnum.TraMod.ToString(), AName = modDetail.EndName, DName = modDetail.AddrName, ATime = modDetail.EndTime.Value, DTime = modDetail.SendTime.Value, Id = modOrder.OrderId.Value, Sequence = 1, TravelNo = modDetail.TrainNo }).Distinct().ToList(); travelDataModels.AddRange(trainModTravelDataModels); #endregion #region 过滤正单和改签单 travelDataModels.ForEach(n => { indexList.Add(n.Id); }); foreach (int index in indexList) { List <TravelDataModel> traList = travelDataModels.FindAll( n => n.Id == index && n.Type == OrderSourceTypeEnum.Tra.ToString()); List <TravelDataModel> modList = travelDataModels.FindAll( n => n.Id == index && n.Type == OrderSourceTypeEnum.TraMod.ToString()); if (traList != null && traList.Count > 0 && (modList == null || modList.Count == 0)) { travel.DataList.AddRange(traList); } else if (modList != null && modList.Count > 0) { travel.DataList.AddRange(modList); } } #endregion #region 过滤退票订单 List <int> refundId = new List <int>(); if (travel.DataList != null && travel.DataList.Count > 0) { List <TraOrderEntity> traOrderEntities = base.Context.Set <TraOrderEntity>().Where(n => indexList.Contains(n.OrderRoot ?? 0) && ((!n.IsModRefund.HasValue) || n.IsModRefund == false) && n.OrderType == 2) .ToList(); if (traOrderEntities.Count > 0) { for (int i = 0; i < travel.DataList.Count; i++) { TraOrderEntity traOrderEntity = traOrderEntities.Find(n => n.OrderRoot == travel.DataList[i].Id); if (traOrderEntity != null) { refundId.Add(traOrderEntity.OrderRoot ?? 0); //有退票的订单号 } } } } #endregion if (refundId.Count > 0) { travel.DataList.RemoveAll(n => refundId.Contains(n.Id)); } return(travel); }
public DataTable ConvertTravelIns(TravelModel _objMotorIns) { try { //sql string-string //sql long -long // sql int -int DataTable _dt = new DataTable(); _dt.Columns.Add("IssueDate", typeof(DateTime)); _dt.Columns.Add("PolicyNo", typeof(string)); _dt.Columns.Add("Branch", typeof(string)); _dt.Columns.Add("Planning", typeof(string)); _dt.Columns.Add("NoOfDays", typeof(int)); _dt.Columns.Add("CoverageType", typeof(string)); _dt.Columns.Add("DepartureDate", typeof(DateTime)); _dt.Columns.Add("DateOfReturn", typeof(DateTime)); _dt.Columns.Add("DateOfBirth", typeof(DateTime)); _dt.Columns.Add("TravelDestination", typeof(string)); _dt.Columns.Add("PurposeOfVisit", typeof(string)); _dt.Columns.Add("Marketer", typeof(string)); _dt.Columns.Add("Broker_AgentCode", typeof(string)); _dt.Columns.Add("IssueFrom", typeof(string)); _dt.Columns.Add("AssuredName", typeof(string)); _dt.Columns.Add("Gender", typeof(string)); _dt.Columns.Add("CivilID", typeof(string)); _dt.Columns.Add("Mobile", typeof(long)); _dt.Columns.Add("PostBox", typeof(string)); _dt.Columns.Add("PostalCode", typeof(string)); _dt.Columns.Add("City", typeof(string)); _dt.Columns.Add("Email", typeof(string)); _dt.Columns.Add("LocalPersonName", typeof(string)); _dt.Columns.Add("LocalPersonNo", typeof(string)); _dt.Columns.Add("Nationality", typeof(string)); _dt.Columns.Add("PassportNo", typeof(string)); _dt.Columns.Add("Extension", typeof(string)); _dt.Columns.Add("VipCustomer", typeof(string)); _dt.Columns.Add("Remarks", typeof(string)); _dt.Columns.Add("PolicyIsForOmanNationals_LegalResidentsOfOman", typeof(string)); _dt.Columns.Add("SpecialDiscount", typeof(string)); _dt.Columns.Add("AdditionalConditions", typeof(string)); _dt.Columns.Add("MazayaCard", typeof(string)); _dt.Columns.Add("AssuredNameFamilyMember", typeof(string)); _dt.Columns.Add("DateOfBirthFamilyMember", typeof(DateTime)); _dt.Columns.Add("Age", typeof(int)); _dt.Columns.Add("Relationship", typeof(string)); _dt.Columns.Add("Sex", typeof(string)); _dt.Columns.Add("PassportNoFamilyMember", typeof(string)); _dt.Columns.Add("ExtensionFamilyMember", typeof(string)); ; DataRow _dr; _dr = _dt.NewRow(); _dr["IssueDate"] = _objMotorIns.IssueDate; _dr["PolicyNo"] = _objMotorIns.PolicyNo; _dr["Branch"] = _objMotorIns.Branch; _dr["Planning"] = _objMotorIns.Planning; _dr["NoOfDays"] = _objMotorIns.NoOfDays; _dr["CoverageType"] = _objMotorIns.CoverageType; _dr["DepartureDate"] = _objMotorIns.DepartureDate; _dr["DateOfReturn"] = _objMotorIns.DateOfReturn; _dr["DateOfBirth"] = _objMotorIns.DateOfBirth; _dr["TravelDestination"] = _objMotorIns.TravelDestination; _dr["PurposeOfVisit"] = _objMotorIns.PurposeOfVisit; _dr["Marketer"] = _objMotorIns.Marketer; _dr["Broker_AgentCode"] = _objMotorIns.Broker_AgentCode; _dr["IssueFrom"] = _objMotorIns.IssueFrom; _dr["AssuredName"] = _objMotorIns.AssuredName; _dr["Gender"] = _objMotorIns.Gender; _dr["CivilID"] = _objMotorIns.CivilID; _dr["Mobile"] = _objMotorIns.Mobile; _dr["PostBox"] = _objMotorIns.PostBox; _dr["PostalCode"] = _objMotorIns.PostalCode; _dr["City"] = _objMotorIns.City; _dr["Email"] = _objMotorIns.Email; _dr["LocalPersonName"] = _objMotorIns.LocalPersonName; _dr["LocalPersonNo"] = _objMotorIns.LocalPersonNo; _dr["Nationality"] = _objMotorIns.Nationality; _dr["PassportNo"] = _objMotorIns.PassportNo; _dr["Extension"] = _objMotorIns.Extension; _dr["VipCustomer"] = _objMotorIns.VipCustomer; _dr["Remarks"] = _objMotorIns.Remarks; _dr["PolicyIsForOmanNationals_LegalResidentsOfOman"] = _objMotorIns.PolicyIsForOmanNationals_LegalResidentsOfOman; _dr["SpecialDiscount"] = _objMotorIns.SpecialDiscount; _dr["AdditionalConditions"] = _objMotorIns.AdditionalConditions; _dr["MazayaCard"] = _objMotorIns.MazayaCard; _dr["AssuredNameFamilyMember"] = _objMotorIns.AssuredNameFamilyMember; _dr["DateOfBirthFamilyMember"] = _objMotorIns.DateOfBirthFamilyMember; _dr["Age"] = _objMotorIns.Age; _dr["Relationship"] = _objMotorIns.Relationship; _dr["Sex"] = _objMotorIns.Sex; _dr["PassportNoFamilyMember"] = _objMotorIns.PassportNoFamilyMember; _dr["ExtensionFamilyMember"] = _objMotorIns.ExtensionFamilyMember; _dt.Rows.Add(_dr); return(_dt); } catch (Exception ex) { throw; } }