//[HttpPost(Name = "SearchData")] public async Task <IEnumerable <EngieNotaInformatiovaDataDto> > SearchData([FromBody] SearchEngieDataDto dataDto) { var resReturened = await _readDataService.ReadDataNotaInformativa(_fileType, _notaVerificareExcelFilePath); var query = resReturened.Select(x => x); if (!String.IsNullOrEmpty(dataDto.cod_loc_consum)) { query = query.Where(x => x.cod_loc_consum.ToLower().Contains(dataDto.cod_loc_consum.ToLower())); } if (!String.IsNullOrEmpty(dataDto.nr_inreg_dgsr)) { query = query.Where(x => x.nr_inreg_dgsr.ToLower().Contains(dataDto.nr_inreg_dgsr.ToLower())); } if (!String.IsNullOrEmpty(dataDto.nume_client_final)) { query = query.Where(x => x.nume_client_final.ToLower().Contains(dataDto.nume_client_final.ToLower())); } if (!String.IsNullOrEmpty(dataDto.telefon)) { query = query.Where(x => x.telefon.ToLower().Contains(dataDto.telefon.ToLower())); } return(query.ToList()); }
public void TestInitializate() { //var pathFile = Path.GetFullPath(Directory.GetParent(Directory.GetCurrentDirectory()).Parent.Parent.Parent.FullName) + "\\EngiePOC\\Files\\fisier_date_test_engie_servicii.xlsx"; //configurationSection["ExcelFilePath"] = pathFile; searchEngieData = new SearchEngieDataDto { cod_loc_consum = "DGSBSC100537143", nr_inreg_dgsr = "300020062", nume_client_final = "Ion Ionescu 12", telefon = "0724730799" }; engieData = new EngieNotaInformatiovaDataDto { cod_loc_consum = "DGSBSC100537143", nr_inreg_dgsr = "300020062", nume_client_final = "Ion Ionescu 12", telefon = "0724730799", nr_fisa_evidenta = "13", aparat_debit_1 = "App debit 1", aparat_debit_2 = "App debit 2", aparat_debit_3 = "App debit 3", aparat_debit_4 = "App debit 4", aparat_nr_1 = "App nr 1", aparat_nr_2 = "App nr 2", aparat_nr_3 = "App nr 3", aparat_nr_4 = "App nr 4", aparat_tip_1 = "App tip 1", aparat_tip_2 = "App tip 2", aparat_tip_3 = "App tip 3", aparat_tip_4 = "App tip 4", bloc_scara_apartament = "33-B-18", instalatorul_autorizat_nume_prenume = "Nenea Instalatorulul", localitate_judet = "La tara", numar = "18", reprezentantul_legal_nume_prenume = "No name", strada = "saidac Gheorghe" }; }