public string Post(RefItem refItem) { string success = ""; try { using (WebSiteContext db = new WebSiteContext()) { Ref @ref = new Ref(); @ref.RefType = refItem.RefType; @ref.RefCode = GetUniqueRefCode(refItem.RefDescription, db); @ref.RefDescription = refItem.RefDescription; db.Refs.Add(@ref); db.SaveChanges(); //refModel.RefCode = @ref.RefCode; success = "ok"; } } catch (Exception ex) { success = ex.Message; } return(success); }
public string Put(Comment updateComment) { string success = ""; try { using (WebSiteContext db = new WebSiteContext()) { Comment comment = db.Comments.Where(c => c.CommentId == updateComment.CommentId).FirstOrDefault(); if (comment != null) { comment.CommentText = updateComment.CommentText; comment.CommentTitle = updateComment.CommentTitle; db.SaveChanges(); success = "ok"; } else { success = "comment not found"; } } } catch (Exception ex) { success = Helpers.ErrorDetails(ex); } return(success); }
public CommentsModel Post(CommentsModel newComment) { try { using (WebSiteContext db = new WebSiteContext()) { var comment = new Comment(); comment.CreateDate = DateTime.Now; comment.ArticleId = newComment.ArticleId; comment.CommentText = newComment.CommentText; comment.CommentTitle = newComment.CommentTitle; comment.UserId = newComment.UserId; comment.UserName = newComment.UserName; db.Comments.Add(comment); db.SaveChanges(); newComment.CommentId = comment.CommentId; newComment.CreateDate = comment.CreateDate.ToShortDateString(); newComment.success = "ok"; //newComment.success = new GodaddyEmailController().SendEmail("Somebody Actually Made A comment", comment.UserName + " said: " + comment.CommentText); } } catch (Exception ex) { newComment.success = Helpers.ErrorDetails(ex); } return(newComment); }
public string UpdateArticle(VwArticle articleModel) { var success = ""; try { using (WebSiteContext db = new WebSiteContext()) { Article updateArticle = db.Articles.Where(a => a.Id.ToString() == articleModel.Id).FirstOrDefault(); updateArticle.Title = articleModel.Title; updateArticle.CategoryRef = articleModel.CategoryRef; updateArticle.SubCategoryRef = articleModel.SubCategoryRef; updateArticle.ImageName = articleModel.ImageName; updateArticle.LastUpdated = articleModel.LastUpdated; //DateTime.Now; updateArticle.ByLineRef = articleModel.ByLineRef; updateArticle.Content = articleModel.Content; updateArticle.Summary = articleModel.Summary; //db.ArticleTags.RemoveRange(db.ArticleTags.Where(t => t.articleId.ToString() == editArticle.Id)); ////article.ArticleTags = null; //foreach (DbArticleTagModel tagModel in editArticle.Tags) //{ // article.ArticleTags.Add(new ArticleTag() { articleId = article.Id, Id = tagModel.Id, TagName = tagModel.TagName }); //} db.SaveChanges(); success = "ok"; } } catch (Exception ex) { success = Helpers.ErrorDetails(ex); } return(success); }
public SuccessModel AddImage(ImageData data) { var successModel = new SuccessModel(); try { // data:image/jpeg;base64, string imageFullFileName = Path.Combine(imagesPath, data.FileName); string trimData = data.Data.ToString().Substring(23); byte[] byteArray = Convert.FromBase64String(trimData); //Byte[] byteArray = data.Data.ReadAsByteArrayAsync().Result; File.WriteAllBytes(imageFullFileName, byteArray); // USE WEBREQUEST TO UPLOAD THE FILE FtpWebRequest webRequest = null; string destPath = ftpHost + articleImagesFolder; if (!FtpUtilies.DirectoryExists(destPath)) { FtpUtilies.CreateDirectory(destPath); } webRequest = (FtpWebRequest)WebRequest.Create(destPath + "/" + data.FileName); webRequest.Credentials = networkCredentials; webRequest.Method = WebRequestMethods.Ftp.UploadFile; using (Stream requestStream = webRequest.GetRequestStream()) { byte[] fileContents = System.IO.File.ReadAllBytes(imageFullFileName); webRequest.ContentLength = fileContents.Length; requestStream.Write(fileContents, 0, fileContents.Length); requestStream.Flush(); requestStream.Close(); } using (WebSiteContext db = new WebSiteContext()) { Article article = db.Articles.Where(a => a.Id == data.ArticleId).FirstOrDefault(); article.ImageName = data.FileName; db.SaveChanges(); successModel.ReturnValue = data.FileName; } successModel.Success = "ok"; } catch (Exception ex) { successModel.Success = Helpers.ErrorDetails(ex); } return(successModel); }
public string Put(RefItem refItem) { string success = ""; try { using (WebSiteContext db = new WebSiteContext()) { Ref @ref = db.Refs.Where(r => r.RefCode == refItem.RefCode).First(); @ref.RefDescription = refItem.RefDescription; db.SaveChanges(); success = "ok"; } } catch (Exception ex) { success = ex.Message; } return(success); }
public string Post(DbArticleTagModel tag) { var success = ""; try { var dbTag = new ArticleTag(); dbTag.TagName = tag.TagName; dbTag.articleId = tag.ArticleId; using (WebSiteContext db = new WebSiteContext()) { db.ArticleTags.Add(dbTag); db.SaveChanges(); success = "ok"; } } catch (Exception ex) { success = Helpers.ErrorDetails(ex); } return(success); }
public string AddNewArticle(VwArticle articleModel) { string success; try { Article newArticle = new Article { //Id = Guid.NewGuid().ToString(), Id = articleModel.Id, Title = articleModel.Title, CategoryRef = articleModel.CategoryRef, SubCategoryRef = articleModel.SubCategoryRef, ImageName = articleModel.ImageName, Created = DateTime.Now, LastUpdated = DateTime.Now, Content = articleModel.Content, Summary = articleModel.Summary, ByLineRef = articleModel.ByLineRef }; //foreach (DbArticleTagModel tag in articleModel.Tags) // if (tag.TagName != null) // newArticle.ArticleTags.Add(new ArticleTag() { TagName = tag.TagName, TagCategoryRef = tag.TagCategoryRef }); using (WebSiteContext db = new WebSiteContext()) { db.Articles.Add(newArticle); db.SaveChanges(); success = "ok"; } } catch (Exception ex) { success = Helpers.ErrorDetails(ex); } return(success); }