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