public ActionResult Load()
{
using (var db = new DemosContext()){
var persons = db.Persons.ToList();
return(Ok(persons));
}
}
public ActionResult Load()
{
using (var db = new DemosContext()){
var events = db.Events.ToList();
return(Ok(events));
}
}
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 Load()
{
using (var db = new DemosContext()){
var tasks = db.Tasks.OrderBy(a => a.Order).ToList();
return(Ok(tasks));
}
}
public ActionResult Load(int id)
{
using (var db = new DemosContext()){
var sheet = db.Sheets.Where(a => a.Id == id).SingleOrDefault();
var json = sheet == null ? "{}" : sheet.Data;
return(Content(json, "application/json"));
}
}
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 LoadDynamic([FromQuery] int count, [FromQuery] int start)
{
using (var db = new DemosContext()){
if (count == 0)
{
count = 20;
}
var persons = db.Persons.Skip(start).Take(count).ToList();
return(Ok(new DynamicData {
Count = db.Persons.Count(),
Pos = start,
Data = persons
}));
}
}
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"));
}
}
