/// <summary>
/// GetColumnsByDefault
/// </summary>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
/// <param name="inColumnsByDefault">inColumnsByDefault</param>
/// <returns></returns>
public string GetColumnsByDefault(string workType, int companyId, bool inColumnsByDefault)
{
WorkTypeViewDisplayGateway workTypeViewDisplayGateway = new WorkTypeViewDisplayGateway(Data);
workTypeViewDisplayGateway.LoadByWorkTypeInColumnsByDefault(workType, companyId, inColumnsByDefault);
string columnsByDefault = "";
foreach (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYRow row in (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable)Table)
{
if ((row.WorkType == workType) && (row.COMPANY_ID == companyId) && (row.Always))
{
columnsByDefault = columnsByDefault + row.Column_ + ", ";
}
}
columnsByDefault = columnsByDefault.Substring(0, columnsByDefault.Length - 2);
return columnsByDefault;
}
/// <summary>
/// GetColumnsToDisplay
/// </summary>
/// <returns></returns>
public string GetColumnsToDisplay()
{
string columnsToDisplay = "";
foreach (WorkViewTDS.WorkViewDisplayTempRow row in (WorkViewTDS.WorkViewDisplayTempDataTable)Table)
{
if (row.Selected)
{
WorkTypeViewDisplay workTypeViewDisplay = new WorkTypeViewDisplay();
workTypeViewDisplay.LoadByWorkTypeDisplayId(row.WorkType, row.COMPANY_ID, row.DisplayID);
WorkTypeViewDisplayGateway workTypeViewDisplayGateway = new WorkTypeViewDisplayGateway(workTypeViewDisplay.Data);
columnsToDisplay = columnsToDisplay + workTypeViewDisplayGateway.GetName(row.WorkType, row.COMPANY_ID, row.DisplayID) + ", ";
}
}
if (columnsToDisplay.Length > 2)
{
columnsToDisplay = columnsToDisplay.Substring(0, columnsToDisplay.Length - 2);
}
return columnsToDisplay;
}
/// <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;
}
/// <summary>
/// LoadByWorkTypeDisplayId
/// </summary>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
/// <param name="displayId">displayId</param>
public void LoadByWorkTypeDisplayId(string workType, int companyId, int displayId)
{
WorkTypeViewDisplayGateway columnsToDisplayGateway = new WorkTypeViewDisplayGateway(Data);
columnsToDisplayGateway.LoadByWorkTypeDisplayId(workType, companyId, displayId);
}
