private void GetInfoFromDB()
{
msSQLTransport = new MSSQLTransport();
var regex = new Regex(@"[\d*]{1,}");
var cBIN = entryOrder.clientBIN.Replace(" ", "");
cBIN = regex.Match(cBIN).ToString();
entryOrder.clientBIN = cBIN;
dataSet = msSQLTransport.Execute("select a.* from altair.dbo.companiesView a where a.bin='" + entryOrder.clientBIN + "'");
if (dataSet == null || dataSet.Tables.Count <= 0)
{
return;
}
entryOrder.clientFullName = dataSet.Tables[0].Rows[0].Field <string>("fullName");
entryOrder.clientAddress = dataSet.Tables[0].Rows[0].Field <string>("addrJur");
entryOrder.clientPhones = dataSet.Tables[0].Rows[0].Field <string>("phones");
entryOrder.clientBankIIK = dataSet.Tables[0].Rows[0].Field <string>("iik");
entryOrder.clientBankBIK = dataSet.Tables[0].Rows[0].Field <string>("bik");
dataSet = msSQLTransport.Execute("select a.* from altair.dbo.banksView a where a.bik='" + entryOrder.clientBankBIK + "'");
if (dataSet == null || dataSet.Tables.Count <= 0)
{
return;
}
entryOrder.clientBankName = dataSet.Tables[0].Rows[0].Field <string>("bankName");
}
private void AddRecord()
{
msSQLTransport = new MSSQLTransport();
var regex = new Regex(@"[\d*]{1,}");
string req = "", loc = "";
var cBIN = JournalC01CompanyInfo.bin.Replace(" ", "");
long bankId;
cBIN = regex.Match(cBIN).ToString();
if (!string.IsNullOrEmpty(cBIN))
{
dataSet = msSQLTransport.Execute("select top 1 a.* from altair.dbo.companiesView a where a.bin like '%" + cBIN + "%'");
}
if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
loc = dataSet.Tables[0].Rows[0].Field <string>("addrJur");
bankId = dataSet.Tables[0].Rows[0].Field <long>("bankId");
req = "БИН " + cBIN + "\n";
req += "БИК " + dataSet.Tables[0].Rows[0].Field <string>("bik") + "\n";
req += "Кбе " + dataSet.Tables[0].Rows[0].Field <string>("kbe") + "\n";
req += "ИИК " + dataSet.Tables[0].Rows[0].Field <string>("iik") + "\n";
dataSet = msSQLTransport.Execute("select a.* from altair.dbo.banksView a where a.id='" + bankId + "'");
if (dataSet != null && dataSet.Tables.Count > 0)
{
req += "Банк " + dataSet.Tables[0].Rows[0].Field <string>("bankName") + "\n";
}
}
else
{
req = "Данных в базе не обнаружено";
}
WaitingListTable.Add(new WaitingListTable {
company = "Код клиента: " + SupplierCode + "\n" + SupplierName + "\n Код брокера: " + BrokerCode + "\n" + BrokerName,
bankReq = req,
location = loc
});
}
// Connect to db Ais
private void ConnectToDB()
{
msSQLTransport = new MSSQLTransport();
}
