public ActionResult News_Edit(t_news model) { string sql = string.Format("update t_news t set t.xzqhcode='{0}',t.typeid='{1}',t.title='{2}',t.content='{3}' where t.id={4}", model.xzqhcode, model.typeid, model.title, model.content, model.id); int count = DbHelperMySQL.ExecuteSql(sql); return(Json(Result.AutoResult(count), JsonRequestBehavior.AllowGet)); }
public ActionResult News_Add(t_news model) { string sql = string.Format("insert into t_news(xzqhcode,typeid,adminid,title,time,content,scan,state,del) values('{0}','{1}','{2}','{3}',now(),'{4}',0,0,0)", model.xzqhcode, model.typeid, Common.getAdmin().id, model.title, model.content); int count = DbHelperMySQL.ExecuteSql(sql); return(Json(Result.AutoResult(count), JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteConfirmed(int id) { t_news t_news = db.t_news.Find(id); db.t_news.Remove(t_news); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(int id = 0) { t_news t_news = db.t_news.Find(id); ViewBag.news_category = new SelectList(db.t_news_category.ToList(), "news_category_id", "category_title"); if (t_news == null) { return(HttpNotFound()); } return(View(t_news)); }
public ActionResult Details(int id = 0) { t_news t_news = db.t_news.Find(id); var iduser = (from table in db.t_news where table.news_id == id select table.user_id).FirstOrDefault(); var user = (from table in db.users where table.id_user == iduser select table.nama).FirstOrDefault(); ViewBag.userNama = user; var idkategori = (from table in db.t_news where table.news_id == id select table.news_category).FirstOrDefault(); var kategori = (from table in db.t_news_category where table.news_category_id == idkategori select table.category_title).FirstOrDefault(); var gambar = (from table in db.t_file where table.file_parent == id && table.file_category == "Berita" select table.file_url).FirstOrDefault(); ViewBag.namaKategori = kategori; ViewBag.gambar = gambar; if (t_news == null) { return(HttpNotFound()); } return(View(t_news)); }
public ActionResult News_Check(int id, int state) { string sql = string.Format("update t_news t set t.state={0} where t.id={1}", state, id); int count = DbHelperMySQL.ExecuteSql(sql); try { if (state == 1) { sql = string.Format("select * from t_news t where t.id={0}", id); DataTable dt = DbHelperMySQL.Query(sql).Tables[0]; t_news news = dt.ConvertToModel <t_news>().FirstOrDefault(); Common.Count_Admin_News_Add(); Common.Send_News_Add_Message(news.xzqhcode); } } catch (Exception e) { } return(Json(Result.AutoResult(count), JsonRequestBehavior.AllowGet)); }
public ActionResult EditConfirmed(int id, admin.Models.BeritaCreate model) { t_news t_news = db.t_news.Find(id); var file = (from table in db.t_file where table.file_parent == id select table.file_id).FirstOrDefault(); t_file t_file = db.t_file.Find(file); if (ModelState.IsValid) { using (var news = new db_esosEntities()) { var valid = 0; var create = news.t_news.Create(); var createFile = news.t_file.Create(); create.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault(); create.news_date = (from table in db.t_news where table.news_id == t_news.news_id select table.news_date).FirstOrDefault(); create.news_title = model.news_title; create.news_content = model.news_content; create.news_status = model.news_status; create.news_modified = DateTime.Now; create.news_parent = t_news.news_id; create.news_type = model.news_type; create.news_url = "Kosong"; create.news_category = model.news_category; if (model.gambar != null) { if (model.gambar.ContentLength < 2048000) { var fileName = Path.GetFileName(model.gambar.FileName); var ex = Path.GetExtension(fileName); if (ex == ".jpg") { var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName); model.gambar.SaveAs(path); createFile.file_category = "Berita"; createFile.file_location = path; createFile.file_name = fileName; createFile.file_title = fileName; createFile.file_url = "~/Content/Image/" + fileName; createFile.mime_type = ex; createFile.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault(); valid = 1; } else { ModelState.AddModelError("", "Gambar harus berformat (.jpg)"); ViewBag.news_category = new SelectList(db.t_news_category.ToList(), "news_category_id", "category_title"); return(View(t_news)); } } else { ModelState.AddModelError("", "Ukuran gambar tidak boleh lebih dari 2 MB"); ViewBag.news_category = new SelectList(db.t_news_category.ToList(), "news_category_id", "category_title"); return(View(t_news)); } } else { if (file != 0) { valid = 2; } } db.t_news.Add(create); db.SaveChanges(); t_news.news_status = "tidak_aktif"; db.SaveChanges(); if (valid == 1) { createFile.file_parent = (from table in db.t_news select table.news_id).Max(); db.t_file.Add(createFile); db.SaveChanges(); } else if (valid == 2) { t_file.file_parent = (from table in db.t_news select table.news_id).Max(); db.SaveChanges(); } return(RedirectToAction("Index")); } } else { ViewBag.news_category = new SelectList(db.t_news_category.ToList(), "news_category_id", "category_title"); return(View(t_news)); } }