Exemple #1
0
        private string GetFormHeader(JCF_Submission submission)
        {
            string   return_String = "";
            JCF_Form jcf_Form      = new JICSBaseFacade <JCF_Form>().GetQuery().Where(x => x.FormID == submission.FormID).SingleOrDefault();

            return_String += "Form Name:" + jcf_Form.Name + "\n";
            if (submission.UserID != new Guid())
            {
                ICS_Portal_User user = new JICSBaseFacade <ICS_Portal_User>().GetQuery().Where(x => x.ID == submission.UserID).SingleOrDefault();
                return_String += "Submitter Name:" + user.LastName + "," + user.FirstName + "\n";
                return_String += "Submitter ID:" + user.ID + "\n";
                return_String += "Submitted Date:" + submission.SubmittedDate.ToString("dddd, dd MMMM yyyy");
            }
            else
            {
                External_Submitter external_User = new JICSBaseFacade <External_Submitter>().GetQuery().Where(x => x.Submission_ID == submission.SubmissionID).SingleOrDefault();
                if (external_User != null)
                {
                    return_String += "External Submitter Email:" + external_User.User_Email + "\n";
                    return_String += "Submitted Date:" + submission.SubmittedDate.ToString("dddd, dd MMMM yyyy");
                }
                else
                {
                    return_String += "Error Loading Submission:" + submission.SubmissionID;
                }
            }
            return(return_String);
        }
Exemple #2
0
        public Study_Abroad_Form()
        {
            Name         = "Study Abroad Application";
            review_Items = new List <Guid> {
                new Guid("3DD8962A-805D-4972-91BB-11E834E2506C"), // Preference1
                new Guid("8D988A93-0192-4CC2-A8BD-A9FC5F91F9F2"), // Preference2
                new Guid("5F121850-3B2A-44AA-8D9B-FD9BC21818AC"), // Preference3
                new Guid("D8213F6A-6379-4845-86F6-BD9FAEC183B2"), // First Professor Recommendation
                new Guid("8D348FD3-3612-4DF5-B27E-1561256E5ADD"), // Second Professor Recommendation
                new Guid("FC3305D4-3454-47E0-BEC1-2C968C73272D")
            };                                                    // Staff Recommendation
            list_View_Items = new List <Guid> {
                new Guid("3DD8962A-805D-4972-91BB-11E834E2506C"), // Preference1
                new Guid("8D988A93-0192-4CC2-A8BD-A9FC5F91F9F2"), // Preference2
                new Guid("5F121850-3B2A-44AA-8D9B-FD9BC21818AC"), // Preference3
                new Guid("D8213F6A-6379-4845-86F6-BD9FAEC183B2"), // First Professor Recommendation
                new Guid("8D348FD3-3612-4DF5-B27E-1561256E5ADD"), // Second Professor Recommendation
                new Guid("FC3305D4-3454-47E0-BEC1-2C968C73272D")
            };                                                    // Staff Recommendation

            facade = new JCF_Submission();
            list_Column_Headers = new List <string>()
            {
                "UserID", "SubmittedDate", "Process Status", "Preference1", "Preference2", "Preference3", "FirstProfessorRecommendation", "SecondProfessorRecommendation"
            };
            list_Header_Items = new Dictionary <string, object>()
            {
                { "Current Year:", DateTime.Today.Year },
                { "Unveiling of Programs and Applications Open:", "11/18/2019" },
                { "Applications close-by 11:59", "2/11/2020" },
                { "Last Day for Letters of Recommendations:", "2/14/2020" },
                { "Subcommittees get applications to review", "2/18/2020" },
                { "Subcommittees return results to CGC Office:", "2/27/2020" },
                { "CGC Review:", "2/28/2020" },
                { "Release results to students:", "3/2/2020" },
                { "Deposits Due:", "3/16/2020" }
            };
            Index = new List <string> {
                "FormID"
            };
            Index_Value = new List <object> {
                new Guid("D0AF99F0-6E83-4BDA-BDB8-1ABCABCFC339")
            };
        }
