public static List <Translit> GetTranslitsByUserGuid(Guid userGuid) { using (var context = new TransliterationDBContext()) { return(context.Translits.Where(x => x.UserGuid == userGuid).ToList()); } }
public static bool UserExists(string login) { using (var context = new TransliterationDBContext()) { return(context.Users.Any(u => u.Login == login)); } }
public static User GetUserByLogin(string login) { using (var context = new TransliterationDBContext()) { return(context.Users.FirstOrDefault(u => u.Login == login)); } }
public static void AddUser(User user) { using (var context = new TransliterationDBContext()) { context.Users.Add(user); context.SaveChanges(); } }
public static void AddTranslit(Translit translit) { using (var context = new TransliterationDBContext()) { translit.DeleteDatabaseValues(); context.Translits.Add(translit); context.SaveChanges(); } }