private void btnEdit_Click(object sender, EventArgs e)
{
if (gridLevel.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridLevel.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region Level Casting
int levelID = int.Parse(gridLevel.SelectedRows[0].Cells[1].Value.ToString());
if (!Level.Validation(levelID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Level level = Level.Get(levelID, myConnection);
#endregion
txtTitle.Text = level.Title;
//FormsManagement.EnableYesNo(btnSave, btnEdit, btnDelete, btnYes, btnNo, gridLevel);
FormManagement.EnableYesNo(this.Controls);
txtTitle.Focus();
}
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 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);
}
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 btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtBankTitle.Text.Trim()) || string.IsNullOrEmpty(txtBankTitle.Text.Trim()))
{
DataValidationMesaage.BlankTextBox("عنوان بانک");
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
if (myConnection.BankAccounts.Any(a => a.BankTitle.Equals(txtBankTitle.Text.Trim())))
{
DataValidationMesaage.DuplicateData("عنوان بانک");
return;
}
BankAccount.Insert(txtBankTitle.Text.Trim(), txtCardNumber.Text.Trim(), txtAccountNumber.Text.Trim(),
myConnection);
ClearTextBoxes();
myConnection.Dispose();
}
private void btnEdit_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;
}
cmbType.SelectedItem = playingBoardType.Type;
txtPrice.Text = playingBoardType.Price.ToString();
FormManagement.EnableYesNo(this.Controls);
myConnection.Dispose();
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (gridBankAccount.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridBankAccount.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region BankAccount Casting
int bankAccountId = int.Parse(gridBankAccount.SelectedRows[0].Cells[1].Value.ToString());
if (!BankAccount.Validation(bankAccountId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
BankAccount bankAccount = BankAccount.Get(bankAccountId, myConnection);
#endregion
txtBankTitle.Text = bankAccount.BankTitle;
txtCardNumber.Text = bankAccount.CardNumber;
txtAccountNumber.Text = bankAccount.AccountNumber;
FormManagement.EnableYesNo(this.Controls);
txtBankTitle.Focus();
}
private void صندوقچهاماناتToolStripMenuItem_Click(object sender, EventArgs e)
{
if (gridMember.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridMember.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
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);
MemberProfile = member;
FrmMemberCabinet frm = new FrmMemberCabinet();
frm.ShowDialog();
myConnection.Dispose();
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (gridCabinet.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridCabinet.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region Cabinet Casting
int cabinetID = int.Parse(gridCabinet.SelectedRows[0].Cells[1].Value.ToString());
if (!Cabinet.Validation(cabinetID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Cabinet cabinet = Cabinet.Get(cabinetID, myConnection);
#endregion
txtTitle.Text = cabinet.Title;
FormManagement.EnableYesNo(this.Controls);
txtTitle.Focus();
myConnection.Dispose();
}
private void btnSave_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (string.IsNullOrWhiteSpace(txtTitle.Text) || string.IsNullOrEmpty(txtTitle.Text))
{
DataValidationMesaage.BlankTextBox("عنوان");
return;
}
if (myConnection.Cabinets.Any(a => a.Title == txtTitle.Text.Trim()))
{
DataValidationMesaage.DuplicateData("عنوان");
return;
}
Cabinet cabinet = Cabinet.Insert(txtTitle.Text, true, myConnection);
DataValidationMesaage.AcceptMessage(cabinet.Title);
clearTextBox();
Cabinet.LoadGridColorful(gridCabinet, myConnection);
myConnection.Dispose();
}
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.Phones.Any(a => a.Title == txtTitle.Text.Trim()))
{
DataValidationMesaage.DuplicateData(txtTitle.Text);
return;
}
Phone phone = Phone.Insert(txtTitle.Text.Trim(), myConnection);
clearTextBox();
DataValidationMesaage.AcceptMessage(phone.Title);
Phone.LoadGrid(gridPhone, myConnection);
}
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 btnEdit_Click(object sender, EventArgs e)
{
if (gridPhone.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridPhone.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region Phone Casting
int phoneID = int.Parse(gridPhone.SelectedRows[0].Cells[1].Value.ToString());
if (!Phone.Validation(phoneID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Phone phone = Phone.Get(phoneID, myConnection);
#endregion
txtTitle.Text = phone.Title;
FormManagement.EnableYesNo(this.Controls);
txtTitle.Focus();
}
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();
}
private void gridMember_Click(object sender, EventArgs e)
{
if (gridMember.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridMember.Text);
return;
}
lblName.Text = gridMember.SelectedRows[0].Cells[3].Value.ToString();
}
private void gridPlayingBoard_Click(object sender, EventArgs e)
{
if (gridPlayingBoard.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoard.Text);
return;
}
lblPlayingBoardTitle.Text = gridPlayingBoard.SelectedRows[0].Cells[2].Value.ToString();
}
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);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (gridCabinet.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridCabinet.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region Cabinet Casting
int cabinetID = int.Parse(gridCabinet.SelectedRows[0].Cells[1].Value.ToString());
if (!Cabinet.Validation(cabinetID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Cabinet cabinet = Cabinet.Get(cabinetID, myConnection);
#endregion
if (cabinet.MemberCabinets.Any(a => a.Status))
{
DataValidationMesaage.DataInUse(cabinet.Title, gridCabinet.Text);
return;
}
if (cabinet.MemberCabinets.Any(a => !a.Status))
{
DataValidationMesaage.DataUsed(cabinet.Title, gridCabinet.Text);
return;
}
DialogResult message = DataValidationMesaage.ConfirmDeleteData(cabinet.Title);
if (message == DialogResult.Yes)
{
Cabinet.Delete(cabinet, myConnection);
DataValidationMesaage.DeleteMessage();
Cabinet.LoadGridColorful(gridCabinet, myConnection);
}
myConnection.Dispose();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (gridCabinetAvailables.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridCabinetAvailables.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region Cabinet Cast
int cabinetId = int.Parse(gridCabinetAvailables.SelectedRows[0].Cells[1].Value.ToString());
if (!Cabinet.Validation(cabinetId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Cabinet cabinet = Cabinet.Get(cabinetId, myConnection);
#endregion
_selectedMember = FrmMember.MemberProfile;
if (myConnection.MemberCabinets.Any(a => a.Member == _selectedMember && a.Status))
{
MessageBox.Show("به این عضو یک صندوق امانت اختصاص داده شده است", "کاربر گرامی", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
MemberCabinet.Insert(cabinet, _selectedMember, DateTime.Now, DateTime.Now, true, myConnection);
MessageBox.Show("عملیات اختصاص صندوق امانت به عضو با موفقیت انجام شد", "کاربر گرامی", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
cabinet.IsAvailable = false;
myConnection.SubmitChanges();
Cabinet.LoadGridAvailables(gridCabinetAvailables, 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 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);
}
}
}
private void btnYes_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
#region Cabinet Casting
int cabinetID = int.Parse(gridCabinet.SelectedRows[0].Cells[1].Value.ToString());
if (!Cabinet.Validation(cabinetID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Cabinet cabinet = Cabinet.Get(cabinetID, myConnection);
#endregion
if (string.IsNullOrWhiteSpace(txtTitle.Text) || string.IsNullOrEmpty(txtTitle.Text))
{
DataValidationMesaage.BlankTextBox("عنوان");
return;
}
if (myConnection.Cabinets.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != cabinet.ID))
{
DataValidationMesaage.DuplicateData(txtTitle.Text);
return;
}
Cabinet.Edit(cabinet, txtTitle.Text.Trim(), cabinet.IsAvailable, myConnection);
DataValidationMesaage.EditMessage();
clearTextBox();
Cabinet.LoadGridColorful(gridCabinet, myConnection);
FormManagement.DisableYesNo(this.Controls);
myConnection.Dispose();
}
private void btnYes_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
#region BankAccount Casting
int bankAccountId = int.Parse(gridBankAccount.SelectedRows[0].Cells[1].Value.ToString());
if (!BankAccount.Validation(bankAccountId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
BankAccount bankAccount = BankAccount.Get(bankAccountId, myConnection);
#endregion
if (string.IsNullOrWhiteSpace(txtBankTitle.Text.Trim()) || string.IsNullOrEmpty(txtBankTitle.Text.Trim()))
{
DataValidationMesaage.BlankTextBox("عنوان بانک");
return;
}
if (myConnection.BankAccounts.Any(a => a.BankTitle.Equals(txtBankTitle.Text.Trim()) && a.ID != bankAccountId))
{
DataValidationMesaage.DuplicateData("عنوان بانک");
return;
}
BankAccount.Edit(bankAccount, txtBankTitle.Text.Trim(), txtCardNumber.Text.Trim(),
txtAccountNumber.Text.Trim(), myConnection);
DataValidationMesaage.EditMessage();
ClearTextBoxes();
BankAccount.LoadGrid(gridBankAccount, 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 btnYes_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
#region Level Casting
int levelID = int.Parse(gridLevel.SelectedRows[0].Cells[1].Value.ToString());
if (!Level.Validation(levelID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
Level level = Level.Get(levelID, myConnection);
#endregion
if (string.IsNullOrWhiteSpace(txtTitle.Text) || string.IsNullOrEmpty(txtTitle.Text))
{
DataValidationMesaage.BlankTextBox("عنوان");
return;
}
if (myConnection.Levels.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != levelID))
{
DataValidationMesaage.DuplicateData(txtTitle.Text);
return;
}
Level.Edit(level, txtTitle.Text.Trim(), myConnection);
if (myConnection.Levels.Any(a => a.ID != levelID && a.Title == txtTitle.Text.Trim()))
{
DataValidationMesaage.EditMessage();
}
ClearTextBox();
Level.LoadGrid(gridLevel, myConnection);
//FormsManagement.DisableYesNo(btnSave, btnEdit, btnDelete, btnYes, btnNo, gridLevel);
FormManagement.DisableYesNo(this.Controls);
}
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 SocialNetworkType Casting
int socialNetworkTypeID = int.Parse(gridSocialNetworkType.SelectedRows[0].Cells[1].Value.ToString());
if (!SocialNetworkType.Validation(socialNetworkTypeID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeID, myConnection);
#endregion
if (myConnection.SocialNetworkTypes.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != socialNetworkType.ID))
{
DataValidationMesaage.DuplicateData(txtTitle.Text);
return;
}
SocialNetworkType.Edit(socialNetworkType, txtTitle.Text.Trim(), myConnection);
DataValidationMesaage.EditMessage();
clearTextBox();
txtTitle.Focus();
SocialNetworkType.LoadGrid(gridSocialNetworkType, myConnection);
FormManagement.DisableYesNo(this.Controls);
}
private void کنترلبرقToolStripMenuItem_Click_1(object sender, EventArgs e)
{
#region No ListItem Selected
if (gridPlayingBoard.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridPlayingBoard.Text);
return;
}
#endregion
FrmSetRaspberryRelays frm = new FrmSetRaspberryRelays();
frm.ShowDialog();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (gridBankAccount.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridBankAccount.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region BankAccount Casting
int bankAccountId = int.Parse(gridBankAccount.SelectedRows[0].Cells[1].Value.ToString());
if (!BankAccount.Validation(bankAccountId, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
BankAccount bankAccount = BankAccount.Get(bankAccountId, myConnection);
#endregion
if (bankAccount.CardSerialPayments.Any())
{
DataValidationMesaage.DataInUse(bankAccount.BankTitle, gridBankAccount.Text);
return;
}
DialogResult message = DataValidationMesaage.ConfirmDeleteData(bankAccount.ToString());
if (message == DialogResult.Yes)
{
BankAccount.Delete(bankAccount, myConnection);
DataValidationMesaage.DeleteMessage();
BankAccount.LoadGrid(gridBankAccount, myConnection);
}
}
