public ActionResult DeleteConfirmed(int id)
{
t_csr_activity t_csr_activity = db.t_csr_activity.Find(id);
db.t_csr_activity.Remove(t_csr_activity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Details(int id = 0)
{
t_csr_activity t_csr_activity = db.t_csr_activity.Find(id);
var idAct = (from table in db.t_csr_activity where table.csr_activity_id == id select table).FirstOrDefault();
ViewBag.user = (from table in db.users where table.id_user == idAct.user_id select table.nama).FirstOrDefault();
var csr = (from table in db.t_csr_ph where table.csr_ph_id == idAct.csr_ph_id select table).FirstOrDefault();
ViewBag.act_name = csr.csr_ph_activity;
ViewBag.csr_ph = csr.csr_ph_name;
if (t_csr_activity == null)
{
return(HttpNotFound());
}
return(View(t_csr_activity));
}
public ActionResult Edit(int id, Models.CSRactCreate csr_activity)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
t_csr_activity t_csr_activity = db.t_csr_activity.Find(id);
t_csr_activity.csr_ph_id = csr_activity.csr_ph_id;
t_csr_activity.csr_activity_date = DateTime.Now;
t_csr_activity.csr_activity_content = csr_activity.csr_activity_content;
t_csr_activity.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault();
if (csr_activity.gambar != null)
{
if (csr_activity.gambar.ContentLength < 2048000)
{
var fileName = Path.GetFileName(csr_activity.gambar.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
csr_activity.gambar.SaveAs(path);
t_csr_activity.csr_activity_path = "~/Content/Image/" + fileName;
}
else
{
ModelState.AddModelError("", "Gambar harus berformat (.jpg)");
var list = (from table in db.t_csr_ph
select new
{
ph_id = table.csr_ph_id,
keg = table.csr_ph_name + " (" + table.csr_ph_activity + ")"
}).ToList();
ViewBag.csr_ph = new SelectList(list, "ph_id", "keg");
return(View(csr_activity));
}
}
else
{
ModelState.AddModelError("", "Ukuran gambar tidak boleh lebih dari 2 MB");
var list = (from table in db.t_csr_ph
select new
{
ph_id = table.csr_ph_id,
keg = table.csr_ph_name + " (" + table.csr_ph_activity + ")"
}).ToList();
ViewBag.csr_ph = new SelectList(list, "ph_id", "keg");
return(View(csr_activity));
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
var list = (from table in db.t_csr_ph
select new
{
ph_id = table.csr_ph_id,
keg = table.csr_ph_name + " (" + table.csr_ph_activity + ")"
}).ToList();
ViewBag.csr_ph = new SelectList(list, "ph_id", "keg");
return(View(csr_activity));
}
}
