/// <summary>
/// Adds a project by current user username to the Db. Adds a default empty index file to the Db.
/// Adds current user as owner of the new project to the Db.
/// </summary>
/// <param name="model">'CreateProjectViewModel'</param>
/// <param name="ownerName">Owner Name</param>
public void addProject(CreateProjectViewModel model, string ownerName)
{
Project newProject = new Project();
newProject._projectName = model._projectName;
newProject._projectFileTypeId = model._projectTypeId;
_db._projects.Add(newProject);
_db.SaveChanges();
string extension = _db._fileTypes.Where(x => x.ID == model._projectTypeId).SingleOrDefault()._extension;
string aceExtension = _db._fileTypes.Where(x => x.ID == model._projectTypeId).SingleOrDefault()._aceExtension;
string defaultData = _db._fileTypes.Where(x => x.ID == model._projectTypeId).SingleOrDefault()._initialCode;
ProjectFile defaultFile = new ProjectFile();
defaultFile._projectFileName = "index" + "." + extension;
defaultFile._projectFileType = "." + extension;
defaultFile._aceExtension = aceExtension;
defaultFile._projectFileData = defaultData;
defaultFile._projectID = _db._projects.OrderByDescending(p => p.ID)
.Select(p => p.ID).FirstOrDefault();
_db._projectFiles.Add(defaultFile);
_db.SaveChanges();
ProjectOwner owner = new ProjectOwner();
owner._projectID = defaultFile._projectID;
owner._userName = ownerName;
_db._projectOwners.Add(owner);
_db.SaveChanges();
}
/// <summary>
/// A function that deletes a specific milestone, also deletes it's
/// solutions and submissions
/// </summary>
public void deleteMilestone(Milestone milestone)
{
if (milestone != null)
{
List <Solution> solutions = (from s in db.Solutions where s.MilestoneID == milestone.ID select s).ToList();
List <Submission> submissions = (from s in db.Submission where s.MilestoneID == milestone.ID select s).ToList();
if (solutions.Count != 0)
{
IEnumerable <Solution> solutionsToDelete = solutions;
foreach (var item in solutionsToDelete)
{
db.Solutions.Remove(item);
}
db.SaveChanges();
}
if (submissions.Count != 0)
{
IEnumerable <Submission> submissionsToDelete = submissions;
foreach (var item in submissionsToDelete)
{
db.Submission.Remove(item);
}
db.SaveChanges();
}
Milestone milestoneToDelete = db.Milestones.Where(x => x.ID == milestone.ID).SingleOrDefault();
db.Milestones.Remove(milestoneToDelete);
db.SaveChanges();
}
}
//Creates a project with User withc specific username as owner. Returns false if fails, otherwise true
public bool CreateProject(CreateProjectViewModel NewCreateProject, string Username)
{
if (NewCreateProject == null || Username == "")
{
return(false);
}
var ProjectWithSameName = DB.Projects.Where(x => x.Owner.Username == Username &&
x.Name == NewCreateProject.Name).FirstOrDefault();
if (ProjectWithSameName != null) //If user has created a project with same name nothing is created and function returns false
{
return(false);
}
UserInfo Owner = DB.UsersInfo.Where(x => x.Username == Username).SingleOrDefault(); //User that is creating project
Project NewProject = new Project(); //The project that is being made, gets values from viewmodel
NewProject.Name = NewCreateProject.Name;
NewProject.Type = NewCreateProject.Type;
NewProject.Owner = Owner;
NewProject.ReadMe = FService.CreateReadMe(NewCreateProject.ReadMe); //New ReadMe created
NewProject.DateCreated = DateTime.Now;
NewProject.DateModified = DateTime.Now;
//If project is a web application more default files are made
if (NewProject.Type == "Web Application")
{
var Files = FService.CreateWebApplication(); //Gets a list of extra files
FileInProject FIProjectCSS = new FileInProject(); //connection between file and project is made
FIProjectCSS.FileProject = NewProject;
FIProjectCSS.ProjectFile = Files[0]; //css file
FileInProject FIProjectJS = new FileInProject(); //connection between file and project is made
FIProjectJS.FileProject = NewProject;
FIProjectJS.ProjectFile = Files[1]; //js file
DB.FilesInProjects.Add(FIProjectCSS); //added to database
DB.FilesInProjects.Add(FIProjectJS);
}
DB.Projects.Add(NewProject); //Project added to database
DB.SaveChanges();
//Connection between user creating and project is made
ProjectOwner POwner = new ProjectOwner();
POwner.Owner = Owner;
POwner.OwnerProject = NewProject;
//Connection between default file and project is made
FileInProject FIProject = new FileInProject();
FIProject.FileProject = NewProject;
FIProject.ProjectFile = FService.CreateDefaultFile(NewProject.Type); //default file is made
DB.ProjectOwners.Add(POwner); //connections added to database
DB.FilesInProjects.Add(FIProject);
DB.SaveChanges(); //changes saved and function returns true
return(true);
}
public void UpdateRatePost(Post p)
{
var result = (from posts in _db.Posts
where posts.Id == p.Id
select posts).SingleOrDefault();
result.Rating = p.Rating;
_db.SaveChanges();
}
//Add Course to db.Courses
public bool add(CreateCourseViewModel newCourse)
{
Course temp = new Course()
{
name = newCourse.name, description = newCourse.description
};
db.Courses.Add(temp);
return(Convert.ToBoolean(db.SaveChanges()));
}
public void UpdateUser(ApplicationUser a, Photo p)
{
var query = (from u in _db.Users
where u.Id == a.Id
select u).SingleOrDefault();
query.Photo = p;
_db.SaveChanges();
}
//Create link between User and Course
public bool createLink(string userID, int courseID, int roleID)
{
UsersInCourse uInC = new UsersInCourse()
{
userID = userID, courseID = courseID, roleID = roleID
};
db.UsersInCourse.Add(uInC);
return(Convert.ToBoolean(db.SaveChanges()));
}
/// <summary>
/// A function that connects a student to a course in the database
/// </summary>
public void ConnectStudents(string userID, int courseID)
{
Course_Student newStudent = new Course_Student
{
UserID = userID,
CourseID = courseID
};
db.CoursesStudents.Add(newStudent);
db.SaveChanges();
return;
}
/// <summary>
/// Add project file to the Db.
/// </summary>
/// <param name="model">'CreateProjectFileViewModel'</param>
public void addProjectFile(CreateProjectFileViewModel model)
{
ProjectFile newProjectFile = new ProjectFile();
newProjectFile._projectFileName = model._projectFileName + "." + model._projectFileType;
newProjectFile._projectFileData = model._projectFileData;
newProjectFile._projectFileType = "." + model._projectFileType;
newProjectFile._aceExtension = getAceExtensionByProjectId(model._projectID);
newProjectFile._projectID = model._projectID;
_db._projectFiles.Add(newProjectFile);
_db.SaveChanges();
}
//Adds a folder to a project
public void AddFolder(AddFolderViewModel Model)
{
Folder NewFolder = new Folder(); //A new folder is created
NewFolder.Name = Model.Name; //It gets Model's name and is added to Project with Model's ProjectID
NewFolder.ProjectStructure = DB.Projects.Where(x => x.ID == Model.ProjectID).FirstOrDefault();
NewFolder.FolderStructure = null; //It goes to root of project by default
NewFolder.DateCreated = DateTime.Now; //DateTime attributes are setted
NewFolder.DateModified = DateTime.Now;
NewFolder.ProjectStructure.DateModified = DateTime.Now; //Date modified resetted on project
DB.Folders.Add(NewFolder); //Added to database and saved
DB.SaveChanges();
}
public void UpdatePhotoPath(string photopath, ApplicationUser user)
{
var query = (from c in _db.Comments
where c.AuthorId == user.Id
select c);
foreach (var item in query)
{
item.AuthorPhotoFileName = photopath;
}
_db.SaveChanges();
}
public void UpdateEventList(EventList el, ApplicationUser user)
{
EventList t = getEventList(el.Id, user);
if (t != null)
{
t.Id = el.Id;
t.Event = el.Event;
t.JoinTime = el.JoinTime;
t.User = el.User;
_db.SaveChanges();
}
}
public void CreateGroup(string userId, Group groupName)
{
try
{
groupName.ownerId = userId;
groupName.timeCreated = System.DateTime.Now;
db.groups.Add(groupName);
db.SaveChanges();
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex.Message + Environment.NewLine + "Location of error: " + ex.Source +
Environment.NewLine + "StackTrace: " + Environment.NewLine + ex.StackTrace +
Environment.NewLine + "Time : " + DateTime.Now + Environment.NewLine);
}
}
public void createHandinAttempt(int assignmentId, string solution)
{
var currentUser = HttpContext.Current.User.Identity.GetUserId();
var assignmentSolution = (from assign in db.Assignments
where assign.ID == assignmentId
select assign.solution).FirstOrDefault();
var acceptedOrNot = "";
if (assignmentSolution == solution)
{
acceptedOrNot = "Accepted";
}
else
{
acceptedOrNot = "Not Accepted";
}
Solution sol = new Solution()
{
userID = currentUser, assignmentID = assignmentId, accepted = acceptedOrNot, handinDate = DateTime.Now, file = solution
};
db.Solutions.Add(sol);
db.SaveChanges();
getSolution(assignmentId);
return;
}
/// <summary>
/// Take data from 'ConctactLogViewModel' and save to Db table 'contactLog', if model is not valid return false.
/// </summary>
/// <param name="model">'ContactLogViewModel'</param>
/// <returns>bool</returns>
public bool addContactLog(ConctactLogViewModel model)
{
if (model._contactName != null || model._contactEmail != null || model._contactEmail != null) // FIXME::?
{
ContactLog contactLog = new ContactLog
{
_contactName = model._contactName,
_contactEmail = model._contactEmail,
_ContactMessage = model._contactMessage
};
_db._contacts.Add(contactLog);
_db.SaveChanges();
return(true);
}
return(false);
}
public void EditUser(UserInfo User) //Saves the changes of specific User in database
{
UserInfo ToEdit = db.UsersInfo.Find(User.ID);
ToEdit.Name = User.Name;
ToEdit.Email = User.Email;
ToEdit.Country = User.Country;
db.SaveChanges();
}
public void StalkUser(string userId, string stalkId)
{
try
{
if (!String.IsNullOrEmpty(userId) && !String.IsNullOrEmpty(stalkId))
{
var stalking = new Stalking();
stalking.userId = userId;
stalking.stalkedId = stalkId;
db.stalking.Add(stalking);
db.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex.Message + Environment.NewLine + "Location of error: " + ex.Source +
Environment.NewLine + "StackTrace: " + Environment.NewLine + ex.StackTrace +
Environment.NewLine + "Time : " + DateTime.Now + Environment.NewLine);
}
}
// Add assignment to db.assignments
public bool createAssignment(CreateAssignmentViewModel newAssignment)
{
Assignment temp = new Assignment()
{
name = newAssignment.name, solution = newAssignment.solution,
description = newAssignment.description, startDate = newAssignment.startDate,
endDate = newAssignment.endDate
};
db.Assignments.Add(temp);
db.SaveChanges();
AssignmentsInCourse link = new AssignmentsInCourse()
{
assignmentID = temp.ID, courseID = newAssignment.courseID
};
db.AssingmentInCourse.Add(link);
return(Convert.ToBoolean(db.SaveChanges()));
}
public bool AddFile(AddFilesViewModel Model)
{
var FileWithSameName = DB.FilesInProjects.Where(x => x.ProjectFile.Name == Model.Name &&
x.FileProject.ID == Model.ProjectID &&
x.ProjectFile.Type == Model.Type).FirstOrDefault();
if (FileWithSameName != null)
{
return(false);
}
// Make the file.
File NewFile = new File();
NewFile.Name = Model.Name;
NewFile.Type = Model.Type;
NewFile.Location = "//This is a new file";
NewFile.FolderStructure = null;
NewFile.DateCreated = DateTime.Now;
NewFile.DateModified = DateTime.Now;
// Add the connection.
FileInProject NewConnection = new FileInProject();
NewConnection.ProjectFile = NewFile;
Project TheProj = DB.Projects.Where(x => x.ID == Model.ProjectID).FirstOrDefault();
NewConnection.FileProject = TheProj;
// Adding to the database.
DB.Files.Add(NewFile);
DB.FilesInProjects.Add(NewConnection);
// If no changes are made to the database we return false.
if (DB.SaveChanges() == 0)
{
return(false);
}
return(true);
}
public void PostStatus(string userId, Status userStatus)
{
try
{
userStatus.userId = userId;
userStatus.timeCreated = System.DateTime.Now;
userStatus.fullName = (from p in db.profiles
where p.userID == userId
select p.name).SingleOrDefault();
if (!String.IsNullOrEmpty(userStatus.urlToPic))
{
userStatus.urlToPic = userStatus.urlToPic;
}
db.userStatuses.Add(userStatus);
db.SaveChanges();
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex.Message + Environment.NewLine + "Location of error: " + ex.Source +
Environment.NewLine + "StackTrace: " + Environment.NewLine + ex.StackTrace +
Environment.NewLine + "Time : " + DateTime.Now + Environment.NewLine);
}
}
public void ChangeProfilePicUrl(string userId, string url)
{
try
{
if (!String.IsNullOrEmpty(url))
{
var profile = (from p in db.profiles
where p.userID == userId
select p).SingleOrDefault();
profile.profilePicUrl = url;
db.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex.Message + Environment.NewLine + "Location of error: " + ex.Source +
Environment.NewLine + "StackTrace: " + Environment.NewLine + ex.StackTrace +
Environment.NewLine + "Time : " + DateTime.Now + Environment.NewLine);
}
}
/// <summary>
/// Adds a submission to the database from a student.
/// </summary>
public void AddSubmission(SubmissionViewModel sub)
{
if (sub == null)
{
return;
}
Submission NewSub = new Submission();
NewSub.AssignmentID = sub.AssignmentID;
NewSub.CourseID = sub.CourseID;
NewSub.Error = sub.Error;
NewSub.FilePath = sub.FilePath;
NewSub.Grade = sub.Grade;
NewSub.MilestoneID = sub.MilestoneID;
NewSub.Output = sub.Output;
NewSub.Status = sub.Status;
NewSub.UserName = sub.UserName;
NewSub.DrMemory = sub.DrMemory;
NewSub.Comment = sub.Comment;
_db.Submission.Add(NewSub);
_db.SaveChanges();
}
// Creates a project with the attributes from the CreateProjectViewModel that gets sent in
public void CreateProject(CreateProjectViewModel projectVM)
{
Project project = new Project
{
Name = projectVM.Name,
Type = projectVM.Type,
OwnerID = projectVM.OwnerID,
};
_db.Projects.Add(project);
_db.SaveChanges();
CreateFileViewModel file = new CreateFileViewModel
{
Name = "index",
Type = project.Type,
ProjectID = project.ID
};
CreateFile(file);
}
public void AddGroup(Group g)
{
_db.Groups.Add(g);
_db.SaveChanges();
}
public void SendFriendRequest(FriendRequest friendRequest)
{
_dbContext.FriendRequests.Add(friendRequest);
_dbContext.SaveChanges();
}
//Add & remove
public void AddPhoto(Photo s)
{
_db.Photos.Add(s);
_db.SaveChanges();
}
public void AddGroupToList(GroupList gl)
{
_db.GroupList.Add(gl);
_db.SaveChanges();
}
/// <summary>
/// Adds a Group to the database
/// </summary>
/// <param name="group"></param>
public void CreateGroup(Group group)
{
_dbContext.Groups.Add(group);
_dbContext.SaveChanges();
}
public void AddPost(Post post)
{
_dbContext.Posts.Add(post);
_dbContext.SaveChanges();
}
public void AddEvent(Event e)
{
_db.Events.Add(e);
_db.SaveChanges();
}