Example #1
0
        // Cau hoi text
        public Dictionary <string, model.reportTotal> insertReportTotal1(model.reportTotal rpt, Dictionary <string, model.reportTotal> dt)
        {
            Dictionary <string, model.reportTotal> dtReturn;

            dtReturn = dt;
            string key = string.Format("{0}_{1}_{2}_{3}", rpt.LecturerId, rpt.ClassRoomId, rpt.QuestionId, rpt.AnswerId);

            if (dt.ContainsKey(key))
            {
                model.reportTotal rpt1 = dt[key];
                rpt1.Value = rpt1.Value + ";" + rpt.Value;
                dtReturn.Remove(key);
                dtReturn.Add(key, rpt1);
            }
            else
            {
                dtReturn.Add(key, rpt);
            }
            return(dtReturn);
        }
Example #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                Dictionary <string, model.reportTotal> dtReportTotals = new Dictionary <string, model.reportTotal>();
                string    strContent          = string.Format("Bat dau: {0:d/M/yyyy HH:mm:ss}", DateTime.Now);
                DataTable dt                  = data.Nuce_Survey.getByStatus(4, 1);
                DataTable dtNoiDungBaiKhaoSat = data.Nuce_Survey.getEdu_Survey_BaiKhaoSat_GetNoiDungDeThi();
                DataTable dtLecturer          = data.Nuce_Survey.getAcademy_Lecturer();
                DataTable dtClassRoom         = data.Nuce_Survey.getAcademy_ClassRoom();
                for (int i = 0; i < dt.Rows.Count; i++)
                //for (int i = 0; i < 10; i++)
                {
                    int    SinhVien_BaiKhaoSat_SinhVienID = int.Parse(dt.Rows[i]["ID"].ToString());
                    int    SinhVien_BaiKhaoSatID          = int.Parse(dt.Rows[i]["BaiKhaoSatID"].ToString());
                    int    SinhVienID                = int.Parse(dt.Rows[i]["SinhVienID"].ToString());
                    int    iDeThiID                  = int.Parse(dt.Rows[i]["DeThiID"].ToString());
                    string NoiDungDeThi              = getNoiDungDeThi(iDeThiID.ToString(), dtNoiDungBaiKhaoSat);
                    string strAnswares               = dt.Rows[i]["BaiLam"].ToString();
                    string stringClassRoomCode       = dt.Rows[i]["ClassRoomCode"].ToString();
                    string stringLecturerCode        = dt.Rows[i]["LecturerCode"].ToString();
                    List <model.CauHoi> lsCauHois    = JsonConvert.DeserializeObject <List <model.CauHoi> >(NoiDungDeThi);
                    List <model.DapAn>  lsDapAns     = new List <model.DapAn>();
                    List <model.DapAn>  lsDapAnsText = new List <model.DapAn>();
                    string   strRate                 = "";
                    string[] strAnswaresSplit        = strAnswares.Split(new string[] { "#####$$$$$@@@@@" }, StringSplitOptions.RemoveEmptyEntries);
                    if (strAnswaresSplit.Length >= 3)
                    {
                        lsDapAns     = Utils.convertListDapAnFromAnswares(strAnswaresSplit[0]);
                        lsDapAnsText = Utils.convertListDapAnFromAnswaresText(strAnswaresSplit[1]);
                        strRate      = strAnswaresSplit[2];
                    }
                    //data.dnn_Nuce_KS_SinhVienRaTruong_ReportTotal1.insert(SinhVien_BaiKhaoSat_SinhVienID,SinhVien_BaiKhaoSatID,SinhVienID,)
                    string strMatch = "";
                    if (lsDapAns != null)
                    {
                        //string strMatch = dapAn != null ? dapAn.Match : "";
                        foreach (model.DapAn dapAnTemp in lsDapAns)
                        {
                            strMatch += ";" + dapAnTemp.Match + ";";
                        }
                    }
                    // Chi so cau hoi
                    int    l  = 0;
                    int    l1 = 0;
                    string strType;
                    int    iSoCauTraLoi = -1;
                    string strIDMC      = "";
                    #region
                    foreach (model.CauHoi cauhoi in lsCauHois)
                    {
                        l++;
                        strType = cauhoi.Type;
                        model.reportTotal rpt1 = new model.reportTotal();
                        model.reportTotal rpt2 = new model.reportTotal();
                        model.reportTotal rpt3 = new model.reportTotal();
                        model.reportTotal rpt4 = new model.reportTotal();
                        model.reportTotal rpt5 = new model.reportTotal();
                        model.reportTotal rpt6 = new model.reportTotal();
                        switch (strType)
                        {
                            #region cau hoi lua chon
                        case "SC":
                        case "MC":
                        case "TQ":
                        case "FQ":
                            iSoCauTraLoi = cauhoi.SoCauTraLoi;
                            l1           = 1;
                            while (l1 < (iSoCauTraLoi + 1))
                            {
                                strIDMC = "";
                                switch (l1)
                                {
                                case 1:
                                    if (strMatch.Contains(string.Format(";{0};", cauhoi.M1)))
                                    {
                                        // Cap nhat cau hoi duoc tra loi
                                        #region rpt
                                        rpt1.CampaignId         = 1;
                                        rpt1.SemesterId         = 1;
                                        rpt1.CampaignTemplateId = iDeThiID;
                                        rpt1.ClassRoomId        = getClassRoomID(stringClassRoomCode, dtClassRoom);
                                        rpt1.LecturerId         = getLecturerID(stringLecturerCode, dtLecturer);
                                        #region QuestionType
                                        switch (strType)
                                        {
                                        case "SC":
                                            rpt1.QuestionType = 1;
                                            break;

                                        case "MC":
                                            rpt1.QuestionType = 2;
                                            break;

                                        case "SA":
                                            rpt1.QuestionType = 3;
                                            break;

                                        default:
                                            rpt1.QuestionType = -1;
                                            break;
                                        }
                                        #endregion
                                        rpt1.QuestionId    = cauhoi.CauHoiID;
                                        rpt1.QuestionIndex = l;
                                        rpt1.Total         = 1;
                                        rpt1.AnswerId      = -1;
                                        rpt1.Value         = "";
                                        #endregion
                                        rpt1.AnswerId  = int.Parse(cauhoi.M1);
                                        dtReportTotals = insertReportTotal(rpt1, dtReportTotals);
                                    }
                                    break;

                                case 2:
                                    if (strMatch.Contains(string.Format(";{0};", cauhoi.M2)))
                                    {
                                        // Cap nhat cau hoi duoc tra loi
                                        #region rpt
                                        rpt2.CampaignId         = 1;
                                        rpt2.SemesterId         = 1;
                                        rpt2.CampaignTemplateId = iDeThiID;
                                        rpt2.ClassRoomId        = getClassRoomID(stringClassRoomCode, dtClassRoom);
                                        rpt2.LecturerId         = getLecturerID(stringLecturerCode, dtLecturer);
                                        #region QuestionType
                                        switch (strType)
                                        {
                                        case "SC":
                                            rpt2.QuestionType = 1;
                                            break;

                                        case "MC":
                                            rpt2.QuestionType = 2;
                                            break;

                                        case "SA":
                                            rpt2.QuestionType = 3;
                                            break;

                                        default:
                                            rpt2.QuestionType = -1;
                                            break;
                                        }
                                        #endregion
                                        rpt2.QuestionId    = cauhoi.CauHoiID;
                                        rpt2.QuestionIndex = l;
                                        rpt2.Total         = 1;
                                        rpt2.AnswerId      = -1;
                                        rpt2.Value         = "";
                                        #endregion
                                        rpt2.AnswerId  = int.Parse(cauhoi.M2);
                                        dtReportTotals = insertReportTotal(rpt2, dtReportTotals);
                                    }
                                    break;

                                case 3:
                                    if (strMatch.Contains(string.Format(";{0};", cauhoi.M3)))
                                    {
                                        #region rpt
                                        rpt3.CampaignId         = 1;
                                        rpt3.SemesterId         = 1;
                                        rpt3.CampaignTemplateId = iDeThiID;
                                        rpt3.ClassRoomId        = getClassRoomID(stringClassRoomCode, dtClassRoom);
                                        rpt3.LecturerId         = getLecturerID(stringLecturerCode, dtLecturer);
                                        #region QuestionType
                                        switch (strType)
                                        {
                                        case "SC":
                                            rpt3.QuestionType = 1;
                                            break;

                                        case "MC":
                                            rpt3.QuestionType = 2;
                                            break;

                                        case "SA":
                                            rpt3.QuestionType = 3;
                                            break;

                                        default:
                                            rpt3.QuestionType = -1;
                                            break;
                                        }
                                        #endregion
                                        rpt3.QuestionId    = cauhoi.CauHoiID;
                                        rpt3.QuestionIndex = l;
                                        rpt3.Total         = 1;
                                        rpt3.AnswerId      = -1;
                                        rpt3.Value         = "";
                                        #endregion
                                        rpt3.AnswerId  = int.Parse(cauhoi.M3);
                                        dtReportTotals = insertReportTotal(rpt3, dtReportTotals);
                                    }
                                    break;

                                case 4:
                                    if (strMatch.Contains(string.Format(";{0};", cauhoi.M4)))
                                    {
                                        #region rpt
                                        rpt4.CampaignId         = 1;
                                        rpt4.SemesterId         = 1;
                                        rpt4.CampaignTemplateId = iDeThiID;
                                        rpt4.ClassRoomId        = getClassRoomID(stringClassRoomCode, dtClassRoom);
                                        rpt4.LecturerId         = getLecturerID(stringLecturerCode, dtLecturer);
                                        #region QuestionType
                                        switch (strType)
                                        {
                                        case "SC":
                                            rpt4.QuestionType = 1;
                                            break;

                                        case "MC":
                                            rpt4.QuestionType = 2;
                                            break;

                                        case "SA":
                                            rpt4.QuestionType = 3;
                                            break;

                                        default:
                                            rpt4.QuestionType = -1;
                                            break;
                                        }
                                        #endregion
                                        rpt4.QuestionId    = cauhoi.CauHoiID;
                                        rpt4.QuestionIndex = l;
                                        rpt4.Total         = 1;
                                        rpt4.AnswerId      = -1;
                                        rpt4.Value         = "";
                                        #endregion
                                        rpt4.AnswerId  = int.Parse(cauhoi.M4);
                                        dtReportTotals = insertReportTotal(rpt4, dtReportTotals);
                                    }
                                    break;

                                case 5:
                                    if (strMatch.Contains(string.Format(";{0};", cauhoi.M5)))
                                    {
                                        #region rpt
                                        rpt5.CampaignId         = 1;
                                        rpt5.SemesterId         = 1;
                                        rpt5.CampaignTemplateId = iDeThiID;
                                        rpt5.ClassRoomId        = getClassRoomID(stringClassRoomCode, dtClassRoom);
                                        rpt5.LecturerId         = getLecturerID(stringLecturerCode, dtLecturer);
                                        #region QuestionType
                                        switch (strType)
                                        {
                                        case "SC":
                                            rpt5.QuestionType = 1;
                                            break;

                                        case "MC":
                                            rpt5.QuestionType = 2;
                                            break;

                                        case "SA":
                                            rpt5.QuestionType = 3;
                                            break;

                                        default:
                                            rpt5.QuestionType = -1;
                                            break;
                                        }
                                        #endregion
                                        rpt5.QuestionId    = cauhoi.CauHoiID;
                                        rpt5.QuestionIndex = l;
                                        rpt5.Total         = 1;
                                        rpt5.AnswerId      = -1;
                                        rpt5.Value         = "";
                                        #endregion
                                        rpt5.AnswerId  = int.Parse(cauhoi.M5);
                                        dtReportTotals = insertReportTotal(rpt5, dtReportTotals);
                                    }
                                    break;
                                }
                                l1++;
                            }
                            if (strType.Equals("MC"))
                            {
                                #region rpt
                                rpt6.CampaignId         = 1;
                                rpt6.SemesterId         = 1;
                                rpt6.CampaignTemplateId = iDeThiID;
                                rpt6.ClassRoomId        = getClassRoomID(stringClassRoomCode, dtClassRoom);
                                rpt6.LecturerId         = getLecturerID(stringLecturerCode, dtLecturer);
                                #region QuestionType
                                switch (strType)
                                {
                                case "SC":
                                    rpt6.QuestionType = 1;
                                    break;

                                case "MC":
                                    rpt6.QuestionType = 2;
                                    break;

                                case "SA":
                                    rpt6.QuestionType = 3;
                                    break;

                                default:
                                    rpt6.QuestionType = -1;
                                    break;
                                }
                                #endregion
                                rpt6.QuestionId    = cauhoi.CauHoiID;
                                rpt6.QuestionIndex = l;
                                rpt6.Total         = 1;
                                rpt6.AnswerId      = -1;
                                rpt6.Value         = "";
                                #endregion
                                rpt6.AnswerId  = -1;
                                rpt6.Value     = Utils.getValueTextFromDapAn(lsDapAnsText, cauhoi.CauHoiID);
                                dtReportTotals = insertReportTotal1(rpt6, dtReportTotals);
                            }
                            break;

                            #endregion
                            #region cau hoi text
                        case "SA":
                            #region rpt
                            model.reportTotal rpt = new model.reportTotal();
                            rpt.CampaignId         = 1;
                            rpt.SemesterId         = 1;
                            rpt.CampaignTemplateId = iDeThiID;
                            rpt.ClassRoomId        = getClassRoomID(stringClassRoomCode, dtClassRoom);
                            rpt.LecturerId         = getLecturerID(stringLecturerCode, dtLecturer);
                            #region QuestionType
                            switch (strType)
                            {
                            case "SC":
                                rpt.QuestionType = 1;
                                break;

                            case "MC":
                                rpt.QuestionType = 2;
                                break;

                            case "SA":
                                rpt.QuestionType = 3;
                                break;

                            default:
                                rpt.QuestionType = -1;
                                break;
                            }
                            #endregion
                            rpt.QuestionId    = cauhoi.CauHoiID;
                            rpt.QuestionIndex = l;
                            rpt.Total         = 1;
                            rpt.AnswerId      = -1;
                            rpt.Value         = "";
                            #endregion
                            rpt.AnswerId   = -1;
                            rpt.Value      = Utils.getValueTextFromDapAn(lsDapAnsText, cauhoi.CauHoiID);
                            dtReportTotals = insertReportTotal1(rpt, dtReportTotals);
                            //rpt.Value = Utils.getValueTextFromDapAn(lsDapAnsText, cauhoi.CauHoiID);
                            //dtReportTotals = insertReportTotal1(rpt, dtReportTotals);
                            break;

                            #endregion
                        default: break;
                        }
                    }
                    // Cap nhat dat xu ly
                }
                #endregion
                // Cap nhat
                foreach (var pair in dtReportTotals)
                {
                    string            Key = pair.Key;
                    model.reportTotal rpt = pair.Value;
                    data.Nuce_Survey.InsertReportTotal(rpt.SemesterId, rpt.CampaignId, rpt.CampaignTemplateId, rpt.ClassRoomId, rpt.LecturerId, rpt.QuestionType, rpt.QuestionId, rpt.QuestionIndex, rpt.AnswerId, rpt.Total, rpt.Value);
                }
                strContent          += string.Format("------ ket thuc : {0:d/M/yyyy HH:mm:ss}", DateTime.Now);
                divContent.InnerHtml = string.Format("{0} ----- Co ta ca {1} ban ghi", strContent, dtReportTotals.Count);
            }
            catch (Exception ex)
            {
                divContent.InnerHtml = ex.ToString();
            }
        }