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