IEnumerable<view_service> schedule_name = db.Database.SqlQuery<models.view_service>(sql).ToList(); // searching string filter if (current_filter == null || current_filter == "_") current_filter = ""; ViewBag.current_filter = current_filter; // search string in schedule_name by bus_name and driver_name if (!String.IsNullOrEmpty(current_filter)) schedule_name = schedule_name.Where (s => s.code.ToUpper().Contains(current_filter.ToUpper())); //sorting order by code, name, insert_timestamp ViewBag.code = sort_order == "code" ? "code_desc" : "code"; ViewBag.name = sort_order == "name" ? "name_desc" : "name"; ViewBag.insert_timestamp = sort_order == "insert_timestamp" ? "insert_timestamp_desc" : "insert_timestamp"; ViewBag.current_sort = sort_order; switch (sort_order)....
<select data-placeholder="Choose schedule..." class="chosen-select-group" style="width: 260px;" tabindex="-1" value="@ViewBag.current_filter"> --Choose schedule-- @foreach (var item in ViewBag.schedules) { if (item.id.ToString() == ViewBag.Schedule_id.ToString()) { @item.name } else { @item.name } } </select>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)