예제 #1
0
        //更新约束
        public void  updateCheck(List <Major> list, List <CheckGrade> LC, ExamSubject examSubject, Boolean r1, Boolean r2)
        {
            //删除所有约束,再添加新约束
            string sql1 = "delete from  check_major where examSubjectNo=@examSubjectNo  ";
            string sql2 = "delete from  check_grade where examSubjectNo=@examSubjectNo  ";

            SqlParameter[] pars1 =
            {
                new SqlParameter("@examSubjectNo", SqlDbType.Int)
            };
            pars1[0].Value = examSubject.id;
            //无限制
            SqlParameter[] pars2 =
            {
                new SqlParameter("@examSubjectNo", SqlDbType.Int)
            };
            pars2[0].Value = examSubject.id;

            SqlHelper.GetExecuteNonQuery(sql2, CommandType.Text, pars1);



            SqlHelper.GetExecuteNonQuery(sql1, CommandType.Text, pars2);



            AddMajorsBoolean(list, LC, examSubject, r1, r2);
        }
예제 #2
0
        public int AddSubject(ExamSubject examSubject)
        {
            string str = "insert into ExamSubject (name,ApplyStar,ApplyEnd,ExamEnd,ExamStar,detail,examPlace,classifyName) values(@name,@ApplyStar,@ApplyEnd,@ExamStar,@ExamEnd,@detail,@examPlace,@classifyName)";

            SqlParameter[] pars =
            {
                new SqlParameter("@name",         SqlDbType.VarChar,    50),
                new SqlParameter("@ApplyStar",    SqlDbType.DateTime),
                new SqlParameter("@ApplyEnd",     SqlDbType.DateTime),
                new SqlParameter("@ExamEnd",      SqlDbType.DateTime),
                new SqlParameter("@ExamStar",     SqlDbType.DateTime),
                new SqlParameter("@detail",       SqlDbType.VarChar,   200),
                new SqlParameter("@examPlace",    SqlDbType.VarChar,   200),
                new SqlParameter("@classifyName", SqlDbType.VarChar,   200),
            };
            pars[0].Value = examSubject.name;
            pars[1].Value = examSubject.ApplyStar;
            pars[2].Value = examSubject.ApplyEnd;
            pars[4].Value = examSubject.ExamEnd;
            pars[3].Value = examSubject.ExamStar;
            pars[5].Value = examSubject.detail;
            pars[6].Value = examSubject.examPlace;
            pars[7].Value = examSubject.classifyName;
            return(SqlHelper.GetExecuteNonQuery(str, CommandType.Text, pars));
        }
예제 #3
0
        public List <Major> getCheckMajor(ExamSubject e)
        {
            string str = "select * from major where 专业编号 in ( select checkMajor from check_major where examSubjectNo=@examSubjectNo)";

            SqlParameter[] pars =
            {
                new SqlParameter("@examSubjectNo", SqlDbType.Int)
            };
            pars[0].Value = e.id;

            DataTable    da   = SqlHelper.GetTable(str, CommandType.Text, pars);
            List <Major> list = null;

            if (da.Rows.Count > 0)
            {
                Major major = null;
                list = new List <Major>();
                foreach (DataRow datarow in da.Rows)
                {
                    major = new Major();
                    LoadMajor(datarow, major);
                    list.Add(major);
                }
            }
            return(list);
        }
예제 #4
0
        public JsonResult AddSubjectBySiteAdmin(ExamSubject Data)
        {
            ResultInfo <string> ResultInfo = new ResultInfo <string>()
            {
                Status      = false,
                Description = "Failed|Login"
            };

            try
            {
                if (Data != null)
                {
                    User_Backend Obj = new User_Backend();


                    ResultInfo.Info = Obj.AddSubjectBySiteAdmin(Data);
                    if (ResultInfo.Info != null)
                    {
                        ResultInfo.Description = "Success| Insertion Sucess ";
                        ResultInfo.Status      = true;
                    }
                }
            }
            catch (Exception ex)
            {
            }

            return(Json(ResultInfo, JsonRequestBehavior.AllowGet));
        }
