public void DeleteProjectTest()
{
var appDataDir = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "C:\\Users\\Claudiu Sirbu\\source\\repos\\SE\\Student\\App_Data");
AppDomain.CurrentDomain.SetData("DataDirectory", appDataDir);
ManagementController managementController = new ManagementController();
managementController.AddProject("project", false);
Student.Models.ApplicationDbContext dbContext = Models.ApplicationDbContext.Create();
List <Student.Models.Project> projects = dbContext.Projects.Where(m => m.Name == "project").ToList();
var ID = projects[0].ID;
dbContext.Projects.Remove(projects[0]);
dbContext.SaveChanges();
List <Student.Models.Project> list = dbContext.Projects.Where(m => m.ID == ID).ToList();
var count = list.Count;
Assert.Equal(count, 0);
if (list.Count != 0)
{
dbContext.Projects.Remove(list[0]);
dbContext.SaveChanges();
}
dbContext.Dispose();
}
public void DeleteUser()
{
var appDataDir = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "C:\\Users\\Claudiu Sirbu\\source\\repos\\SE\\Student\\App_Data");
AppDomain.CurrentDomain.SetData("DataDirectory", appDataDir);
ManagementController managementController = new ManagementController();
managementController.AddUser("stoe", "password", "stoenica", "robert", 1960718162021, "*****@*****.**", "admin");
Student.Models.ApplicationDbContext dbContext = Models.ApplicationDbContext.Create();
List <Student.Models.User> users = dbContext.Users.Where(m => m.Username == "stoe").ToList();
var ID = users[0].ID;
dbContext.Users.Remove(users[0]);
dbContext.SaveChanges();
List <Student.Models.User> list = dbContext.Users.Where(m => m.ID == ID).ToList();
var count = list.Count;
Assert.Equal(count, 0);
if (list.Count != 0)
{
var uid = list[0].ID;
var role = dbContext.Roles.Where(r => r.UserID == uid).ToList()[0];
dbContext.Roles.Remove(role);
dbContext.Users.Remove(list[0]);
dbContext.SaveChanges();
}
dbContext.Dispose();
}
public void SetProjectTest()
{
var appDataDir = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "C:\\Users\\Claudiu Sirbu\\source\\repos\\SE\\Student\\App_Data");
AppDomain.CurrentDomain.SetData("DataDirectory", appDataDir);
ManagementController managementController = new ManagementController();
managementController.AddUser("stoe", "password", "stoenica", "robert", 1960718162021, "*****@*****.**", "admin");
managementController.AddProject("project", false);
managementController.SetProject("stoe", "project");
Student.Models.ApplicationDbContext dbContext = Models.ApplicationDbContext.Create();
dbContext.SaveChanges();
List <Student.Models.User> user = dbContext.Users.Where(m => m.Username == "stoe").ToList();
List <Student.Models.Project> project = dbContext.Projects.Where(m => m.Name == "project").ToList();
var projectID = project[0].ID;
var userID = user[0].ID;
List <Student.Models.Users_Projects> projects = dbContext.UsersProjects.Where(m => m.ProjectID == projectID && m.UserID == userID).ToList();
var firstProjectID = projects[0].ProjectID;
var firstUserID = projects[0].UserID;
Assert.Equal(firstProjectID, projectID);
Assert.Equal(firstUserID, userID);
dbContext.UsersProjects.Remove(projects[0]);
dbContext.Projects.Remove(project[0]);
var uid = user[0].ID;
var role = dbContext.Roles.Where(r => r.UserID == uid).ToList()[0];
dbContext.Roles.Remove(role);
dbContext.Users.Remove(user[0]);
dbContext.SaveChanges();
dbContext.Dispose();
}
public ActionResult AddProject(string projectName, bool?projectOptional)
{
Student.Models.ApplicationDbContext dbContext = Student.Models.ApplicationDbContext.Create();
Student.Models.Project projectModel = new Student.Models.Project();
if (dbContext.Projects.Where(m => m.Name == projectName).ToList().Count > 0)
{
TempData["Error"] = "Project already exists!";
return(RedirectToAction("Index"));
}
projectModel.Name = projectName;
projectModel.Description = "";
projectModel.Deadline = DateTime.Now;
if (projectOptional == true)
{
projectModel.Optional = true;
}
else
{
projectOptional = false;
}
dbContext.Projects.Add(projectModel);
dbContext.SaveChanges();
dbContext.Dispose();
return(RedirectToAction("Index"));
}
public ActionResult DeleteUser(string username)
{
Student.Models.ApplicationDbContext dbContext = Student.Models.ApplicationDbContext.Create();
List <Student.Models.User> user = dbContext.Users.Where(m => m.Username == username).ToList();
if (user.Count() != 0)
{
int id = user[0].ID;
List <Student.Models.UserRole> role = dbContext.Roles.Where(m => m.UserID == id).ToList();
dbContext.Users.Remove(user[0]);
dbContext.Roles.Remove(role[0]);
dbContext.SaveChanges();
dbContext.Dispose();
}
return(RedirectToAction("Index"));
}
public ActionResult SetProject(string username, string projectName)
{
Student.Models.ApplicationDbContext dbContext = Student.Models.ApplicationDbContext.Create();
List <Student.Models.User> user = dbContext.Users.Where(m => m.Username == username).ToList();
List <Student.Models.Project> project = dbContext.Projects.Where(m => m.Name == projectName).ToList();
Student.Models.Users_Projects users_projects = new Student.Models.Users_Projects();
if (user.Count() != 0 && project.Count() != 0)
{
users_projects.UserID = user[0].ID;
users_projects.ProjectID = project[0].ID;
users_projects.Mark = 0;
dbContext.UsersProjects.Add(users_projects);
dbContext.SaveChanges();
}
dbContext.Dispose();
return(RedirectToAction("Index"));
}
public ActionResult GiveMark(int mark, int ID)
{
Student.Models.ApplicationDbContext db = Student.Models.ApplicationDbContext.Create();
var uprj = db.UsersProjects.SingleOrDefault(up => up.UsersProjectsID == ID);
uprj.Mark = mark;
db.SaveChanges();
db.Dispose();
ViewBag.ID = ID;
return(View("_ViewAssigment"));
}
public ActionResult AddUser(string username, string password, string firstName, string lastName, long cnp, string email, string role)
{
Student.Models.ApplicationDbContext dbContext = Student.Models.ApplicationDbContext.Create();
Student.Models.User userModel = new Student.Models.User();
Student.Models.UserRole roleModel = new Student.Models.UserRole();
if (dbContext.Users.Where(m => m.Username == username).ToList().Count > 0)
{
TempData["Error"] = "Username already exists!";
return(RedirectToAction("Index"));
}
List <Student.Models.User> list = dbContext.Users.ToList();
userModel.Username = username;
userModel.Password = password;
userModel.FirstName = firstName;
userModel.LastName = lastName;
userModel.CNP = cnp;
userModel.Email = email;
roleModel.UserID = userModel.ID;
if (role == "Student")
{
roleModel.Role = Student.Models.UserRole.roles.student;
}
else if (role == "Professor")
{
roleModel.Role = Student.Models.UserRole.roles.professor;
}
else
{
roleModel.Role = Student.Models.UserRole.roles.administrator;
}
dbContext.Users.Add(userModel);
dbContext.Roles.Add(roleModel);
dbContext.SaveChanges();
dbContext.Dispose();
return(RedirectToAction("Index"));
}
public ActionResult SaveInformation(string description, DateTime deadline, int ID)
{
Student.Models.ApplicationDbContext dbContext = Student.Models.ApplicationDbContext.Create();
var project = dbContext.Projects.SingleOrDefault(m => m.ID == ID);
project.Description = description;
project.Deadline = deadline;
dbContext.SaveChanges();
dbContext.Dispose();
ViewBag.ID = ID;
return(View("_ViewProject"));
}
public ActionResult SubmitComment(string comment, int userID, int ID)
{
Student.Models.ApplicationDbContext dbContext = Student.Models.ApplicationDbContext.Create();
Student.Models.Users_Projects_Comments conversation = new Student.Models.Users_Projects_Comments();
conversation.Comment = comment;
conversation.UserID = userID;
conversation.UsersProjectsID = ID;
dbContext.UsersProjectsComments.Add(conversation);
dbContext.SaveChanges();
dbContext.Dispose();
ViewBag.ID = ID;
return(View("_ViewAssigment"));
}
public ActionResult DeleteProject(string projectName)
{
Student.Models.ApplicationDbContext dbContext = Student.Models.ApplicationDbContext.Create();
List <Student.Models.Project> project = dbContext.Projects.Where(m => m.Name == projectName).ToList();
if (project.Count() != 0)
{
dbContext.Projects.Remove(project[0]);
dbContext.SaveChanges();
dbContext.Dispose();
}
return(RedirectToAction("Index"));
}
public void LoginFailedTest()
{
var appDataDir = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "C:\\Users\\Claudiu Sirbu\\source\\repos\\SE\\Student\\App_Data");
AppDomain.CurrentDomain.SetData("DataDirectory", appDataDir);
AccountController accountController = new AccountController();
ManagementController managementController = new ManagementController();
managementController.AddUser("stoe", "password", "stoenica", "robert", 1960718162021, "*****@*****.**", "admin");
var result = accountController.Login("stoe2", "password") as ViewResult;
Assert.True(result != null);
Student.Models.ApplicationDbContext dbContext = Models.ApplicationDbContext.Create();
List <Student.Models.User> list = dbContext.Users.Where(m => m.Username == "stoe").ToList();
var uid = list[0].ID;
var role = dbContext.Roles.Where(r => r.UserID == uid).ToList()[0];
dbContext.Roles.Remove(role);
dbContext.Users.Remove(list[0]);
dbContext.SaveChanges();
dbContext.Dispose();
}
