private void LoadPicture() { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { try { Users user = this.authService.User; var list = db.Gallery.ToList(); List <Gallery> photosList = new List <Gallery>(); for (int i = 0; i < list.Count(); i++) { if (list[i].Id == user.id) { photosList.Add(list[i]); } } CollectionOfPhotos = new ObservableCollection <Gallery>(photosList); OnPropertyChanged("CollectionOfPhotos"); } catch (Exception e) { MessageBox.Show(e.Message); } } }
private void LoadTasks() { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { try { Users user = this.authService.User; var tasks = db.TaskManager.ToList(); List <TaskManager> taskList = new List <TaskManager>(); for (int i = 0; i < tasks.Count(); i++) { if (tasks[i].Id == user.id) { taskList.Add(tasks[i]); } } CollectionOfTaskManager = new ObservableCollection <TaskManager>(taskList); OnPropertyChanged("CollectionOfTaskManager"); } catch (Exception e) { MessageBox.Show(e.Message); } } }
private async Task <TaskManager> ChangedIntoDB(string title, string description, string category, int priority, DateTime date) { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { TaskManager taskManager = db.TaskManager.FirstOrDefault(item => item.IdTaskManager == SelectedTask.IdTaskManager); if (taskManager.Title != title) { taskManager.Title = title; } if (taskManager.Description != description) { taskManager.Description = description; } if (taskManager.Category != category) { taskManager.Category = category; } if (taskManager.Priority != priority) { taskManager.Priority = priority; } if (taskManager.Date != date) { taskManager.Date = date; } await db.SaveChangesAsync(); return(taskManager); } }
private void LoadPassword() { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { try { Users user = this.authService.User; var list = db.ManagerPass.ToList(); List <ManagerPass> passwordsList = new List <ManagerPass>(); for (int i = 0; i < list.Count(); i++) { if (list[i].Id == user.id) { passwordsList.Add(list[i]); } } CollectionOfPassword = new ObservableCollection <ManagerPass>(passwordsList); OnPropertyChanged("CollectionOfPassword"); } catch (Exception e) { MessageBox.Show(e.Message); } } }
private async Task <ManagerPass> ChangedIntoDB(int id, string network, string login, string password) { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { ManagerPass managerPass = db.ManagerPass.FirstOrDefault(item => item.IdManagerPass == id); if (managerPass.SocialNetwork != network) { managerPass.SocialNetwork = network; } if (managerPass.Login != login) { managerPass.Login = login; } if (managerPass.Password != password) { managerPass.Password = password; } await db.SaveChangesAsync(); return(managerPass); } }
private async Task <Gallery> DeleteIntoDB(int id) { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { Gallery photo = (Gallery)db.Gallery.FirstOrDefault(Id => Id.IdImage == id); db.Gallery.Remove(photo); await db.SaveChangesAsync(); return(photo); } }
private async Task <TaskManager> DeleteIntoDB(int id) { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { TaskManager tasks = db.TaskManager.FirstOrDefault(item => item.IdTaskManager == id); db.TaskManager.Remove(tasks); await db.SaveChangesAsync(); return(tasks); } }
private async Task <ManagerPass> DeleteIntoDB(int id) { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { ManagerPass managerPass = db.ManagerPass.FirstOrDefault(item => item.IdManagerPass == id); db.ManagerPass.Remove(managerPass); await db.SaveChangesAsync(); return(managerPass); } }
public async Task <Users> AddUserInDB(string UserName, string Password) { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { Users user = new Users() { NameUser = UserName, Password = Password }; User = db.Users.Add(user); await db.SaveChangesAsync(); return(User); } }
private void LoadUser() { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { try { var userList = db.Users.ToList(); CollectionOfUser = new ObservableCollection <Users>(userList); OnPropertyChanged("CollectionOfUser"); } catch (Exception e) { MessageBox.Show(e.Message); } } }
private async Task <Gallery> SaveIntoDB(string filename, Image img) { Users user = this.authService.User; using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { Gallery photo = new Gallery() { FileName = filename, Data = ConvertImageToBinary(img), Id = user.id }; db.Gallery.Add(photo); await db.SaveChangesAsync(); return(photo); } }
public async Task <Users> SettingChangedName(int id, string name) { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { Users activeUser = db.Users.FirstOrDefault(user => user.id == id); if (activeUser != null) { activeUser.NameUser = name; User = activeUser; await db.SaveChangesAsync(); return(User); } else { return(null); } } }
private async Task <ManagerPass> SaveIntoDB(string network, string login, string password) { Users user = this.authService.User; using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { ManagerPass pass = new ManagerPass() { SocialNetwork = network, Login = login, Password = password, Id = user.id }; db.ManagerPass.Add(pass); await db.SaveChangesAsync(); LoadPassword(); return(pass); } }
public async Task <Users> SettingChangedPassword(int id, string oldpassword, string password) { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { Users activeUser = db.Users.FirstOrDefault(user => user.id == id); string passwordHash = activeUser.Password; if (BCrypt.Net.BCrypt.Verify(oldpassword, passwordHash)) { password = BCrypt.Net.BCrypt.HashPassword(password); activeUser.Password = password; User = activeUser; await db.SaveChangesAsync(); return(User); } else { return(null); } } }
private async Task <TaskManager> SaveIntoDB(string title, string description, string category, int priority, DateTime date) { int userID = this.authService.User.id; using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { TaskManager task = new TaskManager() { Id = userID, IsDone = false, Title = title, Description = description, Category = category, Priority = priority, Date = date }; db.TaskManager.Add(task); await db.SaveChangesAsync(); return(task); } }
public bool ActiveUser(string UserName, string Password) { using (Organaizer_v2Entities db = new Organaizer_v2Entities()) { //User activeUser = db.Users.FirstOrDefault(user => user.NameUser == UserName); IQueryable <Users> CollectionActiveUser = from item in db.Users where item.NameUser == UserName select item; if (CollectionActiveUser == null) { return(false); } foreach (var activeUser in CollectionActiveUser) { string passwordHash = activeUser.Password; if (BCrypt.Net.BCrypt.Verify(Password, passwordHash)) { User = activeUser; return(true); } } return(false); } }