public void ExecuteSaveMonitoring(object obj)
{
using (CreditsFirmsContext context = new CreditsFirmsContext())
{
Collateral collateral = context.Collaterals.FirstOrDefault(c => c.Collateral_agreement == CollateralAgreement);
Monitoring_collateral monitoringUpdate = context.Monitoring_collateral.FirstOrDefault(m => m.Collateral_agreement == CollateralAgreement);
monitoringUpdate.Collateral_agreement = CollateralAgreement;
monitoringUpdate.Note = Note;
monitoringUpdate.Previous_date = Previous_date;
monitoringUpdate.Planned_date = Planned_date;
monitoringUpdate.Employees.Clear();
if (EmployeeMonitoring != null)
{
Employee emp1 = context.Employees.First(e => e.Employee_Id == EmployeeMonitoring.Employee_Id);
emp1.Monitoring_collateral.Add(monitoringUpdate);
}
if (EmployeeSupport != null)
{
Employee emp = context.Employees.First(e => e.Employee_Id == EmployeeSupport.Employee_Id);
emp.Monitoring_collateral.Add(monitoringUpdate);
}
context.SaveChanges();
CloseWnd(this, new EventArgs());
}
}
public void ExecuteSaveCollateral(object obj)
{
using (CreditsFirmsContext context = new CreditsFirmsContext())
{
if (valAgreement && valClient && valDate && valSum && Currency != null && TypeCollateral != null &&
!string.IsNullOrWhiteSpace(CreditAgreement) && FormCollateral != null && (!string.IsNullOrWhiteSpace(FirmId) || !string.IsNullOrWhiteSpace(PersonId)))
{
Collateral colRequest;
if (Flag == true)
{
colRequest = (Collateral)context.Collaterals.FirstOrDefault(c => c.Collateral_agreement == CollateralAgreement);
}
else
{
colRequest = new Collateral();
}
colRequest.Collateral_agreement = CollateralAgreement;
colRequest.Start_date = StartDate;
colRequest.End_date = EndDate;
colRequest.Currency_Id = Currency.Currency_Id;
colRequest.Sum = double.Parse(SumText);
colRequest.Description = Description;
colRequest.TypeId = TypeCollateral.TypeId;
colRequest.FormId = FormCollateral.FormId;
colRequest.Credit_agreement = CreditAgreement;
if (FirmId != null)
{
colRequest.Id_Firm = FirmId;
}
else if (PersonId != null)
{
colRequest.Id_Person = PersonId;
}
if (Flag == false)
{
Monitoring_collateral monitoringAdd = new Monitoring_collateral();
monitoringAdd.Collateral_agreement = CollateralAgreement;
monitoringAdd.Previous_date = StartDate;
if (TypeCollateral.TypeId == 99551 || TypeCollateral.TypeId == 99552)
{
monitoringAdd.Planned_date = StartDate.AddYears(1);
}
if (TypeCollateral.TypeId == 99553)
{
monitoringAdd.Planned_date = StartDate.AddMonths(3);
}
context.Monitoring_collateral.Add(monitoringAdd);
context.Collaterals.Add(colRequest);
}
context.SaveChanges();
CloseWnd(this, new EventArgs());
MessageBox.Show("Операция проведена успешно", "Договор обеспечения",
MessageBoxButton.OK, MessageBoxImage.Asterisk);
}
else
{
MessageBox.Show("Не все поля заполены корректно", "Ошибка при регистрации договора",
MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