Exemple #3
0
        private void open_Clicked(object sender, EventArgs e)
        {
            Button         clickedButton = (Button)sender;
            int            row           = Int32.Parse(clickedButton.ID.Substring(5));
            List_able      listObj       = current_Viewable.returnListable();
            JCF_Submission obj           = (JCF_Submission)listObj.get_iterable_List()[row];
            Object         formID        = obj.FormID;
            Object         formNo        = obj.SubmissionID;

            JCF_Form_Facade form_facade = new JCF_Form_Facade();
            JCF_Form        form        = (JCF_Form)form_facade.GetByIdWhere(formID, "FormID")[0];
            Guid            lookupID    = form.PortletID;

            Form_URL_Table_Facade formurl_facade = new Form_URL_Table_Facade();
            Form_URL_Table        formurltable   = (Form_URL_Table)formurl_facade.GetByIdWhere(lookupID, "PortletID")[0];

            //Response.Redirect("~/Admin/CNTR_Design/Jenzabar_Contained_Form.jnz?submission_id=" + formNo + "&form=" + formID);
            Response.Redirect(formurltable.PortletURL + "?submission_id=" + formNo + "&form=" + formID);
        }
Exemple #4
0
        private string GetSubmissionFileName(JCF_Submission submission)
        {
            string return_String;

            if (submission.UserID != new Guid())
            {
                ICS_Portal_User user = new JICSBaseFacade <ICS_Portal_User>().GetQuery().Where(x => x.ID == submission.UserID).SingleOrDefault();
                //return_String = user.HostID.TrimStart('0')+"_"+user.LastName+"_"+user.FirstName+ "_JCF_" + ".pdf";
                return_String = user.HostID.TrimStart('0') + "_JCF.pdf";
            }
            else
            {
                External_Submitter external_User = new JICSBaseFacade <External_Submitter>().GetQuery().Where(x => x.Submission_ID == submission.SubmissionID).SingleOrDefault();
                if (external_User != null)
                {
                    return_String = "External_JCF.pdf";
                }
                else
                {
                    return_String = "ERROR_JCF.pdf";
                }
            }
            return(return_String);
        }
Exemple #5
0
        private void print_Form(JCF_Submission submission)
        {
            string   filename = string.Empty;
            Document document = new Document();
            Section  section;

            JCF_Submission_Facade submission_Facade = new JCF_Submission_Facade();
            Flow_Rec_Facade       flow_Rec_Facade   = new Flow_Rec_Facade();
            Flow_Rec parent_Flow;

            List <Abstract_Iter_able> form_List = new List <Abstract_Iter_able>();

            List <Abstract_Iter_able> flow_List = flow_Rec_Facade.GetByIdWhere(submission.SubmissionID, "Submission_ID");

            if (flow_List.Count > 0)
            {
                parent_Flow = (Flow_Rec)flow_Rec_Facade.GetByIdWhere(submission.SubmissionID, "Submission_ID")[0];
                List <Abstract_Iter_able> flow_objs = flow_Rec_Facade.GetByIdWhere(parent_Flow.ID, "Parrent_Flow");
                List <Abstract_Iter_able> submissions;

                form_List.Add(submission);
                foreach (Flow_Rec flow_obj in flow_objs)
                {
                    submissions = submission_Facade.GetByIdWhere(flow_obj.Submission_ID, "SubmissionID");
                    if (submissions.Count > 0)
                    {
                        form_List.Add(submissions[0]);
                    }
                }
            }
            else
            {
                form_List.Add(submission);
            }
            Paragraph    answer_Paragraph  = new Paragraph();
            Paragraph    question_Pragraph = new Paragraph();
            Paragraph    header_Paragaraph = new Paragraph();
            List <Color> color_List        = new List <Color>()
            {
                Colors.Red, Colors.Orange, Colors.Yellow, Colors.Green, Colors.Blue, Colors.Indigo, Colors.Violet
            };
            int i = 0;

            foreach (JCF_Submission submissionForm in form_List)
            {
                section           = document.AddSection();
                header_Paragaraph = section.AddParagraph(GetFormHeader(submissionForm));
                header_Paragaraph.Format.Alignment        = ParagraphAlignment.Left;
                header_Paragaraph.Format.Font.Name        = "Times New Roman";
                header_Paragaraph.Format.Font.Color       = Colors.Black;
                header_Paragaraph.Format.Borders.Distance = "5pt";
                header_Paragaraph.Format.Borders.Color    = color_List[i % 7];
                header_Paragaraph.Format.Font.Size        = 16;
                List <JCF_FormItem> questions = new JICSBaseFacade <JCF_FormItem>().GetQuery().Where(x => x.FormID == submissionForm.FormID).OrderBy(x => x.QuestionNum).ThenBy(x => x.RowNum).ToList();
                foreach (JCF_FormItem question in questions)
                {
                    question_Pragraph = section.AddParagraph(StripHTML(current_Viewable.nullCheck(question.Text).ToString()));
                    question_Pragraph.Format.Alignment        = ParagraphAlignment.Left;
                    question_Pragraph.Format.Font.Name        = "Times New Roman";
                    question_Pragraph.Format.Font.Color       = Colors.Black;
                    question_Pragraph.Format.Font.Size        = 12;
                    question_Pragraph.Format.Borders.Distance = "5pt";
                    question_Pragraph.Format.Borders.Color    = color_List[i % 7];

                    List <JCF_Answer> answers = new JICSBaseFacade <JCF_Answer>().GetQuery().Where(x => x.ItemID == question.ID && x.SubmissionID == submissionForm.SubmissionID).ToList();
                    if (answers.Count > 0)
                    {
                        foreach (JCF_Answer answer in answers)
                        {
                            answer_Paragraph = section.AddParagraph(StripHTML(current_Viewable.nullCheck(answer.AnswerValue).ToString()));
                            answer_Paragraph.Format.Alignment  = ParagraphAlignment.Justify;
                            answer_Paragraph.Format.Font.Name  = "Times New Roman";
                            answer_Paragraph.Format.Font.Color = Colors.DarkGray;
                            answer_Paragraph.Format.Font.Size  = 12;
                        }
                    }
                    else
                    {
                        answer_Paragraph = section.AddParagraph(" ");
                        answer_Paragraph.Format.Alignment = ParagraphAlignment.Justify;
                        answer_Paragraph.Format.Font.Size = 12;
                    }
                }
                i++;
            }

            PdfDocumentRenderer pdfRenderer = new PdfDocumentRenderer(false);

            pdfRenderer.Document = document;
            pdfRenderer.RenderDocument();
            filename = GetSubmissionFileName(submission);
            EventLog.WriteEntry("ICSNET", "FILENAME:" + filename, EventLogEntryType.Information);
            Response.Clear();
            Response.ContentType = "application/pdf";
            MemoryStream stream = new MemoryStream();

            pdfRenderer.PdfDocument.Save(stream, false);
            Response.AddHeader("Content-Disposition", "attachment; filename=" + filename);
            Response.AddHeader("content-length", stream.Length.ToString());
            Response.BinaryWrite(stream.ToArray());
            Response.Flush();
            stream.Close();
            Response.End();
        }
