public static async Task <int> AddFavorWork(HasFavoriteEntity entity)
{
var query = "INSERT INTO favorite_has_work(favorite_id,work_id) VALUES(@favorite_id,@work_id)";
using var connection = DatabaseConnector.Connect();
await connection.OpenAsync();
using var command = connection.CreateCommand();
command.CommandText = query;
command.Parameters.AddWithValue("@work_id", entity.work_id);
command.Parameters.AddWithValue("@favorite_id", entity.favorite_id);
await command.ExecuteNonQueryAsync();
return((int)command.LastInsertedId);
}
public static async Task <int> DeleteFavorWork(HasFavoriteEntity entity)
{
var query = "DELETE FROM favorite_has_work WHERE favorite_id=@favorite_id AND work_id=@work_id";
using var connection = DatabaseConnector.Connect();
await connection.OpenAsync();
using var command = connection.CreateCommand();
command.CommandText = query;
command.Parameters.AddWithValue("@work_id", entity.work_id);
command.Parameters.AddWithValue("@favorite_id", entity.favorite_id);
var row = await command.ExecuteNonQueryAsync();
if (row > 0)
{
return(1);
}
return(0);
}
public static async Task <int> FindFavorWork(HasFavoriteEntity entity)
{
var query = "SELECT favorite_id,work_id FROM favorite_has_work WHERE favorite_id=@favorite_id AND work_id=@work_id";
using var connection = DatabaseConnector.Connect();
await connection.OpenAsync();
using var command = connection.CreateCommand();
command.CommandText = query;
command.Parameters.AddWithValue("@favorite_id", entity.favorite_id);
command.Parameters.AddWithValue("@work_id", entity.work_id);
using var reader = await command.ExecuteReaderAsync();
if (await reader.ReadAsync())
{
HasFavoriteEntity temp = new HasFavoriteEntity
{
favorite_id = reader.GetInt32("favorite_id"),
work_id = reader.GetInt32("work_id"),
};
return(1);
}
return(0);
}
