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(); //Ну... Думаю подобное и так понятно...
}
