private void bttSave_Click(object sender, EventArgs e) { PrepareObject(); ContaContext contaContext = new ContaContext(); UnitOfWork unityOfWork = new UnitOfWork(contaContext); IList<Contract> checkIfIsExist = (IList<Contract>)unityOfWork.Contracte.GetContractByNumberAndYear(_contract.NrContract, DateTime.Today); if (checkIfIsExist == null || checkIfIsExist.Count > 0) { MessageBox.Show(@"Contractul cu numarul " + _contract.NrContract + @" exista deja.", @"Eroare la salvare", MessageBoxButtons.OK, MessageBoxIcon.Error); txtNrContr.Text = ""; return; } if (_contract.BeneficiarId <= 0) { MessageBox.Show(@"Contractul nu poate fi salvat fara Beneficiar.\nVa rugam selectati unul sau creati unul nou ", @"Eroare la salvare", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } unityOfWork.Contracte.Add(_contract); unityOfWork.Complete(); unityOfWork.Dispose(); contaContext.Dispose(); grBoxContract.Enabled = false; bttNewContract.Enabled = true; FillGridView(_filter, DateTime.Today.Year.ToString()); OnUpdateLucrariCombo(); }
private void gridViewContract_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow selectedRow = null; foreach (DataGridViewRow iterator in gridViewContract.SelectedRows) { selectedRow = iterator; } var selRow = selectedRow?.Cells["ContractId"].Value; if (selRow == null) return; ContaContext contaContext = new ContaContext(); UnitOfWork unitOfWork = new UnitOfWork(contaContext); _contract = unitOfWork.Contracte.Get((int) selRow); unitOfWork.Dispose(); contaContext.Dispose(); if (_contract == null) return; // Completeaza formul cu datele din baza de date txtNrContr.Text = _contract.NrContract; txtSuma.Text = _contract.Suma.ToString(CultureInfo.InstalledUICulture); txtObiect.Text = _contract.ObiectulContractului; txtObs.Text = _contract.Observatii; dateTimePickerContr.Value = _contract.Data; //Set enable disabe or visibilty for controls bttNewContract.Enabled = false; bttDeleteContract.Enabled = false; grBoxContract.Enabled = true; bttEdit.Visible = true; bttCancel.Visible = true; bttSave.Visible = false; bttClear.Visible = false; }
private void bttDeleteContract_Click(object sender, EventArgs e) { DataGridViewRow selectedRow = null; foreach (DataGridViewRow iterator in gridViewContract.SelectedRows) { selectedRow = iterator; } var selRow = selectedRow?.Cells["ContractId"].Value; if (selRow == null) return; ContaContext contaContext = new ContaContext(); UnitOfWork unityOfWork = new UnitOfWork(contaContext); Contract contract = unityOfWork.Contracte.Get((int) selRow); if (contract == null) return; var userConfirm = MessageBox.Show( @"Confirmati stergerea din baza de date a contractului cu nr. " + contract.NrContract + @"/" + contract.Data, @"Delete confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (userConfirm == DialogResult.Yes) { try { unityOfWork.Contracte.Remove(contract); unityOfWork.Complete(); unityOfWork.Dispose(); contaContext.Dispose(); bttDeleteContract.Enabled = false; FillGridView(_filter, DateTime.Now.Year.ToString()); ClearFormContract(); } catch (DbUpdateException) { // ReSharper disable once LocalizableElement MessageBox.Show("Contractul este folosit de o alta intrare din baza de date.\nStergere refuzata", @"Eroare stergere contract", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch(Exception ex) { MessageBox.Show(ex.Message, @"Eroare stergere contract", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { bttDeleteContract.Enabled = false; unityOfWork.Dispose(); contaContext.Dispose(); } }
private void GetBeneficiariForDb() { ContaContext contaContext = new ContaContext(); UnitOfWork unitOfWork = new UnitOfWork(contaContext); _mlBeneficiari =(List<Beneficiar>) unitOfWork.Beneficiari.GetAll(); unitOfWork.Dispose(); contaContext.Dispose(); _names = new AutoCompleteStringCollection(); foreach (var str in _mlBeneficiari) _names.Add(str.Nume); }
private void FillComboBox() { ContaContext contaContext = new ContaContext(); UnitOfWork unitOfWork = new UnitOfWork(contaContext); BindingSource bindTipAct = new BindingSource {DataSource = unitOfWork.TipActe.GetAll()}; unitOfWork.Dispose(); contaContext.Dispose(); cbTipAct.DataSource = bindTipAct; cbTipAct.DisplayMember = "TipAct1"; cbAtribFiscal.Items.Add(""); cbAtribFiscal.Items.Add("RO"); }
private void bttDeleteLucrari_Click(object sender, EventArgs e) { DataGridViewRow selectedRow = null; foreach (DataGridViewRow iterator in LucrariView.SelectedRows) { selectedRow = iterator; } var dataGridViewCell = selectedRow?.Cells["LucrareId"].Value; if (dataGridViewCell == null) return; //var id = dataGridViewCell; ContaContext contaContext = new ContaContext(); UnitOfWork unityOfWork = new UnitOfWork(contaContext); Lucrare lucrare = unityOfWork.Lucrari.Get((int)dataGridViewCell); var userConfirm = MessageBox.Show(@"Confirmati stergerea din baza de date a documentatiei cu nr. " + lucrare.NrProiect + @"/" + lucrare.AnProiect, @"Delete confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (userConfirm == DialogResult.Yes) { try { unityOfWork.Lucrari.Remove(lucrare); unityOfWork.Complete(); unityOfWork.Dispose(); contaContext.Dispose(); bttDeleteLucrari.Enabled = false; FillGridView(_filter, DateTime.Now.Year.ToString()); } catch (DbUpdateException) { // ReSharper disable once LocalizableElement MessageBox.Show("Documentatie este folosit de o alta intrare din baza de date.\nStergere refuzata", @"Eroare stergere contract", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.Message, @"Eroare stergere contract", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { bttDeleteLucrari.Enabled = false; unityOfWork.Dispose(); contaContext.Dispose(); } }
private void LucrariView_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = null; foreach (DataGridViewRow iterator in LucrariView.SelectedRows) { row = iterator; } if (row == null) return; var conta = new ContaContext(); var unitOfWork = new UnitOfWork(conta); // ReSharper disable once ConstantConditionalAccessQualifier var id = row?.Cells["LucrareId"].Value; if (id == null) return; _lucrare = unitOfWork.Lucrari.Get((int)id); if (_lucrare == null) return; int sStatusAccept = unitOfWork.AcceptateRespinse.Get(_lucrare.AcceptataRefuzataId).AcceptataRefuzataId; if (--sStatusAccept >= 0) cbAcceptResp.SelectedIndex = sStatusAccept; int sStatusRec = unitOfWork.ReceptionateRespinse.Get(_lucrare.ReceptionatRespinsId).ReceptionatRespinsId; if(--sStatusRec >= 0) cbReceptionatRespins.SelectedIndex = sStatusRec; if (_lucrare.ContractId != null) cbContract.SelectedText = unitOfWork.Contracte.Get((int)_lucrare.ContractId).NrContract; if (_lucrare.DataInregistrare != null) dateTimePickerInreg.Value = (DateTime)_lucrare.DataInregistrare; if (_lucrare.TermenSolutionare != null) dateTimePickerTermen.Value = (DateTime)_lucrare.TermenSolutionare; unitOfWork.Dispose(); conta.Dispose(); txtInreg.Text = _lucrare.Nr_OCPI; txtDoc.Text = _lucrare.NrProiect; txtAvizator.Text = _lucrare.AvizatorRegistrator; txtUAT.Text = _lucrare.UAT; txtObservatii.Text = _lucrare.Observatii; txtCad.Text = _lucrare.CadTop; //Set enable disabe or visibilty for controls bttNewLucrare.Enabled = false; bttDeleteLucrari.Enabled = false; grBoxLucrare.Enabled = true; bttEdit.Visible = true; bttCancel.Visible = true; bttSave.Visible = false; bttClearlucrare.Visible = false; }