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