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 btnSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrWhiteSpace(txtTitle.Text)) { DataValidationMesaage.BlankTextBox("عنوان"); return; } if (myConnection.Phones.Any(a => a.Title == txtTitle.Text.Trim())) { DataValidationMesaage.DuplicateData(txtTitle.Text); return; } Phone phone = Phone.Insert(txtTitle.Text.Trim(), myConnection); clearTextBox(); DataValidationMesaage.AcceptMessage(phone.Title); Phone.LoadGrid(gridPhone, myConnection); }
private void btnSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrWhiteSpace(txtTitle.Text) || string.IsNullOrEmpty(txtTitle.Text)) { DataValidationMesaage.BlankTextBox("عنوان"); return; } if (myConnection.Cabinets.Any(a => a.Title == txtTitle.Text.Trim())) { DataValidationMesaage.DuplicateData("عنوان"); return; } Cabinet cabinet = Cabinet.Insert(txtTitle.Text, true, myConnection); DataValidationMesaage.AcceptMessage(cabinet.Title); clearTextBox(); Cabinet.LoadGridColorful(gridCabinet, myConnection); 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 btnPhoneSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrWhiteSpace(txtPhoneNumber.Text) || string.IsNullOrEmpty(txtPhoneNumber.Text)) { DataValidationMesaage.BlankTextBox("شماره تماس"); 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 if (myConnection.PhoneNumbers.Any(a => a.Number == txtPhoneNumber.Text.Trim() && a.Member == member && a.Phone == phone)) { DataValidationMesaage.DuplicateData(txtPhoneNumber.Text.Trim()); return; } var query = myConnection.PhoneNumbers.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } PhoneNumber phoneNumber = PhoneNumber.Insert(phone, member, true, txtPhoneNumber.Text, myConnection); DataValidationMesaage.AcceptMessage(phoneNumber.Number); PhoneNumber.ShowListByMember(lstPhoneNumber, member, myConnection); txtPhoneNumber.Clear(); if (lstPhoneNumber.Items.Count > 1) { btnPhoneDelete.Enabled = true; } myConnection.Dispose(); }
private void btnSocialAccountSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrWhiteSpace(txtSocialAccount.Text) || string.IsNullOrEmpty(txtSocialAccount.Text)) { DataValidationMesaage.BlankTextBox("اکانت شبکه های اجتماعی"); 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 if (myConnection.SocialNetworkAccounts.Any( a => a.Account == txtSocialAccount.Text.Trim() && a.Member == member && a.SocialNetworkType == socialNetworkType)) { DataValidationMesaage.DuplicateData(txtSocialAccount.Text.Trim()); return; } var query = myConnection.SocialNetworkAccounts.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } SocialNetworkAccount socialNetworkAccount = SocialNetworkAccount.Insert(socialNetworkType, member, true, txtSocialAccount.Text.Trim(), myConnection); DataValidationMesaage.AcceptMessage(socialNetworkAccount.Account); SocialNetworkAccount.ShowListByMember(lstSocialNetwork, member, myConnection); txtSocialAccount.Clear(); if (lstSocialNetwork.Items.Count > 1) { btnSocialAccountDelete.Enabled = true; } myConnection.Dispose(); }
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); }