public int getCountOfEmployees() { clartItems(); DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT count(employee_id) as Expr1 FROM Employee"); handler.queryExecute(); while (handler.reader.Read()) { int count = int.Parse(handler.reader["Expr1"].ToString()); return count; } return 0; }
/// <summary> /// This method will return an object of class user if the user found. Otherwise it will return null /// </summary> /// <param name="username">The username of the user</param> /// <param name="password">The password of the user</param> /// <returns></returns> public static HRUser authenticate(string username, string password) { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM [User] WHERE user_name = @name AND user_password = @password"); handler.addParameter("@name", username); handler.addParameter("@password", password); handler.queryExecute(); while (handler.reader.Read()) { HRUser u = new HRUser(int.Parse(handler.reader["user_id"].ToString())); return u; } return null; }
public ArrayList getALL() { clartItems(); DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT employee_id AS Expr1, employee_lastName FROM Employee WHERE (employee_working_status = 1) ORDER BY employee_lastName"); handler.queryExecute(); while (handler.reader.Read()) { int employee_id = int.Parse(handler.reader["Expr1"].ToString()); Employee e = new Employee(); e.findById(employee_id); items.Add(e); } return items; }
public ArrayList getApproved() { clartItems(); DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT employee_id FROM Employee WHERE (employee_approved = @status) ORDER BY employee_lastName"); handler.addParameter("@status", "TRUE"); handler.queryExecute(); while (handler.reader.Read()) { int employee_id = int.Parse(handler.reader["employee_id"].ToString()); Employee e = new Employee(); e.findById(employee_id); items.Add(e); } return items; }
public static float getALLMontly() { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT SUM(income_amount) as total FROM Income WHERE income_per = @m"); handler.addParameter("@m", "Monthly"); handler.queryExecute(); try { while (handler.reader.Read()) { return float.Parse(handler.reader["total"].ToString()); } } catch (Exception ex) { return 0; } return 0; }
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; }
/// <summary> /// This will return an arraylist that contains the name and id and the department for each /// </summary> /// <returns></returns> public static ArrayList getALL() { ArrayList list = new ArrayList(); DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM Position ORDER BY position_department"); handler.queryExecute(); while (handler.reader.Read()) { int id = int.Parse(handler.reader["position_id"].ToString()); string name = handler.reader["position_name"].ToString(); int department_id = int.Parse(handler.reader["position_department"].ToString()); Position p = new Position(id,name,new Department(department_id)); list.Add(p); } return list; }
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; } } }
public int getCountOfEmployees() { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT COUNT(employee_id) AS countpositions FROM Employee WHERE (employee_position = @id)"); handler.addParameter("@id", this.id.ToString()); handler.queryExecute(); int count = 0; while (handler.reader.Read()) { count = int.Parse(handler.reader["countpositions"].ToString()); } return count; }
/** * Init * This method will take care of getting all the records for an employee * * @pram int id * @return none * */ public void init(int employee_id) { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM Record WHERE employee = @employee_id"); handler.addParameter("@employee_id", employee_id.ToString()); handler.queryExecute(); while (handler.reader.Read()) { int id = int.Parse(handler.reader["record_id"].ToString()); int number = int.Parse(handler.reader["record_number"].ToString()); DateTime issueDate = DateTime.Parse(handler.reader["record_issue_date"].ToString()); DateTime expireDate = DateTime.Parse(handler.reader["record_expire_date"].ToString()); string type = handler.reader["record_type"].ToString(); string note = handler.reader["record_note"].ToString(); bool approved = (handler.reader["record_approved"].ToString() == "1"); Record r = new Record(id,number,issueDate,expireDate,type,note,approved); items.Add(r); } }
/** * Init * This method will take care of getting all the Time Offs for an employee * * @pram int id * @return none * */ public void init(int employee_id) { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM Time_off WHERE employee = @employee_id"); handler.addParameter("@employee_id", employee_id.ToString()); handler.queryExecute(); while (handler.reader.Read()) { int id = int.Parse(handler.reader["time_off_id"].ToString()); DateTime startDate = DateTime.Parse(handler.reader["time_off_start_date"].ToString()); DateTime endDate = DateTime.Parse(handler.reader["time_off_end_date"].ToString()); string type = handler.reader["time_off_type"].ToString(); int paidDays = int.Parse(handler.reader["time_off_paid_days"].ToString()); bool approved = (handler.reader["time_off_approved"].ToString() == "1"); TimeOff t = new TimeOff(id,startDate,endDate,paidDays,type,approved); items.Add(t); } }
/** * Init * This method will take care of getting all the Documents for an employee * * @pram int id * @return none * */ public void init(int employee_id) { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM Document WHERE employee = @employee_id"); handler.addParameter("@employee_id", employee_id.ToString()); handler.queryExecute(); while (handler.reader.Read()) { int id = int.Parse(handler.reader["document_id"].ToString()); string name = handler.reader["document_name"].ToString(); string path = handler.reader["document_path"].ToString(); string note = handler.reader["document_note"].ToString(); int size = int.Parse(handler.reader["document_size"].ToString()); Document d = new Document(id, name, path, note, size); items.Add(d); } }
public int getPositionsCount() { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT COUNT(position_id) AS countpositions FROM Position WHERE (position_department = @id)"); handler.addParameter("@id", this.id.ToString()); handler.queryExecute(); int count = 0; while (handler.reader.Read()) { count = int.Parse(handler.reader["countpositions"].ToString()); } return count; }
private void init() { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM [Department] WHERE department_id = @id"); handler.addParameter("@id",this.id.ToString()); handler.queryExecute(); while (handler.reader.Read()) { this.name = handler.reader["department_name"].ToString(); } }
/// <summary> /// Getting the user information from the database /// </summary> private void init() { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM [User] WHERE user_id = @id"); handler.addParameter("@id", id.ToString()); handler.queryExecute(); while (handler.reader.Read()) { username = handler.reader["user_name"].ToString(); password = handler.reader["user_password"].ToString(); fullName = handler.reader["user_full_name"].ToString(); email = handler.reader["user_email"].ToString(); role = int.Parse(handler.reader["user_role"].ToString()); } }
/** * Init * */ public void init(int employee_id) { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM Income WHERE employee = @employee_id"); handler.addParameter("@employee_id", employee_id.ToString()); handler.queryExecute(); while (handler.reader.Read()) { int id = int.Parse(handler.reader["income_id"].ToString()); string type = handler.reader["income_type"].ToString(); string per = handler.reader["income_per"].ToString(); float amount = float.Parse(handler.reader["income_amount"].ToString()); Income income = new Income(id, type, per, amount); items.Add(income); } }
/// <summary> /// This will return an arraylist that contains the name and id and the department for each /// </summary> /// <returns></returns> public static ArrayList getByDepartmentID(int department_id) { ArrayList list = new ArrayList(); DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM Position WHERE position_department = @id"); handler.addParameter("@id", department_id.ToString()); handler.queryExecute(); while (handler.reader.Read()) { int id = int.Parse(handler.reader["position_id"].ToString()); string name = handler.reader["position_name"].ToString(); Position p = new Position(id, name, new Department(department_id)); list.Add(p); } return list; }
/** * Find By SSN * * This method should take the SSN as an argument and get the employee from database * */ public void findBySSN(int SSN) { DatabaseHandler handler = new DatabaseHandler(); handler.setSQL("SELECT * FROM Employee WHERE employee_SSN = @SSN"); handler.addParameter("@SSN", SSN.ToString()); handler.queryExecute(); while (handler.reader.Read()) { // Sending all the data to the big setter setObject(handler.reader); } }