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 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 (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 صندوقچهامانات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 (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 (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 (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 تعیینبهاء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 gridPlayingBoard_Click(object sender, EventArgs e) { if (gridPlayingBoard.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoard.Text); return; } lblPlayingBoardTitle.Text = gridPlayingBoard.SelectedRows[0].Cells[2].Value.ToString(); }
private void gridMember_Click(object sender, EventArgs e) { if (gridMember.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridMember.Text); return; } lblName.Text = gridMember.SelectedRows[0].Cells[3].Value.ToString(); }
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 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 کنترلبرقToolStripMenuItem_Click_1(object sender, EventArgs e) { #region No ListItem Selected if (gridPlayingBoard.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoard.Text); return; } #endregion FrmSetRaspberryRelays frm = new FrmSetRaspberryRelays(); frm.ShowDialog(); }
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 (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 (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 (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 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 btnDelete_Click(object sender, EventArgs e) { if (gridCabinetMembers.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridCabinetMembers.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region MemberCabinet Cast int memberCabinetID = int.Parse(gridCabinetMembers.SelectedRows[0].Cells[1].Value.ToString()); if (!MemberCabinet.Validation(memberCabinetID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } MemberCabinet memberCabinet = MemberCabinet.Get(memberCabinetID, myConnection); #endregion // MemberCabinet.Delete(memberCabinet, myConnection); memberCabinet.Cabinet.IsAvailable = true; memberCabinet.Status = false; myConnection.SubmitChanges(); MemberCabinet.LoadGridMemberCabinet(gridCabinetMembers, myConnection); myConnection.Dispose(); }
private void btnDelete_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; } playingBoardType = PlayingBoardType.Get(playingBoardType.ID, myConnection); DialogResult message = DataValidationMesaage.ConfirmDeleteData(playingBoardType.Type); if (message == DialogResult.Yes) { PlayingBoardType.Delete(playingBoardType, myConnection); DataValidationMesaage.DeleteMessage(); PlayingBoardType.ShowList_By_PlayingBoard(FrmPlayingBoard.SelectedPlayingBoard, lstPlayingBoardTypes, myConnection); } myConnection.Dispose(); }
private void btnDelete_Click(object sender, EventArgs e) { if (gridMember.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridMember.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region Member Casting int memeberId = int.Parse(gridMember.SelectedRows[0].Cells[1].Value.ToString()); if (!Member.Validation(memeberId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Member member = Member.Get(memeberId, myConnection); #endregion #region PhoneNumber Casting string gridPhoneNumber = gridMember.SelectedRows[0].Cells[9].Value.ToString(); PhoneNumber phoneNumber = myConnection.PhoneNumbers.FirstOrDefault(a => a.Number == gridPhoneNumber && a.Member == member); if (!PhoneNumber.Validation(phoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } #endregion #region SocialNetworkAccount Casting string gridSocialAccount = gridMember.SelectedRows[0].Cells[8].Value.ToString(); SocialNetworkAccount socialNetworkAccount = myConnection.SocialNetworkAccounts.FirstOrDefault( a => a.Account == gridSocialAccount && a.Member == member); if (!SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } #endregion DialogResult message = DataValidationMesaage.ConfirmDeleteData(member.Code); if (message == DialogResult.Yes) { PhoneNumber.Delete(phoneNumber, myConnection); SocialNetworkAccount.Delete(socialNetworkAccount, myConnection); Member.Delete(member, myConnection); DataValidationMesaage.DeleteMessage(); GetCode(); Member.LoadGridJoinSocialNetworkAccountJoinPhoneNumber(gridMember, 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 btnPhoneEdit_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (lstPhoneNumber.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست شماره های تماس"); 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 #region PhoneNumber Casting PhoneNumber phoneNumber = (PhoneNumber)lstPhoneNumber.SelectedItems[0].Tag; if (!PhoneNumber.Validation(phoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } phoneNumber = PhoneNumber.Get(phoneNumber.ID, myConnection); #endregion DialogResult message = MessageBox.Show("در صورت تایید شماره تماس فعلی فعال گردیده و مابقی غیرفعال میگردند", "کاربر گرامی", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (message == DialogResult.Yes) { if (lstPhoneNumber.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست شماره های تماس"); return; } var query = myConnection.PhoneNumbers.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } PhoneNumber.Edit(phoneNumber, phone, member, true, txtPhoneNumber.Text, myConnection); txtPhoneNumber.Clear(); PhoneNumber.ShowListByMember(lstPhoneNumber, member, myConnection); } myConnection.Dispose(); }
private void btnPhoneDelete_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (lstPhoneNumber.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست شماره های تماس"); 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 #region PhoneNumber Casting PhoneNumber phoneNumber = (PhoneNumber)lstPhoneNumber.SelectedItems[0].Tag; if (!PhoneNumber.Validation(phoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } phoneNumber = PhoneNumber.Get(phoneNumber.ID, myConnection); #endregion DialogResult messageResult = DataValidationMesaage.ConfirmDeleteData(lstPhoneNumber.SelectedItems[0].SubItems[1].Text); if (messageResult == DialogResult.Yes) { if (phoneNumber.Status) { #region NextPhoneNumber Casting int nextPhoneNumberIndex = (int.Parse(lstPhoneNumber.SelectedItems[0].Text)) % lstPhoneNumber.Items.Count; PhoneNumber nextPhoneNumber = (PhoneNumber)lstPhoneNumber.Items[nextPhoneNumberIndex].Tag; if (!PhoneNumber.Validation(nextPhoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } nextPhoneNumber = PhoneNumber.Get(nextPhoneNumber.ID, myConnection); var query = myConnection.PhoneNumbers.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } #endregion nextPhoneNumber.Status = true; myConnection.SubmitChanges(); } PhoneNumber.Delete(phoneNumber, myConnection); PhoneNumber.ShowListByMember(lstPhoneNumber, FrmMember.MemberProfile, myConnection); if (lstPhoneNumber.Items.Count == 1) { btnPhoneDelete.Enabled = false; } } txtPhoneNumber.Clear(); 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 btnSocialAccountEdit_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (lstSocialNetwork.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست اکانت های شبکه های اجتماعی"); 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 #region SocialNetworkAccount Casting SocialNetworkAccount socialNetworkAccount = (SocialNetworkAccount)lstSocialNetwork.SelectedItems[0].Tag; if (!SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } socialNetworkAccount = SocialNetworkAccount.Get(socialNetworkAccount.ID, myConnection); #endregion DialogResult message = MessageBox.Show("در صورت تایید اکانت فعلی فعال گردیده و مابقی غیرفعال میگردند", "کاربر گرامی", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (message == DialogResult.Yes) { if (lstSocialNetwork.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست اکانت های شبکه های اجتماعی"); return; } var query = myConnection.SocialNetworkAccounts.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } SocialNetworkAccount.Edit(socialNetworkAccount, socialNetworkType, member, true, txtSocialAccount.Text.Trim(), myConnection); txtSocialAccount.Clear(); SocialNetworkAccount.ShowListByMember(lstSocialNetwork, member, myConnection); } myConnection.Dispose(); }
private void btnSocialAccountDelete_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (lstSocialNetwork.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست اکانت های شبکه های اجتماعی"); 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 #region SocialNetworkAccount Casting SocialNetworkAccount socialNetworkAccount = (SocialNetworkAccount)lstSocialNetwork.SelectedItems[0].Tag; if (!SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } socialNetworkAccount = SocialNetworkAccount.Get(socialNetworkAccount.ID, myConnection); #endregion DialogResult messageResult = DataValidationMesaage.ConfirmDeleteData(lstSocialNetwork.SelectedItems[0].SubItems[1].Text); if (messageResult == DialogResult.Yes) { if (socialNetworkAccount.Status) { #region NextSocialNetworkAccount Casting int nextSocialNetworkAccountIndex = (int.Parse(lstSocialNetwork.SelectedItems[0].Text)) % lstSocialNetwork.Items.Count; SocialNetworkAccount nextSocialNetworkAccount = (SocialNetworkAccount)lstSocialNetwork.Items[nextSocialNetworkAccountIndex].Tag; if (!SocialNetworkAccount.Validation(nextSocialNetworkAccount.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } nextSocialNetworkAccount = SocialNetworkAccount.Get(nextSocialNetworkAccount.ID, myConnection); var query = myConnection.SocialNetworkAccounts.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } #endregion nextSocialNetworkAccount.Status = true; myConnection.SubmitChanges(); } SocialNetworkAccount.Delete(socialNetworkAccount, myConnection); SocialNetworkAccount.ShowListByMember(lstSocialNetwork, FrmMember.MemberProfile, myConnection); if (lstSocialNetwork.Items.Count == 1) { btnPhoneDelete.Enabled = false; } } txtSocialAccount.Clear(); myConnection.Dispose(); }