Exemplo n.º 1
0
        private GeneralFormViewModel GetFormViewModel()
        {
            var levels     = _context.Ref_Level.ToList();
            var faculties  = _context.Ref_Faculty.ToList();
            var deliveries = _context.Ref_Delivery.ToList();

            var departments = _context.Ref_Department.ToList();
            List <SelectListItem> listSelectListInitDepts   = new List <SelectListItem>();
            List <SelectListItem> listSelectListServDepts   = new List <SelectListItem>();
            List <SelectListItem> listSelectListCollabDepts = new List <SelectListItem>();

            foreach (Ref_Department dept in departments)
            {
                SelectListItem selectList = new SelectListItem()
                {
                    Text  = dept.Name,
                    Value = dept.Id.ToString(),
                };
                listSelectListInitDepts.Add(selectList);
                listSelectListServDepts.Add(selectList);
                listSelectListCollabDepts.Add(selectList);
            }

            var viewModel = new GeneralFormViewModel
            {
                Levels      = levels,
                Faculties   = faculties,
                Deliveries  = deliveries,
                InitDepts   = listSelectListInitDepts,
                ServDepts   = listSelectListServDepts,
                CollabDepts = listSelectListCollabDepts,
            };

            return(viewModel);
        }
Exemplo n.º 2
0
        private GeneralFormViewModel GetFormViewModel(int?pid)
        {
            ApplicationDbContext db = new ApplicationDbContext();
            var     proposal        = _context.Proposals.SingleOrDefault(m => m.Id == pid);
            General general         = null;

            if (pid != null)
            {
                general = proposal.General;
            }

            var levels     = _context.Ref_Level.ToList();
            var faculties  = _context.Ref_Faculty.ToList();
            var deliveries = _context.Ref_Delivery.ToList();

            var departments = _context.Ref_Department.ToList();
            List <SelectListItem> listSelectListInitDepts   = new List <SelectListItem>();
            List <SelectListItem> listSelectListServDepts   = new List <SelectListItem>();
            List <SelectListItem> listSelectListCollabDepts = new List <SelectListItem>();
            List <SelectListItem> listSelectListProposers   = new List <SelectListItem>();
            List <SelectListItem> listSelectListShared      = new List <SelectListItem>();

            // lecturers, deans, hods
            //string umStaff = "Select * from AspNetUsers users Inner Join AspNetUserRoles roles On users.Id = roles.UserId and roles.RoleId in ('2', '4', '5')";
            string umStaff = "Select Distinct * From AspNetUsers Where Id in(Select users.Id from AspNetUsers users Inner Join AspNetUserRoles roles On(users.Id = roles.UserId and roles.RoleId in ('2', '4', '5')))";
            var    users   = db.Database.SqlQuery <ApplicationUser>(umStaff).ToList();

            if (pid == null)
            {
                foreach (ApplicationUser user in users)
                {
                    SelectListItem selectList = new SelectListItem()
                    {
                        Text  = user.Email,
                        Value = user.Id,
                    };
                    listSelectListProposers.Add(selectList);
                }
            }
            else
            {
                var sharedIds = _context.Database.SqlQuery <string>("Select UserId From Shared_General Where GeneralId = " + general.Id).ToList();

                string umStaffLeft = "Select Distinct * From AspNetUsers Where Id in(Select users.Id from AspNetUsers users Inner Join AspNetUserRoles roles On users.Id = roles.UserId and roles.RoleId in ('2', '4', '5') and users.Id Not In('" + string.Join("','", sharedIds.ToArray()) + "'))";

                var usersLeft = db.Database.SqlQuery <ApplicationUser>(umStaffLeft).ToList();
                foreach (ApplicationUser user in usersLeft)
                {
                    SelectListItem selectList = new SelectListItem()
                    {
                        Text  = user.Email,
                        Value = user.Id,
                    };
                    listSelectListProposers.Add(selectList);
                }
            }


            if (pid != null)
            {
                var proposersIds = _context.Database.SqlQuery <string>("Select UserId From Proposer_General Where GeneralId = " + general.Id).ToList();

                string umStaffLeft = "Select Distinct * From AspNetUsers Where Id in(Select users.Id from AspNetUsers users Inner Join AspNetUserRoles roles On users.Id = roles.UserId and roles.RoleId in ('2', '4', '5') and users.Id Not In('" + string.Join("','", proposersIds.ToArray()) + "'))";

                var usersLeft = db.Database.SqlQuery <ApplicationUser>(umStaffLeft).ToList();
                foreach (ApplicationUser user in usersLeft)
                {
                    SelectListItem selectList = new SelectListItem()
                    {
                        Text  = user.Email,
                        Value = user.Id,
                    };
                    listSelectListShared.Add(selectList);
                }
            }


            foreach (Ref_Department dept in departments)
            {
                var            deptInDb   = _context.Ref_Department.SingleOrDefault(m => m.Id == dept.Id);
                SelectListItem selectList = new SelectListItem()
                {
                    Text  = dept.Name,
                    Value = dept.Id.ToString(),
                };

                if (pid != null)
                {
                    var dg = _context.Department_General.SingleOrDefault(m => m.DepartmentId == dept.Id && m.GeneralId == general.Id);
                    if (dg != null)
                    {
                        if (dg.Type == 1)
                        {
                            listSelectListInitDepts.Add(selectList);
                        }
                    }
                    else
                    {
                        listSelectListInitDepts.Add(selectList);
                    }
                }
                else
                {
                    listSelectListInitDepts.Add(selectList);
                }

                if (pid != null)
                {
                    var dg = _context.Department_General.SingleOrDefault(m => m.DepartmentId == dept.Id && m.GeneralId == general.Id);
                    if (dg != null)
                    {
                        if (dg.Type == 2)
                        {
                            listSelectListCollabDepts.Add(selectList);
                        }
                    }
                    else
                    {
                        listSelectListCollabDepts.Add(selectList);
                    }
                }
                else
                {
                    listSelectListCollabDepts.Add(selectList);
                }

                if (pid != null)
                {
                    var stm = dept.GetServStatement((int)pid);
                    if (stm != null)
                    {
                        if (stm.Selection == true)
                        {
                            continue;
                        }
                        else
                        {
                            listSelectListServDepts.Add(selectList);
                        }
                    }
                    else
                    {
                        var dg = _context.Department_General.SingleOrDefault(m => m.DepartmentId == dept.Id && m.GeneralId == general.Id);
                        if (dg != null)
                        {
                            if (dg.Type == 3)
                            {
                                listSelectListServDepts.Add(selectList);
                            }
                        }
                        else
                        {
                            listSelectListServDepts.Add(selectList);
                        }
                    }
                }
                else
                {
                    listSelectListServDepts.Add(selectList);
                }
            }

            var viewModel = new GeneralFormViewModel
            {
                Levels        = levels,
                Faculties     = faculties,
                Deliveries    = deliveries,
                InitDepts     = listSelectListInitDepts,
                ServDepts     = listSelectListServDepts,
                CollabDepts   = listSelectListCollabDepts,
                Proposers     = listSelectListProposers,
                Shared        = listSelectListShared,
                SelectedTypes = new List <string>()
            };

            return(viewModel);
        }
