コード例 #1
0
        public UserViewModel Update(int flag, UserViewModel objEntity)
        {
            try
            {
                //
                Database objDB = base.GetDatabase();
                // Create a suitable command type and add the required parameter.
                using (DbCommand sprocCmd = objDB.GetStoredProcCommand(sp_UserViewModelUpdate))
                {

                    objDB.AddInParameter(sprocCmd, PARAM_Flag, DbType.Int32, flag);
                    objDB.AddInParameter(sprocCmd, PARAM_UserId, DbType.Int32, objEntity.UserId);
                    objDB.AddInParameter(sprocCmd, PARAM_UserEmail, DbType.String, objEntity.UserEmail);
                    objDB.AddInParameter(sprocCmd, PARAM_OldPassword, DbType.String, objEntity.OldPassword);
                    objDB.AddInParameter(sprocCmd, PARAM_Password, DbType.String, objEntity.Password);
                    objDB.AddInParameter(sprocCmd, PARAM_UserTypeId, DbType.Int32, objEntity.UserTypeId);
                    objDB.AddInParameter(sprocCmd, PARAM_UserStatus, DbType.Int32, objEntity.UserStatus);
                    objDB.AddOutParameter(sprocCmd, PARAM_Result, DbType.Int32, objEntity.Result);

                    objDB.ExecuteNonQuery(sprocCmd);
                    objEntity.Result = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, PARAM_Result));
                }
                //
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
            return objEntity;
        }
コード例 #2
0
        public List<UserViewModel> Select(int flag, UserViewModel entity)
        {
            var objEntityList = new List<UserViewModel>();

            try
            {

                Database objDB = base.GetDatabase();
                // Create a suitable command type and add the required parameter.
                using (DbCommand sprocCmd = objDB.GetStoredProcCommand(sp_UserViewModelSelect))
                {
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, flag);
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_USERID, DbType.Int32, entity.UserId);
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_USEREMAIL, DbType.String, entity.UserEmail);
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_PASSWORD, DbType.String, entity.Password);

                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_ROLEID, DbType.Int32, entity.RoleId);

                    using (IDataReader reader = objDB.ExecuteReader(sprocCmd))
                    {

                        while (reader.Read())
                        {
                            UserViewModel objEntity = new UserViewModel();

                            objEntity.UserId = reader.GetColumnValue<Int32>(COLUMN_NAME_USERID);
                            objEntity.RegistrationId = reader.GetColumnValue<Int32>(COLUMN_NAME_REGISTRATIONID);
                            objEntity.RoleId = reader.GetColumnValue<Int16>(COLUMN_NAME_ROLEID);
                            objEntity.RoleName = reader.GetColumnValue<String>(COLUMN_NAME_ROLENAME);

                            objEntity.PhotoName = reader.GetColumnValue<String>(COLUMN_NAME_PHOTONAME);

                            objEntity.Password = reader.GetColumnValue<String>(COLUMN_NAME_PASSWORD);
                            objEntity.PasswordSalt = reader.GetColumnValue<String>(COLUMN_NAME_PASSWORDSALT);
                            objEntity.UserEmail = reader.GetColumnValue<String>(COLUMN_NAME_USEREMAIL);
                            objEntity.UserCreatedDate = reader.GetColumnValue<DateTime>(COLUMN_NAME_CREATEDDATE);
                            objEntity.UserStatus = (StatusEnum)reader.GetColumnValue<Int16>(COLUMN_NAME_USERSTATUS);

                            if (objEntity != null)
                            {
                                objEntityList.Add(objEntity);
                            }
                        }
                    }
                }
            }

            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }

            return objEntityList;
        }
コード例 #3
0
        public UserAccount GetAccountByUser(UserViewModel objEntity)
        {
            UserAccount objUserAccount = new UserAccount();
            objUserAccount.UserID = objEntity.UserId;
            objUserAccount.UserTypeID = Convert.ToInt32(objEntity.UserTypeId);

            objUserAccount.UserEmail = objEntity.UserEmail;

            return objUserAccount;
        }
