private void logOn_Click(object sender, RoutedEventArgs e) { using (var db = new SimpleScadaContext()) { var users = db.Users.OrderBy(p => p.Id); int countUsers = 0; passwordInfo.Content = ""; usernameInfo.Content = ""; foreach (var user in users) { if (user.User.Equals(txtUsername.Text) && user.Password.Equals(txtPassword.Text)) { countUsers++; securityLevel = user.Level; operatorName = user.User; //MessageBox.Show("Successfull"); MainScreen.loginScreen.Close(); } if (user.User.Equals(txtUsername.Text) && !user.Password.Equals(txtPassword.Text)) { countUsers++; passwordInfo.Content = "Wrong password!"; } } if (countUsers == 0) { usernameInfo.Content = $"User doesn't exist in database."; } } }
public Trend() { InitializeComponent(); actualTime = DateTime.Now; _timer1 = new System.Timers.Timer(1000); //Updates every second. _timer1.Elapsed += new ElapsedEventHandler(OnTimedEvent); SeriesCollection = new SeriesCollection { }; Labels = new List <string> { }; YFormatter = value => Math.Round(value, 2).ToString("") + MainScreen.variables.Find(p => p.Name.Equals(data.Last().MeasuringPoin)).MeasuringUnit; // Default measuring point will be LI_1 actualMeasuringPoint = "LI_1"; SeriesCollection.Add(new LineSeries { Title = "LI_1", Values = new ChartValues <double> { } }); Task.Run(() => { using (var db = new SimpleScadaContext()) { data = db.Data.Where(p => p.MeasuringPoin.Equals("LI_1")).OrderByDescending(p => p.Id).Take(60).ToList(); } counter = 60; foreach (var item in data) { result = DateTime.Compare(Convert.ToDateTime(item.Time).AddSeconds(60), Convert.ToDateTime(actualTime.ToLongTimeString())); if (result < 0) { SeriesCollection[0].Values.Add(0.0); Labels.Add(actualTime.AddSeconds(counter).ToLongTimeString()); } else { SeriesCollection[0].Values.Add(Math.Round(Convert.ToDouble(item.Value), 2)); Labels.Add(item.Time); } counter--; } Labels.Reverse(); _timer1.Enabled = true; }); DataContext = this; }
private void OnTimedEvent(object source, ElapsedEventArgs e) { // Top bar info labels using (var db = new SimpleScadaContext()) { alarmHistory.Clear(); alarmHistory.AddRange((IEnumerable <AlarmHistory>)db.AlarmHistory.ToList()); } Dispatcher.Invoke(new Action(() => { alarmHistoryList.ItemsSource = null; })); Dispatcher.Invoke(new Action(() => { alarmHistoryList.ItemsSource = alarmHistory; })); }
// -- CRUD -- // // Add new user private void addButton_Click(object sender, RoutedEventArgs e) { using (var db = new SimpleScadaContext()) { db.Users.Add(new Users() { User = usernameTxt.Text, Password = passwordTxt.Text, Level = Int32.Parse(levelTxt.Text) }); db.SaveChanges(); showViewList(); }; }
// Delete choosen user private void deleteButton_Click(object sender, RoutedEventArgs e) { var selectedStockObject = userList.SelectedItem as Users; using (var db = new SimpleScadaContext()) { var newUser = db.Users.First(p => p.Id == selectedStockObject.Id); db.Users.Remove(newUser); db.SaveChanges(); showViewList(); }; }
// Edit choosen user private void editButton_Click(object sender, RoutedEventArgs e) { var selectedStockObject = userList.SelectedItem as Users; using (var db = new SimpleScadaContext()) { db.Users.First(p => p.Id == selectedStockObject.Id).User = usernameTxt.Text; db.Users.First(p => p.Id == selectedStockObject.Id).Password = passwordTxt.Text; db.Users.First(p => p.Id == selectedStockObject.Id).Level = Int32.Parse(levelTxt.Text); db.SaveChanges(); showViewList(); }; }
private void showViewList() { items.Clear(); using (var db = new SimpleScadaContext()) { // Write Users from database to viewList on Admin Panel var users = db.Users.OrderBy(p => p.Id); foreach (var user in users) { items.Add(new SimpleScada.Users() { Id = user.Id, User = user.User, Password = user.Password, Level = user.Level }); } } userList.ItemsSource = null; userList.ItemsSource = items; }
// Create a series collection of specific measuring point choosen in check box private void createSeriesCollection(string measuringPoint) { actualTime = DateTime.Now; _timer1.Enabled = false; SeriesCollection.Clear(); Labels.Clear(); actualMeasuringPoint = measuringPoint; SeriesCollection.Add(new LineSeries { Title = measuringPoint, Values = new ChartValues <double> { } }); Task.Run(() => { using (var db = new SimpleScadaContext()) { data = db.Data.Where(p => p.MeasuringPoin.Equals(measuringPoint)).OrderByDescending(p => p.Id).Take(60).ToList(); } counter = 60; YFormatter = null; YFormatter = value => value.ToString("") + MainScreen.variables.Find(p => p.Name.Equals(data.Last().MeasuringPoin)).MeasuringUnit; foreach (var item in data) { result = DateTime.Compare(Convert.ToDateTime(item.Time), actualTime.AddSeconds(60)); if (result > 0) { SeriesCollection[0].Values.Add(0.0); Labels.Add(actualTime.AddSeconds(counter).ToLongTimeString()); } else { SeriesCollection[0].Values.Add(Convert.ToDouble(item.Value)); Labels.Add(item.Time); } counter--; } Labels.Reverse(); _timer1.Enabled = true; }); }