//GET: ProjectSupervisors/Edit/5 public ActionResult Select(string id, string StudentNumber) { string studID = StudentNumber; using (var db = new ProgressTrackerEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProjectSupervisor supervisor = db.ProjectSupervisors.Find(id); Student student = db.Students.Find(id); if (supervisor == null) { return(HttpNotFound()); } string selectedSup = supervisor.UserID; Allocation allocation = new Allocation(); allocation.StaffNumber = id; allocation.StudentNumber = studID; db.Allocations.Add(allocation); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } }
public ActionResult UploadFile(int?id) { using (var db = new ProgressTrackerEntities()) { ViewBag.Id = id; } return(View()); }
// GET: Students/Create public ActionResult Create() { using (ProgressTrackerEntities dc = new ProgressTrackerEntities()) { ViewBag.StudentNumber = new SelectList(db.AspNetUsers, "Id", "Email"); return(View()); } }
public LinkDto Get(int id) { using (var dc = new ProgressTrackerEntities()) { return((LinkDto)dc .Links .Find(id)); } }
public async Task <ActionResult> RegisterAdmin(RegisterAdmin model) { using (var db = new ProgressTrackerEntities()) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email, Name = model.Name, Surname = model.Surname, Title = model.Title, Picture = null }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); var _context = new ApplicationDbContext(); var roleStore = new RoleStore <Microsoft.AspNet.Identity.EntityFramework.IdentityRole>(_context); var roleManager = new RoleManager <IdentityRole>(roleStore); var userStore = new UserStore <ApplicationUser>(_context); var UseManage = new UserManager <ApplicationUser>(userStore); UseManage.AddToRole(user.Id, "Admin"); var id = user.Id; // For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); Admin admin = new Admin { UserID = id, }; db.Admins.Add(admin); db.SaveChanges(); return(View("DisplayEmail")); // return RedirectToAction("Index", "Home"); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); } }
public IEnumerable <LinkDto> Get() { using (var dc = new ProgressTrackerEntities()) { return(dc .Links .ToList() .Select(l => (LinkDto)l)); } }
public ActionResult viewAll() { using (ProgressTrackerEntities dc = new ProgressTrackerEntities()) { List <Object> mymodal = new List <object>(); mymodal.Add(db.Students.ToList()); mymodal.Add(db.ProjectSupervisors.ToList()); return(View(mymodal)); } }
protected override void Dispose(bool disposing) { using (var dc = new ProgressTrackerEntities()) { if (disposing) { dc.Dispose(); } base.Dispose(disposing); } }
public TaskDto Get(int id) { List <Milestone> data = new List <Milestone>(); var userID = User.Identity.GetUserId(); using (var dc = new ProgressTrackerEntities()) { return((TaskDto)dc .Milestones .Find(id)); } }
protected override void Dispose(bool disposing) { var userID = User.Identity.GetUserId(); using (var dc = new ProgressTrackerEntities()) { if (disposing) { dc.Dispose(); } base.Dispose(disposing); } }
public IHttpActionResult CreateTask(TaskDto taskDto) { Completed completed = new Completed(); To_Do to_Do = new To_Do(); var userID = User.Identity.GetUserId(); Milestone task = new Milestone(); using (var dc = new ProgressTrackerEntities()) { var newTask = (Milestone)taskDto; newTask.SortOrder = dc.Milestones.Max(t => t.SortOrder) + 1; newTask.StudentNumber = userID; if (newTask.Progress == 1) { newTask.Status = "Completed"; newTask.Completed = true; completed.Progress = newTask.Progress; completed.StudentNumber = newTask.StudentNumber; dc.Completeds.Add(completed); dc.SaveChanges(); } if (newTask.Progress > 0 && newTask.Progress < 1) { newTask.Status = "In-Progress"; newTask.InProgress = true; } if (newTask.Progress == 0) { newTask.Status = "To-Do"; newTask.ToDo = true; to_Do.StudentNumber = newTask.StudentNumber; to_Do.Progress = newTask.Progress; dc.To_Do.Add(to_Do); dc.SaveChanges(); } dc.Milestones.Add(newTask); dc.SaveChanges(); return(Ok(new { tid = newTask.Id, action = "inserted" })); } }
public ActionResult ViewMilestones() { List <Milestone> data = new List <Milestone>(); var userID = User.Identity.GetUserId(); using (var db = new ProgressTrackerEntities()) { var milestones = from rowM in db.Milestones where rowM.StudentNumber == userID select rowM; data = milestones.ToList(); } return(View(data)); }
public ActionResult Edit([Bind(Include = "StudentNumber,Course,StudyYear,ProjectName")] Student student) { using (ProgressTrackerEntities dc = new ProgressTrackerEntities()) { if (ModelState.IsValid) { db.Entry(student).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StudentNumber = new SelectList(db.AspNetUsers, "Id", "Email", student.UserID); return(View(student)); } }
public ActionResult ViewMySupervisor(string id) { List <AspNetUser> supervisor = new List <AspNetUser>(); var studId = User.Identity.GetUserId(); using (ProgressTrackerEntities dc = new ProgressTrackerEntities()) { var sups = from rowS in dc.AspNetUsers join rowR in dc.Allocations on rowS.Id equals rowR.StaffNumber where rowR.StudentNumber == studId select rowS; supervisor = sups.ToList(); } return(View(supervisor)); }
public ActionResult ViewStudentMilestones(string id) { List <Milestone> data = new List <Milestone>(); Student student = new Student(); var studID = id; using (var db = new ProgressTrackerEntities()) { var milestones = from rowM in db.Milestones where rowM.StudentNumber == studID select rowM; data = milestones.ToList(); } return(View(data)); }
public IHttpActionResult CreateLink(LinkDto linkDto) { using (var dc = new ProgressTrackerEntities()) { var newLink = (Link)linkDto; dc.Links.Add(newLink); dc.SaveChanges(); return(Ok(new { tid = newLink.LinkId, action = "inserted" })); } }
public ActionResult ViewAllStudents() { List <AspNetUser> students = new List <AspNetUser>(); using (ProgressTrackerEntities dc = new ProgressTrackerEntities()) { var allstuds = from rowS in dc.AspNetUsers join rowStudents in dc.Students on rowS.Id equals rowStudents.UserID where rowS.Id == rowStudents.UserID select rowS; students = allstuds.ToList(); return(View(students)); } }
public ActionResult ViewAllSupervisors() { List <AspNetUser> supervisors = new List <AspNetUser>(); using (ProgressTrackerEntities dc = new ProgressTrackerEntities()) { var allsupervisors = from rowS in db.AspNetUsers join rowSupervisor in db.ProjectSupervisors on rowS.Id equals rowSupervisor.UserID where rowS.Id == rowSupervisor.UserID select rowS; supervisors = allsupervisors.ToList(); return(View(supervisors)); } }
public IHttpActionResult DeleteLink(int id) { using (var dc = new ProgressTrackerEntities()) { var link = dc.Links.Find(id); if (link != null) { dc.Links.Remove(link); dc.SaveChanges(); } return(Ok(new { action = "deleted" })); } }
// GET: Students/Details/5 public ActionResult Details(string id) { using (ProgressTrackerEntities dc = new ProgressTrackerEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Student student = db.Students.Find(id); if (student == null) { return(HttpNotFound()); } return(View(student)); } }
public IHttpActionResult EditLink(int id, LinkDto linkDto) { using (var dc = new ProgressTrackerEntities()) { var clientLink = (Link)linkDto; clientLink.LinkId = id; dc.Entry(clientLink).State = EntityState.Modified; dc.SaveChanges(); return(Ok(new { action = "updated" })); } }
// GET api/Task public IEnumerable <TaskDto> Get() { List <Milestone> data = new List <Milestone>(); var userID = User.Identity.GetUserId(); using (var dc = new ProgressTrackerEntities()) { var milestones = from rowM in dc.Milestones where rowM.StudentNumber == userID select rowM; data = milestones.OrderBy(t => t.SortOrder).ToList(); return(data.Select(t => (TaskDto)t)); } }
public ActionResult ViewMyStudents() { var staffId = User.Identity.GetUserId(); List <AspNetUser> students = new List <AspNetUser>(); using (ProgressTrackerEntities dc = new ProgressTrackerEntities()) { var mystudents = from rowS in db.AspNetUsers join rowStudent in db.Students on rowS.Id equals rowStudent.UserID join rowAll in db.Allocations on rowStudent.UserID equals rowAll.StudentNumber where rowAll.StaffNumber == staffId select rowS; students = mystudents.ToList(); } return(View(students)); }
public ActionResult Edit([Bind(Include = "MilestoneID,Text,StartDate,Duration,ProjectNumber,Type,ParentId,Progress,Id,StudentNumber")] Milestone milestone) { var userID = User.Identity.GetUserId(); using (var db = new ProgressTrackerEntities()) { if (ModelState.IsValid) { milestone.StudentNumber = userID; db.Entry(milestone).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } ViewBag.MilestoneID = new SelectList(db.Students, "StudentNumber", "Course", milestone.MilestoneID); return(View(milestone)); }
// GET: Students/Edit/5 public ActionResult Edit(string id) { using (ProgressTrackerEntities dc = new ProgressTrackerEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Student student = db.Students.Find(id); if (student == null) { return(HttpNotFound()); } ViewBag.StudentNumber = new SelectList(db.AspNetUsers, "Id", "Email", student.UserID); return(View(student)); } }
// GET: Milestones/Delete/5 public ActionResult Delete(int?id) { var userID = User.Identity.GetUserId(); using (var db = new ProgressTrackerEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Milestone milestone = db.Milestones.Find(id); if (milestone == null) { return(HttpNotFound()); } return(View(milestone)); } }
public IHttpActionResult DeleteTask(int id) { var userID = User.Identity.GetUserId(); using (var dc = new ProgressTrackerEntities()) { var task = dc.Milestones.Find(id); if (task != null) { dc.Milestones.Remove(task); dc.SaveChanges(); } return(Ok(new { action = "deleted" })); } }
// GET: Milestones/Edit/5 public ActionResult Edit(int?id) { Milestone milestone = new Milestone(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (var db = new ProgressTrackerEntities()) { milestone = db.Milestones.Find(id); } if (milestone == null) { return(HttpNotFound()); } //ViewBag.MilestoneID = new SelectList(db.Students, "StudentNumber", "Course", milestone.MilestoneID); return(View(milestone)); }
public IHttpActionResult EditTask(int id, TaskDto taskDto) { var userID = User.Identity.GetUserId(); Completed completed = new Completed(); To_Do to_Do = new To_Do(); using (var dc = new ProgressTrackerEntities()) { var updatedTask = (Milestone)taskDto; updatedTask.Id = id; if (taskDto.progress == 1) { updatedTask.Status = "Completed"; completed.Progress = updatedTask.Progress; completed.StudentNumber = updatedTask.StudentNumber; dc.Completeds.Add(completed); dc.SaveChanges(); } else if (taskDto.progress == 0) { updatedTask.Status = "To-Do"; to_Do.StudentNumber = updatedTask.StudentNumber; to_Do.Progress = updatedTask.Progress; dc.To_Do.Add(to_Do); dc.SaveChanges(); } else { updatedTask.Status = "In-Progress"; } dc.Entry(updatedTask).State = EntityState.Modified; dc.SaveChanges(); return(Ok(new { action = "updated" })); } }
public ActionResult Upload([Bind(Include = "DocumentID,DocumentName,Path,Id,MilestoneID")] Document document, IEnumerable <HttpPostedFileBase> File, int id) { using (var db = new ProgressTrackerEntities()) { if (ModelState.IsValid) { document.Path = "/UploadedFiles/" + File.First().FileName; document.MilestoneID = id; document.DocumentName = document.DocumentName; db.Documents.Add(document); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Id = new SelectList(db.Milestones, "Id", "Text", document.Id); } return(View(document)); }