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();
}
