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 btnYes_Click(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrWhiteSpace(txtTitle.Text))
{
DataValidationMesaage.BlankTextBox("عنوان");
return;
}
#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
if (myConnection.Phones.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != phoneID))
{
DataValidationMesaage.DuplicateData(txtTitle.Text);
return;
}
Phone.Edit(phone, txtTitle.Text.Trim(), myConnection);
DataValidationMesaage.EditMessage();
clearTextBox();
txtTitle.Focus();
Phone.LoadGrid(gridPhone, myConnection);
FormManagement.DisableYesNo(this.Controls);
}
private void btnDelete_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
if (phone.PhoneNumbers.Any())
{
DataValidationMesaage.DataInUse(phone.Title, gridPhone.Text);
return;
}
DialogResult message = DataValidationMesaage.ConfirmDeleteData(phone.Title);
if (message == DialogResult.Yes)
{
Phone.Delete(phone, myConnection);
DataValidationMesaage.DeleteMessage();
Phone.LoadGrid(gridPhone, myConnection);
}
}
private void FrmPhone_Load(object sender, EventArgs e)
{
Phone.LoadGrid(gridPhone, Setting.DataBase);
}
