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