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