private void btnAdd_Click(object sender, EventArgs e)
{
string getGender;
if (rbtnFemale.Checked)
{
getGender = rbtnFemale.Text;
}
else
{
getGender = rbtnMale.Text;
}
var student = new Students
{
StudentNumber = Convert.ToInt32(txtBoxStudentID.Text),
FirstName = txtBoxFirstName.Text,
MI = txtBoxMI.Text,
LastName = txtBoxLastName.Text,
GradeLevel = (int)cbxGrade.SelectedItem,
Section = cbxSection.SelectedItem.ToString(),
Gender = getGender,
Password = (txtBoxLastName.Text + txtBoxStudentID.Text.Substring(txtBoxStudentID.TextLength - 4)),
};
var saved = new StudentDAO().InsertStudent(student);
RefreshData();
}
public void Student_GetByLastNameTest()
{
StudentDAO dao = new StudentDAO();
Students selectedStudent = dao.GetByLastName("Pet");
Assert.NotNull(selectedStudent);
}
public void Student_GetById()
{
StudentDAO dao = new StudentDAO();
Students selectedStudent = dao.GetById(2);
Assert.NotNull(selectedStudent);
}
private void LoadStudentGridView()
{
DataTable dt = StudentDAO.GetListStudent_Quang();
DataView dv = new DataView(dt);
dataGridViewStudent.DataSource = dv;
}
private void butResult_Click(object sender, EventArgs e)
{
StudentDAO stuDao = new StudentDAO();
stuList = stuDao.getAllStudents();
for (int i = 0; i < dgvStuList.Rows.Count; i++)
{
string _selectValue = dgvStuList.Rows[i].Cells["stuCheck"].EditedFormattedValue.ToString();
if (_selectValue == "True")
{
absenceName.Add(stuList[i].Name);
}
}
for (int i = 0; i < dgvStuList.Rows.Count; i++)
{
string _selectValue = dgvStuList.Rows[i].Cells["stuCause"].EditedFormattedValue.ToString();
if (_selectValue == "True")
{
askForLeaveName.Add(stuList[i].Name);
}
}
MessageBox.Show("本次应到学生：" + stuList.Count + "人，缺席：" + absenceName.Count + "人，请假人数：" + askForLeaveName.Count + "人");
//测试代码
FileStream fs = File.Create(@"C:/test.txt");
StreamWriter sw = new StreamWriter(fs);
sw.WriteLine(absenceName.Count);
sw.Close();
fs.Close();
}
public async Task <bool> Create(Student student)
{
StudentDAO studentDAO = new StudentDAO
{
Id = student.Id,
Address = student.Address,
Dob = student.Dob,
Email = student.Email,
Gender = student.Gender,
EthnicId = student.EthnicId,
HighSchoolId = student.HighSchoolId,
Name = student.Name,
Phone = student.Phone,
PlaceOfBirth = student.PlaceOfBirth,
TownId = student.TownId,
Identify = student.Identify,
Image = student.Image,
Biology = student.Biology,
Chemistry = student.Chemistry,
CivicEducation = student.CivicEducation,
Geography = student.Geography,
History = student.History,
Languages = student.Languages,
Literature = student.Literature,
Maths = student.Maths,
Physics = student.Physics,
Status = 0
};
tFContext.Student.Add(studentDAO);
await tFContext.SaveChangesAsync();
return(true);
}
private void btnLoadStu_Click_1(object sender, EventArgs e)
{
StudentDAO stuDao = new StudentDAO();
stuList = stuDao.getAllStudents();
int stuCounts = stuList.Count;
progressName.Maximum = stuCounts;
DataTable dt = new DataTable();
dt.Columns.Add("stuID", Type.GetType("System.String"));
dt.Columns.Add("stuName", Type.GetType("System.String"));
dt.Columns.Add("stuSex", Type.GetType("System.String"));
foreach (Student stu in stuList)
{
dt.Rows.Add(stu.Id, stu.Name, stu.Sex);
progressName.Value += 1;
Thread.Sleep(500);
}
dgvStuList.DataSource = dt;
setControlVisible();
}
private void btnLoadStu_Click(object sender, EventArgs e)
{
//获取学生数据源
StudentDAO stuDao = new StudentDAO();
stuList = stuDao.getAllStudents();
//进度条设置
int stuCounts = stuList.Count;//及时学生人数
progressName.Maximum = stuCounts;
//构造数据源
DataTable dt = new DataTable();
dt.Columns.Add("stuID", Type.GetType("System.String"));
dt.Columns.Add("stuName", Type.GetType("System.String"));
//数据加载以进度条方式展现
foreach (Student stu in stuList)
{
dt.Rows.Add(stu.Id, stu.Name);
progressName.Value += 1;//一个学生，进度条加1；
}
dgvStuList.DataSource = dt;
setControlVisible();
//显式学生人数
this.studentsNum.Text = "学生人数：" + stuDao.getStudentRecordsNums();
}
public List <Student> GetStudents()
{
StudentDAO sDAO = new StudentDAO();
List <Student> students0 = sDAO.GetStudents();
return(students0);
}
public DictantStudentModel(Dictant dictant, User user)
{
currentStudent = new StudentDAO();
currentDictant = dictant;
CurrentUser = user;
currentStudent.getPositionAndAnswer(currentDictant.ID, out positions, out answers);
}
public void AddStudent(string name, int courseId)
{
Student newStudent = new Student(name, courseId);
StudentDAO newSt = new StudentDAO();
newSt.Add(newStudent);
}
public ActionResult GetListStudentByLecture(int useid = -1)
{
var dao1 = new StudentDAO();
List <Student> x = dao1.FiltStudent(useid);
return(Json(x.Select(i => new {
ID = i.ID,
Name = i.Name,
Born = i.Born.ToShortDateString(),
Address = i.Address,
Position = i.Position,
Mobile = i.Mobile,
Email = i.Email,
Active = i.Active,
Password = i.Password,
UserName = i.UserName,
Status = i.Status,
CreateDate = i.CreateDate,
CreateBy = i.CreateBy,
IDClass = i.IDClass,
IDLecturer = i.IDLecturer,
Gender = i.Gender,
CMND = i.CMND
}),
JsonRequestBehavior.AllowGet));
}
public async Task <bool> Create(Student student)
{
StudentDAO studentDAO = examRegContext.Student.Where(s => s.Id.Equals(student.Id)).FirstOrDefault();
if (studentDAO == null)
{
studentDAO = new StudentDAO()
{
Id = student.Id,
StudentNumber = student.StudentNumber,
LastName = student.LastName,
GivenName = student.GivenName,
Birthday = student.Birthday,
Email = student.Email
};
await examRegContext.Student.AddAsync(studentDAO);
}
else
{
studentDAO.StudentNumber = student.StudentNumber;
studentDAO.LastName = student.LastName;
studentDAO.GivenName = student.GivenName;
studentDAO.Birthday = student.Birthday;
studentDAO.Email = student.Email;
};
await examRegContext.SaveChangesAsync();
return(true);
}
public void RefreshData()
{
var listStudents = new StudentDAO().GetStudents();
dgvStudents.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgvStudents.DataSource = listStudents;
}
public void Student_DeleteTest()
{
StudentDAO dao = new StudentDAO();
int studentsDeleted = dao.Delete(dao.GetByLastName("Desjardins").Id);
Assert.True(studentsDeleted != -1);
}
public StudentHomeGUI(string user)
{
InitializeComponent();
username = user;
Student s = StudentDAO.getStudentByUsername(username);
txtStuID.Text = s.StuID;
txtUsername.Text = s.Username;
txtName.Text = s.Name;
txtDob.Text = s.Dob.ToString();
if (s.Gender == 0)
{
txtGender.Text = "Female";
}
if (s.Gender == 1)
{
txtGender.Text = "Male";
}
if (s.BedNo != 0)
{
txtRoomName.Text = s.RoomName;
txtBedNo.Text = s.BedNo.ToString();
txtBookingDate.Text = s.BookingDate.ToString();
}
txtMoneyAccount.Text = s.MoneyAccount.ToString();
txtDebt.Text = s.Debt.ToString();
}
private void btnLoadStu_Click(object sender, EventArgs e)
{
//获取学生数据源
StudentDAO stuDao = new StudentDAO();
stuList = stuDao.getAllStudents();
//进度条设置
int stuCounts = stuList.Count;//及时学生人数
progressName.Maximum = stuCounts;
//构造数据源
DataTable dt = new DataTable();
dt.Columns.Add("stuID", Type.GetType("System.String"));
dt.Columns.Add("stuName", Type.GetType("System.String"));
dt.Columns.Add("stuSex", Type.GetType("System.String"));
//数据加载以进度条方式展现
foreach (Student stu in stuList)
{
dt.Rows.Add(stu.Id, stu.Name, stu.Sex);
progressName.Value += 1;//一个学生，进度条加1；
Thread.Sleep(50);
}
dataGVList.DataSource = dt;
setControlVisible();
}
public DataTable GetTotalTimeInAllClassesByStcode(string StudentCode)
{
SettingBusiness setb = new SettingBusiness();
StudentDAO s= new StudentDAO();
string term = s.GetLastTermBystcode(StudentCode);
DataTable dtTermJari = UD.GetTermJary();
string termJari = dtTermJari.Rows[0][0].ToString();
int salStudent = 0;
if (term!="")
salStudent=Convert.ToInt32( term.Split('-')[0]);
int jariSal = 0;
if(termJari!="")
jariSal = Convert.ToInt32( termJari.Split('-')[0]);
if (term==""|| salStudent<(jariSal-2))
return new DataTable() ;
SettingDTO setdto = setb.GetSettingByTermC(term);
if (setdto.ConName!="")
{
return spDAO.GetTotalTimeInAllClassesByStcode(StudentCode, term);
}
else
{
return new DataTable();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == 0)
{
Student student = new Student
{
full_name = nameText.Text,
username = usernameText.Text,
password = PasswordText.Text
};
StudentDAO studentDAO = new StudentDAO();
studentDAO.addStudent(student);
}
if (comboBox1.SelectedIndex == 1)
{
Teacher teacher = new Teacher
{
full_name = nameText.Text,
username = usernameText.Text,
password = PasswordText.Text
};
TeacherDAO teacherDAO = new TeacherDAO();
teacherDAO.addTeacher(teacher);
}
}
public void butResult1_Click(object sender, EventArgs e)
{
int m = 0;
int n = 0;
StudentDAO stuDao = new StudentDAO();
stuList = stuDao.getAllStudents();
//统计学生缺席情况
try
{
for (int i = 0; i < dgvRandom.Rows.Count; i++)
{
string _selectValue = dgvRandom.Rows[i].Cells["stuCheck1"].EditedFormattedValue.ToString();
if (_selectValue == "True")
{
m++;
}
}
for (int i = 0; i < dgvRandom.Rows.Count; i++)
{
string _selectValue = dgvRandom.Rows[i].Cells["stuCause1"].EditedFormattedValue.ToString();
if (_selectValue == "True")
{
n++;
}
}
MessageBox.Show("本次随机点到学生：" + int.Parse(textBox1.Text) + "人，缺席：" + m + "人，请假人数：" + n + "人");
}
catch
{
MessageBox.Show("输入有误！", "提示");
}
}
private void btnChangeClass_Click(object sender, EventArgs e)
{
bool checking = StudentDAO.ChangeClass(cbxClassName.SelectedValue.ToString(), txtStudentID.Text);
MessageBox.Show(checking ? "Change Class successful!" : "Change class failed!");
LoadStudentGridView();
}
public void Student_GetAll()
{
StudentDAO dao = new StudentDAO();
List <Students> allStudents = dao.GetAll();
Assert.NotNull(allStudents);
}
public List <CourseStudent> Get()
{
using (var dao = new CourseStudentDAO())
{
var query = dao.Query(e => true);
var coursesstudents = query.ToArray();
var cuenta3 = coursesstudents.Length;
using (var courdao = new CourseDAO())
{
var ids = coursesstudents.Select(e => e.IDCURSO).Distinct();
var courses = courdao.Query(e => ids.Contains(e.ID)).ToArray();
var cuenta2 = courses.Length;
using (var studendao = new StudentDAO())
{
var ids2 = coursesstudents.Select(e => e.IDESTUDIANTE).Distinct();
var students = studendao.Query(e => ids2.Contains(e.ID)).ToArray();
var cuenta = students.Length;
return(coursesstudents.Select(e => e.Map(students, courses)).ToList());
}
}
}
}
private void frmStudents_Load(object sender, EventArgs e)
{
var listStudents = new StudentDAO().GetStudents();
dgvStudents.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgvStudents.DataSource = listStudents;
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
var dao = new StudentDAO();
var result = dao.Login(model.Email, Encryptor.MD5Hash(model.Password));
if (result == 1)
{
var student = dao.GetById(model.Email);
var studentSession = new StudentLogin();
studentSession.Email = student.Email;
studentSession.ID = student.Id;
Session.Add(Common_Constants.STUDENT_SESSION, studentSession);
return(RedirectToAction("Index", "Home"));
}
else if (result == 0)
{
ModelState.AddModelError("", "Account is invalid");
}
else if (result == -1)
{
ModelState.AddModelError("", "Account was locked");
}
else if (result == -2)
{
ModelState.AddModelError("", "Email or Password is incorrect");
}
else
{
ModelState.AddModelError("", "Login false.");
}
}
return(View("Index"));
}
private void button3_Click(object sender, EventArgs e)
{
Mingdan = @"D:/缺课名单.txt";
File.WriteAllText(Mingdan, "");
//获取学生数据源
StudentDAO stuDao = new StudentDAO();
stuList = stuDao.getAllStudents();
//进度条设置
int stuCounts = stuList.Count;//及时学生人数
progressName.Maximum = stuCounts;
//构造数据源
DataTable dt = new DataTable();
dt.Columns.Add("stuID", Type.GetType("System.String"));
dt.Columns.Add("stuName", Type.GetType("System.String"));
//数据加载以进度条方式展现
foreach (Student stu in stuList)
{
dt.Rows.Add(stu.Id, stu.Name);
progressName.Value += 1;//一个学生，进度条加1；
Thread.Sleep(500);
}
dgvStuList.DataSource = dt;
setControlVisible();
}
public ActionResult SerachForLastname(string searchPhrase)
{
StudentDAO studentDAO = new StudentDAO();
List <StudentModel> searchResults = studentDAO.SerachForLastname(searchPhrase);
return(View("Index", searchResults));
}
public ActionResult Edit(int Id)
{
StudentDAO studentDAO = new StudentDAO();
StudentModel student = studentDAO.FetchOne(Id);
return(View("StudentForm", student));
}
public ActionResult Details(int Id)
{
StudentDAO studentDAO = new StudentDAO();
StudentModel student = studentDAO.FetchOne(Id);
return(View("Details", student));
}
/// <summary>
/// 绑定培训类型
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void Btn_OK_Click(object sender, EventArgs e)
{
var choosRow = _list.FindAll(m => m.ServiceID == currentService.ServiceID);
if (choosRow.Count != 1)
{
MsgBox.ShowInfo("请只选择一种服务");
return;
}
else
{
BuildBind_Para para = new BuildBind_Para();
BuildBind_Para outPara = null;//返回输出参数
para.vStudentStr = iStudentID;
foreach (var ser in choosRow)
{
para.iServiceID = ser.ServiceID;
}
para.iOperateID = Program.CurrentEmployee.EmployeeID;
bool result = new StudentDAO().BuildBind(para, out outPara);
if (result)
{
MsgBox.ShowInfo(outPara.vReturnValue);
}
else
{
MsgBox.ShowInfo(outPara.vReturnValue);
}
}
}
public bool isAuthencation(StudentDTO user)
{
StudentDAO ud = new StudentDAO();
if (ud.CheckPassword(user) == true)
return true;
else
return false;
}
