public static UserInfoMob GetUserDetailsMob(string UserName, int PortalID)
        {
            string sp = "[dbo].[usp_GetUserDetails]";
            SQLHandler sagesql = new SQLHandler();

            List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
            ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", UserName));
            ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));

            List<UserInfoMob> lstUser = new List<UserInfoMob>();
            SqlDataReader reader = null;
            try
            {

                reader = sagesql.ExecuteAsDataReader(sp, ParamCollInput);
                while (reader.Read())
                {
                    UserInfoMob obj = new UserInfoMob();
                    // obj.UserID = new Guid(reader["userid"].ToString());
                    obj.UserName = reader["Username"].ToString();
                    //obj.Password = reader["Password"].ToString();
                    //obj.PasswordSalt = reader["PasswordSalt"].ToString();
                    //obj.PasswordFormat = int.Parse(reader["PasswordFormat"].ToString());
                    obj.FirstName = reader["FirstName"].ToString();
                    obj.LastName = reader["LastName"].ToString();
                    obj.Email = reader["Email"].ToString();
                    // obj.LastPasswordChangeDate = DateTime.Parse(reader["LastPasswordChangedDate"].ToString());
                    //obj.LastActivityDate = DateTime.Parse(reader["LastActivityDate"].ToString());
                    //obj.LastLoginDate = DateTime.Parse(reader["LastLoginDate"].ToString());
                    //obj.IsApproved = bool.Parse(reader["IsApproved"].ToString());
                    obj.UserExists = true;
                    lstUser.Add(obj);
                }
                reader.Close();
                UserInfoMob userObj = lstUser.Count > 0 ? lstUser[0] : new UserInfoMob(false);
                return userObj;

            }
            catch (Exception ex)
            {

                throw (ex);
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }
            }
        }
    public UserInfoMob IsUserValid(string userName, string password, int portalID, int storeID, bool isChecked, string sessionCode)
    {
        SageFrameConfig pagebase = new SageFrameConfig();
        MembershipController member = new MembershipController();
        RoleController role = new RoleController();
        UserInfo user = member.GetUserDetails(portalID, userName);
        UserInfoMob userinfo = member.GetUserDetailsMob(portalID, userName);
        if (user.UserExists && user.IsApproved)
        {
            if (!(string.IsNullOrEmpty(password) && string.IsNullOrEmpty(password)))
            {
                if (PasswordHelper.ValidateUser(user.PasswordFormat, password, user.Password, user.PasswordSalt))
                {

                    int customerID = GetCustomerID();
                    if (customerID == 0)
                    {
                        CustomerGeneralInfo sageUserCust = CustomerGeneralInfoController.CustomerIDGetByUsername(user.UserName, portalID, storeID);
                        if (sageUserCust != null)
                        {
                            customerID = sageUserCust.CustomerID;
                            userinfo.CustomerID = customerID;
                        }
                    }

                    UpdateCartAnonymoususertoRegistered1(storeID, portalID, customerID, sessionCode);
                    userinfo.Status = 1;


                }
                else
                {
                    userinfo = new UserInfoMob();
                    userinfo.Status = 2;//User and Password Combination Doesnot match
                }
            }
        }
        else
        {
            userinfo = new UserInfoMob();
            userinfo.Status = 3;//User Doesnot Exist

        }
        return userinfo;
    }