public async Task <ActionResult> Export(ExportModel model) { model.ProjectName = (await ProjectService.GetProjectAsync(model.ProjectGuid.GetValueOrDefault())).Name; var directory1 = Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString()); Directory.CreateDirectory(directory1); foreach (var definitionId in model.DefinitionIds) { var definition = await ReleaseDefinitionsService.GetDefinitionJsonAsync(model.ProjectGuid.GetValueOrDefault(), definitionId); var token = JToken.Parse(definition); var file = $"{FileUtility.RemoveInvalidFileCharacters(token["name"].ToString())}.json"; System.IO.File.WriteAllText(Path.Combine(directory1, file), FormatJson(definition)); } var friendlyFileName = $"{model.ProjectName.Replace(" ", "-")}_ReleaseDefinitions_{DateTime.Now:yyyy-MM-dd_HH-mm}.zip"; var archive = Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString()); System.IO.Compression.ZipFile.CreateFromDirectory(directory1, archive); Directory.Delete(directory1, true); return(File(System.IO.File.OpenRead(archive), "application/zip", friendlyFileName)); }
private void SaveMultipleLevel(ExportModel info, TextureArray2D texture) { Debug.Assert(info.TexFormat.Format.HasGliFormat); var numLayer = info.Layer == -1 ? models.Images.NumLayers : 1; var numLevels = info.Mipmap == -1 ? models.Images.NumMipmaps : 1; var supportCropping = numLevels == 1; var width = info.GetCropWidth(); var height = info.GetCropHeight(); if (!info.UseCropping && numLevels == 1) { // set full width and height width = models.Images.GetWidth(info.Mipmap); height = models.Images.GetHeight(info.Mipmap); } Debug.Assert(width > 0); Debug.Assert(height > 0); if (!supportCropping) { width = models.Images.Width; height = models.Images.Height; } // allocate ImageLoader.CreateStorage(info.TexFormat.Format.GliFormat, width, height, numLayer, numLevels); // store data for (var layerIdx = 0; layerIdx < numLayer; ++layerIdx) { for (var levelIdx = 0; levelIdx < numLevels; ++levelIdx) { ImageLoader.GetLevelSize(levelIdx, out var bufSize); var data = texture.GetData( numLayer == 1 ? info.Layer : layerIdx, numLevels == 1 ? info.Mipmap : levelIdx, info.TexFormat.Format, info.UseCropping && supportCropping, info.CropStartX, info.CropStartY, ref width, ref height, models.GlData.ExportShader, (int)bufSize); ImageLoader.StoreLevel(layerIdx, levelIdx, data, (UInt64)data.Length); } } // save texture if (info.FileType == ExportModel.FileFormat.Ktx) { ImageLoader.SaveKtx(info.Filename); } else if (info.FileType == ExportModel.FileFormat.Ktx2) { ImageLoader.SaveKtx2(info.Filename); } else if (info.FileType == ExportModel.FileFormat.Dds) { ImageLoader.SaveDDS(info.Filename); } }
public ExcelExportResultModel Export <T>(ExportModel model, IList <T> entities) where T : class, new() { if (model == null) { throw new NullReferenceException("Excel导出信息不存在"); } //设置列对应的属性类型 SetColumnPropertyType <T>(model); var saveName = Guid.NewGuid() + model.Format.ToDescription(); var saveDir = Path.Combine(Options.TempPath, "Export", DateTime.Now.Format("yyyyMMdd")); if (!Directory.Exists(saveDir)) { Directory.CreateDirectory(saveDir); } var result = new ExcelExportResultModel { SaveName = saveName, FileName = model.FileName, Path = Path.Combine(saveDir, saveName) }; using var fs = new FileStream(result.Path, FileMode.Create, FileAccess.Write); //创建文件 _exportHandler.CreateExcel(model, entities, fs); return(result); }
public void ParsedWaybillsToExcel([DataBind("filter")] ParsedWaybillsFilter filter) { if(filter.Session == null) filter.Session = DbSession; var result = ExportModel.GetParcedWaybills(filter); this.RenderFile("Отчет о состоянии формализованных накладных.xls", result); }
public ActionResult Index(ExportModel model) { var data = _soLieuNhapLieuService.GetSoLieuNhapLieusXuatFile(model.fromDate, model.toDate, model.fromNumber, model.toNumber); return(View(data)); }
public void ExcelClientConditionsMonitoring() { var filter = new ClientConditionsMonitoringFilter(); filter.Session = DbSession; BindObjectInstance(filter, IsPost ? ParamStore.Form : ParamStore.QueryString, "filter", AutoLoadBehavior.NullIfInvalidKey); this.RenderFile("Мониторинг_выставления_условий_клиенту.xls", ExportModel.GetClientConditionsMonitoring(filter)); }
/// <summary> /// This method is used to load the export model from memory if available or from the database. /// </summary> /// <param name="context">Contains the <see cref="IFrameworkContext{IDataRepository}"/> object used for accessing the Vasont data repository.</param> /// <param name="exportId">Contains the identity of the export.</param> /// <returns> /// Returns the <see cref="ExportModel" /> model. /// </returns> public static ExportModel LoadExportModelCache(this IFrameworkContext <IDataRepository> context, long exportId) { string exportCacheKey = $"Tenant_{context.Settings.TenantInfo.DomainKey}_Export{exportId}"; ExportModel model = null; // load XML link type model from the cache if it exists if (context.Cache.Contains(exportCacheKey)) { model = context.Cache.Get <ExportModel>(exportCacheKey); } else { Export export = context.DataRepository.Exports .AsNoTracking() .FirstOrDefault(e => e.ExportId == exportId); if (export != null) { model = new ExportModel(export); if (!context.Cache.Contains(exportCacheKey)) { context.Cache.Add(exportCacheKey, model); } } else { context.ErrorManager.Warning(Resources.ExportNotFoundText); } } return(model); }
public IActionResult Test(InputEncapsulationModel input) { List <InputModel> inputList = input.InputModels; if (inputList.Count == 0) { return(NoContent()); } else { if (input.SortID == "" | input.SortID == null) { input.SortID = "Falcon lijn.Pers-groep.WP6.DataBlocksGlobal.DB_PressRxD.in.ps3AVForcePress"; } List <InputModel> valList = inputList.Where(i => i.id == input.SortID).ToList(); List <ExportModel> returnList = new List <ExportModel>(); foreach (InputModel val in valList) { ExportModel exportModel = new ExportModel(); exportModel.ID = 1; exportModel.y = double.Parse(val.v); exportModel.x = double.Parse(val.t); returnList.Add(exportModel); } return(Ok(returnList)); // return format of type [ ID,y,x ] in which ID is ID y = v x = t } }
public void Initialize() { exportModel = ServiceLocator.Current.GetInstance <MainViewModel>().export; rLastPeriod = ServiceLocator.Current.GetInstance <DashboardViewModel>().LastPeriod; productionList = exportModel.productionList; produceItemProductionList = new List <produceItemsItem>(); WorkplacesTimesNew = new ObservableCollection <WorkplaceTimeModel>(); workspaces = WorkspacesModel.GetInstance().GetWorkspaces(); produceItems = ProduceItemsModel.GetInstance().GetProduceItems(); produceItemProductionList = ProduceItemsModel.GetInstance().GetProduceItems(); workspaces.ForEach(w => { string description = w.label.de; var shift = 1; var model = new WorkplaceTimeModel(w.id, description, 0, 0, 0, 0, 0, shift, 0); WorkplacesTimesNew.Add(model); }); calcSetUpNew(); productionList.ForEach(i => calculateProductionTimeNew(i.article, i.quantity)); createMapOldTimeOrdersInWork(rLastPeriod); createMapOldWaitinglistWorkstations(rLastPeriod); oldSetUpTime(rLastPeriod, produceItems); calculate(); }
/// <summary> /// 设置列属性 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="model"></param> private void SetColumnPropertyType <T>(ExportModel model) where T : class, new() { if (model.Columns == null || !model.Columns.Any()) { return; } var objectType = typeof(T); if (!_exportObjectProperties.TryGetValue(objectType.TypeHandle, out Dictionary <string, PropertyInfo> types)) { types = new Dictionary <string, PropertyInfo>(); var properties = objectType.GetProperties(); foreach (var property in properties) { types.Add(property.Name.ToLower(), property); } _exportObjectProperties.TryAdd(objectType.TypeHandle, types); } foreach (var column in model.Columns) { column.PropertyInfo = types.FirstOrDefault(m => m.Key.EqualsIgnoreCase(column.Name)).Value; } }
public Models(int numPipelines = 1) { NumPipelines = numPipelines; CheckDeviceCapabilities(); SharedModel = new SharedModel(); Images = new ImagesModel(SharedModel.ScaleShader); TextureCache = new TextureCache(Images); pixelValueShader = new PixelValueShader(SharedModel); polarConvertShader = new ConvertPolarShader(SharedModel.QuadShader); Export = new ExportModel(SharedModel); Filter = new FiltersModel(Images); //Gif = new GifModel(sharedModel.QuadShader); Progress = new ProgressModel(); for (int i = 0; i < numPipelines; ++i) { pipelines.Add(new ImagePipeline(i)); pipelines.Last().PropertyChanged += PipeOnPropertyChanged; } Pipelines = pipelines; stats = new StatisticsModel(SharedModel); thumbnail = new ThumbnailModel(SharedModel.QuadShader); // pipeline controller pipelineController = new PipelineController(this); }
/// <summary> /// This is the method that actually does the work. /// </summary> /// <param name="DA">The DA object is used to retrieve from inputs and store in outputs.</param> protected override void SolveInstance(IGH_DataAccess DA) { ModelCls mymodel = new ModelCls(); //新建模型对象,存储建立的模型 string path0 = null; //路径 int typeFile = 1; //文件类型,1为midas mgt,2为abaqus inp bool cmd = false; //文件输出指令,True为输出 DA.GetData(3, ref cmd); if (DA.GetData(0, ref mymodel) && DA.GetData(1, ref path0) && DA.GetData(2, ref typeFile) && cmd) { ExportModel myExport = null; switch (typeFile) { case 1: myExport = new ExportGen(mymodel, path0); break; case 2: myExport = new ExportAbaqus(mymodel, path0); break; } Process process = Process.Start(myExport.Pathfile);//打开输出的文件,便于直接复制 process.Dispose(); } }
private async void ImportButton_Click(object sender, RoutedEventArgs e) { var file = await IOTools.OpenLocalFile(".guanzhi"); if (file != null) { string text = await FileIO.ReadTextAsync(file); var model = JsonConvert.DeserializeObject <ExportModel>(text); var tipDialog = new ConfirmDialog("导入提醒", $"您将导入用户名为'{model.UserName}'用户的相关配置及历史记录。这会覆盖您目前的配置及记录,是否确认?"); var result = await tipDialog.ShowAsync(); if (result == ContentDialogResult.Primary) { bool importResult = await ExportModel.ImportModel(model); if (importResult) { var closeDialog = new ConfirmDialog("请重启软件", "配置及历史记录已成功导入,现在请关闭软件,重新启动应用", "关闭", "关闭", "还是关闭"); await closeDialog.ShowAsync(); App.Current.Exit(); } } } }
public void FormPositionToExcel([DataBind("filter")] FormPositionFilter filter) { if(filter.Session == null) filter.Session = DbSession; var result = ExportModel.GetFormPosition(filter); this.RenderFile("Отчет о состоянии формализуемых полей.xls", result); }
private void addUsedForms(SearchModel model) { ExportModel exportModel = new ExportModel(); exportModel.formIds = model.formIds; exportModel.formResultIds = model.sisIds; exportModel.formNames = new Dictionary <int, string>(); foreach (int?nFormId in exportModel.formIds) { if (nFormId != null) { int formId = (int)nFormId; def_Forms form = formsRepo.GetFormById(formId); if (form != null) { string name = form.identifier; exportModel.formNames.Add(formId, name); } } } Session["ExportModel"] = exportModel; model.usedForms = exportModel.formNames; if (model.usedForms.Count() > 1) { model.usedForms.Add(-1, "All"); } }
public Step1ViewModel() { exportModel = ServiceLocator.Current.GetInstance <MainViewModel>().export; Sellwish1 = 0; Sellwish2 = 0; Sellwish3 = 0; selldirect1 = 0; selldirect2 = 0; selldirect3 = 0; selldirect1price = 0L; selldirect2price = 0L; selldirect3price = 0L; selldirect1fine = 0L; selldirect2fine = 0L; selldirect3fine = 0L; forecast11 = 0; forecast21 = 0; forecast31 = 0; forecast12 = 0; forecast22 = 0; forecast32 = 0; forecast13 = 0; forecast23 = 0; forecast33 = 0; NextCommand = new RelayCommand(NextClick); }
public void ExcelWhoWasNotUpdated() { var filter = new WhoWasNotUpdatedFilter(); filter.Session = DbSession; BindObjectInstance(filter, IsPost ? ParamStore.Form : ParamStore.QueryString, "filter", AutoLoadBehavior.NullIfInvalidKey); this.RenderFile("Кто_не_обновлялся_с_опред._даты.xls", ExportModel.ExcelWhoWasNotUpdated(filter)); }
public async Task <ActionResult> Export(ExportModel model) { model.ProjectName = (await ProjectService.GetProjectAsync(model.ProjectGuid.GetValueOrDefault())).Name; var directory1 = Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString()); Directory.CreateDirectory(directory1); foreach (var groupId in model.GroupIds) { var group = await TaskGroupService.GetTaskGroupAsync(model.ProjectGuid.GetValueOrDefault(), groupId); var file = $"{FileUtility.RemoveInvalidFileCharacters(group.Name)}.json"; System.IO.File.WriteAllText(Path.Combine(directory1, file), JsonConvert.SerializeObject(group, Formatting.Indented)); } var friendlyFileName = $"{model.ProjectName.Replace(" ", "-")}_TaskGroups_{DateTime.Now:yyyy-MM-dd_HH-mm}.zip"; var archive = Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString()); System.IO.Compression.ZipFile.CreateFromDirectory(directory1, archive); Directory.Delete(directory1, true); return(File(System.IO.File.OpenRead(archive), "application/zip", friendlyFileName)); }
/// <summary> /// 导出excel数据 /// </summary> /// <param name="model"></param> /// <returns>filename</returns> public string ExportExcelData(JqGridPostData model) { string tableName = model.QuerySet.TableName; FapTable ftb = _dbContext.Table(tableName); string fileName = $"{ftb.TableComment}_{UUIDUtils.Fid}.xlsx"; string filePath = Path.Combine(Environment.CurrentDirectory, FapPlatformConstants.TemporaryFolder, fileName); Pageable pageable = AnalysisPostData(model); pageable.QueryCols = model.QuerySet.ExportCols; string sql = pageable.Wraper.MakeExportSql(); if (pageable.Parameters != null && pageable.Parameters.Count > 0) { foreach (var param in pageable.Parameters) { sql = sql.Replace("@" + param.Key, "'" + param.Value + "'"); } } ExportModel em = new ExportModel() { DataSql = sql, FileName = filePath, TableName = tableName, ExportCols = pageable.QueryCols }; bool result = _officeService.ExportExcel(em); return(result ? fileName : ""); }
public ActionResult Index(ExportModel Expmodel, TrainBookingRequestModel model, FormCollection frm, int?page) { TrainBookingRequestRepository _rep = new TrainBookingRequestRepository(); var ts = (TravelSession)Session["TravelPortalSessionInfo"]; model.StatusId = 1; model.PagedList = _rep.GetBrachPendingBookingPagedList(model, page, ts.LoginTypeId); ViewData["DisList"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName"); if (TrainGeneralRepository.Message != null) { model.Message = TrainGeneralRepository.Message; } else { model.Message = _msg; } GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } var exportData = _rep.BranchList(model, ts.LoginTypeId).Select(m => new { SNo = m.SNo, Passenger_Name = m.FullName, Sector = m.Sector, DepartureDate = m.DepartureDate, RequestDate = m.CreateDate, TicketStatusName = m.StatusName, RequestBy = m.CreatedByName, Request_ID = "AH-TR-" + m.TrainPNRId.ToString().PadLeft(5, '0') }); App_Class.AppCollection.Export(Expmodel, exportData, "TrainBookingRequestList"); } catch (Exception ex) { ATLTravelPortal.Utility.ErrorLogging.LogException(ex); } } return(View(model)); }
public ActionResult <ExportModel> AllVehicles(DateTime dayOf) { var export = m_Context.Export.FirstOrDefault(c => c.export_date.Date == dayOf.Date && c.export_type == "Vehicle"); if (export == null) { ExportHelper helper = new ExportHelper(m_appSettings.SecurityConnection); string fileName = "Vehicle_Data_" + dayOf.ToString("yyyy.MM.dd") + ".json"; //Kick off the file export & return Task task = Task.Run(() => helper.ExportVehicleData(dayOf, m_appSettings.ExportFileLocation, fileName)); //NOTE: In a production environment the files would mostly be generated by a scheduled nightly job. //If they *were* being generated on-demand, then this method would most likely write the request to a //queue of some sort where a seperate process would pick it up and process it. That //would be a preferred approach, so as not to overburden the web server with file generation. We are //launching it here on a background task just for demonstration purposes. return(StatusCode(202)); } var result = new ExportModel { location = m_appSettings.ApiBase + $"/download/{export.Id}" }; return(result); }
void ExportToSql(ExportModel data, AppOptionInfo opts, EntityMap entityMap, CodeGenRunner codeGenRunner, string template, List <string> files) { var fileName = GetFileName(entityMap.Name, entityMap.SortOrder, opts.OutputFile); codeGenRunner.GenerateCodeFromTemplate(data, template, codeGenRunner.WorkingFolder, fileName); files.Add(Path.Combine(codeGenRunner.WorkingFolder, fileName)); }
public ActionResult ExcelExport(string GridModel) { ExportModel exportModel = new ExportModel(); exportModel = (ExportModel)JsonConvert.DeserializeObject(GridModel, typeof(ExportModel)); // Deserialized the GridModel using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet worksheet = workbook.Worksheets[0]; IEnumerable DataSource = order; //Import the data to worksheet IList <OrdersDetails> reports = DataSource.AsQueryable().Cast <OrdersDetails>().ToList(); worksheet.ImportData(reports, 2, 1, true); MemoryStream stream = new MemoryStream(); workbook.SaveAs(stream); stream.Position = 0; //Download the Excel file in the browser FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel"); fileStreamResult.FileDownloadName = "Output.xlsx"; return(fileStreamResult); } }
public void ExcelAnalysisOfWorkDrugstores() { var filter = new AnalysisOfWorkDrugstoresFilter(); filter.Session = DbSession; BindObjectInstance(filter, IsPost ? ParamStore.Form : ParamStore.QueryString, "filter", AutoLoadBehavior.NullIfInvalidKey); this.RenderFile("Сравнительный_анализ_работы_аптек.xls", ExportModel.ExcelAnalysisOfWorkDrugstores(filter)); }
public ActionResult Index(BusPNRModel model, int?page, ExportModel Expmodel, FormCollection frm) { Session["FromDate"] = model.FromDate; Session["ToDate"] = model.ToDate; BusPNRModel _model = new BusPNRModel(); UnIssuedTicketRepository _rep = new UnIssuedTicketRepository(); BusGeneralRepository.SetRequestPageRow(); try { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorAgentList(ts.LoginTypeId), "AgentId", "AgentName"); _model.TabularList = _rep.GetDistributorPagedIssueList(page, model.FromDate, model.ToDate, model.AgentId, ts.LoginTypeId); } catch (Exception ex) { _model.Message = BusGeneralRepository.CatchException(ex); } //export BookedTicketReportController crtBKT = new BookedTicketReportController(); crtBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } var exportData = _model.TabularList.Select(m => new { Passenger_Name = m.FullName, Operator_Name = m.BusMasterName, DepartureDate = TimeFormat.DateFormat(m.DepartureDate.ToString()), DepartureTime = TimeFormat.GetAMPMTimeFormat(m.DepartureTime.ToString()), Category = m.BusCategoryName, Type = m.Type }); App_Class.AppCollection.Export(Expmodel, exportData, "Issued Ticket"); } catch { } } _model.Message = _res; return(View(_model)); }
/// <summary> /// Exports the specified entity map. /// </summary> /// <param name="entityMap">The entity map.</param> /// <param name="exportIdentityColumn">if set to <c>true</c> [export identity column].</param> /// <param name="exportDatabaseGeneratedColumn">if set to <c>true</c> [export database generated column].</param> /// <returns></returns> public ExportModel Export(EntityMap entityMap, bool exportIdentityColumn = true, bool exportDatabaseGeneratedColumn = true) { var model = new ExportModel { ImportDialect = importDialect, ExportDialect = exportDialect, Map = entityMap, TypeConverterStore = typeConverter }; model.Options.ExportIdentityColumn = exportIdentityColumn; model.Options.ExportDatabaseGeneratedColumns = exportDatabaseGeneratedColumn; IDbAccess dbAccess = new DbAccess(dbConnector); using (var conn = dbConnector.CreateNewConnection()) { if (conn.State != ConnectionState.Open) { conn.Open(); } var dataBag = dbAccess.ExecuteDictionary(conn, model.SelectSqlStatement()); model.DataBag = dataBag; } return(model); }
/// <summary> /// 设置列名 /// </summary> private void SetColumnName(ExcelWorksheet sheet, ExportModel model, ref int index) { if (!model.ShowColName) { return; } sheet.Row(index).Height = 25; for (int i = 0; i < model.Columns.Count; i++) { var col = model.Columns[i]; var cell = sheet.Cells[index, i + 1]; cell.Value = col.Label; cell.Style.Font.Size = 12; cell.Style.Font.Bold = true; cell.Style.Font.Color.SetColor(Color.CornflowerBlue); cell.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; cell.Style.VerticalAlignment = ExcelVerticalAlignment.Center; if (col.Width > 0) { sheet.Column(i + 1).Width = col.Width; } else { sheet.Column(i + 1).AutoFit(); } } index++; }
public ActionResult Index(ExportModel Expmodel, BookedTicketModels model, FormCollection frm, int?pageNo, int?flag) { var ts = SessionStore.GetTravelSession(); //var agentsByDistributor = distributorManagementProvider.GetAllAgentsByDistributorId(ts.AppUserId); //var details = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate); //var result = agentsByDistributor.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList()); var details = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate); var result = details.Where(x => x.DistributorId == ts.LoginTypeId); model.BookedTicketList = result; model.BookedTicketList = result; //export GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } var exportData = model.BookedTicketList.Select(m => new { Agent_Name = m.AgentName, GDSReferenceNumber = m.GDSRefrenceNumber, PassengerName = m.PassengerName, Sector = m.Sector, Flight_Date = m.FlightDate, BookedOn = m.BookedOn, BookedBy = m.BookedBy }); App_Class.AppCollection.Export(Expmodel, exportData, "Booked Ticket"); } catch { } } ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName"); //var agents = defaultProvider.GetAgentList().Where(x => x.CreatedBy == ts.AppUserId); var agents = defaultProvider.GetAgentList().Where(x => x.DistributorId == ts.LoginTypeId); ViewData["AgentList"] = new SelectList(agents, "AgentId", "AgentName"); return(View(model)); }
public ActionResult Index(ExportModel Expmodel, AgentCLApprovedModel model, FormCollection frm, int?pageNo, int?flag) { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; if (ts.UserTypeId == 6) { model.DistributorID = ts.LoginTypeId; } model.AgentCLApprovedListExport = agentCLApprovedProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId); //export BookedTicketReportController crtBKT = new BookedTicketReportController(); crtBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } var exportData = model.AgentCLApprovedListExport.Select(m => new { Brach_Office = m.BranchOfficeName, Distributor = m.DistributorName, Agent_Name = m.AgentName, Agent_Code = m.AgentCode, Currency = m.Currency, Amount = m.Amount, Type = m.Type, Requestion = m.Requestion, Checker_Date = m.CheckerDate, CheckerBy = m.CheckedBy }); App_Class.AppCollection.Export(Expmodel, exportData, "Issued Ticket"); } catch { } } model.UsersOption = new SelectList(agentCLApprovedProvider.GetDistributorUsers(model.DistributorID), "AppUserId", "FullName"); model.AgentOption = new SelectList(agentCLApprovedProvider.GetAgentsByDistributorId(model.DistributorID ?? 0), "AgentId", "AgentName", model.AgentId); return(View(model)); }
public ActionResult Index(ExportModel Expmodel, AgentCLApprovedModel model, FormCollection frm, int?pageNo, int?flag, int?page) { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; int currentPageIndex = page.HasValue ? page.Value : 1; int defaultPageSize = 50; //export BookedTicketReportController crtBKT = new BookedTicketReportController(); crtBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { model.AgentCLApprovedListExport = agentReceiptsProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId); try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } var exportData = model.AgentCLApprovedListExport.Select(m => new { BranchOffice_Name = m.BranchOfficeName, Distributor_Name = m.DistributorName, Agent_Name = m.AgentName, Agent_Code = m.AgentCode, Currency = m.Currency, Amount = m.Amount, Narration = m.Comments, VoucherNo = m.VoucherNo, CreatedBy = m.CheckedBy, CreatedDate = m.CheckerDate }); App_Class.AppCollection.Export(Expmodel, exportData, "Agent Receipts"); } catch { } } model.AgentReceiptList = agentReceiptsProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId).ToPagedList(currentPageIndex, defaultPageSize); model.UsersOption = new SelectList(defaultProvider.GetUserList(), "AppUserId", "FullName"); model.BranchOfficeOption = new SelectList(branchOfficeManagementProvider.GetAll(), "BranchOfficeId", "BranchOfficeName", model.BranchOfficeId); model.DistributorOption = new SelectList(agentclaapprovedprovider.GetAllDistributorsByBranchOfficeId(model.BranchOfficeId ?? 0), "DistributorId", "DistributorName"); model.AgentOption = new SelectList(agentclaapprovedprovider.GetAgentsByDistributorId(model.DistributorID ?? 0), "AgentId", "AgentName", model.AgentId); return(View(model)); }