public List<UserLevelsBO> LoadActiveUserLevels() { DBEgine dbEgine = new DBEgine(); List<UserLevelsBO> userLevelsList = new List<UserLevelsBO>(); try { dbEgine.DBOpen(); SqlDataReader drUserLevels = dbEgine.ExecuteReader("UserManagement.UM_LoadActiveUserLevels", null); if (drUserLevels != null && drUserLevels.HasRows) { while (drUserLevels.Read()) { UserLevelsBO userLevelObj = new UserLevelsBO(); userLevelObj = FillUserLevel(drUserLevels); userLevelsList.Add(userLevelObj); } } return userLevelsList; } catch { throw; } finally { dbEgine.DBClose(); } }
public UserLevelsBO GetNextUserLevelByCurrentUserLevelID(int currentUserLevelID) { DBEgine dbEgine = new DBEgine(); try { UserLevelsBO userLevelObj = new UserLevelsBO(); SqlParameter[] parms = new SqlParameter[1]; dbEgine.DBOpen(); SqlParameter userLevelIdParm = new SqlParameter(); userLevelIdParm.ParameterName = "@UserLevelId"; userLevelIdParm.SqlDbType = SqlDbType.Int; userLevelIdParm.Direction = ParameterDirection.Input; userLevelIdParm.Value = currentUserLevelID; parms[0] = userLevelIdParm; SqlDataReader drUserLevels = dbEgine.ExecuteReader("UserManagement.UM_GetNextUserLevelByCurrentUserLevel", parms); if (drUserLevels != null && drUserLevels.HasRows && drUserLevels.Read()) { userLevelObj = FillUserLevel(drUserLevels); } return userLevelObj; } catch { throw; } finally { dbEgine.DBClose(); } }
public int DeleteUserLevelsDetails(DBEgine dbEgine, int userID, UserLevelsBO obj) { try { SqlParameter[] paramArray = new SqlParameter[1]; SqlParameter userIDParam = new SqlParameter(); userIDParam.ParameterName = "@UserID"; userIDParam.SqlDbType = SqlDbType.Int; userIDParam.Direction = ParameterDirection.Input; userIDParam.Value = userID; paramArray[0] = userIDParam; dbEgine.ExecNonQueryStoredProc("UserManagement.UM_DeleteUserLevelsDetails", paramArray); return obj.UserLevelId; } catch { throw; } }
private void SaveUser() { UserBO user = new UserBO(); //if (!ValidateData(user)) return; try { //if (user.UserId == -1) //{ if (!Common.IsValidPassword(textBoxPassword.Text.ToString().Trim())) { MessageBoxClass.ShowMessage(ErrorMessagesClass.InvaliedPasswordLength, true); return; } if (textBoxPassword.Text.Contains(' ')) { MessageBoxClass.ShowMessage(ErrorMessagesClass.InvaliedPasswordCharacter, true); return; } //} user.UserId = userID; user.UserName = textBoxUserName.Text.ToString(); user.UserPassword = textBoxPassword.Text.ToString(); user.FirstName = textBoxFirstName.Text.ToString().ToUpper(); user.LastName = textBoxLastName.Text.ToString().ToUpper(); user.Initials = "A.B.C"; user.Address = textBoxAddress.Text.ToString().ToUpper(); user.Nic = "NIC"; user.PassportNo = "Passport"; user.EmpNo = "EmpNo"; user.TelHome = "Telephone"; user.TelMobile = "Mobile"; user.Email = textBoxEmail.Text.ToString().ToUpper(); user.UserDesignation = new DesignationBO(); user.UserDesignation.DesignationId = 1; user.UserLevelPrimary = new UserLevelsBO(); var level = new UserLevelsBO(); level.UserLevelId = 1;//int.Parse(comboBoxUserLevel.SelectedValue.ToString()); user.UserLevelPrimary = level; user.UserLevelDeatailList = new List<UserLevelsDetailsBO>(); user.UserLevelDeatailList = LoadUserLevelDetailsList(-1); user.UserBranchDetailList = new List<UserBranchesDetailsBO>(); user.UserBranchDetailList = LoadUserBranchesDetailsList(-1); user.UserGroup = new UserGroupBO(); user.UserGroup.GroupId = 1; user.UserRoles = new List<RoleBO>(); var role=new RoleBO(); role.RoleId = int.Parse(comboBoxUserLevel.SelectedValue.ToString()); role.IsActive = true; user.UserRoles.Add(role); /*User Type, Group Id , lock*/ user.UserType = 0; user.IsLock = 0; user.IsClientManager = false; user.IsAccountManager = false; user.IsEnable = checkBoxStatus.Checked; user.CreatedUser = Common.User.UserId; user.PasswordExpirePeriod = 0;//Convert.ToInt32(txtPasswordExpirePeriod.Text); user.IsUserChangePasswordFirstLogin = false;//ChkUserPasswordChange.Checked; user.IsPasswordExpire = false;//ChkPasswordExpire.Checked; user.IsAllowConcurrentConnection = false;//ChkConcurrentConnection.Checked; user.CreatedUser = Common.User.UserId; user.CreatedDate = DateTime.Now; user.UserId = new UserDAL().AddUser(user); if (user.UserId > 0) { MessageBoxClass.ShowMessage(ErrorMessagesClass.UserSaveSucess, false); GetUserInfo(user); //HidePassWordPannel(); } else if (user.UserId == -1) { MessageBoxClass.ShowMessage(ErrorMessagesClass.UserNameAlreadyExists , true); } else { MessageBoxClass.ShowMessage(ErrorMessagesClass.UserSaveFail, true); } } catch { //lblErrorMsg.Text = Common.GerErrorMessage("UM-16"); } }
private UserLevelsBO FillUserLevel(SqlDataReader reader) { UserLevelsBO userLevel = new UserLevelsBO(); userLevel.UserLevelId = reader.GetInt32(reader.GetOrdinal("UserLevelId")); userLevel.UserLevel = reader.GetValue(reader.GetOrdinal("UserLevel")).ToString(); userLevel.IsActive = reader.GetBoolean(reader.GetOrdinal("IsActive")); try { userLevel.Rate = reader.GetInt32(reader.GetOrdinal("Rate")); } catch { } try { userLevel.UserId = reader.GetInt32(reader.GetOrdinal("ModifiedBy")); if (userLevel.UserId == 0) { userLevel.UserId = reader.GetInt32(reader.GetOrdinal("CreatedBy")); } } catch { } return userLevel; }
public bool SaveUserLevel(UserLevelsBO obj) { DBEgine dbEgine = new DBEgine(); try { UserLevelsBO userLevelsObj = new UserLevelsBO(); SqlParameter[] parms = new SqlParameter[8]; dbEgine.DBOpen(); SqlParameter userLevelIdNewParm = new SqlParameter(); userLevelIdNewParm.ParameterName = "@UserLevelIdNew"; userLevelIdNewParm.SqlDbType = SqlDbType.Int; userLevelIdNewParm.Direction = ParameterDirection.InputOutput; userLevelIdNewParm.Value = obj.UserLevelId; parms[0] = userLevelIdNewParm; SqlParameter userLevelIdOldParm = new SqlParameter(); userLevelIdOldParm.ParameterName = "@UserLevelIdOld"; userLevelIdOldParm.SqlDbType = SqlDbType.Int; userLevelIdOldParm.Direction = ParameterDirection.InputOutput; userLevelIdOldParm.Value = obj.UserLevelIdOld; parms[1] = userLevelIdOldParm; SqlParameter userLevelParm = new SqlParameter(); userLevelParm.ParameterName = "@UserLevel"; userLevelParm.SqlDbType = SqlDbType.NVarChar; userLevelParm.Direction = ParameterDirection.Input; userLevelParm.Value = obj.UserLevel; parms[2] = userLevelParm; SqlParameter isActiveParm = new SqlParameter(); isActiveParm.ParameterName = "@IsActive"; isActiveParm.SqlDbType = SqlDbType.Bit; isActiveParm.Direction = ParameterDirection.Input; isActiveParm.Value = obj.IsActive; parms[3] = isActiveParm; SqlParameter createdByParm = new SqlParameter(); createdByParm.ParameterName = "@CreatedBy"; createdByParm.SqlDbType = SqlDbType.Int; createdByParm.Direction = ParameterDirection.Input; createdByParm.Value = obj.UserId; parms[4] = createdByParm; SqlParameter modifiedByParm = new SqlParameter(); modifiedByParm.ParameterName = "@ModifiedBy"; modifiedByParm.SqlDbType = SqlDbType.Int; modifiedByParm.Direction = ParameterDirection.Input; modifiedByParm.Value = obj.UserId; parms[5] = modifiedByParm; SqlParameter stateParm = new SqlParameter(); stateParm.ParameterName = "@State"; stateParm.SqlDbType = SqlDbType.Bit; stateParm.Direction = ParameterDirection.InputOutput; stateParm.Value = 0; parms[6] = stateParm; SqlParameter rateParm = new SqlParameter(); rateParm.ParameterName = "@Rate"; rateParm.SqlDbType = SqlDbType.Int; rateParm.Direction = ParameterDirection.Input; rateParm.Value = obj.Rate; parms[7] = rateParm; dbEgine.ExecNonQueryStoredProc("UserManagement.UM_SaveUserLevel", parms); bool state = Boolean.Parse(stateParm.Value.ToString()); dbEgine.DBClose(); return state; } catch { throw; } finally { dbEgine.DBClose(); } }