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