コード例 #4
0
        public UserViewModel CheckSignIn(int flag, UserLoginViewModel objEntity)
        {
            var objUserViewModel = new UserViewModel
            {
                UserEmail = objEntity.UserEmail,
                Password = objEntity.Password

            };
            return _userRepository.Select(flag, objUserViewModel).FirstOrDefault();
        }
コード例 #5
0
        public UserAccountModel GetAccountByUser(UserViewModel objEntity)
        {
            UserAccountModel objUserAccount = new UserAccountModel();
            objUserAccount.UserId = objEntity.UserId;
            objUserAccount.RoleId = objEntity.RoleId;
            objUserAccount.RegistrationId = objEntity.RegistrationId;
            objUserAccount.PhotoName = objEntity.PhotoName;
            objUserAccount.UserEmail = objEntity.UserEmail;

            return objUserAccount;
        }
コード例 #6
0
 public bool SetAccountByUser(int userID)
 {
     bool isSuccess = false;
     var userViewModel = new UserViewModel() { UserId = userID };
     var objUserViewModel = _userRepository.Select(UserFlags.SelectByID.GetHashCode(), userViewModel).SingleOrDefault();
     if (objUserViewModel != null)
     {
         SessionWrapper.UserAccount = new AccountRepository().GetAccountByUser(objUserViewModel);
         isSuccess = true;
     }
     return isSuccess;
 }
コード例 #7
0
        public List<UserViewModel> Select(int flag, UserViewModel entity)
        {
            var objEntityList = new List<UserViewModel>();

            try
            {

                Database objDB = base.GetDatabase();
                // Create a suitable command type and add the required parameter.
                using (DbCommand sprocCmd = objDB.GetStoredProcCommand(sp_UserViewModelSelect))
                {
                    objDB.AddInParameter(sprocCmd, "Flag", DbType.Int32, flag);
                    objDB.AddInParameter(sprocCmd, "UserId", DbType.Int32, entity.UserId);
                    objDB.AddInParameter(sprocCmd, "UserEmail", DbType.String, entity.UserEmail);
                    objDB.AddInParameter(sprocCmd, "Password", DbType.String, entity.Password);
                    objDB.AddInParameter(sprocCmd, "UserTypeId", DbType.Int32, entity.UserTypeId);

                    using (IDataReader reader = objDB.ExecuteReader(sprocCmd))
                    {

                        while (reader.Read())
                        {
                            var objEntity =
                                new UserViewModel()
                                {
                                    UserId = reader.GetInt32(reader.GetOrdinal("UserId")),
                                    UserTypeId = reader.GetInt32(reader.GetOrdinal("UserTypeId")),
                                    UserEmail = reader.GetString(reader.GetOrdinal("UserEmail")),
                                    UserCreatedDate = reader.GetDateTime(reader.GetOrdinal("UserCreatedDate")),
                                    UserStatus = reader.GetInt32(reader.GetOrdinal("UserStatus")),
                                };
                            if (objEntity != null)
                            {
                                objEntityList.Add(objEntity);
                            }
                        }
                    }
                }
            }

            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }

            return objEntityList;
        }
コード例 #8
0
        public static int Login(UserViewModel objUserViewModel)
        {
            int isResult = LoginResultEnum.Failure.GetHashCode();
            try
            {
                SessionWrapper.UserAccount = new AccountRepository().GetAccountByUser(objUserViewModel);

                FormsAuthentication.SetAuthCookie(Convert.ToString(objUserViewModel.UserId), false);
                isResult = LoginResultEnum.Success.GetHashCode();
            }
            catch (Exception ex)
            {

                throw ex;
            }
            return isResult;
        }
