public void Post([FromBody] Proverb newProverb)
{
ProverbContext context = new ProverbContext();
context.Proverbs.Add(newProverb);
context.SaveChanges();
}
public Proverb Get(int id)
{
ProverbContext context = new ProverbContext();
var searchedProverb = (from x in context.Proverbs
where id == x.ProverbId
select x).FirstOrDefault();
return(searchedProverb);
}
public void Delete(int id)
{
ProverbContext context = new ProverbContext();
var proverbToDelete = (from x in context.Proverbs
where id == x.ProverbId
select x).FirstOrDefault();
context.Remove(proverbToDelete);
context.SaveChanges();
}
public SayingQuery(ProverbContext context) : base(context) { }
public UserQuery(ProverbContext context) : base(context)
{
}
public SayingQuery(ProverbContext context) : base(context)
{
}
public SageQuery(ProverbContext context) : base(context)
{
}
public BaseCommandQuery(ProverbContext context)
{
_context = context;
}
public UserQuery(ProverbContext dbContext) : base(dbContext)
{
}
public UserCommand(ProverbContext dbContext) : base(dbContext)
{
}
public int Count()
{
ProverbContext context = new ProverbContext();
return(context.Proverbs.Count());
}
public SageCommand(ProverbContext dbContext) : base(dbContext)
{
}
public UserCommand(ProverbContext context) : base(context)
{
}
public SageQuery(ProverbContext dbContext) : base(dbContext) { }
public SayingQuery(ProverbContext dbContext) : base(dbContext)
{
}
public UserQuery(ProverbContext dbContext) : base(dbContext) { }
protected BaseCommandQuery(ProverbContext dbContext)
{
DbContext = dbContext;
}
public IEnumerable <Proverb> Get()
{
ProverbContext context = new ProverbContext();
return(context.Proverbs.ToList());
}
public SayingCommand(ProverbContext context) : base(context)
{
}
public UserCommand(ProverbContext dbContext) : base(dbContext) { }
public SageCommand(ProverbContext dbContext) : base(dbContext) { }
public SageCommand(ProverbContext context) : base(context) { }
public SayingQuery(ProverbContext dbContext) : base(dbContext) { }
public UserQuery(ProverbContext context) : base(context) { }
protected BaseCommandQuery(ProverbContext dbContext)
{
DbContext = dbContext;
}
public UserCommand(ProverbContext context) : base(context) { }
public BaseCommandQuery(ProverbContext context)
{
_context = context;
}
public SageQuery(ProverbContext context) : base(context) { }