public List <GetDistrict> GetDistrict()
{
connection.Open();
List <GetDistrict> lstGD = new List <GetDistrict>();
SqlCommand cmd = new SqlCommand("[dbo].[GetDistrict]", connection)
{
CommandType = CommandType.StoredProcedure
};
var dr = cmd.ExecuteReader();
var dt = new DataTable();
if (dr.HasRows)
{
dt.Load(dr);
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
GetDistrict obj = new GetDistrict
{
DistrictCode = Convert.ToInt32(r["DisCode"]),
DistrictName = r["DisName"].ToString()
};
lstGD.Add(obj);
}
}
}
connection.Close();
return(lstGD);
}
public Task <List <GetDistrictResponse> > GetDistrictAsync(GetDistrict dto)
{
return(Task.Run(() =>
{
string cacheName = string.Format(ServiceGlobalConfig.CACHE_DISTRICT_LIST, dto.city_id);
List <GetDistrictResponse> list = CacheHelper.Get <List <GetDistrictResponse> >(cacheName);
if (list == null)
{
var cityList = _districtRepository.Table.Where(t => t.CityId == dto.city_id).ToList();
list = Mapper.Map <List <GetDistrictResponse> >(cityList);
CacheHelper.Insert <List <GetDistrictResponse> >(cacheName, list, 60);
}
return list;
}));
}
public async Task <IHttpActionResult> Get([FromUri] GetDistrict dto)
{
var resp = await _commonService.GetDistrictAsync(dto);
return(Ok(resp));
}
