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