public List <string> SelectAllUserEmails()
{
using (IDbConnection connection = new SqlConnection(DataBaseHelper.ConnectionValue("EcommerceV2")))
{
var emails = connection.Query <string>("EcommerceV2.dbo.Users_SelectAllEmails").ToList();
return(emails);
}
}
public List <Product> SelectAllTVs()
{
using (IDbConnection connection = new SqlConnection(DataBaseHelper.ConnectionValue("EcommerceV2")))
{
List <Product> tvProducts = connection.Query <Product>("EcommerceV2.dbo.Product_SelectAllTVs").ToList();
return(tvProducts);
}
}
public void InsertUser(string email, string password)
{
using (IDbConnection connection = new SqlConnection(DataBaseHelper.ConnectionValue("EcommerceV2")))
{
var user = new User {
Email = email, Password = password
};
var users = new List <User>();
users.Add(user);
connection.Execute("EcommerceV2.dbo.Users_Insert @Email, @Password", users);
}
}
public Product SelectProductById(int productId)
{
using (IDbConnection connection = new SqlConnection(DataBaseHelper.ConnectionValue("EcommerceV2")))
{
string sql = "EXEC EcommerceV2.dbo.Product_SelectById @ProductId = " + productId.ToString();
List <Product> products = connection.Query <Product>(sql).ToList();
Product product = null;
foreach (Product p in products)
{
product = p;
}
return(product);
}
}
