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