public static void logIntoDb(String activityLine, User user, DateTime dateNow)
{
StudentInfoContext context = new StudentInfoContext();
if (context.TestLogsIfEmpty())
{
context.CopyCurrentLogs();
}
context.Logs.Add(new Log(activityLine, dateNow /*,user*/));
context.SaveChanges();
}
private void btnTestStudents_Click(object sender, RoutedEventArgs e)
{
StudentInfoContext context = new StudentInfoContext();
if (context.TestStudentsIfEmpty())
{
MessageBox.Show("В базата няма студенти, ще бъдат добавени тестовите");
context.CopyTestStudents();
}
else
{
MessageBox.Show("В базата има данни за " + context.getTotalStudentsCount() + " на брой студента");
}
}
public static void SetUserActiveTo(string username, DateTime activeTo)
{
StudentInfoContext context = new StudentInfoContext();
foreach (var user in context.Users)
{
if (user.Username.Equals(username))
{
user.ActiveTo = activeTo;
Logger.LogActivity("Промяна на активност на " + username, user);
break;
}
}
context.SaveChanges();
}
public static void AssignUserRole(string username, UserRoles role)
{
StudentInfoContext context = new StudentInfoContext();
foreach (var user in context.Users)
{
if (user.Username.Equals(username))
{
user.Role = role;
Logger.LogActivity("Промяна на роля на " + user, user);
break;
}
context.SaveChanges();
}
}
public static User IsUserPassCorrect(string username, string password)
{
StudentInfoContext context = new StudentInfoContext();
if (context.TestUsersIfEmpty())
{
MessageBox.Show("В базата няма потребители, ще бъдат добавени тестовите");
context.CopyTestUsers();
}
foreach (var user in context.Users)
{
if (user.Username.Equals(username) && user.Password.Equals(password))
{
return(user);
}
}
return(null);
}
public StudentInfoContext() : base(Properties.Settings.Default.DbConnect)
{
context = this;
}
private static List <User> GetRegions()
{
List <User> users = new StudentInfoContext().context.Users.ToList();
return(users);
}