private void btnUpdate_Click(object sender, EventArgs e)
{
SEASON_ID = 0;
btnUpdate.UseSelectable = false;
try
{
foreach (DataGridViewRow row in dataGridViewSeason.SelectedRows)
{
SEASON_ID = Convert.ToInt32(row.Cells[0].Value);
}
//MessageBox.Show(SEASON_ID.ToString());
if (SEASON_ID != 0)
{
FormUpdateSeason update = new FormUpdateSeason();
update.ShowDialog(this);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
finally
{
using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS())
{
dataGridViewSeason.DataSource = sda.ShowAllSeasonIncludeInactive();
}
}
}
private void ControlSeason_Load(object sender, EventArgs e)
{
using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS())
{
dataGridViewSeason.DataSource = sda.ShowAllSeasonIncludeInactive();
}
}
private void btnAddNew_Click(object sender, EventArgs e)
{
try
{
btnAddNew.UseSelectable = false;
using (_addseason = new FormAddNewSeason())
{
_addseason.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
GC.Collect();
}
finally
{
using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS())
{
dataGridViewSeason.DataSource = sda.ShowAllSeasonIncludeInactive();
}
GC.Collect();
}
btnAddNew.UseSelectable = false;
}
private void btnDelete_Click(object sender, EventArgs e)
{
SEASON_ID = 0;
try
{
foreach (DataGridViewRow row in dataGridViewSeason.SelectedRows)
{
SEASON_ID = Convert.ToInt32(row.Cells[0].Value);
}
//MessageBox.Show(SEASON_ID.ToString());
if (SEASON_ID != 0)
{
using (LicenseDataContext _context = new LicenseDataContext())
{
TBL_SEASON season = (from s in _context.TBL_SEASONs
where s.SEASON_ID == SEASON_ID
select s).FirstOrDefault();
season.IS_ACTIVE = false;
_context.SubmitChanges();
};
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
GC.Collect();
}
finally
{
using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS())
{
dataGridViewSeason.DataSource = sda.ShowAllSeasonIncludeInactive();
}
}
btnDelete.UseSelectable = false;
}