public string Get(Guid id)
{
string value;
using (var ctx = new core2apiv1Context())
{
value = ctx.Values.FirstOrDefault(x => x.Id == id).Value;
}
return(value);
}
public IEnumerable <Values> Get()
{
IEnumerable <Values> values;
using (var ctx = new core2apiv1Context())
{
values = ctx.Values.ToList();
}
return(values);
}
public int Delete(Guid id)
{
EntityEntry <Values> result = null;
try
{
using (var ctx = new core2apiv1Context())
{
result = ctx.Values.Remove(ctx.Values.SingleOrDefault(x => x.Id == id));
ctx.SaveChanges();
}
return(StatusCodes.Status200OK);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(result);
return(StatusCodes.Status500InternalServerError);
}
}
public int Put(Guid id, [FromBody] string value)
{
Values result = null;
try
{
using (var ctx = new core2apiv1Context())
{
result = ctx.Values.SingleOrDefault(x => x.Id == id);
result.Value = value;
ctx.SaveChanges();
}
return(StatusCodes.Status200OK);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(result);
return(StatusCodes.Status500InternalServerError);
}
}
public int Post([FromBody] string value)
{
EntityEntry <Values> result = null;
try
{
using (var ctx = new core2apiv1Context())
{
result = ctx.Values.Add(new Values {
Id = Guid.NewGuid(), Value = value
});
ctx.SaveChanges();
}
return(StatusCodes.Status200OK);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(result);
return(StatusCodes.Status500InternalServerError);
}
}
