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