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));
}
}
