public ActionResult Create(int SemesterID, int GradeID, int MajorID, string[] SemesterCourseNumber, string[] SemesterCourseName, CourseType[] CourseType)
{
if (ModelState.IsValid)
{
int semesterCourseNumberCount = SemesterCourseNumber.Count(x => !string.IsNullOrEmpty(x));
int semesterCourseNameCount = SemesterCourseName.Count(x => !string.IsNullOrEmpty(x));
int courseTypeCount = CourseType.Count();
var validateLenth = Math.Min(semesterCourseNumberCount, semesterCourseNameCount);
var _gradMajor = db.GradeMajors.SingleOrDefault(x => x.GradeID == GradeID && x.MajorID == MajorID);
if (_gradMajor == null)
{
return(HttpNotFound());
}
else
{
for (int i = 0; i < validateLenth; i++)
{
var semesterCourseUpdate = new SemesterCourse();
semesterCourseUpdate.SemesterID = SemesterID;
semesterCourseUpdate.GradeMajorID = _gradMajor.GradeMajorID;
semesterCourseUpdate.SemesterCourseNumber = SemesterCourseNumber[i];
semesterCourseUpdate.SemesterCourseName = SemesterCourseName[i];
semesterCourseUpdate.CourseType = CourseType[i];
semesterCourseUpdate.AuthorName = User.Identity.GetUserName();
semesterCourseUpdate.PostTime = DateTime.Now;
db.SemesterCourses.Add(semesterCourseUpdate);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Index"));
}
public ActionResult Create(int GradeID, int MajorID, string[] SchoolClassName, int[] StudentNumber)
{
if (ModelState.IsValid)
{
// int classNameCount = SchoolClassName.Count();
//int classStudentNumberCount = StudentNumber.Count();
var validateLenth = SchoolClassName.Count(x => !string.IsNullOrEmpty(x));
var _gradMajor = db.GradeMajors.SingleOrDefault(x => x.GradeID == GradeID && x.MajorID == MajorID);
if (_gradMajor == null)
{
return(HttpNotFound());
}
else
{
for (int i = 0; i < validateLenth; i++)
{
var schoolClassUpdate = new SchoolClass();
schoolClassUpdate.GradeMajorID = _gradMajor.GradeMajorID;
schoolClassUpdate.SchoolClassName = SchoolClassName[i];
schoolClassUpdate.StudentNumber = StudentNumber[i];
db.SchoolClasses.Add(schoolClassUpdate);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Index"));
}
public override void OnActionExecuted(ActionExecutedContext filterContext)
{
// TeachingMaterialDbContext db=filterContext.Controller
// TeachingMaterialDbContext db = filterContext.HttpContext.GetOwinContext().Get<TeachingMaterialDbContext>();
foreach (var gradeItem in db.Grades.Include(x => x.GradeMajors).ToList())
{
int _gradeStudentNumber = 0;
if (gradeItem.GradeMajors != null)
{
foreach (var gradeMajorItem in gradeItem.GradeMajors)
{
_gradeStudentNumber += gradeMajorItem.GradeMajorStudentNumber;
/* if (gradeMajorItem.SchoolClasses != null)
* {
* foreach (var classItem in gradeMajorItem.SchoolClasses)
* {
* _gradeStudentNumber += classItem.StudentNumber;
* }
*
* } */
}
gradeItem.GradeStudentNumber = _gradeStudentNumber;
db.SaveChanges();
}
}
foreach (var majorItem in db.Majors.Include(m => m.GradeMajors).ToList())
{
int _majorStudentNumber = 0;
if (majorItem.GradeMajors != null)
{
foreach (var gradeMajorItem in majorItem.GradeMajors)
{
_majorStudentNumber += gradeMajorItem.GradeMajorStudentNumber;
/* if (gradeMajorItem.SchoolClasses != null)
* {
* foreach (var classItem in gradeMajorItem.SchoolClasses)
* {
* _gradeStudentNumber += classItem.StudentNumber;
* }
*
* } */
}
majorItem.MajorStudentNumber = _majorStudentNumber;
db.SaveChanges();
}
}
base.OnActionExecuted(filterContext);
}
public ActionResult Create([Bind(Include = "DepartmentName,DepartmentLocation")] Department department)
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "NoticeTitle,Content,AuthorName,PostTime,NoticeIsShow,PriorOrder,ClickCount")] Notice notice)
{
if (ModelState.IsValid)
{
db.Notices.Add(notice);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(notice));
}
public ActionResult Create([Bind(Include = "BookTypeName")] BookType bookType)
{
if (ModelState.IsValid)
{
db.BookTypes.Add(bookType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bookType));
}
public ActionResult Create([Bind(Include = "BookID,BookName,ISBN,AuthorName,Press,PublishingDate,Price,BookTypeID")] Book book)
{
if (ModelState.IsValid)
{
db.Books.Add(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BookTypeID = new SelectList(db.BookTypes, "BookTypeID", "BookTypeName", book.BookTypeID);
return(View(book));
}
public ActionResult Create([Bind(Include = "GradeID,MajorID,GradeMajorIsValidate")] GradeMajor gradeMajor) //因为创建视图返回回来的为空，所有不要绑定GradeMajorID
{
if (ModelState.IsValid)
{
db.GradeMajors.Add(gradeMajor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// ViewBag.GradeID = new SelectList(db.Grades, "GradeID", "GradeName", gradeMajor.GradeID);
//ViewBag.MajorID = new SelectList(db.Majors, "MajorID", "MajorName", gradeMajor.MajorID);
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "SemesterName,StartDateOfSubscription,OverDateOfSubscription,SwitchOfSubscription,IsCurrentSemester")] Semester semester)
{
if (ModelState.IsValid)
{
if (semester.StartDateOfSubscription < semester.OverDateOfSubscription)
{
ModelState.AddModelError("", "开始日期不能小于结束日期");
}
db.Semesters.Add(semester);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//PartialView("_AddSemester.Modal.Preview", semester);
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "GradeName,GradeIsValidate")] Grade grade) //如果在绑定白名单 中有GradeID，从模态框中返回的空值将绑定失败。
{
if (ModelState.IsValid)
{
db.Grades.Add(grade);
db.SaveChanges();
return(RedirectToAction("Index"));
}
if (Request.UrlReferrer != null)
{
var returnUrl = Request.UrlReferrer.ToString();
return(new RedirectResult(returnUrl)); //由于使用的是隐藏表单提交而非Ajax无刷新异步提交。所以使用jquery将表单提交到控制器后，返回Request.UrlReferrer返回到上一个页面将是数据库更新后的状态。
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "MajorName,DepartmentID")] Major major) //以前在Create 方法中包含了MajorID,而Create方法中的majorID值为空，因此，始终模型绑定不成功。有了它还导致了绑定失败；
{
if (ModelState.IsValid)
{
db.Majors.Add(major);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepartmentName", major.DepartmentID);
if (Request.UrlReferrer != null)
{
var returnUrl = Request.UrlReferrer.ToString();
return(new RedirectResult(returnUrl)); //由于使用的是隐藏表单提交而非Ajax无刷新异步提交。所以使用jquery将表单提交到控制器后，返回Request.UrlReferrer返回到上一个页面将是数据库更新后的状态。
}
return(RedirectToAction("Index"));
}
/*
* //模态框取得的专业列表，一旦模态框中部门变动，返回专业
* [HttpGet]
* public JsonResult GetModalMajorList(int gradeID, int? departmentID)
* {
* var _majorList = from m in db.GradeMajors.Include(x => x.Major)
* where m.GradeID == gradeID && m.GradeMajorIsValidate == true
* select m.Major;
*
* _majorList = _majorList.Distinct().OrderBy(x => x.MajorID);
*
* if (departmentID != null)
* {
* _majorList = _majorList.Where(x => x.DepartmentID == departmentID);
* }
*
* var _majors = from m in _majorList
* select new { majorID = m.MajorID, majorName = m.MajorName };
* return Json(_majors.ToList(), JsonRequestBehavior.AllowGet);
*
* }
*/
//批量设置需要或不需要征订学生教材。适用于批准设置需要 教材 和批量设置不需要教材 两种选择。
public int MassSetNeedStudentBook(bool expected = true, params int[] selectedIds) //必须为int型，负责find()会出现主键的类型不匹配
{
int number = 0;
if (selectedIds != null)
{
foreach (var semesterCourseId in selectedIds)
{
var semesterCourse = db.SemesterCourses.Find(semesterCourseId);
if (semesterCourse != null)
{
if (expected)
{
if (semesterCourse.IsNeedStudentBook != true)
{
semesterCourse.IsNeedStudentBook = true;
number++;
}
}
else
{
if (semesterCourse.IsNeedStudentBook != false)
{
semesterCourse.IsNeedStudentBook = false;
number++;
var alreadyBookSubscription = semesterCourse.BookSubscriptions.Where(x => x.SubscriptionType == SubscriptionType.学生教材);
if (alreadyBookSubscription != null) //如果存在与该 课程关联的订单。
{
db.BookSubscriptions.RemoveRange(alreadyBookSubscription); //删除该课程对应的所有订单。
}
}
}
db.SaveChanges();
}
}
}
return(number);
}
public int GenerateSchoolClassBookOrder(int?semesterIDParam)
{
int count = 0;
if (semesterIDParam == null)
{
return(0);
}
var currentSemester = db.Semesters.Single(x => x.SemesterID == semesterIDParam);
if (currentSemester == null)
{
return(0);
}
if (!currentSemester.IsCurrentSemester)
{
return(0);
}
var exitSchoolClassBookOrder = db.SchoolClassBookOrders.Where(x => x.BookSubscription.SemesterCourse.SemesterID == semesterIDParam); //找出已经存在的班级订单，全部删除；
db.SchoolClassBookOrders.RemoveRange(exitSchoolClassBookOrder);
var exitMajorTeacherBookOrder = db.TeacherBookOrders.Where(x => x.BookSubscription.SemesterCourse.SemesterID == semesterIDParam);
db.TeacherBookOrders.RemoveRange(exitMajorTeacherBookOrder);
var subscritpion = db.BookSubscriptions.Include(x => x.SemesterCourse).Include(x => x.Book).Where(x => x.SemesterCourse.SemesterID == semesterIDParam); //找出所有的原始订单。
foreach (var subItem in subscritpion)
{
var gradeMajorItem = db.GradeMajors.Include(x => x.SchoolClasses).Single(x => x.GradeMajorID == subItem.SemesterCourse.GradeMajorID);
if (gradeMajorItem != null)
{
if (subItem.SubscriptionType == SubscriptionType.学生教材)
{
foreach (var classItem in gradeMajorItem.SchoolClasses)
{
db.SchoolClassBookOrders.Add(
new SchoolClassBookOrder
{
SchoolClassID = classItem.SchoolClassID,
BookSubscriptionID = subItem.BookSubscriptionID,
GenerateTime = DateTime.Now,
//为了使电子表格导出数据，添加了冗余列。
SemesterName = subItem.SemesterName,
GradeName = subItem.GradeName,
DepartmentName = subItem.DepartmentName,
MajorName = subItem.MajorName,
SchoolClassName = classItem.SchoolClassName, //班级名称
SemesterCourseNumber = subItem.SemesterCourseNumber,
SemesterCourseName = subItem.SemesterCourseName,
BookName = subItem.BookName,
AuthorName = subItem.AuthorName,
ISBN = subItem.ISBN,
Press = subItem.Press,
PublishingDate = subItem.PublishingDate,
Price = subItem.Price,
BookSubscriptionNumber = classItem.StudentNumber, //订单数量等于班级人数
BookTypeName = subItem.BookTypeName,
SubscriptionTypeName = subItem.BookTypeName,
SubscriptionPrice = subItem.SubscriptionPrice
});
}
}
else if (subItem.SubscriptionType == SubscriptionType.教师用书)
{
db.TeacherBookOrders.Add(new TeacherBookOrder()
{
MajorID = gradeMajorItem.MajorID, BookSubscriptionID = subItem.BookSubscriptionID,
GenerateTime = DateTime.Now
});
}
count += db.SaveChanges();
}
}
return(count);
}
