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