get list from dropdown in mvc

Guest User

i have dynamic dropdown list in which list of car model,if i select one of the option from list then it will show list of that car model, but i get the value of the selected item but didnt get the list of car model,it show Count = 0,

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted answer
test this
public static IEnumerable getUsedCarListByFilters(filters filter)
{
var parameters = new GeneralParameters();
parameters.FilterList = new List();
parameters.SortList = new List();
parameters.Paging = new Paging();
parameters.Paging.PageNumber = 1;
parameters.Paging.PageLines = 10;
parameters.SortList.Add(new Sort() { PropertyName = "createDate", SortType = "DESC " });
if (!string.IsNullOrEmpty(filter.brand))
parameters.FilterList.Add(new Filters() { PropertyName = " brand= '" + filter.brand.ToString() + "'" });
if (!string.IsNullOrEmpty(filter.model))
parameters.FilterList.Add(new Filters() { PropertyName = " modelType='" + filter.model.ToString() + "'" });
if (!string.IsNullOrEmpty(filter.variant))
parameters.FilterList.Add(new Filters() { PropertyName = " AND variant='" + filter.variant.ToString() + "'" });
if (filter.driven > 0)
{
if (parameters.FilterList.Count > 0)
parameters.FilterList.Add(new Filters() { PropertyName = " AND totalDriven<=" + filter.driven.ToString() });
else
parameters.FilterList.Add(new Filters() { PropertyName = " totalDriven<=" + filter.driven.ToString() });
}
if (!string.IsNullOrEmpty(filter.budgetRange))
if (parameters.FilterList.Count > 0)
parameters.FilterList.Add(new Filters() { PropertyName = " AND(expectedPrice>=" + filter.budgetRange.Split('-')[0] + " AND expectedPrice<=" + filter.budgetRange.Split('-')[1] + ")" });
else
parameters.FilterList.Add(new Filters() { PropertyName = " (expectedPrice>=" + filter.budgetRange.Split('-')[0] + " AND expectedPrice<=" + filter.budgetRange.Split('-')[1] + ")" });
if (!string.IsNullOrEmpty(filter.city))
if (parameters.FilterList.Count > 0)
{
if (filter.city == "All" || filter.city == "All City" || filter.city == "All Cities")
parameters.FilterList.Add(new Filters() { PropertyName = " AND saleCity IS NOT NULL" });
//parameters.FilterList.Add(new Filters() { PropertyName = " AND saleCity='" + filter.city.ToString() + "'" + " " });

if((!string.IsNullOrEmpty(filter.brand)){
parameters.FilterList.Add(new Filters() { PropertyName = " brand=" + filter.brand.ToString() });
}
}
else
parameters.FilterList.Add(new Filters() { PropertyName = " saleCity='" + filter.city.ToString() + "'" + " " });
if (!string.IsNullOrEmpty(filter.adType))
if (parameters.FilterList.Count > 0)
parameters.FilterList.Add(new Filters() { PropertyName = " AND adType='" + filter.adType.ToString() + "'" + " " });
else
parameters.FilterList.Add(new Filters() { PropertyName = " adType='" + filter.adType.ToString() + "'" + " " });
var _list = getList(parameters);
return _list;
}
Sachin Singh4y ago
please debug your getlist() method, there might be error in stored procedure or your EF/ADO.Net query.
check whether your getlist() method is getting all parameters correctly or not?
Guest User4y ago
Sachin Singh

still not getting the list(Count=0)

var _list = getList(parameters); (Count=0)
Sachin Singh4y ago
where i have mentioned that???
if you are using carList method then obviously parameter is string so use brand only
see,
what i have mentioned
public ActionResult CarList(string brand)
        {
         filters filter=new filters();
         filter.brand=brand;
            ViewBag.saleCity = filter.city;
TempData["brand"]=brand; // added for your solution to work
            var _list = CarInfoService.getUsedCarListByFilters(filter);
            ViewData.Model = _list;

            return View("UsedCarListParent");
        }
public ActionResult Index()
{

var brand=Convert.ToString(TempData["brand"]);

CarList(brand);
return View("CarInfo");
}
Guest User4y ago
Sachin Singh

public ActionResult Index()
{
var filter = new filters();
CarList(filter); // getting error( cannot convert from 'JKCarMart.DBHelper.filters' to 'string')
return View("CarInfo");
}
Sachin Singh4y ago
Test this
public ActionResult CarList(string brand)
        {
         filters filter=new filters();
         filter.brand=brand;
            ViewBag.saleCity = filter.city;

            var _list = CarInfoService.getUsedCarListByFilters(filter);
            ViewData.Model = _list;

            return View("UsedCarListParent");
        }

you will get two alerts one for value and other for text, please verify what you want and use accordingly. Currently i am using text if you want value then use .val() version.
Guest User4y ago
public static IEnumerable getUsedCarListByFilters(filters filter)
{
var parameters = new GeneralParameters();
parameters.FilterList = new List();
parameters.SortList = new List();
parameters.Paging = new Paging();
parameters.Paging.PageNumber = 1;
parameters.Paging.PageLines = 10;
parameters.SortList.Add(new Sort() { PropertyName = "createDate", SortType = "DESC " });
if (!string.IsNullOrEmpty(filter.brand))
parameters.FilterList.Add(new Filters() { PropertyName = " brand= '" + filter.brand.ToString() + "'" });
if (!string.IsNullOrEmpty(filter.model))
parameters.FilterList.Add(new Filters() { PropertyName = " modelType='" + filter.model.ToString() + "'" });
if (!string.IsNullOrEmpty(filter.variant))
parameters.FilterList.Add(new Filters() { PropertyName = " AND variant='" + filter.variant.ToString() + "'" });
if (filter.driven > 0)
{
if (parameters.FilterList.Count > 0)
parameters.FilterList.Add(new Filters() { PropertyName = " AND totalDriven<=" + filter.driven.ToString() });
else
parameters.FilterList.Add(new Filters() { PropertyName = " totalDriven<=" + filter.driven.ToString() });
}
if (!string.IsNullOrEmpty(filter.budgetRange))
if (parameters.FilterList.Count > 0)
parameters.FilterList.Add(new Filters() { PropertyName = " AND(expectedPrice>=" + filter.budgetRange.Split('-')[0] + " AND expectedPrice<=" + filter.budgetRange.Split('-')[1] + ")" });
else
parameters.FilterList.Add(new Filters() { PropertyName = " (expectedPrice>=" + filter.budgetRange.Split('-')[0] + " AND expectedPrice<=" + filter.budgetRange.Split('-')[1] + ")" });
if (!string.IsNullOrEmpty(filter.city))
if (parameters.FilterList.Count > 0)
{
if (filter.city == "All" || filter.city == "All City" || filter.city == "All Cities")
parameters.FilterList.Add(new Filters() { PropertyName = " AND saleCity IS NOT NULL" });
//parameters.FilterList.Add(new Filters() { PropertyName = " AND saleCity='" + filter.city.ToString() + "'" + " " });
}
else
parameters.FilterList.Add(new Filters() { PropertyName = " saleCity='" + filter.city.ToString() + "'" + " " });
if (!string.IsNullOrEmpty(filter.adType))
if (parameters.FilterList.Count > 0)
parameters.FilterList.Add(new Filters() { PropertyName = " AND adType='" + filter.adType.ToString() + "'" + " " });
else
parameters.FilterList.Add(new Filters() { PropertyName = " adType='" + filter.adType.ToString() + "'" + " " });
var _list = getList(parameters);
return _list;
}
Sachin Singh4y ago
Please share your filters class and also the method getUsedCarListByFilters