public void AddRole(string aspNetUserId, string roleName)
{
LMSUserUpdateRequest user = new LMSUserUpdateRequest();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var cmd = new SqlCommand("AspNetUserAddRole", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", aspNetUserId);
cmd.Parameters.AddWithValue("@Name", roleName);
cn.Open();
cmd.ExecuteNonQuery();
}
}
public void UpdateRoles(LMSUserUpdateRequest request)
{
using (var transactionScope = new System.Transactions.TransactionScope())
{
_lmsRoleRepository.RemoveRoles(request.ID);
foreach (var role in request.RoleNames)
{
_lmsRoleRepository.AddRole(request.ID, role);
}
transactionScope.Complete();
}
}
public ActionResult GetUserDetails(UserDetailsToEditVM user)
{
var request = new LMSUserUpdateRequest();
request.UserID = user.UserDetailsToEdit.UserID;
request.ID = user.UserDetailsToEdit.ID;
request.FirstName = user.UserDetailsToEdit.FirstName;
request.LastName = user.UserDetailsToEdit.LastName;
request.GradeLevelID = user.UserDetailsToEdit.GradeLevelID;
foreach (var roleSelection in user.SelectedRoles)
{
if (roleSelection.CheckedStatus)
{
request.RoleNames.Add(roleSelection.RoleName);
}
}
_lmsRoleManager.UpdateRoles(request);
_lmsUserManager.UpdateUserDetails(request);
return RedirectToAction("Index", "Admin");
}
public List<LMSUserUpdateRequest> UserGetAllRoles(int UserID)
{
List<LMSUserUpdateRequest> users = new List<LMSUserUpdateRequest>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var cmd = new SqlCommand("UserViewDetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", UserID);
cn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var user = new LMSUserUpdateRequest();
user.UserID = (int) dr["UserID"];
user.ID = dr["ID"].ToString();
user.FirstName = dr["FirstName"].ToString();
user.LastName = dr["LastName"].ToString();
user.UserId = dr["LastName"].ToString();
user.RoleID = dr["RoleId"].ToString();
user.RoleName = dr["Name"].ToString();
users.Add(user);
}
}
}
return users;
}
public LmsUser UpdateUserDetails(LMSUserUpdateRequest user)
{
LmsUser user1 = new LmsUser();
return user1;
}
public LmsUser UpdateUserDetails(LMSUserUpdateRequest user)
{
LmsUser user1 = new LmsUser();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var cmd = new SqlCommand("UserUpdateDetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", user.UserID);
cmd.Parameters.AddWithValue("@ID", user.ID);
cmd.Parameters.AddWithValue("@FirstName", user.FirstName);
cmd.Parameters.AddWithValue("@LastName", user.LastName);
cmd.Parameters.AddWithValue("@GradeLevelID", user.GradeLevelID);
cn.Open();
cmd.ExecuteNonQuery();
}
return user1;
}
//public DataResponse<LmsUser> UpdateUserDetails(LmsUser user)
public DataResponse<LmsUser> UpdateUserDetails(LMSUserUpdateRequest user)
{
var response = new DataResponse<LmsUser>();
try
{
response.Data = _lmsUserRepository.UpdateUserDetails(user);
response.Success = true;
}
catch (Exception ex)
{
response.Message = "User not updated";
}
return response;
}
