public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
conn.Open();
DataTable tb = new DataTable();
this.DAOList_ = new List<HOLIDAY_INFO_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = HOLIDAY_INFO_Table_DAOManager.SelectQuery_;
//selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
HOLIDAY_INFO_Table_DAO dao = new HOLIDAY_INFO_Table_DAO();
dao.HOLIDAY_DATE_ = item[0].ToString();
dao.HOLIDAY_NAME_ = item[1].ToString();
dao.HOLIDAY_COUNTRY_NAME_ = item[2].ToString();
dao.HOLIDAY_CURRENCY_CODE_ = item[3].ToString();
dao.HOLIDAY_TYPE_ = item[4].ToString();
dao.USING_START_DATE_ = item[5].ToString();
dao.USING_END_DATE_ = item[6].ToString();
dao.DESCRIPTION_ = item[7].ToString();
this.DAOList_.Add(dao);
}
}
public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
DataTable tb = new DataTable();
this.DAOList_ = new List <HOLIDAY_INFO_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = HOLIDAY_INFO_Table_DAOManager.SelectQuery_;
//selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
HOLIDAY_INFO_Table_DAO dao = new HOLIDAY_INFO_Table_DAO();
dao.HOLIDAY_DATE_ = item[0].ToString();
dao.HOLIDAY_NAME_ = item[1].ToString();
dao.HOLIDAY_COUNTRY_NAME_ = item[2].ToString();
dao.HOLIDAY_CURRENCY_CODE_ = item[3].ToString();
dao.HOLIDAY_TYPE_ = item[4].ToString();
dao.USING_START_DATE_ = item[5].ToString();
dao.USING_END_DATE_ = item[6].ToString();
dao.DESCRIPTION_ = item[7].ToString();
this.DAOList_.Add(dao);
}
}
public void removeHoliday(DateTime d)
{
try
{
HOLIDAY_INFO_Table_DAO dao = new HOLIDAY_INFO_Table_DAO();
dao.HOLIDAY_DATE_ = StringConverter.dbDateTimeToDateString(d);
dao.HOLIDAY_COUNTRY_NAME_ = this.calendarName_;
dao.delete(DataBaseConnectManager.ConnectionFactory("myDB"));
this.dataReload();
}
catch (Exception e)
{
OutputLogViewModel.addResult("remove fail : " + d.ToString("yyyyMMdd") + " " + e.Message);
throw;
}
}
public void addHoliday(DateTime d, string description)
{
try
{
HOLIDAY_INFO_Table_DAO dao = new HOLIDAY_INFO_Table_DAO();
dao.HOLIDAY_COUNTRY_NAME_ = this.calendarName_;
dao.HOLIDAY_CURRENCY_CODE_ = this.calendarName_;
dao.HOLIDAY_DATE_ = StringConverter.dbDateTimeToDateString(d);
dao.HOLIDAY_NAME_ = description;
dao.HOLIDAY_TYPE_ = "";
dao.USING_START_DATE_ = "19000101";
dao.USING_END_DATE_ = "21001231";
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
this.dataReload();
}
catch (Exception e)
{
OutputLogViewModel.addResult("add fail : " + d.ToString("yyyyMMdd") + " " + e.Message);
throw;
}
}
public void addHoliday(DateTime d, string description)
{
try
{
HOLIDAY_INFO_Table_DAO dao = new HOLIDAY_INFO_Table_DAO();
dao.HOLIDAY_COUNTRY_NAME_ = this.calendarName_;
dao.HOLIDAY_CURRENCY_CODE_ = this.calendarName_;
dao.HOLIDAY_DATE_ = StringConverter.dbDateTimeToDateString(d);
dao.HOLIDAY_NAME_ = description;
dao.HOLIDAY_TYPE_ = "";
dao.USING_START_DATE_ = "19000101";
dao.USING_END_DATE_ = "21001231";
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
this.dataReload();
}
catch (Exception e)
{
OutputLogViewModel.addResult("add fail : " + d.ToString("yyyyMMdd") + " " + e.Message);
throw;
}
}
public void removeHoliday(DateTime d)
{
try
{
HOLIDAY_INFO_Table_DAO dao = new HOLIDAY_INFO_Table_DAO();
dao.HOLIDAY_DATE_ = StringConverter.dbDateTimeToDateString(d);
dao.HOLIDAY_COUNTRY_NAME_ = this.calendarName_;
dao.delete(DataBaseConnectManager.ConnectionFactory("myDB"));
this.dataReload();
}
catch (Exception e)
{
OutputLogViewModel.addResult("remove fail : " + d.ToString("yyyyMMdd") + " " + e.Message);
throw;
}
}
