public IActionResult Createhighlight(int id) { SucceedInfomation succeedinfomation = new SucceedInfomation(); // find postocntent first if found then Add it to the highlight table postcontent postcontentValue = _Context.postcontents.FirstOrDefault(x => x.postid == id); if (postcontentValue == null) { succeedinfomation.Issucceed = false; return(Ok(succeedinfomation)); } var checkhg = _Context.highlights.FirstOrDefault(x => x.postcontentid == postcontentValue.postcontentid); if (checkhg != null) { succeedinfomation.Issucceed = false; succeedinfomation.SucceedDetail = "duplicated content"; return(Ok(succeedinfomation)); } var Newhighlight = new highlight(); Newhighlight.postcontentid = postcontentValue.postcontentid; _Context.highlights.Add(Newhighlight); _Context.SaveChanges(); succeedinfomation.Issucceed = true; return(Ok(succeedinfomation)); }
public ActionResult Editpostcontent([FromForm] Updatepayload updatepayload) { SucceedInfomation succeedinfomation = new SucceedInfomation(); //find postcontent metadata and use this metada to obtain post id and content id postcontent postcontentvalue = _Context.postcontents.FirstOrDefault(x => x.postid == updatepayload.postid); // find post id post postvalue = _Context.posts.FirstOrDefault(x => x.postid == postcontentvalue.postid); // insert new imgurl if imgfile payload not null if (updatepayload.imgfile != null) { // remove old file but that come later if (updatepayload.imgfile.FileName.EndsWith(".jpg")) { postvalue.titleimgurl = _imgservice.SaveAsJPG(updatepayload.imgfile); } else if (updatepayload.imgfile.FileName.EndsWith(".png")) { postvalue.titleimgurl = _imgservice.SaveAsPng(updatepayload.imgfile); } } // insert new value of postitle postvalue.posttitle = updatepayload.posttitle; // find content id content contentvalue = _Context.contents.FirstOrDefault(x => x.contentid == postcontentvalue.contentid); // insert new value of content contentvalue.contentdetail = updatepayload.contentdetail; // the Update operation start here // _Context.posts.Update(postvalue); _Context.contents.Update(contentvalue); _Context.SaveChanges(); return(Ok(succeedinfomation)); }
public async Task <ActionResult <SucceedInfomation> > createpostcontent([FromForm] PostPayload postpayload) { SucceedInfomation succeedinformation = new SucceedInfomation(); post Newpost = new post() { posttitle = postpayload.posttitle }; if (postpayload.imgfile == null || postpayload.posttitle.Length < 3) { succeedinformation.Issucceed = false; succeedinformation.SucceedDetail = "Please complete the form"; return(Ok(succeedinformation)); } if (postpayload.imgfile.FileName.EndsWith(".jpg")) { Newpost.titleimgurl = await _imgservice.SaveFileJpg(postpayload.imgfile); } else if (postpayload.imgfile.FileName.EndsWith(".png")) { Newpost.titleimgurl = await _imgservice.SaveFilePng(postpayload.imgfile); } // else if(postpayload.imgfile.Length == 0) // { // succeedinformation.Issucceed = false; // succeedinformation.SucceedDetail = "file format invalide , pls use jpg or png"; // return Ok(succeedinformation); // } content Newcontent = new content() { contentdetail = postpayload.contentdetail }; _Context.posts.Add(Newpost); _Context.contents.Add(Newcontent); _Context.SaveChanges(); var Newposcontent = new postcontent() { postid = Newpost.postid, contentid = Newcontent.contentid, userid = postpayload.userid, categoryid = postpayload.categoryid, postcontentcreated = DateTime.UtcNow }; _Context.postcontents.Add(Newposcontent); _Context.SaveChanges(); return(succeedinformation); }
public IActionResult deleteHighlight(int id) { SucceedInfomation succeedinfomation = new SucceedInfomation(); // find postocntent first if found then Add it to the highlight table postcontent postcontentValue = _Context.postcontents.FirstOrDefault(x => x.postid == id); var highlightValue = _Context.highlights.FirstOrDefault(x => x.postcontentid == postcontentValue.postcontentid); if (highlightValue == null) { succeedinfomation.Issucceed = false; return(Ok(succeedinfomation)); } var Newhighlight = new highlight(); _Context.highlights.Remove(highlightValue); _Context.SaveChanges(); succeedinfomation.Issucceed = true; return(Ok(succeedinfomation)); }
public async Task <ActionResult <SucceedInfomation> > post(int id) { SucceedInfomation succeedinformation = new SucceedInfomation(); postcontent postcontenvalue = await _Context.postcontents.FirstOrDefaultAsync(x => x.postid == id); post postvalue = new post() { postid = postcontenvalue.postid }; content contentvalue = new content() { contentid = postcontenvalue.contentid }; _Context.posts.Remove(postvalue); _Context.contents.Remove(contentvalue); var result = await _Context.SaveChangesAsync(); succeedinformation.SucceedDetail = result.ToString(); return(Ok(succeedinformation)); }