public void Test_OrderBy()
{
List <Employee> emplist = new List <Employee>();
List <Employee> empl = new List <Employee>();
emplist.Add(new Employee {
EmployeeID = "1000", EmployeeName = "Anushree", EmployeeEmail = "*****@*****.**"
});
emplist.Add(new Employee {
EmployeeID = "1200", EmployeeName = "Name1200", EmployeeEmail = "*****@*****.**"
});
emplist.Add(new Employee {
EmployeeID = "1400", EmployeeName = "Name1400", EmployeeEmail = "*****@*****.**"
});
emplist.Add(new Employee {
EmployeeID = "1500", EmployeeName = "Name1500", EmployeeEmail = "*****@*****.**"
});
emplist.Add(new Employee {
EmployeeID = "1700", EmployeeName = "Anushree", EmployeeEmail = "*****@*****.**"
});
emplist.Add(new Employee {
EmployeeID = "2000", EmployeeName = "Anushree", EmployeeEmail = "*****@*****.**"
});
//Expected result list
empl.Add(new Employee {
EmployeeID = "2000", EmployeeName = "Anushree", EmployeeEmail = "*****@*****.**"
});
empl.Add(new Employee {
EmployeeID = "1700", EmployeeName = "Anushree", EmployeeEmail = "*****@*****.**"
});
empl.Add(new Employee {
EmployeeID = "1500", EmployeeName = "Name1500", EmployeeEmail = "*****@*****.**"
});
empl.Add(new Employee {
EmployeeID = "1400", EmployeeName = "Name1400", EmployeeEmail = "*****@*****.**"
});
empl.Add(new Employee {
EmployeeID = "1200", EmployeeName = "Name1200", EmployeeEmail = "*****@*****.**"
});
empl.Add(new Employee {
EmployeeID = "1000", EmployeeName = "Anushree", EmployeeEmail = "*****@*****.**"
});
//Arrange
List <Employee> expected = empl;
//Act
LinqMethods methods = new LinqMethods();
List <Employee> actual = methods.OrderBy(emplist);
//Assert
Assert.AreEqual(expected.Count, actual.Count);
Assert.AreEqual(expected[0].EmployeeID, actual[0].EmployeeID);
Assert.AreEqual(expected[0].EmployeeName, actual[0].EmployeeName);
Assert.AreEqual(expected[0].EmployeeEmail, actual[0].EmployeeEmail);
Assert.AreEqual(expected[1].EmployeeID, actual[1].EmployeeID);
Assert.AreEqual(expected[1].EmployeeName, actual[1].EmployeeName);
Assert.AreEqual(expected[1].EmployeeEmail, actual[1].EmployeeEmail);
Assert.AreEqual(expected[2].EmployeeID, actual[2].EmployeeID);
Assert.AreEqual(expected[2].EmployeeName, actual[2].EmployeeName);
Assert.AreEqual(expected[2].EmployeeEmail, actual[2].EmployeeEmail);
Assert.AreEqual(expected[3].EmployeeID, actual[3].EmployeeID);
Assert.AreEqual(expected[3].EmployeeName, actual[3].EmployeeName);
Assert.AreEqual(expected[3].EmployeeEmail, actual[3].EmployeeEmail);
Assert.AreEqual(expected[4].EmployeeID, actual[4].EmployeeID);
Assert.AreEqual(expected[4].EmployeeName, actual[4].EmployeeName);
Assert.AreEqual(expected[4].EmployeeEmail, actual[4].EmployeeEmail);
Assert.AreEqual(expected[5].EmployeeID, actual[5].EmployeeID);
Assert.AreEqual(expected[5].EmployeeName, actual[5].EmployeeName);
Assert.AreEqual(expected[5].EmployeeEmail, actual[5].EmployeeEmail);
CollectionAssert.AreEqual(expected.Select(emp => emp.EmployeeID).ToList(), actual.Select(emp => emp.EmployeeID).ToList());
CollectionAssert.AreEqual(expected.Select(emp => emp.EmployeeName).ToList(), actual.Select(emp => emp.EmployeeName).ToList());
CollectionAssert.AreEqual(expected.Select(emp => emp.EmployeeEmail).ToList(), actual.Select(emp => emp.EmployeeEmail).ToList());
}
public List <Employee> GetDetail()
{
List <Employee> list;
LinqMethods methods = new LinqMethods();
if (dropdown2.SelectedItem.ToString() == "Basic Filter")
{
list = methods.BasicFilter(empList);
return(list);
}
else if (dropdown2.SelectedItem.ToString() == "Order by")
{
list = methods.OrderBy(empList);
return(list);
}
else if (dropdown2.SelectedItem.ToString() == "Join")
{
list = methods.Join(empList);
return(list);
}
else if (dropdown2.SelectedItem.ToString() == "Group by")
{
list = methods.GroupBy(empList);
return(list);
}
else if (dropdown2.SelectedItem.ToString() == "Quantifiers")
{
bool result;
result = methods.LQuantifiersAny(empList);
lblAnyResult.Content = result;
result = methods.LQuantifiersAll(empList);
lblAllResult1.Content = result;
result = methods.LQuantifiersContain(empList);
lblContainResult.Content = result;
}
else if (dropdown2.SelectedItem.ToString() == "Aggregate Functions")
{
double result;
result = methods.AggregateAvg(empList);
lblAvgResult.Content = result;
result = methods.AggregateMin(empList);
lblMinResult.Content = result;
result = methods.AggregateMax(empList);
lblMaxResult.Content = result;
result = methods.AggregateCount(empList);
lblCountResult.Content = result;
result = methods.AggregateSum(empList);
lblSumResult.Content = result;
}
else if (dropdown2.SelectedItem.ToString() == "Element Operators")
{
string result;
result = methods.ElementAt(empList);
lblElementAtResult.Content = result;
result = methods.First(empList);
lblFirstResult.Content = result;
result = methods.Last(empList);
lblLastResult.Content = result;
}
else if (dropdown2.SelectedItem.ToString() == "Set Operators")
{
//list = methods.Distinct(empList);
//return list;
//list = methods.Except(empList);
//return list;
//list = methods.Intersect(empList);
//return list;
list = methods.Union(empList);
return(list);
}
return(null);
}