public bool SearchUser(string userLogin, string userPassword)
{
bool checkRangeUser = false;
userPassword = new CryptAndDecryptPassword().CalculateMD5Hash(userPassword).ToString();
try
{
using (managerdbContext context = new managerdbContext())
{
var userInfo = context.UsersInfo.FirstOrDefault(userinf => userinf.ID == (context.Users.FirstOrDefault(user => user.Email == userLogin && user.Password == userPassword) as Users).ID);
if (userInfo != null)
{
checkRangeUser = true;
userListInformantion = new Person()
{
ID = (context.Users.FirstOrDefault(user => user.Email == userLogin && user.Password == userPassword) as Users).ID,
Login = (context.Users.FirstOrDefault(user => user.Email == userLogin && user.Password == userPassword) as Users).Email,
Name = userInfo.UserName,
Status = userInfo.UserStatus,
Department = userInfo.UserDepartment,
Group = userInfo.UserGroup
};
}
}
return(checkRangeUser);
}
catch
{
return(false);
}
}
public async Task <bool> RegistrationUser(IFCore.User user, IFCore.UserInfo userInfo)
{
try
{
using (managerdbContext context = new managerdbContext())
{
context.Users.Add(new Users()
{
Email = user.Email,
Password = user.Password
});
context.UsersInfo.Add(new UsersInfo()
{
UserName = userInfo.UserName,
UserStatus = userInfo.UserStatus,
UserDepartment = userInfo.UserDepartment,
UserGroup = userInfo.UserGroup
});
await context.SaveChangesAsync();
return(true);
}
}
catch
{
return(false);
}
}
public bool GetPasswordUser(string userLogin, string password)
{
using (managerdbContext context = new managerdbContext())
{
var user = context.Users.Where(login => login.Email == userLogin).ToList()[0];
return(user.Password == new CryptAndDecryptPassword().CalculateMD5Hash(password).ToString() ? true : false);
}
}
public bool GetCOOKIESUser(string login)
{
using (managerdbContext context = new managerdbContext())
{
var checkUserInDB = context.Users.Where(userLogin => userLogin.Email == login).ToList();
return(checkUserInDB.Count != 0 ? true : false);
}
}
public void ChangePasswordUser(string userLogin, string userNewPassword)
{
using (var context = new managerdbContext())
{
context.Users.FirstOrDefault(user => user.Email == userLogin).Password = new CryptAndDecryptPassword().CalculateMD5Hash(userNewPassword).ToString();
context.SaveChanges();
}
}
public bool GetAllNotesUser(int idUser)
{
try
{
using (managerdbContext context = new managerdbContext())
{
listNote = context.UsersNotes.Where(note => note.IDUser == idUser).ToList();
return(true);
}
}
catch
{
return(false);
}
}
public bool ChangeNoteUser(int idNote, string changeText)
{
try
{
using (managerdbContext context = new managerdbContext())
{
((context.UsersNotes.SingleOrDefault(note => note.IDNotes == idNote)) as UsersNotes).NoteText = changeText;
context.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public async void DeleteOldNotes(DateTime firstDayOfWeek)
{
using (managerdbContext context = new managerdbContext())
{
try
{
await context.UsersNotes.ForEachAsync(note =>
{
if (note.DateNote < firstDayOfWeek)
{
context.UsersNotes.Remove(note);
}
});
context.SaveChanges();
}
catch
{
}
}
}
public bool CheckExclusiveUser(string userLogin)
{
bool checkRangeUser = true;
try
{
using (managerdbContext context = new managerdbContext())
{
foreach (var user in context.Users)
{
if (user.Email == userLogin)
{
checkRangeUser = false;
}
}
return(checkRangeUser);
}
}
catch
{
return(false);
}
}
public bool AddNewNoteUser(int userid, string textNote, DateTime dateDayNote, string para, int paraNumber)
{
try
{
using (managerdbContext context = new managerdbContext())
{
context.UsersNotes.Add(new UsersNotes()
{
IDUser = userid,
DateNote = dateDayNote,
Para = para,
ParaNumber = paraNumber,
NoteText = textNote
});
context.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public Person CollectionInformationUser(string userLogin)
{
try
{
using (managerdbContext context = new managerdbContext())
{
var userInfo = context.UsersInfo.FirstOrDefault(userinf => userinf.ID == (context.Users.FirstOrDefault(user => user.Email == userLogin) as Users).ID);
userListInformantion = new Person()
{
ID = (context.Users.FirstOrDefault(user => user.Email == userLogin) as Users).ID,
Login = (context.Users.FirstOrDefault(user => user.Email == userLogin) as Users).Email,
Name = userInfo.UserName,
Status = userInfo.UserStatus,
Department = userInfo.UserDepartment,
Group = userInfo.UserGroup
};
}
}
catch
{
}
return(userListInformantion);
}