예제 #5
0
        public async Task <IActionResult> Edit(int id, [Bind("ExamId,StudSubjectId,Mark,Grade")] ExamSubject examSubject)
        {
            if (id != examSubject.ExamId)
            {
                return(RedirectToAction("Index", "Errors"));
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(examSubject);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ExamSubjectExists(examSubject.ExamId))
                    {
                        return(RedirectToAction("Index", "Errors"));
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["ExamId"]        = new SelectList(_context.Exam, "ExamId", "ExamDesc", examSubject.ExamId);
            ViewData["StudSubjectId"] = new SelectList(_context.StudentSubject, "StudSubjectId", "StudId", examSubject.StudSubjectId);
            return(View(examSubject));
        }
예제 #6
0
        public async Task <ActionResult> PostExam([FromBody] ExamAddViewModel exam)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            Exam examToPost = new Exam();

            examToPost.ExamId    = exam.ExamId;
            examToPost.ExamDate  = exam.ExamDate;
            examToPost.ExamCode  = exam.ExamCode;
            examToPost.FullMark  = exam.FullMark;
            examToPost.PassMark  = exam.PassMark;
            examToPost.SessionId = exam.SessionId;
            _repo.Add(examToPost);
            var save = await _repo.SaveAsync(examToPost);

            foreach (var item in exam.Subjects)
            {
                ExamSubject es = new ExamSubject();
                es.ExamId    = save.ExamId;
                es.SubjectId = item.SubjectId;
                es.Mark      = item.Mark;
                es.PassMark  = item.PassMark;
                _esRepo.Add(es);
                var esp = await _esRepo.SaveAsync(es);

                examToPost.Subjects.Add(es);
            }


            return(Ok());
        }
예제 #7
0
        /// <summary>
        /// 初始化培训场景UI
        /// </summary>
        public void initTrainUI(string equipName, string flow, TrainMode trainMode)
        {
            //tabStrip.init(1, tabStripClick);
            //tabStrip.setTabActiveState(1);
            currentEquipName      = equipName;
            this.currentTrainFlow = flow;
            this.currentTrainMode = trainMode;
            index = (int)currentTrainMode;
            dynamiclistUI.reset();
            dynamiclistUI.resetPostion();
            flowOperateMenu.initFlowMenu(flowOperateMenuClick, currentTrainMode);
            initToolMenu();
            toolMenu.canelHindTool();
            uitool.setPauseBtnClick(pauseMovie);
            uitool.setReturnBtnClick(backMenu);
            uitool.setRatateBtnClick(afreshTrain);
            uitool.setNextBtnClick(setNextClick);
            uitool.setPreBtnClick(setBackClick);
            nextProcess.setNoSwitchClick(noBtnClick);
            nextProcess.setYesSwitchClick(yesBtnClick);
            count = flowOperateMenu.getflows().Count;
            if (gradeManager == null)
            {
                gradeManager = new TLGradeManager();
            }
            ExamSubject subject = gradeManager.getExamSubject(flow);

            if (!subject.IsExam)
            {
                tabStrip.setTabDisableState(2);
            }
            //isExam = false;
            //initTrainMode(trainMode);
            popwindow.init();
        }
