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);
}
