public Department FindName(string name) { string query = "SELECT * FROM t_department WHERE name='" + name + "'"; aSqlConnection.Open(); aSqlCommand = new SqlCommand(query, aSqlConnection); SqlDataReader aSqlDataReader = aSqlCommand.ExecuteReader(); Department aDepartment; if (aSqlDataReader.HasRows) { aDepartment = new Department(); aSqlDataReader.Read(); aDepartment.Id = (int)aSqlDataReader["id"]; aDepartment.Code = aSqlDataReader["code"].ToString(); aDepartment.Name = aSqlDataReader["name"].ToString(); aSqlDataReader.Close(); aSqlConnection.Close(); return aDepartment; } else { aSqlDataReader.Close(); aSqlConnection.Close(); return null; } }
public CourseAssignToTeacher( int teacherId, int courseId, Department department, Teacher teacher, Course course) { Teacher_id = teacherId; Course_id = courseId; Department = department; Teacher = teacher; Course = course; }
private void saveButton_Click(object sender, EventArgs e) { if (codeTextBox.Text == "") { MessageBox.Show("insert code value"); return; } else if (nameTextBox.Text == "") { MessageBox.Show("insert name value"); return; } string code = codeTextBox.Text; string name = nameTextBox.Text; Department aDepartment = new Department(code, name); string msg = aDepartmentManager.Save(aDepartment); MessageBox.Show(msg); }
public List<Department> GetAllDepartments() { List<Department> departmentList = new List<Department>(); string query = "SELECT * FROM t_department"; aSqlCommand = new SqlCommand(query, aSqlConnection); aSqlConnection.Open(); SqlDataReader aSqlDataReader = aSqlCommand.ExecuteReader(); while (aSqlDataReader.Read()) { Department aDepartment = new Department(); aDepartment.Id = (int)aSqlDataReader["id"]; aDepartment.Code = aSqlDataReader["code"].ToString(); aDepartment.Name = aSqlDataReader["name"].ToString(); departmentList.Add(aDepartment); } aSqlDataReader.Close(); aSqlConnection.Close(); return departmentList; }
public string Save(Department aDepartment) { if (aDepartment.Code.Length >= 2 && aDepartment.Code.Length <= 7) { Department departmentForCodeCheck = aDepartmentGateway.FindCode(aDepartment.Code); Department departmentForNameCheck = aDepartmentGateway.FindName(aDepartment.Name); if (departmentForCodeCheck == null && departmentForNameCheck==null) { aDepartmentGateway.Save(aDepartment); return "Department added."; } else { return "Department CODE already exists."; } } else { return "Code length must be 2 to 7 characters long."; } }
public void Save(Department aDepartment) { string query = "INSERT INTO t_department VALUES('" + aDepartment.Code + "', '" + aDepartment.Name + "')"; aSqlConnection.Open(); aSqlCommand = new SqlCommand(query, aSqlConnection); aSqlCommand.ExecuteNonQuery(); aSqlConnection.Close(); }