//
// GET: /Curriculum/
public ActionResult Curriculum(CurriculumSearchModel search)
{
CurriculumViewModel model = new CurriculumViewModel(); //页面模型
model.search = search; //页面的搜索模型
model.search.PageSize = 15; //每页显示
model.search.CurrentPage = Convert.ToInt32(Request["pageindex"]) <= 0 ? 1 : Convert.ToInt32(Request["pageindex"]); //当前页
//分校下拉项
List <CommonEntity> ComCodeIL = CommonData.Get_SYS_Company_COMP_Code(UserSession.comcode);//分校
model.ComCodeIL = CommonData.Instance.GetBropDownListData_Choice(ComCodeIL);
model.search.ComCodeIL1 = CommonData.Instance.GetBropDownListData_Choice(ComCodeIL);
if (UserSession.comcode != null && UserSession.comcode != "1")
{
search.ComCode = UserSession.comcode;//默认查询当前分校的人员
}
model.buttonlist = CourseData.GetButtonList(search); //填充页面模型数据
return(View(model)); //返回页面模型
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult Index(Guid id)
{
var curr = Db.Curricula.SingleOrDefault(x => x.Id == id);
var model = new CurriculumViewModel();
model.Curriculum = curr;
model.Semester = SemesterService.GetSemester(DateTime.Today);
var user = GetCurrentUser();
if (user.MemberState == MemberState.Staff)
{
model.ActiveSemesters.AddRange(Db.Semesters.Where(s =>
s.Groups.Any(g => g.CapacityGroup.CurriculumGroup.Curriculum.Id == curr.Id)));
}
else
{
model.ActiveSemesters.AddRange(Db.Semesters.Where(s =>
s.Groups.Any(g => g.CapacityGroup.CurriculumGroup.Curriculum.Id == curr.Id && g.IsAvailable)));
}
// hier muss überprüft werden, ob der aktuelle Benutzer
// der Fakultät des Studiengangs angehört oder nicht
ViewBag.UserRight = GetUserRight(model.Curriculum.Organiser);
return(View(model));
}
public PartialViewResult TopicList(Guid groupId)
{
var semGroup = Db.SemesterGroups.SingleOrDefault(x => x.Id == groupId);
var model = new CurriculumViewModel();
if (semGroup != null)
{
var curr = semGroup.CapacityGroup.CurriculumGroup.Curriculum;
var semester = semGroup.Semester;
model.Curriculum = curr;
model.Topics = Db.SemesterTopics.Where(x =>
x.Semester.Id == semester.Id &&
x.Topic.Chapter.Curriculum.Id == curr.Id &&
x.Activities.Any(s => s.SemesterGroups.Any(g => g.Id == semGroup.Id))
).ToList();
}
else
{
model.Topics = new List <SemesterTopic>();
}
return(PartialView("_TopicList", model));
}
public ActionResult Create(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CurriculumViewModel curriculumViewModel = new CurriculumViewModel {
CurriculumTemplates = db.GetFromDatabase <CurriculumTemplate>().ToList(),
StudentId = (int)id,
Student = db.GetFromDatabase <Student>(id)
};
return(View(curriculumViewModel));
}
public PartialViewResult SemesterTopicList(Guid?semId, Guid currId, bool activeOnly = true)
{
var curr = Db.Curricula.SingleOrDefault(c => c.Id == currId);
var semester = SemesterService.GetSemester(semId);
var model = new CurriculumViewModel
{
Curriculum = curr,
};
model.Topics = Db.SemesterTopics.Where(x =>
x.Semester.Id == semester.Id &&
x.Topic.Chapter.Curriculum.Id == curr.Id).ToList();
return(PartialView("_TopicList", model));
}
public IActionResult AfficherPDF()
{
var id = HttpContext.Session.GetInt32("UtilisateurId");
CurriculumViewModel curriculum = new CurriculumViewModel();
curriculum.Objectifs = _context.Objectif.Where(o => o.Curriculum.UtilisateurId == id).ToList();
curriculum.Formations = _context.Formation.Where(f => f.Curriculum.UtilisateurId == id).ToList();
curriculum.ExperiencseProfessionnelles = _context.ExperiencesProfissionelles.Where(ep => ep.Curriculum.UtilisateurId == id).ToList();
curriculum.Langues = _context.Langues.Where(l => l.Curriculum.UtilisateurId == id).ToList();
return(new ViewAsPdf("PDF", curriculum)
{
FileName = "CV.pdf"
});
}
public PartialViewResult GroupList(Guid?semId, Guid currId, bool activeOnly = true)
{
var curr = Db.Curricula.SingleOrDefault(c => c.Id == currId);
var semester = SemesterService.GetSemester(semId);
var model = new CurriculumViewModel
{
Curriculum = curr,
};
if (curr != null && semester != null)
{
if (activeOnly)
{
model.SemesterGroups = Db.SemesterGroups
.Where(g =>
g.Semester.Id == semester.Id &&
g.IsAvailable &&
g.CapacityGroup.CurriculumGroup.Curriculum.Id == model.Curriculum.Id)
.OrderBy(g => g.CapacityGroup.CurriculumGroup.Name)
.ThenBy(g => g.CapacityGroup.Name)
.ToList();
}
else
{
model.SemesterGroups = Db.SemesterGroups
.Where(g =>
g.Semester.Id == semester.Id &&
g.CapacityGroup.CurriculumGroup.Curriculum.Id == model.Curriculum.Id)
.OrderBy(g => g.CapacityGroup.CurriculumGroup.Name)
.ThenBy(g => g.CapacityGroup.Name)
.ToList();
}
}
else
{
model.SemesterGroups = new List <SemesterGroup>();
}
return(PartialView("_GroupList", model));
}
public ActionResult MapData()
{
//var listNationalityData = Session["SessionListNationalityData"] as List<NationalityObj>;
var vmCurriculum = new CurriculumViewModel();
List <string> fooList = new List <string>();
fooList.Add("Literacy_Primary");
fooList.Add("Reading");
fooList.Add("Writing");
fooList.Add("L_and_T");
fooList.Add("Numeracy_Primary");
fooList.Add("NMM");
fooList.Add("SPM");
fooList.Add("IH");
vmCurriculum.ListSubjects = fooList;
vmCurriculum.DicSubject = GetDicSubject();
return(View("MapIndex", vmCurriculum));
}
public ActionResult Create([Bind(Include = "StudentId,CurriculumTemplateId")] CurriculumViewModel curriculumViewModel)
{
if (ModelState.IsValid)
{
Student student = db.GetFromDatabase <Student>(curriculumViewModel.StudentId);
var curriculumTemplate = db.GetFromDatabase <CurriculumTemplate>(curriculumViewModel.CurriculumTemplateId);
var topics = curriculumTemplate.Topics;
Curriculum curriculum = new Curriculum();
curriculum.Naam = curriculumTemplate.Naam;
foreach (var topic in topics)
{
//var topic1 = db.GetFromDatabase<Topic>(topic.Id);
CurriculumTopic t = new CurriculumTopic {
TopicId = topic.Id, Topic = topic, Curriculum = curriculum, CurriculumId = curriculum.Id
};
curriculum.Topics.Add(t);
}
curriculum.Student = student;
student.Curricula.Add(curriculum);
db.Curricula.Add(curriculum);
db.Entry(student).State = EntityState.Modified;
db.SaveChanges();
//// COMMENT: This code can probably be removed
//if (curriculumViewModel.StudentId != 0)
// return RedirectToAction("Details", "Student", new { id = curriculumViewModel.StudentId });
return(RedirectToAction("Details", "Student", new { id = curriculumViewModel.StudentId }));
}
return(View());
//curriculumTemplateViewModel.AlleTopics = db.Topics.Where(t => !t.IsDeleted).ToList();
//curriculumTemplateViewModel.AlleTopics = db.Topics.ToList();
//return View(curriculumTemplateViewModel);
}
// GET: Curriculum
public ActionResult Index(string schoolyear)
{
int yearStart = DateTime.Today.Month > 5 ? DateTime.Today.Year : DateTime.Today.AddYears(-1).Year;
int yearEnd = DateTime.Today.Month > 5 ? DateTime.Today.AddYears(1).Year : DateTime.Today.Year;
if (!IsValidSchoolYear(schoolyear))
{
schoolyear = string.Format("{0}-{1}", yearStart, yearEnd);
}
string cacheKey = "Curriculum" + schoolyear;
CurriculumViewModel vm1 = WebCache.Get(cacheKey) as CurriculumViewModel;
if (vm1 == null)
{
CurriculumViewModel vm = new CurriculumViewModel();
vm.SchoolYear = schoolyear;
vm.SchedulesInThisYear = curRepo.GetSchedulesBySchoolYear(schoolyear);
vm.CoursesInThisYear = curRepo.GetCoursesBySchoolYear(schoolyear);
vm.TeachersInThisYear = curRepo.GetTeachersBySchoolYear(schoolyear);
vm.TeacherContacts = curRepo.GetTeacherContactsBySchooYear(schoolyear);
vm.BooksInThisYear = curRepo.AllTextbooks();
vm.RoomsInThisYear = curRepo.AllClassroooms();
WebCache.Set(cacheKey, vm);
vm1 = vm;
}
string langCode = (string)this.RouteData.Values["lang"];
if (string.IsNullOrEmpty(langCode))
{
langCode = "en";
}
ViewBag.LangCode = langCode;
return(View(vm1));
}
// GET: SchoolProfile/Curriculum
public ActionResult Index(string sSchoolName)
{
//page counter
var eGeneralSettings = ACCDataStore.Core.Helper.ConvertHelper.XmlFile2Object(HttpContext.Server.MapPath("~/Config/GeneralSettings.xml"), typeof(GeneralCounter)) as GeneralCounter;
eGeneralSettings.CurriculumpgCounter++;
ACCDataStore.Core.Helper.ConvertHelper.Object2XmlFile(eGeneralSettings, HttpContext.Server.MapPath("~/Config/GeneralSettings.xml"));
var vmCurriculum = new CurriculumViewModel();
//var schoolname = new List<string>();
var sSubjectCriteria = new List <string>();
var setGenderCriteria = new List <string>();
List <CurriculumObj> ListCurriculumData = new List <CurriculumObj>();
List <CurriculumObj> temp = new List <CurriculumObj>();
var listResult = this.rpGeneric.FindSingleColumnByNativeSQL("SELECT DISTINCTROW Name from sch_Student_t t1 INNER JOIN sch_PrimarySchool_t t2 on t1.SeedCode = t2.SeedCode ");
List <string> fooList = listResult.OfType <string>().ToList();
vmCurriculum.ListSchoolNameData = fooList;
listResult = this.rpGeneric.FindSingleColumnByNativeSQL("SELECT DISTINCTROW StudentStage FROM sch_Student_t group by StudentStage");
fooList = listResult.OfType <string>().ToList();
vmCurriculum.ListStageCode = fooList;
listResult = this.rpGeneric.FindSingleColumnByNativeSQL("SELECT DISTINCTROW Gender FROM sch_Student_t group by Gender");
fooList = listResult.OfType <string>().ToList();
fooList.Add("T");
vmCurriculum.ListGenderCode = fooList;
vmCurriculum.DicGender = GetDicGender();
fooList = new List <string>();
fooList.Add("Literacy_Primary");
fooList.Add("Reading");
fooList.Add("Writing");
fooList.Add("L_and_T");
fooList.Add("Numeracy_Primary");
fooList.Add("NMM");
fooList.Add("SPM");
fooList.Add("IH");
vmCurriculum.ListSubjects = fooList;
vmCurriculum.DicSubject = GetDicSubject();
fooList = new List <string>();
fooList.Add("Early");
fooList.Add("Early Developing");
fooList.Add("Early Consolidating");
fooList.Add("Early Secure");
fooList.Add("First Developing");
fooList.Add("First Consolidating");
fooList.Add("First Secure");
fooList.Add("Second Developing");
fooList.Add("Second Consolidating");
fooList.Add("Second Secure");
fooList.Add("Third Developing");
fooList.Add("Third Consolidating");
fooList.Add("Third Secure");
fooList.Add("blank");
//fooList.Add("Grand Total");
vmCurriculum.ListSkills = fooList;
if (Request.HttpMethod == "GET") // get method
{
if (sSchoolName == null) // case of index page, show criteria
{
vmCurriculum.IsShowCriteria = true;
}
else // case of detail page, by pass criteria
{
vmCurriculum.IsShowCriteria = false;
vmCurriculum.ListSelectedGender = vmCurriculum.ListGenderCode;
vmCurriculum.ListSelectedSubject = vmCurriculum.ListSubjects;
Session["ListSelectedGender"] = vmCurriculum.ListSelectedGender;
//Session["ListSelectedNationality"] = vmNationality.ListSelectedNationality;
Session["sSchoolName"] = sSchoolName;
}
}
else // post method
{
vmCurriculum.IsShowCriteria = true;
sSchoolName = Request["selectedschoolname"];
vmCurriculum.selectedschoolname = sSchoolName;
Session["sSchoolName"] = sSchoolName;
if (Request["subject"] != null)
{
sSubjectCriteria = Request["subject"].Split(',').ToList();
vmCurriculum.ListSelectedSubject = sSubjectCriteria;
}
else
{
sSubjectCriteria = null;
}
if (Request["gender"] != null)
{
vmCurriculum.ListSelectedGender = Request["gender"].Split(',').ToList();
}
else
{
vmCurriculum.ListSelectedGender = vmCurriculum.ListGenderCode;
}
Session["ListSelectedGender"] = vmCurriculum.ListSelectedGender;
//Session["ListSelectedNationality"] = vmNationality.ListSelectedNationality;
// get parameter from Request object
}
vmCurriculum.DicGenderWithSelected = GetDicGenderWithSelected(vmCurriculum.ListSelectedGender);
// process data
if (sSchoolName == null || sSchoolName.Equals(""))
{
vmCurriculum.IsShowData = false;
}
else if (sSchoolName != null)
{
vmCurriculum.selectedschoolname = sSchoolName;
if (sSubjectCriteria == null)
{
vmCurriculum.IsShowData = false;
vmCurriculum.ListLiteracydata = null;
vmCurriculum.ListNMMdata = null;
vmCurriculum.ListSPMdata = null;
vmCurriculum.ListIHdata = null;
vmCurriculum.ListLiteracydata = null;
vmCurriculum.ListReadingdata = null;
vmCurriculum.ListWritingdata = null;
vmCurriculum.ListLandTdata = null;
vmCurriculum.ListNumeracydata = null;
}
//else if (sSubjectCriteria.Count != 0 && sSubjectCriteria != null)
//{
// vmCurriculum.IsShowData = true;
// //vmCurriculum.ListNationalityData = ListCurriculumData.Where(x => sNationalCriteria.Contains(x.IdentityCode)).ToList();
// vmCurriculum.ListLiteracydata = ListCurriculumData;
//}
else
{
foreach (var subject in sSubjectCriteria)
{
if (subject.Equals("Literacy_Primary"))
{
vmCurriculum.ListLiteracydata = GetCurriculumDatabySchoolname(rpGeneric, sSchoolName, "Literacy_Primary");
Session["SessionListLiteracydata"] = vmCurriculum.ListLiteracydata;
}
else if (subject.Equals("Reading"))
{
vmCurriculum.ListReadingdata = GetCurriculumDatabySchoolname(rpGeneric, sSchoolName, "Reading");
Session["SessionListReadingdata"] = vmCurriculum.ListReadingdata;
}
else if (subject.Equals("Writing"))
{
vmCurriculum.ListWritingdata = GetCurriculumDatabySchoolname(rpGeneric, sSchoolName, "Writing");
Session["SessionListWritingdata"] = vmCurriculum.ListWritingdata;
}
else if (subject.Equals("L_and_T"))
{
vmCurriculum.ListLandTdata = GetCurriculumDatabySchoolname(rpGeneric, sSchoolName, "L_and_T");
Session["SessionListLandTdata"] = vmCurriculum.ListLandTdata;
}
else if (subject.Equals("Numeracy_Primary"))
{
vmCurriculum.ListNumeracydata = GetCurriculumDatabySchoolname(rpGeneric, sSchoolName, "Numeracy_Primary");
Session["SessionListNumeracydata"] = vmCurriculum.ListNumeracydata;
}
else if (subject.Equals("NMM"))
{
vmCurriculum.ListNMMdata = GetCurriculumDatabySchoolname(rpGeneric, sSchoolName, "NMM");
Session["SessionListNMMdata"] = vmCurriculum.ListNMMdata;
}
else if (subject.Equals("SPM"))
{
vmCurriculum.ListSPMdata = GetCurriculumDatabySchoolname(rpGeneric, sSchoolName, "SPM");
Session["SessionListSPMdata"] = vmCurriculum.ListSPMdata;
}
else if (subject.Equals("IH"))
{
vmCurriculum.ListIHdata = GetCurriculumDatabySchoolname(rpGeneric, sSchoolName, "IH");
Session["SessionListIHdata"] = vmCurriculum.ListIHdata;
}
}
vmCurriculum.IsShowData = true;
}
}
return(View("Index", vmCurriculum));
}