Exemple #6
0
        private void delete_Clicked(object sender, EventArgs e)
        {
            Button clickedButton = (Button)sender;
            CNTR_Resource_Schedule_Facade resource_Schedule_Facade = new CNTR_Resource_Schedule_Facade();

            string deleteLogMessage = PortalUser.Current.FirstName + " " + PortalUser.Current.LastName + " has deleted a Submission." + "\n";

            int       row     = Int32.Parse(clickedButton.ID.Substring(7));
            List_able listObj = current_Viewable.returnListable();

            switch (listObj.getType())
            {
            case "ICS_NHibernate.JCF_Submission":
                JCF_Submission        obj = (JCF_Submission)listObj.get_iterable_List()[row];
                JCF_Submission_Facade submission_Facade = new JCF_Submission_Facade();
                JCF_Answer_Facade     answer_Facade     = new JCF_Answer_Facade();
                Flow_Rec_Facade       flow_Rec_Facade   = new Flow_Rec_Facade();
                submission_Facade.Remove(obj);
                deleteLogMessage += "SubmissionID: " + obj.SubmissionID.ToString() + "\n";
                deleteLogMessage += "SubmissionUser: "******"\n";
                deleteLogMessage += "SubmissionFormID: " + obj.FormID.ToString() + "\n";
                deleteLogMessage += "SubmissionSubmittedDate: " + obj.SubmittedDate.ToString() + "\n";

                try
                {
                    List <CNTR_Resource_Schedule> resourceList = resource_Schedule_Facade.GetByIdWhere(obj.SubmissionID, "Submission_ID").Cast <CNTR_Resource_Schedule>().ToList();
                    foreach (CNTR_Resource_Schedule schedule in resourceList)
                    {
                        resource_Schedule_Facade.Remove(schedule);
                        deleteLogMessage += "ResourceID: " + schedule.Schedule_ID.ToString() + "\n";
                        deleteLogMessage += "ResourceStartTime: " + schedule.Start_Date.ToString() + "\n";
                        deleteLogMessage += "ResourceEndTime: " + schedule.End_Date.ToString() + "\n";
                        deleteLogMessage += "ResourceUser: "******"\n";
                    }
                }
                catch
                {
                    EventLog.WriteEntry("ICSNET", "Error while clearing resource scheduled when deleting submission.");
                }

                List <Flow_Rec> flow_List = flow_Rec_Facade.GetByIdWhere(obj.SubmissionID, "Submission_ID").Cast <Flow_Rec>().ToList();
                if (flow_List.Any())
                {
                    Flow_Rec parent_Flow;
                    if (flow_List[0].Parrent_Flow == new Guid())
                    {
                        parent_Flow = flow_List[0];
                    }
                    else
                    {
                        flow_List = flow_Rec_Facade.GetByIdWhere(flow_List[0].Parrent_Flow, "ID").Cast <Flow_Rec>().ToList();
                        if (flow_List.Any())
                        {
                            parent_Flow = flow_List[0];
                        }
                        else
                        {
                            parent_Flow = null;
                        }
                    }
                    if (parent_Flow != null)
                    {
                        flow_List = flow_Rec_Facade.GetByIdWhere(parent_Flow.ID, "Parrent_Flow").Cast <Flow_Rec>().ToList();
                        List <JCF_Submission> submission_List = new List <JCF_Submission>();
                        foreach (Flow_Rec flow in flow_List)
                        {
                            List <JCF_Submission> submissions = submission_Facade.GetByIdWhere(flow.Submission_ID, "SubmissionID").Cast <JCF_Submission>().ToList();
                            if (submissions.Any())
                            {
                                submission_List.Add(submissions[0]);
                                submission_Facade.Remove(submissions[0]);
                            }
                            flow_Rec_Facade.Remove(flow);
                        }
                        foreach (JCF_Submission sub in submission_List)
                        {
                            List <Abstract_Iter_able> answer_List = answer_Facade.GetByIdWhere(sub.SubmissionID, "SubmissionID");
                            foreach (JCF_Answer answer in answer_List)
                            {
                                answer_Facade.Remove(answer);
                            }
                        }

                        flow_Rec_Facade.Remove(parent_Flow);
                    }
                }

                List <Abstract_Iter_able> answers_List = answer_Facade.GetByIdWhere(obj.SubmissionID, "SubmissionID");
                foreach (JCF_Answer x in answers_List)
                {
                    answer_Facade.Remove(x);
                }
                break;

            default:

                break;
            }
            var flow_Object = master_Forms_List[Convert.ToInt32(hf_Selected_Object.Value)] as Flow_Form_able;

            if (flow_Object != null)
            {
                LoadFlow(master_Forms_List[Convert.ToInt32(hf_Selected_Object.Value)], master_Forms_List[Convert.ToInt32(hf_Selected_Object.Value)].Index_Value, master_Forms_List[Convert.ToInt32(hf_Selected_Object.Value)].Index);
            }
            else
            {
                LoadForm(master_Forms_List[Convert.ToInt32(hf_Selected_Object.Value)].facade, master_Forms_List[Convert.ToInt32(hf_Selected_Object.Value)].Index_Value, master_Forms_List[Convert.ToInt32(hf_Selected_Object.Value)].Index, master_Forms_List[Convert.ToInt32(hf_Selected_Object.Value)]);
            }
            EventLog.WriteEntry("ICSNET", deleteLogMessage, EventLogEntryType.Warning);
            return;
        }
