public static void SetSecurityAccess()
{
var dbHavalehEntities = new dbHavalehEntities();
var result = dbHavalehEntities.tblSecurityAccess.FirstOrDefault(x => x.Id == 1);
if (result == null)
{
var tblSecurityAccess = new tblSecurityAccess
{
Id = 1,
Time = PersianDateTime.Now.AddMinutes(-10).ToString(),
Counter = "0"
};
dbHavalehEntities.tblSecurityAccess.Add(tblSecurityAccess);
dbHavalehEntities.SaveChanges();
}
else if (result.Time == null)
{
var tblSecurityAccess = new tblSecurityAccess
{
Id = 1,
Time = PersianDateTime.Now.AddMinutes(-10).ToString()
};
using (dbHavalehEntities)
{
dbHavalehEntities.tblSecurityAccess.Attach(tblSecurityAccess);
dbHavalehEntities.Entry(tblSecurityAccess).Property(x => x.Time).IsModified = true;
dbHavalehEntities.SaveChanges();
}
}
}
public static Task <List <tblDriver> > Search(string search)
{
var dbHavalehEntities = new dbHavalehEntities();
return(Task.Run(() => dbHavalehEntities.tblDriver.Where(
t => !string.IsNullOrEmpty(t.DriverName) && t.DriverName.Contains(search) ||
!string.IsNullOrEmpty(t.NumberPlates) && t.NumberPlates.Contains(search) ||
!string.IsNullOrEmpty(t.DriverMobile) && t.DriverMobile.Contains(search)).ToList()));
}
public static bool?ChekAdminRegistered()
{
var dbHavalehEntities = new dbHavalehEntities();
var result = dbHavalehEntities.tblSundry.FirstOrDefault(x => x.Id == 1);
if (result == null)
{
return(false);
}
return(result.RegisteredAdminPassword);
}
public static PersianDateTime Date()
{
var dbHavalehEntities = new dbHavalehEntities();
var firstOrDefault = dbHavalehEntities.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 ChangePassword()
{
var tblUser = new tblUser
{
Id = 1,
UserPassword = BCrypt.Net.BCrypt.HashPassword(DPassword)
};
using (var dbHavalehEntities = new dbHavalehEntities())
{
dbHavalehEntities.tblUser.Attach(tblUser);
dbHavalehEntities.Entry(tblUser).Property(x => x.UserPassword).IsModified = true;
dbHavalehEntities.SaveChanges();
}
}
public void StartSecurityTimeAccess()//taeen zaman vorod eshtebah
{
var tblSecurityAccess = new tblSecurityAccess
{
Id = 1,
Time = PersianDateTime.Now.ToString()
};
using (var dbHavalehEntities = new dbHavalehEntities())
{
dbHavalehEntities.tblSecurityAccess.Attach(tblSecurityAccess);
dbHavalehEntities.Entry(tblSecurityAccess).Property(x => x.Time).IsModified = true;
dbHavalehEntities.SaveChanges();
}
}
public static void SaveCounter(int num)//zakhire tedad mavared vorod eshtebah
{
var tblSecurityAccess = new tblSecurityAccess
{
Id = 1,
Counter = num.ToString()
};
using (var dbHavalehEntities = new dbHavalehEntities())
{
dbHavalehEntities.tblSecurityAccess.Attach(tblSecurityAccess);
dbHavalehEntities.Entry(tblSecurityAccess).Property(x => x.Counter).IsModified = true;
dbHavalehEntities.SaveChanges();
}
}
public static int SecurityAccess(ref int counter)//taeen modat zamani ke az 5 bar eshtbah gozashteh ast
{
var dbHavalehEntities = new dbHavalehEntities();
var firstOrDefault = dbHavalehEntities.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 static Task <List <string> > GetQuestion()
{
var dbHavalehEntities = new dbHavalehEntities();
return(Task.Run(() => dbHavalehEntities.tblSecurityQuestion.Select(x => x.SecurityQuestion).ToList()));
}
public static Task <List <tblLicense> > GetData()
{
var dbHavalehEntities = new dbHavalehEntities();
return(Task.Run(() => dbHavalehEntities.tblLicense.Where(x => x.Id == 1).ToList()));
}
public DBuyer()
{
_dbHavalehEntities = new dbHavalehEntities();
}
public DDriver()
{
_dbHavalehEntities = new dbHavalehEntities();
}
public DCapacity()
{
_dbHavalehEntities = new dbHavalehEntities();
}
public DVehicle()
{
_dbHavalehEntities = new dbHavalehEntities();
}
public DUserLogin()
{
_dbHavalehEntities = new dbHavalehEntities();
}
private static List <tblPostType> GetPostdata()
{
var dbHavalehEntities = new dbHavalehEntities();
return(dbHavalehEntities.tblPostType.ToList());
}
public static Task <List <spSelectViewSelectProduct_Result> > GetData(int havalehId)
{
var dbHavalehEntities = new dbHavalehEntities();
return(Task.Run(() => dbHavalehEntities.spSelectViewSelectProduct().Where(x => x.Havaleh_Id == havalehId).ToList()));
}
public DFactory()
{
_dbHavalehEntities = new dbHavalehEntities();
}
public static Task <List <tblVehicleType> > GetData()
{
var dbHavalehEntities = new dbHavalehEntities();
return(Task.Run(() => dbHavalehEntities.tblVehicleType.ToList()));
}
public DHavaleh()
{
_dbHavalehEntities = new dbHavalehEntities();
}
public DProduct()
{
_dbHavalehEntities = new dbHavalehEntities();
}
public static Task <List <spSelectViewHavaleh_Result> > GetHavaleh()
{
var dbHavalehEntities = new dbHavalehEntities();
return(Task.Run(() => dbHavalehEntities.spSelectViewHavaleh().ToList()));
}
public static Task <List <tblProvince> > GetProvince()
{
var dbVisitorEntities = new dbHavalehEntities();
return(Task.Run(() => dbVisitorEntities.tblProvince.ToList()));
}
public static Task <List <tblCounty> > GetCounty()
{
var dbVisitorEntities = new dbHavalehEntities();
return(Task.Run(() => dbVisitorEntities.tblCounty.ToList()));
}
public static Task <List <tblBuyer> > GetData()
{
var dbHavalehEntities = new dbHavalehEntities();
return(Task.Run(() => dbHavalehEntities.tblBuyer.ToList()));
}
public DLicense()
{
_dbHavalehEntities = new dbHavalehEntities();
}
