public void getSubCategoryModelFromExcel() { //var resourcePath = "ExcelClient.Tests.TestData.Transactions.xlxs"; var resourcePath = "ExcelClient.Tests.TestData.Categories.xlsx"; var assembly = Assembly.GetExecutingAssembly(); Stream resourceAsStream = assembly.GetManifestResourceStream(resourcePath); //var file = "Transactions.xlxs"; var file = "Categories.xlsx"; var savedFilePath = Path.Combine(Directory.GetCurrentDirectory() + @"..\..\..\..\TestData\", file); var name = Path.GetFileNameWithoutExtension(savedFilePath); var fi = new FileInfo(savedFilePath); ExcelPackage ep = new ExcelPackage(new FileInfo(savedFilePath)); ExcelPackage ep1 = new ExcelPackage(resourceAsStream); //ExcelPackage ep = new ExcelPackage(new FileInfo(resourcePath)); ExcelWorksheet workSheet = ep.Workbook.Worksheets.FirstOrDefault(); ExcelWorksheet workSheet1 = ep1.Workbook.Worksheets.FirstOrDefault(); var json = ExcelServices.GetJsonFromTable(workSheet); var json1 = ExcelServices.GetJsonFromTable(workSheet1); var jarray = JArray.Parse(json1); List <SubCategory> subcategories = new List <SubCategory>(); foreach (var subCategory in jarray) { subcategories.Add(JsonServices.GetSubCategory(subCategory)); } var table = workSheet.Tables.FirstOrDefault(); json.Should().NotBeNull(); }
JsonMessage <M> DecodeMessage(byte[] body) { var info = JsonServices.ToObject <MessageInfo>(Encoding.UTF8.GetString(body)); var message = JsonMessage <M> .FromInfo(info); return(message); }
public JsonServices ClearanceServices() { JsonServices jsonServices = new JsonServices(); List <ServicesViewModel> ClearanceServicesOBJ = new List <ServicesViewModel>(); try { var Cleaaance = _place.ServicesTypeClearance(); foreach (var item in Cleaaance) { ServicesViewModel ClearanceObj = new ServicesViewModel(); //Places ClearanceObj.Name = item.Name; ClearanceObj.Phone = item.PhoneNumber; //link ClearanceObj.Title = _link.FindById(item.Id).Title; ClearanceObj.Description = _link.FindById(item.Id).Description; ClearanceObj.Icon = _link.FindById(item.Id).Icon; //address ClearanceObj.LocationX = _address.FindById(item.Id).LocationX; ClearanceObj.LocationX = _address.FindById(item.Id).LocationY; ClearanceObj.LocationX = _address.FindById(item.Id).LocationR; ClearanceServicesOBJ.Add(ClearanceObj); } jsonServices.Result = ClearanceServicesOBJ; return(jsonServices); } catch (Exception ex) { _ = ex.Message; return(jsonServices); } }
public JsonServices AnimalsServices() { JsonServices jsonServices = new JsonServices(); List <ServicesViewModel> AnimalsServicesOBJ = new List <ServicesViewModel>(); try { var animal = _place.ServicesTypeAnimal(); foreach (var item in animal) { ServicesViewModel AnimalsObj = new ServicesViewModel(); //Places AnimalsObj.Name = item.Name; AnimalsObj.Phone = item.PhoneNumber; //link AnimalsObj.Title = _link.FindById(item.Id).Title; AnimalsObj.Description = _link.FindById(item.Id).Description; AnimalsObj.Icon = _link.FindById(item.Id).Icon; //address AnimalsObj.LocationX = _address.FindById(item.Id).LocationX; AnimalsObj.LocationX = _address.FindById(item.Id).LocationY; AnimalsObj.LocationX = _address.FindById(item.Id).LocationR; AnimalsServicesOBJ.Add(AnimalsObj); } jsonServices.Result = AnimalsServicesOBJ; return(jsonServices); } catch (Exception ex) { _ = ex.Message; return(jsonServices); } }
public void LstJson01() { var input = list(1, 2, 3, 4, 5); var json = JsonServices.ToJson(input); var output = JsonServices.ToObject <Lst <int> >(json); claim.equal(input, output); }
public AgreementOperationsRepository( ITransformationRepository transformationRepository, JsonServices jsonServices, XmlServices xmlServices) { _jsonServices = jsonServices; _xmlServices = xmlServices; _transformationRepository = transformationRepository; }
public void LstJson05() { var syn = Synthetic.Create(RandomSeed.Seed01); var input = syn.Next <string>(500); var json = JsonServices.ToJson(input); var output = JsonServices.ToObject <Lst <string> >(json); claim.equal(input, output); }
public ConfiguracoesController(IDomainNotificationHandler notification, IMapper mapper, IUserAppServices userappService, IRegisterAppService registerAppService, IQueryAppService localsAppService, JsonServices jsonService) : base(notification, userappService) { _registerAppService = registerAppService; _localsAppService = localsAppService; _jsonService = jsonService; _mapper = mapper; }
public static void ImportComponentSettings(this IConfigurationStore store, string environment, string component, string path) { if (isBlank(environment) || isBlank(component)) { throw new ArgumentException("Both environment and component must be specified"); } var settings = JsonServices.FromObjectFile <ComponentConfigurationSet>(path).Settings; store.SaveComponentSettings(settings); }
public static Service[] BuscarServicios(string token) { Response respuestaServicio; respuestaServicio = TicoPayDll.Services.ServiceController.GetServices(token).GetAwaiter().GetResult(); if (respuestaServicio.status == ResponseType.Ok) { JsonServices impuestos = JsonConvert.DeserializeObject <JsonServices>(respuestaServicio.result); return(impuestos.listObjectResponse); } else { Console.WriteLine(respuestaServicio.message); return(null); } }
public static void ExportComponentSettings(this IConfigurationStore store, string environment, string component, string path) { if (isBlank(environment) || isBlank(component)) { throw new ArgumentException("Both environment and component must be specified"); } var export = new ComponentConfigurationSet { Environment = environment, Component = component, Settings = store.GetComponentSettings(environment, component).ToList() }; JsonServices.ToObjectFile(export, path); }
//-------------------------------------------------------------------------------------Populate info public async Task PopulateJsonPersonViewModel(string fileName) { var personsJson = JsonConvert.DeserializeObject <ObservableCollection <Person> >(await JsonServices.ReadFromJsonFileAsync(fileName)); foreach (var person in personsJson) { viewModel.persons.Add(person); } }
public GerenciaRegrasViewComponent(IQueryAppService appService, JsonServices jsonService) { _appService = appService; _jsonService = jsonService; }
public void UpdateClassesTableValues() { var streamFile = TestsHelper.GetAssemblyFile("Transactions Update With Categories.xlsx"); using (var cashflowExcelPkg = new ExcelPackage(streamFile)) { IEnumerable <string> categoryList = TestsHelper.GetCategoryList(); var expensesWSheet = cashflowExcelPkg.Workbook.Worksheets["Transactions"]; var transactions = expensesWSheet.Tables.FirstOrDefault(); var jsonArray = ExcelConverter.GetJsonFromTable(transactions); var categoriesAverageWorkSheet = cashflowExcelPkg.Workbook.Worksheets["Categories Average"]; var categoriesAverageWorkSheet1 = cashflowExcelPkg.Workbook.Worksheets["Categories Average1"]; if (categoriesAverageWorkSheet != null) { } jsonArray.Count.Should().Be(193); var noko = jsonArray.ToObject <List <MovementsViewModel> >(); List <MovementsViewModel> movementsViewModels = JsonConvert.DeserializeObject <List <MovementsViewModel> >(jsonArray.ToString(), JsonServices.GetJsonSerializerSettings()); movementsViewModels.Count.Should().Be(193); } }
public void CreteCashFlowFromMovements() { var MovementsExcelPkg = new ExcelPackage(GetAssemblyFile("Movements.xlsx")); var WoorSheet = MovementsExcelPkg.Workbook.Worksheets.FirstOrDefault(); var jsonFromTable = ExcelServices.GetJsonFromTable(WoorSheet); MovementsExcelPkg.Dispose(); List <MovementsViewModel> movementsViewModels = JsonConvert.DeserializeObject <List <MovementsViewModel> >(jsonFromTable, JsonServices.GetJsonSerializerSettings()); var categoryList = ModelClassServices.GetListOfCategories(movementsViewModels); //var movements = JsonConvert.DeserializeObject<List<MovementsViewModel>>(jsonFromTable, dateTimeConverter); var excelPkg = new ExcelPackage(GetAssemblyFile("Budget Cashflow.xlsx")); try { var ExpensesWSheet = excelPkg.Workbook.Worksheets["Expenses details"]; var year = 2019; //workSheet.Tables.Delete("YearExpenses"); // add year expenses categoiers ExcelServices.CreateYearExpensesTable(movementsViewModels, categoryList, year, ExpensesWSheet, "YearExpenses", "B38"); // add year incoms categoiers ExcelServices.CreateYearIncomsTable(movementsViewModels, categoryList, year, ExpensesWSheet, "YearIncoms", "B54"); // update Year table //Get Adress to budget table var categoryListWithTotals = Helpers.AddItemsToIenumeration(categoryList, new List <string>() { "Sub Total", "Total" }); var CategoriesAddressWithTotals = ExcelServices.GetColumnsNameAdress(categoryListWithTotals, ExpensesWSheet, "Year_budget"); //Get address to expenses table var CategoriesAddress = ExcelServices.GetColumnsNameAdress(categoryListWithTotals, ExpensesWSheet, "YearExpenses"); //Update year excel table var yearWSheet = excelPkg.Workbook.Worksheets["Year summary"]; ExcelServices.UpdateYearTableValues(CategoriesAddressWithTotals, year, yearWSheet, "tblOperatingExpenses", "BUDGET", "Total"); ExcelServices.UpdateYearTableValues(CategoriesAddress, year, yearWSheet, "tblOperatingExpenses", "ACTUAL", "Total"); // get address to Month budget table var categoriesWithoutIncome = Helpers.DeleteItemsfromIenumeration(categoryList, new List <string>() { "Åse", "Matias" }); var monthBudgetCategoriesAddress = ExcelServices.GetColumnsNameAdress(categoriesWithoutIncome, ExpensesWSheet, "Year_budget"); var monthExpensesCategoriesAddress = ExcelServices.GetColumnsNameAdress(categoriesWithoutIncome, ExpensesWSheet, "YearExpenses"); //update month Table with the categories summary var monthWSheet = excelPkg.Workbook.Worksheets["Monthly summary"]; ExcelServices.UpdateClassesTableValues(monthBudgetCategoriesAddress, monthExpensesCategoriesAddress, year, monthWSheet, "tblOperatingExpenses7"); var categoriesAverageWSheet = excelPkg.Workbook.Worksheets.Add("Categories Average"); new ExcelServices(); ExcelServices.CreateCategoriesAverage(movementsViewModels, categoriesAverageWSheet, categoryList, year, 0, true); } catch (Exception e) { var noko = e.Message; } var filename = "Budget Cashflow With Average 2019"; var path = string.Concat(@"h:\temp\"); Directory.CreateDirectory(path); var filePath = Path.Combine(path, string.Concat(filename, ".xlsx")); excelPkg?.SaveAs(new FileInfo(filePath)); excelPkg.Dispose(); File.Exists(filePath).Should().BeTrue(); }
public static Json ToJson(this IEnumerable <NamedValue> NamedValues) => JsonServices.ToJson(JObject.FromObject(new { NamedValues }));
public EntidadCons(string ruc) { entidad = JsonServices.GET_Entidad(ruc); }
public MoneyCons() { money = JsonServices.GET_Money(); }
Option <T> TryReconsitute <T>(Json J) => Try(() => JsonServices.ToObject <T>(J));
protected override string RenderContent(C content) => JsonServices.ToJson(content);
byte[] Encode(JsonMessage <M> Message) => Encoding.UTF8.GetBytes(JsonServices.ToJson(Message.MessageInfo));
public JsonMessage(string Body, Guid?MessageId = null) : base(typeof(C).Name, JsonServices.ToObject <C>(Body), MessageId) { }
private async void btnCreateJsonFile_Click(object sender, RoutedEventArgs e) { await JsonServices.CreateJsonFileAsync(); await JsonServices.WriteToJsonFileAsync(new Person(tbFirstN.Text, tbLastN.Text, Convert.ToInt32(tbAge.Text), tbEmail.Text)); }
protected override C ParseContent(string content) => JsonServices.ToObject <C>(content);
public static StringContent EncodeJsonContent(this object o) => new StringContent(JsonServices.ToJson(o), Encoding.UTF8, JsonMediaType);
Option <Json> TrySerialize <T>(T Entity) => Try(() => JsonServices.ToJson(Entity));
public GosDuma(string apiToken, string appToken) { _apiToken = apiToken; _appToken = appToken; _service = JsonServices.GetInstance(_apiToken, _appToken); }