public static void SetSecurityAccess() { var dbVisitorEntities = new dbVisitorEntities(); var result = dbVisitorEntities.tblSecurityAccess.FirstOrDefault(x => x.Id == 1); if (result == null) { var tblSecurityAccess = new tblSecurityAccess { Id = 1, Time = PersianDateTime.Now.AddMinutes(-10).ToString(), Counter = "0" }; dbVisitorEntities.tblSecurityAccess.Add(tblSecurityAccess); dbVisitorEntities.SaveChanges(); } else if (result.Time == null) { var tblSecurityAccess = new tblSecurityAccess { Id = 1, Time = PersianDateTime.Now.AddMinutes(-10).ToString() }; using (dbVisitorEntities) { dbVisitorEntities.tblSecurityAccess.Attach(tblSecurityAccess); dbVisitorEntities.Entry(tblSecurityAccess).Property(x => x.Time).IsModified = true; dbVisitorEntities.SaveChanges(); } } }
public void ChangePassword() { var tblUser = new tblUser { Id = 1, UserName = DUserName, UserPassword = BCrypt.Net.BCrypt.HashPassword(DPassword) }; using (var dbVisitorEntities = new dbVisitorEntities()) { dbVisitorEntities.tblUser.Attach(tblUser); dbVisitorEntities.Entry(tblUser).Property(x => x.UserName).IsModified = true; dbVisitorEntities.Entry(tblUser).Property(x => x.UserPassword).IsModified = true; dbVisitorEntities.SaveChanges(); } }
public void StartSecurityTimeAccess()//taeen zaman vorod eshtebah { var tblSecurityAccess = new tblSecurityAccess { Id = 1, Time = PersianDateTime.Now.ToString() }; using (var dbVisitorEntities = new dbVisitorEntities()) { dbVisitorEntities.tblSecurityAccess.Attach(tblSecurityAccess); dbVisitorEntities.Entry(tblSecurityAccess).Property(x => x.Time).IsModified = true; dbVisitorEntities.SaveChanges(); } }
public static void SaveCounter(int num)//zakhire tedad mavared vorod eshtebah { var tblSecurityAccess = new tblSecurityAccess { Id = 1, Counter = num.ToString() }; using (var dbVisitorEntities = new dbVisitorEntities()) { dbVisitorEntities.tblSecurityAccess.Attach(tblSecurityAccess); dbVisitorEntities.Entry(tblSecurityAccess).Property(x => x.Counter).IsModified = true; dbVisitorEntities.SaveChanges(); } }