public async Task <IActionResult> Edit(int id, [Bind("ActivityTypeID,Username,ActTypeDescrip,ActTypeProd")] ActivityType activityType) { if (id != activityType.ActivityTypeID || activityType.Username != User.Identity.Name) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(activityType); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ActivityTypeExists(activityType.ActivityTypeID)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(activityType)); }
public async Task <IActionResult> Edit(int id, [Bind("ActivityID,Username,ActivityName,ActivityTypeID")] Activity activity) { if (id != activity.ActivityID || activity.Username != User.Identity.Name) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(activity); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ActivityExists(activity.ActivityID)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } ViewData["ActivityTypeID"] = new SelectList(_context.ActivityTypes.Where(o => o.Username == User.Identity.Name), "ActivityTypeID", "ActTypeDescrip", activity.ActivityTypeID); return(View(activity)); }
public async Task <IActionResult> Edit(int id, [Bind("TimeLogID,Username,ActivityID,StartTime,EndTime")] TimeLog timeLog) { if (id != timeLog.TimeLogID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(timeLog); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TimeLogExists(timeLog.TimeLogID)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } ViewData["ActivityID"] = new SelectList(_context.Activities.Where(o => o.Username == User.Identity.Name), "ActivityID", "Username", timeLog.ActivityID); return(View(timeLog)); }
public async Task <IActionResult> Create([Bind("ActivityID")] TimeLog timeLog) { if (ModelState.IsValid) { //get last time log with no end time string query = "SELECT TOP 1 * FROM TimeLog WHERE Username = {0} and EndTime is null order by StartTime desc"; try { var endTimeLog = await _context.TimeLogs .FromSql(query, User.Identity.Name) .AsNoTracking() .SingleOrDefaultAsync(); if (endTimeLog != null) { endTimeLog.EndTime = DateTime.Now; _context.Update(endTimeLog); await _context.SaveChangesAsync(); } } catch (DbUpdateConcurrencyException) { if (!TimeLogExists(timeLog.TimeLogID)) { return(NotFound()); } else { throw; } } try { timeLog.Username = User.Identity.Name; timeLog.StartTime = DateTime.Now; _context.Add(timeLog); await _context.SaveChangesAsync(); } catch { } return(RedirectToAction("Index")); } ViewData["ActivityID"] = new SelectList(_context.Activities, "ActivityID", "ActivityID", timeLog.ActivityID); return(View(timeLog)); }