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 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 (lstRaspberryRelays.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست دستگاه ها و رله ها"); return; } DataBaseDataContext myConnection = Setting.DataBase; #region RaspBerryPlayingBoard Cast int playingBoardId = (int)((RaspBerryPlayingBoard)lstRaspberryRelays.SelectedItems[0].Tag).PlayingBoardID; if (!RaspBerryPlayingBoard.Validation_By_PlayingBoardID(playingBoardId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } RaspBerryPlayingBoard raspBerryPlayingBoard = RaspBerryPlayingBoard.Get_By_PlayingBoardID(playingBoardId, myConnection); #endregion DialogResult message = DataValidationMesaage.ConfirmDeleteData(raspBerryPlayingBoard.RaspberryPin.PinNumber); if (message == DialogResult.Yes) { raspBerryPlayingBoard.RaspberryPin.IsAvailable = true; RaspBerryPlayingBoard.Delete(raspBerryPlayingBoard, myConnection); myConnection.SubmitChanges(); DataValidationMesaage.DeleteMessage(); RaspberryPin.LoadComboBoxAvailables(cmbRaspberryRelay, myConnection); RaspBerryPlayingBoard.ShowList(lstRaspberryRelays, myConnection); } myConnection.Dispose(); }
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); } }
private void btnDelete_Click(object sender, EventArgs e) { if (lstPlayingBoardTypes.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(lstPlayingBoardTypes.Text); 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); DialogResult message = DataValidationMesaage.ConfirmDeleteData(playingBoardType.Type); if (message == DialogResult.Yes) { PlayingBoardType.Delete(playingBoardType, myConnection); DataValidationMesaage.DeleteMessage(); PlayingBoardType.ShowList_By_PlayingBoard(FrmPlayingBoard.SelectedPlayingBoard, lstPlayingBoardTypes, myConnection); } myConnection.Dispose(); }
private void btnSocialAccountDelete_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (lstSocialNetwork.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست اکانت های شبکه های اجتماعی"); return; } #region Member Casting int memberId = FrmMember.MemberProfile.ID; if (!Member.Validation(memberId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Member member = Member.Get(memberId, myConnection); #endregion #region SocialNetworkType Casting int socialNetworkTypeId = ((SocialNetworkType)cmbSocialAccount.SelectedItem).ID; if (!SocialNetworkType.Validation(socialNetworkTypeId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeId, myConnection); #endregion #region SocialNetworkAccount Casting SocialNetworkAccount socialNetworkAccount = (SocialNetworkAccount)lstSocialNetwork.SelectedItems[0].Tag; if (!SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } socialNetworkAccount = SocialNetworkAccount.Get(socialNetworkAccount.ID, myConnection); #endregion DialogResult messageResult = DataValidationMesaage.ConfirmDeleteData(lstSocialNetwork.SelectedItems[0].SubItems[1].Text); if (messageResult == DialogResult.Yes) { if (socialNetworkAccount.Status) { #region NextSocialNetworkAccount Casting int nextSocialNetworkAccountIndex = (int.Parse(lstSocialNetwork.SelectedItems[0].Text)) % lstSocialNetwork.Items.Count; SocialNetworkAccount nextSocialNetworkAccount = (SocialNetworkAccount)lstSocialNetwork.Items[nextSocialNetworkAccountIndex].Tag; if (!SocialNetworkAccount.Validation(nextSocialNetworkAccount.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } nextSocialNetworkAccount = SocialNetworkAccount.Get(nextSocialNetworkAccount.ID, myConnection); var query = myConnection.SocialNetworkAccounts.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } #endregion nextSocialNetworkAccount.Status = true; myConnection.SubmitChanges(); } SocialNetworkAccount.Delete(socialNetworkAccount, myConnection); SocialNetworkAccount.ShowListByMember(lstSocialNetwork, FrmMember.MemberProfile, myConnection); if (lstSocialNetwork.Items.Count == 1) { btnPhoneDelete.Enabled = false; } } txtSocialAccount.Clear(); myConnection.Dispose(); }
private void btnPhoneDelete_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (lstPhoneNumber.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست شماره های تماس"); return; } #region Member Casting int memberId = FrmMember.MemberProfile.ID; if (!Member.Validation(memberId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Member member = Member.Get(memberId, myConnection); #endregion #region Phone Casting int phoneId = ((Phone)cmbPhone.SelectedItem).ID; if (!Phone.Validation(phoneId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneId, myConnection); #endregion #region PhoneNumber Casting PhoneNumber phoneNumber = (PhoneNumber)lstPhoneNumber.SelectedItems[0].Tag; if (!PhoneNumber.Validation(phoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } phoneNumber = PhoneNumber.Get(phoneNumber.ID, myConnection); #endregion DialogResult messageResult = DataValidationMesaage.ConfirmDeleteData(lstPhoneNumber.SelectedItems[0].SubItems[1].Text); if (messageResult == DialogResult.Yes) { if (phoneNumber.Status) { #region NextPhoneNumber Casting int nextPhoneNumberIndex = (int.Parse(lstPhoneNumber.SelectedItems[0].Text)) % lstPhoneNumber.Items.Count; PhoneNumber nextPhoneNumber = (PhoneNumber)lstPhoneNumber.Items[nextPhoneNumberIndex].Tag; if (!PhoneNumber.Validation(nextPhoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } nextPhoneNumber = PhoneNumber.Get(nextPhoneNumber.ID, myConnection); var query = myConnection.PhoneNumbers.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } #endregion nextPhoneNumber.Status = true; myConnection.SubmitChanges(); } PhoneNumber.Delete(phoneNumber, myConnection); PhoneNumber.ShowListByMember(lstPhoneNumber, FrmMember.MemberProfile, myConnection); if (lstPhoneNumber.Items.Count == 1) { btnPhoneDelete.Enabled = false; } } txtPhoneNumber.Clear(); myConnection.Dispose(); }
private void btnDelete_Click(object sender, EventArgs e) { if (gridMember.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridMember.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region Member Casting int memeberId = int.Parse(gridMember.SelectedRows[0].Cells[1].Value.ToString()); if (!Member.Validation(memeberId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Member member = Member.Get(memeberId, myConnection); #endregion #region PhoneNumber Casting string gridPhoneNumber = gridMember.SelectedRows[0].Cells[9].Value.ToString(); PhoneNumber phoneNumber = myConnection.PhoneNumbers.FirstOrDefault(a => a.Number == gridPhoneNumber && a.Member == member); if (!PhoneNumber.Validation(phoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } #endregion #region SocialNetworkAccount Casting string gridSocialAccount = gridMember.SelectedRows[0].Cells[8].Value.ToString(); SocialNetworkAccount socialNetworkAccount = myConnection.SocialNetworkAccounts.FirstOrDefault( a => a.Account == gridSocialAccount && a.Member == member); if (!SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } #endregion DialogResult message = DataValidationMesaage.ConfirmDeleteData(member.Code); if (message == DialogResult.Yes) { PhoneNumber.Delete(phoneNumber, myConnection); SocialNetworkAccount.Delete(socialNetworkAccount, myConnection); Member.Delete(member, myConnection); DataValidationMesaage.DeleteMessage(); GetCode(); Member.LoadGridJoinSocialNetworkAccountJoinPhoneNumber(gridMember, myConnection); } }