public ActionResult createAlbumByID(string albumIntro, string albumName, string userID)
        {
            DateTime dateTime        = DateTime.Now; //创建当前时间
            int      createAlbumFlag = 0;
            Album    album           = new Album();

            album.AlbumIntroduction = albumIntro;
            album.AlbumName         = albumName;
            album.UserId            = int.Parse(userID);
            album.AlbumTime         = dateTime;

            try {
                entity.Album.Add(album);
                entity.SaveChanges();
                entity.Entry(album); //返回插入的记录并注入到album
                createAlbumFlag = 1;
            }
            catch (Exception e) {
                Console.WriteLine(e.Message);
            }
            if (createAlbumFlag == 1)
            {
                string newPath = Path.Combine(albumRootPath, userID, album.AlbumId.ToString());
                if (!Directory.Exists(newPath))  //创建相簿文件目录
                {
                    Directory.CreateDirectory(newPath);
                }
            }

            return(Json(new { createAlbumFlag = createAlbumFlag, albumID = album.AlbumId.ToString() }));
        }
        public async Task <SystemResponse> UpdatePost(Post updatePost)
        {
            Post postObject = _dataContext.Set <Post>()
                              .AsTracking()
                              .FirstOrDefault(p => p.Id == updatePost.Id);

            try
            {
                if (postObject == null)
                {
                    throw new RecordNotFoundException($"Post is not found {updatePost.Id}");
                }
                _dataContext.Entry(postObject).CurrentValues.SetValues(updatePost);
                await _dataContext.SaveChangesAsync();

                return(SystemResponse.SuccessResponse("Success"));
            }
            catch (DbUpdateException ex)
            {
                _logger.LogError(ex, "Update post failed");
                _dataContext.Entry(postObject).Reload();
                throw new UpdateFailedException("Update post failed");
            }
            catch (Exception ex)
            {
                _logger.LogError(ex, "Update post failed");
                throw new UpdateFailedException("Update post failed");
            }
        }
        public ActionResult ArticleEdit(Article article, int?id, HttpPostedFileBase postedFile)
        {
            int PcId = Convert.ToInt32(article.PictureId);
            var pc   = blogContext.Picture.Where(a => a.PictureId == PcId).SingleOrDefault();

            if (postedFile != null)
            {
                System.IO.File.Delete(Server.MapPath("~/Images/" + pc.Path));
                var    dt       = Guid.NewGuid().ToString() + "_" + Path.GetFileName(postedFile.FileName);
                string filePath = Path.Combine(Server.MapPath("~/Images/"), dt);
                postedFile.SaveAs(filePath);
                pc.Path = dt;
                blogContext.Entry(pc).State = EntityState.Modified;
            }
            blogContext.Entry(article).State = EntityState.Modified;
            blogContext.SaveChanges();
            return(RedirectToAction("Article", "Admin"));
        }
