public static void UpdateUserDetailsOnRegistration(string userName)
{
aspnet_Membership userMembership = new aspnet_Membership();
aspnet_Users aspUser = new aspnet_Users();
WSR_UserInfo newUser = new WSR_UserInfo();
using (WholesaleRajaEntities db = new WholesaleRajaEntities())
{
aspUser = db.aspnet_Users.Where(x => x.LoweredUserName == userName.ToLower()).FirstOrDefault();
userMembership = db.aspnet_Membership.Where(x => x.UserId == aspUser.UserId).FirstOrDefault();
if (aspUser != null && userMembership != null && aspUser.UserName.ToLower() == userName.ToLower() && aspUser.UserId == userMembership.UserId)
{
newUser.UserId = aspUser.UserId;
newUser.UserName = aspUser.UserName;
newUser.Email = userMembership.Email;
db.WSR_UserInfo.Add(newUser);
db.SaveChanges();
}
}
}
/// <summary>
/// Get User Profile from Database
/// </summary>
/// <param name="userName">UserName</param>
/// <returns>UserProfile with all details</returns>
private static UserProfile GetUserProfile(string userName)
{
// If input userName is blank or the logged in user is
if (string.IsNullOrWhiteSpace(userName))
{
return(null);
}
else
{
userName = userName.ToLower();
}
UserProfile userProfile = new UserProfile();
WSR_UserInfo userInfo = new WSR_UserInfo();
List <aspnet_Roles> allRoles = new List <aspnet_Roles>();
List <vw_aspnet_UsersInRoles> allUserRoles = new List <vw_aspnet_UsersInRoles>();
List <string> selectedRoles = new List <string>();
// Get all table values for the given user
using (WholesaleRajaEntities db = new WholesaleRajaEntities())
{
userInfo = db.WSR_UserInfo.Where(x => x.UserName == userName).FirstOrDefault();
allRoles = db.aspnet_Roles.ToList();
allUserRoles = db.vw_aspnet_UsersInRoles.Where(x => x.UserId == userInfo.UserId).ToList();
}
// Get all Role Names for the user and add in the List of selected Roles
foreach (var userRole in allUserRoles)
{
string roleName = allRoles.Where(x => x.RoleId == userRole.RoleId).Select(y => y.RoleName).FirstOrDefault();
if (!string.IsNullOrWhiteSpace(roleName))
{
selectedRoles.Add(roleName);
}
}
userProfile.UserInformation = userInfo;
userProfile.UserRoles = selectedRoles;
return(userProfile);
}
