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 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 FrmPlayingBoard_Activated(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; btnAddPlayingboardTitle.Visible = true; if (FrmPlayingBoardGroupTitle.ActivatePlayingBoardGroupTitle) { gridPlayingBoard.Rows.Clear(); PlayingBoardGroupTitle.LoadComboBox(cmbPlayingBoardGroupTitle, myConnection); FrmPlayingBoardGroupTitle.ActivatePlayingBoardGroupTitle = false; } if (FrmPlayingBoardTitle.ActivatePlayingBoardTitle) { gridPlayingBoard.Rows.Clear(); #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); FrmPlayingBoardTitle.ActivatePlayingBoardTitle = false; 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); } } if (!myConnection.PlayingBoardGroupTitles.Any()) { gridPlayingBoard.Rows.Clear(); btnAddPlayingboardTitle.Visible = false; cmbPlayingBoardTitle.Items.Clear(); cmbPlayingBoardTitle.Items.Add("گروه بازی کامل شود"); cmbPlayingBoardTitle.SelectedIndex = 0; return; } }