/// <summary>
/// GetColumnsToDisplayForViews
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
/// <returns>columnsToDisplay</returns>
public string GetColumnsToDisplayForViews(int viewId, string workType, int companyId)
{
WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(Data);
workViewDisplayGateway.LoadByViewIdWorkType(viewId, workType, companyId);
string columnsToDisplay = "";
foreach (WorkViewTDS.LFS_WORK_VIEW_DISPLAYRow row in (WorkViewTDS.LFS_WORK_VIEW_DISPLAYDataTable)Table)
{
if ((row.WorkType == workType) && (row.COMPANY_ID == companyId) && (row.ViewID == viewId))
{
WorkTypeViewDisplayGateway workTypeViewDisplayGateway = new WorkTypeViewDisplayGateway();
workTypeViewDisplayGateway.LoadByWorkTypeDisplayId(workType, companyId, row.DisplayID);
if (row.WorkType == "Junction Lining")
{
string column = workTypeViewDisplayGateway.GetColumn_(workType, companyId, row.DisplayID);
switch (column)
{
case "USMH":
columnsToDisplay = columnsToDisplay + "U_SMH" + ", ";
break;
case "DSMH":
columnsToDisplay = columnsToDisplay + "D_SMH" + ", ";
break;
case "Address":
columnsToDisplay = columnsToDisplay + "MN" + ", ";
break;
case "NoticeDelivered":
columnsToDisplay = columnsToDisplay + "NoticeD_elivered" + ", ";
break;
default:
columnsToDisplay = columnsToDisplay + workTypeViewDisplayGateway.GetColumn_(workType, companyId, row.DisplayID) + ", ";
break;
}
}
else
{
columnsToDisplay = columnsToDisplay + workTypeViewDisplayGateway.GetColumn_(workType, companyId, row.DisplayID) + ", ";
}
}
}
columnsToDisplay = columnsToDisplay.Substring(0, columnsToDisplay.Length - 2);
return columnsToDisplay;
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadByViewIdWorkType
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
public void LoadByViewIdWorkType(int viewId,string workType, int companyId)
{
WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(Data);
workViewDisplayGateway.LoadByViewIdWorkType(viewId,workType, companyId);
}