Exemple #7
0
        public void ChangeView(Object sender, EventArgs e)
        {
            Guid submission_Guid    = new Guid(hf_Submission.Value);
            CNTR_CovidForm_Rec flow = new JICSBaseFacade <CNTR_CovidForm_Rec>().GetQuery().Where(x => x.SubmissionID == submission_Guid).SingleOrDefault();
            int data = Convert.ToInt32(hf_Selected_Object.Value);

            switch (hf_isButtonClicked.Value)
            {
            case "edit":
                Session["viewDesired"]  = "edit";
                Session["form_Obj"]     = flow;
                Session["formable"]     = master_Forms_List[data];
                Session["viewableType"] = master_Forms_List[data].Name;
                ParentPortlet.NextScreen("Objectable_View");
                break;

            case "review":
                Session["viewDesired"] = "edit";

                Session["form_Obj"]     = flow;
                Session["formable"]     = master_Forms_List[data];
                Session["viewableType"] = master_Forms_List[data].Name;

                ParentPortlet.NextScreen("Objectable_View");
                break;

            case "delete":
                new CNTR_CovidForm_Rec_Facade().Remove(flow);
                break;

            case "print":
                List_able          listObj  = current_Viewable.returnListable();
                Abstract_Iter_able form_obj = listObj.get_iterable_List()[data];
                EventLog.WriteEntry("ICSNET", "ListObject:" + listObj.getType(), EventLogEntryType.Information);
                switch (listObj.getType())
                {
                case "ICS_NHibernate.JCF_Submission":
                    JCF_Submission obj = (JCF_Submission)listObj.get_iterable_List()[data];
                    this.print_Form(obj);
                    break;

                case "ICS_NHibernate.Flow_Rec":
                    Flow_Rec       flow_Obj          = (Flow_Rec)listObj.get_iterable_List()[data];
                    JCF_Submission submission_Object = new JICSBaseFacade <JCF_Submission>().GetQuery().Where(x => x.SubmissionID == flow_Obj.Submission_ID).SingleOrDefault();
                    if (submission_Object != null)
                    {
                        this.print_Form(submission_Object);
                    }
                    break;

                case "ICS_NHibernate.CNTR_CovidForm_Rec":
                    this.print_Form(flow);
                    break;

                default:
                    break;
                }

                break;
            }
        }
        private void readyViewObject(List <Flow_Rec> view_Objects, List <Guid> answer_Guids, Dictionary <Guid, object> question_Dictionary_List, Dictionary <Guid, string> question_Answer_Dictionary_List, Dictionary <Guid, string> question_Options_Dictionary_List)
        {
            JICSBaseFacade <JCF_FormItem>   facade            = new JICSBaseFacade <JCF_FormItem>();
            JICSBaseFacade <JCF_Answer>     answer_Facade     = new JICSBaseFacade <JCF_Answer>();
            JICSBaseFacade <JCF_Submission> submission_Facade = new JICSBaseFacade <JCF_Submission>();

            int i = 0;
            Dictionary <int, string> type_Dictionary = new Dictionary <int, string> {
                { 0, "primary" },
                { 1, "warning" },
                { 2, "success" },
                { 3, "danger" },
                { 4, "info" }
            };

            foreach (Flow_Rec view_Obj in view_Objects)
            {
                //List<Abstract_Iter_able> results_Objects;
                JCF_Submission submission = submission_Facade.GetQuery().Where(x => x.SubmissionID == view_Obj.Submission_ID).ToList()[0];
                //results_Objects = answer_Facade.GetByIdWhere(view_Obj.Submission_ID, "SubmissionID");
                List <JCF_FormItem> form_items = facade.GetQuery().Where(x => x.FormID == submission.FormID).ToList();


                foreach (JCF_FormItem item in form_items)
                {
                    if (item.IsActive)
                    {
                        //object_Options.Add(type_Dictionary[i % 5]);

                        //question_Objects.Add(item);

                        List <string> query_Strings = new List <string>()
                        {
                            "SubmissionID", "ItemID"
                        };
                        List <object> query_Objects = new List <object>()
                        {
                            view_Obj.Submission_ID, item.ID
                        };
                        List <JCF_Answer> items = answer_Facade.GetQuery().Where(x => x.SubmissionID == submission.SubmissionID && x.ItemID == item.ID).ToList();
                        if (items.Count > 0)
                        {
                            //answer_Objects.Add(items[0]);
                            JCF_Answer jCF_Answer = items[0];
                            question_Answer_Dictionary_List.Add(jCF_Answer.AnswerID, jCF_Answer.AnswerValue);

                            question_Options_Dictionary_List.Add(jCF_Answer.AnswerID, type_Dictionary[i % 5]);
                            question_Dictionary_List.Add(jCF_Answer.AnswerID, item);
                            answer_Guids.Add(jCF_Answer.AnswerID);
                            //question_Types.Add(item.Type.ToString());
                        }
                        else
                        {
                            JCF_Answer new_Answer = new JCF_Answer();
                            new_Answer.SubmissionID = view_Obj.Submission_ID;
                            new_Answer.ItemID       = item.ID;
                            new_Answer.AnswerValue  = "";
                            new_Answer.AnswerID     = Guid.NewGuid();
                            answer_Facade.Save(new_Answer);
                            answer_Facade.Flush();
                            //answer_Objects.Add(new_Answer);
                            question_Answer_Dictionary_List.Add(new_Answer.AnswerID, new_Answer.AnswerValue);
                            question_Options_Dictionary_List.Add(new_Answer.AnswerID, type_Dictionary[i % 5]);
                            question_Dictionary_List.Add(new_Answer.AnswerID, item);
                            answer_Guids.Add(new_Answer.AnswerID);
                            //question_Types.Add(item.Type.ToString());
                        }
                    }
                }
                i++;
            }
        }
        private void readyViewObject(List <Abstract_Iter_able> view_Objects, JCF_Submission review_Obj, List <Guid> answer_Guids, Dictionary <Guid, object> question_Dictionary_List, Dictionary <Guid, string> question_Answer_Dictionary_List, Dictionary <Guid, string> question_Options_Dictionary_List
                                     , List <Guid> review_Answer_Guids, Dictionary <Guid, object> review_Question_Dictionary_List, Dictionary <Guid, string> review_Question_Answer_Dictionary_List, Dictionary <Guid, string> review_Question_Options_Dictionary_List)
        {
            JCF_Form_Facade form_Facade = new JCF_Form_Facade();
            JICSBaseFacade <JCF_FormItem> form_Item_facade = new JICSBaseFacade <JCF_FormItem>();
            JICSBaseFacade <JCF_Answer>   answer_Facade    = new JICSBaseFacade <JCF_Answer>();
            ICS_Portal_User_Facade        user_Facade      = new ICS_Portal_User_Facade();

            int i = 0;
            Dictionary <int, string> type_Dictionary = new Dictionary <int, string> {
                { 0, "primary" },
                { 1, "warning" },
                { 2, "success" },
                { 3, "danger" },
                { 4, "info" }
            };


            foreach (JCF_Submission view_Obj in view_Objects)
            {
                List <JCF_FormItem> questions = form_Item_facade.GetQuery().Where(x => x.FormID == view_Obj.FormID).ToList();
                //List<Abstract_Iter_able> results_Objects;
                //results_Objects = answer_Facade.GetByIdWhere(view_Obj.SubmissionID, "SubmissionID");

                /*List<JCF_FormItem> questions = new List<JCF_FormItem>();
                 *
                 * foreach (JCF_FormItem question in form_items)
                 * {
                 *  questions.Add(question);
                 *
                 * }*/
                var ordered_form_items = questions.OrderBy(o => o.RowNum).ThenBy(o => o.QuestionNum);
                foreach (JCF_FormItem item in ordered_form_items)
                {
                    if (item.IsActive)
                    {
                        //object_Options.Add(type_Dictionary[i % 5]);

                        //question_Objects.Add(item);

                        /*List<string> query_Strings = new List<string>() { "SubmissionID", "ItemID" };
                         * List<object> query_Objects = new List<object>() { view_Obj.SubmissionID, item.ID };
                         * List<Abstract_Iter_able> items = answer_Facade.GetByIdWhere(query_Objects, query_Strings);*/
                        List <JCF_Answer> items = answer_Facade.GetQuery().Where(x => x.SubmissionID == view_Obj.SubmissionID && x.ItemID == item.ID).ToList();
                        if (items.Count > 0)
                        {
                            //answer_Objects.Add(items[0]);
                            JCF_Answer jCF_Answer = items[0];
                            question_Answer_Dictionary_List.Add(jCF_Answer.AnswerID, jCF_Answer.AnswerValue);
                            question_Options_Dictionary_List.Add(jCF_Answer.AnswerID, type_Dictionary[i % 5]);
                            question_Dictionary_List.Add(jCF_Answer.AnswerID, item);
                            answer_Guids.Add(jCF_Answer.AnswerID);
                            //question_Types.Add(item.Type.ToString());
                        }
                        else
                        {
                            JCF_Answer new_Answer = new JCF_Answer();
                            new_Answer.SubmissionID = view_Obj.SubmissionID;
                            new_Answer.AnswerID     = Guid.NewGuid();
                            new_Answer.ItemID       = item.ID;
                            new_Answer.AnswerValue  = "";
                            answer_Facade.Save(new_Answer);
                            answer_Facade.Flush();
                            //answer_Objects.Add(new_Answer);
                            question_Answer_Dictionary_List.Add(new_Answer.AnswerID, new_Answer.AnswerValue);
                            question_Options_Dictionary_List.Add(new_Answer.AnswerID, type_Dictionary[i % 5]);
                            question_Dictionary_List.Add(new_Answer.AnswerID, item);
                            answer_Guids.Add(new_Answer.AnswerID);

                            //question_Types.Add(item.Type.ToString());
                        }
                    }
                }
                i++;
            }

            List <JCF_FormItem> review_Questions = form_Item_facade.GetQuery().Where(x => x.FormID == review_Obj.FormID).ToList();

            /*List<JCF_FormItem> review_Questions = new List<JCF_FormItem>();
             * foreach (JCF_FormItem question in review_items)
             * {
             *  review_Questions.Add(question);
             * }*/
            var ordered_review_items = review_Questions.OrderBy(o => o.RowNum).ThenBy(o => o.QuestionNum);

            foreach (JCF_FormItem item in ordered_review_items)
            {
                if (item.Required == true || item.Required == false)
                {
                    //object_Options.Add(type_Dictionary[i % 5]);

                    //question_Objects.Add(item);

                    //List<string> query_Strings = new List<string>() { "SubmissionID", "ItemID" };
                    //List<object> query_Objects = new List<object>() { review_Obj.SubmissionID, item.ID };
                    List <JCF_Answer> items = answer_Facade.GetQuery().Where(x => x.SubmissionID == review_Obj.SubmissionID && x.ItemID == item.ID).ToList();
                    if (items.Count > 0)
                    {
                        //answer_Objects.Add(items[0]);
                        JCF_Answer jCF_Answer = items[0];
                        review_Question_Answer_Dictionary_List.Add(jCF_Answer.AnswerID, jCF_Answer.AnswerValue);

                        review_Question_Options_Dictionary_List.Add(jCF_Answer.AnswerID, type_Dictionary[i % 5]);
                        review_Question_Dictionary_List.Add(jCF_Answer.AnswerID, item);
                        review_Answer_Guids.Add(jCF_Answer.AnswerID);

                        //review_question_Types.Add(item.Type.ToString());
                    }
                    else
                    {
                        Guid       answer_Guid = Guid.NewGuid();
                        JCF_Answer new_Answer  = new JCF_Answer();
                        new_Answer.SubmissionID = review_Obj.SubmissionID;
                        new_Answer.ItemID       = item.ID;
                        new_Answer.AnswerValue  = "";
                        new_Answer.AnswerID     = answer_Guid;
                        answer_Facade.Save(new_Answer);
                        answer_Facade.Flush();
                        //answer_Objects.Add(new_Answer);
                        review_Question_Answer_Dictionary_List.Add(new_Answer.AnswerID, new_Answer.AnswerValue);
                        review_Question_Options_Dictionary_List.Add(new_Answer.AnswerID, type_Dictionary[i % 5]);
                        review_Question_Dictionary_List.Add(new_Answer.AnswerID, item);
                        review_Answer_Guids.Add(new_Answer.AnswerID);
                        //review_question_Types.Add(item.Type.ToString());
                    }
                }
            }
        }
