public bool CreateYerba(Yerba yerbaToCreate)
{
using (var connection = new SQLiteConnection(_connectionString))
{
connection.Open();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Name", yerbaToCreate.Name, DbType.AnsiString);
parameter.Add("@Url", yerbaToCreate.Url, DbType.AnsiString);
parameter.Add("@Gentian", yerbaToCreate.Gentian, DbType.Int32);
parameter.Add("@Mark", yerbaToCreate.Mark, DbType.AnsiString);
parameter.Add("@Country", yerbaToCreate.Country, DbType.AnsiString);
parameter.Add("@Components", yerbaToCreate.Components, DbType.AnsiString);
parameter.Add("@Producent", yerbaToCreate.Producent, DbType.AnsiString);
parameter.Add("@Description", yerbaToCreate.Description, DbType.AnsiString);
parameter.Add("@Size", yerbaToCreate.Size, DbType.Int32);
parameter.Add("@Cost", yerbaToCreate.Cost, DbType.Decimal);
int id = connection.QueryFirst <int>(
$"INSERT INTO Yerba (Name, Url, Gentian, Mark, Cost, Country, Components, Producent, Description, Size) " +
$"VALUES(@Name, @Url, @Gentian, @Mark, @Cost, @Country, @Components, @Producent, @Description, @Size); SELECT last_insert_rowid()", parameter);
yerbaToCreate.Id = id;
return(id > 0);
}
}
public bool EditYerba(Yerba yerbaToEdit)
{
using (var connection = new SQLiteConnection(_connectionString))
{
connection.Open();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Id", yerbaToEdit.Id, DbType.Int32);
parameter.Add("@Name", yerbaToEdit.Name, DbType.AnsiString);
parameter.Add("@Url", yerbaToEdit.Url, DbType.AnsiString);
parameter.Add("@Gentian", yerbaToEdit.Gentian, DbType.Int32);
parameter.Add("@Mark", yerbaToEdit.Mark, DbType.AnsiString);
parameter.Add("@Country", yerbaToEdit.Country, DbType.AnsiString);
parameter.Add("@Components", yerbaToEdit.Components, DbType.AnsiString);
parameter.Add("@Producent", yerbaToEdit.Producent, DbType.AnsiString);
parameter.Add("@Description", yerbaToEdit.Description, DbType.AnsiString);
parameter.Add("@Size", yerbaToEdit.Size, DbType.Int32);
parameter.Add("@Cost", yerbaToEdit.Cost, DbType.Decimal);
return(connection.Execute(
$"UPDATE Yerba SET Name = @Name, Url = @Url, Gentian = @Gentian, Mark = @Mark, Cost = @Cost, Country = @Country, Components = @Components, Producent = @Producent, Description = @Description, Size = @Size " +
$"WHERE Id = @Id ", parameter) > 0);
}
}
