public string GetActualAdditionalSearchColumns()
{
List <string> Columns = new List <string>();
string Culture = SqlHelper.EscapeQuotes(DataHelper.GetNotEmpty(URLHelper.GetQueryValue(Request.RawUrl, "culture"), "en-US"));
foreach (string AdditionalColumn in AdditionalSearchColumns.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries))
{
string CleanAdditionalColumn = AdditionalColumn.ToLower().Trim();
if (DocumentColumnsToDataClass.ContainsKey(CleanAdditionalColumn))
{
Columns.Add(string.Format("(select top 1 {0} from CMS_Document where DocumentNodeID = NodeID order by (case when DocumentCulture = '{1}' then 0 else 1 end))", CleanAdditionalColumn, Culture));
}
else if (ColumnsToDataClass.ContainsKey(CleanAdditionalColumn))
{
DataClassInfo ClassObj = ColumnsToDataClass[CleanAdditionalColumn];
Columns.Add(string.Format("(select top 1 {0} from {1} where {2} = (select top 1 DocumentForeignKeyValue from CMS_Document where DocumentNodeID = NodeID order by (case when DocumentCulture = '{3}' then 0 else 1 end)))"
, CleanAdditionalColumn, ClassObj.ClassTableName, ClassToPrimaryKeyColumn[ClassObj.ClassName.ToLower()], Culture));
}
else
{
Columns.Add(AdditionalColumn);
}
}
return(string.Join(",", Columns));
}
public GameColumns(ColumnBase.ChangeColumnDelegate alignDeckSequence)
{
ColResult = new ColumnResult[AdditionalData.CountResultColumns];
ColGame = new ColumnGame[AdditionalData.CountGameColumns];
ColAdditional = new AdditionalColumn[2];
ColDeck = new ColumnDeck();
InitializeColumns(alignDeckSequence);
}
public Columns()
{
ColResult = new ColumnResult[StaticGameData.CountResultColumns];
ColGame = new ColumnGame[StaticGameData.CountGameColumns];
ColAdditional = new AdditionalColumn[2];
ColDeck = new ColumnDeck();
// initialize every column
for (int index = 0; index < ColResult.Length; index++)
{
ColResult[index] = new ColumnResult();
}
for (int index = 0; index < ColGame.Length; index++)
{
ColGame[index] = new ColumnGame(index);
}
ColAdditional[Constants.iColKing] = new AdditionalColumn(CrazyFord.Data.Name.King);
ColAdditional[Constants.iColJoker] = new AdditionalColumn(CrazyFord.Data.Name.Joker);
}
