/// <summary> /// Union two lists, both without duplicates. This list is designated to display in datagrid after earlier filtering. /// </summary> /// <returns></returns> public static List <SettlementListFields> MergeTwoListsWithoutDuplicates() { var twoListsWithoutDuplicates = MakeNewLIstFromMerge.MergeListsAndFilter().Union(ConnectTwoLists.JoinListWithPoliciesInDatabaseAndPoliciesWhichArentInDatabase()); return(twoListsWithoutDuplicates.ToList()); }
/// <summary> ///Connect two lists using Addrange , where we display first list, and add second list to first list, ///where are all positions from first list and second list on which delete elements from first list ///at equal insurance policy numbers on both lists. /// </summary> /// <returns></returns> public static List <SettlementListFields> JoinListWithPoliciesInDatabaseAndPoliciesWhichArentInDatabase() { masterEntities dc = new masterEntities(SaveConnectionStringsAsStringToMethodParameter.connstringMasterEntitiesConnectionDatabase); var userListFilter = dc.userPolicyData.Select(n => n.policyNumber).FirstOrDefault(); var merged = new List <SettlementListFields>(); merged.AddRange(SecondListWithNotEqualsPolicyNumbers.DisplayInsurancePoliciesWhichArentInDatabase().Where(p2 => MakeNewLIstFromMerge.MergeListsAndFilter().All(p1 => p1.settlementPolicyNumber != p2.settlementPolicyNumber))); return(merged.ToList()); }