Esempio n. 1
0
        public ActionResult Edit(Members member)
        {
            Members dbMember = db.Members.Find(member.MemberID);

            if (dbMember != null)
            {
                try
                {
                    dbMember.MemberName      = member.MemberName;
                    dbMember.MemberPWD       = member.MemberPWD;
                    dbMember.Email           = member.Email;
                    dbMember.Telephone       = member.Telephone;
                    db.Entry(dbMember).State = System.Data.EntityState.Modified;
                    db.SaveChanges();

                    ViewBag.Result = "OK";
                }
                catch (Exception ex)
                {
                    ViewBag.Result = "FAIL";
                }
            }
            else
            {
                ViewBag.Result = "FAIL";
            }

            return(View(dbMember));
        }
Esempio n. 2
0
        public ActionResult ArticleEdit(ArticleViewModel vm)
        {
            ArticleViewModel dbVM = new ArticleViewModel();

            try
            {
                Articles dbArticle = db.Articles.Find(vm.Article.ArticleIDX);
                dbArticle.Title          = vm.Article.Title;
                dbArticle.Category       = vm.Article.Category;
                dbArticle.Contents       = vm.Article.Contents;
                dbArticle.IPAddress      = Request.ServerVariables["REMOTE_ADDR"];
                dbArticle.ModifyDate     = DateTime.Now;
                dbArticle.ModifyMemberID = "admin";

                db.Entry(dbArticle).State = System.Data.EntityState.Modified;
                db.SaveChanges();

                if (Request.Files.Count > 0)
                {
                    var attachFile = Request.Files[0];

                    if (attachFile != null && attachFile.ContentLength > 0)
                    {
                        var fileName = Path.GetFileName(attachFile.FileName);              //파일 이름 추출
                        var path     = Path.Combine(Server.MapPath("~/Upload"), fileName); //파일경로 생성
                        attachFile.SaveAs(path);                                           //생성한 파일 경로대로 실제파일 저장

                        ArticleFiles file = new ArticleFiles();

                        file.ArticleIDX = vm.Article.ArticleIDX;
                        file.FilePath   = "/Upload/";
                        file.FileName   = fileName;
                        file.FileFormat = Path.GetExtension(attachFile.FileName);
                        file.FileSize   = attachFile.ContentLength;
                        file.UploadDate = DateTime.Now;


                        db.ArticleFiles.Add(file);
                        db.SaveChanges();
                    }
                }
                Articles            article = db.Articles.Where(c => c.ArticleIDX == vm.Article.ArticleIDX).FirstOrDefault();
                List <ArticleFiles> files   = db.ArticleFiles.Where(c => c.ArticleIDX == vm.Article.ArticleIDX).OrderBy(o => o.UploadDate).ToList();

                dbVM.Article   = article;
                dbVM.Files     = files;
                ViewBag.Result = "OK";
            }
            catch (DbEntityValidationException dbEx)
            {
                //Console.WriteLine($"Exception: '{ex}'");

                foreach (var validationErrors in dbEx.EntityValidationErrors)
                {
                    foreach (var validationError in validationErrors.ValidationErrors)
                    {
                        System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
                    }
                }

                dbVM           = vm;
                ViewBag.Result = "FAIL";
            }
            return(View(dbVM));
        }