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