예제 #8
0
        public async Task <ActionResult <BaseResponse> > PostExamSubject(ExamSubject examSubject)
        {
            var datas = _context.ExamSubjects.Where(x => x.ExamName.Equals(examSubject.ExamName.Trim())).Where(y => y.MAJOR_ID.Equals(Convert.ToInt32(examSubject.MAJOR_ID))).ToList();

            if (String.IsNullOrEmpty(examSubject.ExamName) || Convert.ToInt32(examSubject.MAJOR_ID) == 0)
            {
                return(new BaseResponse
                {
                    ErrorCode = 0,
                    Messege = "Not be emty!!"
                });
            }
            else if (datas.Count != 0)
            {
                return(new BaseResponse
                {
                    ErrorCode = 2,
                    Messege = "Exam Subject already exist!!"
                });
            }
            else
            {
                _context.ExamSubjects.Add(examSubject);
                await _context.SaveChangesAsync();

                return(new BaseResponse
                {
                    ErrorCode = 1,
                    Messege = "Thêm mới thành công!!",
                    Data = CreatedAtAction("GetExamSubject", new { id = examSubject.Id }, examSubject)
                });
            }
        }
예제 #9
0
        //取得grade约束
        public List <CheckGrade> examSubjectNoToGetCheckGrade(ExamSubject examSubject)
        {
            //取要限制的科目编号

            string sql = "select * from check_grade where examSubjectNo=@examSubjectNo";

            SqlParameter[] pars =
            {
                new SqlParameter("@examSubjectNo", SqlDbType.Int)
            };
            pars[0].Value = examSubject.id;
            DataTable         da   = SqlHelper.GetTable(sql, CommandType.Text, pars);
            List <CheckGrade> list = new List <CheckGrade>();

            if (da.Rows.Count > 0)
            {
                CheckGrade check = null;
                list = new List <CheckGrade>();
                foreach (DataRow datarow in da.Rows)
                {
                    check = new CheckGrade();
                    LoadGrade(datarow, check);
                    list.Add(check);
                }
            }
            return(list);
        }
예제 #10
0
        //  查看可报考的 科目   去掉约束科目 去掉已选科目
        public List <ExamSubject> NotBKtable(BaoKao baoKao)
        {
            //string str = "select * from ExamSubject where id not in( select Eid from baokao where sid=@id)";
            string str = "select * from ExamSubject where (id not in (select * from ( sele" +
                         "ct examSubjectNo from check_grade where checkGrade not in" +
                         " (select grade from Students where id=@id) ) a where" +
                         " a.examSubjectNo in (select examSubjectNo from Check_major wh" +
                         "ere '专业名' not in (select major from Students where id=@id))) ) and (id not in( select Eid from baokao where sid=@id  ))";//andEstate!=3

            SqlParameter[] pars =
            {
                new SqlParameter("@id", SqlDbType.VarChar, 50),
            };
            pars[0].Value = baoKao.Sid;
            DataTable          da   = SqlHelper.GetTable(str, CommandType.Text, pars);
            List <ExamSubject> list = new List <ExamSubject>();

            if (da.Rows.Count > 0)
            {
                ExamSubject bk = null;
                foreach (DataRow datarow in da.Rows)
                {
                    bk = new ExamSubject();
                    LoadExamSubject(datarow, bk);
                    list.Add(bk);
                }
            }
            return(list);
        }
