public void DeleteDocument(int documentId)
{
var doc = db.RequisitionDocuments.FirstOrDefault(x => x.Id == documentId);
if (doc == null)
{
return;
}
//don't actually delete, but mark as deleted
doc.MarkedDeleted = true;
doc.MarkedDeletedDate = DateTime.Now;
db.SaveChanges();
}
public User CreateUser(string firstName, string lastName, string email, string password, bool isAdmin = false)
{
using (var db = new loisEntities1())
{
try
{
var salt = GenerateSalt();
var pHash = HashPassword(password, salt);
var user = new User()
{
firstname = firstName,
lastname = lastName,
email = email,
passwordhash = pHash,
salt = salt,
admin = isAdmin,
enabled = true
};
var mapping = mapper.Map <Authentication>(user);
if (db.Authentications.Any(x => x.Email == user.email))
{
return(user);
}
db.Authentications.Add(mapping);
if (isAdmin)
{
var adminGroup = db.AuthenticationGroups.FirstOrDefault(x => x.GroupName == "Admin");
db.AuthGroupUsers.Add(new AuthGroupUser()
{
Authentication = mapping,
AuthenticationGroup = adminGroup
});
}
else
{
var userGroup = db.AuthenticationGroups.FirstOrDefault(x => x.GroupName == "User");
db.AuthGroupUsers.Add(new AuthGroupUser()
{
Authentication = mapping,
AuthenticationGroup = userGroup
});
}
db.SaveChanges();
return(user);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
}
public bool SaveRequisition(Requisition requisition)
{
using (var db = new loisEntities1())
{
var mapping = mapper.Map <DAL.Lois.Requisition>(requisition);
db.Requisitions.AddOrUpdate(mapping);
db.SaveChanges();
return(true);
}
}
public bool SavePatient(Patient pat)
{
using (var db = new loisEntities1())
{
var p = mapper.Map <DAL.Lois.Patient>(pat);
db.Patients.AddOrUpdate(p);
db.SaveChanges();
return(true);
}
}
public bool DeleteByUserId(int userId)
{
using (var db = new loisEntities1())
{
var tokens = db.Tokens.Where(x => x.UserId == userId);
db.Tokens.RemoveRange(tokens);
db.SaveChanges();
}
return(true);
}
public void InsertRequistion()
{
var req = LOIS.BLL.Factories.RequisitionFactory.CreateRequisition(1, new FakeProlisService());
var repo = new RequisitionService();
repo.SaveRequisition(req);
using (var b = new loisEntities1())
{
var r = b.Requisitions.First(x => x.RequisitionNo == 1);
b.Requisitions.Remove(r);
b.SaveChanges();
}
}
public bool Kill(string tokenId)
{
using (var db = new loisEntities1())
{
var token = db.Tokens.FirstOrDefault(x => x.AuthToken == tokenId);
if (token != null)
{
db.Tokens.Remove(token);
db.SaveChanges();
}
}
return(true);
}
public bool ChangePassword(string email, string newPassword, string oldPassword)
{
var user = Authenticate(email, oldPassword);
if (user == null)
{
return(false);
}
var newHash = HashPassword(newPassword, user.salt);
using (var db = new loisEntities1())
{
var dbUser = db.Authentications.First(x => x.Email == user.email);
dbUser.PasswordHash = newHash;
db.SaveChanges();
}
return(true);
}
public Token GenerateToken(int userId)
{
string token = Guid.NewGuid().ToString();
DateTime issuedOn = DateTime.Now;
double expireTime;
try
{
expireTime =
Convert.ToDouble(ConfigurationManager.AppSettings["AuthTokenExpiry"]);
}
catch (Exception)
{
//8 hrs
expireTime = 1000 * 60 * 60 * 8;
}
if (expireTime == 0)
{
expireTime = 1000 * 60 * 60 * 8;
}
DateTime expiredOn = DateTime.Now.AddMilliseconds(expireTime);
var t = new Token()
{
userid = userId,
authtoken = token,
issuedon = issuedOn,
expireson = expiredOn
};
//Insert to db
using (var db = new loisEntities1())
{
var t1 = db.Tokens.FirstOrDefault(x => x.UserId == userId);
if (t1 != null)
{
t1.ExpiresOn = t.expireson;
db.SaveChanges();
t.authtoken = t1.AuthToken;
t.issuedon = t1.IssuedOn;
t.tokenid = t1.TokenId;
}
else
{
var dbToken = new DAL.Lois.Token()
{
UserId = t.userid,
ExpiresOn = t.expireson,
IssuedOn = t.issuedon,
AuthToken = t.authtoken
};
db.Tokens.Add(dbToken);
db.SaveChanges();
}
}
return(t);
}
