public static void SetSecurityAccess()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
var result = dbMunicipalArchiveEntities.tblSecurityAccess.FirstOrDefault(x => x.Id == 1);
if (result == null)
{
var tblSecurityAccess = new tblSecurityAccess
{
Id = 1,
Time = PersianDateTime.Now.AddMinutes(-10).ToString(),
Counter = "0"
};
dbMunicipalArchiveEntities.tblSecurityAccess.Add(tblSecurityAccess);
dbMunicipalArchiveEntities.SaveChanges();
}
else if (result.Time == null)
{
var tblSecurityAccess = new tblSecurityAccess
{
Id = 1,
Time = PersianDateTime.Now.AddMinutes(-10).ToString()
};
using (dbMunicipalArchiveEntities)
{
dbMunicipalArchiveEntities.tblSecurityAccess.Attach(tblSecurityAccess);
dbMunicipalArchiveEntities.Entry(tblSecurityAccess).Property(x => x.Time).IsModified = true;
dbMunicipalArchiveEntities.SaveChanges();
}
}
}
public static bool?ChekAdminRegistered()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
var result = dbMunicipalArchiveEntities.tblSundry.FirstOrDefault(x => x.Id == 1);
if (result == null)
{
return(false);
}
return(result.RegisteredAdminPassword);
}
public static PersianDateTime Date()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
var firstOrDefault = dbMunicipalArchiveEntities.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 static void SaveCounter(int num)//zakhire tedad mavared vorod eshtebah
{
var tblSecurityAccess = new tblSecurityAccess
{
Id = 1,
Counter = num.ToString()
};
using (var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities())
{
dbMunicipalArchiveEntities.tblSecurityAccess.Attach(tblSecurityAccess);
dbMunicipalArchiveEntities.Entry(tblSecurityAccess).Property(x => x.Counter).IsModified = true;
dbMunicipalArchiveEntities.SaveChanges();
}
}
public void StartSecurityTimeAccess()//taeen zaman vorod eshtebah
{
var tblSecurityAccess = new tblSecurityAccess
{
Id = 1,
Time = PersianDateTime.Now.ToString()
};
using (var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities())
{
dbMunicipalArchiveEntities.tblSecurityAccess.Attach(tblSecurityAccess);
dbMunicipalArchiveEntities.Entry(tblSecurityAccess).Property(x => x.Time).IsModified = true;
dbMunicipalArchiveEntities.SaveChanges();
}
}
public void ChangePassword()
{
var tblUser = new tblUser
{
Id = 1,
UserName = DUserName,
UserPassword = BCrypt.Net.BCrypt.HashPassword(DPassword)
};
using (var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities())
{
dbMunicipalArchiveEntities.tblUser.Attach(tblUser);
dbMunicipalArchiveEntities.Entry(tblUser).Property(x => x.UserName).IsModified = true;
dbMunicipalArchiveEntities.Entry(tblUser).Property(x => x.UserPassword).IsModified = true;
dbMunicipalArchiveEntities.SaveChanges();
}
}
public static int SecurityAccess(ref int counter)//taeen modat zamani ke az 5 bar eshtbah gozashteh ast
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
var firstOrDefault = dbMunicipalArchiveEntities.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);
}
public DLicense()
{
_dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
}
public static Task <List <tblUser> > GetData()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
return(Task.Run(() => dbMunicipalArchiveEntities.tblUser.ToList()));
}
private static List <tblPostType> GetPostdata()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
return(dbMunicipalArchiveEntities.tblPostType.ToList());
}
public DUser()
{
_dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
}
public static Task <List <string> > GetQuestion()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
return(Task.Run(() => dbMunicipalArchiveEntities.tblSecurityQuestion.Select(x => x.SecurityQuestion).ToList()));
}
public DViolation()
{
_dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
}
public DFileType()
{
_dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
}
public static Task <List <tblPlaque> > GetData()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
return(Task.Run(() => dbMunicipalArchiveEntities.tblPlaque.AsNoTracking().ToList()));
}
public static Task <List <tblPerson> > CheckNationalCode(string nationalCode)
{
var dbLoanEntities = new dbMunicipalArchiveEntities();
return(Task.Run(() => dbLoanEntities.tblPerson.AsNoTracking().Where(x => x.Code == nationalCode).ToList()));
}
public DVersion()
{
_dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
}
public static Task <bool> CanDelete(int plaqueId)
{
var dbLoanEntities = new dbMunicipalArchiveEntities();
return(Task.Run(() => dbLoanEntities.tblFilePlaque.AsNoTracking().Any(x => x.Plaque_Id == plaqueId)));
}
public static List <tblLicense> GetData()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
return(dbMunicipalArchiveEntities.tblLicense.ToList());
}
public DPlaque()
{
_dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
}
public DFilePerson()
{
_dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
}
public static Task <List <viewFilePlaque> > GetCreate()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
return(Task.Run(() => dbMunicipalArchiveEntities.viewFilePlaque.AsNoTracking().ToList()));
}
public static Task <List <viewAll> > GetAllData()
{
var dbMunicipalArchiveEntities = new dbMunicipalArchiveEntities();
return(Task.Run(() => dbMunicipalArchiveEntities.viewAll.AsNoTracking().ToList()));
}
