private void FrmClosePlayingBoard_Load(object sender, EventArgs e)
{
if (_memberRentPlaying.Day > 0)
{
lblElapsedTime.Text = _memberRentPlaying.Day + ":" +
_memberRentPlaying.Hour.ToString("d2") + ":" +
_memberRentPlaying.Minute.ToString("d2") + ":" +
_memberRentPlaying.Second.ToString("d2");
}
else
{
lblElapsedTime.Text = _memberRentPlaying.Hour.ToString("d2") + ":" +
_memberRentPlaying.Minute.ToString("d2") + ":" +
_memberRentPlaying.Second.ToString("d2");
}
lblPayment.Text = _memberRentPlaying.Payment.ToString();
lblPlayingBorad.Text = _memberRentPlaying.RentPlayingBoard.PlayingBoardType.PlayingBoard.PlayingBoardTitle.Title + " " +
_memberRentPlaying.RentPlayingBoard.PlayingBoardType.PlayingBoard.Number;
DataBaseDataContext myConnection = Setting.DataBase;
memberRentPlayingBoard =
myConnection.MemberRentPlayingBoards.First(
a => a.RentPlayingBoard.ID == _memberRentPlaying.RentPlayingBoard.ID);
lblMemberRenter.Text = memberRentPlayingBoard.Member.FirstName + " " +
memberRentPlayingBoard.Member.LastName;
Member.LoadGridBriefly(gridMember, myConnection);
BankAccount.LoadComboBox(cmbBankAccount, Setting.DataBase);
cmbSearchMemberBy.SelectedIndex = 0;
cmbSearchMemberBy.Enabled = false;
txtSearchMember.Enabled = false;
gridMember.Enabled = false;
cmbIsCredit.SelectedIndex = 0;
int price = int.Parse(lblPayment.Text);
int roundedPrice = 500 * ((price / 500) + 1);
txtPrice.Text = roundedPrice.ToString();
myConnection.Dispose();
}
public static void Edit(MemberRentPlayingBoard memberRentPlayingBoard, RentPlayingBoard rentPlayingBoard, Member member,
string type, DataBaseDataContext connection)
{
memberRentPlayingBoard.Type = type;
memberRentPlayingBoard.RentPlayingBoard = rentPlayingBoard;
memberRentPlayingBoard.Member = member;
connection.SubmitChanges();
}
public void AddPanoramaTile(MemberRentPlayingBoard memberRent, TileGroupElement tileGroupElement,
RadPanorama radPanorama, string name, string text, int second, int minute, int hour, int day, double price)
{
Timer timer = new Timer();
timer.Enabled = true;
timer.Interval = 1000;
timer.Tick += Timer_Tick;
timer.Start();
this.Second = second;
this.Minute = minute;
this.Hour = hour;
this.Day = day;
this.Price = price;
_radTileElement = new Telerik.WinControls.UI.RadTileElement();
tileGroupElement.Items.AddRange(new Telerik.WinControls.RadItem[]
{
_radTileElement
});
_radTileElement.Font = new System.Drawing.Font("B Yekan", 10F);
_radTileElement.Tag = memberRent;
_radTileElement.Name = name;
_radTileElement.RightToLeft = true;
_radTileElement.Text = text;
_radTileElement.ColSpan = 1;
_radTileElement.TextAlignment = ContentAlignment.TopCenter;
//radTileElement.AllowDrag = false;
if (text.Length > 13)
{
_radTileElement.ColSpan = 2;
}
_radTileText = text;
radPanorama.Groups.AddRange(new Telerik.WinControls.RadItem[]
{
tileGroupElement
});
_radTileElement.Click += _radTileElement_Click;
}
public static MemberRentPlayingBoard Insert(RentPlayingBoard rentPlayingBoard, Member member,
string type, DataBaseDataContext connection)
{
MemberRentPlayingBoard memberRentPlayingBoard = new MemberRentPlayingBoard(type);
memberRentPlayingBoard.RentPlayingBoard = rentPlayingBoard;
memberRentPlayingBoard.Member = member;
connection.MemberRentPlayingBoards.InsertOnSubmit(memberRentPlayingBoard);
connection.SubmitChanges();
return(memberRentPlayingBoard);
}
public FrmClosePlayingBoard(MemberRentPlayingBoard memberRent)
{
this._memberRentPlaying = memberRent;
InitializeComponent();
}
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();
}
public static void Delete(MemberRentPlayingBoard memberRentPlayingBoard, DataBaseDataContext connection)
{
connection.MemberRentPlayingBoards.DeleteOnSubmit(memberRentPlayingBoard);
connection.SubmitChanges();
}
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();
}
