public List<Category> GetCategories() { List<Category> categories = null; AnanEntities db = new AnanEntities(); try { categories = (from category in db.Category orderby category.ID ascending orderby category.Enabled descending select category).ToList<Category>(); return categories; } catch { } finally { if (db != null) { db.Dispose(); } } return categories; }
/// <summary> /// /// </summary> /// <param name="user"></param> /// <returns></returns> public bool LocalRegisterUser(User user) { bool result = false; AnanEntities db = new AnanEntities(); try { if (string.IsNullOrEmpty(user.Email)) { throw new Exception(""); } if (string.IsNullOrEmpty(user.Password)) { throw new Exception(""); } user.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); user.Password = Encrypt.MD5(user.Password); db.User.Add(user); db.SaveChanges(); } catch { } finally { if (db != null) { db.Dispose(); } } return result; }
/// <summary> /// /// </summary> /// <param name="name"></param> /// <param name="password"></param> /// <returns></returns> public User Login(string name, string password) { User user = null; AnanEntities db = new AnanEntities(); try { string md5Password = Encrypt.MD5(password); user = (from u in db.User where u.Email == name select u).FirstOrDefault<User>(); if (user == null) { throw new Exception("此用户不存在"); } if (user.Password != md5Password) { throw new Exception("密码错误"); } } catch(Exception ex) { throw ex; } finally { if (db != null) { db.Dispose(); } } return user; }
/// <summary> /// /// </summary> /// <param name="userId"></param> /// <returns></returns> public Permission GetUserPermission(int userId) { Permission permission = new Permission(); AnanEntities db = new AnanEntities(); try { Admin_Super ad = (from auser in db.Admin_Super where auser.user_id == userId select auser).FirstOrDefault<Admin_Super>(); if (ad != null) { System.Reflection.FieldInfo[] fields = permission.GetType().GetFields(); if (fields != null) { foreach (System.Reflection.FieldInfo field in fields) { field.SetValue(permission, 1); } } } else { //TBD } } catch { } finally { if (db != null) { db.Dispose(); } } return permission; }