Exemple #10
0
        public override void SetSubmission(JCF_Submission jcf_Submission)
        {
            submission = jcf_Submission;
            double score = 0;
            ICS_Portal_User_Facade    user_Facade      = new ICS_Portal_User_Facade();
            ICS_Portal_User           user             = (ICS_Portal_User)user_Facade.GetByIdWhere(submission.UserID, "ID")[0];
            List <Involvement>        involvements     = new InvolvementFacade().getAllInvolvementsByStudentID(System.Convert.ToInt32(user.HostID));
            StuAcad_Facade            stuAcad_Facade   = new StuAcad_Facade();
            List <Abstract_Iter_able> stu_acad_records = stuAcad_Facade.GetByIdWhere(Int32.Parse(user.HostID), "id");

            string cum_gpa       = "Error, No GPA Found";
            float  pass_Hours    = 0 / 1;
            string abroad_Status = "";

            StuStatRecord stuStatRecord = (StuStatRecord)(new StuStatRecord_Facade().GetByIdWhere(Int32.Parse(user.HostID), "ID").First());

            if (stuStatRecord != null)
            {
                cum_gpa = stuStatRecord.CumulativeGPA.ToString();
                score  += ((stuStatRecord.CumulativeGPA / 4) * 5);
            }


            //foreach (StuAcad record in stu_acad_records)
            //{
            //    if (record.cum_pass_hrs > pass_Hours)
            //    {
            //        cum_gpa = record.cum_gpa.ToString();
            //        pass_Hours = record.cum_pass_hrs;
            //    }
            //}

            ProgEnrRecFacade progEnrRecFacade = new ProgEnrRecFacade();
            ProgEnrRec       progEnrRec       = progEnrRecFacade.GetById(Int32.Parse(user.HostID.TrimStart('0')));

            foreach (Involvement involvement in involvements)
            {
                if (involvement.InvlCode.EdiInvl == "OCS")
                {
                    if (abroad_Status != "")
                    {
                        abroad_Status += ", ";
                    }
                    abroad_Status += involvement.InvlCode.Descr;
                }
            }

            string StuClassification = "";

            switch (progEnrRec.Class)
            {
            case "FR":
                StuClassification = "First-Year";
                score            += 0;
                break;

            case "SO":
                StuClassification = "Sophmore";
                score            += 2;
                break;

            case "JR":
                StuClassification = "Junior";
                score            += 3;
                break;

            case "SR":
                StuClassification = "Senior";
                score            += 4;
                if (abroad_Status != "")
                {
                    score++;
                }
                break;
            }


            if (abroad_Status == "")
            {
                abroad_Status = "Student has not studied abroad before.";
            }

            single_Header_Items = new Dictionary <string, object>()
            {
                { "Student ID", user.FirstName + " " + user.LastName + " | " + user.Email },
                { "Program Preference 1:", ((JCF_Answer) new JCF_Answer_Facade().GetByIdWhere(new List <object>()
                    {
                        submission.SubmissionID, new Guid("3DD8962A-805D-4972-91BB-11E834E2506C")
                    }, new List <string>()
                    {
                        "SubmissionID", "ItemID"
                    })[0]).AnswerValue },
                { "Program Preference 2:", ((JCF_Answer) new JCF_Answer_Facade().GetByIdWhere(new List <object>()
                    {
                        submission.SubmissionID, new Guid("8D988A93-0192-4CC2-A8BD-A9FC5F91F9F2")
                    }, new List <string>()
                    {
                        "SubmissionID", "ItemID"
                    })[0]).AnswerValue },
                { "Program Preference 3:", ((JCF_Answer) new JCF_Answer_Facade().GetByIdWhere(new List <object>()
                    {
                        submission.SubmissionID, new Guid("5F121850-3B2A-44AA-8D9B-FD9BC21818AC")
                    }, new List <string>()
                    {
                        "SubmissionID", "ItemID"
                    })[0]).AnswerValue },
                { "Study Abroad Status:", abroad_Status },
                { "Classification:", StuClassification },
                { "Student GPA:", cum_gpa }
            };
            single_Footer_Items = new Dictionary <string, object>()
            {
                { "Student ID", user.FirstName + " " + user.LastName + " | " + user.Email },
                { "Program Preference 1:", ((JCF_Answer) new JCF_Answer_Facade().GetByIdWhere(new List <object>()
                    {
                        submission.SubmissionID, new Guid("3DD8962A-805D-4972-91BB-11E834E2506C")
                    }, new List <string>()
                    {
                        "SubmissionID", "ItemID"
                    })[0]).AnswerValue },
                { "Program Preference 2:", ((JCF_Answer) new JCF_Answer_Facade().GetByIdWhere(new List <object>()
                    {
                        submission.SubmissionID, new Guid("8D988A93-0192-4CC2-A8BD-A9FC5F91F9F2")
                    }, new List <string>()
                    {
                        "SubmissionID", "ItemID"
                    })[0]).AnswerValue },
                { "Program Preference 3:", ((JCF_Answer) new JCF_Answer_Facade().GetByIdWhere(new List <object>()
                    {
                        submission.SubmissionID, new Guid("5F121850-3B2A-44AA-8D9B-FD9BC21818AC")
                    }, new List <string>()
                    {
                        "SubmissionID", "ItemID"
                    })[0]).AnswerValue },
                { "Study Abroad Status:", abroad_Status },
                { "Classification:", StuClassification },
                { "Student GPA:", cum_gpa }
            };
        }