예제 #1
0
 public IHttpActionResult GetApp(Guid appId)
 {
     try
     {
         using (MususAppEntities entity = new MususAppEntities())
         {
             var          appMaster = entity.AppMasters.FirstOrDefault(x => x.Id == appId);
             AppMasterDto app       = new AppMasterDto();
             var          rating    = entity.Ratings.Where(x => x.AppId == appMaster.Id);
             if (rating != null && rating.Count() > 0)
             {
                 app.Rating = rating.Average(x => x.Point);
             }
             else
             {
                 app.Rating = 0;
             }
             var useRating = entity.Ratings.FirstOrDefault(x => x.AppId == appMaster.Id &&
                                                           x.Username.Contains(RequestContext.Principal.Identity.Name));
             if (useRating != null)
             {
                 app.UserRating = useRating.Point;
             }
             GetPostComment(entity, appMaster, app, RequestContext.Principal.Identity.Name.ToString());
             MapHostedAppObject(appMaster, app);
             return(Ok(app));
         }
     }
     catch (Exception ex)
     {
         return(BadRequest(ex.Message));
     }
 }
예제 #2
0
 public IHttpActionResult GetAllApps(int page = 1, int size = 10)
 {
     try
     {
         using (MususAppEntities entity = new MususAppEntities())
         {
             List <AppMaster>    appmasters = entity.AppMasters.OrderBy(x => x.Documents).Skip(page - 1).Take(10).ToList();
             List <AppMasterDto> apps       = new List <AppMasterDto>();
             foreach (var master in appmasters)
             {
                 AppMasterDto dto = new AppMasterDto();
                 MapHostedAppObject(master, dto);
                 apps.Add(dto);
             }
             return(Ok(apps));
         }
     }
     catch (Exception ex)
     {
         return(BadRequest(ex.Message));
     }
 }
예제 #3
0
 private void MapHostedAppObject(AppMaster master, AppMasterDto dto)
 {
     dto.AndriodSmartPhoneBuild = master.AndriodSmartPhoneBuild;
     dto.AndriodTabletBuild     = master.AndriodTabletBuild;
     dto.CategoryId             = master.CategoryId;
     dto.CreatedTime            = master.CreatedTime;
     dto.DeletedTime            = master.DeletedTime;
     dto.Description            = master.Description;
     dto.Icon              = master.Icon;
     dto.Id                = master.Id;
     dto.IpadBuild         = master.IpadBuild;
     dto.IpadPackageName   = master.IpadPackageName;
     dto.IphoneBuild       = master.IphoneBuild;
     dto.IphonePackageName = master.IphonePackageName;
     dto.IsDeleted         = master.IsDeleted;
     dto.Published         = master.Published;
     dto.Title             = master.Title;
     dto.Version           = master.Version;
     dto.Download          = master.Download ?? 0;
     if (master.Documents != null)
     {
         var documents = master.Documents.Split(new char[] { ';' });
         foreach (var doc in documents)
         {
             dto.Documents.Add(doc);
         }
     }
     if (master.ScreenShots != null)
     {
         var screenShots = master.ScreenShots.Split(new char[] { ';' });
         foreach (var doc in screenShots)
         {
             dto.ScreenShots.Add(doc);
         }
     }
 }
예제 #4
0
        private static void GetPostComment(MususAppEntities entity, AppMaster appMaster, AppMasterDto app, string userName)
        {
            var userPost = entity.Posts.FirstOrDefault(x => x.AppId == appMaster.Id && x.UserName == userName);

            if (userPost != null)
            {
                var userCR = new CommentReview()
                {
                    Comment     = userPost.Txt,
                    CommentDate = userPost.CreateTime,
                    Username    = userName,
                    Id          = userPost.Id
                };
                var userComment = entity.Comments.FirstOrDefault(x => x.PostId == userPost.Id);
                if (userComment != null)
                {
                    userCR.Review         = userComment.Msg;
                    userCR.ReviewDate     = userComment.CreateTime;
                    userCR.ReviewUsername = userComment.UserName;
                }
                app.UserComment = userCR;
            }
            if (app.UserComment == null)
            {
                var posts = entity.Posts.Where(x => x.AppId == appMaster.Id).OrderByDescending(x => x.CreateTime);
                if (posts != null)
                {
                    foreach (var post in posts)
                    {
                        var review = entity.Comments.FirstOrDefault(x => x.PostId == post.Id);
                        if (review != null)
                        {
                            app.CommentReviews.Add(new CommentReview()
                            {
                                Id             = post.Id,
                                Comment        = post.Txt,
                                CommentDate    = post.CreateTime,
                                Review         = review.Msg,
                                ReviewDate     = review.CreateTime,
                                ReviewUsername = review.UserName,
                                Username       = post.UserName
                            });
                        }
                        else
                        {
                            app.CommentReviews.Add(new CommentReview()
                            {
                                Id          = post.Id,
                                Comment     = post.Txt,
                                CommentDate = post.CreateTime
                            });
                        }
                    }
                }
            }
            else
            {
                var posts = entity.Posts.Where(x => x.AppId == appMaster.Id).OrderByDescending(x => x.CreateTime);
                if (posts != null)
                {
                    foreach (var post in posts)
                    {
                        var review = entity.Comments.FirstOrDefault(x => x.PostId == post.Id);
                        if (review != null)
                        {
                            app.CommentReviews.Add(new CommentReview()
                            {
                                Id             = post.Id,
                                Comment        = post.Txt,
                                CommentDate    = post.CreateTime,
                                Review         = review.Msg,
                                ReviewDate     = review.CreateTime,
                                ReviewUsername = review.UserName,
                                Username       = post.UserName
                            });
                        }
                        else
                        {
                            app.CommentReviews.Add(new CommentReview()
                            {
                                Id          = post.Id,
                                Comment     = post.Txt,
                                CommentDate = post.CreateTime
                            });
                        }
                    }
                }
            }
        }