private void reorder(DemosContext db, Task task, int id, string status) { if (id == 0) { var tasks = db.Tasks.Where(a => a.Status == status).ToList(); int max = 0; tasks.ForEach(a => { if (a.Order > max) { max = a.Order; } }); task.Order = max + 1; db.SaveChanges(); } else { var prev = db.Tasks.Find(id); var ind = prev.Order; var tasks = db.Tasks.Where(a => a.Order >= ind && a.Status == status).ToList(); tasks.ForEach(a => a.Order += 1); task.Order = ind; db.SaveChanges(); } }
public ActionResult Update(int id, [FromForm] Task update, [FromForm] string webix_move_parent, [FromForm] string webix_move_id) { using (var db = new DemosContext()){ var ev = db.Tasks.Where(a => a.Id == id).FirstOrDefault(); if (webix_move_parent != null) { int pid = 0; if (webix_move_id != "" && webix_move_id != null) { pid = Int32.Parse(webix_move_id); } reorder(db, ev, pid, webix_move_parent); } else { ev.Text = update.Text; ev.Status = update.Status; db.Tasks.Update(ev); db.SaveChanges(); } return(Ok(new { Id = ev.Id })); } }
public ActionResult Delete(int id) { using (var db = new DemosContext()){ var ev = db.Events.Where(a => a.Id == id).FirstOrDefault(); db.Events.Remove(ev); db.SaveChanges(); return(Ok(new { Id = id })); } }
public ActionResult Insert([FromForm] Event ev) { using (var db = new DemosContext()){ ev.Id = 0; db.Events.Add(ev); db.SaveChanges(); return(Ok(new { Id = ev.Id })); } }
public ActionResult Insert([FromBody] Person person) { using (var db = new DemosContext()){ person.Id = 0; db.Persons.Add(person); db.SaveChanges(); return(Ok(new { Id = person.Id })); } }
public ActionResult Update(int id, [FromForm] Event update) { using (var db = new DemosContext()){ var ev = db.Events.Where(a => a.Id == id).FirstOrDefault(); ev.Text = update.Text; ev.StartDate = update.StartDate; ev.EndDate = update.EndDate; db.Events.Update(ev); db.SaveChanges(); return(Ok(new { Id = ev.Id })); } }
public ActionResult Insert([FromForm] Task task) { using (var db = new DemosContext()){ task.Id = 0; if (task.Text == null) { task.Text = ""; } db.Tasks.Add(task); db.SaveChanges(); reorder(db, task, 0, task.Status); return(Ok(new { Id = task.Id })); } }
public ActionResult Update(int id, [FromBody] Person update) { using (var db = new DemosContext()){ var ev = db.Persons.Where(a => a.Id == id).FirstOrDefault(); ev.Name = update.Name; ev.Comments = update.Comments; ev.Active = update.Active; ev.BirthDate = update.BirthDate; db.Persons.Update(ev); db.SaveChanges(); return(Ok(new { Id = ev.Id })); } }
public ActionResult Save(int id, [FromBody] SheetData data) { string body = data.Data.ToString(); using (var db = new DemosContext()){ var sheet = db.Sheets.Where(a => a.Id == id).SingleOrDefault(); if (sheet == null) { db.Sheets.Add(new Sheet { Data = body, Id = id }); } else { sheet.Data = body; } db.SaveChanges(); return(Content("{}", "application/json")); } }