public ActionResult Create(t_kegiatan t_kegiatan)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_kegiatan.Create();
create.user_id = db.users.FirstOrDefault(u => u.username == User.Identity.Name).id_user;
create.wilayah_id = t_kegiatan.wilayah_id;
create.kegiatan_nama = t_kegiatan.kegiatan_nama;
create.kegiatan_deskripsi = t_kegiatan.kegiatan_deskripsi;
create.kegiatan_tgl_update = DateTime.Now;
create.kegiatan_tgl_acara = t_kegiatan.kegiatan_tgl_acara;
db.t_kegiatan.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.wilayah_id = new SelectList((from table in db.t_wilayah where table.wil_type == "Kecamatan" select table).ToList(), "wil_id", "wil_name");
return(View(t_kegiatan));
}
}
public ActionResult DeleteConfirmed(int id)
{
t_kegiatan t_kegiatan = db.t_kegiatan.Find(id);
db.t_kegiatan.Remove(t_kegiatan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id = 0)
{
t_kegiatan t_kegiatan = db.t_kegiatan.Find(id);
ViewBag.wilayah_id = new SelectList((from table in db.t_wilayah where table.wil_type == "Kecamatan" select table).ToList(), "wil_id", "wil_name");
if (t_kegiatan == null)
{
return(HttpNotFound());
}
return(View(t_kegiatan));
}
public ActionResult Details(int id = 0)
{
t_kegiatan t_kegiatan = db.t_kegiatan.Find(id);
var idUser = (from table in db.t_kegiatan where table.kegiatan_id == id select table.user_id).FirstOrDefault();
var idWil = (from table in db.t_kegiatan where table.kegiatan_id == id select table.wilayah_id).FirstOrDefault();
ViewBag.user = (from table in db.users where table.id_user == idUser select table.nama).FirstOrDefault();
ViewBag.wilayah = (from table in db.t_wilayah where table.wil_id == idWil select table.wil_name).FirstOrDefault();
if (t_kegiatan == null)
{
return(HttpNotFound());
}
return(View(t_kegiatan));
}
