public List<Department> GetAllDepartments() { try { List<Department> departments = new List<Department>(); connection.Open(); string departmentQuery = "SELECT * FROM t_Department"; command.CommandText = departmentQuery; command.Parameters.Clear(); SqlDataReader departmentReader = command.ExecuteReader(); while (departmentReader.Read()) { Department aDepartment = new Department(); aDepartment.DepartmentId = Convert.ToInt16(departmentReader[0].ToString()); aDepartment.DepartmentCode = departmentReader[1].ToString(); aDepartment.DepartmentName = departmentReader[2].ToString(); departments.Add(aDepartment); } return departments; } finally { connection.Close(); } }
private bool HasThisDepartmentIdExist(Department aDepartment) { List<Department> departments = new List<Department>(); departments = GetAllDepartments(); foreach (Department departmentObj in departments) { if (departmentObj.DepartmentCode == aDepartment.DepartmentCode) return true; } return false; }
protected void saveButton_Click(object sender, EventArgs e) { if (!IsValid) { return; } if (codeTextBox.Value.Length < 3) { msgLabel.ForeColor = Color.Red; msgLabel.Text = "Department Code Must be Three Character"; return; } DepartmentManager aDepartmentManager = new DepartmentManager(); try { aDepartment = new Department(); aDepartment.DepartmentCode = codeTextBox.Value; aDepartment.DepartmentName = nameTextBox.Value; string msg = aDepartmentManager.SaveDepartment(aDepartment); if (msg == "Saved") { msgLabel.ForeColor = Color.Green; msgLabel.Text = msg; ClearAllTextBoxses(); } else { msgLabel.ForeColor = Color.Red; msgLabel.Text = msg; } } catch (SqlException sqlException) { msgLabel.ForeColor = Color.Red; msgLabel.Text = "Database error.See details error: " + sqlException.Message; } catch (Exception exception) { msgLabel.ForeColor = Color.Red; string errorMessage = "Unknow error occured."; errorMessage += exception.Message; if (exception.InnerException != null) { errorMessage += exception.InnerException.Message; } msgLabel.Text = errorMessage; } }
public Department GetDepartment(Int16 departmentId) { aDepartmentGateway = new DepartmentGateway(); List<Department> departments = new List<Department>(); departments = GetAllDepartments(); Department aDepartment = new Department(); foreach (var department in departments) { if (department.DepartmentId == departmentId) { aDepartment.DepartmentId = department.DepartmentId; aDepartment.DepartmentCode = department.DepartmentCode; aDepartment.DepartmentName = department.DepartmentName; return aDepartment; } } return aDepartment; }
public string SaveDepartment(Department aDepartment) { aDepartmentGateway = new DepartmentGateway(); if (!HasThisDepartmentIdExist(aDepartment)) if (!HasThisDepartmentNameExist(aDepartment)) { return aDepartmentGateway.SaveDepartment(aDepartment); } else { return "This Department Name exist."; } else { return "This Department Code exist."; } }
public string SaveDepartment(Department aDepartment) { try { connection.Open(); string departmentAddQuery = "INSERT INTO t_Department VALUES(@code,@name)"; command.CommandText = departmentAddQuery; command.Parameters.Clear(); command.Parameters.AddWithValue("@code", aDepartment.DepartmentCode); command.Parameters.AddWithValue("@name", aDepartment.DepartmentName); command.ExecuteNonQuery(); return "Saved"; } finally { connection.Close(); } }