static void CountUpState()
{
try
{
using (RealState_DBEntities db = new RealState_DBEntities())
{
DateTime dt = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
var state = db.StateSites.FirstOrDefault(f => f.StateSiteDate == dt);
if (state != null)
{
state.StateSiteCount += 1;
}
else
{
db.StateSites.Add(new StateSite()
{
StateSiteDate = dt,
StateSiteCount = 1
});
}
db.SaveChanges();
}
}
catch (Exception)
{
}
}
public override string[] GetRolesForUser(string username)
{
using (RealState_DBEntities _db = new RealState_DBEntities())
{
return(_db.Users.Where(a => a.UserName == username).Select(a => a.Role.RoleName).ToArray());
}
}
public static ShowStateViewModel ShowState()
{
try
{
using (RealState_DBEntities db = new RealState_DBEntities())
{
DateTime dt = ReturnPastTime.SetTime(DateTime.Now);
DateTime dt2 = dt.AddDays(-1);
return(new ShowStateViewModel()
{
OnlineUser = (int)HttpContext.Current.Application["OnlineUser"],
SeeSum = db.StateSites.Sum(s => s.StateSiteCount),
SeeToday = db.StateSites.First(s => s.StateSiteDate == dt).StateSiteCount,
SeeYesterday = db.StateSites.Where(s => s.StateSiteDate == dt2).Select(s => s.StateSiteCount).FirstOrDefault()
});
}
}
catch (Exception)
{
throw;
}
}
