private void button_DownloadEarning_Click(object sender, EventArgs e)
{
db_manager.DBConnect();
CompanyProfilePage cpp = new CompanyProfilePage();
// cpp.DownloadEarningInfoAll(db_manager.getConnection(), "2379"); //from 98-102. profit margin
cpp.DownloadEpsInfo(db_manager.getConnection(), "2379", 100, 1); //eps
cpp.DownloadMonthRevenue(db_manager.getConnection(), "2379", 100, 1); //revenue
cpp.DownloadEpsInfo(db_manager.getConnection(), "2379", 102, 1); //eps
cpp.DownloadMonthRevenue(db_manager.getConnection(), "2379", 102, 1); //revenue
int rev = cpp.GetMonthRevenue(db_manager.getConnection(), "2379", 102, 1);
EarningInfo ei = cpp.GetSeasonEarning(db_manager.getConnection(), "2379", 102, 1);
YearSeasonMonth ysm = cpp.GetLatestRevenueInfoDate(db_manager.getConnection(), "2379");
ysm = cpp.GetLatestEarningInfoDate(db_manager.getConnection(), "2379");
}
public EarningInfo GetSeasonEarning(MySqlConnection conn, String stock_index, int year, int season)
{
EarningInfo res = new EarningInfo();
string qstr = "SELECT * FROM " + companyEarning_db_name + " WHERE stock_index=\'" + stock_index + "\' and year=" + String.Format("{0}", year) + " and season=" + String.Format("{0}", season) + ";";
MySqlCommand cmd = new MySqlCommand(qstr, conn);
MySqlDataReader rdr = null;
try
{
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
res.grossProfitMargin = rdr.GetDouble(rdr.GetOrdinal("grossProfitMargin"));
res.operatingProfitMargin = rdr.GetDouble(rdr.GetOrdinal("operatingProfitMargin"));
res.netProfitMarginBeforeTax = rdr.GetDouble(rdr.GetOrdinal("netProfitMarginBeforeTax"));
res.netProfitMargin = rdr.GetDouble(rdr.GetOrdinal("netProfitMargin"));
if (rdr.IsDBNull(rdr.GetOrdinal("eps")) == false)
{
res.eps = rdr.GetDouble(rdr.GetOrdinal("eps"));
}
}
else
{
res = null;
}
}
catch (Exception ex)
{
Logger.e("GetSeasonEarning:" + stock_index + "(" + year + "," + season + ") failed");
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
return(res);
}