private void FormGenerateLicense_Load(object sender, EventArgs e) { try { parent = this.ParentForm as FormMain; cboTake.SelectedIndex = 9; cboUser.SelectedIndex = 0; cboFollowUpBy.SelectedIndex = 0; dateTimePickerLicenseGenerate.MinDate = DateTime.Today; using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS()) { var season_name = sda.ShowSeasonNameByID(ControlWork.SEASON_ID); foreach (var item in season_name) { txtSeason.Text = item.SEASON_NAME.ToString(); SEASON_ID = item.SEASON_ID; } } using (TBL_USER_DATA_ACCESS uda = new TBL_USER_DATA_ACCESS()) { cboUser.DataSource = uda.ShowUserActive(); cboUser.DisplayMember = "USERNAME"; cboUser.ValueMember = "USER_ID"; cboFollowUpBy.DataSource = uda.ShowUserActive(); cboFollowUpBy.DisplayMember = "USERNAME"; cboFollowUpBy.ValueMember = "USER_ID"; } GC.Collect(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } }
private void ControlReportLicenseGenerate_Load(object sender, EventArgs e) { lblHeading.Text = Properties.Resources.REPORT_LICENSE_GENERATE; cboReportName.SelectedIndex = 0; try { using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS()) { cboSeason.DataSource = sda.ShowAllSeasonToComboBox(); cboSeason.DisplayMember = "SEASON_NAME"; cboSeason.ValueMember = "SEASON_ID"; } using (TBL_COMPANY_DATA_ACCESS cda = new TBL_COMPANY_DATA_ACCESS()) { var company = cda.ShowCompany(); foreach (var item in company) { COMPANY_NAME = item.COMPANY_NAME; COMPANY_ADDRESS = item.COMPANY_ADDRESS; } } printer = new PrinterSettings(); crxApp = new CRAXDDRT.Application(); crxReport = new CRAXDDRT.Report(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void FormUpdateSeason_Load(object sender, EventArgs e) { using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS()) { foreach (var item in sda.CheckSeasonWithoutExisting(txtSeasonName.Text)) { SEASON_NAME = item.SEASON_NAME; MessageBox.Show(SEASON_NAME); } } try { using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS()) { foreach (var item in sda.ShowSeasonNameByID(Convert.ToInt32(ControlSeason.SEASON_ID))) { txtSeasonName.Text = item.SEASON_NAME; txtNote.Text = item.NOTE; txtCreateBy.Text = item.CREATE_BY; SEASON_ID = item.SEASON_ID; } } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } GC.Collect(); }
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 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 bool Invalid() { bool flag = false; using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS()) { foreach (var item in sda.CheckSeason(txtSeasonName.Text)) { SEASON_NAME = item.SEASON_NAME; } } if (txtSeasonName.Text == SEASON_NAME) { this.txtSeasonName.SetValidation(string.Format(Properties.Resources.SEASON_AREADY, this.label1.Text)); flag = true; txtSeasonName.Focus(); } if (txtSeasonName.Text == string.Empty) { this.txtSeasonName.SetValidation(string.Format(Properties.Resources.REQUIRED_SEASON, this.label1.Text)); flag = true; txtSeasonName.Focus(); } using (TBL_USER_DATA_ACCESS uda = new TBL_USER_DATA_ACCESS()) { if (!uda.Authentication(cboUser.Text, txtPassword.Text.Trim())) { this.txtPassword.SetValidation(string.Format(Properties.Resources.WRONG_PASSWORD, this.label1.Text)); flag = true; txtPassword.Focus(); } } return(flag); }
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 FormAddNewSeason_Load(object sender, EventArgs e) { try { ListSchedule = new List <int>(); cboUser.SelectedIndex = 0; using (TBL_USER_DATA_ACCESS uda = new TBL_USER_DATA_ACCESS()) { cboUser.DataSource = uda.ShowUserActive(); cboUser.DisplayMember = "USERNAME"; cboUser.ValueMember = "USER_ID"; } using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS()) { foreach (var item in sda.ShowAllLicense()) { ListSchedule.Add(item.LICENSE_ID); } } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } }
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 ControlSurvey_Load(object sender, EventArgs e) { cboSeason.SelectedIndexChanged -= new EventHandler(cboSeason_SelectedIndexChanged); using (sda = new TBL_SEASON_DATA_ACCESS()) { cboSeason.DataSource = sda.ShowAllSeason(); cboSeason.DisplayMember = "SEASON_NAME"; cboSeason.ValueMember = "SEASON_ID"; dataGridViewSurvey.DataSource = sda.ShowSurvey(Convert.ToInt32(cboSeason.SelectedValue)); } cboSeason.SelectedIndexChanged += new EventHandler(cboSeason_SelectedIndexChanged); }
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 btnSave_Click(object sender, EventArgs e) { if (!Invalid()) { try { using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS()) { using (_context = new LicenseDataContext()) { TBL_SEASON season = new TBL_SEASON() { SEASON_NAME = txtSeasonName.Text, CREATE_BY = cboUser.Text, IS_ACTIVE = true, CREATE_DATE = DateTime.Now, NOTE = txtNote.Text.Trim() }; sda.SaveSeason(season); foreach (var item in sda.ShowSeasonNameByName(txtSeasonName.Text)) { SEASON_ID = item.SEASON_ID; } TBL_SCHEDULE schedule = new TBL_SCHEDULE(); foreach (var item in ListSchedule) { schedule.LICENSE_ID = item; schedule.SEASON_ID = SEASON_ID; sda.SaveSchedule(schedule); } this.Close(); }; } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } } else { } }
public bool Invalid() { bool flag = false; using (TBL_SEASON_DATA_ACCESS sda = new TBL_SEASON_DATA_ACCESS()) { foreach (var item in sda.CheckSeasonWithoutExisting(txtSeasonName.Text)) { SEASON_NAME = item.SEASON_NAME; MessageBox.Show(SEASON_NAME); if (txtSeasonName.Text == SEASON_NAME) { this.txtSeasonName.SetValidation(string.Format(Properties.Resources.SEASON_AREADY, this.label1.Text)); flag = true; txtSeasonName.Focus(); } } } return(flag); }
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; }
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(); }