private void listUpdate() { listView1.Items.Clear(); var gridView = new GridView(); listView1.View = gridView; gridView.Columns.Add(new GridViewColumn { Header = "Id", DisplayMemberBinding = new Binding("Id") }); gridView.Columns.Add(new GridViewColumn { Header = "Login", DisplayMemberBinding = new Binding("Login") }); using (var db = new Context.ContextDB()) { foreach (var user in db.UnregSubjects) { listView1.Items.Add(new Models.UnregisteredSubjects { Id = user.Id, Login = user.Login }); } } }
private void listUpdate() { listView1.Items.Clear(); var gridView = new GridView(); listView1.View = gridView; gridView.Columns.Add(new GridViewColumn { Header = "Id", DisplayMemberBinding = new Binding("Id") }); gridView.Columns.Add(new GridViewColumn { Header = "Логин", DisplayMemberBinding = new Binding("Login") }); gridView.Columns.Add(new GridViewColumn { Header = "Пароль", DisplayMemberBinding = new Binding("Password") }); using (var db = new Context.ContextDB()) { foreach (var user in db.Subjects) { listView1.Items.Add(new Models.Subject { Id = user.Id, Login = user.Login, Password = user.Password, AuthCount = user.AuthCount, LevelId = user.LevelId, RoleId = user.RoleId, BanId = user.BanId }); } } }
private bool CheckDay(Subject subject) { try { using (var db = new Context.ContextDB()) { var role = db.Roles.FirstOrDefault(r => r.Id == subject.RoleId); StringBuilder builder = new StringBuilder(); for (int i = 0; i < role.AllowedDays.Length; ++i) { var curChar = role.AllowedDays.ElementAt(i); if (curChar != ',') { builder.Append(curChar); } else { if (DateTime.Now.DayOfWeek.ToString().Equals(builder.ToString())) { return(true); } builder.Clear(); } } } } catch { } return(false); }
private void button2_Click(object sender, RoutedEventArgs e) { this.Subject.Login = textBox1.Text; this.Subject.Password = textBox2.Text; try { this.Subject.BanId = Convert.ToInt32(textBox3.Text); } catch { } using (var db = new Context.ContextDB()) { var roleId = db.Roles.FirstOrDefault(r => r.Name == comboBox1.SelectedItem.ToString()).Id; var levelId = db.Levels.FirstOrDefault(l => l.Name == comboBox2.SelectedItem.ToString()).Id; this.Subject.RoleId = roleId; this.Subject.LevelId = levelId; } if (Methods.Admin.UpdateSubject(Subject)) { MessageBox.Show("Updating complete"); listUpdate(); } else { MessageBox.Show("Something got wrong!"); } }
private void comboBox2_Loaded(object sender, RoutedEventArgs e) { using (var db = new Context.ContextDB()) { foreach (var role in db.Roles) { comboBox2.Items.Add(role.Name); } } }
private void comboBox1_Loaded(object sender, RoutedEventArgs e) { using (var db = new Context.ContextDB()) { foreach (var level in db.Levels) { comboBox1.Items.Add(level.Name); } } }
//Записываем время в Базу Данных private void FixTime() { try { using (var db = new Context.ContextDB()) { var time = db.Roles.FirstOrDefault(t => t.Id == subject.RoleId); time.AllowedTime = allowedTime; db.SaveChanges(); } } catch { } }
private void listView1_PreviewMouseDoubleClick(object sender, MouseButtonEventArgs e) { foreach (object obj in listView1.SelectedItems) { this.Subject = (obj as Models.Subject); using (var db = new Context.ContextDB()) { var roleName = db.Roles.FirstOrDefault(r => r.Id == Subject.RoleId).Name; var levelName = db.Levels.FirstOrDefault(l => l.Id == Subject.LevelId).Name; comboBox1.SelectedItem = roleName; comboBox2.SelectedItem = levelName; } textBox1.Text = ((obj as Models.Subject).Login); textBox2.Text = ((obj as Models.Subject).Password); textBox3.Text = ((obj as Models.Subject).BanId.ToString()); } }
private bool CheckTime(Subject subject) { try { using (var db = new Context.ContextDB()) { var sTime = db.Levels.FirstOrDefault(t => t.Id == subject.LevelId).StartTime; var eTime = db.Levels.FirstOrDefault(t => t.Id == subject.LevelId).EndTime; if ((DateTime.Now.TimeOfDay >= sTime && DateTime.Now.TimeOfDay <= eTime) || null == sTime || null == eTime) { return(true); } } } catch { } return(false); }
private void listUpdate() { listView1.Items.Clear(); var defaultTime = new TimeSpan(00, 00, 00); var gridView = new GridView(); listView1.View = gridView; gridView.Columns.Add(new GridViewColumn { Header = "Id", DisplayMemberBinding = new Binding("Id") }); gridView.Columns.Add(new GridViewColumn { Header = "Name", DisplayMemberBinding = new Binding("Name") }); gridView.Columns.Add(new GridViewColumn { Header = "CountOfEnter", DisplayMemberBinding = new Binding("CountOfEnter") }); gridView.Columns.Add(new GridViewColumn { Header = "StartTime", DisplayMemberBinding = new Binding("StartTime") }); gridView.Columns.Add(new GridViewColumn { Header = "EndTime", DisplayMemberBinding = new Binding("EndTime") }); using (var db = new Context.ContextDB()) { foreach (var level in db.Levels) { listView1.Items.Add(new Models.Level { Id = level.Id, Name = level.Name, CountOfEnter = level.CountOfEnter.HasValue ? level.CountOfEnter : 0, StartTime = level.StartTime.HasValue ? level.StartTime : defaultTime, EndTime = level.EndTime.HasValue ? level.EndTime : defaultTime }); } } }
private void listUpdate() { listView1.Items.Clear(); var defaultTime = new TimeSpan(00, 00, 00); var gridView = new GridView(); listView1.View = gridView; gridView.Columns.Add(new GridViewColumn { Header = "Id", DisplayMemberBinding = new Binding("Id") }); gridView.Columns.Add(new GridViewColumn { Header = "Имя", DisplayMemberBinding = new Binding("Name") }); gridView.Columns.Add(new GridViewColumn { Header = "Длительность", DisplayMemberBinding = new Binding("AllowedTime") }); gridView.Columns.Add(new GridViewColumn { Header = "Приоритетность", DisplayMemberBinding = new Binding("Priority") }); using (var db = new Context.ContextDB()) { foreach (var role in db.Roles) { listView1.Items.Add(new Models.Role { Id = role.Id, Name = role.Name, AllowedTime = role.AllowedTime.HasValue ? role.AllowedTime : defaultTime, AllowedDays = role.AllowedDays, Priority = role.Priority }); } } }
public MainProgram(Models.Subject subject) { InitializeComponent(); this.subject = subject; label1.Content = subject.Login; //Считывание дозволенного времени (из таблицы Role -> AllowedTime)... Подумай, зачем я поставил try catch try { using (var db = new Context.ContextDB()) { var time = db.Roles.FirstOrDefault(t => t.Id == subject.RoleId).AllowedTime; allowedTime = (TimeSpan)time; } } catch { } TimeIsUp(allowedTime); label2.Content = allowedTime.ToString(); timer.Tick += new EventHandler(TimeLeft); //На каждый тик будет проходить событие TimeLeft timer.Interval = new TimeSpan(0, 0, 1); //Установка интервала таймера (таймер с интервалом в 1 секунду) timer.Start(); //Ну... Думаю подобное и так понятно... }