private void FrmPlayingBoardTitle_Load(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
PlayingBoardTitle.LoadGrid_By_PlayingBoardGroupTitle(gridPlayingBoardTitle,
FrmPlayingBoard.SelectedPlayingBoardGroupTitle, myConnection);
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 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 btnDelete_Click(object sender, EventArgs e)
{
if (gridPlayingBoardTitle.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoardTitle.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#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 (playingBoardTitle.PlayingBoards.Any())
{
DataValidationMesaage.DataInUse(playingBoardTitle.Title, gridPlayingBoardTitle.Text);
return;
}
DialogResult message = DataValidationMesaage.ConfirmDeleteData(playingBoardTitle.Title);
if (message == DialogResult.Yes)
{
PlayingBoardTitle.Delete(playingBoardTitle, myConnection);
DataValidationMesaage.DeleteMessage();
PlayingBoardTitle.LoadGrid_By_PlayingBoardGroupTitle(gridPlayingBoardTitle,
FrmPlayingBoard.SelectedPlayingBoardGroupTitle, myConnection);
}
//myConnection.Dispose();
}
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();
}