public List <IdName> GetCityList(ReqGetCityList req)
{
var cityList = new List <City>();
if (!string.IsNullOrWhiteSpace(req.StateId))
{
cityList =
Provider.Database.ReadList <City>(
"SELECT Id, Name FROM City WHERE StateId={0} AND IsDeleted=0 ORDER BY Name", req.StateId);
}
else if (!string.IsNullOrWhiteSpace(req.CountryId))
{
cityList =
Provider.Database.ReadList <City>(
"SELECT Id, Name FROM City WHERE CountryId={0} AND IsDeleted=0 ORDER BY Name", req.CountryId);
}
return(cityList.Select(c => new IdName()
{
Id = c.Id, Name = c.Name
}).ToList());
}
public List <IdName> GetCityList(ReqGetCityList req)
{
return(Call <List <IdName>, ReqGetCityList>(req, MethodBase.GetCurrentMethod().Name));
}
