public TracksManagerGUI(Manager database) { localization = new System.ComponentModel.ComponentResourceManager(typeof(WorkerTimeStrings)); this.database = database; InitializeComponent(); this.Text = localization.GetString("String18") + " " + localization.GetString("String19"); }
public TrackManagerEdit(Manager database, Track track) { localization = new System.ComponentModel.ComponentResourceManager(typeof(WorkerTimeStrings)); this.database = database; this.track = track; this.Text = localization.GetString("String18") + " " + localization.GetString("String20"); InitializeComponent(); }
public GenericManagerGUI(Manager database, String title, String table, String fields) { localization = new System.ComponentModel.ComponentResourceManager(typeof(WorkerTimeStrings)); this.database = database; this.table = table; this.fields = fields; InitializeComponent(); this.Text = localization.GetString("String18") + " " + title.ToLower(); }
public static void PopulateComboBoxProjects(Manager database, ComboBox comboBoxProject) { comboBoxProject.Items.Clear(); comboBoxProject.Text = ""; DbDataReader reader = database.ExecuteReader("SELECT ID,Name FROM Projects"); while (reader.Read()) { ComboListItem temp = new ComboListItem(); temp.ShortName = reader[0].ToString(); temp.LongName = (String)reader[1]; comboBoxProject.Items.Add(temp); } reader.Close(); if (comboBoxProject.Items.Count > 0) comboBoxProject.SelectedIndex = 0; }
public static Track GetTrack(Manager database, Int32 ID) { Track track; DbDataReader reader = database.ExecuteReader("SELECT * FROM Tracks WHERE ID='" + ID + "'"); reader.Read(); if (reader.HasRows) { track = new Track(Int32.Parse(reader["ProjectID"].ToString()), Int32.Parse(reader["ActivityID"].ToString())); track.ID = Int32.Parse(reader["ID"].ToString()); track.startTime = (DateTime)reader["Start"]; track.endTime = (DateTime)reader["End"]; } else { throw new ApplicationException("Contagem não encontrada na base de dados"); } reader.Close(); return track; }
public static void PopulateComboBoxProjects(Manager database, ComboBox comboBoxProject, String projectId) { PopulateComboBoxProjects(database,comboBoxProject); SelectComboBoxProjectItem(database,comboBoxProject, projectId); }
public static void PopulateComboBoxActivities(Manager database, ComboBox comboBoxProject, ComboBox comboBoxActivity, String activityId) { PopulateComboBoxActivities(database, comboBoxProject, comboBoxActivity); SelectComboBoxActivityItem(database, comboBoxActivity, activityId); }
public static void SelectComboBoxProjectItem(Manager database, ComboBox comboBoxProject, String projectId) { for (int i = 0; i < comboBoxProject.Items.Count; i++) { if (((ComboListItem)comboBoxProject.Items[i]).ShortName == projectId) { comboBoxProject.SelectedIndex = i; } } }
public static void SelectComboBoxActivityItem(Manager database, ComboBox comboBoxActivity, String activityId) { for (int i = 0; i < comboBoxActivity.Items.Count; i++) { if (((ComboListItem)comboBoxActivity.Items[i]).ShortName == activityId) { comboBoxActivity.SelectedIndex = i; } } }
public void Save(Manager database) { if (ID == 0) database.ExecuteNonQuery("INSERT INTO Tracks (ProjectID, ActivityID, Start, End, Duration) VALUES('" + projectId.ToString() + "','" + activityId.ToString() + "','" + startTime.ToString("s", DateTimeFormatInfo.InvariantInfo) + "','" + endTime.ToString("s", DateTimeFormatInfo.InvariantInfo) + "','" + ElapsedTime().Ticks + "')"); else database.ExecuteNonQuery("UPDATE Tracks SET ProjectID='" + projectId.ToString() + "', ActivityID='" + activityId.ToString() + "', Start='" + startTime.ToString("s", DateTimeFormatInfo.InvariantInfo) + "', End='" + endTime.ToString("s", DateTimeFormatInfo.InvariantInfo) + "', Duration='" + ElapsedTime().Ticks + "' WHERE ID='" + ID + "'"); }
public void Delete(Manager database) { database.ExecuteNonQuery("DELETE FROM Tracks WHERE ID = '" + this.ID + "'"); ID = new Int32(); projectId = new Int32(); activityId = new Int32(); startTime = new DateTime(); endTime = new DateTime(); }