public JsonResult GetAll()
{
using (var db = new LessThanDatabase())
{
return Json(db.Tasks.ToArray().Select(a => a.ToJson()).ToArray(), JsonRequestBehavior.AllowGet);
}
}
public ActionResult Index()
{
using(var db = new LessThanDatabase())
{
return View(db.Tasks.ToArray());
}
}
public ActionResult Index()
{
using (var dc = new LessThanDatabase())
{
var userProfileLogin = dc.UserProfileLogins.First(a => a.UniqueIdentifier == User.Identity.Name);
return View(userProfileLogin.UserProfile);
}
}
public ActionResult Update(string username)
{
using (var dc = new LessThanDatabase())
{
var userProfileLogin = dc.UserProfileLogins.First(a => a.UniqueIdentifier == User.Identity.Name);
TempData["username"] = username;
userProfileLogin.UserProfile.UserName = username;
dc.SaveChanges();
return Json(new { msg = "Username is bijgewerkt. <a href='" +Url.Action("Undo") + "' class='undo'>Undo</a>" });
}
}
public EmptyResult SaveTime(int id, int minutes)
{
using (var db = new LessThanDatabase())
{
var task = db.Tasks.FirstOrDefault(x => x.Id == id);
if (task != null)
{
task.TimeSpent = new TimeSpan(0, minutes, 0);
db.SaveChanges();
}
}
return new EmptyResult();
}
public ActionResult Undo()
{
using (var dc = new LessThanDatabase())
{
var userProfileLogin = dc.UserProfileLogins.First(a => a.UniqueIdentifier == User.Identity.Name);
var originalUsername = TempData["username"] as string;
if(!string.IsNullOrEmpty(originalUsername))
{
userProfileLogin.UserProfile.UserName = originalUsername;
dc.SaveChanges();
return Json(new { msg = "Username ongedaan gemaakt" });
}
return Json(new { msg = "Username kon niet ongedaan worden gemaakt" });
}
}
public JsonResult Add(string rawtask)
{
var task = TaskBuilder.CreateTask(rawtask);
using (var db = new LessThanDatabase())
{
task.DateCreated = DateTime.Now;
task.CreatorId = db.UserProfileLogins.First(a => a.UniqueIdentifier == User.Identity.Name).UserProfileId ?? 0;
db.Tasks.AddObject(task);
db.SaveChanges();
}
IConnection connection = Connection.GetConnection<SignalREndPoint>();
connection.Broadcast(new { func = "Add", task });
return Json(task.ToJson());
}
private void AddUserProfile(User user)
{
using (var dc = new LessThanDatabase())
{
var userProfileLogin = dc.UserProfileLogins.FirstOrDefault(a => a.UniqueIdentifier == user.ClaimedIdentifier);
if (userProfileLogin == null)
{
var userProfile = new UserProfile
{
EmailAddress = user.EmailAddress,
FullName = user.Name,
UserName = user.EmailAddress
};
dc.UserProfiles.AddObject(userProfile);
userProfileLogin = new UserProfileLogin
{
UniqueIdentifier = user.ClaimedIdentifier,
UserProfile = userProfile
};
dc.UserProfileLogins.AddObject(userProfileLogin);
dc.SaveChanges();
}
}
}
public EmptyResult ToggleComplete(int id, bool done)
{
using (var db = new LessThanDatabase())
{
var task = db.Tasks.FirstOrDefault(x => x.Id == id);
if (task != null)
{
task.IsDone = done;
db.SaveChanges();
}
}
return new EmptyResult();
}
public JsonResult ToggleTimer(int id, bool start)
{
using (var db = new LessThanDatabase())
{
var task = db.Tasks.FirstOrDefault(x => x.Id == id);
if (task != null)
{
//task.IsStarted = start;
if (start)
{
//task.DateStarted = DateTime.Now;
}
else
{
//if (task.DateStarted.HasValue)
{
//var diff = DateTime.Now - task.DateStarted.Value;
//var timespent = (int) Math.Round(diff.TotalMinutes);
//task.TimeSpent = timespent;
//task.DateStarted = null;
}
}
return Json(task.TimeSpent);
}
return Json(false);
}
}
private void AddUserProfileLogin(User user)
{
using (var dc = new LessThanDatabase())
{
var userProfileLogin = dc.UserProfileLogins.FirstOrDefault(a => a.UniqueIdentifier == user.ClaimedIdentifier);
if (userProfileLogin == null)
{
userProfileLogin = new UserProfileLogin
{
UniqueIdentifier = user.ClaimedIdentifier,
UserProfile = dc.UserProfiles.First(a => a.UserProfileLogins.Any(b=>b.UniqueIdentifier == User.Identity.Name))
};
dc.UserProfileLogins.AddObject(userProfileLogin);
dc.SaveChanges();
}
}
}
