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);
}
