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 btnSave_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; if ( myConnection.PlayingBoardTypes.Any( a => a.Type == cmbType.SelectedItem.ToString() && a.PlayingBoard == playingBoard)) { DataValidationMesaage.DuplicateData(cmbType.SelectedItem.ToString()); return; } PlayingBoardType.Insert(playingBoard, cmbType.SelectedItem.ToString(), int.Parse(txtPrice.Text.Trim()), myConnection); DataValidationMesaage.AcceptMessage(); PlayingBoardType.ShowList_By_PlayingBoard(playingBoard, lstPlayingBoardTypes, myConnection); myConnection.Dispose(); }
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); }
public static void ShowList_By_PlayingBoard(PlayingBoard playingBoard, ListView listView, DataBaseDataContext connection) { IQueryable <PlayingBoardType> myQuery = connection.PlayingBoardTypes.Where(a => a.PlayingBoard == playingBoard); listView.Items.Clear(); int count = 0; foreach (PlayingBoardType item in myQuery) { ListViewItem listViewItem = new ListViewItem(); listViewItem.Tag = item; listViewItem.Text = (++count).ToString(); listViewItem.SubItems.Add(item.Type); listViewItem.SubItems.Add(item.Price.ToString()); listView.Items.Add(listViewItem); } }
public static void LoadFilteredGrid(RadGridView grid, PlayingBoard playingBoard, DataBaseDataContext connection) { var myQuery = connection.PlayingBoardTypes.Where(a => a.PlayingBoard == playingBoard) .Select(a => new { id = a.ID, type = a.Type, price = a.Price }); grid.DataSource = myQuery; grid.Columns[1].IsVisible = false; grid.Columns[2].HeaderText = "نوع"; grid.Columns[2].Width = 300; grid.Columns[3].HeaderText = "قیمت"; grid.Columns[3].Width = 300; for (int i = 0; i < grid.RowCount; i++) { grid.Rows[i].Cells[0].Value = i + 1; } }
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 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(); }
public static void Edit(RaspBerryPlayingBoard raspBerryPlayingBoard, PlayingBoard playingBoard, RaspberryPin raspberryPin, DataBaseDataContext connection) { raspBerryPlayingBoard.RaspberryPin = raspberryPin; raspBerryPlayingBoard.PlayingBoard = playingBoard; connection.SubmitChanges(); }
private void txtSearchPlayingBoard_TextChanged(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; //if (cmbSearchPlayingBoardBy.SelectedIndex == 0) PlayingBoard.Search_By_PlayingBoardTitle_LoadGridAvailables(txtSearchPlayingBoard.Text, gridPlayingBoard, myConnection); //else if (cmbSearchPlayingBoardBy.SelectedIndex == 1) // Member.SearchGridByMemberFullName_LoadGridBriefly(txtSearchMember.Text, gridMember, myConnection); //else if (cmbSearchPlayingBoardBy.SelectedIndex == 2) //Member.SearchGridByMemberNationalCode_LoadGridBriefly(txtSearchMember.Text, gridMember, myConnection); }
public static void Edit(PlayingBoard playingBoard, PlayingBoardTitle PlayingBoardTitle, string number, bool isAvailable, DataBaseDataContext connection) { playingBoard.Number = number; playingBoard.PlayingBoardTitle = PlayingBoardTitle; playingBoard.IsAvailable = isAvailable; connection.SubmitChanges(); }
public static PlayingBoard Insert(PlayingBoardTitle PlayingBoardTitle, string number, bool isAvailable, DataBaseDataContext connection) { PlayingBoard playingBoard = new PlayingBoard(number, isAvailable); playingBoard.PlayingBoardTitle = PlayingBoardTitle; connection.PlayingBoards.InsertOnSubmit(playingBoard); connection.SubmitChanges(); return(playingBoard); }
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); } } }
//public static List<int> ReservedPins = new List<int> //{1, 2, 4, 6, 9, 14, 17, 20, 25, 27, 28, 30, 34}; //public static List<int> GpioPins = new List<int>() //{3, 5, 7, 8, 10, 11, 12, 13, 15, 16, 18, 19, 21, 22, 23, 24, 26, 29, 31, 32, 33, 35, 36, 37}; public static RaspBerryPlayingBoard Insert(RaspberryPin raspberryPin, PlayingBoard playingBoard, DataBaseDataContext connection) { RaspBerryPlayingBoard raspBerryPlayingBoard = new RaspBerryPlayingBoard(); raspBerryPlayingBoard.RaspberryPin = raspberryPin; raspBerryPlayingBoard.PlayingBoard = playingBoard; connection.RaspBerryPlayingBoards.InsertOnSubmit(raspBerryPlayingBoard); connection.SubmitChanges(); return(raspBerryPlayingBoard); }
public static PlayingBoardType Insert(PlayingBoard playingBoard, string type, int price, DataBaseDataContext connection) { PlayingBoardType playingBoardType = new PlayingBoardType(type, price); playingBoard = PlayingBoard.Get(playingBoard.ID, connection); playingBoardType.PlayingBoard = playingBoard; connection.PlayingBoardTypes.InsertOnSubmit(playingBoardType); connection.SubmitChanges(); return(playingBoardType); }
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); } } }
public static void LoadComboBox_By_PlayingBoard(ComboBox cmbBox, PlayingBoard playingBoard, DataBaseDataContext connection) { IQueryable <PlayingBoardType> myQuery = connection.PlayingBoardTypes.Where(a => a.PlayingBoard == playingBoard); cmbBox.Items.Clear(); foreach (var item in myQuery) { cmbBox.Items.Add(item); } if (!myQuery.Any()) { cmbBox.Items.Add("یک آیتم به ثبت برسانید"); cmbBox.SelectedIndex = 0; return; } cmbBox.SelectedIndex = 0; }
private void FrmRent_Load(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; Member.LoadGridBriefly(gridMember, myConnection); PlayingBoard.LoadGridAvailables(gridPlayingBoard, myConnection); if (myConnection.PlayingBoards.Any(a => a.IsAvailable)) { #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); } cmbSearchMemberBy.SelectedIndex = 0; cmbSearchPlayingBoardBy.SelectedIndex = 0; gridPlayingBoard.ClearSelection(); gridMember.ClearSelection(); myConnection.Dispose(); }
public static void Delete(PlayingBoard playingBoard, DataBaseDataContext connection) { connection.PlayingBoards.DeleteOnSubmit(playingBoard); connection.SubmitChanges(); }
private void btnSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (cmbPlayingBoard.SelectedItem == null) { DataValidationMesaage.NoSelectedItemFromList("لیست میزهای بازی"); return; } #region PlayingBoard Cast int playingBoardId = ((PlayingBoard)cmbPlayingBoard.SelectedItem).ID; if (!PlayingBoard.Validation(playingBoardId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoard playingBoard = PlayingBoard.Get(playingBoardId, myConnection); #endregion #region RaspberryPin Cast int raspberryPinID = ((RaspberryPin)cmbRaspberryRelay.SelectedItem).ID; if (!RaspberryPin.Validation(raspberryPinID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } RaspberryPin raspberryPin = RaspberryPin.Get(raspberryPinID, myConnection); #endregion if (myConnection.RaspBerryPlayingBoards.Any(a => a.PlayingBoard == playingBoard)) { MessageBox.Show("برای این میز بازی یک رله اختصاص داده شده است.", "کاربر گرامی", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } RaspBerryPlayingBoard.Insert(raspberryPin, playingBoard, myConnection); raspberryPin.IsAvailable = false; myConnection.SubmitChanges(); DataValidationMesaage.AcceptMessage(); RaspberryPin.LoadComboBoxAvailables(cmbRaspberryRelay, myConnection); RaspBerryPlayingBoard.ShowList(lstRaspberryRelays, myConnection); }
private void btnGameStart_Click(object sender, EventArgs e) { if (gridMember.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridMember.Text); return; } if (gridPlayingBoard.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoard.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #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 #region Memeber Cast 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); #endregion if (!myConnection.PlayingBoardTypes.Any(a => a.PlayingBoard == playingBoard)) { MessageBox.Show("برای این میز بازی هیچ قیمتی ثبت نشده است.", "کاربر گرامی", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (myConnection.RaspBerryPlayingBoards.Any(a => a.PlayingBoard == playingBoard)) { #region RaspBerryPlayingBoard Cast if (!RaspBerryPlayingBoard.Validation_By_PlayingBoardID(playingBoardId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } RaspBerryPlayingBoard raspBerryPlayingBoard = RaspBerryPlayingBoard.Get_By_PlayingBoardID(playingBoardId, myConnection); #endregion MemberRentPlayingBoard.PowerOnOff(raspBerryPlayingBoard.RaspberryPin, "1", Setting.RaspberryIPAddress, Setting.RaspberryPortNumber); } #region PlayingBoardType Cast int playingBoardTypeID = ((PlayingBoardType)cmbPlayingBoardType.SelectedItem).ID; if (!PlayingBoardType.Validation(playingBoardTypeID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardType playingBoardType = PlayingBoardType.Get(playingBoardTypeID, myConnection); #endregion MyRentPlayingBoard = RentPlayingBoard.Insert(playingBoardType, DateTime.Now, DateTime.Now.ToString("HH:mm:ss"), DateTime.Now.ToString("HH:mm:ss"), true, myConnection); MemberRentPlayingBoard.Insert(MyRentPlayingBoard, member, "opener", myConnection); playingBoard.IsAvailable = false; myConnection.SubmitChanges(); PlayingBoard.LoadGridAvailables(gridPlayingBoard, myConnection); MessageBox.Show("بازی شروع شد.", "کاربر گرامی", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); myConnection.Dispose(); }
private void btnSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrEmpty(txtNumber.Text) || string.IsNullOrWhiteSpace(txtNumber.Text)) { DataValidationMesaage.BlankTextBox("شماره دستگاه"); return; } 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))) { DataValidationMesaage.BlankComboBox("عنوان دستگاه"); return; } if ( myConnection.PlayingBoardTitles.Any( a => a.Title.Equals(txtNumber.Text.Trim()) && a.PlayingBoardGroupTitle.Equals(playingBoardGroupTitle))) { MessageBox.Show("کاربر گرامی مقادیر شماره میز و عنوان بازی نمیتوانند یکسان باشند.", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } #region PlayingBoardTitle Cast int id = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID; if (!PlayingBoardTitle.Validation(id, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(id, myConnection); #endregion if (myConnection.PlayingBoards.Any(a => a.PlayingBoardTitle == playingBoardTitle && a.Number.Equals(txtNumber.Text.Trim()))) { DataValidationMesaage.DuplicateData("شماره میز"); return; } PlayingBoard playingBoard = PlayingBoard.Insert(playingBoardTitle, txtNumber.Text, true, myConnection); DataValidationMesaage.AcceptMessage(); DialogResult result1 = MessageBox.Show("آیا مایلید برق میز بازی ثبت شده را به صورت سیستمی کنترل نمایید؟", "کاربر گرامی", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result1 == DialogResult.Yes) { btnRaspberryRelay.PerformClick(); } DialogResult result2 = MessageBox.Show("آیا مایلید برای میز بازی ثبت شده بهاء تعیین نمایید؟", "کاربر گرامی", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result2 == DialogResult.Yes) { btnPrice.PerformClick(); } clearTextBox(); PlayingBoard.LoadGridColorful_By_PlayingBoardTitle(gridPlayingBoard, playingBoardTitle, myConnection); }
private void btnYes_Click(object sender, EventArgs e) { #region Check Blank txtNumber if (string.IsNullOrEmpty(txtNumber.Text.Trim()) && string.IsNullOrWhiteSpace(txtNumber.Text.Trim())) { DataValidationMesaage.BlankTextBox("شماره دستگاه"); return; } #endregion DataBaseDataContext myConnection = Setting.DataBase; if (myConnection.PlayingBoardGroupTitles.Any()) { #region PlayingBoardTitle Cast int playingBoardTitleId = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID; if (!PlayingBoardTitle.Validation(playingBoardTitleId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(playingBoardTitleId, myConnection); #endregion #region Check Duplicate cmbPlayingBoardTitle and txtNumber if ( myConnection.PlayingBoards.Any( a => a.PlayingBoardTitle.Title.Equals(txtNumber.Text.Trim()))) { MessageBox.Show("کاربر گرامی مقادیر شماره میز و عنوان بازی نمیتوانند یکسان باشند.", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } #endregion #region Check Duplicate Data if ( myConnection.PlayingBoards.Any( a => a.Number.Equals(txtNumber.Text.Trim()) && a.PlayingBoardTitle.Equals(playingBoardTitle))) { DataValidationMesaage.DuplicateData("شماره میز"); return; } #endregion #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 PlayingBoard.Edit(playingBoard, playingBoardTitle, txtNumber.Text.Trim(), true, myConnection); DataValidationMesaage.EditMessage(); clearTextBox(); FormManagement.DisableYesNoIncludingComboBox(this.Controls); PlayingBoard.LoadGridColorful_By_PlayingBoardTitle(gridPlayingBoard, playingBoardTitle, myConnection); } myConnection.Dispose(); }
private void cmbPlayingBoardGroupTitle_SelectedIndexChanged(object sender, EventArgs e) { gridPlayingBoard.Rows.Clear(); DataBaseDataContext myConnection = Setting.DataBase; if (myConnection.PlayingBoardGroupTitles.Any()) { btnAddPlayingboardTitle.Visible = true; #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.LoadGridColorful_By_PlayingBoardTitle(gridPlayingBoard, playingBoardTitle, myConnection); } } else { btnAddPlayingboardTitle.Visible = false; cmbPlayingBoardTitle.Items.Add("گروه بازی کامل شود"); cmbPlayingBoardTitle.SelectedIndex = 0; return; } }