public static string ChangeColumnLevels(string colName, List<ValLvlListItem> finalLevelList, ServerDataSource dataSource)
{
string oldLevels = "c(";
string newLevels = "c(";
int i = 0;
foreach (ValLvlListItem vllst in finalLevelList)
{
if (vllst != null)
{
if (i < finalLevelList.Count - 1)//put comma
{
oldLevels = oldLevels + "\'" + vllst.OriginalLevel.Trim() + "\',";
newLevels = newLevels + "\'" + vllst.NewLevel + "\',";
}
else
{
oldLevels = oldLevels + "\'" + vllst.OriginalLevel.Trim() + "\')";
newLevels = newLevels + "\'" + vllst.NewLevel + "\')";
}
i++;
}
}
return string.Format("BSkyChangeLevels(colNameOrIndex='{0}', oldLevels={1}, newLevels={2}, dataSetNameOrIndex='{3}')", colName, oldLevels, newLevels, dataSource.Name);
}