private void dgView_LoadingRow(object sender, DataGridRowEventArgs e) { string row = e.Row.Item.ToString().Substring(e.Row.Item.ToString().IndexOf("=") + 2, e.Row.Item.ToString().IndexOf(",") - e.Row.Item.ToString().IndexOf("=") - 2); int _ID = int.Parse(row); Schedules _sc = Manager.db.Schedules.FirstOrDefault(n => n.ID == _ID); e.Row.Background = _sc.Confirmed ? new SolidColorBrush(Colors.White):new SolidColorBrush(Colors.Red); }
public ShadulesEdit(String schedules, ManageFly window) { InitializeComponent(); _window = window; schedules = schedules.Substring(schedules.IndexOf("=") + 2); _ID = int.Parse(schedules.Substring(0, schedules.IndexOf(","))); _sc = Manager.db.Schedules.FirstOrDefault(n => n.ID == _ID); DataContext = _sc; }
private void FlightCancel_Click(object sender, RoutedEventArgs e) { if (dgView.SelectedItem == null) { return; } string schedules = dgView.SelectedItem.ToString().Substring(dgView.SelectedItem.ToString().IndexOf("=") + 2, dgView.SelectedItem.ToString().IndexOf(",") - dgView.SelectedItem.ToString().IndexOf("=") - 2); int _ID = int.Parse(schedules); Schedules _sc = Manager.db.Schedules.FirstOrDefault(n => n.ID == _ID); _sc.Confirmed = !_sc.Confirmed; Manager.db.SaveChanges(); }
private void ImportChangesButton_Click(object sender, RoutedEventArgs e) { OpenFileDialog oFD = new OpenFileDialog(); oFD.Title = "Открытие файла"; oFD.Filter = "csv (*.csv)|*.csv|All files (*.*)|*.*"; oFD.RestoreDirectory = true; if (oFD.ShowDialog() == true) { StreamReader fileIn = new StreamReader(new FileStream(oFD.FileName.ToString(), FileMode.Open, FileAccess.Read)); string[] s = fileIn.ReadToEnd().Split('\n'); int miss = 0; int duplicate = 0; int successful = 0; for (int i = 0; i < s.Length; i++) { string[] q = s[i].Split(','); if (q[0] == "ADD") { try { DateTime dateTime = Convert.ToDateTime(q[1]); string flightNumber = q[3]; TimeSpan time = new TimeSpan(Convert.ToDateTime(q[2]).Ticks % 864000000000); if (Manager.db.Schedules.FirstOrDefault(n => dateTime == n.Date && n.Time == time && n.FlightNumber == flightNumber) != null) { DublicateTextBlock.Text = duplicate++.ToString(); goto Finish; } Schedules schedules = new Schedules(); schedules.Date = dateTime; schedules.Time = time; schedules.FlightNumber = flightNumber; var q1 = q[4].ToString(); var q2 = q[5].ToString(); int airports = Manager.db.Airports.FirstOrDefault(n => n.IATACode == q1).ID; int airports1 = Manager.db.Airports.FirstOrDefault(n => n.IATACode == q2).ID; Routes routes = Manager.db.Routes.FirstOrDefault(n => n.DepartureAirportID == airports && n.ArrivalAirportID == airports1); schedules.RouteID = routes.ID; schedules.AircraftID = Convert.ToInt32(q[6]); q[7] = q[7].Substring(0, q[7].IndexOf('.')); schedules.EconomyPrice = Convert.ToDecimal(q[7]); schedules.Confirmed = (q[8].Contains("OK")); Manager.db.Schedules.Add(schedules); SuccessfulTextBlock.Text = successful++.ToString(); Finish : { } } catch { miss++; } } if (q[0] == "EDIT") { DateTime dt = Convert.ToDateTime(q[1]); TimeSpan ts = new TimeSpan(Convert.ToDateTime(q[2]).Ticks % 864000000000); Schedules schedules = Manager.db.Schedules.FirstOrDefault(n => n.Date == dt && n.Time == ts); schedules.Confirmed = !schedules.Confirmed; } } Manager.db.SaveChanges(); RecordTextBlock.Text = miss.ToString(); fileIn.Close(); } }