public async Task AddAsync(Entities.TvSerie entity) { var ex = await FindAsync(entity.Id); if (entity == null) { throw new NullReferenceException(); } else if (!ex) { var command = "tvserie_save"; var param = new DynamicParameters(); param.Add("@Id", entity.Id); param.Add("@title", entity.title); param.Add("@poster", entity.poster); param.Add("@voteAverage", entity.voteAverage); param.Add("@isPosted", entity.IsPosted); param.Add("@numberOfSeasons", entity.NumberOfSeasons); await connection.ExecuteAsync(command, param, transaction, commandType : CommandType.StoredProcedure); } else { //return new ResponseMessage("This TvSerie already exist in database."); } }
public void Remove(Entities.TvSerie entity) { string command = "tvserie_remove"; var param = new DynamicParameters(); param.Add("@Id", entity.Id); connection.Execute(command, param, transaction, commandType: CommandType.StoredProcedure); }