public static void UploadTable(string path) { try { string[] Load = File.ReadAllLines(path); using (AccidentContext db = new AccidentContext()) { foreach (var VARIABLE in Load) { try { string[] Loads = VARIABLE.Split(new char[] { ';' }); AccidentObj accident = new AccidentObj(); accident.DataTime = Loads[1]; accident.Adress = Loads[2]; accident.Accident = Loads[3]; accident.TimeAccident = Loads[4]; accident.AddDispetcher = Loads[5]; accident.RemoveDispetcher = Loads[6]; accident.Computer = Loads[7]; accident.District = Loads[8]; accident.Kind = Loads[9]; db.Accidents.Add(accident); } catch {} } db.SaveChanges(); } } catch (Exception e) { myException = new MyException(e); } }
public void timer1_Tick(object sender, EventArgs e) { try { timer1.Interval = 10000; List <AccidentObj> AccidentList = new List <AccidentObj>(); using (AccidentContext db = new AccidentContext()) { var kinds = new[] { "Удален", "Изменен" }; var accidents = db.Accidents.Where(p => !kinds.Contains(p.Kind)); foreach (var VARIABLE in accidents) { AccidentList.Add(VARIABLE); } } if (SizeFont != "") { AccidentObj.AccidentList = AccidentList.GetRange(0, AccidentList.Count); ListViewCompleting(sender, e); } if (!AccidentObj.GetHash(AccidentList, AccidentObj.AccidentList)) { AccidentObj.AccidentList = AccidentList.GetRange(0, AccidentList.Count); ListViewCompleting(sender, e); } } catch (Exception e1) { myException = new MyException(e1); } }
/// <summary> /// Добавление происшествия /// </summary> /// <param name="district">Район</param> /// <param name="adress">Адрес</param> /// <param name="accident">Происшествие</param> /// <param name="timeAccident">Время происшествия</param> public static void AddAccident(AccidentObj accident) { try { using (AccidentContext db = new AccidentContext()) { db.Accidents.Add(accident); db.SaveChanges(); } } catch (Exception e) { myException = new MyException(e); } }
/// <summary> /// создание таблицы /// </summary> public static void CreateTable() { try { using (AccidentContext db = new AccidentContext()) { AccidentObj accident = new AccidentObj("", "", "", ""); db.Accidents.Add(accident); db.SaveChanges(); } } catch (Exception e) { myException = new MyException(e); } }
/// <summary> /// Удаление происшествия /// </summary> /// <param name="objAccident"></param> public static void DeleteAccident(AccidentObj accident) { try { using (AccidentContext db = new AccidentContext()) { var accidents = db.Accidents.Where(p => p.DataTime == accident.DataTime); accidents.FirstOrDefault().Kind = "Удален"; accidents.FirstOrDefault().RemoveDispetcher = Environment.UserName; db.SaveChanges(); } } catch (Exception e) { myException = new MyException(e); } Transfer = true; }
public static void ChangeAccident(AccidentObj oldAccident, AccidentObj newAccident) { try { using (AccidentContext db = new AccidentContext()) { var accidents = db.Accidents.Where(p => p.DataTime == oldAccident.DataTime); accidents.FirstOrDefault().Kind = "Изменен"; accidents.FirstOrDefault().RemoveDispetcher = Environment.UserName; db.Accidents.Add(newAccident); db.SaveChanges(); } } catch (Exception e) { myException = new MyException(e); } Transfer = true; //AccidentList = copyAccidents.GetRange(0, copyAccidents.Count); }
public StoryForm() { InitializeComponent(); try { AccidentHistoryList = new List <AccidentObj>(); using (AccidentContext db = new AccidentContext()) { var accidents = db.Accidents; foreach (var VARIABLE in accidents) { AccidentHistoryList.Add(VARIABLE); } } } catch (Exception e1) { myException = new MyException(e1); } CreateHeadersAndFillListView(); }
/// <summary> /// событие заполнения ListView /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void ListViewCompleting(object sender, EventArgs e) { try { ListViewItem lvi; ListViewItem.ListViewSubItem lvsi; string t = sender.ToString(); switch (t) { case "System.Windows.Forms.Button, Text: ЮГ": if (_buttonSouthEnabled) { button_South.BackColor = System.Drawing.Color.White; _buttonSouthEnabled = false; } else { button_South.BackColor = System.Drawing.Color.Red; _buttonSouthEnabled = true; } break; case "System.Windows.Forms.Button, Text: СЕВЕР": if (_buttonNordEnabled) { button_Nord.BackColor = System.Drawing.Color.White; _buttonNordEnabled = false; } else { button_Nord.BackColor = System.Drawing.Color.Aqua; _buttonNordEnabled = true; } break; case "System.Windows.Forms.Button, Text: ЗАО": if (_buttonVasEnabled) { button_Vas.BackColor = System.Drawing.Color.White; _buttonVasEnabled = false; } else { button_Vas.BackColor = System.Drawing.Color.Green; _buttonVasEnabled = true; } break; case "System.Windows.Forms.Button, Text: ЖКС3": if (_buttonGks3Enabled) { button_GKS3.BackColor = System.Drawing.Color.White; _buttonGks3Enabled = false; } else { button_GKS3.BackColor = System.Drawing.Color.Yellow; _buttonGks3Enabled = true; } break; case "System.Windows.Forms.Button, Text: ЛИФТЫ": if (_buttonElevEnabled) { button_Elev.BackColor = System.Drawing.Color.White; _buttonElevEnabled = false; } else { button_Elev.BackColor = System.Drawing.Color.DarkOrange; _buttonElevEnabled = true; } break; case "System.Windows.Forms.Button, Text: ИНФО": if (_buttonInfoEnabled) { button_Info.BackColor = System.Drawing.Color.White; _buttonInfoEnabled = false; } else { button_Info.BackColor = System.Drawing.Color.Pink; _buttonInfoEnabled = true; } break; default: break; } listViewAccident.Items.Clear(); if (AccidentObj.AccidentList == null) { return; } using (AccidentContext db = new AccidentContext()) { List <string> districtList = new List <string>(); if (_buttonGks3Enabled) { districtList.Add("ЖКС3"); } if (_buttonNordEnabled) { districtList.Add("СЕВЕР"); } if (_buttonSouthEnabled) { districtList.Add("ЮГ"); } if (_buttonVasEnabled) { districtList.Add("ЗАО"); } if (_buttonElevEnabled) { districtList.Add("ЛИФТЫ"); } if (_buttonInfoEnabled) { districtList.Add("ИНФО"); } var accidents = AccidentObj.AccidentList.Where(p => districtList.Contains(p.District)); for (int i = 0; i < accidents.Count(); i++) { lvi = new ListViewItem(); ChangeFont(lvi); lvi.Text = accidents.ElementAt(i).DataTime; lvsi = new ListViewItem.ListViewSubItem(); ChangeFont(lvi); lvsi.Text = accidents.ElementAt(i).Adress; lvi.SubItems.Add(lvsi); lvsi = new ListViewItem.ListViewSubItem(); ChangeFont(lvi); lvsi.Text = accidents.ElementAt(i).Accident; lvi.SubItems.Add(lvsi); lvsi = new ListViewItem.ListViewSubItem(); ChangeFont(lvi); lvsi.Text = accidents.ElementAt(i).TimeAccident; lvi.SubItems.Add(lvsi); lvsi = new ListViewItem.ListViewSubItem(); ChangeFont(lvi); lvsi.Text = accidents.ElementAt(i).AddDispetcher; lvi.SubItems.Add(lvsi); listViewAccident.Items.Add(lvi); } SizeFont = ""; } } catch (Exception e1) { myException = new MyException(e1); } }