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; }