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) { if (string.IsNullOrWhiteSpace(txtBankTitle.Text.Trim()) || string.IsNullOrEmpty(txtBankTitle.Text.Trim())) { DataValidationMesaage.BlankTextBox("عنوان بانک"); return; } DataBaseDataContext myConnection = Setting.DataBase; if (myConnection.BankAccounts.Any(a => a.BankTitle.Equals(txtBankTitle.Text.Trim()))) { DataValidationMesaage.DuplicateData("عنوان بانک"); return; } BankAccount.Insert(txtBankTitle.Text.Trim(), txtCardNumber.Text.Trim(), txtAccountNumber.Text.Trim(), myConnection); ClearTextBoxes(); myConnection.Dispose(); }
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(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 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 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 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 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; #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 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 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(); }
private void btnYes_Click(object sender, EventArgs e) { DataBaseDataContext connection = Setting.DataBase; if (string.IsNullOrWhiteSpace(txtRaspBerryIP.Text.Trim()) || string.IsNullOrEmpty(txtRaspBerryIP.Text.Trim())) { DataValidationMesaage.BlankTextBox("آدرس آی پی کنترلر برق"); return; } if (!ValidateIPv4(txtRaspBerryIP.Text.Trim())) { MessageBox.Show(" کاربر گرامی مقدار وارد شده یک آدرس آی پی معتبر نمی باشد ", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } Configuration.Insert(txtRaspBerryIP.Text.Trim(), "9999", connection); MessageBox.Show("تنظیمات اولیه با موفقیت انجام شد ", "کاربر گرامی", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); }
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 btnSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; #region Level Casting int levelId = ((Level)cmbLevel.SelectedItem).ID; if (!Level.Validation(levelId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Level level = Level.Get(levelId, myConnection); #endregion #region Phone Casting int phoneId = ((Phone)cmbPhone.SelectedItem).ID; if (!Phone.Validation(phoneId, myConnection)) { //TODO Fix Message DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneId, myConnection); #endregion #region Save Image if (!flag) { Image picImage = Properties.Resources.profile; picBox.Image = picImage; picImage.Save(_memoryStream, picBox.Image.RawFormat); _myArray = _memoryStream.GetBuffer(); } if (flag) { _image.Save(_memoryStream, picBox.Image.RawFormat); _myArray = _memoryStream.GetBuffer(); } #endregion if (myConnection.Members.Any(a => a.Code == txtCode.Text)) { DataValidationMesaage.DuplicateData(txtCode.Text); return; } if (myConnection.Members.Any(a => a.NationalCode == txtNationalCode.Text)) { DataValidationMesaage.DuplicateData(txtNationalCode.Text); return; } if (string.IsNullOrEmpty(txtNationalCode.Text.Trim()) || string.IsNullOrWhiteSpace(txtNationalCode.Text.Trim())) { DataValidationMesaage.BlankTextBox("کد ملی"); return; } if (!BTM.Date.Validation(txtBirthDate.Text)) { MessageBox.Show("قالب تاریخ تولد وارد شده صحیح نمی باشد", "اخطار در ورود اطلاعات", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } Member member = Member.Insert(txtCode.Text.Trim(), txtFirstName.Text.Trim(), txtLastName.Text.Trim(), txtNationalCode.Text.Trim(), BTM.Date.ConvertToGorgianDate(txtBirthDate.Text.Trim()), cmbType.Text.Trim(), cmbSex.Text.Trim(), _myArray, false, level, myConnection); PhoneNumber.Insert(phone, member, true, CorrectPhoneNumber(), myConnection); if (txtSocialAccount.Text.Length > 0) { #region SocialNetwork Casting int socialNetworkTypeID = ((SocialNetworkType)cmbSocialNetworkType.SelectedItem).ID; if (!Phone.Validation(socialNetworkTypeID, myConnection)) { //TODO Fix Message DataValidationMesaage.NoDataInBank(); return; } SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeID, myConnection); #endregion SocialNetworkAccount.Insert(socialNetworkType, member, true, txtSocialAccount.Text.Trim(), myConnection); } GetCode(); Member.LoadGridJoinSocialNetworkAccountJoinPhoneNumber(gridMember, myConnection); ClearTextBox(); myConnection.Dispose(); }
private void btnPayment_Click(object sender, EventArgs e) { if (gridMember.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridMember.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region RentPlayingBoard Cast int rentid = memberRentPlayingBoard.RentPlayingBoardID; if (!RentPlayingBoard.Validation(rentid, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } RentPlayingBoard rentPlayingBoard = RentPlayingBoard.Get(rentid, myConnection); #endregion if (radioOther.Checked) { #region Member Cast int id = int.Parse(gridMember.SelectedRows[0].Cells[1].Value.ToString()); if (!Member.Validation(id, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } _member = Member.Get(id, myConnection); #endregion } if (radioMySelf.Checked) { #region Member Cast int id = memberRentPlayingBoard.Member.ID; if (!Member.Validation(id, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } _member = Member.Get(id, myConnection); #endregion } RentPlayingBoard myRentPlayingBoard = RentPlayingBoard.Edit(rentPlayingBoard, DateTime.Now.ToString("HH:mm:ss"), false, myConnection); MemberRentPlayingBoard closerMemberRentPlayingBoard = MemberRentPlayingBoard.Insert(myRentPlayingBoard, _member, "Closer", myConnection); myRentPlayingBoard.PlayingBoardType.PlayingBoard.IsAvailable = true; int playingBoardID = myRentPlayingBoard.PlayingBoardType.PlayingBoardID; #region Raspberry Check and Turn off if (myConnection.RaspBerryPlayingBoards.Any(a => a.PlayingBoardID.Equals(playingBoardID))) { if (!RaspBerryPlayingBoard.Validation_By_PlayingBoardID(playingBoardID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } #region RaspBerryPlayingBoard Cast RaspBerryPlayingBoard raspBerryPlayingBoard = RaspBerryPlayingBoard.Get_By_PlayingBoardID( playingBoardID, myConnection); #endregion MemberRentPlayingBoard.PowerOnOff(raspBerryPlayingBoard.RaspberryPin, "0", Setting.RaspberryIPAddress, Setting.RaspberryPortNumber); } #endregion bool isCredit = true && cmbIsCredit.SelectedText.Equals("نسیه"); bool isCard = true && radioCard.Checked; if (string.IsNullOrWhiteSpace(txtPrice.Text.Trim()) || string.IsNullOrEmpty(txtPrice.Text.Trim())) { DataValidationMesaage.BlankTextBox("مبلغ پرداختی"); return; } if (isCard) { if (string.IsNullOrWhiteSpace(txtCardPaymentIdentity.Text.Trim()) || string.IsNullOrEmpty(txtCardPaymentIdentity.Text.Trim())) { DataValidationMesaage.BlankTextBox("شناسه پرداخت"); return; } if (myConnection.CardSerialPayments.Any(a => a.CardPaymentIdentity.Equals(txtCardPaymentIdentity.Text.Trim()))) { DataValidationMesaage.DuplicateData("شناسه پرداخت"); return; } } Payment payment = Payment.Insert(int.Parse(txtPrice.Text.Trim()), DateTime.Now, isCredit, isCard, "", closerMemberRentPlayingBoard.ID, _member, myConnection); if (isCard) { CardSerialPayment.Insert(txtCardPaymentIdentity.Text.Trim(), txtCardNumber.Text.Trim(), txtAccountNumber.Text.Trim(), payment, (BankAccount)cmbBankAccount.SelectedItem, myConnection); } myConnection.SubmitChanges(); MessageBox.Show("بازی تمام شد."); DialogResult message = MessageBox.Show( "پرداخت انجام شد و میز بازی بسته شد. آیا مایل هستید پنجره جاری بسته شود؟ ", "کاربر گرامی", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (message == DialogResult.Yes) { this.Close(); } 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 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 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); }