// Insert
public bool Insert(StudentFaculty aStudentFaculty)
{
try
{
db.StudentFaculties.InsertOnSubmit(aStudentFaculty);
db.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
throw new Exception("StudentFacultyBO.Insert" + ex.ToString());
}
}
private void SaveInforStudent()
{
try
{
Student stu = new Student();
stu.Stu_Code = txtStuCode.Text;
stu.Stu_Name = txtStuName.Text;
stu.Stu_DateOfBirth = editDate.Value;
stu.Stu_HomeTown = txtNs.Text;
stu.Stu_Address = txtAddress.Text;
stu.Stu_PhoneNumber = txtPhone.Text;
stu.Stu_Ethnic = txtEth.Text;
stu.Stu_Religion = txtReligion.Text;
stu.Stu_StudyStatus = 1;
// xu ly khoa va chuyen nganh
StudentFaculty stFa = new StudentFaculty();
stFa.Stu_Code = stu.Stu_Code;
stFa.Fac_Code = aFacultyBO.Select_ByName(cmbFaculty.SelectedValue.ToString()).Select(b => b.Fac_Code).FirstOrDefault();
stFa.Spe_Code = aSpecializationBO.Select_ByName(cmbSpecialization.SelectedValue.ToString()).Select(b => b.Spe_Code).FirstOrDefault();
if (txtStuCode.Text != "" && txtStuName.Text != "" && txtAddress.Text != "") {
if (aStudentBO.Insert(stu) && aStudentFacultyBO.Insert(stFa)) {
MessageBox.Show("Thêm thành công", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else {
MessageBox.Show("Thêm thất bại", "Thất bại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else {
MessageBox.Show("Không được để trống mã, tên sinh viên và địa chỉ.", "Thất bại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex) {
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Update
public bool Update(StudentFaculty aStudentFaculty)
{
try
{
var editObj = db.StudentFaculties.Where(b => b.Stu_Code == aStudentFaculty.Stu_Code && b.Fac_Code == aStudentFaculty.Fac_Code && b.Spe_Code == aStudentFaculty.Spe_Code).FirstOrDefault();
editObj.Sfa_Status = aStudentFaculty.Sfa_Status;
db.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
throw new Exception("StudentFacultyBO.Update" + ex.ToString());
}
}
private void SaveInforStudent()
{
try
{
Student stu = new Student();
stu.Stu_Code = txtStuCode.Text;
stu.Stu_Name = txtStuName.Text;
stu.Stu_DateOfBirth = editDate.Value;
stu.Stu_HomeTown = txtNs.Text;
stu.Stu_Address = txtAddress.Text;
stu.Stu_PhoneNumber = txtPhone.Text;
stu.Stu_Ethnic = txtEth.Text;
stu.Stu_Religion = txtReligion.Text;
// xu ly khoa va chuyen nganh
StudentFaculty stFa = new StudentFaculty();
//if (cmbFaculty.SelectedItem != null && cmbSpecialization.SelectedItem != null) {
// stFa.Stu_Code = stu.Stu_Code;
// var q = from m in db.Faculties where m.Fac_Name == cmbFaculty.SelectedItem select m.Fac_Code;
// stFa.Fac_Code = Int32.Parse(q.ToString()); // convert from string to int
// var p = from m in db.Specializations where m.Spe_Name == cmbSpecialization.SelectedItem select m.Spe_Code;
// stFa.Spe_Code = Int32.Parse(p.ToString());
//}
stFa.Stu_Code = stu.Stu_Code;
List<int> CurrentFaculty = db.Faculties.Where(b => b.Fac_Name == cmbFaculty.SelectedValue.ToString()).Select(b => b.Fac_Code).Distinct().ToList();
List<int> CurrentSpecialization = db.Specializations.Where(b => b.Spe_Name == cmbSpecialization.SelectedValue.ToString()).Select(b => b.Spe_Code).Distinct().ToList();
stFa.Fac_Code = CurrentFaculty[0];
stFa.Spe_Code = CurrentSpecialization[0];
// get data for StudentEN object
//stEN.setValue(stu);
if (txtStuCode.Text != "" && txtStuName.Text != "" && txtAddress.Text != "") {
db.Students.InsertOnSubmit(stu);
db.StudentFaculties.InsertOnSubmit(stFa);
db.SubmitChanges();
if (db.Students.Count() > 0) {
MessageBox.Show("Thêm thành công", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else {
MessageBox.Show("Thêm thất bại", "Thất bại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else {
MessageBox.Show("Không được để trống mã,tên sinh viên và địa chỉ.", "Thất bại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex) {
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void setValue( StudentFaculty aStudentFaculty ) {
this.StudentFacultyStu_Code = aStudentFaculty.Stu_Code;
this.StudentFacultyFac_Code = aStudentFaculty.Fac_Code;
this.StudentFacultySpe_Code = aStudentFaculty.Spe_Code;
}
partial void DeleteStudentFaculty(StudentFaculty instance);
partial void UpdateStudentFaculty(StudentFaculty instance);
partial void InsertStudentFaculty(StudentFaculty instance);
