private void btnSave_Click(object sender, EventArgs e)
{
PlayingBoard playingBoard = FrmPlayingBoard.SelectedPlayingBoard;
if (int.Parse(txtPrice.Text.Trim()).Equals(0) || string.IsNullOrWhiteSpace(txtPrice.Text.Trim()) || string.IsNullOrEmpty(txtPrice.Text.Trim()))
{
DataValidationMesaage.BlankTextBox("بهای میز");
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
if (
myConnection.PlayingBoardTypes.Any(
a => a.Type == cmbType.SelectedItem.ToString() && a.PlayingBoard == playingBoard))
{
DataValidationMesaage.DuplicateData(cmbType.SelectedItem.ToString());
return;
}
PlayingBoardType.Insert(playingBoard, cmbType.SelectedItem.ToString(),
int.Parse(txtPrice.Text.Trim()), myConnection);
DataValidationMesaage.AcceptMessage();
PlayingBoardType.ShowList_By_PlayingBoard(playingBoard, lstPlayingBoardTypes, myConnection);
myConnection.Dispose();
}
private void btnSave_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrWhiteSpace(txtTitle.Text))
{
DataValidationMesaage.BlankTextBox("عنوان");
return;
}
if (myConnection.Phones.Any(a => a.Title == txtTitle.Text.Trim()))
{
DataValidationMesaage.DuplicateData(txtTitle.Text);
return;
}
Phone phone = Phone.Insert(txtTitle.Text.Trim(), myConnection);
clearTextBox();
DataValidationMesaage.AcceptMessage(phone.Title);
Phone.LoadGrid(gridPhone, myConnection);
}
private void btnSave_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (string.IsNullOrWhiteSpace(txtTitle.Text) || string.IsNullOrEmpty(txtTitle.Text))
{
DataValidationMesaage.BlankTextBox("عنوان");
return;
}
if (myConnection.Cabinets.Any(a => a.Title == txtTitle.Text.Trim()))
{
DataValidationMesaage.DuplicateData("عنوان");
return;
}
Cabinet cabinet = Cabinet.Insert(txtTitle.Text, true, myConnection);
DataValidationMesaage.AcceptMessage(cabinet.Title);
clearTextBox();
Cabinet.LoadGridColorful(gridCabinet, myConnection);
myConnection.Dispose();
}
private void btnSave_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (string.IsNullOrEmpty(txtNumber.Text) || string.IsNullOrWhiteSpace(txtNumber.Text))
{
DataValidationMesaage.BlankTextBox("شماره دستگاه");
return;
}
if (myConnection.PlayingBoardGroupTitles.Any())
{
#region PlayingBoardGroupTitle Cast
int playingBoardGroupTitleId = ((PlayingBoardGroupTitle)cmbPlayingBoardGroupTitle.SelectedItem).ID;
if (!PlayingBoardGroupTitle.Validation(playingBoardGroupTitleId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoardGroupTitle playingBoardGroupTitle = PlayingBoardGroupTitle.Get(playingBoardGroupTitleId,
myConnection);
#endregion
if (!myConnection.PlayingBoardTitles.Any(a => a.PlayingBoardGroupTitle.Equals(playingBoardGroupTitle)))
{
DataValidationMesaage.BlankComboBox("عنوان دستگاه");
return;
}
if (
myConnection.PlayingBoardTitles.Any(
a =>
a.Title.Equals(txtNumber.Text.Trim()) &&
a.PlayingBoardGroupTitle.Equals(playingBoardGroupTitle)))
{
MessageBox.Show("کاربر گرامی مقادیر شماره میز و عنوان بازی نمیتوانند یکسان باشند.",
"اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
#region PlayingBoardTitle Cast
int id = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID;
if (!PlayingBoardTitle.Validation(id, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(id, myConnection);
#endregion
if (myConnection.PlayingBoards.Any(a => a.PlayingBoardTitle == playingBoardTitle && a.Number.Equals(txtNumber.Text.Trim())))
{
DataValidationMesaage.DuplicateData("شماره میز");
return;
}
PlayingBoard playingBoard = PlayingBoard.Insert(playingBoardTitle, txtNumber.Text, true, myConnection);
DataValidationMesaage.AcceptMessage();
DialogResult result1 = MessageBox.Show("آیا مایلید برق میز بازی ثبت شده را به صورت سیستمی کنترل نمایید؟", "کاربر گرامی", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result1 == DialogResult.Yes)
{
btnRaspberryRelay.PerformClick();
}
DialogResult result2 = MessageBox.Show("آیا مایلید برای میز بازی ثبت شده بهاء تعیین نمایید؟", "کاربر گرامی", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result2 == DialogResult.Yes)
{
btnPrice.PerformClick();
}
clearTextBox();
PlayingBoard.LoadGridColorful_By_PlayingBoardTitle(gridPlayingBoard, playingBoardTitle, myConnection);
}
private void btnPhoneSave_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (string.IsNullOrWhiteSpace(txtPhoneNumber.Text) || string.IsNullOrEmpty(txtPhoneNumber.Text))
{
DataValidationMesaage.BlankTextBox("شماره تماس");
return;
}
#region Member Casting
int memberId = FrmMember.MemberProfile.ID;
if (!Member.Validation(memberId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Member member = Member.Get(memberId, myConnection);
#endregion
#region Phone Casting
int phoneId = ((Phone)cmbPhone.SelectedItem).ID;
if (!Phone.Validation(phoneId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Phone phone = Phone.Get(phoneId, myConnection);
#endregion
if (myConnection.PhoneNumbers.Any(a => a.Number == txtPhoneNumber.Text.Trim() && a.Member == member && a.Phone == phone))
{
DataValidationMesaage.DuplicateData(txtPhoneNumber.Text.Trim());
return;
}
var query = myConnection.PhoneNumbers.Where(a => a.Member == member);
foreach (var item in query)
{
item.Status = false;
myConnection.SubmitChanges();
}
PhoneNumber phoneNumber = PhoneNumber.Insert(phone, member, true, txtPhoneNumber.Text, myConnection);
DataValidationMesaage.AcceptMessage(phoneNumber.Number);
PhoneNumber.ShowListByMember(lstPhoneNumber, member, myConnection);
txtPhoneNumber.Clear();
if (lstPhoneNumber.Items.Count > 1)
{
btnPhoneDelete.Enabled = true;
}
myConnection.Dispose();
}
private void btnSocialAccountSave_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (string.IsNullOrWhiteSpace(txtSocialAccount.Text) || string.IsNullOrEmpty(txtSocialAccount.Text))
{
DataValidationMesaage.BlankTextBox("اکانت شبکه های اجتماعی");
return;
}
#region Member Casting
int memberId = FrmMember.MemberProfile.ID;
if (!Member.Validation(memberId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Member member = Member.Get(memberId, myConnection);
#endregion
#region SocialNetworkType Casting
int socialNetworkTypeId = ((SocialNetworkType)cmbSocialAccount.SelectedItem).ID;
if (!SocialNetworkType.Validation(socialNetworkTypeId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeId, myConnection);
#endregion
if (myConnection.SocialNetworkAccounts.Any(
a => a.Account == txtSocialAccount.Text.Trim() && a.Member == member &&
a.SocialNetworkType == socialNetworkType))
{
DataValidationMesaage.DuplicateData(txtSocialAccount.Text.Trim());
return;
}
var query = myConnection.SocialNetworkAccounts.Where(a => a.Member == member);
foreach (var item in query)
{
item.Status = false;
myConnection.SubmitChanges();
}
SocialNetworkAccount socialNetworkAccount = SocialNetworkAccount.Insert(socialNetworkType, member, true, txtSocialAccount.Text.Trim(), myConnection);
DataValidationMesaage.AcceptMessage(socialNetworkAccount.Account);
SocialNetworkAccount.ShowListByMember(lstSocialNetwork, member, myConnection);
txtSocialAccount.Clear();
if (lstSocialNetwork.Items.Count > 1)
{
btnSocialAccountDelete.Enabled = true;
}
myConnection.Dispose();
}
private void btnSave_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (cmbPlayingBoard.SelectedItem == null)
{
DataValidationMesaage.NoSelectedItemFromList("لیست میزهای بازی");
return;
}
#region PlayingBoard Cast
int playingBoardId = ((PlayingBoard)cmbPlayingBoard.SelectedItem).ID;
if (!PlayingBoard.Validation(playingBoardId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoard playingBoard = PlayingBoard.Get(playingBoardId, myConnection);
#endregion
#region RaspberryPin Cast
int raspberryPinID = ((RaspberryPin)cmbRaspberryRelay.SelectedItem).ID;
if (!RaspberryPin.Validation(raspberryPinID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
RaspberryPin raspberryPin = RaspberryPin.Get(raspberryPinID, myConnection);
#endregion
if (myConnection.RaspBerryPlayingBoards.Any(a => a.PlayingBoard == playingBoard))
{
MessageBox.Show("برای این میز بازی یک رله اختصاص داده شده است.", "کاربر گرامی", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
RaspBerryPlayingBoard.Insert(raspberryPin, playingBoard, myConnection);
raspberryPin.IsAvailable = false;
myConnection.SubmitChanges();
DataValidationMesaage.AcceptMessage();
RaspberryPin.LoadComboBoxAvailables(cmbRaspberryRelay, myConnection);
RaspBerryPlayingBoard.ShowList(lstRaspberryRelays, myConnection);
}
