//更新约束 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); }
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)); }
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); }
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)); }
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)); }
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()); }
/// <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(); }
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) }); } }
//取得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); }
// 查看可报考的 科目 去掉约束科目 去掉已选科目 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); }
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")); }
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)); }
public SubjectAdd(int no) { InitializeComponent(); Subject = new ExamSubject() { Id = Guid.NewGuid().ToString(), Sort = no, Grade = 1 }; }
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")); } }
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)); }
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)); }
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)); }
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); }
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); }
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!!" }); } }
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); }