public static void AddBusinessDescriptions(BusinessDescriptions cCompanyInfos)
{
const string cmdInsert = "insert into [BusinessDescription$] (identifier,DescENG,DescTHA) values (@identifier,@DescENG,@DescTHA);";
#region Variables
List <DataTable> tables = new List <DataTable>();
string connectionString = string.Format(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;""",
ConfigurationManager.AppSettings["EXCEL_PATH"]
);
#endregion Variables
List <string> commands = new List <string>();
/*Update data*/
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
if (connection.State != System.Data.ConnectionState.Closed)
{
connection.Close();
}
connection.Open();
try
{
var i = cCompanyInfos;
string iTHA = string.Empty;
string iENG = string.Empty;
foreach (var j in i.BusinessDescription.MediumDescription)
{
switch (j.LanguageCode)
{
case "THA":
iTHA = j.Value;
break;
case "ENG":
iENG = j.Value;
break;
}
}
OleDbCommand cmd = new OleDbCommand(cmdInsert, connection);
cmd.Parameters.AddWithValue("@exchangeId", i.GeneralInfo.ExchangeId);
cmd.Parameters.AddWithValue("@identifier", i.GeneralInfo.Symbol);
cmd.Parameters.AddWithValue("@DescENG", iENG);
cmd.Parameters.AddWithValue("@DescTHA", iTHA);
int result = (int)cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
static void Main(string[] args)
{
DataTable tbl = GetData();
Console.WriteLine("Engine started.");
com.morningstar.equityapi1.InvestorRelationsService srv = new com.morningstar.equityapi1.InvestorRelationsService();
foreach (DataRow i in tbl.Rows)
{
if ((i["identifier"] is System.DBNull))
{
continue;
}
object iExchangeId = "";
if (args.Contains(P_INDUSTRY_GROUP))
{
try
{
CompanyInfos cInfo = srv.GetCompanyGeneralInformation(
i["ExchangeId"].ToString(),
CompanyInfoIdentifierType.Symbol,
i["identifier"].ToString());
AddCompanyInfos(cInfo);
}
catch (Exception ex) {}
}
if (args.Contains(P_BUSINESS_DESCRIPTION))
{
try
{
BusinessDescriptions iBuissInfo = srv.GetBusinessDescription(
i["ExchangeId"].ToString(),
BusinessDescriptionIdentifierType.Symbol,
i["identifier"].ToString()
);
AddBusinessDescriptions(iBuissInfo);
}
catch (Exception ex) {}
}
Console.WriteLine("Loaded {0}", i["identifier"]);
}
Process.Start(ConfigurationManager.AppSettings["EXCEL_PATH"]);
Console.ReadKey();
}
