Example #1
0
        /// <summary>
        /// To insert the DAO test user details
        /// </summary>
        private long DAO_Insert_UserDetails(long CanId, int roleid)
        {
            long UserId   = 0;
            int  ModuleId = 0;

            int.TryParse(Session["exammoduleid"].ToString(), out ModuleId);

            string userEmail    = Session["userEmail"].ToString();
            string examinerName = Session["ExaminerName"].ToString();

            string alloted_questions_tbl = "NES_questions_DAO";
            string examCode = "TS_DAO";

            if (ModuleId == 50)
            {
                alloted_questions_tbl = "NES_questions_DAO";
                examCode = "TS_DAO";
            }
            //Anil 20200611
            if (ModuleId == 52)
            {
                alloted_questions_tbl = "NES_questions_DAO";
                examCode = "INS"; // Insurance Test
            }
            if (ModuleId == 54)
            {
                alloted_questions_tbl = "NES_questions_DAO";
                examCode = "ANA"; // Analytical Test
            }

            if (ModuleId == 56)
            {
                alloted_questions_tbl = "NES_questions_DAO";
                examCode = "EBK_XML"; // EBook XML Test
            }

            if (ModuleId == 57)
            {
                alloted_questions_tbl = "NES_questions_DAO";
                examCode = "EBK_EPUB"; // Ebook EPUB Test
            }

            if (ModuleId == 59)
            {
                alloted_questions_tbl = "NES_questions_DAO";
                examCode = "EDT"; // English Descriptive Test for PCM
            }

            if (ModuleId == 61) // 20200723 Anil
            {
                alloted_questions_tbl = "User_Questions_CINAHL";
                examCode = "CINAHL"; // CINAHL Indexing Test
            }

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

            ExcludeModules.Add(52);
            ExcludeModules.Add(54);
            ExcludeModules.Add(56);
            ExcludeModules.Add(57);
            ExcludeModules.Add(59);
            ExcludeModules.Add(61);

            UserDetails dac = new UserDetails();

            UserId = dac.DAO_Insert_UserDetails(userEmail, roleid, examinerName, alloted_questions_tbl, examCode, ModuleId);
            if (UserId > 0)
            {
                string Ip_Address = Request.ServerVariables["REMOTE_ADDR"].ToString().Trim();
                int    res        = 0;
                if (!ExcludeModules.Contains(ModuleId))
                {
                    res = dac.DAO_Insert_UserAllotedQuestions(UserId, ModuleId, Ip_Address);
                }

                DateTime stdate  = Convert.ToDateTime(txtExamTime.Text + " " + ddlExamTime.SelectedValue);
                int      totTime = 20;
                int.TryParse(ddlTotMinutes.SelectedValue, out totTime);
                string linkId = GenerateRandomString(10);
                InsertCurrent_Candidates(UserId, ModuleId, CanId, stdate, totTime, linkId, Session["ExaminerName"].ToString());
            }
            dac = null;
            return(UserId);
        }