public void AddFaculty() { Faculty_BLL facultyBLL = new Faculty_BLL(); Faculty faculty = new Faculty(); //Accesing to the attributes from my faculty object faculty.Code = txtCode.Text; faculty.Name = txtName.Text; faculty.Creation_date = Convert.ToDateTime(txtCreationDate.Text); faculty.University = int.Parse(ddlUniversity.SelectedValue); faculty.City = int.Parse(ddlCity.SelectedValue); try { //LINQ SubjectFaculty subjectFaculty; List <SubjectFaculty> subjectList = new List <SubjectFaculty>(); foreach (ListItem item in SubjectListBox.Items) { if (item.Selected) { subjectFaculty = new SubjectFaculty(); subjectFaculty.subject = int.Parse(item.Value); subjectFaculty.faculty = faculty.ID_Faculty; subjectList.Add(subjectFaculty); } } facultyBLL.AddFaculty(faculty//,subjectList ); ClearFields(); } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Registration", "alert('" + ex.Message + "')", true); } }
//protected void ddlSubject_SelectedIndexChanged(object sender, EventArgs e) //{ // txtDept.Text = ""; // ddlSem.SelectedIndex = ddlFaculty.SelectedIndex = ddlValid.SelectedIndex = 0; // var getsubsem=(from s in ue.Subjects // join u in ue.Users // on s.Users.uid equals u.uid // where s.sname==ddlSubject.Text // select new {s,u}).FirstOrDefault(); // if (getsubsem != null) // { // var facultydept = (from c in ue.Courses // join u in ue.Users // on c.cid equals u.Courses.cid // where u.username == getsubsem.u.username // select c.cname).FirstOrDefault(); // ddlSem.Text = getsubsem.s.ssem.ToString(); // ddlFaculty.SelectedValue = getsubsem.u.username; // txtDept.Text = facultydept; // if(getsubsem.s.svalid==true) // ddlValid.SelectedIndex=0; // else // ddlValid.SelectedIndex=1; // } //} /// <summary> /// Subject details are updated on Submit.. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { try { var getSubject = (from s in ue.Subjects join c in ue.Courses on s.Courses.cid equals c.cid where s.sname == txtSubName.Text && c.cname == ddlCourse.Text select s).FirstOrDefault(); var faculty = (from u in ue.Users where u.username == ddlFaculty.Text select u).FirstOrDefault(); var subjectId = (int)Session["subject"]; var subjectFaculty = (from sf in ue.SubjectFaculty where sf.Subjects.sid == subjectId orderby sf.sfstartdate descending select sf.Users.uid).FirstOrDefault(); var subjectsFaculty = (from sf in ue.SubjectFaculty where sf.Subjects.sid == subjectId orderby sf.sfstartdate descending select sf).FirstOrDefault(); //var courseexistsinsub = (from s in ue.Subjects // join c in ue.Courses // on s.Courses.cid equals c.cid // where c.cname == ddlCourse.Text && s.sname == txtSubName.Text && s.sid != subjectid // select s).FirstOrDefault(); var course = (from c in ue.Courses where c.cname == ddlCourse.Text select c).FirstOrDefault(); if (ddlCourse.SelectedIndex != 0) { if (ddlFaculty.SelectedIndex != 0) { if (ddlSem.SelectedIndex != 0) { //if (courseexistsinsub == null) //{ getSubject.ssem = Convert.ToInt32(ddlSem.Text); if (subjectFaculty != faculty.uid) { subjectsFaculty.sfvalid = false; ue.SaveChanges(); SubjectFaculty updatedFaculty = new SubjectFaculty(); updatedFaculty.SubjectsReference.EntityKey = new System.Data.EntityKey("unitycollegeEntities1.Subjects", "sid", subjectId); updatedFaculty.UsersReference.EntityKey = new System.Data.EntityKey("unitycollegeEntities1.Users", "uid", faculty.uid); updatedFaculty.sfstartdate = DateTime.Now.Date; updatedFaculty.sfvalid = true; ue.AddToSubjectFaculty(updatedFaculty); ue.SaveChanges(); } //getSubject.UsersReference.EntityKey = new System.Data.EntityKey("unitycollegeEntities1.Users", "uid", faculty.uid); if (ddlValid.SelectedIndex == 0) { getSubject.svalid = true; var checkSubjectFaculty = (from sf in ue.SubjectFaculty where sf.Subjects.sid == subjectId orderby sf.sfstartdate descending select sf.Users.uid).FirstOrDefault(); var checkSubjectsFaculty = (from sf in ue.SubjectFaculty where sf.Subjects.sid == subjectId orderby sf.sfstartdate descending select sf).FirstOrDefault(); var getFaculty = (from u in ue.Users where u.uid == checkSubjectFaculty select u).FirstOrDefault(); if (getFaculty.uvalid == true) { checkSubjectsFaculty.sfvalid = true; } } else { getSubject.svalid = false; var makeSubjectFacultyFalse = (from sf in ue.SubjectFaculty where sf.Subjects.sid == subjectId select sf).ToList(); if (makeSubjectFacultyFalse.Count != 0) { foreach (var data in makeSubjectFacultyFalse) { data.sfvalid = false; } } } ue.SaveChanges(); lblMsg.Text = "Success!!!Record Updated!"; //txtDept.Text = ""; //ddlValid.SelectedIndex = ddlFaculty.SelectedIndex = ddlCourse.SelectedIndex = ddlSem.SelectedIndex = 0; //} //else // lblMsg.Text = "Subject already exists in selected course"; } else { lblMsg.Text = "No semester selected!"; } } else { lblMsg.Text = "No Faculty selected for Subject!"; } } else { lblMsg.Text = "No course selected!"; } } catch (Exception e1) { lblMsg.Text = "Error:" + e1.Message; } }
/// <summary> /// Changes for Subject are saved on Submit /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { try { var course = (from c in ue.Courses where c.cname == ddlCourse.Text select c).FirstOrDefault(); var user = (from u in ue.Users where u.username == ddlFaculty.Text select u).FirstOrDefault(); var subjectExists = (from c in ue.Courses join s in ue.Subjects on c.cid equals s.Courses.cid where c.cname == ddlCourse.Text && s.sname == txtSubName.Text select s).FirstOrDefault(); if (ddlCourse.SelectedIndex != 0) { if (ddlFaculty.SelectedIndex != 0) { if (ddlSem.SelectedIndex != 0) { //Check if subject exists for that selected course if (subjectExists == null) { Subjects newSubject = new Subjects(); newSubject.sname = txtSubName.Text; newSubject.CoursesReference.EntityKey = new System.Data.EntityKey("unitycollegeEntities1.Courses", "cid", course.cid); newSubject.ssem = Convert.ToInt32(ddlSem.Text); //newSubject.UsersReference.EntityKey = new System.Data.EntityKey("unitycollegeEntities1.Users", "uid", user.uid); if (ddlValid.SelectedIndex == 0) { newSubject.svalid = true; } else { newSubject.svalid = false; } ue.AddToSubjects(newSubject); ue.SaveChanges(); SubjectFaculty subjectFaculty = new SubjectFaculty(); subjectFaculty.SubjectsReference.EntityKey = new System.Data.EntityKey("unitycollegeEntities1.Subjects", "sid", newSubject.sid); subjectFaculty.UsersReference.EntityKey = new System.Data.EntityKey("unitycollegeEntities1.Users", "uid", user.uid); subjectFaculty.sfstartdate = DateTime.Now.Date; subjectFaculty.sfvalid = true; ue.AddToSubjectFaculty(subjectFaculty); ue.SaveChanges(); lblMsg.Text = "Success!!!Record Saved!"; txtSubName.Text = txtDept.Text = ""; ddlCourse.SelectedIndex = ddlSem.SelectedIndex = ddlValid.SelectedIndex = ddlFaculty.SelectedIndex = 0; } else { lblMsg.Text = "Subject Name:" + txtSubName.Text + " already exists for " + ddlCourse.Text; } } else { lblMsg.Text = "No semester selected!"; } } else { lblMsg.Text = "Faculty is required!"; } } else { lblMsg.Text = "No course selected!"; } } catch (Exception e1) { lblMsg.Text = "Error:" + e1.Message; } }
public void addFacultySubject(SubjectFaculty subject) { SubjectFaculty_DAL subjFaculty = new SubjectFaculty_DAL(); subjFaculty.addFacultySubject(subject); }