public ViewModelUserInformation GetUserInformation()
{
SqlParameter[] param =
{
new SqlParameter("@flag", SqlDbType.VarChar, 100)
{
Value = "user-info"
}
, new SqlParameter("@user", SqlDbType.NVarChar, 128)
{
Value = SessionHelper.GetUserID()
}
};
DataRow result = SqlHelper.ExecuteDataRow("spUserProfile", param);
ViewModelUserInformation userInfo = new ViewModelUserInformation();
if (result.Table.Rows.Count > 0)
{
userInfo.FullName = Convert.ToString(result["FullName"]);
userInfo.CompanyId = Convert.ToString(result["CompanyId"]);
userInfo.CompanyName = Convert.ToString(result["CompanyName"]);
userInfo.CompanyCode = Convert.ToString(result["CompanyCode"]);
userInfo.Email = Convert.ToString(result["Email"]);
userInfo.Phone = Convert.ToString(result["Phone"]);
userInfo.SessionTimeOut = result["SessionTimeOut"] != DBNull.Value ? Convert.ToInt32(result["SessionTimeOut"]) : (int?)null;
userInfo.DOB = result["DOB"] != DBNull.Value ? Convert.ToDateTime(result["DOB"]) : (DateTime?)null;
userInfo.Gender = Convert.ToString(result["Gender"]);
userInfo.FiscalCode = Convert.ToString(result["Fiscal"]);
}
return(userInfo);
}
public void SetUserSession()
{
ViewModelUserInformation userInformation = iCommonLibrary.GetUserInformation();
SessionHelper.SetSession <string>("userName", User.Identity.Name);
SessionHelper.SetSession <string>("userFullName", userInformation.FullName);
SessionHelper.SetSession <string>("companyId", userInformation.CompanyId);
SessionHelper.SetSession <string>("userEmail", userInformation.Email);
SessionHelper.SetSession <string>("userPhone", userInformation.Phone);
SessionHelper.SetSession <int?>("userSessionTimeOut", userInformation.SessionTimeOut);
SessionHelper.SetSession <DateTime?>("userDOB", userInformation.DOB);
SessionHelper.SetSession <string>("userGender", userInformation.Gender);
SessionHelper.SetSession <string>("fiscalCode", userInformation.FiscalCode);
SessionHelper.SetSessionTimeOut(userInformation.SessionTimeOut);
// SessionHelper.SetSession<string>("userKey", CommonLibraryService.GetKeyName(1).Key);
//var UserId = User.Identity.GetUserId();
//var role = UserManager.GetRoles(UserId);
//string roleName = role[0];
}
