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.PlayingBoardGroupTitles.Any(a => a.GroupTitle == txtTitle.Text.Trim()))
{
DataValidationMesaage.DuplicateData(txtTitle.Text);
return;
}
PlayingBoardGroupTitle playingBoardGroupTitle = PlayingBoardGroupTitle.Insert(txtTitle.Text.Trim(), myConnection);
ClearTextBox();
DataValidationMesaage.AcceptMessage(playingBoardGroupTitle.GroupTitle);
PlayingBoardGroupTitle.LoadGrid(gridPlayingBoardGroupTitle, 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 PlayingBoardGroupTitle Casting
int playingBoardGroupTitleID = int.Parse(gridPlayingBoardGroupTitle.SelectedRows[0].Cells[1].Value.ToString());
if (!PlayingBoardGroupTitle.Validation(playingBoardGroupTitleID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoardGroupTitle playingBoardGroupTitle = PlayingBoardGroupTitle.Get(playingBoardGroupTitleID, myConnection);
#endregion
if (myConnection.PlayingBoardGroupTitles.Any(a => a.GroupTitle == txtTitle.Text.Trim() && a.ID != playingBoardGroupTitleID))
{
DataValidationMesaage.DuplicateData(txtTitle.Text);
return;
}
PlayingBoardGroupTitle.Edit(playingBoardGroupTitle, txtTitle.Text.Trim(), myConnection);
DataValidationMesaage.EditMessage();
ClearTextBox();
txtTitle.Focus();
PlayingBoardGroupTitle.LoadGrid(gridPlayingBoardGroupTitle, myConnection);
FormManagement.DisableYesNo(this.Controls);
myConnection.Dispose();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (gridPlayingBoardGroupTitle.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoardGroupTitle.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region PlayingBoardGroupTitle Casting
int playingBoardGroupTitleID = int.Parse(gridPlayingBoardGroupTitle.SelectedRows[0].Cells[1].Value.ToString());
if (!PlayingBoardGroupTitle.Validation(playingBoardGroupTitleID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
PlayingBoardGroupTitle playingBoardGroupTitle = PlayingBoardGroupTitle.Get(playingBoardGroupTitleID, myConnection);
#endregion
if (playingBoardGroupTitle.PlayingBoardTitles.Any())
{
DataValidationMesaage.DataInUse(playingBoardGroupTitle.GroupTitle, gridPlayingBoardGroupTitle.Text);
return;
}
DialogResult message = DataValidationMesaage.ConfirmDeleteData(playingBoardGroupTitle.GroupTitle);
if (message == DialogResult.Yes)
{
PlayingBoardGroupTitle.Delete(playingBoardGroupTitle, myConnection);
DataValidationMesaage.DeleteMessage();
PlayingBoardGroupTitle.LoadGrid(gridPlayingBoardGroupTitle, myConnection);
}
}
private void FrmPlayingBoardGroupTitle_Load(object sender, EventArgs e)
{
PlayingBoardGroupTitle.LoadGrid(gridPlayingBoardGroupTitle, Setting.DataBase);
}
