private void ExecuteSearchCollateral(object obj) { ObservableCollection <CollateralInfo> collateralsInfo = new ObservableCollection <CollateralInfo>(); ObservableCollection <Collateral> collateralsLoad = new ObservableCollection <Collateral>(); using (CreditsFirmsContext context = new CreditsFirmsContext()) { if (!string.IsNullOrWhiteSpace(SearchCollateral)) { var collaterals = from c in context.Collaterals where c.Collateral_agreement.StartsWith(SearchCollateral) select c; foreach (Collateral collateral in collaterals) { collateralsLoad.Add(collateral); } } else if (!string.IsNullOrWhiteSpace(SearchClient)) { var collaterals = from c in context.Collaterals where c.Firm.Name.Contains(SearchClient) || c.Individual.Name.Contains(SearchClient) select c; foreach (Collateral collateral in collaterals) { collateralsLoad.Add(collateral); } } if (collateralsLoad != null) { foreach (Collateral collateral in collateralsLoad) { CollateralInfo collateralInfo = new CollateralInfo(); collateralInfo.Collateral_agreement = collateral.Collateral_agreement; collateralInfo.Start_date = collateral.Start_date; collateralInfo.End_date = collateral.End_date; collateralInfo.Credit_agreement = collateral.Credit_agreement; collateralInfo.Currency = collateral.Currencies_directory; collateralInfo.Sum = collateral.Sum; collateralInfo.FormId = collateral.FormId; collateralInfo.TypeId = collateral.TypeId; collateralInfo.Description = collateral.Description; if (collateral.Firm != null) { collateralInfo.ClientId = collateral.Id_Firm; collateralInfo.ClientName = collateral.Firm.Name; } else { collateralInfo.ClientId = collateral.Id_Person; collateralInfo.ClientName = collateral.Individual.Name; } collateralsInfo.Add(collateralInfo); } Collaterals = collateralsInfo; } } }
public void LoadCollateral() { ObservableCollection <CollateralInfo> collateralsInfo = new ObservableCollection <CollateralInfo>(); using (CreditsFirmsContext context = new CreditsFirmsContext()) { var collateralsLoad = context.Collaterals; foreach (Collateral collateral in collateralsLoad) { CollateralInfo collateralInfo = new CollateralInfo(); collateralInfo.Collateral_agreement = collateral.Collateral_agreement; collateralInfo.Start_date = collateral.Start_date; collateralInfo.End_date = collateral.End_date; collateralInfo.Credit_agreement = collateral.Credit_agreement; collateralInfo.Currency = collateral.Currencies_directory; collateralInfo.Sum = collateral.Sum; collateralInfo.FormId = collateral.FormId; collateralInfo.TypeId = collateral.TypeId; collateralInfo.Description = collateral.Description; if (collateral.Firm != null) { collateralInfo.ClientId = collateral.Id_Firm; collateralInfo.ClientName = collateral.Firm.Name; } else { collateralInfo.ClientId = collateral.Id_Person; collateralInfo.ClientName = collateral.Individual.Name; } collateralsInfo.Add(collateralInfo); } Collaterals = collateralsInfo; } }