예제 #1
0
        /// <summary>
        /// Submit Store geo tag using multipart
        /// </summary>
        /// <param name="geoTagBO"></param>
        /// <returns></returns>
        public int SubmitStoreGeoTag(StoreGeoTagBO geoTagBO)
        {
            StoreGeoTag storeGeoTag = new StoreGeoTag();

            ObjectMapper.Map(geoTagBO, storeGeoTag);
            int status = StoreRepository.SubmitStoreGeoTag(storeGeoTag);

            return(status);
        }
예제 #2
0
        public StoreGeoTag GetStoreDetails(long surveyResponseID)
        {
            StoreGeoTag result = new StoreGeoTag();

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,
                                                                 new TransactionOptions
            {
                IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted
            }))
            {
                result = (from response in SmartDostDbContext.SurveyResponses
                          join tag in SmartDostDbContext.StoreGeoTags
                          on new { UserID = response.UserID, StoreID = response.StoreID.Value } equals new { UserID = tag.UserID, StoreID = tag.StoreID }
                          where response.SurveyResponseID == surveyResponseID
                          select tag
                          ).ToList().OrderByDescending(x => x.CreatedDate).FirstOrDefault();
                scope.Complete();
            }
            return(result);
        }