private void btnDelete_Click(object sender, EventArgs e) { #region No ListItem Selected if (gridPlayingBoard.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoard.Text); return; } #endregion DataBaseDataContext myConnection = Setting.DataBase; #region PlayingBoard Cast int playingBoardId = (int)gridPlayingBoard.SelectedRows[0].Cells[1].Value; if (!PlayingBoard.Validation(playingBoardId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoard playingBoard = PlayingBoard.Get(playingBoardId, myConnection); #endregion #region Check Data In Use (RaspberryPin) if (playingBoard.PlayingBoardTypes.Any() || myConnection.RaspBerryPlayingBoards.Any(a => a.PlayingBoard.Equals(playingBoard))) { DataValidationMesaage.DataInUse(playingBoard.Number, gridPlayingBoard.Text); return; } #endregion DialogResult message = DataValidationMesaage.ConfirmDeleteData(playingBoard.Number); if (message == DialogResult.Yes) { PlayingBoard.Delete(playingBoard, myConnection); DataValidationMesaage.DeleteMessage(); PlayingBoard.LoadGridColorful_By_PlayingBoardTitle(gridPlayingBoard, playingBoard.PlayingBoardTitle, myConnection); } myConnection.Dispose(); }
private void btnYes_Click(object sender, EventArgs e) { PlayingBoard playingBoard = FrmPlayingBoard.SelectedPlayingBoard; if (int.Parse(txtPrice.Text.Trim()).Equals(0) || string.IsNullOrWhiteSpace(txtPrice.Text.Trim()) || string.IsNullOrEmpty(txtPrice.Text.Trim())) { DataValidationMesaage.BlankTextBox("بهای میز"); return; } DataBaseDataContext myConnection = Setting.DataBase; PlayingBoardType playingBoardType = (PlayingBoardType)lstPlayingBoardTypes.SelectedItems[0].Tag; if (!PlayingBoardType.Validation(playingBoardType.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } playingBoardType = PlayingBoardType.Get(playingBoardType.ID, myConnection); if ( myConnection.PlayingBoardTypes.Any( a => a.Type == cmbType.SelectedItem.ToString() && a.PlayingBoard == playingBoard && a.ID != playingBoardType.ID)) { DataValidationMesaage.DuplicateData(cmbType.SelectedItem.ToString()); return; } if (myConnection.PlayingBoardTypes.Any(a => a.PlayingBoard == playingBoard && !a.PlayingBoard.IsAvailable)) { DataValidationMesaage.DataInUse("میز بازی", lstPlayingBoardTypes.Text); return; } PlayingBoardType.Edit(playingBoardType, cmbType.SelectedItem.ToString(), int.Parse(txtPrice.Text.Trim()), myConnection); DataValidationMesaage.EditMessage(); PlayingBoardType.ShowList_By_PlayingBoard(playingBoard, lstPlayingBoardTypes, myConnection); FormManagement.DisableYesNo(this.Controls); myConnection.Dispose(); clearTextBox(); }
private void btnDelete_Click(object sender, EventArgs e) { if (gridCabinet.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridCabinet.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region Cabinet Casting int cabinetID = int.Parse(gridCabinet.SelectedRows[0].Cells[1].Value.ToString()); if (!Cabinet.Validation(cabinetID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Cabinet cabinet = Cabinet.Get(cabinetID, myConnection); #endregion if (cabinet.MemberCabinets.Any(a => a.Status)) { DataValidationMesaage.DataInUse(cabinet.Title, gridCabinet.Text); return; } if (cabinet.MemberCabinets.Any(a => !a.Status)) { DataValidationMesaage.DataUsed(cabinet.Title, gridCabinet.Text); return; } DialogResult message = DataValidationMesaage.ConfirmDeleteData(cabinet.Title); if (message == DialogResult.Yes) { Cabinet.Delete(cabinet, myConnection); DataValidationMesaage.DeleteMessage(); Cabinet.LoadGridColorful(gridCabinet, myConnection); } myConnection.Dispose(); }
private void btnDelete_Click(object sender, EventArgs e) { if (gridPlayingBoardTitle.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoardTitle.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region PlayingBoardTitle Casting int playingBoardTitleId = int.Parse(gridPlayingBoardTitle.SelectedRows[0].Cells[1].Value.ToString()); if (!PlayingBoardTitle.Validation(playingBoardTitleId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(playingBoardTitleId, myConnection); #endregion if (playingBoardTitle.PlayingBoards.Any()) { DataValidationMesaage.DataInUse(playingBoardTitle.Title, gridPlayingBoardTitle.Text); return; } DialogResult message = DataValidationMesaage.ConfirmDeleteData(playingBoardTitle.Title); if (message == DialogResult.Yes) { PlayingBoardTitle.Delete(playingBoardTitle, myConnection); DataValidationMesaage.DeleteMessage(); PlayingBoardTitle.LoadGrid_By_PlayingBoardGroupTitle(gridPlayingBoardTitle, FrmPlayingBoard.SelectedPlayingBoardGroupTitle, myConnection); } //myConnection.Dispose(); }
private void btnDelete_Click(object sender, EventArgs e) { if (gridBankAccount.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridBankAccount.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region BankAccount Casting int bankAccountId = int.Parse(gridBankAccount.SelectedRows[0].Cells[1].Value.ToString()); if (!BankAccount.Validation(bankAccountId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } BankAccount bankAccount = BankAccount.Get(bankAccountId, myConnection); #endregion if (bankAccount.CardSerialPayments.Any()) { DataValidationMesaage.DataInUse(bankAccount.BankTitle, gridBankAccount.Text); return; } DialogResult message = DataValidationMesaage.ConfirmDeleteData(bankAccount.ToString()); if (message == DialogResult.Yes) { BankAccount.Delete(bankAccount, myConnection); DataValidationMesaage.DeleteMessage(); BankAccount.LoadGrid(gridBankAccount, myConnection); } }
private void btnDelete_Click(object sender, EventArgs e) { if (gridLevel.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridLevel.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region Level Casting int levelID = int.Parse(gridLevel.SelectedRows[0].Cells[1].Value.ToString()); if (!Level.Validation(levelID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Level level = Level.Get(levelID, myConnection); #endregion if (level.Members.Any()) { DataValidationMesaage.DataInUse(level.Title, gridLevel.Text); return; } DialogResult message = DataValidationMesaage.ConfirmDeleteData(level.Title); if (message == DialogResult.Yes) { Level.Delete(level, myConnection); DataValidationMesaage.DeleteMessage(); Level.LoadGrid(gridLevel, myConnection); } }
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 btnDelete_Click(object sender, EventArgs e) { if (gridSocialNetworkType.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridSocialNetworkType.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region SocialNetworkType Casting int socialNetworkTypeID = int.Parse(gridSocialNetworkType.SelectedRows[0].Cells[1].Value.ToString()); if (!SocialNetworkType.Validation(socialNetworkTypeID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeID, myConnection); #endregion if (socialNetworkType.SocialNetworkAccounts.Any()) { DataValidationMesaage.DataInUse(socialNetworkType.Title, gridSocialNetworkType.Text); return; } DialogResult message = DataValidationMesaage.ConfirmDeleteData(socialNetworkType.Title); if (message == DialogResult.Yes) { SocialNetworkType.Delete(socialNetworkType, myConnection); DataValidationMesaage.DeleteMessage(); SocialNetworkType.LoadGrid(gridSocialNetworkType, myConnection); } }
private void btnDelete_Click(object sender, EventArgs e) { if (gridTeam.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridTeam.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region Team Casting int teamID = int.Parse(gridTeam.SelectedRows[0].Cells[1].Value.ToString()); if (!Team.Validation(teamID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Team team = Team.Get(teamID, myConnection); #endregion if (team.TeamMembers.Any()) { DataValidationMesaage.DataInUse(team.Title, gridTeam.Text); return; } DialogResult message = DataValidationMesaage.ConfirmDeleteData(team.Title); if (message == DialogResult.Yes) { Team.Delete(team, myConnection); DataValidationMesaage.DeleteMessage(); Team.LoadGrid(gridTeam, myConnection); } }