public DataTable GetMainStreetIntersectionsMaintenanceDecisions(string municName, bool details, bool notMaintOrders)
{
string sql = ""; // MAINTAIN_ORDER_DET_LOCS
string notInMaintOrdersPart = notMaintOrders ? @" and INTERSECTION_ID not in (select INTERSECT_ID from VW_MAINT_ORDERS_FULL where INTERSECT_ID is not null and WORK_STATUS=1)
and INTERSECTION_ID not in (select INTER_ID from FEEDBACK_DETAILS where INTER_ID is not null) "
: "";
string municNum = new Municpiality().GetMunicNo(municName);
if (details)
{
if (municName == "0" || string.IsNullOrEmpty(municName))
{
return(new DataTable());
}
sql = string.Format("select * from VW_LATEST_MD_INTERSAMP where inter_no like '{0}%' and INTER_NO is not null {1} order by arname, INTER_NO ",
municNum, notInMaintOrdersPart);
}
else
{
sql = string.Format("select * from VW_LATEST_MDCOST_SUM_INTER where inter_no like '{0}%' {1} order by arname ", municNum, notInMaintOrdersPart);
}
return(db.ExecuteQuery(sql));
}
public DataTable GetMaintenancePrioritiesForMainStreetIntersectReport(string municName, bool udiDesc, bool udiAsc, bool priority)
{
string orderByPart = GetOrderByPriorityPart(udiDesc, udiAsc, priority);
string municNum = new Municpiality().GetMunicNo(municName);
string sql = string.Format("select * from VW_LATEST_PRIO_INTERSECTIONS where SURVEY_NO>2 and inter_no like '{0}%' {1} ", municNum, orderByPart);
return(db.ExecuteQuery(sql));
}