示例#4
0
        public JsonResult personalInfo(string nick_name, string gender, string location, string year, string month, string day, string email, string tel, string wechat)
        {
            //User user = new User();
            int flag   = 0;
            var userid =
                (from c in entity.User
                 where c.NickName == nick_name
                 select c.UserId).Distinct();
            var id   = userid.FirstOrDefault();
            var user = entity.User.Find(id); //在数据库中根据key找到相应记录

            if (id == default)
            {
                flag = 0; //没有找到该用户
            }
            else
            {
                //user.UserId = id;
                user.Gender   = gender;
                user.Location = location;
                //DateTime dateOfBirth = new DateTime();
                //string.Format("yyyy年MM月dd日", dateOfBirth);
                //user.Dob = dateOfBirth;

                var      yyyy     = year;
                var      mm       = month;
                var      dd       = day;
                DateTime dateTime = new DateTime();
                DateTime.TryParse(yyyy + "-" + mm + "-" + dd, out dateTime);
                user.Dob = dateTime;

                user.Email  = email;
                user.Tel    = tel;
                user.Wechat = wechat;
                //entity.User.Add(user); //把user这个实体加入数据库
                entity.Entry(user).State = EntityState.Modified;
                entity.SaveChanges();
                flag = 1; //信息存储完成
            }
            var data = new {
                Infoflag = flag
            };

            if (flag == 0)
            {
                Response.StatusCode = 404;//没有找到该用户
                return(Json(data));
            }
            else
            {
                Response.StatusCode = 200; //成功修改信息
                return(Json(data));
            }
        }
        public ActionResult createTopicByID()
        {
            DateTime dateTime        = DateTime.Now; //获取当前时间
            Topic    topic           = new Topic();  //新建topic条目项
            int      createTopicFlag = 0;

            try {
                //获取参数
                string content = Request.Form["content"];
                string title   = Request.Form["title"];
                string userID  = Request.Form["userID"];
                string zoneID  = Request.Form["zoneID"];


                //向条目中插入数据
                topic.TopicContent    = content;
                topic.TopicTitle      = title;
                topic.AnswerNum       = 0;
                topic.UserId          = int.Parse(userID);
                topic.TopicUploadTime = dateTime;
                topic.ZoneId          = int.Parse(zoneID);

                var zoneContent = (from c in entity.Zone
                                   where c.ZoneId == int.Parse(zoneID)
                                   select c).FirstOrDefault();
                zoneContent.ZoneTopicNum += 1;
                entity.Zone.Update(zoneContent);
                entity.SaveChanges();

                entity.Add(topic);
                createTopicFlag = entity.SaveChanges(); //存入数据库 返回值为1表示成功
                entity.Entry(topic);
                createTopicFlag = 1;



                return(Json(new { topicDetail = topic, createTopicFlag = createTopicFlag }));
            }
            catch (Exception e) {
                Console.WriteLine(e.Message);
                createTopicFlag = 0;

                return(Json(new { createTopicFlag = createTopicFlag }));
            }
        }
        public JsonResult addArticleByID(string nick_name, string folderName, int articleID)
        {
            var flag = 0;
            //根据用户名找到用户ID
            var userid =
                (from c in entity.User
                 where c.NickName == nick_name
                 select c.UserId).Distinct();
            var    id  = userid.FirstOrDefault();
            string msg = "";

            if (id == default)
            {
                flag = 2;
                //Response.StatusCode = 405;//没找到该用户
                return(Json(new { ReturnFlag = flag, UserID = id, result = "NOT FOUND" }));
            }

            var folderid =
                (from c in entity.Favourite
                 where (c.FavouriteName == folderName && c.UserId == id)
                 select c.FavouriteId).Distinct();
            var F_id = folderid.FirstOrDefault();

            if (F_id == default)
            {
                //Response.StatusCode = 404;//没找到该文件夹
                flag = 3;
                return(Json(new { ReturnFlag = flag, folderID = F_id, result = "NOT FOUND" }));
            }

            try
            {
                //FAVOURITE里面更新收藏夹文章数量
                var folder = entity.Favourite.Find(F_id);
                var num    = folder.ArticleNum;
                if (num == default)
                {
                    folder.ArticleNum = 1;
                }
                else
                {
                    folder.ArticleNum = num + 1;
                }
                entity.Entry(folder).State = EntityState.Modified;
                //entity.SaveChanges();

                //ARTICLE表里面更新文章收藏量
                var article = entity.Article.Find(articleID);
                if (article == default)
                {
                    //Response.StatusCode = 400;//没有该文章
                    flag = 4;
                    return(Json(new { ReturnFlag = flag, ArticleID = articleID, result = "Article NOT FOUND!" }));
                }
                var collectNum = article.CollectNum;
                if (collectNum == default)
                {
                    article.CollectNum = 1;
                }
                else
                {
                    article.CollectNum = collectNum + 1;
                }
                entity.Entry(article).State = EntityState.Modified;
                //entity.SaveChanges();

                //加入FAVOURITE_ARTICLE表
                var item = new FavouriteArticle();
                item.FavouriteId   = F_id;
                item.ArticleId     = articleID;
                item.FavouriteTime = DateTime.Now;
                entity.FavouriteArticle.Add(item);
                entity.SaveChanges();

                //Response.StatusCode = 200;//成功
                flag = 1;
                return(Json(new { ReturnFlag = flag, folderID = F_id, articleId = articleID }));
            }
            catch (Exception e)
            {
                flag = 0;
                msg  = e.Message;
            }
            return(Json(new { Flag = flag, errorMsg = msg }));
        }