public ActionResult TaskBoxItem( int ID )
{
BaseReturn br = new BaseReturn();
MobileTaskBox mtb = new MobileTaskBox();
var item = (from e in DbUtil.Db.TaskLists
where e.CreatedBy == ID
select e).SingleOrDefault();
br.type = 104;
if (item != null)
{
br.count = 1;
mtb.populate(item);
br.data = JSONHelper.JsonSerializer<MobileTaskBox>(mtb);
}
else
{
br.error = 1;
}
return br;
}
public ActionResult TaskBoxItem(int ID)
{
BaseReturn br = new BaseReturn();
MobileTaskBox mtb = new MobileTaskBox();
var item = (from e in DbUtil.Db.TaskLists
where e.CreatedBy == ID
select e).SingleOrDefault();
br.type = 104;
if (item != null)
{
br.count = 1;
mtb.populate(item);
br.data = JSONHelper.JsonSerializer <MobileTaskBox>(mtb);
}
else
{
br.error = 1;
}
return(br);
}
public ActionResult TaskItem(int ID)
{
BaseReturn br = new BaseReturn();
MobileTask mt = new MobileTask();
var item = (from e in DbUtil.Db.Tasks
where e.Id == ID
select e).SingleOrDefault();
br.type = 102;
if (item != null)
{
br.count = 1;
mt.populate(item);
br.data = JSONHelper.JsonSerializer <MobileTask>(mt);
}
else
{
br.error = 1;
}
return(br);
}
public ActionResult TaskList(int ID)
{
BaseReturn br = new BaseReturn();
List <MobileTask> mt = new List <MobileTask>();
var list = from e in DbUtil.Db.Tasks
where e.OwnerId == ID
select e;
br.type = 101;
if (list != null)
{
br.count = list.Count();
foreach (var item in list)
{
mt.Add(new MobileTask().populate(item));
}
br.data = JSONHelper.JsonSerializer <List <MobileTask> >(mt);
}
else
{
br.error = 1;
}
return(br);
}
public ActionResult Authorize()
{
BaseReturn br = new BaseReturn();
if (CmsWeb.Models.AccountModel.AuthenticateMobile())
{
br.id = Util.UserPeopleId ?? 0;
return br;
}
else
{
br.error = 1;
br.data = "Username and password combination not found, please try again.";
return br;
}
}
public ActionResult Authorize()
{
BaseReturn br = new BaseReturn();
if (CmsWeb.Models.AccountModel.AuthenticateMobile())
{
br.id = Util.UserPeopleId ?? 0;
return(br);
}
else
{
br.error = 1;
br.data = "Username and password combination not found, please try again.";
return(br);
}
}
public ActionResult Search(string name, string comm, string addr)
{
BaseReturn br = new BaseReturn();
List <MobilePerson> mp = new List <MobilePerson>();
var m = new SearchModel(name, comm, addr);
br.type = 1;
br.count = m.Count;
foreach (var item in m.ApplySearch().OrderBy(p => p.Name2).Take(20))
{
mp.Add(new MobilePerson().populate(item));
}
br.data = JSONHelper.JsonSerializer <List <MobilePerson> >(mp);
return(br);
}
public ActionResult Search(string name, string comm, string addr)
{
BaseReturn br = new BaseReturn();
List<MobilePerson> mp = new List<MobilePerson>();
var m = new SearchModel(name, comm, addr);
br.type = 1;
br.count = m.Count;
foreach( var item in m.ApplySearch().OrderBy(p => p.Name2).Take(20) )
{
mp.Add(new MobilePerson().populate(item));
}
br.data = JSONHelper.JsonSerializer<List<MobilePerson>>(mp);
return br;
}
public ActionResult TaskStatusList()
{
BaseReturn br = new BaseReturn();
List <MobileTaskStatus> ls = new List <MobileTaskStatus>();
br.type = 105;
var s = from e in DbUtil.Db.TaskStatuses
select e;
foreach (var item in s)
{
ls.Add(new MobileTaskStatus().populate(item));
}
br.count = s.Count();
br.data = JSONHelper.JsonSerializer <List <MobileTaskStatus> >(ls);
return(br);
}
public ActionResult TaskCreate(string type, string data) // Type 1001
{
BaseReturn br = new BaseReturn();
br.type = 1001;
MobileTask mt = JSONHelper.JsonDeserialize <MobileTask>(data);
if (mt != null)
{
br.id = mt.addToDB();
}
else
{
br.error = 1;
br.data = "Task was not created.";
}
return(br);
}
public ActionResult Authorize()
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
br.error = 0;
br.id = Util.UserPeopleId ?? 0;
List<MobilePerson> mp = new List<MobilePerson>();
var person = DbUtil.Db.People.SingleOrDefault(p => p.PeopleId == Util.UserPeopleId);
if (person != null)
{
mp.Add(new MobilePerson().populate(person));
br.data = JsonConvert.SerializeObject(mp);
br.count = 1;
}
return br;
}
public ActionResult DoSearch(string name, string comm, string addr)
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
List<MobilePerson> mp = new List<MobilePerson>();
var m = new SearchModel(name, comm, addr);
br.error = 0;
br.type = 1;
br.count = m.Count;
foreach (var item in m.ApplySearch().OrderBy(p => p.Name2).Take(20))
{
mp.Add(new MobilePerson().populate(item));
}
br.data = JsonConvert.SerializeObject(mp);
return br;
}
private ActionResult Authenticate()
{
if (CmsWeb.Models.AccountModel.AuthenticateMobile()) return null;
else
{
BaseReturn br = new BaseReturn();
br.data = "You are not authorized!";
return br;
}
}
public ActionResult TaskUpdate(string type, string data)
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
br.type = 1002;
MobileTask mt = JSONHelper.JsonDeserialize<MobileTask>(data);
var t = from e in DbUtil.Db.Tasks
where e.Id == mt.id
select e;
if (t != null)
{
var task = t.Single();
if (mt.updateDue > 0) task.Due = mt.due;
if (mt.statusID > 0) task.StatusId = mt.statusID;
if (mt.priority > 0) task.Priority = mt.priority;
if (mt.notes.Length > 0) task.Notes = mt.notes;
if (mt.description.Length > 0) task.Description = mt.description;
if (mt.ownerID > 0) task.OwnerId = mt.ownerID;
if (mt.boxID > 0) task.ListId = mt.boxID;
if (mt.aboutID > 0) task.WhoId = mt.aboutID;
if (mt.delegatedID > 0) task.CoOwnerId = mt.delegatedID;
if (mt.notes.Length > 0) task.Notes = mt.notes;
DbUtil.Db.SubmitChanges();
br.data = "Task updated.";
}
else
{
br.error = 1;
br.data = "Task not found.";
}
return br;
}
public ActionResult TaskStatusList()
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
List<MobileTaskStatus> ls = new List<MobileTaskStatus>();
br.type = 105;
var s = from e in DbUtil.Db.TaskStatuses
select e;
foreach (var item in s)
{
ls.Add(new MobileTaskStatus().populate(item));
}
br.count = s.Count();
br.data = JSONHelper.JsonSerializer<List<MobileTaskStatus>>(ls);
return br;
}
public ActionResult TaskList(int ID)
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
List<MobileTask> mt = new List<MobileTask>();
var list = from e in DbUtil.Db.Tasks
where e.OwnerId == ID
select e;
br.type = 101;
if (list != null)
{
br.count = list.Count();
foreach (var item in list)
{
mt.Add(new MobileTask().populate(item));
}
br.data = JSONHelper.JsonSerializer<List<MobileTask>>(mt);
}
else
{
br.error = 1;
}
return br;
}
public ActionResult TaskItem(int ID)
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
MobileTask mt = new MobileTask();
var item = (from e in DbUtil.Db.Tasks
where e.Id == ID
select e).SingleOrDefault();
br.type = 102;
if (item != null)
{
br.count = 1;
mt.populate(item);
br.data = JSONHelper.JsonSerializer<MobileTask>(mt);
}
else
{
br.error = 1;
}
return br;
}
public ActionResult TaskCreate(string type, string data)
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
br.type = 1001;
MobileTask mt = JSONHelper.JsonDeserialize<MobileTask>(data);
if (mt != null) br.id = mt.addToDB();
else
{
br.error = 1;
br.data = "Task was not created.";
}
return br;
}
public ActionResult SaveImage(int id, string image)
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
var imageBytes = Convert.FromBase64String(image);
var person = DbUtil.Db.People.SingleOrDefault(pp => pp.PeopleId == id);
if (person.Picture != null)
{
ImageData.DbUtil.Db.Images.DeleteOnSubmit(ImageData.DbUtil.Db.Images.Where(i => i.Id == person.Picture.ThumbId).SingleOrDefault());
ImageData.DbUtil.Db.Images.DeleteOnSubmit(ImageData.DbUtil.Db.Images.Where(i => i.Id == person.Picture.SmallId).SingleOrDefault());
ImageData.DbUtil.Db.Images.DeleteOnSubmit(ImageData.DbUtil.Db.Images.Where(i => i.Id == person.Picture.MediumId).SingleOrDefault());
ImageData.DbUtil.Db.Images.DeleteOnSubmit(ImageData.DbUtil.Db.Images.Where(i => i.Id == person.Picture.LargeId).SingleOrDefault());
person.Picture.ThumbId = ImageData.Image.NewImageFromBits(imageBytes, 50, 50).Id;
person.Picture.SmallId = ImageData.Image.NewImageFromBits(imageBytes, 120, 120).Id;
person.Picture.MediumId = ImageData.Image.NewImageFromBits(imageBytes, 320, 400).Id;
person.Picture.LargeId = ImageData.Image.NewImageFromBits(imageBytes, 570, 800).Id;
}
else
{
var newPicture = new Picture();
newPicture.ThumbId = ImageData.Image.NewImageFromBits( imageBytes, 50, 50 ).Id;
newPicture.SmallId = ImageData.Image.NewImageFromBits( imageBytes, 120, 120 ).Id;
newPicture.MediumId = ImageData.Image.NewImageFromBits( imageBytes, 320, 400 ).Id;
newPicture.LargeId = ImageData.Image.NewImageFromBits( imageBytes, 570, 800 ).Id;
person.Picture = newPicture;
}
DbUtil.Db.SubmitChanges();
br.error = 0;
br.data = "Image updated.";
br.id = id;
br.count = 1;
return br;
}
public ActionResult TaskUpdate(string type, string data) // Type 1002
{
BaseReturn br = new BaseReturn();
br.type = 1002;
MobileTask mt = JSONHelper.JsonDeserialize <MobileTask>(data);
var t = from e in DbUtil.Db.Tasks
where e.Id == mt.id
select e;
if (t != null)
{
var task = t.Single();
if (mt.updateDue > 0)
{
task.Due = mt.due;
}
if (mt.statusID > 0)
{
task.StatusId = mt.statusID;
}
if (mt.priority > 0)
{
task.Priority = mt.priority;
}
if (mt.notes.Length > 0)
{
task.Notes = mt.notes;
}
if (mt.description.Length > 0)
{
task.Description = mt.description;
}
if (mt.ownerID > 0)
{
task.OwnerId = mt.ownerID;
}
if (mt.boxID > 0)
{
task.ListId = mt.boxID;
}
if (mt.aboutID > 0)
{
task.WhoId = mt.aboutID;
}
if (mt.delegatedID > 0)
{
task.CoOwnerId = mt.delegatedID;
}
if (mt.notes.Length > 0)
{
task.Notes = mt.notes;
}
DbUtil.Db.SubmitChanges();
br.data = "Task updated.";
}
else
{
br.error = 1;
br.data = "Task not found.";
}
return(br);
}
public ActionResult TaskBoxList( int ID )
{
BaseReturn br = new BaseReturn();
List<MobileTaskBox> mtb = new List<MobileTaskBox>();
var list = from e in DbUtil.Db.TaskLists
where e.CreatedBy == ID
select e;
br.type = 103;
if (list != null)
{
br.count = list.Count();
foreach (var item in list)
{
mtb.Add(new MobileTaskBox().populate(item));
}
br.data = JSONHelper.JsonSerializer<List<MobileTaskBox>>(mtb);
}
else
{
br.error = 1;
}
return br;
}
public ActionResult FetchImage( int id, int size )
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
if( id == 0 ) return br.setData("The ID for the person cannot be set to zero");
br.data = "The picture was not found.";
var person = DbUtil.Db.People.SingleOrDefault(pp => pp.PeopleId == id);
if (person.PictureId != null)
{
ImageData.Image image = null;
switch (size)
{
case 0: // 50 x 50
image = ImageData.DbUtil.Db.Images.SingleOrDefault(i => i.Id == person.Picture.ThumbId);
break;
case 1: // 120 x 120
image = ImageData.DbUtil.Db.Images.SingleOrDefault(i => i.Id == person.Picture.SmallId);
break;
case 2: // 320 x 400
image = ImageData.DbUtil.Db.Images.SingleOrDefault(i => i.Id == person.Picture.MediumId);
break;
case 3: // 570 x 800
image = ImageData.DbUtil.Db.Images.SingleOrDefault(i => i.Id == person.Picture.LargeId);
break;
}
if (image != null)
{
br.data = Convert.ToBase64String(image.Bits);
br.count = 1;
br.error = 0;
}
}
return br;
}
public ActionResult FetchPerson(int id)
{
var authError = Authenticate();
if (authError != null) return authError;
BaseReturn br = new BaseReturn();
List<MobilePerson> mp = new List<MobilePerson>();
var person = DbUtil.Db.People.SingleOrDefault(p => p.PeopleId == id);
if (person == null)
{
br.error = 1;
br.data = "Person not found.";
return br;
}
br.error = 0;
br.type = 1;
br.count = 1;
mp.Add(new MobilePerson().populate(person));
br.data = JsonConvert.SerializeObject(mp);
return br;
}
