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