public void ModifyCheck(Check check) { using (ProjectDBContext dbContext = new ProjectDBContext()) { Check c = dbContext.Checks.ToList().Find(x => x.Id == check.Id); if (c == null) { c = new Check() { Datetime = check.Datetime, GateID = check.GateID, Token = check.Token, TokenId = check.TokenId, Type = check.Type, }; dbContext.Add(c); dbContext.SaveChanges(); CommandHandler.Instance.UpdateCheckIDS(c.Id, FindLastCheckID()); } else { c.Datetime = check.Datetime; dbContext.Checks.Attach(c); dbContext.Entry(c).State = Microsoft.EntityFrameworkCore.EntityState.Modified; dbContext.SaveChanges(); CommandHandler.Instance.UpdateCheckIDS(c.Id, FindLastCheckID()); } } }
public void GenerateToken(int userID, int level) { using (ProjectDBContext dbContext = new ProjectDBContext()) { List <Token> tokensInDB = dbContext.Tokens.ToList <Token>(); Token tokenToUpdate = tokensInDB.SingleOrDefault(x => x.UserID == userID); if (tokenToUpdate == null) { Token toAdd = new Token() { UserID = userID, LevelOfAccess = level }; dbContext.Tokens.Add(toAdd); dbContext.SaveChanges(); } else { Token t = dbContext.Tokens.ToList().Find(x => x.UserID == userID); t.LevelOfAccess = level; dbContext.Tokens.Attach(t); dbContext.Entry(t).State = EntityState.Modified; dbContext.SaveChanges(); } } }
public void UpdateUserToDatabase(User user) { using (ProjectDBContext dbContext = new ProjectDBContext()) { dbContext.Entry(user).State = Microsoft.EntityFrameworkCore.EntityState.Modified; dbContext.SaveChanges(); } }
public void ChangeGate(string gateName, int levelOfAccess, Gate selectedGate) { using (ProjectDBContext dbContext = new ProjectDBContext()) { Gate toChange = projectDBContext.Gates.ToList().Find(x => x.GateID == selectedGate.GateID); toChange.Name = gateName; toChange.LevelOfAccess = levelOfAccess; toChange.Checks = selectedGate.Checks; dbContext.Gates.Attach(toChange); var entry = dbContext.Entry(toChange); entry.State = EntityState.Modified; dbContext.SaveChanges(); } }