public bool ChangePassword(string userName, string password, string newPassword)
{
if (String.IsNullOrEmpty(userName)) throw new ArgumentException("Value cannot be null or empty.", "userName");
if (String.IsNullOrEmpty(password)) throw new ArgumentException("Value cannot be null or empty.", "password");
if (String.IsNullOrEmpty(newPassword)) throw new ArgumentException("Value cannot be null or empty.", "newPassword");
using (AuthorizeEntities context = new AuthorizeEntities())
{
try
{
var user = context.User.FirstOrDefault(i => i.UserName == userName);
if (user != null && ValidateUser(userName, password))
{
user.UserName = userName ?? user.UserName;
user.Pwd = newPassword != null ? EncryptPassword(newPassword) : user.Pwd;
context.SaveChanges();
}
else
{
return false;
}
}
catch (Exception e)
{
throw e;
}
}
return true;
}
public bool AddUser(string userName, string pwd, string ChineseName, bool isLock, bool isAdmin, string loginPc, string memo)
{
using (AuthorizeEntities context = new AuthorizeEntities())
{
try
{
var userAdd = new User();
userAdd.UserID = Guid.NewGuid();
userAdd.UserName = userName;
userAdd.Pwd = pwd;
userAdd.ChineseName = ChineseName;
userAdd.IsLock = isLock;
userAdd.IsAdmin = isAdmin;
userAdd.LoginPC = loginPc;
userAdd.Memo = memo;
context.AddToUser(userAdd);
context.SaveChanges();
return true;
}
catch (Exception e)
{
throw e;
}
}
}
public bool delete(string systemId)
{
using (AuthorizeEntities context = new AuthorizeEntities())
{
try
{
Guid guserId = new Guid(systemId);//从子表开始删除 一直到system表
var userid = from userinfo in context.User
where userinfo.UserID == guserId
select userinfo;
var userSystem = from usersys in context.UserSystem
where usersys.UserSystemID == guserId
select usersys;
var sys = from system in context.System
where system.SystemID == guserId
select system;
if (userid.FirstOrDefault() != null)
{
context.DeleteObject(userSystem.First());
context.SaveChanges();
}
if (userid.FirstOrDefault() != null)
{
context.DeleteObject(userid.First());
context.SaveChanges();
}
if (userid.FirstOrDefault() != null)
{
context.DeleteObject(sys.First().UserSystems);
context.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
return true;
}
}
public bool Add(string cityname, bool isactive)
{
using (AuthorizeEntities context = new AuthorizeEntities())
{
try
{
var citys =new City();
citys.CityID=Guid.NewGuid();
citys.CityName = cityname;
citys.IsActive = isactive;
context.AddToCity(citys);
context.SaveChanges();
return true;
}
catch (Exception e)
{
throw e;
}
}
}
public bool AddRole(string roleName, string memo, bool islock)
{
using (AuthorizeEntities context = new AuthorizeEntities())
{
try
{
var roleAdd = new Role();
roleAdd.RoleID = Guid.NewGuid();
roleAdd.RoleName = roleName;
roleAdd.IsLock = islock;
roleAdd.Memo = memo;
context.AddToRole(roleAdd);
context.SaveChanges();
return true;
}
catch (Exception e)
{
throw e;
}
}
}
public bool ValidateUser(string userName, string password)
{
if (String.IsNullOrEmpty(userName)) throw new ArgumentException("Value cannot be null or empty.", "userName");
if (String.IsNullOrEmpty(password)) throw new ArgumentException("Value cannot be null or empty.", "password");
using (AuthorizeEntities context = new AuthorizeEntities())
{
try
{
var adduser = new User();
adduser.UserID = Guid.NewGuid();
adduser.UserName = userName;
adduser.Pwd = EncryptPassword(password);
adduser.IsLock = false;
adduser.IsAdmin = false;
var user = context.User.FirstOrDefault(i => i.UserName == userName);
if (user == null)
{
context.AddToUser(adduser);
context.SaveChanges();
}
return user != null && ComparePassword(password, user.Pwd);
}
catch (Exception e)
{
throw e;
}
}
}
