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));
}
