public void Remove(Entities.Episode entity) { string command = "episode_remove"; var param = new DynamicParameters(); param.Add("@Id", entity.Id); connection.Execute(command, param, transaction, commandType: CommandType.StoredProcedure); }
public async Task AddAsync(Entities.Episode entity) { try { var command = "episode_save"; var param = new DynamicParameters(); param.Add("@tvId", entity.tvId); param.Add("@seasonNumber", entity.seasonNumber); param.Add("@videoSource", entity.videoSource); param.Add("@episodeNumber", entity.episodeNumber); await connection.ExecuteAsync(command, param, transaction, commandType : CommandType.StoredProcedure); //return new ResponseMessage("Episode was added with success."); } catch { //return new ResponseMessage(ex.Message); throw; } }