public static int Clean()
{
using (var db = new HGDContext())
{
List <AppSession> listRemove = new List <AppSession>();
//
foreach (var sess in db.AppSession)
{
Token token = JsonConvert.DeserializeObject <Token>(sess.Value);
if (token != null && token.ExpireTime < DateTime.Now)
{
listRemove.Add(sess);
}
}
if (listRemove.Count > 0)
{
db.AppSession.RemoveRange(listRemove);
return(db.SaveChanges());
}
return(0);
}
}
public static AppSession Get(long id)
{
using (var db = new HGDContext())
{
return(db.AppSession.Find(id));
}
}
public static bool Valid(string loginId, string password)
{
using (var db = new HGDContext())
{
string pwd = (
from u in db.User
where u.Account == loginId
select u.Password
).FirstOrDefault();
if (password == null)
{
return(false);
}
string hasdPwd = MD5Util.getHashStr(password);
if (pwd == null)
{
return(false);
}
return(hasdPwd.ToLower() == pwd.ToLower());
}
}
public static AppInfo Get(long appID)
{
using (var db = new HGDContext())
{
return(db.AppInfo.Find(appID));
}
}
public static List <User> GetAll()
{
//
using (var db = new HGDContext())
{
return(db.User.ToList());
}
}
public static int Add(User user)
{
//
using (var db = new HGDContext())
{
//
db.User.Add(user);
return(db.SaveChanges());
}
}
public static string GetIDByAccount(string loginId)
{
using (var db = new HGDContext())
{
return((
from u in db.User
where u.Account == loginId
select u.IdStr
).FirstOrDefault());
}
}
public static string GetNameByID(string id)
{
using (var db = new HGDContext())
{
return((
from u in db.User
where u.IdStr == id
select u.Name
).FirstOrDefault());
}
}
public static User GetByName(string name)
{
using (var db = new HGDContext())
{
return((
from u in db.User
where u.Name == name
select u
).FirstOrDefault());
}
}
public static User Get(string id)
{
using (var db = new HGDContext())
{
var user = (
from u in db.User
where u.IdStr == id
select u
).FirstOrDefault();
return(user);
}
}
public static int Add(long id, string value)
{
using (var db = new HGDContext())
{
//
AppSession sess = new AppSession();
sess.Id = id;
sess.Value = value;
db.AppSession.Add(sess);
return(db.SaveChanges());
}
}
public static Dictionary <string, User> GetAllDict()
{
//
using (var db = new HGDContext())
{
Dictionary <string, User> dict = new Dictionary <string, User>();
foreach (var u in db.User)
{
dict.Add(u.IdStr, u);
}
return(dict);
}
}
public static bool Valid(long appId, string appSecret)
{
using (var db = new HGDContext())
{
//
AppInfo e = (from ai in db.AppInfo
where ai.Id == appId
select ai)
.FirstOrDefault();
string hashAppSecret = MD5Util.getHashStr(appSecret);
return(e != null && e.Secret.ToLower() == hashAppSecret);
}
}
public static long Add(string appSecret, string name)
{
using (var db = new HGDContext())
{
//
AppInfo e = new AppInfo();
e.Id = LeafSnowflake.getID();
e.Secret = MD5Util.getHashStr(appSecret);
e.Name = name;
db.AppInfo.Add(e);
db.SaveChanges();
return(e.Id);
}
}
public static int Delete(string userId)
{
//
using (var db = new HGDContext())
{
User u = db.User.Find(userId);
if (u == null)
{
return(0);
}
else
{
db.User.Remove(u);
}
return(db.SaveChanges());
}
}
public static int Update(User user)
{
//
using (var db = new HGDContext())
{
User u = db.User.Find(user.Id);
if (u == null)
{
return(0);
}
else
{
u.Name = user.Name;
}
return(db.SaveChanges());
}
}
public static int SaveToken(long id, Token token)
{
using (var db = new HGDContext())
{
//
var sess = db.AppSession.Find(id);
if (sess == null)
{
sess = new AppSession();
sess.Id = id;
db.AppSession.Add(sess);
}
sess.Value = JsonConvert.SerializeObject(token);
return(db.SaveChanges());
}
}
public static Dictionary <long, string> GetIDWithName()
{
using (var db = new HGDContext())
{
//
Dictionary <long, string> dict = new Dictionary <long, string>();
var query = from d in db.AppInfo
select new
{
ID = d.Id,
Name = d.Name
};
foreach (var item in query)
{
dict.Add(item.ID, item.Name);
}
return(dict);
}
}
public static Token LoadToken(long id)
{
using (var db = new HGDContext())
{
//
var sess = db.AppSession.Find(id);
if (sess == null)
{
return(null);
}
Token token = JsonConvert.DeserializeObject <Token>(sess.Value);
if (token.ExpireTime < DateTime.Now)
{
db.AppSession.Remove(sess);
db.SaveChanges();
return(null);
}
return(token);
}
}
