public IResponseDTO GetAllAdvertisementSTP()
 {
     try
     {
         var Citys     = _View_AdvertisementRepositroy.ExecuteQueryView("SELECT * FROM [dbo].[View_Advertisement]", null).ToList();
         var CitysList = _mapper.Map <List <AdvertisementVM> >(Citys);
         _response.Data     = CitysList;
         _response.IsPassed = true;
         _response.Message  = "Done";
     }
     catch (Exception ex)
     {
         _response.Data     = null;
         _response.IsPassed = false;
         _response.Message  = "Error " + ex.Message;
     }
     return(_response);
 }