public static Task <bool> CheckPersonnelId(string doctorId) { var dbVisitorEntities = new dbVisitorEntities(); var result = dbVisitorEntities.tblDoctor.SingleOrDefault(x => x.Doctor_Id == doctorId); return(result == null?Task.Run(() => true) : Task.Run(() => false)); }
public static Task <string> GetPatientId() { var dbVisitorEntities = new dbVisitorEntities(); var s = dbVisitorEntities.spAutoPatientId().FirstOrDefault(); return(Task.Run(() => dbVisitorEntities.spAutoPatientId().FirstOrDefault().ToString())); }
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 static Task <bool> CheckPatientId(string patientId) { var dbVisitorEntities = new dbVisitorEntities(); var result = dbVisitorEntities.tblPatient.SingleOrDefault(x => x.Patient_Id == patientId); return(result == null?Task.Run(() => true) : Task.Run(() => false)); }
public static bool?ChekAdminRegistered() { var dbVisitorEntities = new dbVisitorEntities(); var result = dbVisitorEntities.tblSundry.FirstOrDefault(x => x.Id == 1); if (result == null) { return(false); } return(result.RegisteredAdminPassword); }
public static PersianDateTime Date() { var dbVisitorEntities = new dbVisitorEntities(); var firstOrDefault = dbVisitorEntities.tblSecurityAccess.FirstOrDefault(); //khandan etela-at file if (firstOrDefault == null) { return(PersianDateTime.Now); } var saveDate = firstOrDefault.Time.Split(' '); return(PersianDateTime.Parse(saveDate[0], saveDate[1]).AddMinutes(+5)); }
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(); } }
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 static int SecurityAccess(ref int counter)//taeen modat zamani ke az 5 bar eshtbah gozashteh ast { var dbVisitorEntities = new dbVisitorEntities(); var firstOrDefault = dbVisitorEntities.tblSecurityAccess.FirstOrDefault(); //khandan etela-at file if (firstOrDefault == null) { return(5); } counter = int.Parse(firstOrDefault.Counter);//zakhireh tedad vorod eshtebah var saveDate = firstOrDefault.Time.Split(' '); var result = PersianDateTime.Now - PersianDateTime.Parse(saveDate[0], saveDate[1]); var checkTimeMinutes = result.Minutes; var checkTimeHours = result.Hours; var checkTimeDays = result.Days; if (checkTimeHours == 0 && checkTimeDays == 0) { return(checkTimeMinutes); } return(5); }
private static List <tblPostType> GetPostdata() { var dbVisitorEntities = new dbVisitorEntities(); return(dbVisitorEntities.tblPostType.ToList()); }
public DUser() { _dbVisitorEntities = new dbVisitorEntities(); }
public static Task <List <tblPatient> > GetData() { var dbLoanEntities = new dbVisitorEntities(); return(Task.Run(() => dbLoanEntities.tblPatient.ToList())); }
public DVisitDoctor() { _dbVisitorEntities = new dbVisitorEntities(); }
public static Task <List <tblProvince> > GetProvince() { var dbVisitorEntities = new dbVisitorEntities(); return(Task.Run(() => dbVisitorEntities.tblProvince.ToList())); }
public DLicense() { _dbVisitorEntities = new dbVisitorEntities(); }
public static Task <List <tblLicense> > GetData() { var dbVisitorEntities = new dbVisitorEntities(); return(Task.Run(() => dbVisitorEntities.tblLicense.Where(x => x.Id == 1).ToList())); }
public DSpecialty() { _dbVisitorEntities = new dbVisitorEntities(); }
public static Task <List <spSelectViewDoctor_Result> > GetViewData() { var dbVisitorEntities = new dbVisitorEntities(); return(Task.Run(() => dbVisitorEntities.spSelectViewDoctor().ToList())); }
public static Task <List <tblSpecialty> > GetData() { var dbHavalehEntities = new dbVisitorEntities(); return(Task.Run(() => dbHavalehEntities.tblSpecialty.ToList())); }
public static Task <List <tblCounty> > GetCounty() { var dbVisitorEntities = new dbVisitorEntities(); return(Task.Run(() => dbVisitorEntities.tblCounty.ToList())); }
public DDoctorPatient() { _dbVisitorEntities = new dbVisitorEntities(); }
public static Task <List <tblVisitDoctor> > GetVisitDoctorData(int doctorId) { var dbVisitorEntities = new dbVisitorEntities(); return(Task.Run(() => dbVisitorEntities.tblVisitDoctor.Where(t => t.Doctor_Id == doctorId).ToList())); }
public static Task <List <string> > GetQuestion() { var dbVisitorEntities = new dbVisitorEntities(); return(Task.Run(() => dbVisitorEntities.tblSecurityQuestion.Select(x => x.SecurityQuestion).ToList())); }