/// <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> /// DeleteDirect /// </summary> /// <param name="viewId">viewId</param> /// <param name="companyId">companyId</param> public void DeleteDirect(int viewId, int companyId) { WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(null); workViewDisplayGateway.Delete(viewId, companyId); }
/// <summary> /// DeleteDirectForEditView /// </summary> /// <param name="viewId">viewId</param> /// <param name="workType">workType</param> /// <param name="companyId">companyId</param> /// <param name="displayId">displayId</param> public void DeleteDirectForEditView(int viewId, string workType, int companyId, int displayId) { WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(null); workViewDisplayGateway.DeleteForEditView(viewId, workType, companyId, displayId); }
/// <summary> /// UpdateDirect /// </summary> /// <param name="originalViewId">originalViewId</param> /// <param name="originalWorkType">originalWorkType</param> /// <param name="originalCompanyId">originalCompanyId</param> /// <param name="originalDisplayId">originalDisplayId</param> /// <param name="originalDeleted">originalDeleted</param> /// <param name="newViewId">newViewId</param> /// <param name="newWorkType">newWorkType</param> /// <param name="newCompanyId">newCompanyId</param> /// <param name="newDisplayId">newDisplayId</param> /// <param name="newDeleted">newDeleted</param> public void UpdateDirect(int originalViewId, string originalWorkType, int originalCompanyId, int originalDisplayId, bool originalDeleted, int newViewId, string newWorkType, int newCompanyId, int newDisplayId, bool newDeleted) { WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(null); workViewDisplayGateway.Update(originalViewId, originalWorkType, originalCompanyId, originalDisplayId, originalDeleted, newViewId, newWorkType, newCompanyId, newDisplayId, newDeleted); }
/// <summary> /// LoadByViewIdWorkTypeDisplayId /// </summary> /// <param name="viewId">viewId</param> /// <param name="workType">workType</param> /// <param name="companyId">companyId</param> /// <param name="displayId">displayId</param> public void LoadByViewIdWorkTypeDisplayId(int viewId, string workType, int companyId, int displayId) { WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(Data); workViewDisplayGateway.LoadByViewIdWorkTypeDisplayId(viewId, workType, companyId, displayId); }
/// <summary> /// InsertDirect /// </summary> /// <param name="viewId">viewId</param> /// <param name="workType">workType</param> /// <param name="companyId">companyId</param> /// <param name="displayId">displayId</param> /// <param name="deleted">deleted</param> public void InsertDirect(int viewId, string workType, int companyId, int displayId, bool deleted) { WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(null); workViewDisplayGateway.Insert(viewId, workType, companyId, displayId, deleted); }
/// <summary> /// SaveForEdit /// </summary> public void SaveForEdit() { foreach (WorkViewTDS.WorkViewDisplayTempRow rowViewDisplay in (WorkViewTDS.WorkViewDisplayTempDataTable)Data.Tables["WorkViewDisplayTemp"]) { WorkViewDisplay workViewDisplay = new WorkViewDisplay(null); if (!rowViewDisplay.Deleted && !rowViewDisplay.InDatabase && rowViewDisplay.Selected) { workViewDisplay.InsertDirect(rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID, rowViewDisplay.Deleted); } if (!rowViewDisplay.Deleted && rowViewDisplay.InDatabase && rowViewDisplay.Selected) { WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(); workViewDisplayGateway.LoadAllByViewIdWorkTypeDisplayId(rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID); int originalViewId = rowViewDisplay.ViewID; string originalWorkType = rowViewDisplay.WorkType; int originalCompanyId = rowViewDisplay.COMPANY_ID; int originalDisplayId = rowViewDisplay.DisplayID; bool originalDeleted = workViewDisplayGateway.GetDeleted(rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID); workViewDisplay.UpdateDirect(originalViewId, originalWorkType, originalCompanyId, originalDisplayId, originalDeleted, rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID, rowViewDisplay.Deleted); } if (rowViewDisplay.Deleted && rowViewDisplay.InDatabase && !rowViewDisplay.Selected) { workViewDisplay.DeleteDirectForEditView(rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID); } } }
/// <summary> /// ProcessForEdit /// </summary> /// <param name="viewId"></param> /// <param name="workType"></param> /// <param name="companyId"></param> public void ProcessForEdit(int viewId, string workType, int companyId) { foreach (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYRow rowViewDisplay in (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable)Data.Tables["LFS_WORK_TYPE_VIEW_DISPLAY"]) { WorkViewDisplay workViewDisplay = new WorkViewDisplay(); workViewDisplay.LoadAllByViewIdWorkTypeDisplayId(viewId, workType, companyId, rowViewDisplay.DisplayID); WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(workViewDisplay.Data); if (workViewDisplay.ExistsByViewIDWorkTypeDisplayId(viewId, workType, companyId, rowViewDisplay.DisplayID)) { if (rowViewDisplay.Selected) { // Set Deleted in 0 Insert(viewId, workType, companyId, rowViewDisplay.DisplayID, true, true, false); } else { // Set Deleted in 1 Insert(viewId, workType, companyId, rowViewDisplay.DisplayID, false, true, true); } } else { if (rowViewDisplay.Selected) { // Insert Insert(viewId, workType, companyId, rowViewDisplay.DisplayID, true, false, false); } } } }