private void button5_Click(object sender, EventArgs e)
{
bool first = true;
DbDataReader check_past = StaticDsnConnection.KindExecuteReader("select ID from session_day_sessions where bingoday > cast(now() as date)");
if ((check_past != null) && check_past.HasRows)
{
Console.WriteLine("Sessions scheduled after today, not deleting todays sessions - the computer clock may have been set backwards.\n");
}
else
{
StaticDsnConnection.KindExecuteNonQuery("delete from session_day_sessions where bingoday=cast(now() as date)");
}
StaticDsnConnection.KindExecuteNonQuery("update session_day_sessions set open_for_sales_flag=0");
DbDataReader reader = StaticDsnConnection.KindExecuteReader(
"select session_name,elec_sch_session_macro_session.session_number,bingoday from elec_sch_session_macro_info"
+ " join elec_sch_session_macro_session on elec_sch_session_macro_session.session_macro_info_id=elec_sch_session_macro_info.session_macro_info_id"
+ " join elec_sch_session_info on elec_sch_session_info.session_info_id=elec_sch_session_macro_session.session_info_id"
+ " join session_sales_pages on session_sales_pages.session_number=elec_sch_session_macro_session.session_number"
+ " join session_sales_session_sales_pages using(session_sales_pages_id)"
+ " join session_sales_schedule using(session_sales_info_id)"
+ " where month(month)=month(now()) and bingoday=cast(now() as date)"
+ " order by elec_sch_session_macro_session.session_number"
);
if (reader != null)
{
while (reader.Read())
{
string session_name;
int session_number;
DateTime session_date;
session_name = reader.GetString(0);
session_number = reader.GetInt32(1);
session_date = reader.GetDateTime(2);
long mysql_session_date = (session_date.Year * 10000 + session_date.Month * 100 + session_date.Day);
DbDataReader check_exist = StaticDsnConnection.KindExecuteReader("select ID from session_day_sessions where bingoday='" + mysql_session_date + "' and `session number`=" + session_number);
long ID = 0;
if (check_exist != null && check_exist.HasRows)
{
check_exist.Read();
ID = check_exist.GetInt32(0);
Console.WriteLine("Updating session " + ID + " to " + session_name + "[" + session_number + "] on " + mysql_session_date + "\n");
if (!StaticDsnConnection.KindExecuteNonQuery("replace into session_day_sessions (ID,session_id,`session number`,bingoday,`session name`,open_for_sales_flag,acurals_flag) values ("
+ ID + "," + session_number + "," + session_number + ",'" + mysql_session_date + "','" + session_name + "',1,1)"
))
{
Console.WriteLine("Failed to UPDATE session in session_day_sessions\nfor " + mysql_session_date + "(" + session_name + ") number " + session_number + "\n");
}
}
else
{
Console.WriteLine("Creating session " + session_name + "[" + session_number + "] on " + mysql_session_date + "\n");
ID = StaticDsnConnection.KindExecuteInsert("insert into session_day_sessions (session_id,`session number`,bingoday,`session name`,open_for_sales_flag,acurals_flag) values ("
+ session_number + "," + session_number + ",'" + mysql_session_date + "','" + session_name + "',1,1)");
if (ID == -1)
{
Console.WriteLine("Failed to INSERT session in session_day_sessions\nfor " + mysql_session_date + "(" + session_name + ") number " + session_number + "\n");
}
}
if (first)
{
StaticDsnConnection.KindExecuteNonQuery("update operational_configuration set current_session_id='" + session_number + ",current_bingoday="
+ mysql_session_date + "',current_session_day_sessions_id=" + ID + " where ID=0");
//StaticDsnConnection.KindExecuteNonQuery( "update
first = false;
}
}
}
}
void SetupNewSession(DateTime the_day, DataRow session)
{
StaticDsnConnection.KindExecuteNonQuery("update bingo_game_processed set processed=0 join bingo_game using(bingo_game_id) where bingoday=" + MySQLDataTable.MakeDateOnly(the_day) + " and session=" + session["session"].ToString());
}
