public IEnumerable<MSI_MediaRequestResponse> Get(string agency, Guid userId)
        {
            IEnumerable<MSI_MediaRequestResponse> data = null;
            DataQueries query = new DataQueries();
            try
            {
                data = from requestResponse in query.GetMediaRequestResponses(agency, userId).Where(record => record.AgencyId == agency)
                       select requestResponse;
            }

            catch (Exception ex)
            {
                throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError)
                {
                    Content = new StringContent(string.Format("Error occur in Gets MediaRequest : {0}", ex.Message))
                });

            }
            return data;
        }
 public ActionResult GetMediaRequests()
 {
     IEnumerable<MSI_MediaRequestResponse> data = null;
     DataQueries query = new DataQueries();
     try
     {
         data = query.GetMediaRequestResponses(UserAgency, UserId);
     }
     catch (Exception ex)
     {
     }
     return PartialView("_mediaRequests", data);
 }