public void WithProvider() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => e.workstation == "EPRUIZHW0249")) { Console.WriteLine("{0} {1}", emp.nativename, emp.startworkdate); } }
public void AndTest() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => e.workStation.Contains("IZHW02") && e.nativeName == "Михаил Романов")) { Console.WriteLine($"{emp.nativeName} {emp.workStation}"); } }
public void WithProviderConstantAndFilteredName() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => "EPRUIZHW0249" == e.workStation)) { Console.WriteLine("{0} {1}", emp.nativeName, emp.shortStartWorkDate); } }
public void EndWithTest() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => e.workStation.EndsWith("W0249"))) { Console.WriteLine($"{emp.nativeName} {emp.workStation}"); } }
public void AndMethodTask3() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => e.workstation.StartsWith("EPRUIZHW0") && e.primaryTitle.EndsWith("Specialist") && e.primaryTitle.Contains("Dev"))) { Console.WriteLine("{0} {1}", emp.nativename, emp.startworkdate); } }
//[TestMethod] public void StartsEndsOperationsTask2() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => e.workstation.Contains("PRUIZHW024"))) { Console.WriteLine("{0} {1}", emp.nativename, emp.startworkdate); } }
public void EndsWithTest() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => e.workstation.EndsWith("0249"))) { Console.WriteLine("{0} {1}", emp.nativename, emp.workstation); } }
public void ConstantFirstTest() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => ("EPRUIZHW0249*") == e.workstation)) { Console.WriteLine("{0} {1}", emp.nativename, emp.workstation); } }
public void AndAlsoAndStartsWithAndContainsTest() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => e.workstation.StartsWith("EPRUIZHW") && e.nativename.Contains("Михаил"))) { Console.WriteLine("{0} {1}", emp.nativename, emp.workstation); } }
public void Contains_Test() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); var empList = employees.Where(e => e.workstation.Contains("IZHW030")).ToList(); foreach (var emp in empList) { Console.WriteLine("{0} {1}", emp.nativename, emp.shortStartWorkDate); } }
public void WithProvider_And() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); foreach (var emp in employees.Where(e => e.firstname == "Mihail" && e.room.Contains("4 Floor"))) { Console.WriteLine("{0} {1}", emp.nativename, emp.room); } }
public void WhereContainsTest_AssertParameter() { var employees = new E3SEntitySet <EmployeeEntity>(_fakeClient); foreach (var emp in employees.Where(e => e.workstation.Contains("EPRUIZHW0249"))) { Console.WriteLine("{0}", emp); } var expectedString = @"https://e3s.epam.com/eco/rest/e3s-eco-scripting-impl/0.1.0/data/searchFts?" + @"metaType=meta:people-suite:people-api:com.epam.e3s.app.people.api.data.EmployeeEntity&" + @"query={""statements"":[{""query"":""workstation:(*EPRUIZHW0249*)""}]%2c""filters"":null%2c""sorting"":null%2c""start"":0%2c""limit"":0}"; A.CallTo(() => _fakeClient.GetStringAsync(A <Uri> .That.Matches(uri => uri.ToString() == expectedString))).MustHaveHappened(); }
public void EndsWith() { var _mock = new Mock <E3SQueryClient>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); _mock.Setup(x => x.SearchFTS(It.IsAny <Type>(), "workstation:(*IZHW0060)", It.IsAny <int>(), It.IsAny <int>())).Returns(new List <EmployeeEntity>() { new EmployeeEntity("Petya", "06/05/2017") }); employees.Provider = new E3SLinqProvider(_mock.Object); foreach (var emp in employees.Where(e => e.workstation.EndsWith("IZHW0060"))) { Console.WriteLine("{0} {1}", emp.nativename, emp.startworkdate); } }
public void ReversePredicate() { var _mock = new Mock <E3SQueryClient>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); _mock.Setup(x => x.SearchFTS(It.IsAny <Type>(), It.IsAny <string>(), It.IsAny <int>(), It.IsAny <int>())).Returns(new List <EmployeeEntity>() { new EmployeeEntity("Yana", "05/05/2017") }); employees.Provider = new E3SLinqProvider(_mock.Object); foreach (var emp in employees.Where(e => "EPRUIZHW0249" == e.workstation)) { Console.WriteLine("{0} {1}", emp.nativename, emp.startworkdate); } }
public void WithProvider() { var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); //foreach (var emp in employees.Where(e => e.workStation == "EPRUIZHW0249")) //{ // Console.WriteLine("{0} {1}", emp.nativeName, emp.shortStartWorkDate); //} //foreach (var emp in employees.Where(e => "EPRUIZHW0249" == e.workStation)) //{ // Console.WriteLine("{0} {1}", emp.nativeName, emp.shortStartWorkDate); //} foreach (var emp in employees.Where(e => e.workStation.StartsWith("EPRU") && e.lastName.Contains("ty"))) { Console.WriteLine("{0} {1}", emp.nativeName, emp.shortStartWorkDate); } }
public void WithProvider() { int count = 0; var employees = new E3SEntitySet <EmployeeEntity>(ConfigurationManager.AppSettings["user"], ConfigurationManager.AppSettings["password"]); Console.WriteLine("Part 1"); //<имя фильтруемого поля> == <константа> foreach (var emp in employees.Where(e => e.workstation == "EPRUIZHW0249")) { Console.WriteLine($"{emp.nativename}, {emp.shortStartWorkDate}, {emp.citySum}, {emp.workstation}"); } //PART 1 ********************************************************************************************* //<константа> == <имя фильтруемого поля> foreach (var emp in employees.Where(e => "EPRUIZHW0249" == e.workstation)) { Console.WriteLine($"{emp.nativename}, {emp.shortStartWorkDate}, {emp.citySum}, {emp.workstation}"); } Console.WriteLine("**************************"); //PART 2 ********************************************************************************************************** Console.WriteLine("Part 2"); //StartsWith foreach (var emp in employees.Where(e => e.workstation.StartsWith("EPRUIZHW024"))) { Console.WriteLine($"{emp.nativename}, {emp.shortStartWorkDate}, {emp.citySum}, {emp.workstation}"); count++; } Console.WriteLine("**************************"); Console.WriteLine($"StartsWith count = {count}"); Console.WriteLine("**************************"); count = 0; //EndsWith foreach (var emp in employees.Where(e => e.workstation.EndsWith("IZHW0249"))) { Console.WriteLine($"{emp.nativename}, {emp.shortStartWorkDate}, {emp.citySum}, {emp.workstation}"); count++; } Console.WriteLine("**************************"); Console.WriteLine($"EndsWith count = {count}"); Console.WriteLine("**************************"); count = 0; //Contains foreach (var emp in employees.Where(e => e.workstation.Contains("IZHW024"))) { Console.WriteLine($"{emp.nativename}, {emp.shortStartWorkDate}, {emp.citySum}, {emp.workstation}"); count++; } Console.WriteLine("**************************"); Console.WriteLine($"Contains count = {count}"); Console.WriteLine("**************************"); //PART 3********************************************************************************** //AND Console.WriteLine("Part 3"); count = 0; foreach (var emp in employees.Where(e => e.workstation == "EPRUIZHW0249" & e.citySum == "Izhevsk")) { Console.WriteLine($"{emp.nativename}, {emp.shortStartWorkDate}, {emp.citySum}, {emp.workstation}"); count++; } Console.WriteLine("**************************"); Console.WriteLine($"AND count = {count}"); Console.WriteLine("**************************"); count = 0; foreach (var emp in employees.Where(e => e.workstation == "EPRUIZHW0249" & e.citySum == "Minsk")) { Console.WriteLine($"{emp.nativename}, {emp.shortStartWorkDate}, {emp.citySum}, {emp.workstation}"); count++; } Console.WriteLine("**************************"); Console.WriteLine($"AND Wrong city!!! count = {count}"); }