public StudentController()
{
departmentManager = new DepartmentManager();
studentManager = new StudentManager();
courseManager = new CourseManager();
gradeManager = new GradeManager();
}
//添加成绩
private void AddGrade()
{
if (textBox3.Text.Trim() == string.Empty && textBox4.Text.Trim() == string.Empty)
{
label8.Text = "0.00";
}
else
{
label8.Text = (double.Parse(textBox3.Text) * double.Parse(label10.Text) + double.Parse(textBox4.Text) * (1 - double.Parse(label10.Text))).ToString();
}
if (GradeManager.UpdateClass(
Convert.ToInt32(label13.Text.Trim()),
Convert.ToInt32(label12.Text.Trim()),
Convert.ToDouble(textBox3.Text.Trim()),
Convert.ToDouble(textBox4.Text.Trim()),
Convert.ToDouble(label8.Text.Trim())
))
{
MessageBox.Show(
"成功添加/修改成绩",
"成功",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
NeedConfirmOnExit = false;
Close();
}
else
{
MessageBox.Show("添加/修改失败,请重试！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Grade 下拉列表
public void Bind()
{
var slist = new GradeManager().Getll();
SelectList sslist = new SelectList(slist, "GradeId", "GradeName");
ViewBag.sslist = sslist;
}
public void RunTest()
{
var cache = new MockCache();
var connectionStringBuilder = new SqliteConnectionStringBuilder()
{
DataSource = ":memory:"
};
string connectionString = connectionStringBuilder.ToString();
var connection = new SqliteConnection(connectionString);
var dbContextOptionsBuilder = new DbContextOptionsBuilder <IffleyRoutesRecordContext>();
dbContextOptionsBuilder.UseSqlite(connection);
var repository = new IffleyRoutesRecordContext(dbContextOptionsBuilder.Options);
repository.Database.OpenConnection();
repository.Database.EnsureCreated();
var styleSymbolManager = new StyleSymbolManager(repository, cache);
var ruleManager = new RuleManager(repository, cache);
var holdManager = new HoldManager(repository, cache, ruleManager);
var gradeManager = new GradeManager(repository, cache);
var problemReader = new ProblemReader(repository, cache, styleSymbolManager, ruleManager, holdManager, gradeManager);
var validator = new ProblemRequestValidator(repository);
var staticDataPopulater = new PopulateDatabaseWithStaticData(repository, existingDataFilePath);
staticDataPopulater.Populate();
var populator = new PopulateDatabaseWithExistingProblems(repository, existingDataFilePath, validator);
populator.Populate(false);
}
//添加学生成绩
private void toolStripButton6_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow == null)
{
return;
}
var r = dataGridView1.CurrentRow.Cells;
using (GradeDialog addgrade = new GradeDialog(teacher,
Convert.ToInt32(r[3].Value),
Convert.ToInt32(r[0].Value),
r[1].Value as string,
Convert.ToSingle(r[4].Value as string),
Convert.ToSingle(r[5].Value as string),
Convert.ToSingle(r[6].Value as string)
))
addgrade.ShowDialog();
if (toolStripComboBox3.Text.Trim() != "")
{
string option = " AND " + Convert.ToString(dataGridView1.CurrentRow.Cells[3].Value) + " = classId ";
DataTable t = GradeManager.SelectDifferentGrade(teacher.Id, option);
t.Columns[0].ColumnName = "学号";
t.Columns[1].ColumnName = "姓名";
t.Columns[2].ColumnName = "学院";
t.Columns[3].ColumnName = "课程编号";
t.Columns[4].ColumnName = "平时成绩";
t.Columns[5].ColumnName = "期末成绩";
t.Columns[6].ColumnName = "总成绩";
dataGridView1.DataSource = t;
}
else
{
RefreshClassTable();
}
}
public async Task <ActionResult> Create()
{
var departments = await DepartmentManager.GetAllEntities().ToListAsync();
SelectList departSelectList = new SelectList(departments, "Id", "Name");
ViewBag.departSelectList = departSelectList;
var majors = await MajorManager.GetMajorsForDepartment(departments.ElementAtOrDefault(0)).ToListAsync();
SelectList majorSelectList = new SelectList(majors, "Id", "Name");
ViewBag.majorSelectList = majorSelectList;
var grades = await GradeManager.GetAllEntities().ToListAsync();
SelectList gradeSelectList = new SelectList(grades, "Id", "GradeNum");
ViewBag.gradeSelectList = gradeSelectList;
var teachers = (await UserManager.GetNoClassTeachersAsync()).ToList();
ViewBag.teacherSelectList = new SelectList(teachers, "Id", "Name");
ViewBag.Classes = await ClassManager.GetAllEntities().ToListAsync();
return(View());
}
public IActionResult AddG(GradeModel model)
{
if (ModelState.IsValid)
{
var student = StudentManager.GetAll().FirstOrDefault(c => c.Name == model.StudentName && c.Surname == model.StudentSurname);
var subject = SubjectManager.GetAll().FirstOrDefault(c => c.Name == model.SubjectName);
//model.Subject = SubjectController.Subjects.Find(s => s.Name == model.SubjectName);
//model.Student = StudentController.Students.Find(s => s.Name == model.StudentName && s.Surname == model.StudentSurname);
if (student == null)
{
ModelState.AddModelError("stu", "Skolnieks nav atrasts!");
}
else if (subject == null)
{
ModelState.AddModelError("sub", "Priekšmets nav atrasts!");
}
else if (model.Grade < 1 || model.Grade > 10)
{
ModelState.AddModelError("gra", "Atzīmei jābūt intervālā no 1 līdz 10!");
}
else
{
GradeManager.Create(model.Grade, model.Comment, student.Id, subject.Id);
return(RedirectToAction(nameof(IndexG)));
}
}
return(View(model));
}
//查询学生名单
private void toolStripButton4_Click(object sender, EventArgs e)
{
string option = "";
if (toolStripComboBox2.Text.Trim() == "姓名")
{
option = "WHERE name like '%" + toolStripTextBox1.Text.Trim() + "%'";
}
else if (toolStripComboBox2.Text.Trim() == "性别")
{
option = "WHERE sex like '%" + toolStripTextBox1.Text.Trim() + "%'";
}
else if (toolStripComboBox2.Text.Trim() == "学院")
{
option = "WHERE college like '%" + toolStripTextBox1.Text.Trim() + "%'";
}
else
{
option = "";
}
var dt = GradeManager.SelectStudent(option);
dt.Columns[0].ColumnName = "学号";
dt.Columns[1].ColumnName = "姓名";
dt.Columns[2].ColumnName = "性别";
dt.Columns[3].ColumnName = "学院";
dataGridView2.DataSource = dt;
}
public IActionResult Add(GradeModel model)
{
if (ModelState.IsValid)
{
var sub = GradeManager.FindSub(model.SubjectTitle);
var name = GradeManager.FindName(model.PupilsName);
var surname = GradeManager.FindSurname(model.PupilsSurname);
if (name != null && surname != null && sub != null && model.Grade > 0 && model.Grade < 11)
{
GradeManager.Create(model.Grade, model.Description, model.PupilsName, model.PupilsSurname, model.SubjectTitle);
return(RedirectToAction("Index"));
}
else if (name == null || surname == null)
{
ModelState.AddModelError("pup", "Pupil is not found!");
}
else if (sub == null)
{
ModelState.AddModelError("sub", "Subject is not found!");
}
else if (model.Grade < 0 || model.Grade > 10)
{
ModelState.AddModelError("gra", "Grade has to be from 0 - 10!");
}
}
return(View(model));
}
//public static List<GradeModel> Grades = new List<GradeModel>();
public IActionResult Index()
{
var model = GradeManager.GetAll().Select(g => g.ToModelG())
.ToList();
return(View(model));
}
public StudentResultController()
{
gradeManager = new GradeManager();
studentResultManager = new StudentResultManager();
enrollManager = new EnrollManager();
}
void Start()
{
instance = GetComponent <GradeManager>();
Vector2 offset = face.GetComponent <SpriteRenderer>().bounds.size;
CriaGrade(offset.x, offset.y);
}
public ResultController()
{
aStudentManager = new StudentManager();
aCourseManager = new CourseManager();
aGradeManager = new GradeManager();
aEnrollCourseManager = new EnrollCourseManager();
assignCourseGateway = new AssignCourseGateway();
}
public IActionResult ViewSubjectGrades(string name)
{
//kad meklēja pēc id:
//var model = GradeManager.GetSubjectGrades(oSubjectId).Select(u => u.ToModel()).ToList();
var model = GradeManager.GetSubjectGrades(name).Select(u => u.ToModel()).ToList();
return(View(model));
}
public static float GetAverageWithFinalTest(int semester)
{
if (GradeManager.LoadFinalTest()[semester] == -1)
{
return(0);
}
return((GetAverage(semester) + GradeManager.LoadFinalTest()[semester]) / 2);
}
public Grades()
{
this.InitializeComponent();
grades = GradeManager.GetAllGrades();
dtSmall = (DataTemplate)Resources["dtm_GradeList_Grades"];
dtEnlarged = (DataTemplate)Resources["dtm_GradeDetail_Grades"];
}
public static float GetAverage(int semester)
{
float[,] grade = GradeManager.LoadGrade();
if (grade[semester, 0] != -1 && grade[semester, 1] != -1 && grade[semester, 2] != -1)
{
return((grade[semester, 0] + grade[semester, 1] + grade[semester, 2]) / 3);
}
return(0);
}
public string GetGradeId(string name, string language)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
return(GradeManager.GetGradeId(name, language));
}
public string getGrade(string language)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
return(GradeManager.getJson(language));
}
private async void btn_DeleteGrade_Grades_Click(object sender, RoutedEventArgs e)
{
if (await delete_grades() == ContentDialogResult.Secondary)
{
GradeManager.DeleteGrade((lvw_Grades.SelectedItem as Grade).id);
Frame.Navigate(this.GetType());
Frame.GoBack();
}
}
//Save Student Result
public ActionResult SaveResult()
{
StudentManager aStudentManager = new StudentManager();
GradeManager aGradeManager = new GradeManager();
ViewBag.students = aStudentManager.GetAllStudents();
ViewBag.gredes = aGradeManager.GetAllGrades();
return(View());
}
public string update(string n, string r, string i, string lan)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
return(GradeManager.Update(n, r, i, lan));
}
public StudentResultController()
{
_courseManager = new CourseManager();
_departmentManager = new DepartmentManager();
_semesterManager = new SemesterManager();
aEnrollCourseManager = new EnrollCourseManager();
aGradeManager = new GradeManager();
aStudentResultManager = new StudentResultManager();
}
public string delete(string i)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
return(GradeManager.DeleteGradeByPK(int.Parse(i)).ToString());
}
public void ResetSemester()
{
for (int i = 0; i < 3; i++)
{
grade[GetCurrentSemester() - 1, i] = -1;
}
finalTest[GetCurrentSemester() - 1] = -1;
GradeManager.SaveData(grade, finalTest);
PlayerPrefs.Save();
}
public string GetGradeByLan(string lan)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
GradeManager gm = new GradeManager();
return(gm.GetGradeByLan(lan));
}
private void selectGradeLevelComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
GradeManager aGradeManager = new GradeManager();
Grade aGrade = new Grade();
aGrade.BasicAmount = aGradeManager.Get((int)selectGradeLevelComboBox.SelectedValue).BasicAmount;
aGrade.MedicalAllowance = aGradeManager.Get((int)selectGradeLevelComboBox.SelectedValue).MedicalAllowance;
aGrade.HouseRent = aGradeManager.Get((int)selectGradeLevelComboBox.SelectedValue).HouseRent;
totalSalaryTextBox.Text = aGrade.GetTotalSalary().ToString();
gradeId = (int)selectGradeLevelComboBox.SelectedValue;
}
private void Start()
{
//UpdateText
this.bUpdateText.text = "Upgrade (" + PlayerController.GetPlayerAttributes().updates + ")";
PlayerController.LoadPlayerAttributes();
//INIT
grade = GradeManager.LoadGrade();
finalTest = GradeManager.LoadFinalTest();
SaveData(grade, finalTest);
StartUiObjects();
}
private void saveButton_Click(object sender, EventArgs e)
{
Grade aGrade = new Grade();
aGrade.GradeLevel = levelTextBox.Text;
aGrade.BasicAmt = Convert.ToDecimal(basicAmtTextBox.Text);
aGrade.Medical = Convert.ToDecimal(medicalAmtTextBox.Text);
aGrade.HouseRent = Convert.ToDecimal(houseRentTextBox.Text);
GradeManager aGradeManager = new GradeManager();
string msg = aGradeManager.Save(aGrade);
MessageBox.Show(msg);
}
public static PupilModel ToModelP(this Pupils p)
{
{
return(new PupilModel()
{
Id = p.Id,
Name = p.Name,
Surname = p.Surname,
Birthyear = p.Birthyear,
ClassNumber = p.ClassNumber,
AverageGrade = Math.Round(GradeManager.Average(p.Name, p.Surname), 1)
});
}
}
