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