public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Info")] SubjectsModel subjectsModel) { if (id != subjectsModel.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(subjectsModel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SubjectsModelExists(subjectsModel.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(subjectsModel)); }
public ActionResult DeleteSubjectRecords(IEnumerable <Guid> deletesub, string hiddenInput) { if (deletesub != null && hiddenInput != "") { string result = SubjectsModel.DeleteSubjects(deletesub); if (result == "OK") { return(RedirectToAction("ManageSubjects", "Subjects", new { res = SherlockHolmesEncryptDecrypt.Encrypt("S") })); } else { return(RedirectToAction("ManageSubjects", "Subjects", new { res = SherlockHolmesEncryptDecrypt.Encrypt(result) })); } } else { return(RedirectToAction("ManageSubjects", "Subjects", new { res = SherlockHolmesEncryptDecrypt.Encrypt("Plz Select Records To Delete!") })); } }
public SubjectViewModel() { this.context = new TimetableCourseProject(); context.Subjects.Load(); SubjectsDatabase = context.Subjects.Local; Subjects = new ObservableCollection <Subjects>(SubjectsDatabase); subjectsModel = new SubjectsModel(); }
public async Task <IActionResult> Post(SubjectsModel employeeModel) { if (ModelState.IsValid) { await _repo.Insert(employeeModel); return(Ok()); } return(BadRequest()); }
public async Task <IActionResult> Create(SubjectsModel employeeModel) { if (ModelState.IsValid) { await _repo.Insert(employeeModel); return(RedirectToAction(nameof(Index))); } return(View(employeeModel)); }
public async Task <IActionResult> Create([Bind("Id,Name,Info")] SubjectsModel subjectsModel) { if (ModelState.IsValid) { _context.Add(subjectsModel); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(subjectsModel)); }
private void subjectsAdd_Method(object obj) { if (IsValid(ValidatesAddProperties, out AddErrors)) { AddErrors += subjectsModel.Add(SubjectsModel.getSubjectObject(AddShortName, AddFullName)); MessageBox.Show(AddErrors, "Результат добавления"); FilterSubjects(); } else { MessageBox.Show("Заполните поля корректно!", "Результат добавления"); } }
/// <summary> /// 在班级内按单科排名 /// </summary> /// <param name="check">是否降序</param> /// <param name="classmodel">班级实体对象</param> /// <param name="submodel"></param> /// <returns></returns> public DataTable OrderBySingleClass(bool check, ClassesModel classmodel, SubjectsModel submodel) { string sql = ""; if (check == false) { sql = "select d.Classes_Name 班级名称,c.Subjects_Name 科目名称,b.StudentNum 学号,b.Student_Name 姓名,a.ExamScore 成绩 from Examination a join Students b on a.StudentID=b.Student_ID join Subjects c on a.SubjectsID=c.Subjects_ID join Classes d on b.StudentClass=d.Classes_ID where d.Classes_ID=@0 and c.Subjects_ID=@1 order by a.Examscore asc"; } else { sql = "select d.Classes_Name 班级名称,c.Subjects_Name 科目名称,b.StudentNum 学号,b.Student_Name 姓名,a.ExamScore 成绩 from Examination a join Students b on a.StudentID=b.Student_ID join Subjects c on a.SubjectsID=c.Subjects_ID join Classes d on b.StudentClass=d.Classes_ID where d.Classes_ID=@0 and c.Subjects_ID=@1 order by a.Examscore desc"; } return(SqlHelper.GetDataTable(sql, classmodel.Classes_ID, submodel.Subjects_ID)); }
private void btnAddke_Click(object sender, EventArgs e) { SubjectsBLL subject = new SubjectsBLL(); SubjectsModel model = new SubjectsModel(); if (string.IsNullOrEmpty(this.txtkeName.Text)) { MessageBox.Show("学科名称不能为空"); return; } model.Subjects_Name = this.txtkeName.Text; subject.AddSubjects(model); GetAllSubject(); }
public async Task <IActionResult> Edit(string id, SubjectsModel employeeModel) { if (id != employeeModel.ID) { return(NotFound()); } if (ModelState.IsValid) { await _repo.Update(employeeModel); return(RedirectToAction(nameof(Index))); } return(View(employeeModel)); }
public async Task <IActionResult> Put(SubjectsModel employeeModel) { if (string.IsNullOrEmpty(employeeModel.ID)) { return(BadRequest()); } if (ModelState.IsValid) { await _repo.Update(employeeModel); return(Ok(employeeModel)); } return(BadRequest()); }
private void benDeleke_Click(object sender, EventArgs e) { SubjectsBLL subject = new SubjectsBLL(); SubjectsModel model = new SubjectsModel(); if (this.dataxueke.SelectedRows.Count > 0) { int ID = Convert.ToInt32(this.dataxueke.SelectedRows[0].Cells["科目编号"].Value); model.Subjects_ID = ID; try { subject.DeleSubjects(model); GetAllSubject(); } catch { MessageBox.Show("删除失败"); } } }
private void subjectsRemove_Method(object obj) { if (editButtonContent.Equals("Изменить")) { if (IsValid(ValidatesChangeProperties, out ChangeErrors)) { ChangeErrors = subjectsModel.Remove(SubjectsModel.getSubjectObject(changeShortName, changeFullName)); MessageBox.Show(ChangeErrors, "Результат удаления"); FilterSubjects(); } else { MessageBox.Show("Заполните корректно поля!", "Результат удаления"); } } else { MessageBox.Show("Для удаления отмените операцию \"Изменение\" нажав на кнопку\"Отмена\"", "", MessageBoxButton.OK, MessageBoxImage.Exclamation); } }
private void subjectsChange_Method(object obj) { if (editButtonContent.Equals("Изменить")) { if (IsValid(ValidatesChangeProperties, out ChangeErrors)) { if (subjectsModel.IsExist(SubjectsModel.getSubjectObject(changeShortName, changeFullName))) { EditButtonContent = "Сохранить"; CancelVisibility = Visibility.Visible; changedSubject = SubjectsModel.getSubjectObject(changeShortName, changeFullName); return; } else { MessageBox.Show("Изменяемого объекта не существует", "Результат изменения"); } } else { MessageBox.Show("Заполните корректно поля!", "Результат Изменения"); } } else if (editButtonContent.Equals("Сохранить")) { if (IsValid(ValidatesChangeProperties, out ChangeErrors)) { ChangeErrors += subjectsModel.Change(changedSubject, SubjectsModel.getSubjectObject(changeShortName, changeFullName)); MessageBox.Show(ChangeErrors, "Результат изменения"); EditButtonContent = "Изменить"; CancelVisibility = Visibility.Collapsed; FilterSubjects(); } else { MessageBox.Show("Заполните корректно поля!", "Результат изменения"); } } }
public ActionResult AddSubjectRecords(Subject sub, string degree) { if (ModelState.IsValid) { string result = SubjectsModel.AddSubject(sub); if (result == "OK") { ViewBag.Message = "Successfully Record Added"; return(View()); } else { ViewBag.Message = "Error! " + result; return(View()); } } else { ViewBag.Message = "Error! Unable to Add Record!"; return(View()); } }
/// <summary> /// 在专业内按单科排名 /// </summary> /// <param name="check"></param> /// <param name="classmodel"></param> /// <param name="submodel"></param> /// <returns></returns> public DataTable OrderBySingleSpeciality(bool check, SpecialityModel spemodel, SubjectsModel submodel) { string sql = ""; if (check == false) { sql = "select b.Student_Name 学生姓名,b.StudentNum 学号,e.Speciality_Name 专业名称,c.Subjects_Name 科目名称,a.ExamScore 成绩 from Examination a join Students b on a.StudentID = b.Student_ID join Subjects c on a.SubjectsID = c.Subjects_ID join Classes d on b.StudentClass = d.Classes_ID join Speciality e on d.Classes_Speciality = e.Speciality_ID where Speciality_ID = @0 and c.Subjects_ID = @1 order by a.ExamScore asc"; } else { sql = "select b.Student_Name 学生姓名,b.StudentNum 学号,e.Speciality_Name 专业名称,c.Subjects_Name 科目名称,a.ExamScore 成绩 from Examination a join Students b on a.StudentID = b.Student_ID join Subjects c on a.SubjectsID = c.Subjects_ID join Classes d on b.StudentClass = d.Classes_ID join Speciality e on d.Classes_Speciality = e.Speciality_ID where Speciality_ID = @0 and c.Subjects_ID = @1 order by a.ExamScore desc"; } return(SqlHelper.GetDataTable(sql, spemodel.Speciality_ID, submodel.Subjects_ID)); }
/// <summary> /// 添加科目的数据访问方法 /// </summary> /// <param name="model">科目的实体对象</param> public void AddSubjects(SubjectsModel model) { string sql = "insert into Subjects values(@0)"; SqlHelper.ExNonQuery(sql, "添加科目", model.Subjects_Name); }
/// <summary> /// 删除科目的数据访问方法 /// </summary> /// <param name="model">科目的实体对象</param> public void DeleSubject(SubjectsModel model) { string sql = "delete Subjects where Subjects_ID=@0"; SqlHelper.ExNonQuery(sql, "删除科目", model.Subjects_ID); }
/// <summary> /// 删除科目业务 /// </summary> /// <param name="model">科目的实体对象</param> public void DeleSubjects(SubjectsModel model) { SubjectsDAL subject = new SubjectsDAL(); subject.DeleSubject(model); }
/// <summary> /// 在班级内按单科排名 /// </summary> /// <param name="check">是否降序</param> /// <param name="classmodel">班级实体对象</param> /// <param name="submodel"></param> /// <returns></returns> public DataTable OrderBySingleClass(bool check, ClassesModel classmodel, SubjectsModel submodel) { return(exam.OrderBySingleClass(check, classmodel, submodel)); }
/// <summary> /// 在专业内按单科排名 /// </summary> /// <param name="check"></param> /// <param name="specmodel"></param> /// <param name="submodel"></param> /// <returns></returns> public DataTable OrderBySingleSpeciality(bool check, SpecialityModel specmodel, SubjectsModel submodel) { return(exam.OrderBySingleSpeciality(check, specmodel, submodel)); }
/// <summary> /// 添加科目业务 /// </summary> /// <param name="model">科目的实体对象</param> public void AddSubjects(SubjectsModel model) { SubjectsDAL subject = new SubjectsDAL(); subject.AddSubjects(model); }