public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_de_Descripcion_de_Evidencia_CCApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_de_Descripcion_de_Evidencia_CCPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_de_Descripcion_de_Evidencia_CCApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_de_Descripcion_de_Evidencia_CCs == null) { result.Detalle_de_Descripcion_de_Evidencia_CCs = new List <Detalle_de_Descripcion_de_Evidencia_CC>(); } var data = result.Detalle_de_Descripcion_de_Evidencia_CCs.Select(m => new Detalle_de_Descripcion_de_Evidencia_CCGridModel { Clave = m.Clave , Numero_de_Evidencia = m.Numero_de_Evidencia , Descripcion_de_la_Evidencia = m.Descripcion_de_la_Evidencia , Origen = m.Origen , Descripcion = m.Descripcion , Examen_Solicitado = m.Examen_Solicitado , Codigo_de_Barras = m.Codigo_de_Barras , Archivo_de_Foto = m.Archivo_de_Foto }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_de_Descripcion_de_Evidencia_CCList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_de_Descripcion_de_Evidencia_CCList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_Ejercicios_RutinasApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_Ejercicios_RutinasPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_Ejercicios_RutinasApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_Ejercicios_Rutinass == null) { result.Detalle_Ejercicios_Rutinass = new List <Detalle_Ejercicios_Rutinas>(); } var data = result.Detalle_Ejercicios_Rutinass.Select(m => new Detalle_Ejercicios_RutinasGridModel { Folio = m.Folio , Orden_de_realizacion = m.Orden_de_realizacion , Secuencia = m.Secuencia , Enfoque_del_EjercicioDescripcion = (string)m.Enfoque_del_Ejercicio_Tipo_de_Enfoque_del_Ejercicio.Descripcion , EjercicioNombre_del_Ejercicio = (string)m.Ejercicio_Ejercicios.Nombre_del_Ejercicio , Cantidad_de_series = m.Cantidad_de_series , Cantidad_de_repeticiones = m.Cantidad_de_repeticiones , Descanso_en_segundos = m.Descanso_en_segundos }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_Ejercicios_RutinasList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_Ejercicios_RutinasList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
void ImportPeopleCSV_Click(object sender, RoutedEventArgs e) { //category to auto-apply long?autocCatId = CatSelectDialog.SelectCat("Choose category to apply to each imported person, or cancel to skip")?.RowId; string filename = AskForImportFileName(false); if (filename == null) { return; } var cvt = new CsvConverter(); try { using var rdr = new StreamReader(filename); var persons = cvt.PersonFromCsv(rdr).ToArray(); foreach (var person in persons) { var eperson = new ExtPerson(person, null, null); if (autocCatId != null) { eperson.SelectedCatIds = new long[] { autocCatId.Value } } ; Globals.UI.SavePerson(eperson); } VisualUtils.ShowMessageDialog($"Imported {persons.Length} record(s)"); } catch (Exception ex) { VisualUtils.ShowMessageDialog("Importing failed: " + ex.Message); } }
public void StartProcessing() { _isNeedStop = false; SigmoidAlphaValue = viewModel.SigmoidsAlpha; LearningRate = viewModel.LearningRate; Momentum = viewModel.Momentum; var lines = File.ReadAllLines(viewModel.TrainingFilePath); // Initialize input and output values var dataset = CsvConverter.ToDouble(lines); // Layers (without input layer, contains output layer) int[] layers = { 20, dataset.Outputs[0].Length }; // Create perceptron Network = new ActivationNetwork(new SigmoidFunction(SigmoidAlphaValue), dataset.Inputs[0].Length, layers); // Create teacher var teacher = new BackPropagationLearning(Network) { LearningRate = LearningRate, Momentum = Momentum }; int iteration = 1; try { List <double> errorsList = new List <double>(); while (!_isNeedStop) { // run epoch of learning procedure double error = teacher.RunEpoch(dataset.Inputs, dataset.Outputs); errorsList.Add(error); // show current iteration & error viewModel.Epoches = iteration; viewModel.AverageError = error; iteration++; // check if we need to stop if (error <= viewModel.LearningErrorLimit) { break; } if (iteration > viewModel.EpochesLimit && viewModel.EpochesLimit > 0) { break; } } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_Planes_de_Suscripcion_EspecialistasApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_Planes_de_Suscripcion_EspecialistasPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_Planes_de_Suscripcion_EspecialistasApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_Planes_de_Suscripcion_Especialistass == null) { result.Detalle_Planes_de_Suscripcion_Especialistass = new List <Detalle_Planes_de_Suscripcion_Especialistas>(); } var data = result.Detalle_Planes_de_Suscripcion_Especialistass.Select(m => new Detalle_Planes_de_Suscripcion_EspecialistasGridModel { Folio = m.Folio , Plan_de_SuscripcionNombre = (string)m.Plan_de_Suscripcion_Planes_de_Suscripcion_Especialistas.Nombre , Fecha_de_inicio = (m.Fecha_de_inicio == null ? string.Empty : Convert.ToDateTime(m.Fecha_de_inicio).ToString(ConfigurationProperty.DateFormat)) , Fecha_fin = (m.Fecha_fin == null ? string.Empty : Convert.ToDateTime(m.Fecha_fin).ToString(ConfigurationProperty.DateFormat)) , Frecuencia_de_PagoNombre = (string)m.Frecuencia_de_Pago_Frecuencia_de_pago_Especialistas.Nombre , Costo = m.Costo , Firmo_Contrato = m.Firmo_Contrato , EstatusDescripcion = (string)m.Estatus_Estatus_de_Suscripcion.Descripcion }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_Planes_de_Suscripcion_EspecialistasList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_Planes_de_Suscripcion_EspecialistasList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
private static void ConvertMidiFileToFromCsv(MidiFile midiFile, string outputFilePath, MidiFileCsvConversionSettings settings) { var csvConverter = new CsvConverter(); csvConverter.ConvertMidiFileToCsv(midiFile, outputFilePath, true, settings); csvConverter.ConvertCsvToMidiFile(outputFilePath, settings); }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IMR_TarjetasApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new MR_TarjetasPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IMR_TarjetasApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.MR_Tarjetass == null) { result.MR_Tarjetass = new List <MR_Tarjetas>(); } var data = result.MR_Tarjetass.Select(m => new MR_TarjetasGridModel { Folio = m.Folio , Tipo_de_TarjetaDescripcion = (string)m.Tipo_de_Tarjeta_Tipo_de_Tarjeta.Descripcion , Numero_de_Tarjeta = m.Numero_de_Tarjeta , Nombre_del_Titular = m.Nombre_del_Titular , Ano_de_vigencia = m.Ano_de_vigencia , Mes_de_vigencia = m.Mes_de_vigencia , Alias_de_la_Tarjeta = m.Alias_de_la_Tarjeta , EstatusDescripcion = (string)m.Estatus_Estatus.Descripcion }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "MR_TarjetasList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "MR_TarjetasList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_Resultados_ConsultasApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_Resultados_ConsultasPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_Resultados_ConsultasApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_Resultados_Consultass == null) { result.Detalle_Resultados_Consultass = new List <Detalle_Resultados_Consultas>(); } var data = result.Detalle_Resultados_Consultass.Select(m => new Detalle_Resultados_ConsultasGridModel { Folio = m.Folio , Folio_PacientesNombre_Completo = (string)m.Folio_Pacientes_Pacientes.Nombre_Completo , Fecha_de_Consulta = (m.Fecha_de_Consulta == null ? string.Empty : Convert.ToDateTime(m.Fecha_de_Consulta).ToString(ConfigurationProperty.DateFormat)) , IndicadorNombre = (string)m.Indicador_Indicadores_Consultas.Nombre , Resultado = m.Resultado , Interpretacion = m.Interpretacion , IMC = m.IMC , IMC_Pediatria = m.IMC_Pediatria }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_Resultados_ConsultasList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_Resultados_ConsultasList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
void ImportBoxesCSV_Click(object sender, RoutedEventArgs e) { string filename = AskForImportFileName(false); if (filename == null) { return; } var cvt = new CsvConverter(); try { using var rdr = new StreamReader(filename); var boxes = cvt.BoxFromCsv(rdr).ToArray(); foreach (var box in boxes) { Globals.UI.SaveBox(new ExtBox(box, null), false); } VisualUtils.ShowMessageDialog($"Imported {boxes.Length} record(s)"); } catch (Exception ex) { VisualUtils.ShowMessageDialog("Importing failed: " + ex.Message); } UIGlobals.Do.RebuildViews(BoxEditingPool.CreateUniversalChangeItem(), false); }
private static void ConvertNotesToFromCsv(IEnumerable <Note> notes, TempoMap tempoMap, string outputFilePath, NoteCsvConversionSettings settings) { var csvConverter = new CsvConverter(); csvConverter.ConvertNotesToCsv(notes, outputFilePath, tempoMap, true, settings); csvConverter.ConvertCsvToNotes(outputFilePath, tempoMap, settings); }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_de_IndiciosApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_de_IndiciosPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_de_IndiciosApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_de_Indicioss == null) { result.Detalle_de_Indicioss = new List <Detalle_de_Indicios>(); } var data = result.Detalle_de_Indicioss.Select(m => new Detalle_de_IndiciosGridModel { Clave = m.Clave , Numero_de_Indicio = m.Numero_de_Indicio , Nombre_de_Indicio = m.Nombre_de_Indicio , Descripcion_de_Indicio = m.Descripcion_de_Indicio , Motivo_de_Indicio = m.Motivo_de_Indicio , DiligenciaServicio = (string)m.Diligencia_Servicios_Periciales.Servicio , Ubicacion = m.Ubicacion , EstatusDescripcion = (string)m.Estatus_Estatus_de_Indicio.Descripcion }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_de_IndiciosList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_de_IndiciosList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public bool TryLoadFromClipboard(GraphViewModel item) { if (item == null) { throw new ArgumentNullException(nameof(item)); } var text = Clipboard.GetText().Trim(); if (string.IsNullOrEmpty(text)) { return(false); } var csv = text.Split(new[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries); var points = CsvConverter.ToPointList(csv); if (points.Count == 0) { return(false); } item.Points.Clear(); foreach (var point in points) { item.Points.Add(point); } return(true); }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_de_Historial_de_Emergencia_CCApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_de_Historial_de_Emergencia_CCPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_de_Historial_de_Emergencia_CCApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_de_Historial_de_Emergencia_CCs == null) { result.Detalle_de_Historial_de_Emergencia_CCs = new List <Detalle_de_Historial_de_Emergencia_CC>(); } var data = result.Detalle_de_Historial_de_Emergencia_CCs.Select(m => new Detalle_de_Historial_de_Emergencia_CCGridModel { Clave = m.Clave , Fecha = (m.Fecha == null ? string.Empty : Convert.ToDateTime(m.Fecha).ToString(ConfigurationProperty.DateFormat)) , Hora = m.Hora , Latitud = m.Latitud , Longitud = m.Longitud , Estatus = m.Estatus , Comentarios = m.Comentarios , Usuario_que_registra = m.Usuario_que_registra }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_de_Historial_de_Emergencia_CCList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_de_Historial_de_Emergencia_CCList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
private static void ConvertMidiFileToFromCsv(MidiFileCsvConversionSettings settings) { var tempPath = Path.GetTempPath(); var outputDirectory = Path.Combine(tempPath, Guid.NewGuid().ToString()); Directory.CreateDirectory(outputDirectory); try { foreach (var filePath in TestFilesProvider.GetValidFilesPaths()) { var midiFile = MidiFile.Read(filePath); var outputFilePath = Path.Combine(outputDirectory, Path.GetFileName(Path.ChangeExtension(filePath, "csv"))); var csvConverter = new CsvConverter(); csvConverter.ConvertMidiFileToCsv(midiFile, outputFilePath, true, settings); var convertedFile = csvConverter.ConvertCsvToMidiFile(outputFilePath, settings); MidiAsserts.AreFilesEqual(midiFile, convertedFile, true, $"Conversion of '{filePath}' is invalid."); } } finally { Directory.Delete(outputDirectory, true); } }
public async Task <IActionResult> Import(TaxRateImportForm model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var inputStream = model.CsvFile.OpenReadStream(); var records = CsvConverter.ReadCsvStream <TaxRateImport>(model.CsvFile.OpenReadStream(), model.IncludeHeader, model.CsvDelimiter); foreach (var record in records) { var stateOrProvince = _stateOrProvinceRepository.Query().FirstOrDefault(x => x.Name == record.StateOrProvinceName); var taxRate = new TaxRate { TaxClassId = record.TaxClassId, CountryId = record.CountryId, StateOrProvince = stateOrProvince, ZipCode = record.ZipCode, Rate = record.Rate }; _taxRateRepository.Add(taxRate); } await _taxRateRepository.SaveChangesAsync(); return(NoContent()); }
private static MidiFile ConvertCsvToMidiFile( MidiFileCsvLayout layout, TimeSpanType timeType, string[] csvLines, NoteFormat noteFormat = NoteFormat.Events, NoteNumberFormat noteNumberFormat = NoteNumberFormat.NoteNumber, TimeSpanType noteLengthType = TimeSpanType.Midi) { var filePath = Path.GetTempFileName(); File.WriteAllLines(filePath, csvLines); var settings = new MidiFileCsvConversionSettings { CsvLayout = layout, TimeType = timeType, NoteFormat = noteFormat, NoteNumberFormat = noteNumberFormat, NoteLengthType = noteLengthType }; try { var midiFile = new CsvConverter().ConvertCsvToMidiFile(filePath, settings); ConvertMidiFileToFromCsv(midiFile, filePath, settings); return(midiFile); } finally { File.Delete(filePath); } }
private static void ConvertCsvToNotes( IEnumerable <NoteWithCustomTimeAndLength> expectedNotes, TempoMap tempoMap, TimeSpanType timeType, string[] csvLines, NoteNumberFormat noteNumberFormat = NoteNumberFormat.NoteNumber, TimeSpanType noteLengthType = TimeSpanType.Midi, char delimiter = ',') { var filePath = Path.GetTempFileName(); File.WriteAllLines(filePath, csvLines); var settings = new NoteCsvConversionSettings { TimeType = timeType, NoteNumberFormat = noteNumberFormat, NoteLengthType = noteLengthType }; settings.CsvSettings.CsvDelimiter = delimiter; try { var actualNotes = new CsvConverter().ConvertCsvToNotes(filePath, tempoMap, settings).ToList(); _noteMethods.AssertCollectionsAreEqual(expectedNotes.Select(n => n.GetNote(tempoMap)), actualNotes); ConvertNotesToFromCsv(actualNotes, tempoMap, filePath, settings); } finally { File.Delete(filePath); } }
/// <summary> /// Save Vn Characters to db /// </summary> /// <param name="characters"></param> /// <param name="vnid"></param> public static void SaveVnCharacters(ICollection <Character> characters, uint vnid) { try { if (characters == null || characters.Count < 1) { return; } var cred = CredentialManager.GetCredentials(App.CredDb); if (cred == null || cred.UserName.Length < 1) { return; } using (var db = new LiteDatabase($"{App.GetDbStringWithoutPass}'{cred.Password}'")) { var dbCharInfo = db.GetCollection <VnCharacterInfo>(DbVnCharacter.VnCharacter.ToString()); ILiteCollection <VnCharacterTraits> dbCharTraits = db.GetCollection <VnCharacterTraits>(DbVnCharacter.VnCharacter_Traits.ToString()); if (characters.Count > 0) { List <VnCharacterInfo> vnCharactersList = new List <VnCharacterInfo>(); List <VnCharacterTraits> vnCharacterTraitsList = new List <VnCharacterTraits>(); foreach (Character vnCharacter in characters) { var prevVnCharacter = dbCharInfo.Query().Where(x => x.CharacterId == vnCharacter.Id); var character = prevVnCharacter.FirstOrDefault() ?? new VnCharacterInfo(); character.VnId = vnid; character.CharacterId = vnCharacter.Id; character.Name = vnCharacter.Name; character.Original = vnCharacter.OriginalName; character.Gender = vnCharacter.Gender.ToString(); character.BloodType = vnCharacter.BloodType.ToString(); character.Age = vnCharacter.Age.ToString(); character.Birthday = SimpleDateConverter.ConvertSimpleDate(vnCharacter.Birthday); character.Aliases = CsvConverter.ConvertToCsv(vnCharacter.Aliases); character.Description = vnCharacter.Description; character.ImageLink = !string.IsNullOrEmpty(vnCharacter.Image) ? vnCharacter.Image : string.Empty; character.ImageRating = vnCharacter.ImageRating; character.Bust = Convert.ToInt32(vnCharacter.Bust, CultureInfo.InvariantCulture); character.Waist = Convert.ToInt32(vnCharacter.Waist, CultureInfo.InvariantCulture); character.Hip = Convert.ToInt32(vnCharacter.Hip, CultureInfo.InvariantCulture); character.Height = Convert.ToInt32(vnCharacter.Height, CultureInfo.InvariantCulture); character.Weight = Convert.ToInt32(vnCharacter.Weight, CultureInfo.InvariantCulture); vnCharactersList.Add(character); vnCharacterTraitsList.AddRange(FormatVnCharacterTraits(vnCharacter, dbCharTraits)); } dbCharInfo.Upsert(vnCharactersList); dbCharTraits.Upsert(vnCharacterTraitsList); } } } catch (Exception e) { App.Logger.Error(e, "Failed to save VnCharacters"); SentryHelper.SendException(e, null, SentryLevel.Error); } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_de_ResultadosApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_de_ResultadosPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_de_ResultadosApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_de_Resultadoss == null) { result.Detalle_de_Resultadoss = new List <Detalle_de_Resultados>(); } var data = result.Detalle_de_Resultadoss.Select(m => new Detalle_de_ResultadosGridModel { Clave = m.Clave , Nombre = m.Nombre , Apellido_Paterno = m.Apellido_Paterno , Apellido_Materno = m.Apellido_Materno , Fecha_Nacimiento = (m.Fecha_Nacimiento == null ? string.Empty : Convert.ToDateTime(m.Fecha_Nacimiento).ToString(ConfigurationProperty.DateFormat)) , SexoDescripcion = (string)m.Sexo_Genero.Descripcion , NacionalidadNacionalidadC = (string)m.Nacionalidad_Nacionalidad.NacionalidadC }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_de_ResultadosList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_de_ResultadosList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_de_Sentencias_Imputado_MPIApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_de_Sentencias_Imputado_MPIPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_de_Sentencias_Imputado_MPIApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_de_Sentencias_Imputado_MPIs == null) { result.Detalle_de_Sentencias_Imputado_MPIs = new List <Detalle_de_Sentencias_Imputado_MPI>(); } var data = result.Detalle_de_Sentencias_Imputado_MPIs.Select(m => new Detalle_de_Sentencias_Imputado_MPIGridModel { Clave = m.Clave , DelitoDescripcion = (string)m.Delito_Delito.Descripcion , SentenciaDescripcion = (string)m.Sentencia_Sentencia.Descripcion , Fecha_de_Devolucion = (m.Fecha_de_Devolucion == null ? string.Empty : Convert.ToDateTime(m.Fecha_de_Devolucion).ToString(ConfigurationProperty.DateFormat)) , Hora_de_Devolucion = m.Hora_de_Devolucion , Repacion_del_Dano = m.Repacion_del_Dano , Resolucion = m.Resolucion }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_de_Sentencias_Imputado_MPIList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_de_Sentencias_Imputado_MPIList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_Aseguramiento_PirateriaApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_Aseguramiento_PirateriaPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_Aseguramiento_PirateriaApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_Aseguramiento_Piraterias == null) { result.Detalle_Aseguramiento_Piraterias = new List <Detalle_Aseguramiento_Pirateria>(); } var data = result.Detalle_Aseguramiento_Piraterias.Select(m => new Detalle_Aseguramiento_PirateriaGridModel { Clave = m.Clave , Motivo_de_RegistroDescripcion = (string)m.Motivo_de_Registro_Motivo_de_Registro.Descripcion , TipoDescripcion = (string)m.Tipo_Tipo_de_Pirateria.Descripcion , Descripcion = m.Descripcion , Cantidad = m.Cantidad , Unidad_de_MedicionDescripcion = (string)m.Unidad_de_Medicion_Unidad_de_Medida_de_pirateria.Descripcion , Observaciones = m.Observaciones }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_Aseguramiento_PirateriaList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_Aseguramiento_PirateriaList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_de_Coincidencias_MPIApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_de_Coincidencias_MPIPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_de_Coincidencias_MPIApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_de_Coincidencias_MPIs == null) { result.Detalle_de_Coincidencias_MPIs = new List <Detalle_de_Coincidencias_MPI>(); } var data = result.Detalle_de_Coincidencias_MPIs.Select(m => new Detalle_de_Coincidencias_MPIGridModel { Clave = m.Clave , Nombre_Completo = m.Nombre_Completo , Alias = m.Alias , Numero_de_Expediente = m.Numero_de_Expediente , NUAT = m.NUAT , NUC = m.NUC , Rol = m.Rol }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_de_Coincidencias_MPIList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_de_Coincidencias_MPIList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _ISpartan_Format_FieldApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Spartan_Format_FieldPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _ISpartan_Format_FieldApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Spartan_Format_Fields == null) { result.Spartan_Format_Fields = new List <Spartan_Format_Field>(); } var data = result.Spartan_Format_Fields.Select(m => new Spartan_Format_FieldGridModel { FormatFieldId = m.FormatFieldId , Field_Path = m.Field_Path , Physical_Field_Name = m.Physical_Field_Name , Logical_Field_Name = m.Logical_Field_Name , Creation_Hour = m.Creation_Hour , Creation_User = m.Creation_User , Properties = m.Properties }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Spartan_Format_FieldList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Spartan_Format_FieldList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_Examenes_LaboratorioApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_Examenes_LaboratorioPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_Examenes_LaboratorioApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_Examenes_Laboratorios == null) { result.Detalle_Examenes_Laboratorios = new List <Detalle_Examenes_Laboratorio>(); } var data = result.Detalle_Examenes_Laboratorios.Select(m => new Detalle_Examenes_LaboratorioGridModel { Folio = m.Folio , IndicadorIndicador = (string)m.Indicador_Indicadores_Laboratorio.Indicador , Resultado = m.Resultado , Unidad = m.Unidad , Intervalo_de_Referencia = m.Intervalo_de_Referencia , Fecha_de_Resultado = (m.Fecha_de_Resultado == null ? string.Empty : Convert.ToDateTime(m.Fecha_de_Resultado).ToString(ConfigurationProperty.DateFormat)) , Estatus_Indicador = m.Estatus_Indicador }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_Examenes_LaboratorioList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_Examenes_LaboratorioList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IDetalle_Registro_Beneficiarios_EmpresaApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Detalle_Registro_Beneficiarios_EmpresaPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IDetalle_Registro_Beneficiarios_EmpresaApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Detalle_Registro_Beneficiarios_Empresas == null) { result.Detalle_Registro_Beneficiarios_Empresas = new List <Detalle_Registro_Beneficiarios_Empresa>(); } var data = result.Detalle_Registro_Beneficiarios_Empresas.Select(m => new Detalle_Registro_Beneficiarios_EmpresaGridModel { Folio = m.Folio , Numero_de_Empleado_Titular = m.Numero_de_Empleado_Titular , Numero_de_Empleado = m.Numero_de_Empleado , UsuarioName = (string)m.Usuario_Spartan_User.Name , Activo = m.Activo , SuscripcionNombre_del_Plan = (string)m.Suscripcion_Planes_de_Suscripcion.Nombre_del_Plan , EstatusDescripcion = (string)m.Estatus_Estatus.Descripcion }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Detalle_Registro_Beneficiarios_EmpresaList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Detalle_Registro_Beneficiarios_EmpresaList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _ISpartan_WorkFlow_Matrix_of_StatesApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new Spartan_WorkFlow_Matrix_of_StatesPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _ISpartan_WorkFlow_Matrix_of_StatesApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Spartan_WorkFlow_Matrix_of_Statess == null) { result.Spartan_WorkFlow_Matrix_of_Statess = new List <Spartan_WorkFlow_Matrix_of_States>(); } var data = result.Spartan_WorkFlow_Matrix_of_Statess.Select(m => new Spartan_WorkFlow_Matrix_of_StatesGridModel { Matrix_of_StatesId = m.Matrix_of_StatesId , Visible = m.Visible , Required = m.Required , Read_Only = m.Read_Only , Label = m.Label , Default_Value = m.Default_Value , Help_Text = m.Help_Text }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "Spartan_WorkFlow_Matrix_of_StatesList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "Spartan_WorkFlow_Matrix_of_StatesList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
public void Export(string format, int pageIndex, int pageSize) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); if (!_tokenManager.GenerateToken()) { return; } _IMR_Detalle_PlatilloApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetConfiguration(filter, new MR_Detalle_PlatilloPropertyMapper()); } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IMR_Detalle_PlatilloApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize, configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.MR_Detalle_Platillos == null) { result.MR_Detalle_Platillos = new List <MR_Detalle_Platillo>(); } var data = result.MR_Detalle_Platillos.Select(m => new MR_Detalle_PlatilloGridModel { Folio = m.Folio , IngredienteNombre_Ingrediente = (string)m.Ingrediente_Ingredientes.Nombre_Ingrediente , Cantidad = m.Cantidad , Cantidad_en_Fraccion = m.Cantidad_en_Fraccion , UnidadUnidad = (string)m.Unidad_Unidades_de_Medida.Unidad , Cantidad_a_mostrar = m.Cantidad_a_mostrar , Ingrediente_a_mostrar = m.Ingrediente_a_mostrar }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(), "MR_Detalle_PlatilloList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(), "MR_Detalle_PlatilloList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(), "EmployeeList_" + DateTime.Now.ToString()); break; } }
// TODO Change to AddOrUpdate, not just Add private void SetupTimestampedDataSerialization(CsvSerializerContext serializer, string timestampFieldName) { CsvConverter converter = String.IsNullOrWhiteSpace(timestampFieldName) ? new TimestampedDataCsvConverter() : new TimestampedDataCsvConverter(timestampFieldName); serializer.Converters.Add(converter); }
private static void ProcessListOfItemsToCSV <T>(List <T> listItems, string fullFileName) { using (var file = new StreamWriter(fullFileName)) { var csvString = CsvConverter.Serialize <T>(listItems); file.WriteLine(csvString); } }
private void DrawChart(List <string[]> csvContent) { Dictionary <DateTime, double> csvDictionary = CsvConverter.ConvertToDictionary(csvContent); Predictions.Clear(); DiagrammPainter.UpdateSeries(csvDictionary); }