public static List <IES.JW.Model.User> ClassUserHistory_List(int TeachingClassID, string Key, int PageIndex, int PageSize) { TeachingClass model = new TeachingClass { TeachingClassID = TeachingClassID, Key = Key }; return(new MyGroupBLL().ClassUserHistory_List(model, PageIndex, PageSize)); }
protected override void Seed(EntityFramework_Demo.DAL.MyContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. //--------- //Adding Classes var Clss = new TeachingClass() { ClassName = "Class A" }; context.TeachingClasses.AddOrUpdate(Clss); context.TeachingClasses.AddOrUpdate(new TeachingClass() { ClassName = "Class B" }); context.SaveChanges(); //--------- //Adding Students context.Students.Add(new Student() { StudentName = "Anas", Age = 40, TeachingClassId = Clss.Id }); var Std2 = new Student() { StudentName = "Mohammad", Age = 30, TeachingClassId = Clss.Id }; context.Students.Add(Std2); context.Students.Add(new Student() { StudentName = "Bisher", Age = 30, TeachingClassId = Clss.Id }); context.SaveChanges(); //--------- //Adding Homeworks context.Homework.Add(new Homework() { Title = "homework 1", StudentId = Std2.StudentId, }); context.Homework.Add(new Homework() { Title = "homework 2", StudentId = Std2.StudentId, }); context.Homework.Add(new Homework() { Title = "homework 3", StudentId = Std2.StudentId, }); context.SaveChanges(); //--------- }
//public ActionResult CheckSubjectSlotAvialability(string subject, string level, string StartHourclinet, string StartMinuteclinet) public ActionResult CheckDaySlotAvialability(string levels) { //var theValue = $('#Subject').val() + ";" + $('#Class').val() + ";" + $('#StratTimeHour').val() + ";" + $('#StratTimeMinute').val() + ";" + $('#Teacher').val() + ";" + $('#Day').val(); string[] theLEvel = levels.Split(';'); string subject = theLEvel[0]; string level = theLEvel[1]; string StartHourclinet = theLEvel[2]; string StartMinuteclinet = theLEvel[3]; string day1 = theLEvel[5]; // string day1 = theLEvel[5]; Day day = DayHelper.GetDay(day1); smContext db = new smContext(); List <TeachingDay> theTeachingDay = db.TeachingDay.Include("TeachingSubject").Where(a => a.TeachingClass.ClassName == level && a.theDay == day).ToList(); foreach (TeachingDay td in theTeachingDay) { TeachingClass theTeachingClass = db.TeachingClass.Where(a => a.TeachingClassID == td.TeachingClassID).First(); string theClass = theTeachingClass.ClassName; // string theClass = td.TeachingClass.ClassName; foreach (TeachingSubject ts in td.TeachingSubject) { String Day = ts.TeachingDay.theDay.ToString(); string theSubject = ts.SubjectName; string EndHour = ts.TeachingDay.EndTimeHour; string EndMinutes = ts.TeachingDay.EndTimeMinute; string StartHour = ts.TeachingDay.StratTimeHour; string StartMinutes = ts.TeachingDay.StratTimeMinute; StringBuilder EndHourEndMinutes = new StringBuilder(); EndHourEndMinutes.Append(EndHour); EndHourEndMinutes.Append(EndMinutes); int time = Convert.ToInt16(EndHourEndMinutes.ToString()); //= Convert.ToInt16(EndHour) + Convert.ToInt16(EndMinutes); StringBuilder StartHourStartMinuteclinets = new StringBuilder(); StartHourStartMinuteclinets.Append(StartHourclinet).Append(StartMinuteclinet); int timeClient = Convert.ToInt16(StartHourStartMinuteclinets.ToString());//Convert.ToInt16(StartHourclinet) + Convert.ToInt16(StartMinuteclinet); if (timeClient < time) { string theAlert = theSubject + " has been fixed for " + theClass + " which starts " + StartHour + ":" + StartMinutes + " ends at " + EndHour + ":" + EndMinutes; return(Json(theAlert, JsonRequestBehavior.AllowGet)); } } } // } return(Json("", JsonRequestBehavior.AllowGet)); }
//获取历史班级下的学生 public static List<User> ClassUserHistory_List(TeachingClass model, int PageIndex, int PageSize) { try { using (var conn = DbHelper.CCService()) { var p = new DynamicParameters(); p.Add("@Key", model.Key); p.Add("@TeachingClassID", model.TeachingClassID); p.Add("@PageIndex", PageIndex); p.Add("@PageSize", PageSize); return conn.Query<User>("ClassUserHistory_List", p, commandType: CommandType.StoredProcedure).ToList(); } } catch (Exception e) { return new List<User>(); } }
//获取历史班级下的学生 public List<User> ClassUserHistory_List(TeachingClass model, int PageIndex, int PageSize) { return MyGroupDAL.ClassUserHistory_List(model, PageIndex, PageSize); }
public ActionResult Create(TimeTable model) { List <Level> theLevels = work.LevelRepository.Get().ToList(); List <SelectListItem> theItem = new List <SelectListItem>(); theItem.Add(new SelectListItem() { Text = "None", Value = "" }); foreach (var level in theLevels) { theItem.Add(new SelectListItem() { Text = level.LevelName + ":" + level.Type, Value = level.LevelName + ":" + level.Type }); } ViewData["Level"] = theItem; List <Subject> theSubject = work.SubjectRepository.Get().ToList(); List <SelectListItem> theSubjectsItem = new List <SelectListItem>(); theSubjectsItem.Add(new SelectListItem() { Text = "None", Value = "" }); foreach (var sub in theSubject) { theSubjectsItem.Add(new SelectListItem() { Text = sub.Name, Value = sub.Name }); } ViewData["Subject"] = theSubjectsItem; List <PrimarySchoolStaff> staff = work.PrimarySchoolStaffRepository.Get().OrderBy(a => a.LastName).ToList(); List <SelectListItem> theStaffItem = new List <SelectListItem>(); theStaffItem.Add(new SelectListItem() { Text = "None", Value = "" }); foreach (var s in staff) { theStaffItem.Add(new SelectListItem() { Text = s.LastName + " " + s.Middle + " " + s.FirstName, Value = s.LastName + " " + s.Middle + " " + s.FirstName }); } ViewData["Staff"] = theStaffItem; try { string v = model.Subject + ";" + model.Class + ";" + model.StratTimeHour + ";" + model.StratTimeMinute + ";" + model.Teacher + ";" + model.Day; string theReturnedValue = TimeTableCollisionAviodance.CheckDaySlotAvialability(v); string theReturnedValueSubject = TimeTableCollisionAviodance.CheckSubjectSlotAvialability(v); string theReturnedValueStaff = TimeTableCollisionAviodance.CheckStaffSlotAvialability(v); if (!(string.IsNullOrEmpty(theReturnedValue))) { // ModelState.AddModelError("", "Create a Class Subjects First for Class " + theStudent.PresentLevel); // return View(theReg); ModelState.AddModelError("", theReturnedValue); return(View(model)); } int start = Convert.ToInt32(model.StratTimeHour); int finish = Convert.ToInt32(model.EndTimeHour); if (finish < start) { ModelState.AddModelError("", "Start Time of a Subject must be greater than its finish time!"); return(View(model)); } if (!(string.IsNullOrEmpty(theReturnedValueSubject))) { ModelState.AddModelError("", theReturnedValueSubject); return(View(model)); } if (!(string.IsNullOrEmpty(theReturnedValueStaff))) { ModelState.AddModelError("", theReturnedValueStaff); return(View(model)); } //var theValue = $('#Subject').val() + ";" + $('#Class').val() + ";" + $('#StratTimeHour').val() + ";" + $('#StratTimeMinute').val() + ";" + $('#Teacher').val() + ";" + $('#Day').val(); TeachingSubject ts = new TeachingSubject(); ts.SubjectName = model.Subject; TeachingDay td = new TeachingDay(); td.StratTimeHour = model.StratTimeHour; td.StratTimeMinute = model.StratTimeMinute; td.EndTimeHour = model.EndTimeHour; td.EndTimeMinute = model.EndTimeMinute; if (model.Day == "SUNDAY") { td.theDay = Day.SUNDAY; } if (model.Day == "MONDAY") { td.theDay = Day.MONDAY; } if (model.Day == "TUESDAY") { td.theDay = Day.TUESDAY; } if (model.Day == "WEDNESDAY") { td.theDay = Day.WEDNESDAY; } if (model.Day == "THURSDAY") { td.theDay = Day.THURSDAY; } if (model.Day == "FRIDAY") { td.theDay = Day.FRIDAY; } if (model.Day == "SATURDAY") { td.theDay = Day.SATURDAY; } TeachingClass tc = new TeachingClass(); tc.ClassName = model.Class; List <TeachingSubject> tss = new List <TeachingSubject>(); tss.Add(ts); td.TeachingSubject = tss; List <TeachingDay> tdd = new List <TeachingDay>(); tdd.Add(td); tc.TheTeachingDay = tdd;; List <TeachingClass> tt = new List <TeachingClass>(); tt.Add(tc); Teacher t = new Teacher(); // work.PrimarySchoolStaffRepository.ge t.TeacherName = model.Teacher; string[] theTeacher = model.Teacher.Split(' '); string firstName = theTeacher[2]; string lastName = theTeacher[0]; List <PrimarySchoolStaff> priStaff = work.PrimarySchoolStaffRepository.Get(a => a.LastName.Equals(lastName) && a.FirstName.Equals(firstName)).ToList(); t.ThePersonID = priStaff[0].PersonID; t.TheTeachingClass = tt; work.TeacherRepository.Insert(t); work.Save(); // td.theDay = model.Day; // TODO: Add insert logic here return(RedirectToAction("Create")); // return RedirectToAction("Index"); } catch { return(View()); } }
public static List<IES.JW.Model.User> ClassUserHistory_List(int TeachingClassID, string Key, int PageIndex, int PageSize) { TeachingClass model = new TeachingClass { TeachingClassID = TeachingClassID, Key = Key }; return new MyGroupBLL().ClassUserHistory_List(model, PageIndex, PageSize); }