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 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;
#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();
}
