public bool Equals(SavedRouteClass other) { if (other == null) { return(false); } return((this.Name == other.Name || (String.IsNullOrEmpty(this.Name) && String.IsNullOrEmpty(other.Name))) && this.StartDate == other.StartDate && this.EndDate == other.EndDate && this.Systems.Count == other.Systems.Count && this.Systems.Zip(other.Systems, (t, o) => t == o).All(v => v)); }
public static List <SavedRouteClass> GetAllSavedRoutes() { List <SavedRouteClass> retVal = new List <SavedRouteClass>(); try { using (SQLiteConnectionED cn = new SQLiteConnectionED()) { using (DbCommand cmd1 = cn.CreateCommand("select * from routes_expeditions")) { DataSet ds1 = SQLiteDBClass.SQLQueryText(cn, cmd1); if (ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0) { using (DbCommand cmd2 = cn.CreateCommand("select * from route_systems")) { DataSet ds2 = SQLiteDBClass.SQLQueryText(cn, cmd2); foreach (DataRow dr in ds1.Tables[0].Rows) { DataRow[] syslist = new DataRow[0]; if (ds2.Tables.Count != 0) { syslist = ds2.Tables[0].Select(String.Format("routeid = {0}", dr["id"]), "id ASC"); } SavedRouteClass sys = new SavedRouteClass(dr, syslist); retVal.Add(sys); } } } } } } catch { } return(retVal); }
public static List<SavedRouteClass> GetAllSavedRoutes() { List<SavedRouteClass> retVal = new List<SavedRouteClass>(); try { using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader)) { using (DbCommand cmd1 = cn.CreateCommand("select * from routes_expeditions")) { DataSet ds1 = SQLiteDBClass.SQLQueryText(cn, cmd1); if (ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0) { using (DbCommand cmd2 = cn.CreateCommand("select * from route_systems")) { DataSet ds2 = SQLiteDBClass.SQLQueryText(cn, cmd2); foreach (DataRow dr in ds1.Tables[0].Rows) { DataRow[] syslist = new DataRow[0]; if (ds2.Tables.Count != 0) { syslist = ds2.Tables[0].Select(String.Format("routeid = {0}", dr["id"]), "id ASC"); } SavedRouteClass sys = new SavedRouteClass(dr, syslist); retVal.Add(sys); } } } } } } catch { } return retVal; }
public bool Equals(SavedRouteClass other) { if (other == null) { return false; } return (this.Name == other.Name || (String.IsNullOrEmpty(this.Name) && String.IsNullOrEmpty(other.Name))) && this.StartDate == other.StartDate && this.EndDate == other.EndDate && this.Systems.Count == other.Systems.Count && this.Systems.Zip(other.Systems, (t, o) => t == o).All(v => v); }
private void UpdateRouteInfo(SavedRouteClass route) { route.Name = textBoxRouteName.Text.Trim(); route.Systems.Clear(); route.Systems.AddRange(dataGridViewRouteSystems.Rows.OfType<DataGridViewRow>().Where(r => r.Cells[0].Value != null).Select(r => r.Cells[0].Value.ToString())); if (dateTimePickerStartDate.Checked) { route.StartDate = dateTimePickerStartDate.Value.Date; if (dateTimePickerStartTime.Checked) { route.StartDate += dateTimePickerStartTime.Value.TimeOfDay; } } else { route.StartDate = null; } if (dateTimePickerEndDate.Checked) { route.EndDate = dateTimePickerEndDate.Value.Date; if (dateTimePickerEndTime.Checked) { route.EndDate += dateTimePickerEndTime.Value.TimeOfDay; } else { route.EndDate += new TimeSpan(23, 59, 59); } } else { route.EndDate = null; } }
private void toolStripButtonNew_Click(object sender, EventArgs e) { SavedRouteClass newroute = new SavedRouteClass(); UpdateRouteInfo(newroute); if (!newroute.Equals(_currentRoute)) { var result = MessageBox.Show(_discoveryForm, "There are unsaved changes to the current route.\r\nAre you sure you want to select another route without saving?", "Unsaved route", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (result == DialogResult.No) { toolStripComboBoxRouteSelection.SelectedIndex = _currentRouteIndex; return; } } ClearRoute(); }
private void toolStripComboBoxRouteSelection_SelectedIndexChanged(object sender, EventArgs e) { SavedRouteClass newroute = new SavedRouteClass(); UpdateRouteInfo(newroute); if (!newroute.Equals(_currentRoute)) { var result = MessageBox.Show(_discoveryForm, "There are unsaved changes to the current route.\r\nAre you sure you want to select another route without saving?", "Unsaved route", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (result == DialogResult.No) { toolStripComboBoxRouteSelection.SelectedIndex = _currentRouteIndex; return; } } _currentRouteIndex = toolStripComboBoxRouteSelection.SelectedIndex; _currentRoute = _savedRoutes[toolStripComboBoxRouteSelection.SelectedIndex]; dataGridViewRouteSystems.Rows.Clear(); textBoxRouteName.Text = _currentRoute.Name; if (_currentRoute.StartDate == null) { dateTimePickerStartDate.Value = DateTime.Now; dateTimePickerStartDate.Checked = false; dateTimePickerStartTime.Value = DateTime.Now; dateTimePickerStartTime.Checked = false; } else { dateTimePickerStartDate.Checked = true; dateTimePickerStartDate.Value = (DateTime)_currentRoute.StartDate; dateTimePickerStartTime.Value = (DateTime)_currentRoute.StartDate; if (((DateTime)_currentRoute.StartDate).TimeOfDay == new TimeSpan(0, 0, 0)) { dateTimePickerStartTime.Checked = false; } else { dateTimePickerStartTime.Checked = true; } } if (_currentRoute.EndDate == null) { dateTimePickerEndDate.Value = DateTime.Now; dateTimePickerEndDate.Checked = false; dateTimePickerEndTime.Value = DateTime.Now; dateTimePickerEndTime.Checked = false; } else { dateTimePickerEndDate.Checked = true; dateTimePickerEndDate.Value = (DateTime)_currentRoute.EndDate; dateTimePickerEndTime.Value = (DateTime)_currentRoute.EndDate; if (((DateTime)_currentRoute.EndDate).TimeOfDay == new TimeSpan(23, 59, 59)) { dateTimePickerEndTime.Checked = false; } else { dateTimePickerEndTime.Checked = true; } } foreach (string sysname in _currentRoute.Systems) { var rowobj = new object[] { sysname, "", "" }; dataGridViewRouteSystems.Rows.Add(rowobj); } for (int i = 0; i < dataGridViewRouteSystems.Rows.Count; i++) { dataGridViewRouteSystems[1, i].ReadOnly = true; dataGridViewRouteSystems[2, i].ReadOnly = true; UpdateSystemRow(i); } }
private void ClearRoute() { toolStripComboBoxRouteSelection.Text = ""; _currentRoute = new SavedRouteClass { Name = "" }; dataGridViewRouteSystems.Rows.Clear(); dateTimePickerStartDate.Value = DateTime.Now; dateTimePickerStartDate.Checked = false; dateTimePickerEndDate.Value = DateTime.Now; dateTimePickerEndDate.Checked = false; dateTimePickerStartTime.Value = DateTime.Now; dateTimePickerStartTime.Checked = false; dateTimePickerEndTime.Value = DateTime.Now; dateTimePickerEndTime.Checked = false; textBoxRouteName.Text = ""; }
private void buttonReverseRoute_Click(object sender, EventArgs e) { var route = new SavedRouteClass(); UpdateRouteInfo(route); dataGridViewRouteSystems.Rows.Clear(); InsertRows(0, route.Systems.Reverse<string>().ToArray()); }
public void InitControl(EDDiscoveryForm discoveryForm) { _discoveryForm = discoveryForm; edsm = new EDSMClass(); _currentRoute = new SavedRouteClass(""); _savedRoutes = new List<SavedRouteClass>(); }
public SavedRouteExpeditionControl() { InitializeComponent(); _currentRoute = new SavedRouteClass(""); }
public void InitControl(EDDiscoveryForm discoveryForm) { _discoveryForm = discoveryForm; _savedRoutes = SavedRouteClass.GetAllSavedRoutes(); foreach (var initroute in InitialRoutes) { if (!_savedRoutes.Any(r => r.Name == initroute.Name)) { initroute.Add(); _savedRoutes.Add(initroute); } } UpdateComboBox(); _currentRoute = new SavedRouteClass(""); edsm = new EDSMClass(); }