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