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