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 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 FrmPlayBoard_Load(object sender, EventArgs e)
{
cmbType.SelectedIndex = 0;
DataBaseDataContext myConnection = Setting.DataBase;
lblTitle.Text = FrmPlayingBoard.SelectedPlayingBoard.PlayingBoardTitle.PlayingBoardGroupTitle.GroupTitle
+ " " + FrmPlayingBoard.SelectedPlayingBoard.PlayingBoardTitle.Title
+ " " + FrmPlayingBoard.SelectedPlayingBoard.Number;
PlayingBoardType.ShowList_By_PlayingBoard(FrmPlayingBoard.SelectedPlayingBoard, lstPlayingBoardTypes,
myConnection);
}
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();
}
