/// <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); }