private void cboSeason_SelectedIndexChanged(object sender, EventArgs e)
{
using (sda = new TBL_SEASON_DATA_ACCESS())
{
foreach (var item in sda.ShowSeason(Convert.ToInt32(cboSeason.SelectedValue)))
{
lblRemainNumber.Text = item.REMAIN_LICENSE.ToString();
}
dataGridViewSurvey.DataSource = sda.ShowSurvey(Convert.ToInt32(cboSeason.SelectedValue));
}
}
private void ControlWork_Load(object sender, EventArgs e)
{
cboSeason.SelectedIndexChanged -= new EventHandler(cboSeason_SelectedIndexChanged);
TBL_SCHEDULE_DATA_ACCESS sda = new TBL_SCHEDULE_DATA_ACCESS();
TBL_SEASON_DATA_ACCESS seda = new TBL_SEASON_DATA_ACCESS();
cboSeason.DataSource = seda.ShowSeason();
cboSeason.DisplayMember = "SEASON_NAME";
cboSeason.ValueMember = "SEASON_ID";
dataGridViewGenerate.DataSource = sda.DisplayToGenerate(Convert.ToInt32(cboSeason.SelectedValue));
cboSeason.SelectedIndexChanged += new EventHandler(cboSeason_SelectedIndexChanged);
}
public void ckShowAllSeason_CheckedChanged(object sender, EventArgs e)
{
// by Sieng Sotheara 2016-4-28
if (ckShowAllSeason.Checked == true)
{
using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS())
{
DataTable dt = new DataTable();
dt.Columns.Add("SEASON_ID");
dt.Columns.Add("SEASON_NAME");
DataRow row1 = dt.NewRow();
row1[0] = 0;
row1[1] = Properties.Resources.ALL_SEASON;
dt.Rows.Add(row1);
foreach (var item in sda.ShowAllSeason())
{
DataRow row = dt.NewRow();
row[0] = item.SEASON_ID;
row[1] = item.SEASON_NAME;
dt.Rows.Add(row);
}
cboSeason.DataSource = dt;
cboSeason.DisplayMember = "SEASON_NAME";
cboSeason.ValueMember = "SEASON_ID";
};
}
else
{
using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS())
{
cboSeason.DataSource = sda.ShowSeason();
};
}
GC.Collect();
}