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)
{
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.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;
#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;
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 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 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 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 btnYes_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtFirstName.Text) || string.IsNullOrEmpty(txtLastName.Text) ||
string.IsNullOrEmpty(txtNationalCode.Text) ||
string.IsNullOrWhiteSpace(txtFirstName.Text) || string.IsNullOrWhiteSpace(txtLastName.Text) ||
string.IsNullOrWhiteSpace(txtNationalCode.Text))
{
MessageBox.Show("کاربر گرامی مقادیر نام یا نام خانوادگی یا کد ملی نمی توانند خالی باشند ", "اخطار در ورود اطلاعات", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
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 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 != null && !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 != null && !SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
#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 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
bool query = myConnection.PhoneNumbers.Any(a => a.Number == CorrectPhoneNumber() &&
a.Member == member && a.ID != phoneNumber.ID);
if (query)
{
DataValidationMesaage.DuplicateData("شماره تماس برای این کاربر");
return;
}
query =
myConnection.SocialNetworkAccounts.Any(
a =>
a.Account == txtSocialAccount.Text.Trim() && a.Member == member &&
a.ID != socialNetworkAccount.ID);
if (query)
{
DataValidationMesaage.DuplicateData("اکانت شبکه های اجتماعی برای این کاربر");
return;
}
query = myConnection.Members.Any(a => a.NationalCode == txtNationalCode.Text.Trim() && a.ID != memeberId);
if (query)
{
DataValidationMesaage.DuplicateData("کاربر با این کد ملی");
return;
}
if (!flag)
{
Image picImage = Properties.Resources.profile;
picBox.Image = picImage;
picImage.Save(_memory, picBox.Image.RawFormat);
_myArray = _memory.GetBuffer();
}
if (flag)
{
_image.Save(_memory, picBox.Image.RawFormat);
_myArray = _memory.GetBuffer();
}
Phone.Edit(phone, cmbPhone.Text.Trim(), myConnection);
PhoneNumber.Edit(phoneNumber, phone, member, true, CorrectPhoneNumber(), myConnection);
SocialNetworkType.Edit(socialNetworkType, cmbSocialNetworkType.Text.Trim(), myConnection);
SocialNetworkAccount.Edit(socialNetworkAccount, socialNetworkType, member, true, txtSocialAccount.Text.Trim(), myConnection);
//TODO How to check Has Cabinet or not?
Member.Edit(member, 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, level, myConnection);
DataValidationMesaage.EditMessage();
ClearTextBox();
txtFirstName.Focus();
Member.LoadGridJoinSocialNetworkAccountJoinPhoneNumber(gridMember, myConnection);
FormManagement.DisableYesNo(this.Controls);
}
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 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 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();
}
