public static string Login(UserAuthDTO value) { using (var dbContext = new FiszkiContext()) { var user = dbContext.Users.FirstOrDefault(x => x.Login == value.Login); if (user == null) { return(null); } if (user.Password != value.Password) { dbContext.UsersLogs.Add(new Repositories.UserLogs { UserId = user.Id, LoginDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), LoginStatus = "Nieprawidłowe hasło" }); dbContext.SaveChanges(); return(null); } dbContext.UsersLogs.Add(new Repositories.UserLogs { UserId = user.Id, LoginDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), LoginStatus = "Zalogowano" }); dbContext.SaveChanges(); return(JWTService.GenerateToken(user.Id)); } }
public static string Login(CredentialsModel value) { using (var dbContext = new FiszkiContext()) { var user = dbContext.Users.FirstOrDefault(x => x.Login == value.Login); if (user == null) { return(null); } if (user.Password != value.Password) { dbContext.UsersLogs.Add(new Repositories.UserLogs //Dodanie informacji o logowaniu + złe hasło { UserId = user.Id, LoginDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), // Data rejestracji LoginStatus = "Nieprawidłowe hasło" //var x = UserLogsRepository.AddUserLogsList(user.Id, ) }); dbContext.SaveChanges(); return(null); } dbContext.UsersLogs.Add(new Repositories.UserLogs //Dodanie informacji o logowaniu + złe hasło { UserId = user.Id, LoginDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), // Data rejestracji LoginStatus = "Zalogowano" }); dbContext.SaveChanges(); return(JWTService.GenerateToken(user.Id)); } }
public static void DeleteWord(int id) { using (var dbContext = new FiszkiContext()) { var item = dbContext.WordsTable.FirstOrDefault(x => x.Id == id); dbContext.WordsTable.Remove(item); dbContext.SaveChanges(); } }
public static void AddUserLogsList(int id, string LoginEvent) { using (var dbContext = new FiszkiContext()) //standardowa linijka { dbContext.UsersLogs.Add(new Repositories.UserLogs //Dodanie informacji o logowaniu + złe hasło { UserId = id, LoginDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), // Data rejestracji LoginStatus = "Nieprawidłowe hasło" }); dbContext.SaveChanges(); } }
public static void EditWord(int id, Words value) { using (var dbContext = new FiszkiContext()) { var Word = dbContext.WordsTable.FirstOrDefault(x => x.Id == id); Word.Wordpl = value.Wordpl; Word.Worden = value.Worden; Word.WordCategory = value.WordCategory; dbContext.SaveChanges(); } }
public static void AddUserLogsList(int id, string LoginEvent) { using (var dbContext = new FiszkiContext()) { dbContext.UsersLogs.Add(new Repositories.UserLogs { UserId = id, LoginDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), LoginStatus = "Nieprawidłowe hasło" }); dbContext.SaveChanges(); } }
public static int DeleteNote(int id, int Userid) { using (var dbContext = new FiszkiContext()) { var note = dbContext.NotesTable.FirstOrDefault(x => x.id == id && x.userId == Userid); if (note == null) { return(0); } dbContext.NotesTable.Remove(note); dbContext.SaveChanges(); return(id); } }
public static void AddWord(Words value) { using (var dbContext = new FiszkiContext()) { var newWord = new Words { Wordpl = value.Wordpl, Worden = value.Worden, WordCategory = value.WordCategory }; dbContext.WordsTable.Add(newWord); dbContext.SaveChanges(); int id = newWord.Id; } }
public static List <NotesModel> EditNote(int id, NotesModel Note, int Userid) { using (var dbContext = new FiszkiContext()) { var editedNote = dbContext.NotesTable.FirstOrDefault(x => x.id == id && x.userId == Userid); { editedNote.type = Note.type; editedNote.title = Note.title; editedNote.articleUrl = Note.articleUrl; editedNote.noteContent = Note.noteContent; editedNote.dateUser = Note.dateUser; editedNote.lastEdit = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); editedNote.rating = Note.rating; editedNote.isActive = 1; }; dbContext.SaveChanges(); var EditetItem = dbContext.NotesTable.Where(item => item.id == id).ToList(); return(EditetItem); } }
public static (string status, string coment, string token) Register(CredentialsModel value) { using (var dbContext = new FiszkiContext()) { var user = dbContext.Users.FirstOrDefault(x => x.Login == value.Login); if (user != null) { return(null, "Login zajęty", null); } if (value.Login.Length < 4) { return(null, "Login musi mieć minimum 5 znaków", null); } if (value.Password.Length < 4) { return(null, "Hasło musi mieć minimum 5 znaków", null); } if (value.Login == value.Password) { return(null, "Login musi się różnic od hasła", null); } var newAccount = new User { Login = value.Login, Password = value.Password, DateAdd = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") // Data rejestracji }; dbContext.Users.Add(newAccount); dbContext.SaveChanges(); int newAccountId = newAccount.Id; //return ("ok", $"{value.Login} [{newAccountId}], konto zostało dodane, możesz się zalogować"); return("ok", null, JWTService.GenerateToken(newAccountId)); } }
public static (string status, string coment, string token) Register(UserAuthDTO value) { using (var dbContext = new FiszkiContext()) { var user = dbContext.Users.FirstOrDefault(x => x.Login == value.Login); if (user != null) { return(null, "Login zajęty", null); } if (value.Login.Length < 4) { return(null, "Login musi mieć minimum 5 znaków", null); } if (value.Password.Length < 4) { return(null, "Hasło musi mieć minimum 5 znaków", null); } if (value.Login == value.Password) { return(null, "Login musi się różnic od hasła", null); } var newAccount = new User { Login = value.Login, Password = value.Password, DateAdd = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; dbContext.Users.Add(newAccount); dbContext.SaveChanges(); int newAccountId = newAccount.Id; return("ok", null, JWTService.GenerateToken(newAccountId)); } }
public static void AddProgress(Progress progresUpdate, int userId) { using (var dbContext = new FiszkiContext()) { var userProgres = dbContext.ProgressTable.FirstOrDefault(x => x.UserId == userId && x.WordId == progresUpdate.WordId); if (userProgres != null) { userProgres.WordStatus = progresUpdate.WordStatus; } else { var newProgress = new Progress { UserId = userId, WordId = progresUpdate.WordId, WordStatus = progresUpdate.WordStatus, DateEdit = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; dbContext.ProgressTable.Add(newProgress); } dbContext.SaveChanges(); } }
public static List <NotesModel> AddNote(NotesModel NewNote, int Userid) { using (var dbContext = new FiszkiContext()) { var newNote = new NotesModel { userId = Userid, type = NewNote.type, title = NewNote.title, articleUrl = NewNote.articleUrl, noteContent = NewNote.noteContent, dateUser = NewNote.dateUser, created = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), lastEdit = null, rating = NewNote.rating, isActive = 1, }; dbContext.NotesTable.Add(newNote); dbContext.SaveChanges(); int id = newNote.id; return(dbContext.NotesTable.Where(item => item.id == id).ToList()); } }