private void btnEdit_Click(object sender, EventArgs e) { //FormUpdateLicense frmupdate = new FormUpdateLicense(); foreach (DataGridViewRow row in dataGridViewLicense.SelectedRows) { LICENSE_NUMBER = row.Cells[1].Value.ToString(); } // MessageBox.Show(LICENSE_NUMBER.ToString()); if (LICENSE_NUMBER != string.Empty) { FormUpdateLicense update = new FormUpdateLicense(); update.ShowDialog(this); } else { } using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { dataGridViewLicense.DataSource = lda.ShowLicense(); } btnEdit.UseSelectable = false; txtSearch.Clear(); GC.Collect(); }
private void btnDelete_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dataGridViewLicense.SelectedRows) { LICENSE_NUMBER = row.Cells[1].Value.ToString(); } // MessageBox.Show(LICENSE_NUMBER); if (LICENSE_NUMBER == string.Empty || LICENSE_NUMBER == null) { } else { var result = MetroMessageBox.Show(this, "Are you sure to delete it?", "Delete", MessageBoxButtons.OKCancel); if (result == System.Windows.Forms.DialogResult.OK) { using (LicenseDataContext _context = new LicenseDataContext()) { TBL_LICENSE license = (from l in _context.TBL_LICENSEs where l.ACCOUNT_NO == LICENSE_NUMBER select l).FirstOrDefault(); license.IS_ACTIVE = false; _context.SubmitChanges(); } using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { dataGridViewLicense.DataSource = lda.ShowLicense(); } GC.Collect(); } } GC.Collect(); }
private void FormEditSpecialLicense_Load(object sender, EventArgs e) { try { if (ControlLicenseSpecial.COLOR_ID == 1) { cboColor.SelectedIndex = 0; } else if (ControlLicenseSpecial.COLOR_ID == 2) { cboColor.SelectedIndex = 1; } else if (ControlLicenseSpecial.COLOR_ID == 3) { cboColor.SelectedIndex = 2; } using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { foreach (var item in lda.ShowLicenseByID(ControlLicenseSpecial.LICENSE_ID)) { txtAccountName.Text = item.ACCOUNT_NAME; txtLicenseNumber.Text = item.ACCOUNT_NO; LICENSE_ID = item.LICENSE_ID; } } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } }
public void ControlLicense_Load(object sender, EventArgs e) { LICENSE_NUMBER = string.Empty; using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { dataGridViewLicense.DataSource = lda.ShowLicense(); }; GC.Collect(); }
private void FormMain_Load(object sender, EventArgs e) { btnMenuLicense.Enabled = false; lda = new TBL_LICENSE_DATA_ACCESS(); clm = new ControlLicenseMenuLeft(); cl = new ControlLicense(); clm.Dock = DockStyle.Fill; panelLeft.Controls.Add(clm); cl.Dock = DockStyle.Fill; panelContainer.Controls.Add(cl); GC.Collect(); }
private void btnAddNew_Click(object sender, EventArgs e) { FormAddNewLicense add = new FormAddNewLicense(); add.ShowDialog(this); using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { dataGridViewLicense.DataSource = lda.ShowLicense(); } btnAddNew.UseSelectable = false; txtSearch.Clear(); GC.Collect(); }
private void FormLicenseAvailableBySeason_Load(object sender, EventArgs e) { try { using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { dataGridViewLicense.DataSource = lda.DisplayAvailableLicenseBySeasonID(ControlWork.SEASON_ID); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private bool invalid() { using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { foreach (var item in lda.CheckLicenseNumber(txtLicenseNumber.Text)) { LICENSE_NUMBER = item.ACCOUNT_NO.ToString(); } } bool flag = false; if (this.txtLicenseNumber.Text == LICENSE_NUMBER) { this.txtLicenseNumber.SetValidation(string.Format(Properties.Resources.LICENSENUMBER_ADREADY, this.label1.Text)); flag = true; } if (this.txtLicenseNumber.Text == "") { this.txtLicenseNumber.SetValidation(string.Format(Properties.Resources.REQUIRED_LICENSENUMBER, this.label1.Text)); flag = true; } if (this.txtAccountName.Text == "") { this.txtAccountName.SetValidation(string.Format(Properties.Resources.REQUIRED_ACCOUNTNAME, this.label1.Text)); flag = true; } if (this.txtProvince.Text == "") { this.txtProvince.SetValidation(string.Format(Properties.Resources.REQUIRED_PROVINCE_NAME, this.label1.Text)); flag = true; } if (this.txtContactName.Text == "") { this.txtContactName.SetValidation(string.Format(Properties.Resources.REQUIRED_CONTACTNAME, this.label1.Text)); flag = true; } if (this.txtPhone.Text == "") { this.txtPhone.SetValidation(string.Format(Properties.Resources.REQUIRED_PHONE, this.label1.Text)); flag = true; } if (this.txtAddress.Text == "") { this.txtAddress.SetValidation(string.Format(Properties.Resources.REQUIRED_ADDRESS, this.label1.Text)); flag = true; } return(flag); }
private void dataGridViewLicense_CellClick(object sender, DataGridViewCellEventArgs e) { using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { foreach (DataGridViewRow row in dataGridViewLicense.SelectedRows) { ID = Convert.ToInt32(row.Cells["L_ID"].Value); } foreach (var item in lda.ShowLicenseByID(ID)) { txtAccountName.Text = item.ACCOUNT_NAME; txtLicenseNumber.Text = item.ACCOUNT_NO; LICENSE_ID = item.LICENSE_ID; } } }
private void txtSearch_TextChanged(object sender, EventArgs e) { if (txtSearch.Text.Length > 0) { using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { dataGridViewLicense.DataSource = lda.Search(txtSearch.Text); } } else { using (TBL_LICENSE_DATA_ACCESS lda = new TBL_LICENSE_DATA_ACCESS()) { dataGridViewLicense.DataSource = lda.ShowLicense(); } } }