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