public async Task <PagedListResult <CourseItem> > GetPagedList(PageableListQuery query)
{
var lstCourse = await this.repository.GetPagedList(query);
var lstCourseItem = new List <CourseItem>();
foreach (var item in lstCourse.List)
{
var courseItem = new CourseItem()
{
Id = item.Id,
Name = item.Name,
Code = item.Code,
StudentItems = new List <StudentItem>()
};
foreach (var enrollment in item.Enrollments)
{
var studentItem = new StudentItem()
{
Id = enrollment.Student.Id,
Name = enrollment.Student.Name,
Roll = enrollment.Student.Roll,
Email = enrollment.Student.Email
};
courseItem.StudentItems.Add(studentItem);
}
lstCourseItem.Add(courseItem);
}
return(new PagedListResult <CourseItem>(lstCourseItem, lstCourseItem.Count));
}
private async Task <StudentItem> GetEventsParticipation(
StudentItem student, List <TrackEventItem> events, CancellationToken token
)
{
student.AttendedEvents = new List <AttendedEventItem>();
if (events != null)
{
foreach (var item in events)
{
var application = await GetApplication(student.Id, item.EventScheduleId, token);
if (application != null)
{
student.AttendedEvents.Add(new AttendedEventItem
{
EventDate = application.EventDate,
EventScheduleId = application.ScheduleId,
FinalGrade = GetFinalGrade(application),
Presence = application.UserPresence,
Title = item.Title
});
}
}
}
return(student);
}
public void InitItem(StudentItem item)
{
studentItem = item;
UserName = item.UserName;
IPAddress = item.IPAddress;
studentState = item.studentState;
}
public async Task <IActionResult> PutStudentItem(long id, StudentItem studentItem)
{
if (id != studentItem.Id)
{
return(BadRequest());
}
_context.Entry(studentItem).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
// Use this for initialization
void Start()
{
string error = ErrorCodeConfig.GetErrorById(10000);
Debug.Log(error);
string error1 = Error.GetErrorById(10001);
Debug.Log(error1);
string name = JsonTest.Config.name;
Debug.Log(name);
GoodsConfigGoods goods = GoodsConfig.GetGoodsById(10000);
if (goods != null)
{
Debug.Log(goods.Name);
}
StudentItem student = StudentConfig.GetStudent(12345);
if (student != null)
{
Debug.Log(student.Name);
}
else
{
Debug.Log("没有找到数据");
}
}
public IActionResult Create(StudentItem item)
{
_context.StudentItems.Add(item);
_context.SaveChanges();
return(CreatedAtRoute("Get", new { id = item.STU_ID }, item));
}
public void UpdateStudent()
{
using (EditStudentForm editStd = new EditStudentForm())
{
editStd.txtFName.text = gridStd[gridStd.RowSel, 2].ToString();
editStd.txtLName.text = gridStd[gridStd.RowSel, 3].ToString();
editStd.txtMName.text = gridStd[gridStd.RowSel, 4].ToString();
editStd.txtCCode.text = gridStd[gridStd.RowSel, 5].ToString();
editStd.txtCtitle.text = gridStd[gridStd.RowSel, 6].ToString();
editStd.txtYear.text = gridStd[gridStd.RowSel, 7].ToString();
editStd.txtSection.text = gridStd[gridStd.RowSel, 8].ToString();
editStd.ShowDialog();
if (editStd.isConfirmed == true)
{
var stdManage = new StudentManager();
var item = new StudentItem();
item.Std_FName = editStd.txtFName.text;
item.Std_LName = editStd.txtLName.text;
item.Std_MName = editStd.txtMName.text;
item.Std_CourseCode = editStd.txtCCode.text;
item.Std_CourseTitle = editStd.txtCtitle.text;
item.Std_Year = editStd.txtYear.text;
item.Std_Section = editStd.txtSection.text;
item.Std_Id = selectedId;
stdManage.UpdateStudent(item);
}
// do what ever with result...
}
}
public List <CourseItem> GetAll()
{
var lstCourse = new List <Course>();
lstCourse = unit.CourseRepository.GetAll();
var lstCourseItem = new List <CourseItem>();
foreach (var item in lstCourse)
{
var courseItem = new CourseItem()
{
Id = item.CourseId,
Name = item.Name,
Code = item.Code,
IsDelete = item.IsDelete,
StudentItems = new List <StudentItem>()
};
foreach (var student in item.Students)
{
var studentItem = new StudentItem()
{
Id = student.StudentId,
Name = student.Name,
Roll = student.Roll,
Email = student.Email,
Address = student.Address,
IsDelete = student.IsDelete
};
courseItem.StudentItems.Add(studentItem);
}
lstCourseItem.Add(courseItem);
}
return(lstCourseItem);
}
/// <summary>
/// Проверяет эквивалентны ли два студента.
/// </summary>
/// <param name="first_student">Первый студент для сравнения</param>
/// <param name="second_student">Второй студент для сравнения</param>
private void AreEqualStudents(StudentItem first_student, StudentItem second_student)
{
Assert.AreEqual(first_student.Id, second_student.Id);
Assert.AreEqual(first_student.LastName, second_student.LastName);
Assert.AreEqual(first_student.FirstName, second_student.FirstName);
Assert.AreEqual(first_student.FatherName, second_student.FatherName);
Assert.AreEqual(first_student.TeamId, second_student.TeamId);
}
public StudentInsertWindow()
{
InitializeComponent();
//Student = item;
Student = new StudentItem();
Groups = new GroupRepository().GetAll();
//SelectedGroup = new GroupItem(item.GroupId, item.GroupName);
DataContext = this;
}
public StudentEditWindow(StudentItem item)
{
InitializeComponent();
Student = item;
Groups = new GroupRepository().GetAll();
SelectedGroup = Groups[0];
//SelectedGroup = new DeaneryLibrary.GroupItem();
//SelectedGroup.Id = item.GroupId; SelectedGroup.Name = item.GroupName;
DataContext = this;
}
public async Task <ActionResult <StudentItem> > PostStudentItem(StudentItem studentItem)
{
//Validare
if (studentItem.Age < 0)
{
return(BadRequest("Invalid value entered for the 'age' field!"));
}
_context.StudentItems.Add(studentItem);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetStudentItem", new { id = studentItem.Id }, studentItem));
}
public void SetUp()
{
_transactionScope = new TransactionScope();
_studentRepository = new StudentRepository();
_personRepository = new PersonRepository();
_teamRepository = new TeamRepository();
_specialtyDetailRepository = new SpecialtyDetailRepository();
_specialtyRepository = new SpecialtyRepository();
_cathedraRepository = new CathedraRepository();
_facultyRepository = new FacultyRepository();
_team = new TeamItem()
{
CreateDate = DateTime.Now,
Name = "ПЕ-22б",
SpecialtyDetailId = _specialtyDetailRepository.Create(new SpecialtyDetailItem()
{
SpecialtyId = _specialtyRepository.Create(new SpecialtyItem()
{
CathedraId = _cathedraRepository.Create(new CathedraItem()
{
FacultyId = _facultyRepository.Create(new FacultyItem()),
FullName = "Кафедра",
ShortName = "K"
}),
FullName = "Специальность",
ShortName = "С",
Code = "1"
}),
ActualDate = DateTime.Now
})
};
_student = new StudentItem()
{
LastName = "Егоров",
FirstName = "Виталий",
FatherName = "Игоревич",
Birthday = DateTime.Now,
TeamId = _teamRepository.Create(_team)
};
_student.Id = _personRepository.Create(_student);
_studentNew = new StudentItem()
{
LastName = "Журавлев",
FirstName = "Данил",
FatherName = "Александрович",
Birthday = DateTime.Now,
TeamId = _teamRepository.Create(_team)
};
_studentNew.Id = _personRepository.Create(_student);
}
public void SetStudData()
{
myStudItem = new StudentItem();
myStudItem.Std_FName = txtFName.text;
myStudItem.Std_LName = txtLName.text;
myStudItem.Std_MName = txtMName.text;
myStudItem.Std_CourseCode = txtCourseCode.text;
myStudItem.Std_CourseTitle = txtCourseTitle.text;
myStudItem.Std_Year = txtYear.text;
myStudItem.Std_Section = txtSection.text;
myStudItem.Std_Deleted = "no";
}
public void Add_NewStudent_StudentAdded()
{
var student = new StudentItem
{
Name = "John",
PersonalIdentifier = 7,
Gender = 'M',
Type = "University"
};
_subject.Add(student);
var actualStudentAdded = _subject.Get(7);
var expectedStudentAdded = new Student("John", 7, 'F', "University", DateTime.UtcNow);
Assert.Equal(expectedStudentAdded, actualStudentAdded);
}
public void Update_StudentName_StudentUpdated()
{
var personalIdentifier = 6;
var student = new StudentItem
{
Name = "Peeteer",
PersonalIdentifier = personalIdentifier,
Gender = 'M',
Type = "University"
};
_subject.Update(personalIdentifier, student);
var actualStudentAdded = _subject.Get(personalIdentifier);
var expectedStudentAdded = new Student("Peeteer", 6, 'M', "University", DateTime.UtcNow);
Assert.Equal(expectedStudentAdded, actualStudentAdded);
}
//static void bkWork_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
//{
// if (errStr != "")
// MessageBox.Show(errStr);
//}
//// 處理畢業變更狀態
//static void bkWork_DoWork(object sender, DoWorkEventArgs e)
//{
// List<JHSchool.Data.JHStudentRecord> StudRecs = JHSchool.Data.JHStudent.SelectByIDs(sidList);
// foreach (JHSchool.Data.JHStudentRecord studRec in StudRecs)
// studRec.Status = K12.Data.StudentRecord.StudentStatus.畢業或離校;
// JHSchool.Data.JHStudent.Update(StudRecs);
//}
/// <summary>
/// 取得班級學生
/// </summary>
/// <param name="ClassIDs"></param>
/// <param name="Status"></param>
/// <returns></returns>
public static Dictionary <string, List <StudentItem> > getStudentItems(List <ClassItem> ClassItems, string Status)
{
Class.Instance.SyncAllBackground();
Dictionary <string, List <JHSchool.Data.JHStudentRecord> > classStud = new Dictionary <string, List <JHSchool.Data.JHStudentRecord> >();
foreach (JHSchool.Data.JHStudentRecord studRec in JHSchool.Data.JHStudent.SelectAll())
{
if (studRec.Status == K12.Data.StudentRecord.StudentStatus.一般)
{
if (classStud.ContainsKey(studRec.RefClassID))
{
classStud[studRec.RefClassID].Add(studRec);
}
else
{
List <JHSchool.Data.JHStudentRecord> StudRecList = new List <JHSchool.Data.JHStudentRecord>();
StudRecList.Add(studRec);
classStud.Add(studRec.RefClassID, StudRecList);
}
}
}
Dictionary <string, List <StudentItem> > StudentItems = new Dictionary <string, List <StudentItem> >();
foreach (ClassItem ci in ClassItems)
{
List <StudentItem> studItems = new List <StudentItem>();
if (classStud.ContainsKey(ci.ClassID))
{
foreach (JHSchool.Data.JHStudentRecord studRec in classStud[ci.ClassID])
{
StudentItem si = new StudentItem();
si.StudentID = studRec.ID;
si.Status = studRec.Status.ToString();
si.ClassName = studRec.Class.Name;
studItems.Add(si);
si = null;
}
StudentItems.Add(ci.ClassID, studItems);
}
}
return(StudentItems);
}
public IActionResult Update(int id, StudentItem item)
{
var todo = _context.StudentItems.Find(id);
if (todo == null)
{
return(NotFound());
}
todo.StudentId = item.StudentId;
todo.FirstName = item.FirstName;
todo.LastName = item.LastName;
todo.Email = item.Email;
todo.Phone = item.Phone;
todo.Address = item.Address;
_context.StudentItems.Update(todo);
_context.SaveChanges();
return(NoContent());
}
/// <summary>
/// Исключение студента из группы.
/// </summary>
/// <param name="student">Студенты.</param>
public void Delete(StudentItem student)
{
using (var sqlh = new SqlHelper())
{
sqlh.ExecNoQuery(@"
insert into Person.student
(
event_date,
person,
team,
act
)
values
(
getdate(),
@Id,
@TeamId,
-1
)", student);
}
}
public void LoginDetails()
{
myStudentItem = new List <StudentItem>();
myStudentItem.Clear();
string logStatus = myStudentCollection.LoadLogStudentsFromDb(txtStdFname.text, txtStdLname.text);
if (logStatus == "Name Not Found")
{
pbWarning.Visible = true;
lblWarning.Visible = true;
}
else
{
foreach (var popStudentItem in myStudentCollection.pubStudentCollect)
{
var myItem = new StudentItem();
myItem.Std_FName = popStudentItem.Std_FName;
myItem.Std_LName = popStudentItem.Std_LName;
myItem.Std_Id = popStudentItem.Std_Id;
myStudentItem.Add(myItem);
}
var passForm = new PasswordForm();
passForm.Owner = this;
passForm.holdStdList = myStudentItem;
passForm.lblPassword.Text = "Enter Id:";
passForm.btnLogin.ButtonText = "Enter";
this.Hide();
passForm.ShowDialog();
txtStdFname.text = "";
txtStdLname.text = "";
passForm.Dispose();
myStudentItem.Clear();
GC.Collect();
}
}
/// <summary>
/// Зачисление студента в группу.
/// </summary>
/// <param name="student">Студенты.</param>
/// <returns>Идентификатор созданной задачи.</returns>
public int Create(StudentItem student)
{
using (var sqlh = new SqlHelper())
{
return(sqlh.ExecScalar <int>(@"
insert into Person.student
(
event_date,
person,
team,
act
)
values
(
getdate(),
@Id,
@TeamId,
1
)
select @Id", student));
}
}
public void Post([FromBody] StudentItem student)
{
_studentsService.Add(student);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strXmlClassDocument = hiddenClassXMLDocument.Value.Trim();
if ("" == strXmlClassDocument)
{
PageUtil.PageAlert(this.Page, "请添加班级后保存");
return;
}
XmlDocument xmlClass = new XmlDocument();
try
{
xmlClass.LoadXml(string.Format("<Classes>{0}</Classes>" ,strXmlClassDocument));
}
catch(Exception ee)
{
PageUtil.PageAlert(this.Page, "保存失败!");
return;
}
XmlNodeList classNodeList = xmlClass.GetElementsByTagName("Class");
foreach (XmlNode classNode in classNodeList)
{
//添加主表记录——班级
ClassItem classItem = new ClassItem();
XmlNode nodeClassName = classNode.SelectSingleNode("ClassName");
if (null == nodeClassName)
continue;
string strClassName = nodeClassName.InnerText;
if ("" == strClassName.Trim())
continue;
classItem.ClassName = strClassName;
XmlNode nodeNumber = classNode.SelectSingleNode("StudentNumber");
if (null != nodeNumber)
classItem.StudentNumber = Util.ParseInt(nodeNumber.InnerText, 0);
int nClassId = classItem.Save();
if (nClassId <= 0)
continue;
XmlNodeList studentNodeList = classNode.SelectNodes("Students/Student");
foreach (XmlNode studentNode in studentNodeList)
{
//添加字表记录——学生
StudentItem studentItem = new StudentItem();
studentItem.ClassItemId = nClassId;
XmlNode nodeStudentName = studentNode.SelectSingleNode("Name");
if (null == nodeStudentName)
continue;
string strStudentName = nodeStudentName.InnerText;
if ("" == strStudentName.Trim())
continue;
studentItem.Name = strStudentName;
XmlNode nodeAge = studentNode.SelectSingleNode("Age");
if (null != nodeAge)
studentItem.Age = Util.ParseInt(nodeAge.InnerText, 0);
studentItem.Save();
}
}
PageUtil.PageAppendScript(this.Page, "alert('保存成功！');window.location.href = 'Window.aspx?value=FunctionControls/ClassManage/ClassManage.ascx'");
}
private async Task <TrackItem> GetStudentsInfo(
TrackItem track, ObjectId moduleId, List <Student> trackStudents, List <UserModuleProgress> progresses, List <UserFile> userFiles
)
{
track.Students = new List <StudentItem>();
track.StudentsProgress = new List <StudentsProgressItem>();
track.WrongConcepts = new List <WrongConcept>();
track.ViewedContents = new List <ViewedContentItem>();
track.SubjectsProgress = new List <SubjectsProgressItem>();
track.UserFiles = new List <UserFile>();
track.StudentsProgress.Add(new StudentsProgressItem
{
Count = 0,
Level = null
});
track.StudentsProgress.Add(new StudentsProgressItem
{
Count = 0,
Level = 0
});
track.StudentsProgress.Add(new StudentsProgressItem
{
Count = 0,
Level = 1
});
track.StudentsProgress.Add(new StudentsProgressItem
{
Count = 0,
Level = 2
});
track.StudentsProgress.Add(new StudentsProgressItem
{
Count = 0,
Level = 3
});
track.StudentsProgress.Add(new StudentsProgressItem
{
Count = 0,
Level = 4
});
var trackModule = track.ModulesConfiguration.First(m =>
m.ModuleId == moduleId
);
track.ModulesConfiguration = new List <TrackModuleItem>
{
trackModule
};
foreach (var student in trackStudents)
{
if (student.WrongConcepts != null && student.WrongConcepts.Any(x => x.ModuleId == moduleId))
{
track.WrongConcepts.AddRange(
student.WrongConcepts.Where(x => x.ModuleId == moduleId).ToList()
);
}
UserModuleProgress userProgress = null;
int level = 0;
if (progresses.Count > 0)
{
userProgress = progresses.FirstOrDefault(p =>
p.UserId == student.Id
);
if (userProgress == null)
{
track.StudentsProgress.First(x => x.Level == null).Count++;
}
else
{
level = userProgress.Level;
track.StudentsProgress.First(x => x.Level == level).Count++;
}
}
var newStud = new StudentItem
{
Id = student.Id,
ImageUrl = student.ImageUrl,
Name = student.Name,
Objective = userProgress == null ? 0 : userProgress.Progress,
Finished = userProgress != null && userProgress.Level > trackModule.Level,
UserFiles = userFiles.Where(x => x.CreatedBy == student.Id).OrderByDescending(x => x.CreatedAt).FirstOrDefault()
};
if (userProgress != null)
{
newStud.Level = level;
}
track.Students.Add(newStud);
}
var dbModule = await GetModuleById(moduleId);
track.ModuleTitle = dbModule.Title;
foreach (var subject in dbModule.Subjects)
{
var progressColl = _db.Database.GetCollection <UserSubjectProgress>("UserSubjectProgress");
var progQuery = await progressColl.FindAsync(x =>
x.ModuleId == moduleId
);
var subjectProgresses = await progQuery.ToListAsync();
decimal subjectProgressSum = subjectProgresses.Where(p =>
p.SubjectId == subject.Id &&
trackStudents
.Select(s => s.Id)
.Contains(p.UserId)
).Sum(p => p.Level);
track.StudentsCount = trackStudents.Count();
if (track.StudentsCount > 0)
{
track.SubjectsProgress.Add(new SubjectsProgressItem
{
Level = subjectProgressSum / (decimal)track.StudentsCount,
SubjectTitle = subject.Title
});
}
foreach (var content in subject.Contents)
{
string contentId = content.Id.ToString();
var studentsIds = trackStudents.Select(s => s.Id);
var actionsColl = _db.Database.GetCollection <Action>("Actions");
var actionsQuery = await actionsColl.FindAsync(x =>
x.ContentId == contentId &&
x.Description == "content-access" &&
studentsIds.Contains(x.CreatedBy)
);
var actions = await actionsQuery.ToListAsync();
var actionsCount = actions.GroupBy(c => c.CreatedBy).Count();
if (actionsCount > 0)
{
track.ViewedContents.Add(new ViewedContentItem
{
ContentTitle = content.Title,
ContentType = content.Type,
Count = actionsCount
});
}
}
}
track.WrongConcepts = track.WrongConcepts
.GroupBy(c => new { c.Concept, c.ModuleId })
.Select(g => new WrongConcept
{
Concept = g.First().Concept,
ModuleId = g.First().ModuleId,
ModuleName = g.First().ModuleName,
Count = g.Sum(c => c.Count)
})
.OrderByDescending(wc => wc.Count)
.ToList();
return(track);
}
public void Put([FromBody] StudentItem student)
{
_studentsService.Update(student.PersonalIdentifier, student);
}
