public IHttpActionResult Put([FromUri] string section, [FromBody] Sections SectionEntity)
{
using (ServicesEntities db = new ServicesEntities())
{
try
{
var UpdatedEntity = db.Sections.Where(s => s.Section == section).FirstOrDefault();
if (UpdatedEntity != null)
{
UpdatedEntity.City = SectionEntity.City;
UpdatedEntity.Location = SectionEntity.Location;
UpdatedEntity.Name = SectionEntity.Name;
db.Entry(UpdatedEntity).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Ok());
}
else
{
return(BadRequest("Записи с данным идентификатором сервера не найдено."));
}
}
catch (Exception ex)
{
return(BadRequest(ex.ToString()));
}
}
}
//GET Service/GetService
public JsonResult ListServices()
{
using (var db = new ServicesEntities())
{
List <Service> services = db.Services.ToList();
return(Json(services, JsonRequestBehavior.AllowGet));
}
}
public IHttpActionResult Get(string section)
{
using (ServicesEntities db = new ServicesEntities())
{
var Section = db.Sections.Where(s => s.Section == section).FirstOrDefault();
if (Section != null)
{
return(Ok(Section));
}
}
return(NotFound());
}
public IHttpActionResult Get()
{
using (ServicesEntities db = new ServicesEntities())
{
return(Ok(db.Sections.ToList().Select(section => new {
section = section.Section,
info = new {
name = section.Name,
city = section.City,
location = section.Location
}
}).OrderBy(s => s.section)));
}
}
public JsonResult RemoveService(int id)
{
using (var db = new ServicesEntities())
{
Service service = db.Services.Find(id);
if (service == null)
{
return(Json(new { success = false }));
}
db.Services.Remove(service);
db.SaveChanges();
return(Json(new { success = true }));
}
}
public JsonResult UpdateService(Service service)
{
using (var db = new ServicesEntities())
{
var serviceUpdated = db.Services.Find(service.ServiceId);
if (serviceUpdated == null)
{
return(Json(new { success = false }));
}
else
{
serviceUpdated.Description = service.Description;
serviceUpdated.Date = service.Date;
serviceUpdated.Type = service.Type;
db.SaveChanges();
return(Json(new { success = true }));
}
}
}
public JsonResult AddService(Service service)
{
if (service != null)
{
using (var db = new ServicesEntities())
{
try
{
db.Services.Add(service);
db.SaveChanges();
}
catch (Exception exception)
{
Console.WriteLine(exception.Message);
}
return(Json(new { success = true }));
}
}
return(Json(new { success = false }));
}
public IHttpActionResult Post([FromUri] string section, [FromBody] Sections SectionEntity)
{
using (ServicesEntities db = new ServicesEntities())
{
try
{
if (db.Sections.Any(s => s.Section == section))
{
return(BadRequest("Запись с данным идентификатором сервера уже создана."));
}
SectionEntity.Id = Guid.NewGuid();
SectionEntity.Section = section;
db.Sections.Add(SectionEntity);
db.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
return(BadRequest(ex.ToString()));
}
}
}