コード例 #9
0
        public UserViewModel Update(int flag, UserViewModel objEntity)
        {
            try
            {
                //
                Database objDB = base.GetDatabase();
                // Create a suitable command type and add the required parameter.
                using (DbCommand sprocCmd = objDB.GetStoredProcCommand(sp_UserViewModelUpdate))
                {

                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, flag);
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_USERID, DbType.Int32, objEntity.UserId);

                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_OLDPASSWORD, DbType.String, objEntity.OldPassword);
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_PASSWORDSALT, DbType.String, objEntity.PasswordSalt);
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_PASSWORD, DbType.String, objEntity.Password);
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_ROLEID, DbType.Int16, objEntity.RoleId);
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_USEREMAIL, DbType.String, objEntity.UserEmail);
                    objDB.AddInParameter(sprocCmd, COLUMN_NAME_USERSTATUS, DbType.Int16, objEntity.UserStatus);
                    objDB.AddOutParameter(sprocCmd, COLUMN_NAME_RESULT, DbType.Int32, objEntity.Result);

                    objDB.ExecuteNonQuery(sprocCmd);
                    objEntity.Result = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_RESULT));
                }
                //
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
            return objEntity;
        }
コード例 #10
0
        public int ValidateUserChangePassword(UserChangePasswordViewModel objEntity)
        {
            int result = 0;
            AccountRepository objAccountRepository = new AccountRepository();
            var objUserRepository = new UserRepository();
            var objLoginUserViewModel = objAccountRepository.GetUserDetailsforLogin(UserFlags.UserSignIn.GetHashCode(), new UserLoginViewModel() { UserEmail = objEntity.UserEmail });

            if (objLoginUserViewModel != null)
            {
                if (PasswordHelpers.Validate(objLoginUserViewModel.Password, objLoginUserViewModel.PasswordSalt, objEntity.NewPassword))
                {
                    result = ResultFlags.OldPasswordMismatch.GetHashCode();

                }
                else
                {
                    PasswordHelpers.HashedPassword objHashedPassword = PasswordHelpers.Generate(objEntity.NewPassword);
                    var objNewUserViewModel = new UserViewModel()
                    {
                        UserId = SessionWrapper.UserAccount.UserId,
                        UserEmail = SessionWrapper.UserAccount.UserEmail,
                        PasswordSalt = objHashedPassword.Salt,
                        Password = objHashedPassword.Password
                    };

                    objNewUserViewModel = objUserRepository.Update(UserFlags.UpdatePasswordByID.GetHashCode(), objNewUserViewModel);
                    result = objNewUserViewModel.Result;

                }

            }

            return result;
        }
コード例 #11
0
        public ActionResult ManageUserEdit(Int16 id, UserViewModel objEntity)
        {
            var objUserRepository = new UserRepository();

            if (ModelState.IsValid)
            {

                objEntity.UserId = id;

                objEntity = objUserRepository.Update(UserFlags.UpdateStatusByID.GetHashCode(), objEntity);
                if (objEntity.Result == ResultFlags.Success.GetHashCode())
                {
                    this.Flash("Success", "User details updated successfully");
                    return RedirectToAction("Index");
                }
                else if (objEntity.Result == ResultFlags.Failure.GetHashCode())
                {

                    this.Flash("Error", "User details failed to Update");
                }

            }

            return View(objEntity);
        }
コード例 #12
0
        public ActionResult ManageUserEdit(int id)
        {
            UserRepository objUserRepository = new UserRepository();

            var objEntity = new UserViewModel();

            objEntity = objUserRepository.Select(UserFlags.SelectByID.GetHashCode(), new UserViewModel()
            {
                UserId = id
            }).FirstOrDefault();
            if (objEntity == null)
            {
                this.Flash("Error", "Failed to edit user details");

                return RedirectToAction("Index");
            }

            return View(objEntity);
        }
コード例 #13
0
        public UserViewModel GetUserDetailsforLogin(int flag, UserLoginViewModel objEntity)
        {
            var objUserViewModel = new UserViewModel
            {
                UserEmail = objEntity.UserEmail

            };
            return _userRepository.Select(flag, objUserViewModel).FirstOrDefault();
        }