Exemplo n.º 1
0
        public ScheduleItemWindow(ScheduleItem si_, DateTime dtClicked_)
            : base(Gtk.WindowType.Toplevel)
        {
            this.Build ();

            _dtClicked = dtClicked_;

            if ( si_ != null )
            {
                _si = si_;

                MySqlConnection conn = new MySqlConnection(Globals.ConnectionString);

                MySqlCommand cmd = new MySqlCommand("select * from tasks where t_id = @t_id;", conn);

                cmd.Parameters.Add( new MySqlParameter("t_id", MySqlDbType.VarChar)).Value = _si.TaskId;

                conn.Open();

                MySqlDataReader rdr = cmd.ExecuteReader();

                _task = new Task();

                if (rdr.Read())
                {
                    _task.Id = rdr.GetInt32(rdr.GetOrdinal("t_id"));
                    _task.Name = rdr.GetString(rdr.GetOrdinal("t_title"));
                    _task.TimeRequired = rdr.GetInt32(rdr.GetOrdinal("t_time_req"));
                    if (rdr.IsDBNull(rdr.GetOrdinal("t_depends"))) _task.Depends = 0;
                    else _task.Depends = rdr.GetInt32(rdr.GetOrdinal("t_depends"));
                    _task.TaskType = rdr.GetInt32(rdr.GetOrdinal("t_type"));
                }

                conn.Close();

                PopulateResources(_task.TaskType);

                _update = true;
            }
            else
            {
                _si = new ScheduleItem();
                if ( _dtClicked != DateTime.MinValue )
                {
                    txtStart.Text = _dtClicked.ToString();
                }
            }

            if (_update)
            {
                FillDetails();
            }
            else
            {
                btnDelete.Visible = false;
            }
        }
Exemplo n.º 2
0
        private void UpdateGraph()
        {
            DateTime dtWeekStart = Utils.GetWeekStart(dtCurrent);
            DateTime dtWeekEnd = Utils.GetWeekEnd(dtCurrent);

            lblCurrentWeek.Text = "<b>" + dtWeekStart.ToShortDateString() + " - " + dtWeekEnd.ToShortDateString() + "</b>";
            lblCurrentWeek.UseMarkup = true;

            MySqlConnection conn = new MySqlConnection(Globals.ConnectionString);

            MySqlCommand cmd = new MySqlCommand(
                "select s.s_id, s.t_id, s.t_start, s.t_finish, s.r_id, t.t_title, t.t_time_req, t.t_depends, r.r_name, y.tt_name " +
                "from schedule s, tasks t, resources r, tasktypes y " +
                "where s.t_id = t.t_id and s.r_id = r.r_id and t.t_type = y.tt_id and s.t_start between @week_start and @week_end"
                , conn);

            cmd.Parameters.Add(new MySqlParameter("week_start", MySqlDbType.DateTime)).Value = dtWeekStart;
            cmd.Parameters.Add(new MySqlParameter("week_end", MySqlDbType.DateTime)).Value = dtWeekEnd;

            conn.Open();

            MySqlDataReader rdr = cmd.ExecuteReader();

            List<ScheduleItem> items = new List<ScheduleItem>();

            while(rdr.Read())
            {
                int s_id = rdr.GetInt32(rdr.GetOrdinal("s_id"));

                int t_id = rdr.GetInt32(rdr.GetOrdinal("t_id"));

                DateTime t_start = DateTime.MinValue;
                DateTime t_finish = DateTime.MinValue;
                if (!rdr.IsDBNull(rdr.GetOrdinal("t_start")))
                    t_start = rdr.GetDateTime(rdr.GetOrdinal("t_start"));

                if (!rdr.IsDBNull(rdr.GetOrdinal("t_finish")))
                    t_finish = rdr.GetDateTime(rdr.GetOrdinal("t_finish"));

                int r_id = rdr.GetInt32(rdr.GetOrdinal("r_id"));

                string t_title = rdr.GetString( rdr.GetOrdinal( "t_title" ) );
                int t_time_req = rdr.GetInt32( rdr.GetOrdinal( "t_time_req" ) );

                string rname = rdr.GetString( rdr.GetOrdinal( "r_name" ) );
                string ttype = rdr.GetString( rdr.GetOrdinal( "tt_name" ) );

                ScheduleItem si = new ScheduleItem(s_id, t_id, r_id, t_start, t_finish, t_title, t_time_req, rname, ttype);
                items.Add(si);
            }

            conn.Close();

            sg.Items.Clear();
            sg.Items.AddRange(items);
            sg.WeekStart = dtWeekStart;
            sg.QueueDraw();
        }