예제 #11
0
        public int UpdateExamSubject(ExamSubject examSubject)
        {
            string str = "update ExamSubject set name =@name,ApplyStar=@ApplyStar,ApplyEnd=@ApplyEnd," +
                         "ExamEnd=@ExamEnd,ExamStar=@ExamStar,examPlace=@examPlace,detail=@detail,classifyName=@classifyName where id=@id ";

            SqlParameter[] pars =
            {
                new SqlParameter("@name",         SqlDbType.VarChar,    50),
                new SqlParameter("@ApplyStar",    SqlDbType.DateTime),
                new SqlParameter("@ApplyEnd",     SqlDbType.DateTime),
                new SqlParameter("@ExamEnd",      SqlDbType.DateTime),
                new SqlParameter("@ExamStar",     SqlDbType.DateTime),
                new SqlParameter("@examPlace",    SqlDbType.VarChar,   200),
                new SqlParameter("@detail",       SqlDbType.VarChar,   200),
                new SqlParameter("@classifyName", SqlDbType.VarChar,   200),
                new SqlParameter("@id",           SqlDbType.Int),
            };
            pars[0].Value = examSubject.name;
            pars[1].Value = examSubject.ApplyStar;
            pars[2].Value = examSubject.ApplyEnd;
            pars[3].Value = examSubject.ExamEnd;
            pars[4].Value = examSubject.ExamStar;
            pars[5].Value = examSubject.examPlace;
            pars[6].Value = examSubject.detail;
            pars[7].Value = examSubject.classifyName;
            pars[8].Value = examSubject.id;
            return(SqlHelper.GetExecuteNonQuery(str, CommandType.Text, pars));
        }
        public ActionResult SubmitExamSubjectMarks([Bind(Include = "examSubjects")] ExamsClassesSubjectViewModel model)
        {
            if (!LoginStatus())
            {
                return(RedirectToAction("Login", "Admins", null));
            }

            if (ModelState.IsValid)
            {
                if (model.examSubjects != null)
                {
                    foreach (var item in model.examSubjects)
                    {
                        Exam    exam    = _db.Exams.Find(item.ExamId);
                        Subject subject = _db.Subjects.Find(item.SubjectId);

                        bool Exists = _db.ExamSubjects.Any(d => d.ExamId == item.ExamId && d.ExamSubjectId == item.ExamSubjectId);

                        ExamSubject addModel = new ExamSubject()
                        {
                            AvgMarks      = item.AvgMarks,
                            ExamMarks     = item.ExamMarks,
                            ExamSubjectId = item.ExamSubjectId,
                            Percentages   = item.Percentages,
                            Exam          = exam,
                            ExamId        = item.ExamId,
                            Subject       = subject,
                            SubjectId     = item.SubjectId
                        };

                        if (addModel.AvgMarks <= addModel.ExamMarks)
                        {
                            if (!Exists)
                            {
                                _db.ExamSubjects.Add(addModel);
                            }
                            else
                            {
                                _db.Entry(addModel).State = EntityState.Modified;
                            }
                        }
                        else
                        {
                            return(Json("Error: cause of some wrong information feeded."));
                        }
                        _db.SaveChanges();
                    }
                    return(Json(""));
                }
                else
                {
                    return(Json("Model is not valid."));
                }
            }
            else
            {
                return(Json("Model is not valid."));
            }
        }
        public ActionResult DeleteConfirmed(string id)
        {
            ExamSubject examSubject = db.ExamSubjects.Find(id);

            db.ExamSubjects.Remove(examSubject);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
예제 #14
0
        public void AddMajorsBoolean(List <Major> list, List <CheckGrade> LC, ExamSubject examSubject, Boolean r1, Boolean r2)
        {
            //取要限制的科目编号
            ExamSubject e = NameToGetSubject(examSubject);

            //  try
            {
                if (!r1)
                {
                    foreach (var m in list)
                    {
                        string         sql1 = "select 专业编号 from major where 专业名=@mn";
                        SqlParameter[] pars =
                        {
                            new SqlParameter("@mn", SqlDbType.VarChar, 50)
                        };
                        pars[0].Value = m.name;
                        //取要限制专业编号
                        DataTable d1 = SqlHelper.GetTable(sql1, CommandType.Text, pars);
                        //插入
                        string         sql3  = "insert into check_major(examsubjectNo,checkmajor) values(@examsubjectNo,@checkmajor)";
                        SqlParameter[] pars3 =
                        {
                            new SqlParameter("@examsubjectNo", SqlDbType.VarChar, 50),
                            new SqlParameter("@checkmajor",    SqlDbType.VarChar, 50)
                        };
                        pars3[0].Value = e.id;
                        if (d1.Rows.Count > 0)
                        {
                            pars3[1].Value = d1.Rows[0][0].ToString();
                            SqlHelper.GetExecuteNonQuery(sql3, CommandType.Text, pars3);
                        }
                    }
                }

                if (!r2)
                {
                    foreach (var m in LC)
                    {
                        string         sql3  = "insert into check_grade(examsubjectNo,checkgrade) values(@examsubjectNo,@checkgrade)";
                        SqlParameter[] pars3 =
                        {
                            new SqlParameter("@examsubjectNo", SqlDbType.VarChar, 50),
                            new SqlParameter("@checkgrade",    SqlDbType.VarChar, 50)
                        };
                        pars3[0].Value = e.id;
                        pars3[1].Value = m.grade;
                        SqlHelper.GetExecuteNonQuery(sql3, CommandType.Text, pars3);
                    }
                }
            }
            // catch
            {
                // Console.WriteLine("数据库连接失败");
            }
        }
 public ActionResult Edit([Bind(Include = "ExamSubject1,Id")] ExamSubject examSubject)
 {
     if (ModelState.IsValid)
     {
         db.Entry(examSubject).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(examSubject));
 }
예제 #16
0
 public SubjectAdd(int no)
 {
     InitializeComponent();
     Subject = new ExamSubject()
     {
         Id    = Guid.NewGuid().ToString(),
         Sort  = no,
         Grade = 1
     };
 }
예제 #17
0
        public ActionResult addExam(ExamViewModel collection)
        {
            List <ExamSubject> sublist = new List <ExamSubject>();

            foreach (long i in collection.Subjects)
            {
                ExamSubject obj = new ExamSubject()
                {
                    SubjectId = i,
                };

                if (!sublist.Contains(obj))
                {
                    sublist.Add(obj);
                }
            }


            if (!examExist(collection.Name))
            {
                DBEnt db = new DBEnt();

                string filename = Path.GetFileNameWithoutExtension(collection.Image.FileName);
                string ext      = Path.GetExtension(collection.Image.FileName);
                filename = filename + DateTime.Now.Millisecond.ToString();
                filename = filename + ext;
                string filetodb = "/Image/" + filename;
                filename = Path.Combine(Server.MapPath("~/Image/"), filename);

                collection.Image.SaveAs(filename);
                collection.Cover = filetodb;
                Exam exm = new Exam()
                {
                    Name = collection.Name, Cover = collection.Cover, MarkPerMcq = collection.MarkPerMcq, NegativeMark = collection.NegativeMark, TimeInMinutes = collection.TimeInMinutes
                };


                db.Exams.Add(exm);
                db.SaveChanges();
                foreach (ExamSubject i in sublist)
                {
                    i.ExamId = exm.Id;
                    db.ExamSubjects.Add(i);
                }
                db.SaveChanges();

                Alerts.addExam = true;
                return(RedirectToAction("addExam", "Admin"));
            }
            else
            {
                Alerts.alreadyExist = true;
                return(RedirectToAction("addExam", "Admin"));
            }
        }
예제 #18
0
        public int DeletSubject(ExamSubject examSubject)
        {
            string str = "delete ExamSubject where id=@id ";

            SqlParameter[] pars =
            {
                new SqlParameter("@id", SqlDbType.Int)
            };
            pars[0].Value = examSubject.id;
            return(SqlHelper.GetExecuteNonQuery(str, CommandType.Text, pars));
        }
        public ActionResult Create([Bind(Include = "ExamSubject1,Id")] ExamSubject examSubject)
        {
            if (ModelState.IsValid)
            {
                db.ExamSubjects.Add(examSubject);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(examSubject));
        }
 public ActionResult Edit([Bind(Include = "ExamSubjectID,ExamID,SubjectID,TestDuration,EditedAt,CreatedAt,DeletedAt")] ExamSubject examSubject)
 {
     if (ModelState.IsValid)
     {
         db.Entry(examSubject).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.ExamID    = new SelectList(db.Exams, "ExamID", "Year", examSubject.ExamID);
     ViewBag.SubjectID = new SelectList(db.Subjects, "SubjectID", "SubjectName", examSubject.SubjectID);
     return(View(examSubject));
 }
예제 #21
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            // context.Response.Write("Hello World");
            ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
            ExamSubject          examSubject          = new ExamSubject();

            examSubject.id = Convert.ToInt32(context.Request.QueryString["id"]);

            examSubjectDalServer.DeletSubject(examSubject);
            context.Response.Redirect("SubjectManage.aspx");
        }
        public ActionResult SubjectDisplay(long?id, long?examid)
        {
            if (!LoginStatus())
            {
                return(RedirectToAction("Login", "Admins", null));
            }

            ExamsClassesSubjectViewModel model = new ExamsClassesSubjectViewModel()
            {
                Exam         = _db.Exams.Find(examid),
                Classess     = _db.Classess.Find(id),
                examSubjects = new List <ExamSubject>()
            };

            List <ExamSubject> examSubjects = _db.ExamSubjects.Where(d => d.ExamId == examid).ToList();

            List <Subject> subjectList = _db.Subjects.Where(d => d.ClassesId == id).ToList();

            int totalpercentage, totalavgmarks, totalmarks;

            totalpercentage = totalavgmarks = totalmarks = 0;

            foreach (var subject in subjectList)
            {
                ExamSubject findVal = examSubjects.Where(d => d.SubjectId == subject.SubjectId && d.ExamId == examid).FirstOrDefault();

                ExamSubject addModel = new ExamSubject()
                {
                    AvgMarks      = findVal != null ? findVal.AvgMarks : 0,
                    Exam          = model.Exam,
                    ExamId        = (long)examid,
                    ExamMarks     = findVal != null ? findVal.ExamMarks : 0,
                    ExamSubjectId = findVal != null ? findVal.ExamSubjectId : 0,
                    Percentages   = findVal != null ? findVal.Percentages : 0,
                    Subject       = subject,
                    SubjectId     = subject.SubjectId
                };

                totalavgmarks += addModel.AvgMarks;
                totalmarks    += addModel.ExamMarks;

                model.examSubjects.Add(addModel);
            }
            if (totalavgmarks != 0 && totalmarks != 0)
            {
                totalpercentage = ((totalavgmarks * 100) / totalmarks);
            }
            model.TotalAvg        = totalavgmarks;
            model.TotalMarks      = totalmarks;
            model.TotalPercentage = totalpercentage;

            return(View(model));
        }
예제 #23
0
 public void LoadExamSubject(DataRow rows, ExamSubject examSubject)
 {
     examSubject.id        = Convert.ToInt32(rows["id"]);
     examSubject.name      = rows["name"] != null ?rows["name"].ToString().Trim()  : string.Empty;
     examSubject.ApplyStar = Convert.ToDateTime(rows["ApplyStar"]);
     examSubject.ApplyEnd  = Convert.ToDateTime(rows["ApplyEnd"]);
     examSubject.ExamStar  = Convert.ToDateTime(rows["ExamStar"]);
     //students.img= rows["img"] != null ? Convert.FromBase64String(rows["img"].ToString()) : Convert.FromBase64String(string.Empty);
     examSubject.ExamEnd      = Convert.ToDateTime(rows["ExamEnd"]);
     examSubject.detail       = rows["detail"] != null ? rows["detail"].ToString().Trim() : string.Empty;
     examSubject.examPlace    = rows["examPlace"] != null ? rows["examPlace"].ToString().Trim() : string.Empty;
     examSubject.classifyName = rows["classifyName"] != null ? rows["classifyName"].ToString().Trim() : string.Empty;
     //转换未字符类型后再转换为 []byte 类型   tc
 }
        // GET: ExamSubjects/Delete/5
        public ActionResult Delete(string id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ExamSubject examSubject = db.ExamSubjects.Find(id);

            if (examSubject == null)
            {
                return(HttpNotFound());
            }
            return(View(examSubject));
        }
        public async Task <IActionResult> PutExamSubject(int id, ExamSubject examSubjec_updatet)
        {
            var Exam = await _context.ExamSubjects.FindAsync(id);

            if (Exam == null)
            {
                return(NotFound());
            }

            Exam.ExamName = examSubjec_updatet.ExamName;

            _context.ExamSubjects.Update(Exam);
            await _context.SaveChangesAsync();

            return(Ok(Exam));
        }
        // GET: Admin/ExamSubjects/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ExamSubject examSubject = db.ExamSubjects.Find(id);

            if (examSubject == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ExamID    = new SelectList(db.Exams, "ExamID", "Year", examSubject.ExamID);
            ViewBag.SubjectID = new SelectList(db.Subjects, "SubjectID", "SubjectName", examSubject.SubjectID);
            return(View(examSubject));
        }
예제 #27
0
        public List <ExamSubject> GetTable()
        {
            string str = "select * from ExamSubject";

            DataTable          da   = SqlHelper.GetTable(str, CommandType.Text);
            List <ExamSubject> list = new List <ExamSubject>();

            if (da.Rows.Count > 0)
            {
                list = new List <ExamSubject>();
                ExamSubject bk = null;
                foreach (DataRow datarow in da.Rows)
                {
                    bk = new ExamSubject();
                    LoadExamSubject(datarow, bk);
                    list.Add(bk);
                }
            }
            return(list);
        }
예제 #28
0
        public ExamSubject GetSubject(ExamSubject examSubject)
        {
            string str = "select * from ExamSubject where id=@id";

            SqlParameter[] pars =
            {
                new SqlParameter("@id", SqlDbType.Int)
            };
            pars[0].Value = examSubject.id;
            ExamSubject ex = new ExamSubject();
            DataTable   da = SqlHelper.GetTable(str, CommandType.Text, pars);

            if (da.Rows.Count > 0)
            {
                foreach (DataRow datarow in da.Rows)
                {
                    LoadExamSubject(datarow, ex);
                }
            }
            return(ex);
        }
예제 #29
0
        public async Task <ActionResult <BaseResponse> > PutExamSubject(int id, ExamSubject examSubjec_updatet)
        {
            var datas = _context.ExamSubjects.Where(x => x.ExamName.Equals(examSubjec_updatet.ExamName.Trim())).Where(y => y.MAJOR_ID.Equals(Convert.ToInt32(examSubjec_updatet.MAJOR_ID))).ToList();
            var Exam  = await _context.ExamSubjects.FindAsync(id);

            if (Exam == null)
            {
                return(NotFound());
            }
            else if (String.IsNullOrEmpty(examSubjec_updatet.ExamName) || Convert.ToInt32(examSubjec_updatet.MAJOR_ID) == 0)
            {
                return(new BaseResponse
                {
                    ErrorCode = 0,
                    Messege = "Not be emty!!"
                });
            }
            else if (datas.Count != 0)
            {
                return(new BaseResponse
                {
                    ErrorCode = 2,
                    Messege = "Exam Subject already exist!!"
                });
            }
            else
            {
                Exam.MAJOR_ID = examSubjec_updatet.MAJOR_ID;
                Exam.ExamName = examSubjec_updatet.ExamName;

                _context.ExamSubjects.Update(Exam);
                await _context.SaveChangesAsync();

                return(new BaseResponse
                {
                    ErrorCode = 1,
                    Messege = "Update thành công!!"
                });
            }
        }
예제 #30
0
        public void getCheckGrade(ExamSubject e)
        {
            List <CheckGrade> list = examSubjectDalServer.getCheckGrade(e);
            string            str  = "";

            //
            if (list == null)
            {
            }
            else
            {
                foreach (var l in list)
                {
                    str = l.grade + "</br>" + str;
                }
            }
            if (str.Equals(""))
            {
                str = "无年级限制";
            }
            Response.Write(str);
        }