public static void ImportCodes_to_ElasticDB() { string folder = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName; string filePath = Path.Combine(folder, "Excel\\codes.xlsx"); bool hasHeader = true; string bicholder = ""; DataTable excelData = null; try { excelData = ExcelUtils.getDataFromExcelFileMM(filePath, hasHeader); } catch (Exception ex) { filePath = Path.Combine(folder, "Excel\\codes.xls"); } excelData = ExcelUtils.getDataFromExcelFileMM(filePath, hasHeader); List <Bic_Iban_Codes> CodesForImportL = new List <Bic_Iban_Codes>(); foreach (System.Data.DataRow item in excelData.Rows) { int bla = 0; //string[] data = item.ItemArray[0].ToString(); Bic_Iban_Codes CodesForImport = new Bic_Iban_Codes(); CodesForImport.IbanPar = item.ItemArray[0].ToString(); CodesForImport.CodeID = Guid.NewGuid().ToString(); CodesForImport.BankName = item.ItemArray[2].ToString(); if (item.ItemArray[7].ToString() == "") { CodesForImport.bic = bicholder; } else { CodesForImport.bic = item.ItemArray[7].ToString(); } bicholder = CodesForImport.bic; CodesForImportL.Add(CodesForImport); bla++; } string indexName = "validation"; Import_IBAN_BIC_Data_to_ElasticDB(CodesForImportL, indexName); }
public static List <Bic_Iban_Codes> CheckBicBank(Bic_Parameter BicParametar, SessionSecurityTicket securityTicket) { // var TenantID = securityTicket.TenantID.ToString(); var serializer = new JsonNetSerializer(); var connection = Elastic_Utils.ElsaticConnection(); string queryS = string.Empty; string elasticType = "iban_bic"; var index = "validation"; List <Bic_Iban_Codes> modelBicIBanL = new List <Bic_Iban_Codes>(); if (Elastic_Utils.IfIndexOrTypeExists(index, connection) && Elastic_Utils.IfIndexOrTypeExists(index + "/" + elasticType, connection)) { var query = new QueryBuilder <Bic_Iban_Codes>() .From(0) .Size(100) .Query(q => q .Bool(b => b .Should(sh => sh .Match(m => m .Field("bic") .Query(BicParametar.Bic).Operator(PlainElastic.Net.Operator.AND) ) ) )); queryS = query.BuildBeautified(); string searchCommand_Doctors_PracticeID = Commands.Search(index, elasticType).Pretty(); string result = connection.Post(searchCommand_Doctors_PracticeID, queryS); var foundResults_Doctors = serializer.ToSearchResult <Bic_Iban_Codes>(result); foreach (var item in foundResults_Doctors.Documents) { Bic_Iban_Codes modelBicIBan = new Bic_Iban_Codes(); modelBicIBan.BankName = item.BankName; modelBicIBan.bic = item.bic; modelBicIBan.IbanPar = item.IbanPar; modelBicIBanL.Add(modelBicIBan); } } return(modelBicIBanL); }