public void Add(Product entity)
{
using (IDbConnection cn = connection)
{
var parameters = new
{
Name = entity.Name,
Id = entity.Id
};
cn.Open();
entity.Id = cn.Query<Guid>(
"INSERT INTO Products (Name, Id) VALUES(@Name, @Id)",
parameters).FirstOrDefault();
}
}
public void AddPricingQueryTest()
{
// We use a static id, so we always can drop the the user after the test
Guid userid = new Guid("f265ab67-8006-4266-b6fd-c6a409321b31");
// We use a static id, so we always can drop the the query after the test
Guid queryid = new Guid("329BF626-9F06-483B-AD0F-F70E27BE30F7");
// We use a static id, so we always can drop the the query after the test
Guid productid = new Guid("758c0953-e576-4a8d-9223-b85ffd24c8ac");
//Add User
User user = new User() { Id = userid, FirstName = "Jayakaran", LastName = "Theiven", AddressLine1 = "buntspechtweg 8a", City = "Bonn", PostCode = "53123", Country = "Germany", Email ="*****@*****.**", Phone = "00491739476008"};
userRepository.Add(user);
//Add Product
Product product = new Product() { Id = productid, Name = "Test Product" };
productRepository.Add(product);
//insert pricing query
PricingQuery query = new PricingQuery() { Id = queryid, ProductId = productid, UserId = userid, EnquiryDate = DateTime.Today, IsReplied = false };
pricingQueryRepository.Add(query);
// return pricing query data and test
var result = pricingQueryRepository.Find(queryid);
Assert.That(result.Id, Is.EqualTo(queryid));
Assert.That(result.UserId, Is.EqualTo(userid));
Assert.That(result.ProductId, Is.EqualTo(productid));
//Clean up after testing
PricingQueryCleanUp(queryid);
UserCleanUp(userid);
ProductCleanUp(productid);
}