public ActionResult Index()
        {
            //check login
            if (!IsLogged())
            {
                return(BackToLogin());
            }
            daotao_taolopModels        param         = new daotao_taolopModels();
            List <daotao_taolopModels> lstResult_lop = new List <daotao_taolopModels>();
            SaudaotaoServices          service_lop   = new SaudaotaoServices();

            if (Session["thudientu"].ToString().Trim() == "1" || Session["loginid"].ToString().Trim() == "admin")
            {
                param.email = "";
            }
            else
            {
                param.email = Session["thudientu"].ToString();
            }

            lstResult_lop = service_lop.SelectRows_Laydslopdaotao(param);

            StringBuilder sblophoc = new StringBuilder();

            foreach (var item in lstResult_lop)
            {
                sblophoc.Append(string.Format("<option value='{0}'>{1}</option>", item.malop, item.tenlop));
            }
            ViewBag.sblophoc = sblophoc.ToString();
            return(View());
        }
        public ActionResult Createtrainning(string idmalophc)
        {
            if (!IsLogged())
            {
                return(BackToLogin());
            }

            daotao_taolopModels        param         = new daotao_taolopModels();
            List <daotao_taolopModels> lstResult_lop = new List <daotao_taolopModels>();
            SaudaotaoServices          service_lop   = new SaudaotaoServices();

            param.email   = Session["thudientu"].ToString();
            lstResult_lop = service_lop.SelectRows_Laydslophoctheo_nhanvien(param);

            if (idmalophc == null)
            {
                StringBuilder sblophoc = new StringBuilder();
                sblophoc.Append(string.Format("<option value='{0}'>{1}</option>", "0", "Chọn tên lớp học"));
                foreach (var item in lstResult_lop)
                {
                    sblophoc.Append(string.Format("<option value='{0}'>{1}</option>", item.malop, item.tenlop));
                }
                ViewBag.sblophoc = sblophoc.ToString();
            }
            else
            {
                StringBuilder sblophoc = new StringBuilder();
                foreach (var item in lstResult_lop.Where(p => p.malop == int.Parse(idmalophc.Trim())))
                {
                    sblophoc.Append(string.Format("<option value='{0}'>{1}</option>", item.malop, item.tenlop));
                }
                ViewBag.sblophoc = sblophoc.ToString();
            }

            //phong ban
            PhongBanModels        parampb            = new PhongBanModels();
            DanhmucServices       service            = new DanhmucServices();
            List <PhongBanModels> lstResult_phongban = service.SelectRows(parampb);
            StringBuilder         sbphongban         = new StringBuilder();

            foreach (var item in lstResult_phongban)
            {
                sbphongban.Append(string.Format("<option value={0}>{1}</option>", item.maphongban, item.tenphongban));
            }
            ViewBag.sbphongban = sbphongban.ToString();



            return(View());
        }
        public JsonResult Save(string DataJson)
        {
            JsonResult        Data       = new JsonResult();
            SaudaotaoServices servicevpp = new SaudaotaoServices();
            string            nguoitao   = Session["userid"].ToString();
            string            iresult    = servicevpp.Save_ykiensaodautao(DataJson, nguoitao, matiepnhan);

            if (iresult != "-1")
            {
                matiepnhan = iresult;
                return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
            }
            else
            {
                return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
            }
        }
        public JsonResult SelectRows_Danhsachdanhgiasaudaotao(daotao_ykiensaodaotaoModels model, int curentPage)
        {
            daotao_ykiensaodaotaoModels param   = new daotao_ykiensaodaotaoModels();
            SaudaotaoServices           service = new SaudaotaoServices();

            param.nguoitao = int.Parse(Session["userid"].ToString());
            param.malop    = model.malop;
            int tongsodong = service.CountRows_Danhsachdanhgiasaudaotao(param);
            int sotrang    = 1;

            if (tongsodong > 30)
            {
                if (tongsodong % 30 > 0)
                {
                    sotrang = (tongsodong / 30) + 1;
                }
                else
                {
                    sotrang = (tongsodong / 30);
                }
            }

            int trangbd = 1; int trangkt = 30;

            if (curentPage != 1 && curentPage <= sotrang)
            {
                trangbd = (trangkt * (curentPage - 1)) + 1;
                trangkt = trangkt * curentPage;
            }

            List <daotao_ykiensaodaotaoModels> lstResult = new List <daotao_ykiensaodaotaoModels>();

            if (curentPage <= sotrang)
            {
                lstResult = service.SelectRows_Danhsachdanhgiasaudaotao(param, trangbd, trangkt);
            }
            else if (curentPage != 1 && curentPage > sotrang)
            {
                curentPage = curentPage - 1;
            }


            StringBuilder sbResult = new StringBuilder();
            StringBuilder sbRows   = new StringBuilder();
            int           tongdong = 0;

            if (lstResult.Count > 0)
            {
                string strSTT = "";
                int    i      = trangbd;

                foreach (var item in lstResult)
                {
                    strSTT = i.ToString();
                    sbRows.Append(PrepareDataJson_Danhsachdanhgiasaudaotao(item, strSTT));
                    i++;
                }
                tongdong = i - 1;
                if (sbRows.Length > 0)
                {
                    sbRows.Remove(sbRows.Length - 1, 1);
                }
            }
            if (tongsodong == 0)
            {
                sotrang = 0;
            }
            sbResult.Append("{");
            sbResult.Append("\"isHeader\":\"" + "111" + "\",");

            sbResult.Append("\"tongdong\":\"" + "" + tongsodong + "" + "\",");

            sbResult.Append("\"Pages\":\"" + "" + sotrang + "" + "\",");
            sbResult.Append("\"SubRow\":\"" + "false" + "\",");

            sbResult.Append("\"data\":[" + sbRows.ToString() + "]");
            sbResult.Append("}");

            return(Json(sbResult.ToString(), JsonRequestBehavior.AllowGet));
        }