private void btn_Xoa_Click(object sender, EventArgs e)
{
if (monthCalendar1.SelectedDates.Count > 0 && IsNgayPhep(monthCalendar1.SelectedDates))
{
if (MessageBox.Show("Bạn muốn xoá ngày nghỉ phép cho nhân viên " + oThongTinCNVC.txt_MaNV.Text + " ?", "Hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
Pabo.Calendar.SelectedDatesCollection c = new Pabo.Calendar.SelectedDatesCollection(monthCalendar1);
c = monthCalendar1.SelectedDates;
List <string> delDates = new List <string>();
for (int i = 0; i < c.Count; i++)
{
Pabo.Calendar.DateItem[] dt = monthCalendar1.GetDateInfo(c[i]);
if (dt.Count() > 0 && dt[0].BackColor1 == Color.IndianRed)
{
delDates.Add(dt[0].Date.ToShortDateString());
}
}
oChamCong.Delete(oThongTinCNVC.txt_MaNV.Text, delDates.ToArray());
GetAndBindMonthCalendar();
MessageBox.Show("Xoá thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception)
{
MessageBox.Show("Xoá không thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
void monthCalendar1_DaySelected(object sender, Pabo.Calendar.DaySelectedEventArgs e)
{
Pabo.Calendar.SelectedDatesCollection dates = this.monthCalendar1.SelectedDates;
if (manual_dataset == null)
{
manual_dataset = new BingoGameEvent.GameEventDataSet(StaticDsnConnection.dsn);
DsnSQLUtil.MatchCreate(StaticDsnConnection.dsn, manual_dataset);
}
if (dates.Count > 0)
{
{
List <DateTime> selectedDates = new List <DateTime>();
for (int idx = 0; idx < dates.Count; idx++)
{
selectedDates.Add(dates[idx]);
}
the_day = dates[0];
GetSessions(the_day, selectedDates);
//sessions = BingoGameList.GetPlayedSessions( dates[ 0 ] );
manual_dataset.FillToday(the_day, selectedDates);
}
}
dataGridView1.DataSource = manual_dataset.games;
dataGridView1.Columns["bingo_game_id"].Visible = false;
dataGridView1.Columns["bingoday"].Visible = true;
dataGridView1.Columns["bingoday"].HeaderText = "Date";
dataGridView1.Columns["session"].HeaderText = "Session";
dataGridView1.Columns["session"].Width = 150;
dataGridView1.Columns["game"].HeaderText = "Game";
dataGridView1.Columns["game"].Width = 150;
dataGridView1.Columns["session_id"].Visible = false;
dataGridView1.Columns["game_id"].Visible = false;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.RowHeadersVisible = false;
dataGridView1.ScrollBars = ScrollBars.Vertical;
dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically;
int width = dataGridView1.Width;
width -= dataGridView1.Columns["bingoday"].Width;
width -= dataGridView1.Columns["session"].Width;
width -= dataGridView1.Columns["game"].Width;
width -= dataGridView1.Columns["ballset"].Width;
width -= dataGridView1.Columns["closed_at"].Width;
dataGridView1.Columns["created"].Width = width;
dataGridView1.Columns["created"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
return;
}
// kiem tra xem co ngay nghi phep trong cac ngay chon tren calendar o ?
private bool IsNgayPhep(Pabo.Calendar.SelectedDatesCollection c)
{
for (int i = 0; i < c.Count; i++)
{
Pabo.Calendar.DateItem[] dt = monthCalendar1.GetDateInfo(c[i]);
if (dt.Count() > 0 && dt[0].BackColor1 == Color.IndianRed)
{
return(true);
}
}
return(false);
}
void monthCalendar1_DaySelected(object sender, Pabo.Calendar.DaySelectedEventArgs e)
{
Pabo.Calendar.SelectedDatesCollection dates = this.monthCalendar1.SelectedDates;
sessions = BingoGameList.GetPlayedSessions(dates[0]);
listBoxSessions.Items.Clear();
listBoxSessions.Items.Add("All");
foreach (int session in sessions)
{
listBoxSessions.Items.Add(session);
}
listBoxSessions.SelectedIndex = 0;
//listBoxSessions.DataSource = sessions;
//.SelectionMode = SelectionMode.MultiSimple;
//throw new Exception( "The method or operation is not implemented." );
}
private void button1_Click(object sender, EventArgs e)
{
this.listBoxStatus.Items.Clear();
//this.labelStatus.Text = "Getting selected date...";
Pabo.Calendar.SelectedDatesCollection dates = this.monthCalendar1.SelectedDates;
if (dates.Count == 0)
{
return;
}
/* these tables are part of 'StateWriter' */
/*
* StaticDsnConnection.KindExecuteNonQuery( "DELETE FROM called_game_balls" );
* StaticDsnConnection.KindExecuteNonQuery( "DELETE FROM called_game_player_rank2" );
* StaticDsnConnection.KindExecuteNonQuery( "DELETE FROM called_game_player_pack_status" );
* StaticDsnConnection.KindExecuteNonQuery( "DELETE FROM called_game_card_away_status" );
* StaticDsnConnection.KindExecuteNonQuery( "DELETE FROM called_game_player_away_status" );
* StaticDsnConnection.KindExecuteNonQuery( "DELETE FROM called_game_winning_card_info" );
*/
UpdateStatus("Initializing Rate & Rank Data Tables...");
foreach (DateTime date in dates)
{
int session;
foreach (DataRowView rowView in listBoxSessions.SelectedItems)
{
session = Convert.ToInt32(rowView.Row[2]);
if (timer_gameEventDataSet != null)
{
timer_gameEventDataSet.ClearProcessed(the_day, session);
}
SetupNewSession(date, session);
RunSessions(session);
}
}
}
private void btn_Xoa_Click(object sender, EventArgs e)
{
if (monthCalendar1.SelectedDates.Count > 0 && IsNgayPhep(monthCalendar1.SelectedDates))
{
if (MessageBox.Show("Bạn muốn xoá ngày nghỉ phép cho nhân viên " + oThongTinCNVC.txt_MaNV.Text + " ?", "Hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
Pabo.Calendar.SelectedDatesCollection c = new Pabo.Calendar.SelectedDatesCollection(monthCalendar1);
c = monthCalendar1.SelectedDates;
List<string> delDates = new List<string>();
for (int i = 0; i < c.Count; i++)
{
Pabo.Calendar.DateItem[] dt = monthCalendar1.GetDateInfo(c[i]);
if (dt.Count() > 0 && dt[0].BackColor1 == Color.IndianRed)
delDates.Add(dt[0].Date.ToShortDateString());
}
oChamCong.Delete(oThongTinCNVC.txt_MaNV.Text, delDates.ToArray());
GetAndBindMonthCalendar();
MessageBox.Show("Xoá thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception)
{
MessageBox.Show("Xoá không thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
this.listBoxStatus.Items.Clear();
this.labelStatus.Text = "Getting selected date...";
Pabo.Calendar.SelectedDatesCollection dates = this.monthCalendar1.SelectedDates;
if (dates.Count == 0)
{
return;
}
int session = 0;
all_sessions = false;
if (String.Compare(listBoxSessions.SelectedItem.ToString(), "All", true) == 0)
{
all_sessions = true;
}
else
{
session = Convert.ToInt32(listBoxSessions.SelectedItem.ToString());
}
if (all_sessions)
{
session = 1;
}
while (session > 0)
{
labelStatus2.Text = "Loading session " + session + " on " + dates[0].Date;
this.labelStatus.Text = "Loading bingo game list for session...";
labelStatus.Refresh();
bgl = new BingoGameList();
bgl.Load(dates[0], session);
//PatternEditor pe = new PatternEditor( );
//pe.ShowDialog();
this.labelStatus.Text = "Loading players for session...";
this.listBoxStatus.Items.Add(this.labelStatus.Text);
labelStatus.Refresh();
bp = new BingoPlayers(dates[0], session, bgl);
//BingoCore bc = new BingoCore( DateTime.Now, Convert.ToInt32( this.comboBox1.Text ) );
/*
* List<BingoPack> packs = BingoPack.GetPackList();
* listBoxPacks.DataSource = packs;
*
* if( last_packlist != null )
* foreach( BingoPack pack in last_packlist )
* {
* listBoxPacks.SetSelected( packs.IndexOf( pack ), true );
* }
*/
this.labelStatus.Text = "Select Packs and go...";
this.listBoxStatus.Items.Add(this.labelStatus.Text);
if (all_sessions)
{
/*
* if( last_packlist == null )
* {
* SelectPacks sp = new SelectPacks();
* sp.ShowDialog();
* listBoxPacks.ClearSelected();
* foreach( BingoPack pack in sp.listBoxPacks.SelectedItems )
* {
* listBoxPacks.SetSelected( packs.IndexOf( pack ), true );
* }
* }
*/
this.Refresh();
RunSession();
this.Refresh();
session++;
if (session > sessions.Length)
{
session = 0;
}
}
else
{
RunSession();
session = 0;
}
}
labelStatus.Text = "Complete...";
this.listBoxStatus.Items.Add(this.labelStatus.Text);
labelStatus2.Text = "Complete...";
//BingoGameCore.BingoCore.Load( dates[0].Date, 1 );
}
