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); }