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