public List<UserLevelsDetailsBO> LoadAllUserLevelsByUserID(int userId)
{
List<UserLevelsDetailsBO> userLevelsList = new List<UserLevelsDetailsBO>();
UserLevelsDetailsBO userLevel = new UserLevelsDetailsBO();
DBEgine dbEgine = new DBEgine();
try
{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "UserID";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = userId;
parms[0] = p1;
dbEgine.DBOpen();
SqlDataReader drUserLevels = dbEgine.ExecuteReader("UserManagement.UM_LoadUserLevelsByUserID", parms);
if (drUserLevels != null && drUserLevels.HasRows)
{
while (drUserLevels.Read())
{
userLevel = FillUserLevels(drUserLevels);
userLevelsList.Add(userLevel);
}
}
return userLevelsList;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public int AddUserLevelsDetails(DBEgine dbEgine,int userId,UserLevelsDetailsBO obj)
{
try
{
SqlParameter[] paramArray = new SqlParameter[3];
SqlParameter userLevelIDParam = new SqlParameter();
userLevelIDParam.ParameterName = "@UserLevelID";
userLevelIDParam.SqlDbType = SqlDbType.Int;
userLevelIDParam.Direction = ParameterDirection.Input;
userLevelIDParam.Value = obj.UserLevelID;
paramArray[0] = userLevelIDParam;
SqlParameter userIDParam = new SqlParameter();
userIDParam.ParameterName = "@UserID";
userIDParam.SqlDbType = SqlDbType.Int;
userIDParam.Direction = ParameterDirection.Input;
userIDParam.Value = userId;
paramArray[1] = userIDParam;
SqlParameter isPrimaryParam = new SqlParameter();
isPrimaryParam.ParameterName = "@IsPrimary";
isPrimaryParam.SqlDbType = SqlDbType.Bit;
isPrimaryParam.Direction = ParameterDirection.Input;
isPrimaryParam.Value = obj.IsPrimary;
paramArray[2] = isPrimaryParam;
dbEgine.ExecNonQueryStoredProc("UserManagement.UM_AddUserLevelsDetails", paramArray);
return obj.UserLevelID;
}
catch
{
throw;
}
}
private UserLevelsDetailsBO FillUserLevelsWithName(SqlDataReader reader)
{
var userLevels = new UserLevelsDetailsBO();
userLevels.UserLevelDetailID = reader.GetInt32(reader.GetOrdinal("UserLevelDetailID"));
userLevels.UserID = reader.GetInt32(reader.GetOrdinal("UserID"));
userLevels.UserLevelID = reader.GetInt32(reader.GetOrdinal("UserLevelID"));
userLevels.IsPrimary = reader.GetBoolean(reader.GetOrdinal("IsPrimary"));
userLevels.UserLevel = reader.GetString(reader.GetOrdinal("UserLevel"));
return userLevels;
}