public async Task <ActionResult> Add(StudentModels model) { if (!ModelState.IsValid) { return(View("Error")); } try { StudnetDB studnetDB = new StudnetDB(); var student = new DAL.Student() { Id = model.StudentId, Age = model.Age, Name = model.Name }; foreach (var sub in model.Subjects.Where(s => s.Checked)) { student.Subjects.Add(studnetDB.Subjects.Where(s => s.SubjectId == sub.Id).First()); } studnetDB.Students.Add(student); await studnetDB.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); } catch { return(View("Error")); } }
private void btnSearch_Click(object sender, EventArgs e) { int countryId = 0, departmentId = 0; DAL.Student student = new DAL.Student(); student.Name = txtSearch.Text; if (cmbCity.SelectedValue != null && cmbCity.SelectedValue.ToString() != "") { student.CityId = Convert.ToInt32(cmbCity.SelectedValue); } if (cmbCountry.SelectedValue != null && cmbCountry.SelectedValue.ToString() != "") { countryId = Convert.ToInt32(cmbCountry.SelectedValue); } if (cmbProgram.SelectedValue != null && cmbProgram.SelectedValue.ToString() != "") { student.ProgramId = Convert.ToInt32(cmbProgram.SelectedValue); } if (cmbDepartment.SelectedValue != null && cmbDepartment.SelectedValue.ToString() != "") { departmentId = Convert.ToInt32(cmbCountry.SelectedValue); } StudentdataGridView.DataSource = student.Select(countryId, departmentId).Tables[0]; }
public int AddSave(string AddStudentNum, string AddStudentName, int AddSex, int AddClass, string AddSchool, string AddStudentPWD) { DAL.Student dal = new DAL.Student(); return(dal.AddSave(AddStudentNum, AddStudentName, AddSex, AddClass, AddSchool, AddStudentPWD)); }
public int EditSave(int EditId, string EditStudentNum, string EditStudentName, int EditSex, int EditClass, int EditSchool, string EditStudentPWD) { DAL.Student dal = new DAL.Student(); return(dal.EditSave(EditId, EditStudentNum, EditStudentName, EditSex, EditClass, EditSchool, EditStudentPWD)); }
public List <BO.Student> GetAllStudents() { DAL.Student dal_student = new DAL.Student(); List <BO.Student> lststudents = dal_student.GetAllStudents(); return(lststudents); }
public async Task <IActionResult> Edit(DAL.Student student) { await _student.EditStudent(student); await AddLog(student.FIRSTNAME + " adlı öğrenci güncellendi."); return(RedirectToAction("Edit", new { id = student.STUDENTID, success = true })); }
public int Delete(string[] Ids) { //防止注入式漏洞 string ids = string.Join(",", Ids); DAL.Student dal = new DAL.Student(); return(dal.Delete(ids)); }
public async Task <IActionResult> Add(DAL.Student student) { await _student.AddStudent(student); await AddLog(student.FIRSTNAME + " adlı öğrenci eklendi."); return(RedirectToAction("Add", new { success = true })); }
public bool Add(Model.Student student, string password, out string message) { message = ""; if (student.StuNo.Trim() == "") { message = "学号不可为空白"; return(false); } if (student.StuName.Trim() == "") { message = "姓名不可为空白"; return(false); } if (!Check.CheckYear(student.Grade.Trim())) { message = "请选择正确的年级"; return(false); } if (student.Subject.Trim() == "") { message = "专业不可为空白"; return(false); } if (student.College.Trim() == "") { message = "学院不可为空白"; return(false); } if (!Check.CheckMobilePhone(student.Phone)) { message = "请选择正确的手机号"; return(false); } if (student.Living.Trim() == "") { message = "居住地不可为空白"; return(false); } if (password.Trim() == "") { message = "默认密码不可空白"; return(false); } DAL.Student model = new DAL.Student(); if (model.CheckExist(student.StuNo.Trim())) { message = "该学生已被录入!!!"; return(false); } message = "导入成功"; model.Add(student); Model.StudentAccount account = new Model.StudentAccount(); account.StuNo = student.StuNo; account.Password = Encode.GenerateMD5(password); return(new DAL.StudentAccount().Add(account)); }
public async Task DeleteStudent(DAL.Student student) { var query = "DELETE FROM STUDENT WHERE STUDENTID=@LESSTUDENTIDSONID"; var parameters = new { STUDENTID = student.STUDENTID }; await Execute(query, parameters); }
public DAL.Student GetStudent(DAL.Student student) { var query = "SELECT TOP 1 * FROM STUDENT WHERE STUDENTID=@STUDENTID"; var parameters = new { STUDENTID = student.STUDENTID }; return(_connection.GetConnection().Query <DAL.Student>(query, parameters).SingleOrDefault()); }
public async Task AddStudent(DAL.Student student) { var query = "INSERT INTO STUDENT(CLASSID,IDENTITYNUMBER,FIRSTNAME,LASTNAME,NUMBER,STATUS) VALUES(@CLASSID,@IDENTITYNUMBER,@FIRSTNAME,@LASTNAME,@NUMBER,@STATUS)"; var parameters = new { CLASSID = student.CLASSID, IDENTITYNUMBER = student.IDENTITYNUMBER, FIRSTNAME = student.FIRSTNAME, LASTNAME = student.LASTNAME, NUMBER = student.NUMBER, STATUS = student.STATUS }; await Execute(query, parameters); }
public async Task <IActionResult> Delete() { if (!string.IsNullOrEmpty(RouteData.Values["id"].ToString())) { var id = int.Parse(RouteData.Values["id"].ToString()); var student = new DAL.Student { STUDENTID = id }; await _student.DeleteStudent(student); await AddLog(id + " numaralı öğrenci silindi."); } return(RedirectToAction("Index")); }
public async Task EditStudent(DAL.Student student) { var query = "UPDATE STUDENT SET CLASSID=@CLASSID,IDENTITYNUMBER=@IDENTITYNUMBER,FIRSTNAME=@FIRSTNAME,LASTNAME=@LASTNAME,NUMBER=@NUMBER,STATUS=@STATUS WHERE STUDENTID=@STUDENTID"; var parameters = new { CLASSID = student.CLASSID, IDENTITYNUMBER = student.IDENTITYNUMBER, FIRSTNAME = student.FIRSTNAME, LASTNAME = student.LASTNAME, STATUS = student.STATUS, NUMBER = student.NUMBER, STUDENTID = student.STUDENTID }; await Execute(query, parameters); }
public IActionResult Edit() { var data = new DAL.Student { STUDENTID = int.Parse(RouteData.Values["id"].ToString()) }; var studentItem = _student.GetStudent(data); if (!string.IsNullOrEmpty(Request.Query["success"])) { ViewData["alert"] = "swal('Öğrenci Düzenle', 'Öğrenci düzenlendi.', 'success');"; } ViewData["Classes"] = _class.GetClasses(); return(View(studentItem)); }
private async void button_Click_2(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); StudentIntImplementation a = new StudentIntImplementation(); AdmissionStudentIntImplementation b = new AdmissionStudentIntImplementation(); DAL.Student st = a.getStudent(id.Text); DAL.Admission_Student admissionSt = null; try { admissionSt = db.Admission_Students.FirstOrDefault(ee => ee.Admission_Student_ID.Equals(st.Admissin_Student_ID)); } catch { //do nothing } if (st == null) { await this.ShowMessageAsync("Error", "Student not found."); } else { DAL.Student_Regular_Fee stReg = db.Student_Regular_Fees.FirstOrDefault(ee => ee.Student_ID.Equals(st.Student_ID)); fullName.Text = admissionSt.Full_Name; grade.Text = admissionSt.Interested_Grade; group.Text = admissionSt.Group; /*if (stReg == null) * mo.Text = ""; * else * mark.Text = stResult.Viva_Exam_Mark;*/ } }
private void frmStudentEducation_Load(object sender, EventArgs e2) { MinimumSize = this.Size; DAL.Student s = new DAL.Student(); cmbStudent.DataSource = s.Select().Tables[0]; cmbStudent.DisplayMember = "name"; cmbStudent.ValueMember = "id"; cmbStudent.SelectedValue = -1; DAL.Education e = new DAL.Education(); cmbEducation.DataSource = e.Select().Tables[0]; cmbEducation.DisplayMember = "name"; cmbEducation.ValueMember = "id"; cmbEducation.SelectedValue = -1; DAL.EducationBoard eb = new DAL.EducationBoard(); cmbEducationBoard.DataSource = eb.Select().Tables[0]; cmbEducationBoard.DisplayMember = "name"; cmbEducationBoard.ValueMember = "id"; cmbEducationBoard.SelectedValue = -1; }
public List <Model.Student> GetList(int pageSize, int pageNumber, string ClassName, string StudentNum, string StudentName) { DAL.Student dal = new DAL.Student(); return(dal.GetList(pageSize, pageNumber, ClassName, StudentNum, StudentName)); }
public void DeleteStudent(BO.Student uistudents) { DAL.Student dal_student = new DAL.Student(); dal_student.DeleteStudent(uistudents); }
public void UpdateStudent(BO.Student uistudents) { DAL.Student dal_student = new DAL.Student(); dal_student.UpdateStudent(uistudents); }
public bool AddStudent(BO.Student uistudents) { DAL.Student dal_student = new DAL.Student(); return(dal_student.AddStudent(uistudents)); }
public List <Model.Class> GetClass(int SchoolId) { DAL.Student dal = new DAL.Student(); return(dal.GetClass(SchoolId)); }
public List <Model.School> GetSchool() { DAL.Student dal = new DAL.Student(); return(dal.GetSchool()); }
public int GetCount() { DAL.Student dal = new DAL.Student(); return(dal.GetCount()); }
public int AddExcel(List <Model.Student> list) { DAL.Student dal = new DAL.Student(); return(dal.AddExcel(list)); }
public Model.Student GetStudent(int Id) { DAL.Student dal = new DAL.Student(); return(dal.GetStudent(Id)); }