public int InsertDepartment(DepartmentClass dept)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmdDept = new SqlCommand("INSERT INTO Department(DepartmentID, DepartmentName) VALUES(@DeptID, @DeptName)", conn);
cmdDept.Parameters.Add(new SqlParameter("@DeptID", System.Data.SqlDbType.NVarChar));
cmdDept.Parameters["@DeptID"].Value = dept.DepartmentID;
cmdDept.Parameters.Add(new SqlParameter("@DeptName", System.Data.SqlDbType.NVarChar));
cmdDept.Parameters["@DeptName"].Value = dept.DepartmentName;
try
{
conn.Open();
return(cmdDept.ExecuteNonQuery());
}
catch (SqlException ex)
{
throw new ApplicationException("Error inserting department" + ex.Message);
}
finally
{
conn.Close();
}
}
}
public ActionResult NewDepartment(string name)
{
DepartmentClass department = new DepartmentClass(name);
department.Save();
return(RedirectToAction("Department"));
}
public ActionResult AssignStudents()
{
Dictionary <string, object> allInfo = new Dictionary <string, object>();
List <StudentClass> students = StudentClass.GetAll();
List <DepartmentClass> departments = DepartmentClass.GetAll();
allInfo.Add("students", students);
allInfo.Add("departments", departments);
return(View(allInfo));
}
public EditDepartment(DepartmentClass dept, IProcessInterface deptprocess)
{
InitializeComponent();
DeptClass = dept;
textBox1.Text = dept.Department_Name;
processQuery = deptprocess;
}
public ActionResult AssignCourses()
{
Dictionary <string, object> allInfo = new Dictionary <string, object>();
List <CourseClass> courses = CourseClass.GetAll();
List <DepartmentClass> departments = DepartmentClass.GetAll();
allInfo.Add("courses", courses);
allInfo.Add("departments", departments);
return(View(allInfo));
}
public ActionResult ShowDepartment(int id)
{
Dictionary <string, object> allInfo = new Dictionary <string, object>();
List <DepartmentClass> department = DepartmentClass.FindById(id);
List <StudentClass> students = JoinStudentDepartmentClass.GetStudentsByDepartmentId(id);
List <CourseClass> courses = JoinCourseDepartmentClass.GetCoursesByDepartmentId(id);
allInfo.Add("students", students);
allInfo.Add("courses", courses);
allInfo.Add("department", department);
return(View("ShowDepartment", allInfo));
}
public ActionResult Department()
{
List <DepartmentClass> departments = DepartmentClass.GetAll();
return(View("NewDepartment", departments));
}
public void Initialize()
{
_department = new DepartmentClass();
_target = new PrivateObject(_department);
}
public DataTable SelectedForUpdateDepartment(DepartmentClass DepartmentCode)
{
return(dal.SelectedForUpdateDepartment(DepartmentCode));
}
public int UpdateDepartment(DepartmentClass dep)
{
return(dal.UpdateDepartment(dep));
}
public DataTable Report_DislayDepartmentByBuilding(DepartmentClass department)
{
return(dal.DisplayDepartByBuilding(department));
}
public int AddDepartment(DepartmentClass department)
{
return(dal.AddDepartment(department));
}
