public int Update(comic comic) { var a = WcDbContext.comics.Single(c => c.ComicId == comic.ComicId); a = comic; var i = WcDbContext.SaveChanges(); return(i); }
public Boolean ChangeStatusComic(int comicId, int statusId) { comic comic = WcDbContext.comics.Single(c => c.ComicId == comicId); comic.StatusComicId = statusId; var i = WcDbContext.SaveChanges(); return(i == 1); }
// GET public ActionResult Index(int comicId) { ComicDAO comicDao = new ComicDAO(); comic comic = comicDao.GetComicAs(comicId).Result; ViewBag.Title = comic.NameComic; ViewBag.Data = comic; return(View()); }
public async Task <int> RatingAs(Rating rating) { comic comic = await WcDbContext.comics.SingleAsync(c => c.ComicId == rating.ComicId); var numRating = comic.NumRating; comic.Rating = ((comic.Rating * numRating) + rating.Point) / numRating++; comic.NumRating = numRating++; var n = await WcDbContext.SaveChangesAsync(); return(n); }
public comic Add(comic comic, List <int> category) { var rs = WcDbContext.comics.Add(comic); int comicId = rs.ComicId; foreach (int categoryId in category) { var cc = WcDbContext.comic_category.Add(new comic_category(comicId, categoryId)); } var n = WcDbContext.SaveChanges(); return(rs); }
public ActionResult UpdateComic(String nameComic, String author, int[] category, int nation, HttpPostedFileBase file, String summary, int comicId) { if (CheckStatusUser()) { return(RedirectToAction("Login")); } if (!CheckViewer()) { ComicDAO comicDao = new ComicDAO(); comic comic = new comic(); comic.ComicId = comicId; comic.NameComic = nameComic; comic.AuthorComic = author; comic.NationId = nation; comic.SummaryComic = summary; comic.UserId = _user.UserId; var b = comicDao.Update(comic, category); ViewBag.Mss = -1; if (file != null) { String path = String.Format("~/Upload/Truyen/{0}", comicId); path = Server.MapPath(path); var messenger = UploadFile.Upload(file, path, "baner.jpg"); ViewBag.Mss = messenger.Code; } ViewBag.Comics = new ComicDAO().GetComic(comicId); ViewBag.Nations = new NationDAO().List(); ViewBag.Categories = new CategoryDAO().List(); // return RedirectToAction("UpdateComic", new {comicId = comicId}); return(View()); } return(RedirectToAction("Index")); }
public comic Update(comic comic, int[] categoryId) { var single = WcDbContext.comics.Single(c => c.ComicId == comic.ComicId && c.UserId == comic.UserId); single.NameComic = comic.NameComic; single.AuthorComic = comic.AuthorComic; single.SummaryComic = comic.SummaryComic; single.NationId = comic.NationId; var removeCategory = WcDbContext.comic_category.Where(cc => cc.ComicId == comic.ComicId); var a = WcDbContext.comic_category.RemoveRange(removeCategory); for (int j = 0; j < categoryId.Length; j++) { WcDbContext.comic_category.Add(new comic_category(comic.ComicId, categoryId[j])); } var i = WcDbContext.SaveChanges(); return(single); }
public Boolean DeleteComic() { if (CheckStatusUser()) { return(false); } if (!CheckViewer()) { comic comic = new comic(); comic.user = _user; comic.ComicId = Convert.ToInt32(Request["id"]); ComicDAO comicDao = new ComicDAO(); var n = comicDao.Delete(comic); return(n > 0); } return(false); }
public int Delete(comic cm) { var comic = new comic(); if (cm.user.RoleId == 1) { comic = WcDbContext.comics.Single(c => c.ComicId == cm.ComicId); } else { comic = WcDbContext.comics.Single(c => c.ComicId == cm.ComicId && c.UserId == cm.UserId && c.user.RoleId < 3); } WcDbContext.comics.Remove(comic); var chaoters = WcDbContext.chapters.Where(chapter => chapter.ComicId == cm.ComicId).ToList(); WcDbContext.chapters.RemoveRange(chaoters); var i = WcDbContext.SaveChanges(); return(i); }
public ActionResult UpComic(String nameComic, String author, int[] category, int nation, HttpPostedFileBase file, String summary) { if (_user != null) { user user = (user)Session["user"]; List <int> categorys = new List <int>(); if (category != null) { categorys = category.ToList(); } comic comic = new comic(); comic.NationId = nation; comic.UserId = _user.UserId; comic.NameComic = nameComic; comic.AuthorComic = author; comic.SummaryComic = summary; try { ComicDAO comicDao = new ComicDAO(); var add = comicDao.Add(comic, categorys); String path = String.Format("~/Upload/Truyen/{0}", add.ComicId); path = Server.MapPath(path); var a = UploadFile.Upload(file, path, "baner.jpg"); path = String.Format("/Upload/Truyen/{0}/baner.jpg", add.ComicId); comic.CommicBanner = path; var i = comicDao.Update(comic); if (i > 0) { ViewBag.Mss = 1; } else { ViewBag.Mss = 0; } CategoryDAO categoryDao = new CategoryDAO(); NationDAO nationDao = new NationDAO(); ViewBag.Nations = nationDao.List(); ViewBag.Categorys = categoryDao.List(); } catch { ViewBag.Mss = 0; } return(View()); } else { return(Redirect(Url.Action("Login", "User"))); } }
private comic getComic(int num) { comic cm; try { string url = "http://xkcd.com/" + num.ToString() + "/info.0.json"; HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url); WebResponse wb = req.GetResponse(); Stream str = wb.GetResponseStream(); StreamReader rdr = new StreamReader(str); string resstr = rdr.ReadToEnd(); rdr.Close(); JavaScriptSerializer sr = new JavaScriptSerializer(); cm = sr.Deserialize<comic>(resstr); } catch (Exception e) { cm = new comic(); cm.num = num; } return cm; }
private void timer1_Tick(object sender, EventArgs e) { if (com == null) { com = getComic(); } else { com = getComic(com.num-1); } if (com.img != null) { pictureBox1.Load(com.img); Bitmap bmp = new Bitmap(600, 800); Graphics.FromImage(bmp).Clear(Color.White); pictureBox1.DrawToBitmap(bmp, new Rectangle(0, 0, 600, 700)); addtext(ref bmp, com.safe_title + ": " + com.alt); pictureBox2.Image = bmp; bmp.Save(com.num + ".png", System.Drawing.Imaging.ImageFormat.Png); } }