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