//[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"
};
}
