Exemple #1
0
        public IActionResult Lost(UpdateUser model)
        {
            // Gets the user from the database

            var user = UserHelper.GetUser(model.Username, OrganisationHelper.GetOrganisationID(HttpContext.Session));

            // Get the userID of the person making this request
            var userid = UserHelper.GetUserId(HttpContext.Session);

            // Check he has permission to be this
            if (user.OrganisationID == UserHelper.GetUser(userid).OrganisationID&& UserHelper.UserInRole(userid, UserHelper.ROLE_ADMIN))
            {
                //Update the password and pass it to the database.
                user.Password = Hasher.Hash(model.Password);
                DatabaseConnector.Update(model.Password);
                DatabaseConnector.PushChanges();
            }
            return(Unauthorized());
        }
        public IActionResult Create(CreateGroupViewModel model)
        {
            // Checks that the model is valid
            if (!ModelState.IsValid)
            {
                model.AccessTypes = DatabaseConnector.Get <AccessTypes>();
                model.Users       = DatabaseConnector.GetWhere <Users>("OrganisationID=" + OrganisationHelper.GetOrganisationID(HttpContext.Session));
                return(View(model));
            }

            // Creates the new group with the info
            Groups newGroup = new Groups()
            {
                Group_Name = model.GroupName,
                CreatedBy  = UserHelper.GetUserId(HttpContext.Session),
                AccessType = model.AccessType
            };

            // Saves the group to the database and gets it id.
            newGroup.GroupID = DatabaseConnector.AddGroup(newGroup);

            // Adds all the wanted users to the group.
            if (model.GroupUsers != null)
            {
                foreach (var usr in model.GroupUsers)
                {
                    // Now using check boxes we need to make sure they are selected.
                    if (usr.Selected)
                    {
                        GroupUsers user = new GroupUsers()
                        {
                            GroupID = newGroup.GroupID,
                            UserID  = usr.UserID
                        };
                        DatabaseConnector.AddGroupUser(user);
                    }
                }
                DatabaseConnector.PushChanges();
            }

            // Returns a serilaised object if the page is going to closed
            if (model.CloseAfter)
            {
                return(new JsonResult(newGroup.GroupID + ";" + newGroup.Group_Name));
            }

            // Redirects to the list of groups.
            return(RedirectToAction("Index", "Groups"));
        }
