/// <summary>
///
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public Category Create(Category category)
{
string sqlStatement = "INSERT INTO Category (Name, CreatedOn, CreatedBy) " +
"VALUES(@Name, @CreatedOn, @CreatedBy); " + Db.LastIdFunction();
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Name", category.Name));
cmd.Parameters.Add(Db.CreateParameter("@CreatedOn", DateTime.Now));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", category.CreatedBy));
category.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(category);
}
/// <summary>
///
/// </summary>
/// <param name="product"></param>
/// <returns></returns>
public Product Create(Product product)
{
string sqlStatement = "INSERT INTO Product (Title, Description, DealerId, Image, Price, CreatedBy) " +
"VALUES(@Title, @Description, @DealerId, @Image, @Price, @CreatedBy);" + Db.LastIdFunction();
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Title", product.Title));
cmd.Parameters.Add(Db.CreateParameter("@Description", product.Description));
cmd.Parameters.Add(Db.CreateParameter("@DealerId", product.DealerId));
cmd.Parameters.Add(Db.CreateParameter("@Image", product.Image));
cmd.Parameters.Add(Db.CreateParameter("@Price", product.Price));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", product.CreatedBy));
// Obtener el valor de la primary key.
product.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(product);
}
