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