Exemplo n.º 3
0
        public ActionResult Save(GeneralFormViewModel vm)
        {
            var general = vm.General;
            List <Department_General> removed = new List <Department_General>();
            List <Department_General> added   = new List <Department_General>();

            if (!ModelState.IsValid)
            {
                //foreach (ModelState modelState in ViewData.ModelState.Values)
                //{
                //    foreach (ModelError error in modelState.Errors)
                //    {
                //        return Content(error.ErrorMessage);
                //    }
                //}
                return(View("Form", general));
            }

            if (general.Id == 0)
            {
                Thread t = new Thread();
                _context.Threads.Add(t);
                general.Thread = t;
                _context.Generals.Add(general);
                var proposal = new Proposal();
                proposal.GeneralId   = general.Id;
                proposal.CreatedOn   = DateTime.Now;
                proposal.CreatedBy   = User.Identity.GetUserId();
                proposal.IsInEdit    = true;
                proposal.UserEditing = User.Identity.GetUserId();
                _context.Proposals.Add(proposal);
            }
            else
            {
                var proposal = _context.Proposals.SingleOrDefault(m => m.GeneralId == general.Id);
                if (proposal == null)
                {
                    return(HttpNotFound());
                }
                if (!proposal.IsEditable(User.Identity.GetUserId()))
                {
                    return(HttpNotFound());
                }
                if (proposal.Submitted)
                {
                    return(Content("Proposal already submitted"));
                }
                var changedLevel = false;

                var generalInDb = _context.Generals.SingleOrDefault(m => m.Id == general.Id);
                if (generalInDb.LevelId != general.LevelId)
                {
                    changedLevel = true;
                }


                generalInDb.Title             = general.Title;
                generalInDb.LevelId           = general.LevelId;
                generalInDb.Ref_Level         = _context.Ref_Level.SingleOrDefault(m => m.Id == general.LevelId);
                generalInDb.AreasStudy        = general.AreasStudy;
                generalInDb.FacultyId         = general.FacultyId;
                generalInDb.Ref_Faculty       = general.Ref_Faculty;
                generalInDb.DeliveryId        = general.DeliveryId;
                generalInDb.Ref_Delivery      = _context.Ref_Delivery.SingleOrDefault(m => m.Id == general.DeliveryId);
                generalInDb.DurationSemesters = general.DurationSemesters;
                generalInDb.FirstDateIntake   = general.FirstDateIntake;
                generalInDb.ExpectedStudents  = general.ExpectedStudents;
                if (general.MaxStudents == null)
                {
                    generalInDb.CappingReason = null;
                }
                else
                {
                    generalInDb.CappingReason = general.CappingReason;
                }
                generalInDb.MaxStudents = general.MaxStudents;

                //remove departments, to be added again later
                var toRemove = _context.Department_General.Where(m => m.GeneralId == general.Id).ToList();

                //remove proposers and shared, to be added again later
                var proposersToRemove = _context.Proposer_General.Where(m => m.GeneralId == general.Id).ToList();
                var sharedToRemove    = _context.Shared_General.Where(m => m.GeneralId == general.Id).ToList();
                var typesToRemove     = _context.Type_General.Where(m => m.GeneralId == general.Id).ToList();

                foreach (Department_General dg in toRemove.ToList())
                {
                    if (dg.Type == 3)
                    {
                        //servicing
                        var dept = dg.Ref_Department;
                        //does not remove if approval accepted
                        var stm = dept.GetServStatement(proposal.Id);
                        if (stm != null)
                        {
                            if (stm.Selection == true)
                            {
                                toRemove.Remove(dg);
                            }
                        }
                    }
                }
                removed = toRemove;
                _context.Department_General.RemoveRange(toRemove);
                _context.Proposer_General.RemoveRange(proposersToRemove);
                _context.Shared_General.RemoveRange(sharedToRemove);
                _context.Type_General.RemoveRange(typesToRemove);

                _context.SaveChanges();

                //if level changed -> change existing year_units
                if (changedLevel)
                {
                    if (general.LevelId == 2)
                    {
                        if (proposal.ProgrammeRationale != null)
                        {
                            if (proposal.ProgrammeRationale.TentativeP != null)
                            {
                                var tentative = proposal.ProgrammeRationale.TentativeP;
                                var years     = tentative.GetYears();
                                foreach (Year y in years)
                                {
                                    var yus = y.GetYearUnits();
                                    foreach (Year_Unit yu in yus)
                                    {
                                        var yuInDb = _context.Year_Unit.Single(m => m.Id == yu.Id);
                                        yuInDb.Compensating       = 0;
                                        yuInDb.CompensatingReason = "Compensated passes are not applicable for PG courses.";
                                    }
                                }
                            }
                        }
                    }
                    else
                    {
                        //switch reasons to null if they were PG default
                        if (proposal.ProgrammeRationale != null)
                        {
                            if (proposal.ProgrammeRationale.TentativeP != null)
                            {
                                var tentative = proposal.ProgrammeRationale.TentativeP;
                                var years     = tentative.GetYears();
                                foreach (Year y in years)
                                {
                                    var yus = y.GetYearUnits();
                                    foreach (Year_Unit yu in yus)
                                    {
                                        var yuInDb = _context.Year_Unit.Single(m => m.Id == yu.Id);
                                        if (yuInDb.Compensating == 0 && yuInDb.CompensatingReason == "Compensated passes are not applicable for PG courses.")
                                        {
                                            yuInDb.CompensatingReason = null;
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }

            _context.SaveChanges();

            if (vm.SelectedInitDepts != null)
            {
                foreach (string s in vm.SelectedInitDepts)
                {
                    var department        = _context.Ref_Department.SingleOrDefault(m => m.Id.ToString() == s);
                    Department_General dg = new Department_General(department.Id, general.Id, 1);
                    var existing          = _context.Department_General.Where(m => m.DepartmentId == department.Id && m.GeneralId == general.Id).ToList();
                    if (existing.Count == 0)
                    {
                        _context.Department_General.Add(dg);
                        added.Add(dg);
                    }
                }
            }
            _context.SaveChanges();
            if (vm.SelectedCollabDepts != null)
            {
                foreach (string s in vm.SelectedCollabDepts)
                {
                    var department        = _context.Ref_Department.SingleOrDefault(m => m.Id.ToString() == s);
                    Department_General dg = new Department_General(department.Id, general.Id, 2);
                    var existing          = _context.Department_General.Where(m => m.DepartmentId == department.Id && m.GeneralId == general.Id).ToList();
                    if (existing.Count == 0)
                    {
                        _context.Department_General.Add(dg);
                        added.Add(dg);
                    }
                }
            }
            _context.SaveChanges();
            if (vm.SelectedServDepts != null)
            {
                foreach (string s in vm.SelectedServDepts)
                {
                    var department        = _context.Ref_Department.SingleOrDefault(m => m.Id.ToString() == s);
                    Department_General dg = new Department_General(department.Id, general.Id, 3);
                    var existing          = _context.Department_General.Where(m => m.DepartmentId == department.Id && m.GeneralId == general.Id).ToList();
                    if (existing.Count == 0)
                    {
                        _context.Department_General.Add(dg);
                        added.Add(dg);
                    }
                }
            }

            if (vm.SelectedTypes != null)
            {
                foreach (string s in vm.SelectedTypes)
                {
                    var          type = _context.Ref_Type.SingleOrDefault(m => m.Id.ToString() == s);
                    Type_General tg   = new Type_General(type.Id, general.Id);
                    _context.Type_General.Add(tg);
                }
            }

            List <int> removedDepIds = new List <int>();

            foreach (Department_General dg in removed)
            {
                var f = false;
                foreach (Department_General adg in added)
                {
                    if ((dg.DepartmentId == adg.DepartmentId) && (dg.GeneralId == adg.GeneralId))
                    {
                        f = true;
                    }
                }
                if (f == true)
                {
                    continue;
                }
                else
                {
                    removedDepIds.Add(dg.DepartmentId);
                    //return Content("removed " + dg.DepartmentId);
                }
            }

            if (vm.SelectedProposers != null)
            {
                ApplicationDbContext adb = new ApplicationDbContext();
                foreach (string s in vm.SelectedProposers)
                {
                    var user            = adb.Database.SqlQuery <ApplicationUser>("Select * from dbo.AspNetUsers Where Id = '" + s + "'").First();
                    Proposer_General pg = new Proposer_General(user.Id, general.Id);
                    _context.Proposer_General.Add(pg);
                }
            }

            if (vm.SelectedShared != null)
            {
                ApplicationDbContext adb = new ApplicationDbContext();
                foreach (string s in vm.SelectedShared)
                {
                    var            user = adb.Database.SqlQuery <ApplicationUser>("Select * from dbo.AspNetUsers Where Id = '" + s + "'").First();
                    Shared_General sg   = new Shared_General(user.Id, general.Id);
                    _context.Shared_General.Add(sg);
                }
            }

            _context.SaveChanges();
            var jump = Request["jump"];
            var prop = general.GetProposal();
            var pr   = _context.ProgrammeRationales.SingleOrDefault(m => m.Id == prop.ProgrammeRationaleId);

            if (pr != null)
            {
                if (pr.TentativePsId != null)
                {
                    var tentativePs = pr.TentativeP;
                    var years       = tentativePs.GetYears();
                    foreach (Year year in years)
                    {
                        var year_units = year.GetYearUnits();
                        foreach (Year_Unit yu in year_units)
                        {
                            if (removedDepIds.Contains(yu.GetUnit().DepartmentId))
                            {
                                var yuInDb = _context.Year_Unit.SingleOrDefault(m => m.Id == yu.Id);
                                _context.Year_Unit.Remove(yuInDb);
                            }
                        }
                    }
                }
            }


            _context.Database.ExecuteSqlCommand("Update dbo.GeneralHistory Set EditedBy = '" + User.Identity.GetUserId() + "' Where GeneralId = " + general.Id + " and EditedBy is null");
            _context.SaveChanges();
            switch (jump)
            {
            case "0": {
                // Save pressed -> return form
                return(RedirectToAction("Edit", "General", new { id = general.Id }));
            }

            case "1":
            {
                // Next pressed -> return next page
                return(RedirectToAction("Jump", "ProgrammeRationale", new { id = prop.Id }));
            }

            case "2":
            {
                // Save and exit
                return(RedirectToAction("CloseEdit", "Proposal", new { id = prop.Id }));
            }

            case "A":
            {
                // A pressed -> go to Section A
                return(RedirectToAction("Edit", "General", new { id = general.Id }));
            }

            case "B":
            {
                // B pressed -> go to Section B
                return(RedirectToAction("Jump", "ProgrammeRationale", new { id = prop.Id }));
            }

            case "C":
            {
                // C pressed -> go to Section C
                return(RedirectToAction("Jump", "ExternalReview", new { id = prop.Id }));
            }

            case "D":
            {
                // D pressed -> go to Section D
                return(RedirectToAction("Jump", "IncomeExpenditure", new { id = prop.Id }));
            }

            default:
            {
                return(RedirectToAction("Index", "Proposal"));
            }
            }
        }
Exemplo n.º 4
0
        public ActionResult Save(GeneralFormViewModel vm)
        {
            var general = vm.General;

            if (!ModelState.IsValid)
            {
                //foreach (ModelState modelState in ViewData.ModelState.Values)
                //{
                //    foreach (ModelError error in modelState.Errors)
                //    {
                //        return Content(error.ErrorMessage);
                //    }
                //}
                return(View("Form", general));
            }

            if (general.Id == 0)
            {
                _context.Generals.Add(general);
                var proposal = new Proposal();
                proposal.GeneralId = general.Id;
                proposal.CreatedOn = DateTime.Now;
                proposal.CreatedBy = "Andrea Naudi";
                _context.Proposals.Add(proposal);
            }
            else
            {
                var proposal = _context.Proposals.SingleOrDefault(m => m.GeneralId == general.Id);
                if (proposal == null)
                {
                    return(HttpNotFound());
                }
                if (proposal.Submitted)
                {
                    return(Content("Proposal already submitted"));
                }
                var generalInDb = _context.Generals.SingleOrDefault(m => m.Id == general.Id);
                generalInDb.Title             = general.Title;
                generalInDb.LevelId           = general.LevelId;
                generalInDb.Ref_Level         = _context.Ref_Level.SingleOrDefault(m => m.Id == general.LevelId);
                generalInDb.AreasStudy        = general.AreasStudy;
                generalInDb.FacultyId         = general.FacultyId;
                generalInDb.Ref_Faculty       = general.Ref_Faculty;
                generalInDb.DeliveryId        = general.DeliveryId;
                generalInDb.Ref_Delivery      = _context.Ref_Delivery.SingleOrDefault(m => m.Id == general.DeliveryId);
                generalInDb.DurationSemesters = general.DurationSemesters;
                generalInDb.FirstDateIntake   = general.FirstDateIntake;
                generalInDb.ExpectedStudents  = general.ExpectedStudents;
                generalInDb.MaxStudents       = general.MaxStudents;
                generalInDb.CappingReason     = general.CappingReason;

                //remove departments, to be added again later
                var toRemove = _context.Department_General.Where(m => m.GeneralId == general.Id);
                _context.Department_General.RemoveRange(toRemove);
            }

            _context.SaveChanges();
            if (vm.SelectedInitDepts != null)
            {
                foreach (string s in vm.SelectedInitDepts)
                {
                    var department        = _context.Ref_Department.SingleOrDefault(m => m.Id.ToString() == s);
                    Department_General dg = new Department_General(department.Id, general.Id, 1);
                    _context.Department_General.Add(dg);
                }
            }
            if (vm.SelectedCollabDepts != null)
            {
                foreach (string s in vm.SelectedCollabDepts)
                {
                    var department        = _context.Ref_Department.SingleOrDefault(m => m.Id.ToString() == s);
                    Department_General dg = new Department_General(department.Id, general.Id, 2);
                    _context.Department_General.Add(dg);
                }
            }
            if (vm.SelectedServDepts != null)
            {
                foreach (string s in vm.SelectedServDepts)
                {
                    var department        = _context.Ref_Department.SingleOrDefault(m => m.Id.ToString() == s);
                    Department_General dg = new Department_General(department.Id, general.Id, 3);
                    _context.Department_General.Add(dg);
                }
            }
            _context.SaveChanges();
            var jump = Request["jump"];
            var prop = general.GetProposal();

            switch (jump)
            {
            case "0": {
                // Save pressed -> return form
                return(RedirectToAction("Edit", "General", new { id = general.Id }));
            }

            case "1":
            {
                // Next pressed -> return next page
                return(RedirectToAction("Jump", "ProgrammeRationale", new { id = prop.Id }));
            }

            case "A":
            {
                // A pressed -> go to Section A
                return(RedirectToAction("Edit", "General", new { id = general.Id }));
            }

            case "B":
            {
                // B pressed -> go to Section B
                return(RedirectToAction("Jump", "ProgrammeRationale", new { id = prop.Id }));
            }

            case "C":
            {
                // C pressed -> go to Section C
                return(RedirectToAction("Jump", "ExternalReview", new { id = prop.Id }));
            }

            case "D":
            {
                // D pressed -> go to Section D
                return(RedirectToAction("Jump", "IncomeExpenditure", new { id = prop.Id }));
            }

            default:
            {
                return(RedirectToAction("Index", "Proposal"));
            }
            }
        }