public void RetrieveAllTest() { var repository = new VendorRepository(); var expected = new List <Vendor>(); expected.Add(new Vendor() { VendorId = 6, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 7, CompanyName = "Home Toys Inc", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 8, CompanyName = "Car Toys", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 9, CompanyName = "Toys for Fun", Email = "*****@*****.**" }); var vendors = repository.RetrieveAll(); var vendorQuery = from v in vendors where v.CompanyName.Contains("Toy") orderby v.CompanyName select v; var vendorQuery2 = vendors.Where(v => v.CompanyName.Contains("Toy")).OrderBy(o => o.CompanyName); CollectionAssert.AreEqual(expected, vendorQuery2.ToList()); }
public void RetrieveAllTest_QuerySyntax() { //Arrange var repo = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 8, CompanyName = "Car Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 9, CompanyName = "Fun Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 5, CompanyName = "Marvel Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 6, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" }, }; //Act var vendors = repo.RetrieveAll(); //could pass lambdas straight in, too (which is preferred) var vendorQuery = vendors.Where(FilterCompanies) .OrderBy(OrderCompaniesByName); //Assert Assert.Equal(expected, vendorQuery.ToList()); //query not executed until ToList() }
public void RetrieveAllTest_MethodSyntax() { //Arrange var repo = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 5, CompanyName = "Marvel Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 6, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" }, new Vendor() { VendorId = 8, CompanyName = "Car Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 9, CompanyName = "Fun Toys", Email = "*****@*****.**" }, }; //Act var vendors = repo.RetrieveAll(); var vendorQuery = from v in vendors where v.CompanyName.Contains("Toy") select v; //query not executed until (via ToList()) //Assert Assert.Equal(expected, vendorQuery.ToList()); }
public void RetrieveAllVendors() { var repo = new VendorRepository(); var expected = new List <Vendor>() { new Vendor { CompanyName = "Evozon", Email = "[email protected]:=", VendorId = 1 }, new Vendor() { CompanyName = "Vision", Email = "[email protected]:=", VendorId = 3 } }; var vendorList = repo.RetrieveAll(); //var customList = from v in vendorList // where v.CompanyName.Contains("on") // orderby v.VendorId // select v; //customList = (from v in vendorList // where v.VendorId == 1 // select v).ToList(); //var customList = vendorList.Where(FilterVendor) // .OrderBy(OrderVendorById); var customList = vendorList.Where(v => v.CompanyName.Contains("on")) .OrderBy(v => v.VendorId); CollectionAssert.AreEqual(customList.ToList(), expected); }
public void RetrieveAllTest() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 9, CompanyName = "JKL Toy Corp", Email = "*****@*****.**" }, new Vendor() { VendorId = 7, CompanyName = "TYU Toy Corp", Email = "*****@*****.**" } }; //Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Toy") // orderby v.CompanyName // select v; var vendorQuery = vendors .Where(v => v.CompanyName.Contains("Toy")) .OrderBy(v => v.CompanyName); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveAllTest() { // Arrange var repository = new VendorRepository(); var expected = new List <Vendor>(); expected.Add(new Vendor() { VendorId = 22, CompanyName = "Amalgamated Toys", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 35, CompanyName = "Car Toys", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 28, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 42, CompanyName = "Toys for Fun", Email = "*****@*****.**" }); // Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Toy") // orderby v.CompanyName // select v; var vendorQuery = vendors.Where(v => v.CompanyName.Contains("Toy")).OrderBy(v => v.CompanyName); // Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveAllTest() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 1, CompanyName = "ABC Corp", Email = "*****@*****.**" }, new Vendor() { VendorId = 2, CompanyName = "BABC Corp", Email = "*****@*****.**" } }; //Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("ABC") // select v; var vendorQuery = vendors.Where(FilterCompanies) .OrderBy(OrderCompanies); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
// load the form private void NewRfp_Load(object sender, EventArgs e) { foreach (Vendor vendor in VendorRepository.RetrieveAll()) { this.chkVendors.Items.Add(vendor); } }
public void RetrieveAllTest() { // Arrange var repository = new VendorRepository(); var expected = new List <Vendor> { { new Vendor() { VendorId = 3, CompanyName = "Berni Cat Co", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 4, CompanyName = "Cat Charlie Inc", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 9, CompanyName = "Hogwarts Magic Cat Co", Email = "*****@*****.**" } }, }; // Act var vendors = repository.RetrieveAll(); // var vendorQuery = from v in vendors // where v.CompanyName.Contains("Cat") // select v; var vendorQuery = vendors.Where(v => v.CompanyName.Contains("Cat")) .OrderBy(v => v.CompanyName); // Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveAllTest() { var repository = new VendorRepository(); var expected = new List <Vendor>() { { new Vendor() { VendorId = 1, CompanyName = "Tech Technossus", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 2, CompanyName = "Tech Infosys", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 3, CompanyName = "Tech LiveDeftsoft", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 4, CompanyName = "Tech TCS", Email = "*****@*****.**" } } }; //Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Tech") // orderby v.CompanyName // select v; var vendorQuery = vendors.Where(FilterCompanies) .OrderBy(OrderCompaniesByName); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
// load the combo in the toolbar to select the current participant void LoadParticipantsCombo() { foreach (Vendor vendor in VendorRepository.RetrieveAll()) { this.cboParticipant.Items.Add(vendor); } this.cboParticipant.Items.Add("Company X employee"); this.cboParticipant.SelectedIndex = 0; }
// set the UI protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // populate the list of vendors foreach (Vendor vendor in VendorRepository.RetrieveAll()) { chkVendorsList.Items.Add(new ListItem(vendor.Name, vendor.Id.ToString())); } } }
// show the combo for selecting a participant (displayed in each table row) string RenderParticipantsCombo(string rfpId) { StringBuilder buffer = new StringBuilder(); buffer.Append("<select id=\"sel_" + rfpId + "\">"); foreach (Vendor vendor in VendorRepository.RetrieveAll()) { buffer.Append(string.Format("<option value=\"{0}\">{1}</option>", vendor.Id, vendor.Name)); } buffer.Append(string.Format("<option value=\"{0}\">{1}</option>", "", "Requestor")); buffer.Append("</select>"); buffer.Append(string.Format("<input type=\"button\" value=\"View\" onclick=\"showProposal('{0}')\"/>", rfpId)); return(buffer.ToString()); }
public void RetrieveAll() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { { new Vendor() { VendorId = 8, CompanyName = "Car Toys Inc", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 9, CompanyName = "Fun Toys Inc", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 6, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 5, CompanyName = "Toys Inc", Email = "*****@*****.**" } } }; //Act var vendors = repository.RetrieveAll(); //Query syntax //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Toy") // orderby v.CompanyName // select v; //Method syntax //var vendorQuery = vendors // .Where(FilterCompanies) // .OrderBy(OrderCompaniesByName); //Lambda Expression var vendorQuery = vendors .Where(v => v.CompanyName.Contains("Toy")) .OrderBy(v => v.CompanyName); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveAllTest() { var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 22, CompanyName = "Amalgamated Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 35, CompanyName = "Car Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 28, CompanyName = "Toys Block Inc", Email = "*****@*****.**" }, new Vendor() { VendorId = 42, CompanyName = "Toys for Fun", Email = "*****@*****.**" } }; var vendors = repository.RetrieveAll(); var vendorQuery = from vendor in vendors where vendor.CompanyName.Contains("Toys") orderby vendor.CompanyName select vendor; //vendorQuery2 = vendors.Where(FilterCompanies).OrderBy(OrderCompsniesByName); var vendorQuery2 = vendors.Where(v => v.CompanyName .Contains("Toys")).OrderBy(v => v.CompanyName); //private bool FilterCompanies(Vendor vendor)=> // vendor.CompanyName.Contains("Toys"); // //cia tas pats kas Where lambda // private string OrderCompsniesByName(Vendor vendor) => // vendor.CompanyName; // cia tas pats kad orderby lambda CollectionAssert.AreEqual(expected, vendorQuery.ToList()); CollectionAssert.AreEqual(expected, vendorQuery2.ToList()); }
public void RetriveAllTest() { var repository = new VendorRepository(); var expected = new List <Vendor>() { { new Vendor() { VendorId = 3, CompanyName = "Manchester Firm", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 4, CompanyName = "Pitterson Empire", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 5, CompanyName = "Rebel Ltd", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 6, CompanyName = "Chess Ltd", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 7, CompanyName = "Checkmate Productions", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 8, CompanyName = "Kellys Ltd", Email = "*****@*****.**" } }, }; var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Ltd") // orderby v.CompanyName // select v; //var vendorQuery = vendors.Where(FilterCompanies).OrderBy(OrderCompaniesByName); var vendorQuery = vendors.Where(v => v.CompanyName.Contains("Ltd")) .OrderBy(v => v.CompanyName); CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveAllLINQTest() { //Arrange var repository = new VendorRepository(); var expected = 7; //Act var vendors = repository.RetrieveAll(); var vendorQuery = vendors .Where(v => v.CompanyName.Contains("Toy")) .Average(v => v.VendorId); //Assert Assert.AreEqual(expected, vendorQuery); }
public void RetrieveAllTest() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { { new Vendor() { VendorId = 22, CompanyName = "Amal Toys", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 35, CompanyName = "Car Toys", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 28, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 42, CompanyName = "Toys n Stuff Inc", Email = "*****@*****.**" } } }; //Act var vendors = repository.RetrieveAll(); // USING QUERY SYNTAX //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Toy") // orderby v.CompanyName // select v; // USING METHOD SYNTAX WITH METHOD NAMES (ie FilterCompanies & OrderCompaniesByName) //var vendorQuery = vendors.Where(FilterCompanies) // .OrderBy(OrderCompaniesByName); //lambda expression = a method that can be passed as an argument to a method when that arg expects a delegate type //USING METHOD SYNTAX AND PASSING LAMBDA EXPRESSIONS...eliminates the private methods below var vendorQuery = vendors.Where(v => v.CompanyName.Contains("Toys")) .OrderBy(v => v.CompanyName); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveAllTest() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 22, CompanyName = "Amalgamated Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 35, CompanyName = "Car Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 28, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" }, new Vendor() { VendorId = 42, CompanyName = "Toys for Fun", Email = "*****@*****.**" }, }; //Act var vendors = repository.RetrieveAll(); ////Query Syntax //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Toy") // orderby v.CompanyName // select v; ////Method Syntax //var vendorQuery = vendors.Where(FilterCompanies).OrderBy(OrderCompaniesByName); //Using Mwthod Syntax with Lambda Expressions directly in-line var vendorQuery = vendors.Where(v => v.CompanyName.Contains("Toy")).OrderBy(v => v.CompanyName); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveAllTest() { // Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { { new Vendor() { VendorId = 22, CompanyName = "Amalgamated Toys", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 35, CompanyName = "Car Toys", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 28, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 42, CompanyName = "Toys for Fun", Email = "*****@*****.**" } } }; // Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Toy") // orderby v.CompanyName // select v; //var vendorQuery = vendors.Where(FilterCompanies) // .OrderBy(OrderCompaniesByName); var vendorQuery = vendors.Where(v => v.CompanyName.Contains("Toy")) .OrderBy(v => v.CompanyName); // Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveWithLINQ() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 1, CompanyName = "ABC Corp", Email = "*****@*****.**" }, new Vendor() { VendorId = 2, CompanyName = "BABC Corp", Email = "*****@*****.**" } }; //Act var vendors = repository.RetrieveAll(); //Assert }
public void RetrieveTest() { var vendorRepository = new VendorRepository(); var vendors = vendorRepository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("2") // select v; //var vendorQuery = vendors.Where(FilterCompanys).OrderBy(OrderCompanyByName); var vendorQuery = vendors.Where(v => v.CompanyName.Contains("3")) .OrderBy(v => v.CompanyName); vendorQuery.ToList(); foreach (var item in vendorQuery) { Console.WriteLine(item); } }
public void RetrieveAllTests() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 2, CompanyName = "Amalgamated Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 2, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" }, new Vendor() { VendorId = 2, CompanyName = "Car Toys", Email = "*****@*****.**" }, new Vendor() { VendorId = 2, CompanyName = "Toys for Fun", Email = "*****@*****.**" } }; //Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Toy") // select v; //var vendorQuery = vendors.Where(repository.FilterCompanies); var vendorQuery = vendors.Where(v => v.CompanyName.Contains("Toy")); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList <Vendor>()); }