private void btnSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrWhiteSpace(txtTitle.Text)) { DataValidationMesaage.BlankTextBox("عنوان"); return; } if (myConnection.Phones.Any(a => a.Title == txtTitle.Text.Trim())) { DataValidationMesaage.DuplicateData(txtTitle.Text); return; } Phone phone = Phone.Insert(txtTitle.Text.Trim(), myConnection); clearTextBox(); DataValidationMesaage.AcceptMessage(phone.Title); Phone.LoadGrid(gridPhone, myConnection); }
private void btnYes_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrWhiteSpace(txtTitle.Text)) { DataValidationMesaage.BlankTextBox("عنوان"); return; } #region Phone Casting int phoneID = int.Parse(gridPhone.SelectedRows[0].Cells[1].Value.ToString()); if (!Phone.Validation(phoneID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneID, myConnection); #endregion if (myConnection.Phones.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != phoneID)) { DataValidationMesaage.DuplicateData(txtTitle.Text); return; } Phone.Edit(phone, txtTitle.Text.Trim(), myConnection); DataValidationMesaage.EditMessage(); clearTextBox(); txtTitle.Focus(); Phone.LoadGrid(gridPhone, myConnection); FormManagement.DisableYesNo(this.Controls); }
private void btnDelete_Click(object sender, EventArgs e) { if (gridPhone.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridPhone.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region Phone Casting int phoneID = int.Parse(gridPhone.SelectedRows[0].Cells[1].Value.ToString()); if (!Phone.Validation(phoneID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneID, myConnection); #endregion if (phone.PhoneNumbers.Any()) { DataValidationMesaage.DataInUse(phone.Title, gridPhone.Text); return; } DialogResult message = DataValidationMesaage.ConfirmDeleteData(phone.Title); if (message == DialogResult.Yes) { Phone.Delete(phone, myConnection); DataValidationMesaage.DeleteMessage(); Phone.LoadGrid(gridPhone, myConnection); } }
private void FrmPhone_Load(object sender, EventArgs e) { Phone.LoadGrid(gridPhone, Setting.DataBase); }