// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadByWorkTypeInView
/// </summary>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
/// <param name="inView">inView</param>
public void LoadByWorkTypeInView(string workType, int companyId, bool inView)
{
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway(Data);
workTypeViewSortGateway.LoadByWorkTypeInView(workType, companyId, inView);
UpdateOrder();
}
/// <summary>
/// GetSortForSql
/// </summary>
/// <returns></returns>
public string GetSortForSql()
{
string sort = "";
// process temp table
DataRow[] dataRowOrder = Data.Tables["WorkViewSortTemp"].Select("Deleted = 0", "Order_ ASC");
foreach (DataRow row in dataRowOrder)
{
if (!(((WorkViewTDS.WorkViewSortTempRow)row).Deleted))
{
int order_ = ((WorkViewTDS.WorkViewSortTempRow)row).Order_;
string workType = ((WorkViewTDS.WorkViewSortTempRow)row).WorkType;
int companyId = ((WorkViewTDS.WorkViewSortTempRow)row).COMPANY_ID;
int sortId = ((WorkViewTDS.WorkViewSortTempRow)row).SortID;
WorkTypeViewSort workTypeViewSort = new WorkTypeViewSort();
workTypeViewSort.LoadByWorkTypeSortId(workType, companyId, sortId);
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway(workTypeViewSort.Data);
string tableName = workTypeViewSortGateway.GetTable_(workType, companyId, sortId);
if (tableName == "AM_ASSET_SEWER_SECTION") tableName = "AASS";
if (tableName == "LFS_WORK_FULLLENGTHLINING") tableName = "LWF";
if (tableName == "LFS_WORK") tableName = "LW";
if (tableName == "AM_ASSET_SEWER_LATERAL") tableName = "AASL";
if (tableName == "LFS_ASSET_SEWER_SECTION") tableName = "LASS";
if (tableName == "LFS_WORK_JUNCTIONLINING_SECTION") tableName = "LWJLS";
if (tableName == "LFS_WORK_JUNCTIONLINING_LATERAL") tableName = "LWJLL";
if (tableName == "LFS_WORK_REHABASSESSMENT") tableName = "LWR";
if (tableName == "LFS_WORK_MANHOLE_REHABILITATION") tableName = "LWMR";
if (tableName == "AM_ASSET_SEWER_MH") tableName = "AASMH";
sort = sort + tableName + "." + workTypeViewSortGateway.GetColumn_(workType, companyId, sortId) + ", ";
}
}
sort = sort.Substring(0, sort.Length - 2);
return sort;
}
private string GetOrderByClause()
{
// Get tableName
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway();
workTypeViewSortGateway.LoadByWorkTypeSortId(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string tableName = workTypeViewSortGateway.GetTable_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string columnName = workTypeViewSortGateway.GetColumn_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
if (tableName == "AM_ASSET_SEWER_SECTION") tableName = "AASS";
if (tableName == "LFS_ASSET_SEWER_MH") tableName = "LASMH";
if (tableName == "LFS_WORK_MANHOLE_REHABILITATION") tableName = "LWMR";
if (tableName == "LFS_WORK_MANHOLE_REHABILITATION_BATCH") tableName = "LWMRB";
if (tableName == "AM_ASSET_SEWER_MH") tableName = "AASMH";
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition1.SelectedValue), companyId);
string conditionValue = workTypeViewConditionGateway.GetColumn_(workType, companyId, int.Parse(ddlCondition1.SelectedValue));
// Get order by clause
string orderBy = "";
if (columnName == "Date")
{
switch (conditionValue)
{
case "PreppedDate":
orderBy = "LWMR.PreppedDate DESC";
break;
case "SprayedDate":
orderBy = "LWMR.SprayedDate DESC";
break;
case "Date":
orderBy = "LWMRB.Date DESC";
break;
default:
orderBy = "AASMH.MHID ASC";
break;
}
}
else
{
orderBy = tableName + "." + columnName;
}
return orderBy;
}
private string GetOrderByClause()
{
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway();
workTypeViewSortGateway.LoadByWorkTypeSortId(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string tableName = workTypeViewSortGateway.GetTable_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string columnName = workTypeViewSortGateway.GetColumn_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition1.SelectedValue), companyId);
string conditionValue1 = workTypeViewConditionGateway.GetColumn_(workType, companyId, int.Parse(ddlCondition1.SelectedValue));
if (tableName == "AM_ASSET_SEWER_SECTION") tableName = "AASS";
if (tableName == "LFS_ASSET_SEWER_SECTION") tableName = "LASS";
if (tableName == "LFS_WORK_POINT_REPAIRS") tableName = "LWPR";
// Get order by clause
string orderBy = "";
if (columnName == "Date")
{
switch (conditionValue1)
{
case "ProposedLiningDate":
orderBy = "LWPR.ProposedLiningDate DESC";
break;
case "DeadlineLiningDate":
orderBy = "LWPR.DeadlineLiningDate DESC";
break;
case "FinalVideoDate":
orderBy = "LWPR.FinalVideoDate DESC";
break;
default:
orderBy = "LWPR.WorkID ASC";
break;
}
}
else
{
orderBy = tableName + "." + columnName;
}
return orderBy;
}
private string GetOrderByClause()
{
// For tableName
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway();
workTypeViewSortGateway.LoadByWorkTypeSortId(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string tableName = workTypeViewSortGateway.GetTable_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string columnName = workTypeViewSortGateway.GetColumn_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition1.SelectedValue), companyId);
string conditionValue = workTypeViewConditionGateway.GetColumn_(workType, companyId, int.Parse(ddlCondition1.SelectedValue));
if (tableName == "AM_ASSET_SEWER_SECTION") tableName = "AASS";
if (tableName == "AM_ASSET_SEWER_LATERAL") tableName = "AASL";
if (tableName == "LFS_ASSET_SEWER_SECTION") tableName = "LASS";
if (tableName == "LFS_WORK_JUNCTIONLINING_SECTION") tableName = "LWJLS";
if (tableName == "LFS_WORK_JUNCTIONLINING_LATERAL") tableName = "LWJLL";
string orderBy = "";
if (columnName == "Date")
{
switch (conditionValue)
{
case "VideoInspection":
orderBy = "LWJLL.VideoInspection DESC";
break;
case "PipeLocated":
orderBy = "LWJLL.PipeLocated DESC";
break;
case "ServicesLocated":
orderBy = "LWJLL.ServicesLocated DESC";
break;
case "CoInstalled":
orderBy = "LWJLL.CoInstalled DESC";
break;
case "BackfilledConcrete":
orderBy = "LWJLL.BackfilledConcrete DESC";
break;
case "BackfilledSoil":
orderBy = "LWJLL.BackfilledSoil DESC";
break;
case "Grouted":
orderBy = "LWJLL.Grouted DESC";
break;
case "Cored":
orderBy = "LWJLL.Cored DESC";
break;
case "Prepped":
orderBy = "LWJLL.Prepped DESC";
break;
case "Measured":
orderBy = "LWJLL.Measured DESC";
break;
case "InProcess":
orderBy = "LWJLL.InProcess DESC";
break;
case "InStock":
orderBy = "LWJLL.InStock DESC";
break;
case "Delivered":
orderBy = "LWJLL.Delivered DESC";
break;
case "PreVideo":
orderBy = "LWJLL.PreVideo DESC";
break;
case "LinerInstalled":
orderBy = "LWJLL.LinerInstalled DESC";
break;
case "FinalVideo":
orderBy = "LWJLL.FinalVideo DESC";
break;
case "CoCutDown":
orderBy = "LWJLL.CoCutDown DESC";
break;
case "FinalRestoration":
orderBy = "LWJLL.FinalRestoration DESC";
break;
case "NoticeDelivered":
orderBy = "LWJLL.NoticeDelivered DESC";
break;
default:
orderBy = "AASS.FlowOrderID ASC";
break;
}
}
else
{
orderBy = tableName + "." + columnName;
}
return orderBy;
}
/// <summary>
/// GetSortForSummary
/// </summary>
/// <returns></returns>
public string GetSortForSummary()
{
string sort = "";
DataRow[] dataRowOrder = Data.Tables["WorkViewSortTemp"].Select("Deleted = 0", "Order_ ASC");
foreach (DataRow row in dataRowOrder)
{
if (!(((WorkViewTDS.WorkViewSortTempRow)row).Deleted))
{
string workType = ((WorkViewTDS.WorkViewSortTempRow)row).WorkType;
int companyId = ((WorkViewTDS.WorkViewSortTempRow)row).COMPANY_ID;
int sortId = ((WorkViewTDS.WorkViewSortTempRow)row).SortID;
WorkTypeViewSort workTypeViewSort = new WorkTypeViewSort();
workTypeViewSort.LoadByWorkTypeSortId(workType, companyId, sortId);
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway(workTypeViewSort.Data);
sort = sort + workTypeViewSortGateway.GetName(workType, companyId, sortId) + ", ";
}
}
if (sort.Length > 2)
{
sort = sort.Substring(0, sort.Length - 2);
}
return sort;
}
private string GetOrderByClause()
{
// Get tableName
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway();
workTypeViewSortGateway.LoadByWorkTypeSortId(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string tableName = workTypeViewSortGateway.GetTable_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string columnName = workTypeViewSortGateway.GetColumn_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
if (tableName == "AM_ASSET_SEWER_SECTION") tableName = "AASS";
if (tableName == "LFS_WORK_REHABASSESSMENT") tableName = "LWR";
if (tableName == "LFS_ASSET_SEWER_SECTION") tableName = "LASS";
if (tableName == "LFS_WORK") tableName = "LW";
// Get order by clause
string orderBy = "";
orderBy = tableName + "." + columnName;
return orderBy;
}
private string GetOrderByClause()
{
// Get tableName
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway();
workTypeViewSortGateway.LoadByWorkTypeSortId(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string tableName = workTypeViewSortGateway.GetTable_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string columnName = workTypeViewSortGateway.GetColumn_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
if (tableName == "AM_ASSET_SEWER_SECTION") tableName = "AASS";
if (tableName == "LFS_WORK_FULLLENGTHLINING") tableName = "LWF";
if (tableName == "LFS_ASSET_SEWER_SECTION") tableName = "LASS";
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition1.SelectedValue), companyId);
string conditionValue = workTypeViewConditionGateway.GetColumn_(workType, companyId, int.Parse(ddlCondition1.SelectedValue));
// Get order by clause
string orderBy = "";
if (columnName == "Date")
{
switch (conditionValue)
{
case "ProposedLiningDate":
orderBy = "LWF.ProposedLiningDate DESC";
break;
case "DeadlineLiningDate":
orderBy = "LWF.DeadlineLiningDate DESC";
break;
case "P1Date":
orderBy = "LWF.P1Date DESC";
break;
case "M1Date":
orderBy = "LWF.M1Date DESC";
break;
case "M2Date":
orderBy = "LWF.M2Date DESC";
break;
case "InstallDate":
orderBy = "LWF.InstallDate DESC";
break;
case "FinalVideoDate":
orderBy = "LWF.FinalVideoDate DESC";
break;
case "PreFlushDate":
orderBy = "LWR.PreFlushDate DESC";
break;
case "PreVideoDate":
orderBy = "LWR.PreVideoDate DESC";
break;
default:
orderBy = "AASS.FlowOrderID ASC";
break;
}
}
else
{
orderBy = tableName + "." + columnName;
}
return orderBy;
}
private string GetOrderByClause()
{
// For tableName
string workType = "Junction Lining Section";
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway();
workTypeViewSortGateway.LoadByWorkTypeSortId(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string tableName = workTypeViewSortGateway.GetTable_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
string columnName = workTypeViewSortGateway.GetColumn_(workType, companyId, int.Parse(ddlSortBy.SelectedValue));
if (tableName == "AM_ASSET_SEWER_SECTION") tableName = "AASS";
if (tableName == "LFS_WORK_JUNCTIONLINING_SECTION") tableName = "LWJLS";
if (tableName == "LFS_ASSET_SEWER_SECTION") tableName = "LASS";
string orderBy = tableName + "." + columnName;
return orderBy;
}
/// <summary>
/// LoadByWorkTypeSortId
/// </summary>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
/// <param name="sortId">sortId</param>
public void LoadByWorkTypeSortId(string workType, int companyId, int sortId)
{
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway(Data);
workTypeViewSortGateway.LoadByWorkTypeSortId(workType, companyId, sortId);
}
