public void CheckCredentials(string login, string password)
{
using (var db = new InsideDBEntities())
{
var user = db.Users.FirstOrDefault(u => u.Login == login);
if (user == null || !PassHashing.CheckPasssword(user.Password, password))
{
Clients.Caller.ServerReply("notFound");
}
else if (user.LicenseExpDate < DateTime.Today)
{
Clients.Caller.ServerReply("licenseExpired");
}
else if (user.Status == "online")
{
Clients.Caller.ServerReply("online");
}
else if (user.LicenseExpDate > DateTime.Today || (user.Role == "demo" && user.LicenseExpDate == null))
{
if (user.Role == "demo" && user.LicenseExpDate == null)
{
user.LicenseExpDate = DateTime.Today.AddDays(7);
}
Clients.Caller.ServerReply(user);
user.ConnectionID = Context.ConnectionId;
user.Status = "online";
db.SaveChanges();
if (user.Role == "admin")
{
Admins.Add(Context.ConnectionId);
}
GetUsers();
}
}
}
private static void CreateAdmin()
{
using (var db = new InsideDBEntities())
{
db.Users.Add(new User
{
Login = "******",
Password = PassHashing.GetPasswordHashWithSalt("admin"),
Role = "admin",
LicenseExpDate = DateTime.Parse("01.01.2050"),
});
db.SaveChanges();
}
}
public void EditUser(string login, string password, string role, string license, string email)
{
using (var db = new InsideDBEntities())
{
var user = db.Users.Find(login);
//keep old pass if parameter is empty
if (password != "")
{
user.Password = PassHashing.GetPasswordHashWithSalt(password);
}
user.Role = role;
user.Email = email;
user.LicenseExpDate = DateTime.Parse(license);
db.SaveChanges();
}
GetUsers();
}
public void AddUser(string login, string password, string role, string license, string email)
{
using (var db = new InsideDBEntities())
{
var user = new User
{
Login = login,
Password = PassHashing.GetPasswordHashWithSalt(password),
Role = role,
Email = email
};
if (role != "demo")
{
user.LicenseExpDate = DateTime.Parse(license);
}
db.Users.Add(user);
db.SaveChanges();
}
GetUsers();
}
