private void ControlSchedule_Load(object sender, EventArgs e)
{
using (TBL_SCHEDULE_DATA_ACCESS sda = new TBL_SCHEDULE_DATA_ACCESS())
{
dataGridViewSchedule.DataSource = sda.AvaibleLicenseToGenerateBySeasonID(1);
};
}
public void cboSeason_SelectedIndexChanged(object sender, EventArgs e)
{
using (TBL_SCHEDULE_DATA_ACCESS sda = new TBL_SCHEDULE_DATA_ACCESS())
{
dataGridViewGenerate.DataSource = sda.DisplayToGenerate(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);
}
private void btnGenerate_Click(object sender, EventArgs e)
{
btnGenerate.UseSelectable = false;
try
{
SEASON_ID = 0;
REMAIN_LICENSE = "";
foreach (DataGridViewRow row in dataGridViewGenerate.SelectedRows)
{
REMAIN_LICENSE = row.Cells[5].Value.ToString();
RESULT = Regex.Match(REMAIN_LICENSE, @"\d+").Value;
SEASON_ID = Convert.ToInt32(row.Cells[0].Value);
}
if (Int32.Parse(RESULT) == 0)
{
var result = MetroMessageBox.Show(this, "សូមអភ័យទោសចំនួនអាជា្ញប័ណ្ឌដែលត្រូវចេញអស់ហើយ ! ", "ពត៏មាន", MessageBoxButtons.OK);
if (result == System.Windows.Forms.DialogResult.OK)
{
}
}
else
{
FormGenerateLicense generate = new FormGenerateLicense();
generate.ShowDialog(this);
GC.Collect();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
using (TBL_SCHEDULE_DATA_ACCESS sda = new TBL_SCHEDULE_DATA_ACCESS())
{
dataGridViewGenerate.DataSource = sda.DisplayToGenerate(Convert.ToInt32(cboSeason.SelectedValue));
}
}
}
