public static CoffeeTable Read(long _id)
{
IDbConnection db = new SqlConnection("Server=GWJSN13\\SQLEXPRESS; Database=Coffee2; user id=admin; password=pass1;");
CoffeeTable prod = db.Get <CoffeeTable>(_id);
return(prod);
}
public static void Delete(long _productID)
{
CoffeeTable prod = new CoffeeTable()
{
ProductID = _productID
};
IDbConnection db = new SqlConnection("Server=GWJSN13\\SQLEXPRESS; Database=Coffee2; user id=admin; password=pass1;");
db.Delete(prod);
}
public static void Update(long _productID, string _productName, string _description, decimal _price, string _category)
{
CoffeeTable prod = new CoffeeTable()
{
ProductID = _productID, ProductName = _productName, Description = _description, Price = _price, Category = _category
};
IDbConnection db = new SqlConnection("Server=GWJSN13\\SQLEXPRESS; Database=Coffee2; user id=admin; password=pass1;");
db.Update(prod);
}
public static void Create(string _productName, string _description, decimal _price, string _category) // Creates a product
{
// Create the new Product instance
CoffeeTable prod = new CoffeeTable()
{
ProductName = _productName, Description = _description, Price = _price, Category = _category
};
// Save it to the database
IDbConnection db = new SqlConnection("Server=GWJSN13\\SQLEXPRESS; Database=Coffee2; user id=admin; password=pass1;");
db.Insert <CoffeeTable>(prod);
// Set the id column of the instance
//prod.ProductID = _id;
// Return the instance
//return prod;
}