/// <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); }