Exemple #3
0
        /// <summary>
        /// This method parses either a CSV
        /// or a Excel(xls(x)) file into the database and is able to add
        /// new users based on the information within those files.
        /// </summary>
        /// <param name="item"></param>
        /// <returns></returns>
        private List <string> ParseFile(KeyValuePair <int, FileInfo> item)
        {
            // Checks whether the gile is an Excel file
            if (item.Value.Extension.ToLower().Contains("xls"))
            {
                try
                {
                    //Using Excel convert and save the file as a csv
                    Microsoft.Office.Interop.Excel.Application app        = new Microsoft.Office.Interop.Excel.ApplicationClass();
                    Microsoft.Office.Interop.Excel.Workbook    wbWorkbook = app.Workbooks.Open(item.Value.FullName);
                    wbWorkbook.SaveAs(Path.Combine(_env.WebRootPath, "lib/Excel/" + item.Value.Name) + ".csv", Microsoft.Office.Interop.Excel.XlFileFormat.xlCSV);
                    wbWorkbook.Close();

                    // Save the CSV and replace the file info object.
                    item = new KeyValuePair <int, FileInfo>(item.Key, new FileInfo(Path.Combine(_env.WebRootPath, "lib/Excel/" + item.Value.Name) + ".csv"));
                }
                // Error would occur if the file was in an ureadable format or did not upload correctly.
                catch (Exception)
                {
                    // Tell the user what went wrong with this file.
                    return(new List <string>()
                    {
                        "Failed to convert workbook into CSV"
                    });
                }
            }

            // Check if the item is listed as a CSV
            if (item.Value.Extension.ToLower().Contains("csv"))
            {
                // Setup a list of possible error or information
                List <string> Information = new List <string>();

                //Open the file in steam.
                using (var stream = new StreamReader(new FileStream(item.Value.FullName, FileMode.Open)))
                {
                    int    userID = UserHelper.GetUserId(HttpContext.Session);
                    string line   = "";
                    // Read the fill until you get to the first line;
                    while (string.IsNullOrEmpty(line = stream.ReadLine()))
                    {
                    }
                    // find the positions of the headers by spliting.
                    string[] headers = line.ToLower().Split(',', StringSplitOptions.RemoveEmptyEntries);

                    // Find the positions of the headers in the list using my own extention method.
                    int uname    = headers.PositionOf("username"),
                        password = headers.PositionOf("password"),
                        fname    = headers.PositionOf("firstname"),
                        lname    = headers.PositionOf("lastname");

                    // Make sure that all the required headers exist.
                    bool error    = false;
                    var  errortxt = "Could not find column: ";
                    if (uname == -1)
                    {
                        errortxt += "username, ";
                        error     = true;
                    }
                    if (password == -1)
                    {
                        errortxt += "password, ";
                        error     = true;
                    }
                    if (fname == -1)
                    {
                        errortxt += "fname, ";
                        error     = true;
                    }
                    if (lname == -1)
                    {
                        errortxt += "lastname, ";
                        error     = true;
                    }

                    // Return if their was an error
                    if (error)
                    {
                        Information.Add(errortxt);
                        return(Information);
                    }

                    // Find the possible positions of the multiple headers.
                    var roles  = headers.PositionsOf("role");
                    var groups = headers.PositionsOf("group");
                    int i      = 1;
                    // Read each line to the end of the file.
                    while (!stream.EndOfStream)
                    {
                        // Get the new line and split it into components.
                        line = stream.ReadLine();
                        var items = line.Split(',');
                        try
                        {
                            // Try creating the user with the detials entered above.
                            string add = "";
                            var    usr = UserHelper.CreateNewUser(UserHelper.GetUserId(HttpContext.Session), items[uname], items[password], items[fname], items[lname]);
                            if (usr.Username == UserHelper.USER_ERROR)
                            {
                                // The the user that the user failed to be added.
                                Information.Add("Line: " + i + " User: "******" Failed to add user. Username probably not unique!");
                            }
                            else
                            {
                                // the user was added, tell them.
                                add = $"Added user: {items[fname]} {items[lname]}, Username: {items[uname]}";

                                // Go through each possible position of roles in this file.
                                foreach (int role in roles)
                                {
                                    try
                                    {
                                        // Check to see their is a role their
                                        if (!string.IsNullOrEmpty(items[role]))
                                        {
                                            // Try to give the user the requested role
                                            try
                                            {
                                                UserHelper.GiveRole(usr.UserID, items[role]);
                                                add += $" role: {items[role]}";
                                            }
                                            // The role was not found if this errors.
                                            catch (KeyNotFoundException)
                                            {
                                                Information.Add("Failed: Unable to find role of name: " + items[role]
                                                                + ". Please make sure the user is in one of the following roles - Teacher, Student, Admin - and that it is spelt correctly");
                                            }
                                            DatabaseConnector.PushChanges();
                                        }
                                    }
                                    catch (IndexOutOfRangeException)
                                    {
                                        // Couuld not file that role if there is an error
                                        Information.Add("Line: " + i + " User: "******" Failed to find role at position: " + role + ".");
                                    }
                                }
                                // go through all the groups that the user was requested to be added to.
                                foreach (var group in groups)
                                {
                                    // Check a group exists at that location.
                                    if (!string.IsNullOrEmpty(items[group]))
                                    {
                                        // Attempt to get the groupID of that group
                                        int GroupID = DatabaseConnector.GetGroup(items[group], OrganisationHelper.GetOrganisationID(HttpContext.Session));
                                        //If the group doesn't exist create a new one
                                        if (GroupID == -1)
                                        {
                                            // Creates the new groups which is accessible by everyone
                                            // and was created by the admin uploading the users.
                                            Groups newGroup = new Groups()
                                            {
                                                AccessType = 1,
                                                CreatedBy  = UserHelper.GetUserId(HttpContext.Session),
                                                Group_Name = items[group]
                                            };
                                            // Get the new ID of the group that the database returns
                                            newGroup.GroupID = DatabaseConnector.AddGroup(newGroup);
                                            // Push the group and user changes.
                                            DatabaseConnector.PushChanges();

                                            // Tell the user that you created a new group.
                                            Information.Add("Line: " + i + " User: "******"created new group: " + items[group] + ".");

                                            // Then add the user to the group you just created.
                                            GroupUsers usrAdd = new GroupUsers()
                                            {
                                                UserID  = usr.UserID,
                                                GroupID = newGroup.GroupID
                                            };
                                            DatabaseConnector.AddGroupUser(usrAdd);
                                        }
                                        // If the group already exists
                                        else
                                        {
                                            // Again add the user too that group
                                            GroupUsers usrAdd = new GroupUsers()
                                            {
                                                UserID  = usr.UserID,
                                                GroupID = GroupID
                                            };
                                            // add this to the database and tell the parser.
                                            DatabaseConnector.AddGroupUser(usrAdd);
                                            Information.Add("Line: " + i + " User: "******" added user to group: " + items[group] + ".");
                                        }
                                    }
                                    else
                                    {
                                        Information.Add("Line: " + i + " User: "******" group column blank: " + group + ".");
                                    }
                                }
                            }
                            Information.Add(add);
                        }
                        // Catches the eror that you cannot find the item. I.E. the person who created the CSV formatted it wrong.
                        catch (IndexOutOfRangeException)
                        {
                            Information.Add("Line: " + i + " Failed to find index of item");
                        }
                        i++;
                    }
                }
                // Return the information from the parse
                return(Information);
            }
            // Return if you were unable to read the inputted files as a CSV.
            return(new List <string>
            {
                "Could not be read as a CSV file"
            });
        }
        /// <summary>
        /// Used to create a group for the user.
        /// </summary>
        /// <param name="closeAfter">If the page should close after we are done.</param>
        /// <returns></returns>
        public IActionResult Create(bool closeAfter)
        {
            var model = new CreateGroupViewModel();

            model.AccessTypes = DatabaseConnector.Get <AccessTypes>();
            model.Users       = DatabaseConnector.GetWhere <Users>("OrganisationID=" + OrganisationHelper.GetOrganisationID(HttpContext.Session));
            model.CloseAfter  = closeAfter;

            return(View(model));
        }