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 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 gridPlayingBoard_SelectionChanged(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (gridPlayingBoard.SelectedRows.Count == 0)
{
return;
}
#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
PlayingBoardType.LoadComboBox_By_PlayingBoard(cmbPlayingBoardType, playingBoard, myConnection);
}
public static void ShowList_By_PlayingBoard(PlayingBoard playingBoard, ListView listView,
DataBaseDataContext connection)
{
IQueryable <PlayingBoardType> myQuery =
connection.PlayingBoardTypes.Where(a => a.PlayingBoard == playingBoard);
listView.Items.Clear();
int count = 0;
foreach (PlayingBoardType item in myQuery)
{
ListViewItem listViewItem = new ListViewItem();
listViewItem.Tag = item;
listViewItem.Text = (++count).ToString();
listViewItem.SubItems.Add(item.Type);
listViewItem.SubItems.Add(item.Price.ToString());
listView.Items.Add(listViewItem);
}
}
public static void LoadFilteredGrid(RadGridView grid, PlayingBoard playingBoard,
DataBaseDataContext connection)
{
var myQuery = connection.PlayingBoardTypes.Where(a => a.PlayingBoard == playingBoard)
.Select(a => new
{
id = a.ID,
type = a.Type,
price = a.Price
});
grid.DataSource = myQuery;
grid.Columns[1].IsVisible = false;
grid.Columns[2].HeaderText = "نوع";
grid.Columns[2].Width = 300;
grid.Columns[3].HeaderText = "قیمت";
grid.Columns[3].Width = 300;
for (int i = 0; i < grid.RowCount; i++)
{
grid.Rows[i].Cells[0].Value = i + 1;
}
}
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 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();
}
public static void Edit(RaspBerryPlayingBoard raspBerryPlayingBoard, PlayingBoard playingBoard, RaspberryPin raspberryPin,
DataBaseDataContext connection)
{
raspBerryPlayingBoard.RaspberryPin = raspberryPin;
raspBerryPlayingBoard.PlayingBoard = playingBoard;
connection.SubmitChanges();
}
private void txtSearchPlayingBoard_TextChanged(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
//if (cmbSearchPlayingBoardBy.SelectedIndex == 0)
PlayingBoard.Search_By_PlayingBoardTitle_LoadGridAvailables(txtSearchPlayingBoard.Text, gridPlayingBoard, myConnection);
//else if (cmbSearchPlayingBoardBy.SelectedIndex == 1)
// Member.SearchGridByMemberFullName_LoadGridBriefly(txtSearchMember.Text, gridMember, myConnection);
//else if (cmbSearchPlayingBoardBy.SelectedIndex == 2)
//Member.SearchGridByMemberNationalCode_LoadGridBriefly(txtSearchMember.Text, gridMember, myConnection);
}
public static void Edit(PlayingBoard playingBoard, PlayingBoardTitle PlayingBoardTitle,
string number, bool isAvailable, DataBaseDataContext connection)
{
playingBoard.Number = number;
playingBoard.PlayingBoardTitle = PlayingBoardTitle;
playingBoard.IsAvailable = isAvailable;
connection.SubmitChanges();
}
public static PlayingBoard Insert(PlayingBoardTitle PlayingBoardTitle, string number, bool isAvailable, DataBaseDataContext connection)
{
PlayingBoard playingBoard = new PlayingBoard(number, isAvailable);
playingBoard.PlayingBoardTitle = PlayingBoardTitle;
connection.PlayingBoards.InsertOnSubmit(playingBoard);
connection.SubmitChanges();
return(playingBoard);
}
private void FrmSetRaspberryRelays_Load(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
RaspBerryPlayingBoard.ShowList(lstRaspberryRelays, myConnection);
RaspberryPin.LoadComboBoxAvailables(cmbRaspberryRelay, myConnection);
PlayingBoardGroupTitle.LoadComboBox(cmbPlayingBoardGroupTitle, myConnection);
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
PlayingBoardTitle.LoadComboBox_By_PlayingBoardGroupTitle(cmbPlayingBoardTitle, playingBoardGroupTitle,
myConnection);
if (myConnection.PlayingBoardTitles.Any(a => a.PlayingBoardGroupTitle.Equals(playingBoardGroupTitle)))
{
#region PlayingBoardTitle Cast
int playingBoardTitleId = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID;
if (!PlayingBoardTitle.Validation(playingBoardTitleId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(playingBoardTitleId, myConnection);
#endregion
PlayingBoard.LoadComboBoxByFilter(cmbPlayingBoard, playingBoardTitle, myConnection);
}
}
}
//public static List<int> ReservedPins = new List<int>
//{1, 2, 4, 6, 9, 14, 17, 20, 25, 27, 28, 30, 34};
//public static List<int> GpioPins = new List<int>()
//{3, 5, 7, 8, 10, 11, 12, 13, 15, 16, 18, 19, 21, 22, 23, 24, 26, 29, 31, 32, 33, 35, 36, 37};
public static RaspBerryPlayingBoard Insert(RaspberryPin raspberryPin, PlayingBoard playingBoard, DataBaseDataContext connection)
{
RaspBerryPlayingBoard raspBerryPlayingBoard = new RaspBerryPlayingBoard();
raspBerryPlayingBoard.RaspberryPin = raspberryPin;
raspBerryPlayingBoard.PlayingBoard = playingBoard;
connection.RaspBerryPlayingBoards.InsertOnSubmit(raspBerryPlayingBoard);
connection.SubmitChanges();
return(raspBerryPlayingBoard);
}
public static PlayingBoardType Insert(PlayingBoard playingBoard, string type, int price, DataBaseDataContext connection)
{
PlayingBoardType playingBoardType = new PlayingBoardType(type, price);
playingBoard = PlayingBoard.Get(playingBoard.ID, connection);
playingBoardType.PlayingBoard = playingBoard;
connection.PlayingBoardTypes.InsertOnSubmit(playingBoardType);
connection.SubmitChanges();
return(playingBoardType);
}
private void FrmPlayingBoard_Load(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
PlayingBoardGroupTitle.LoadComboBox(cmbPlayingBoardGroupTitle, myConnection);
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)))
{
#region PlayingBoardTitle Cast
int playingBoardTitleId = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID;
if (!PlayingBoardTitle.Validation(playingBoardTitleId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(playingBoardTitleId, myConnection);
#endregion
PlayingBoard.LoadGridColorful_By_PlayingBoardTitle(gridPlayingBoard, playingBoardTitle, myConnection);
}
}
myConnection.Dispose();
}
private void cmbPlayingBoardGroupTitle_SelectedIndexChanged(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
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
PlayingBoardTitle.LoadComboBox_By_PlayingBoardGroupTitle(cmbPlayingBoardTitle, playingBoardGroupTitle,
myConnection);
if (myConnection.PlayingBoardTitles.Any(a => a.PlayingBoardGroupTitle.Equals(playingBoardGroupTitle)))
{
#region PlayingBoardTitle Cast
int playingBoardTitleId = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID;
if (!PlayingBoardTitle.Validation(playingBoardTitleId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(playingBoardTitleId, myConnection);
#endregion
PlayingBoard.LoadComboBoxByFilter(cmbPlayingBoard, playingBoardTitle, myConnection);
}
}
}
public static void LoadComboBox_By_PlayingBoard(ComboBox cmbBox, PlayingBoard playingBoard,
DataBaseDataContext connection)
{
IQueryable <PlayingBoardType> myQuery = connection.PlayingBoardTypes.Where(a => a.PlayingBoard == playingBoard);
cmbBox.Items.Clear();
foreach (var item in myQuery)
{
cmbBox.Items.Add(item);
}
if (!myQuery.Any())
{
cmbBox.Items.Add("یک آیتم به ثبت برسانید");
cmbBox.SelectedIndex = 0;
return;
}
cmbBox.SelectedIndex = 0;
}
private void FrmRent_Load(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
Member.LoadGridBriefly(gridMember, myConnection);
PlayingBoard.LoadGridAvailables(gridPlayingBoard, myConnection);
if (myConnection.PlayingBoards.Any(a => a.IsAvailable))
{
#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
PlayingBoardType.LoadComboBox_By_PlayingBoard(cmbPlayingBoardType, playingBoard, myConnection);
}
cmbSearchMemberBy.SelectedIndex = 0;
cmbSearchPlayingBoardBy.SelectedIndex = 0;
gridPlayingBoard.ClearSelection();
gridMember.ClearSelection();
myConnection.Dispose();
}
public static void Delete(PlayingBoard playingBoard, DataBaseDataContext connection)
{
connection.PlayingBoards.DeleteOnSubmit(playingBoard);
connection.SubmitChanges();
}
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);
}
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 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 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 cmbPlayingBoardGroupTitle_SelectedIndexChanged(object sender, EventArgs e)
{
gridPlayingBoard.Rows.Clear();
DataBaseDataContext myConnection = Setting.DataBase;
if (myConnection.PlayingBoardGroupTitles.Any())
{
btnAddPlayingboardTitle.Visible = true;
#region PlayingBoardGroupTitle Cast
int playingBoardGroupTitleId = ((PlayingBoardGroupTitle)cmbPlayingBoardGroupTitle.SelectedItem).ID;
if (!PlayingBoardGroupTitle.Validation(playingBoardGroupTitleId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoardGroupTitle playingBoardGroupTitle = PlayingBoardGroupTitle.Get(playingBoardGroupTitleId,
myConnection);
#endregion
PlayingBoardTitle.LoadComboBox_By_PlayingBoardGroupTitle(cmbPlayingBoardTitle, playingBoardGroupTitle,
myConnection);
if (myConnection.PlayingBoardTitles.Any(a => a.PlayingBoardGroupTitle.Equals(playingBoardGroupTitle)))
{
#region PlayingBoardTitle Cast
int playingBoardTitleId = ((PlayingBoardTitle)cmbPlayingBoardTitle.SelectedItem).ID;
if (!PlayingBoardTitle.Validation(playingBoardTitleId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoardTitle playingBoardTitle = PlayingBoardTitle.Get(playingBoardTitleId, myConnection);
#endregion
PlayingBoard.LoadGridColorful_By_PlayingBoardTitle(gridPlayingBoard, playingBoardTitle, myConnection);
}
}
else
{
btnAddPlayingboardTitle.Visible = false;
cmbPlayingBoardTitle.Items.Add("گروه بازی کامل شود");
cmbPlayingBoardTitle.SelectedIndex = 0;
return;
}
}
