protected void Page_Load(object sender, EventArgs e) { // Get the id of the employee from the url and pass it to the employee object // Also we are saving the object in the class because we need to use it in all the moethds. try { department_id = int.Parse(Request.QueryString["id"]); this.department = new Department(department_id); if(!Page.IsPostBack) TextBox1.Text = department.Name; } catch (Exception exce) { Response.Redirect("departments.aspx"); } }
public static ArrayList getALL() { ArrayList departments = new ArrayList(); DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM [Department] ORDER BY department_name"); handler.queryExecute(); while (handler.reader.Read()) { string department_name = handler.reader["department_name"].ToString(); int department_id = int.Parse(handler.reader["department_id"].ToString()); Department d = new Department(department_id,department_name); departments.Add(d); } return departments; }
public Position(int id, string name, Department department) { this.id = id; this.name = name; this.department = department; }
private void init() { if (this.id != 0) { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM Position WHERE position_id = @id"); handler.addParameter("@id", this.id.ToString()); handler.queryExecute(); while (handler.reader.Read()) { this.name = handler.reader["position_name"].ToString(); int dep_id = int.Parse(handler.reader["position_department"].ToString()); Department d = new Department(dep_id); this.department = d; } } }