private void تعیینبهاءToolStripMenuItem_Click_1(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; } SelectedPlayingBoard = PlayingBoard.Get(playingBoardId, myConnection); #endregion FrmPlayingBoardType frm = new FrmPlayingBoardType(); frm.ShowDialog(); }
private void gridPlayingBoard_SelectionChanged(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (gridPlayingBoard.SelectedRows.Count == 0) { return; } #region PlayingBoard Cast int playingBoardId = int.Parse(gridPlayingBoard.SelectedRows[0].Cells[1].Value.ToString()); if (!PlayingBoard.Validation(playingBoardId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoard playingBoard = PlayingBoard.Get(playingBoardId, myConnection); #endregion PlayingBoardType.LoadComboBox_By_PlayingBoard(cmbPlayingBoardType, playingBoard, myConnection); }
private void btnEdit_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 txtTitle.Text = level.Title; //FormsManagement.EnableYesNo(btnSave, btnEdit, btnDelete, btnYes, btnNo, gridLevel); FormManagement.EnableYesNo(this.Controls); txtTitle.Focus(); }
private void btnEdit_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; } cmbType.SelectedItem = playingBoardType.Type; txtPrice.Text = playingBoardType.Price.ToString(); FormManagement.EnableYesNo(this.Controls); myConnection.Dispose(); }
private void btnEdit_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 txtTitle.Text = phone.Title; FormManagement.EnableYesNo(this.Controls); txtTitle.Focus(); }
private void btnEdit_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 txtBankTitle.Text = bankAccount.BankTitle; txtCardNumber.Text = bankAccount.CardNumber; txtAccountNumber.Text = bankAccount.AccountNumber; FormManagement.EnableYesNo(this.Controls); txtBankTitle.Focus(); }
private void btnEdit_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 txtTitle.Text = cabinet.Title; FormManagement.EnableYesNo(this.Controls); txtTitle.Focus(); myConnection.Dispose(); }
private void صندوقچهاماناتToolStripMenuItem_Click(object sender, EventArgs e) { if (gridMember.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridMember.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; int memberId = int.Parse(gridMember.SelectedRows[0].Cells[1].Value.ToString()); if (!Member.Validation(memberId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Member member = Member.Get(memberId, myConnection); MemberProfile = member; FrmMemberCabinet frm = new FrmMemberCabinet(); frm.ShowDialog(); myConnection.Dispose(); }
private void btnEdit_Click(object sender, EventArgs e) { if (gridPlayingBoard.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoard.Text); return; } 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 txtNumber.Text = playingBoard.Number; FormManagement.EnableYesNoIncludingComboBox(this.Controls); myConnection.Dispose(); }
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 FrmSetRaspberryRelays_Load(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; RaspBerryPlayingBoard.ShowList(lstRaspberryRelays, myConnection); RaspberryPin.LoadComboBoxAvailables(cmbRaspberryRelay, myConnection); PlayingBoardGroupTitle.LoadComboBox(cmbPlayingBoardGroupTitle, myConnection); if (myConnection.PlayingBoardGroupTitles.Any()) { #region PlayingBoardGroupTitle Cast int playingBoardGroupTitleId = ((PlayingBoardGroupTitle)cmbPlayingBoardGroupTitle.SelectedItem).ID; if (!PlayingBoardGroupTitle.Validation(playingBoardGroupTitleId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardGroupTitle playingBoardGroupTitle = PlayingBoardGroupTitle.Get(playingBoardGroupTitleId, myConnection); #endregion PlayingBoardTitle.LoadComboBox_By_PlayingBoardGroupTitle(cmbPlayingBoardTitle, playingBoardGroupTitle, myConnection); if (myConnection.PlayingBoardTitles.Any(a => a.PlayingBoardGroupTitle.Equals(playingBoardGroupTitle))) { #region PlayingBoardTitle Cast int playingBoardTitleId = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID; if (!PlayingBoardTitle.Validation(playingBoardTitleId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(playingBoardTitleId, myConnection); #endregion PlayingBoard.LoadComboBoxByFilter(cmbPlayingBoard, playingBoardTitle, myConnection); } } }
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 btnSubmit_Click(object sender, EventArgs e) { if (gridCabinetAvailables.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridCabinetAvailables.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region Cabinet Cast int cabinetId = int.Parse(gridCabinetAvailables.SelectedRows[0].Cells[1].Value.ToString()); if (!Cabinet.Validation(cabinetId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Cabinet cabinet = Cabinet.Get(cabinetId, myConnection); #endregion _selectedMember = FrmMember.MemberProfile; if (myConnection.MemberCabinets.Any(a => a.Member == _selectedMember && a.Status)) { MessageBox.Show("به این عضو یک صندوق امانت اختصاص داده شده است", "کاربر گرامی", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } MemberCabinet.Insert(cabinet, _selectedMember, DateTime.Now, DateTime.Now, true, myConnection); MessageBox.Show("عملیات اختصاص صندوق امانت به عضو با موفقیت انجام شد", "کاربر گرامی", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); cabinet.IsAvailable = false; myConnection.SubmitChanges(); Cabinet.LoadGridAvailables(gridCabinetAvailables, myConnection); myConnection.Dispose(); }
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 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 (myConnection.PlayingBoardTitles.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != playingBoardTitleID)) { DataValidationMesaage.DuplicateData(txtTitle.Text); return; } PlayingBoardTitle.Edit(playingBoardTitle, txtTitle.Text.Trim(), myConnection); DataValidationMesaage.EditMessage(); ClearTextBox(); txtTitle.Focus(); PlayingBoardTitle.LoadGrid_By_PlayingBoardGroupTitle(gridPlayingBoardTitle, FrmPlayingBoard.SelectedPlayingBoardGroupTitle, myConnection); FormManagement.DisableYesNo(this.Controls); //myConnection.Dispose(); }
private void FrmPlayingBoard_Load(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; PlayingBoardGroupTitle.LoadComboBox(cmbPlayingBoardGroupTitle, myConnection); if (myConnection.PlayingBoardGroupTitles.Any()) { #region PlayingBoardGroupTitle Cast int playingBoardGroupTitleId = ((PlayingBoardGroupTitle)cmbPlayingBoardGroupTitle.SelectedItem).ID; if (!PlayingBoardGroupTitle.Validation(playingBoardGroupTitleId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardGroupTitle playingBoardGroupTitle = PlayingBoardGroupTitle.Get(playingBoardGroupTitleId, myConnection); #endregion if (myConnection.PlayingBoardTitles.Any(a => a.PlayingBoardGroupTitle.Equals(playingBoardGroupTitle))) { #region PlayingBoardTitle Cast int playingBoardTitleId = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID; if (!PlayingBoardTitle.Validation(playingBoardTitleId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(playingBoardTitleId, myConnection); #endregion PlayingBoard.LoadGridColorful_By_PlayingBoardTitle(gridPlayingBoard, playingBoardTitle, myConnection); } } myConnection.Dispose(); }
private void cmbPlayingBoardGroupTitle_SelectedIndexChanged(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (myConnection.PlayingBoardGroupTitles.Any()) { #region PlayingBoardGroupTitle Cast int playingBoardGroupTitleId = ((PlayingBoardGroupTitle)cmbPlayingBoardGroupTitle.SelectedItem).ID; if (!PlayingBoardGroupTitle.Validation(playingBoardGroupTitleId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardGroupTitle playingBoardGroupTitle = PlayingBoardGroupTitle.Get(playingBoardGroupTitleId, myConnection); #endregion PlayingBoardTitle.LoadComboBox_By_PlayingBoardGroupTitle(cmbPlayingBoardTitle, playingBoardGroupTitle, myConnection); if (myConnection.PlayingBoardTitles.Any(a => a.PlayingBoardGroupTitle.Equals(playingBoardGroupTitle))) { #region PlayingBoardTitle Cast int playingBoardTitleId = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID; if (!PlayingBoardTitle.Validation(playingBoardTitleId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(playingBoardTitleId, myConnection); #endregion PlayingBoard.LoadComboBoxByFilter(cmbPlayingBoard, playingBoardTitle, myConnection); } } }
private void btnYes_Click(object sender, EventArgs e) { 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 (string.IsNullOrWhiteSpace(txtTitle.Text) || string.IsNullOrEmpty(txtTitle.Text)) { DataValidationMesaage.BlankTextBox("عنوان"); return; } if (myConnection.Levels.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != levelID)) { DataValidationMesaage.DuplicateData(txtTitle.Text); return; } Level.Edit(level, txtTitle.Text.Trim(), myConnection); if (myConnection.Levels.Any(a => a.ID != levelID && a.Title == txtTitle.Text.Trim())) { DataValidationMesaage.EditMessage(); } ClearTextBox(); Level.LoadGrid(gridLevel, myConnection); //FormsManagement.DisableYesNo(btnSave, btnEdit, btnDelete, btnYes, btnNo, gridLevel); FormManagement.DisableYesNo(this.Controls); }
private void btnYes_Click(object sender, EventArgs e) { 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 (string.IsNullOrWhiteSpace(txtTitle.Text) || string.IsNullOrEmpty(txtTitle.Text)) { DataValidationMesaage.BlankTextBox("عنوان"); return; } if (myConnection.Cabinets.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != cabinet.ID)) { DataValidationMesaage.DuplicateData(txtTitle.Text); return; } Cabinet.Edit(cabinet, txtTitle.Text.Trim(), cabinet.IsAvailable, myConnection); DataValidationMesaage.EditMessage(); clearTextBox(); Cabinet.LoadGridColorful(gridCabinet, myConnection); FormManagement.DisableYesNo(this.Controls); myConnection.Dispose(); }
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 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 (myConnection.SocialNetworkTypes.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != socialNetworkType.ID)) { DataValidationMesaage.DuplicateData(txtTitle.Text); return; } SocialNetworkType.Edit(socialNetworkType, txtTitle.Text.Trim(), myConnection); DataValidationMesaage.EditMessage(); clearTextBox(); txtTitle.Focus(); SocialNetworkType.LoadGrid(gridSocialNetworkType, myConnection); FormManagement.DisableYesNo(this.Controls); }
private void btnYes_Click(object sender, EventArgs e) { 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 (string.IsNullOrWhiteSpace(txtBankTitle.Text.Trim()) || string.IsNullOrEmpty(txtBankTitle.Text.Trim())) { DataValidationMesaage.BlankTextBox("عنوان بانک"); return; } if (myConnection.BankAccounts.Any(a => a.BankTitle.Equals(txtBankTitle.Text.Trim()) && a.ID != bankAccountId)) { DataValidationMesaage.DuplicateData("عنوان بانک"); return; } BankAccount.Edit(bankAccount, txtBankTitle.Text.Trim(), txtCardNumber.Text.Trim(), txtAccountNumber.Text.Trim(), myConnection); DataValidationMesaage.EditMessage(); ClearTextBoxes(); BankAccount.LoadGrid(gridBankAccount, myConnection); FormManagement.DisableYesNo(this.Controls); 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 (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 (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 (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 btnYes_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrWhiteSpace(txtTitle.Text)) { DataValidationMesaage.BlankTextBox("عنوان"); return; } #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 (myConnection.Teams.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != team.ID)) { DataValidationMesaage.DuplicateData(txtTitle.Text); return; } Team.Edit(team, txtTitle.Text.Trim(), myConnection); DataValidationMesaage.EditMessage(); clearTextBox(); Team.LoadGrid(gridTeam, myConnection); FormManagement.DisableYesNo(this.Controls); }
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 (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 btnSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrWhiteSpace(txtTitle.Text.Trim()) || string.IsNullOrEmpty(txtTitle.Text.Trim())) { DataValidationMesaage.BlankTextBox("عنوان دستگاه"); return; } #region PlayingBoardGroupTitle Cast int id = FrmPlayingBoard.SelectedPlayingBoardGroupTitle.ID; if (!PlayingBoardGroupTitle.Validation(id, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardGroupTitle playingBoardGroupTitle = PlayingBoardGroupTitle.Get(id, myConnection); #endregion if (myConnection.PlayingBoardTitles.Any(a => a.Title == txtTitle.Text.Trim())) { DataValidationMesaage.DuplicateData("عنوان دستگاه"); return; } PlayingBoardTitle.Insert(txtTitle.Text.Trim(), playingBoardGroupTitle, myConnection); PlayingBoardTitle.LoadGrid_By_PlayingBoardGroupTitle(gridPlayingBoardTitle, playingBoardGroupTitle, myConnection); ClearTextBox(); //myConnection.Dispose(); }