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