private static String[] GetDataset(DataTable dtroutes)
{
String[] returnval = new String[dtroutes.Rows.Count + 2];
try
{
decimal max = 0; decimal min = 0; decimal dec = 0; decimal din = 0;
#region Get bus rating
ClsBAL objManabusBAL = new ClsBAL();
DataTable dtRating = objManabusBAL.GetRatings().Tables[0];
#endregion
#region Get distinct travels
DataTable dtTravels = ((DataTable)(HttpContext.Current.Session["dtRoutes"])).DefaultView.ToTable(true, "Travels");
DataRow[] drTravels = dtTravels.Select("", "Travels ASC");
StringBuilder sbTravels = new StringBuilder();
if (drTravels.Length > 0)
{
sbTravels.Append("<select id=\"ddlOperator\" name=\"ddlOperator\" multiple=\"multiple\" class=\"Dropdownlist\" onchange=\"LoadFilteredRoutes(event,''); return false;\" >");//multiple=\"multiple\"
//sbTravels.Append("<option value=''>All Operators</option>");
string strOperator = "";
if (HttpContext.Current.Session["travelOperatorSelected"] != null)
{
strOperator = HttpContext.Current.Session["travelOperatorSelected"].ToString();
}
foreach (DataRow item in drTravels)
{
if (strOperator != item["Travels"].ToString())
{
sbTravels.Append("<option value=" + "\"" + item["Travels"].ToString() + "\"" + ">" + item["Travels"].ToString() + "</option>");
}
else
{
sbTravels.Append("<option selected='selected' value=" + "\"" + item["Travels"].ToString() + "\"" + ">" + item["Travels"].ToString() + "</option>");
}
}
sbTravels.Append("</select>");
}
returnval[dtroutes.Rows.Count] = sbTravels.ToString();
#endregion
for (int i = 0; i < dtroutes.Rows.Count; i++)
{
DataRow[] dr = null;
if (dtroutes.Rows[i]["Travels"].ToString().Length >= 5)
{
dr = dtRating.Select("BusOperatorName LIKE '" + dtroutes.Rows[i]["Travels"].ToString().Substring(0, 5) + "%'");
}
else { dr = dtRating.Select("BusOperatorName LIKE '" + dtroutes.Rows[i]["Travels"].ToString() + "%'"); }
String sRating = dr.Length > 0 ? "Images/star" + dr[0]["Rating"].ToString() + ".png" : "Images/star3.png";
//sRating = "";
string sDuration = dtroutes.Rows[i]["Duration"].ToString();
if (sDuration == "") { sDuration = " - "; }
string sArrTime = dtroutes.Rows[i]["ArrTime"].ToString();
if (sArrTime == "") { sArrTime = " - "; }
string sBusType = dtroutes.Rows[i]["BusType"].ToString();
if (sBusType.Length > 50) { sBusType = sBusType.Substring(0, 48); }
returnval[i] = dtroutes.Rows[i]["API"].ToString() + "~" + dtroutes.Rows[i]["SNo"].ToString() + "~"
+ dtroutes.Rows[i]["Travels"].ToString() + "~" + sBusType + "~"
+ dtroutes.Rows[i]["DepTime"].ToString() + "~" + sArrTime + "~"
+ sDuration + "~" + dtroutes.Rows[i]["Fare"].ToString() + "~"
+ dtroutes.Rows[i]["ReservationId"].ToString() + "~"
+ dtroutes.Rows[i]["ServiceId"].ToString() + "~" + dtroutes.Rows[i]["CoachTypeId"].ToString() + "~"
+ dtroutes.Rows[i]["ServiceNumber"].ToString() + "~"
+ dtroutes.Rows[i]["BoardingPointsWithIds"].ToString() + "~" + dtroutes.Rows[i]["DropingPointsWithIds"].ToString() + "~"
+ dtroutes.Rows[i]["lblS"].ToString() + "~"
+ dtroutes.Rows[i]["lblB"].ToString() + "~"
+ sRating + "~" + dtroutes.Rows[i]["AvailableSeats"].ToString();
if (i == 0) { max = min = Convert.ToDecimal(Convert.ToDecimal(dtroutes.Rows[i]["Fare"].ToString()).ToString("0", System.Globalization.CultureInfo.InvariantCulture)); }
dec = din = Convert.ToDecimal(Convert.ToDecimal(dtroutes.Rows[i]["Fare"].ToString()).ToString("0", System.Globalization.CultureInfo.InvariantCulture));
if (dec > max) { max = dec; }
if (din < min) { min = din; }
}
if (dtroutes.Rows.Count != 0)
{
returnval[dtroutes.Rows.Count + 1] = min + "|" + max;
}
else { returnval[dtroutes.Rows.Count + 1] = "1" + "|" + "2500"; }
}
catch (Exception e)
{
//
}
return returnval;
}
void BindGrid()
{
objBAL = new ClsBAL();
DataSet ds = objBAL.GetRatings();
gvRating.DataSource = ds;
ViewState["Rating"] = ds.Tables[0];
gvRating.DataBind();
}