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())); } } }