public void Delete_Faculty()
{
Faculty_BLL facultyBLL = new Faculty_BLL();
int ID_Faculty = int.Parse(lblID_Faculty.Text);
facultyBLL.Delete_Faculty(ID_Faculty);
}
//USING BLL as a bridge for the DAL
public List <object> LoadFaculty()
{
Faculty_BLL facultyBLL = new Faculty_BLL();
List <object> listFaculties = new List <object>();
listFaculties = facultyBLL.LoadFaculty();
//return my list type object
return(listFaculties);
}
//USING BLL as a bridge for the DAL
public DataTable LoadFaculty()
{
Faculty_BLL facultyBLL = new Faculty_BLL();
DataTable dtFaculty = new DataTable();
//Fill up the table with method LoadFaculty
dtFaculty = facultyBLL.LoadFaculty();
return(dtFaculty);
}
public void AddFaculty()
{
Faculty_BLL facultyBLL = new Faculty_BLL();
string Code = txtCode.Text;
string Name = txtName.Text;
DateTime Creation_Date = Convert.ToDateTime(txtCreationDate.Text);
int University = int.Parse(ddlUniversity.SelectedValue);
facultyBLL.AddFaculty(Code, Name, Creation_Date, University);
}
public void UpdateFaculty()
{
Faculty_BLL facultyBLL = new Faculty_BLL();
int ID_Faculty = int.Parse(lblID_Faculty.Text);
string Code = txtCode.Text;
string Name = txtName.Text;
DateTime Creation_Date = Convert.ToDateTime(txtCreationDate);
int University = int.Parse(ddlUniversity.SelectedValue);
//Modify values of each control
facultyBLL.UpdateFaculty(ID_Faculty, Code, Name, Creation_Date, University);
}
public void LoadFaculty(int ID_Faculty)
{
//Instance of BLL layer
Faculty_BLL faculty_BLL = new Faculty_BLL();
Faculty faculty = new Faculty();
faculty = faculty_BLL.LoadFaculty(ID_Faculty);
//Show each field of the selected row
lblID_Faculty.Text = faculty.ID_Faculty.ToString();
lblCode.Text = faculty.Code;
lblName.Text = faculty.Name;
lblCreation_date.Text = faculty.Creation_date.ToString().Substring(0, 10);
ddlUniversity.SelectedValue = faculty.University.ToString();
}
public void LoadFaculty(int ID_Faculty)
{
//Instance of BLL layer
Faculty_BLL faculty_BLL = new Faculty_BLL();
DataTable dtFaculty = new DataTable();
dtFaculty = faculty_BLL.LoadFaculty(ID_Faculty);
//Show each field of the selected row
lblID_Faculty.Text = dtFaculty.Rows[0]["ID_Faculty"].ToString();
txtCode.Text = dtFaculty.Rows[0]["Code"].ToString();
txtName.Text = dtFaculty.Rows[0]["Name"].ToString();
txtCreationDate.Text = dtFaculty.Rows[0]["Creation_date"].ToString();
ddlUniversity.SelectedValue = dtFaculty.Rows[0]["University"].ToString();
}
public void UpdateFaculty()
{
Faculty_BLL facultyBLL = new Faculty_BLL();
Faculty faculty = new Faculty();
faculty.ID_Faculty = int.Parse(lblID_Faculty.Text);
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);
//Modify values of each control
facultyBLL.UpdateFaculty(faculty);
}
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);
}
}
