public Category GetCategoryById(short id)
{
/*using (IDbCommand command = connection.CreateCommand())
* {
* command.CommandText = "SELECT * FROM Category WHERE CategoryId = @Id";
*
* IDbDataParameter parameter = command.CreateParameter();
* parameter.Value = id;
* parameter.ParameterName = "@Id";
* command.Parameters.Add(parameter);
*
* using (IDataReader reader = command.ExecuteReader())
* {
* if (reader.Read())
* {
* Fetch(reader);
* }
* return null;
* }
* }*/
string sql = "SELECT * FROM Category WHERE CategoryId = @Id";
DynamicParameter parameter = new DynamicParameter();
parameter.Add("@Id", id);
return(FetchOne(sql, parameter));
}
public int Add(Category obj)
{
string sql = "INSERT INTO Category VALUES (@Name)";
DynamicParameter parameter = new DynamicParameter();
parameter.Add("@Name", obj.Name);
return(Save(sql, parameter));
}
public List <Product> GetProductsByCategoryId(short id)
{
string sql = "SELECT * FROM Product WHERE CategoryId = @Id";
DynamicParameter parameter = new DynamicParameter();
parameter.Add("@Id", id);
return(FetchAll(sql, parameter));
}
