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