private void FrmMembersCabinetsManagement_Load(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
cmbSearchBy.SelectedIndex = 0;
MemberCabinet.LoadGridMemberCabinet(gridCabinetMembers, myConnection);
}
public static void Edit(MemberCabinet memberCabinet, Cabinet cabinet, Member member,
DateTime dateStart, DateTime dateEnd, DataBaseDataContext connection)
{
memberCabinet.DateStart = dateStart;
memberCabinet.DateEnd = dateEnd;
memberCabinet.Cabinet = cabinet;
memberCabinet.Member = member;
connection.SubmitChanges();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
DataBaseDataContext myConnection = Setting.DataBase;
if (cmbSearchBy != null && cmbSearchBy.Text == "عضو")
{
MemberCabinet.SearchGridMemberCabinetByMemberName(txtSearch.Text, gridCabinetMembers, myConnection);
}
else if (cmbSearchBy != null && cmbSearchBy.Text == "صندوق امانت")
{
MemberCabinet.SearchGridMemberCabinetByCabinetTitle(txtSearch.Text, gridCabinetMembers, 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();
}
public static MemberCabinet Insert(Cabinet cabinet, Member member, DateTime dateStart, DateTime dateEnd, bool status,
DataBaseDataContext connection)
{
MemberCabinet memberCabinet = new MemberCabinet(dateStart, dateEnd, status);
memberCabinet.Member = Member.Get(member.ID, connection);
memberCabinet.Cabinet = Cabinet.Get(cabinet.ID, connection);
connection.MemberCabinets.InsertOnSubmit(memberCabinet);
connection.SubmitChanges();
return(memberCabinet);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (gridCabinetMembers.SelectedRows.Count == 0)
{
DataValidationMesaage.NoSelectedItemFromList(gridCabinetMembers.Text);
return;
}
DataBaseDataContext myConnection = Setting.DataBase;
#region MemberCabinet Cast
int memberCabinetID = int.Parse(gridCabinetMembers.SelectedRows[0].Cells[1].Value.ToString());
if (!MemberCabinet.Validation(memberCabinetID, myConnection))
{
DataValidationMesaage.NoDataInBank();
return;
}
MemberCabinet memberCabinet = MemberCabinet.Get(memberCabinetID, myConnection);
#endregion
// MemberCabinet.Delete(memberCabinet, myConnection);
memberCabinet.Cabinet.IsAvailable = true;
memberCabinet.Status = false;
myConnection.SubmitChanges();
MemberCabinet.LoadGridMemberCabinet(gridCabinetMembers, myConnection);
myConnection.Dispose();
}
public static void Delete(MemberCabinet memberCabinet, DataBaseDataContext connection)
{
connection.MemberCabinets.DeleteOnSubmit(memberCabinet);
connection.SubmitChanges();
}
