private void FormUpdateLicense_Load(object sender, EventArgs e) { using (LicenseDataContext _context = new LicenseDataContext()) { TBL_LICENSE license = (from l in _context.TBL_LICENSEs where l.ACCOUNT_NO == ControlLicense.LICENSE_NUMBER select l).FirstOrDefault(); if (license != null) { LICENSE_ID = license.LICENSE_ID; txtLicenseNumber.Text = license.ACCOUNT_NO; txtAccountName.Text = license.ACCOUNT_NAME; txtPhone.Text = license.PHONE; txtContactName.Text = license.CONTACT_NAME; txtPhone.Text = license.PHONE; txtProvince.Text = license.PROVINCE_NAME; txtDistrict.Text = license.DISTRICT_NAME; txtCommune.Text = license.COMMUNE_NAME; txtVillage.Text = license.VILLAGE_NAME; txtAddress.Text = license.ADDRESS; txtEmail.Text = license.EMAIL; } else { } }; }
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 btnSave_Click(object sender, EventArgs e) { if (!invalid()) { try { using (LicenseDataContext _context = new LicenseDataContext()) { TBL_LICENSE l = new TBL_LICENSE(); l.ACCOUNT_NAME = txtPhone.Text.Trim(); l.ACCOUNT_NO = txtLicenseNumber.Text.Trim(); l.CONTACT_NAME = txtContactName.Text.Trim(); l.PHONE = txtPhone.Text.Trim(); l.EMAIL = txtEmail.Text.Trim(); l.PROVINCE_NAME = txtProvince.Text.Trim(); l.DISTRICT_NAME = txtDistrict.Text.Trim(); l.COMMUNE_NAME = txtCommune.Text.Trim(); l.VILLAGE_NAME = txtVillage.Text.Trim(); l.ADDRESS = txtAddress.Text.Trim(); l.IS_ACTIVE = true; l.CREATE_ON = Convert.ToDateTime(DateTime.Now.ToString()); lda.SaveLicense(l); }; this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } } else { } }
/// <summary> /// Update License No. /// </summary> /// <param name="license"></param> public void UpdateLicense(TBL_LICENSE license) { using (_context = new LicenseDataContext()) { _context.SubmitChanges(); } }
/// <summary> /// Delete License NO. /// </summary> /// <param name="license"></param> public void DeleteLicense(TBL_LICENSE license) { using (_context = new LicenseDataContext()) { _context.TBL_LICENSEs.DeleteOnSubmit(license); _context.SubmitChanges(); } }
public void SaveLicense(TBL_LICENSE license) { using (_context = new LicenseDataContext()) { _context.TBL_LICENSEs.InsertOnSubmit(license); _context.SubmitChanges(); }; }
private void btnSave_Click(object sender, EventArgs e) { using (LicenseDataContext _context = new LicenseDataContext()) { TBL_LICENSE license = (from l in _context.TBL_LICENSEs where l.ACCOUNT_NO == txtLicenseNumber.Text select l).FirstOrDefault(); license.ACCOUNT_NO = txtLicenseNumber.Text.Trim(); license.ACCOUNT_NAME = txtAccountName.Text.Trim(); license.PHONE = txtPhone.Text.Trim(); license.EMAIL = txtEmail.Text.Trim(); license.CONTACT_NAME = txtContactName.Text.Trim(); license.PHONE = txtPhone.Text.Trim(); license.ADDRESS = txtAddress.Text.Trim(); license.PROVINCE_NAME = txtProvince.Text.Trim(); license.DISTRICT_NAME = txtDistrict.Text.Trim(); license.COMMUNE_NAME = txtCommune.Text.Trim(); license.VILLAGE_NAME = txtVillage.Text.Trim(); _context.SubmitChanges(); }; this.Close(); }