Пример #1
0
        /**
         * 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);
            }
        }
Пример #2
0
        /**
         * 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);
            }
        }