public Template Insert([FromBody] Template template)
{
using (var context = new TemplateAPIContext())
{
if (template != null)
{
context.Templates.Add(template);
context.SaveChanges();
}
return(template);
}
}
public List <Template> GetTemplates()
{
using (var context = new TemplateAPIContext())
{
var query = context.Templates.ToList();
if (query != null)
{
return(query);
}
return(null);
}
}
public Request Insert([FromBody] Request request)
{
using (var context = new TemplateAPIContext())
{
if (request != null)
{
context.Requests.Add(request);
context.SaveChanges();
}
return(request);
}
}
public List <Request> GetRequest()
{
using (var context = new TemplateAPIContext())
{
var query = context.Requests.ToList();
if (query != null)
{
return(query);
}
return(null);
}
}
public Template GetRequestById(int id)
{
using (var context = new TemplateAPIContext())
{
var query = context.Templates.Where(x => x.Id == id).FirstOrDefault();
if (query != null)
{
return(query);
}
else
{
return(null);
}
}
}
public bool Delete(int id)
{
using (var context = new TemplateAPIContext())
{
var entity = context.Templates.Where(x => x.Id == id).FirstOrDefault();
if (entity != null)
{
context.Templates.Remove(entity);
context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public Template Update([FromBody] Template template)
{
using (var context = new TemplateAPIContext())
{
var entity = context.Templates.Where(x => x.Id == template.Id).FirstOrDefault();
if (entity != null)
{
entity.Id = template.Id;
entity.TemplateId = template.TemplateId;
entity.Json = template.Json;
entity.CreationDate = template.CreationDate;
entity.Version = template.Version;
context.SaveChanges();
}
return(entity);
}
}
public Request Update([FromBody] Request request)
{
using (var context = new TemplateAPIContext())
{
var entity = context.Requests.Where(x => x.Id == request.Id).FirstOrDefault();
if (entity != null)
{
entity.Id = request.Id;
entity.TemplateId = request.TemplateId;
entity.Json = request.Json;
entity.CreationDate = request.CreationDate;
entity.Version = request.Version;
context.SaveChanges();
}
return(entity);
}
}
