public User UpdateRoleUser(int?userId, int?roleId)
{
using (var db = new ModelContainer())
{
var result = db.sp_InsUpdUserRole(userId, roleId).FirstOrDefault();
if (result != null && result.IsError == true)
{
throw new Exception(result.Message);
}
return(new User()
{
UserId = userId
});
}
}
public List <Resource> GetResourcesByUserId(int UserId)
{
using (var db = new ModelContainer())
{
var collection = db.sp_SelResourceByUserId(UserId);
var resp = (from x in collection
select new Resource()
{
DisplayName = x.DisplayName,
Icon = x.Icon,
Position = x.Position,
ResourceId = x.ResourceId,
Url = x.Url,
ParentResourceId = x.ParentResourceId,
AddMenu = x.Menu
}).ToList();
return(resp);
}
}
public User insUpdUser(User parameters)
{
using (var db = new ModelContainer())
{
ObjectParameter UserId = new ObjectParameter("userId", typeof(int?));
UserId.Value = parameters.UserId;
//parameters.Password = Crypto.ToBase64(parameters.Password).ToString();
var result = db.sp_insUpdUser(UserId,
parameters.UserName,
parameters.Password
).FirstOrDefault();
if (result != null && result.IsError == true)
{
throw new Exception(result.Message);
}
parameters.UserId = Convert.ToInt32(UserId.Value.ToString());
return(parameters);
}
}