public ActionResult Edit(int id, t_volunteer volunteer)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
t_volunteer t_volunteer = db.t_volunteer.Find(id);
t_volunteer.vol_card_id = volunteer.vol_card_id;
t_volunteer.vol_name = volunteer.vol_name;
t_volunteer.vol_phone = volunteer.vol_phone;
t_volunteer.vol_address = volunteer.vol_address;
t_volunteer.vol_occupation = volunteer.vol_occupation;
t_volunteer.vol_email = volunteer.vol_email;
t_volunteer.kegiatan_id = volunteer.kegiatan_id;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.kegiatan = new SelectList((from table in db.t_kegiatan select table).ToList(), "kegiatan_id", "kegiatan_nama");
return(View(volunteer));
}
}
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 Create(t_volunteer t_volunteer)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_volunteer.Create();
create.vol_card_id = t_volunteer.vol_card_id;
create.vol_name = t_volunteer.vol_name;
create.vol_phone = t_volunteer.vol_phone;
create.vol_address = t_volunteer.vol_address;
create.vol_occupation = t_volunteer.vol_occupation;
create.vol_email = t_volunteer.vol_email;
create.kegiatan_id = t_volunteer.kegiatan_id;
db.t_volunteer.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.kegiatan = new SelectList((from table in db.t_kegiatan select table).ToList(), "kegiatan_id", "kegiatan_nama");
return(View(t_volunteer));
}
}
public ActionResult Create(t_wilayah t_wilayah)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_wilayah.Create();
create.geo_location = t_wilayah.geo_location;
create.parent_id = 0;
create.web_url = t_wilayah.web_url;
create.wil_address = t_wilayah.wil_address;
create.wil_name = t_wilayah.wil_name;
create.wil_phone = t_wilayah.wil_phone;
create.wil_type = "Kecamatan";
create.wil_email = t_wilayah.wil_email;
db.t_wilayah.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(t_wilayah));
}
public ActionResult Create(t_wilayah t_wilayah)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_wilayah.Create();
create.geo_location = t_wilayah.geo_location;
create.parent_id = t_wilayah.parent_id;
create.web_url = t_wilayah.web_url;
create.wil_address = t_wilayah.wil_address;
create.wil_name = t_wilayah.wil_name;
create.wil_phone = t_wilayah.wil_phone;
create.wil_type = "Kelurahan";
create.wil_email = t_wilayah.wil_email;
db.t_wilayah.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.parent_id = new SelectList((from table in db.t_wilayah where table.wil_type == "Kecamatan" select table).ToList(), "wil_id", "wil_name");
return(View(t_wilayah));
}
}
public ActionResult Create(t_kesejahteraan t_kesejahteraan)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_kesejahteraan.Create();
create.ks_name = t_kesejahteraan.ks_name;
create.ks_jumlah = t_kesejahteraan.ks_jumlah;
create.ks_type = "PSKS";
create.ks_satuan = t_kesejahteraan.ks_satuan;
create.ks_date = DateTime.Now;
create.ks_year = t_kesejahteraan.ks_year;
db.t_kesejahteraan.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.satuan = new SelectList(db.t_satuan.ToList(), "id_satuan", "satuan");
return(View(t_kesejahteraan));
}
}
public ActionResult Create(admin.Models.FotoCreate t_dokumentasi)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_dokumentasi.Create();
create.album_id = t_dokumentasi.album_id;
create.dokumentasi_date = DateTime.Now;
create.dokumentasi_title = t_dokumentasi.dokumentasi_title;
create.dokumentasi_type = "video";
if (t_dokumentasi.dokumentasi_path != null)
{
if (t_dokumentasi.dokumentasi_path.ContentLength < 102400000)
{
var fileName = Path.GetFileName(t_dokumentasi.dokumentasi_path.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".mp4")
{
var path = Path.Combine(Server.MapPath("~/Content/Video"), fileName);
t_dokumentasi.dokumentasi_path.SaveAs(path);
create.dokumentasi_path = "~/Content/Video/" + fileName;
}
else
{
ModelState.AddModelError("", "Video harus berformat (MP4)");
ViewBag.album_id = new SelectList(db.t_album.ToList(), "album_id", "album_title");
return(View(t_dokumentasi));
}
}
else
{
ModelState.AddModelError("", "Ukuran video tidak boleh lebih dari 100 MB");
ViewBag.album_id = new SelectList(db.t_album.ToList(), "album_id", "album_title");
return(View(t_dokumentasi));
}
}
else
{
ModelState.AddModelError("", "Video harus diisi");
ViewBag.album_id = new SelectList(db.t_album.ToList(), "album_id", "album_title");
return(View(t_dokumentasi));
}
db.t_dokumentasi.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.album_id = new SelectList(db.t_album.ToList(), "album_id", "album_title");
return(View(t_dokumentasi));
}
}
public ActionResult EditFoto(int id, admin.Models.FotoAdmin fotoAdmin)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var ada = (from table in db.t_file where table.user_id == id && table.file_category == "FotoUser" select table.file_id).FirstOrDefault();
ViewBag.file = ada;
if (fotoAdmin.foto != null)
{
if (fotoAdmin.foto.ContentLength < 2048000)
{
var fileName = Path.GetFileName(fotoAdmin.foto.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
fotoAdmin.foto.SaveAs(path);
var createFile = db.t_file.Create();
createFile.file_category = "FotoUser";
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();
db.t_file.Add(createFile);
db.SaveChanges();
if (ViewBag.file != 0)
{
var hapusFoto = db.t_file.Find(ada);
db.t_file.Remove(hapusFoto);
db.SaveChanges();
}
return(RedirectToAction("Details"));
}
else
{
ModelState.AddModelError("", "Foto harus berformat (.jpg)");
return(View(fotoAdmin));
}
}
else
{
ModelState.AddModelError("", "Ukuran foto tidak boleh lebih dari 2 MB");
return(View(fotoAdmin));
}
}
}
}
return(View(fotoAdmin));
}
public ActionResult Create(admin.Models.DownloadCreate t_download)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_download.Create();
create.download_date = DateTime.Now;
create.download_desc = t_download.download_desc;
create.download_title = t_download.download_title;
create.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault();
if (t_download.dokumen != null)
{
if (t_download.dokumen.ContentLength < 3048000)
{
var fileName = Path.GetFileName(t_download.dokumen.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".pdf" || ex == ".xls" || ex == ".xlsx" || ex == ".doc" || ex == ".docx" || ex == ".ppt" || ex == ".pptx")
{
var path = Path.Combine(Server.MapPath("~/Content/Document"), fileName);
t_download.dokumen.SaveAs(path);
create.download_path = "~/Content/Document/" + fileName;
}
else
{
ModelState.AddModelError("", "File harus berformat (.pdf/.ppt/.pptx/.xls/.xlsx/.doc/.docx)");
return(View(t_download));
}
}
else
{
ModelState.AddModelError("", "Ukuran file tidak boleh lebih dari 3 MB");
return(View(t_download));
}
}
else
{
ModelState.AddModelError("", "File harus diisi");
return(View(t_download));
}
db.t_download.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(t_download));
}
public ActionResult Edit(int id, admin.Models.FotoCreate dokumentasi)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
t_dokumentasi t_dokumentasi = db.t_dokumentasi.Find(id);
t_dokumentasi.album_id = dokumentasi.album_id;
t_dokumentasi.dokumentasi_date = DateTime.Now;
t_dokumentasi.dokumentasi_title = dokumentasi.dokumentasi_title;
if (dokumentasi.dokumentasi_path != null)
{
if (dokumentasi.dokumentasi_path.ContentLength < 2048000)
{
var fileName = Path.GetFileName(dokumentasi.dokumentasi_path.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
dokumentasi.dokumentasi_path.SaveAs(path);
t_dokumentasi.dokumentasi_path = "~/Content/Image/" + fileName;
}
else
{
ModelState.AddModelError("", "Foto harus berformat (Jpg)");
ViewBag.album_id = new SelectList(db.t_album.ToList(), "album_id", "album_title");
return(View(dokumentasi));
}
}
else
{
ModelState.AddModelError("", "Ukuran foto tidak boleh lebih dari 2 MB");
ViewBag.album_id = new SelectList(db.t_album.ToList(), "album_id", "album_title");
return(View(dokumentasi));
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.album_id = new SelectList(db.t_album.ToList(), "album_id", "album_title");
return(View(dokumentasi));
}
}
public ActionResult Create(admin.Models.organisasiCreate t_organisasi)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_organisasi.Create();
create.t_nama = t_organisasi.t_nama;
create.t_jabatan = t_organisasi.t_jabatan;
if (t_organisasi.t_path != null)
{
if (t_organisasi.t_path.ContentLength < 2048000)
{
var fileName = Path.GetFileName(t_organisasi.t_path.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
t_organisasi.t_path.SaveAs(path);
create.t_path = "~/Content/Image/" + fileName;
}
else
{
ModelState.AddModelError("", "Foto harus berformat (.jpg)");
return(View(t_organisasi));
}
}
else
{
ModelState.AddModelError("", "Ukuran foto tidak boleh lebih dari 2 MB");
return(View(t_organisasi));
}
}
else
{
ModelState.AddModelError("", "Foto harus diisi");
return(View(t_organisasi));
}
db.t_organisasi.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(t_organisasi));
}
private bool isValid(string username, string password)
{
var crypto = new SimpleCrypto.PBKDF2();
bool isValid = false;
using (var db = new db_esosEntities())
{
var user = db.users.FirstOrDefault(u => u.username == username);
if (user != null)
{
if (user.user_password == crypto.Compute(password, user.user_passwordsalt))
{
isValid = true;
}
}
}
return(isValid);
}
public override string[] GetRolesForUser(string username)
{
using (db_esosEntities db = new db_esosEntities())
{
var user = db.users.FirstOrDefault(u => u.username == username);
if (user == null)
{
return(null);
}
else
{
var id_user = (from table in db.users where table.username == username select table.id_user).FirstOrDefault();
var userRolesID = (from table in db.detail_roles where table.id_user == id_user select table.id_roles).FirstOrDefault();
var userRoles = (from table in db.roles where table.id_roles == userRolesID select table.roles).FirstOrDefault();
return(new[] { userRoles });
}
}
}
public ActionResult Create(t_satuan t_satuan)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_satuan.Create();
create.satuan = t_satuan.satuan;
create.tanggal = DateTime.Now;
db.t_satuan.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(t_satuan));
}
public ActionResult Edit(int id, t_album t_album)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
t_album album = db.t_album.Find(id);
album.album_title = t_album.album_title;
album.album_date = DateTime.Now;
album.album_desc = t_album.album_desc;
album.user_id = db.users.FirstOrDefault(u => u.username == User.Identity.Name).id_user;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(t_album));
}
public ActionResult Create(t_news_category t_news_category)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_news_category.Create();
create.category_date = DateTime.Now;
create.category_title = t_news_category.category_title;
create.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault();
db.t_news_category.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(t_news_category));
}
public ActionResult Create(t_album t_album)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_album.Create();
create.album_title = t_album.album_title;
create.album_date = DateTime.Now;
create.album_desc = t_album.album_desc;
create.user_id = db.users.FirstOrDefault(u => u.username == User.Identity.Name).id_user;
db.t_album.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(t_album));
}
public ActionResult Edit(int id, t_csr_ph t_csr_ph)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var csr = db.t_csr_ph.Find(id);
csr.csr_ph_name = t_csr_ph.csr_ph_name;
csr.csr_ph_address = t_csr_ph.csr_ph_address;
csr.csr_ph_activity = t_csr_ph.csr_ph_activity;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
return(View(t_csr_ph));
}
}
public ActionResult Create(t_csr_ph t_csr_ph)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_csr_ph.Create();
create.csr_ph_name = t_csr_ph.csr_ph_name;
create.csr_ph_address = t_csr_ph.csr_ph_address;
create.csr_ph_activity = t_csr_ph.csr_ph_activity;
create.csr_ph_date = DateTime.Now;
db.t_csr_ph.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
return(View(t_csr_ph));
}
}
public ActionResult Create(Models.CSRactCreate t_csr_activity)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_csr_activity.Create();
create.csr_ph_id = t_csr_activity.csr_ph_id;
create.csr_activity_date = DateTime.Now;
create.csr_activity_content = t_csr_activity.csr_activity_content;
create.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault();
if (t_csr_activity.gambar != null)
{
if (t_csr_activity.gambar.ContentLength < 2048000)
{
var fileName = Path.GetFileName(t_csr_activity.gambar.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
t_csr_activity.gambar.SaveAs(path);
create.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(t_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(t_csr_activity));
}
}
else
{
ModelState.AddModelError("", "Gambar harus diisi");
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(t_csr_activity));
}
db.t_csr_activity.Add(create);
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(t_csr_activity));
}
}
public ActionResult Create(admin.Models.ContentCreate t_content)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var valid = 0;
var valid2 = 0;
var create = db.t_content.Create();
var createFile = db.t_file.Create();
var createGambar = db.t_file.Create();
create.content_name = t_content.content_name;
create.content_type = "Prosedur";
create.content = t_content.content;
create.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault();
create.content_time = DateTime.Now;
create.url = "kosong";
if (t_content.file != null)
{
if (t_content.file.ContentLength < 3048000)
{
var fileName = Path.GetFileName(t_content.file.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".pdf" || ex == ".ppt" || ex == ".pptx" || ex == ".xls" || ex == ".xlsx" || ex == ".doc" || ex == ".docx")
{
var path = Path.Combine(Server.MapPath("~/Content/Document"), fileName);
t_content.file.SaveAs(path);
createFile.file_category = "ProsedurFile";
createFile.file_location = path;
createFile.file_name = fileName;
createFile.file_title = fileName;
createFile.file_url = "~/Content/Document/" + 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("", "File harus berformat (.pdf/.ppt/.pptx/.xls/.xlsx/.doc/.docx)");
return(View(t_content));
}
}
else
{
ModelState.AddModelError("", "Ukuran file tidak boleh lebih dari 3 MB");
return(View(t_content));
}
}
if (t_content.gambar != null)
{
if (t_content.gambar.ContentLength < 2048000)
{
var fileName = Path.GetFileName(t_content.gambar.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
t_content.gambar.SaveAs(path);
createGambar.file_category = "ProsedurGambar";
createGambar.file_location = path;
createGambar.file_name = fileName;
createGambar.file_title = fileName;
createGambar.file_url = "~/Content/Image/" + fileName;
createGambar.mime_type = ex;
createGambar.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault();
valid2 = 1;
}
else
{
ModelState.AddModelError("", "Gambar harus berformat (.jpg)");
return(View(t_content));
}
}
else
{
ModelState.AddModelError("", "Ukuran gambar tidak boleh lebih dari 2 MB");
return(View(t_content));
}
}
db.t_content.Add(create);
db.SaveChanges();
if (valid == 1)
{
createFile.file_parent = ((int)(from table in db.t_content select table.content_id).Max());
db.t_file.Add(createFile);
db.SaveChanges();
}
if (valid2 == 1)
{
createGambar.file_parent = ((int)(from table in db.t_content select table.content_id).Max());
db.t_file.Add(createGambar);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
return(View(t_content));
}
public ActionResult Edit(int id, admin.Models.BidangCreate bidang)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
t_bidang t_bidang = db.t_bidang.Find(id);
t_bidang.bidang_date = DateTime.Now;
t_bidang.bidang_desc = bidang.bidang_desc;
t_bidang.bidang_name = bidang.bidang_name;
t_bidang.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault();
t_bidang.bidang_title = bidang.bidang_title;
if (bidang.gambar_pj != null)
{
if (bidang.gambar_pj.ContentLength < 2048000)
{
var fileName = Path.GetFileName(bidang.gambar_pj.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
bidang.gambar_pj.SaveAs(path);
t_bidang.bidang_person_foto = "~/Content/Image/" + fileName;
}
else
{
ModelState.AddModelError("", "Foto harus berformat (.jpg)");
return(View(bidang));
}
}
else
{
ModelState.AddModelError("", "Ukuran gambar tidak boleh lebih dari 2 MB");
return(View(t_bidang));
}
}
if (bidang.gambar_des != null)
{
if (bidang.gambar_des.ContentLength < 2048000)
{
var fileName = Path.GetFileName(bidang.gambar_des.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
bidang.gambar_des.SaveAs(path);
t_bidang.bidang_desc_foto = "~/Content/Image/" + fileName;
}
else
{
ModelState.AddModelError("", "Gambar harus berformat (.jpg)");
return(View(bidang));
}
}
else
{
ModelState.AddModelError("", "Ukuran gambar tidak boleh lebih dari 2 MB");
return(View(bidang));
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(bidang));
}
public ActionResult Create(admin.Models.BencanaCreate t_report)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var valid = 0;
var create = db.t_report.Create();
var createFile = db.t_file.Create();
create.report_author = t_report.report_author;
create.phone = t_report.phone;
create.address = t_report.address;
create.wil_id = t_report.wil_id;
create.report_content = t_report.report_content;
create.report_time = DateTime.Now;
if (t_report.gambar != null)
{
if (t_report.gambar.ContentLength < 2048000)
{
var fileName = Path.GetFileName(t_report.gambar.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
t_report.gambar.SaveAs(path);
createFile.file_category = "Bencana";
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.wilayah = new SelectList((from table in db.t_wilayah where table.wil_type == "Kelurahan" select table).ToList(), "wil_id", "wil_name");
return(View(t_report));
}
}
else
{
ModelState.AddModelError("", "Ukuran gambar tidak boleh lebih dari 2 MB");
ViewBag.wilayah = new SelectList((from table in db.t_wilayah where table.wil_type == "Kelurahan" select table).ToList(), "wil_id", "wil_name");
return(View(t_report));
}
}
db.t_report.Add(create);
db.SaveChanges();
if (valid == 1)
{
createFile.file_parent = (int)(from table in db.t_report select table.report_id).Max();
db.t_file.Add(createFile);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.wilayah = new SelectList((from table in db.t_wilayah where table.wil_type == "Kelurahan" select table).ToList(), "wil_id", "wil_name");
return(View(t_report));
}
}
public ActionResult Edit(int id, admin.Models.ContentCreate t_content)
{
if (ModelState.IsValid)
{
var id_file = (from table in db.t_file where table.file_parent == id && table.file_category == "Profil" select table.file_id).FirstOrDefault();
t_file tfile = db.t_file.Find(id_file);
t_content content = db.t_content.Find(id);
using (var konten = new db_esosEntities())
{
content.content_name = t_content.content_name;
content.content_type = "Profil";
content.content = t_content.content;
content.user_id = (from table in konten.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault();
content.content_time = DateTime.Now;
content.url = "kosong";
if (t_content.file != null)
{
if (t_content.file.ContentLength < 2048000)
{
var fileName = Path.GetFileName(t_content.file.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
t_content.file.SaveAs(path);
var createFile = db.t_file.Create();
createFile.file_category = "Profil";
createFile.file_location = path;
createFile.file_name = fileName;
createFile.file_parent = id;
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();
db.t_file.Add(createFile);
db.SaveChanges();
if (tfile != null)
{
db.t_file.Remove(tfile);
db.SaveChanges();
}
}
else
{
ModelState.AddModelError("", "Gambar harus berformat (.jpg)");
return(View(t_content));
}
}
else
{
ModelState.AddModelError("", "Ukuran gambar tidak boleh lebih dari 2 MB");
return(View(t_content));
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(t_content));
}
public ActionResult Create(admin.Models.SeksiCreate t_seksi)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var create = db.t_seksi.Create();
create.seksi_date = DateTime.Now;
create.seksi_description = t_seksi.seksi_description;
create.seksi_name = t_seksi.seksi_name;
create.user_id = (from table in db.users where table.username == User.Identity.Name select table.id_user).FirstOrDefault();
create.seksi_title = t_seksi.seksi_title;
create.bidang_id = t_seksi.bidang_id;
if (t_seksi.seksi_foto != null)
{
if (t_seksi.seksi_foto.ContentLength < 2048000)
{
var fileName = Path.GetFileName(t_seksi.seksi_foto.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
t_seksi.seksi_foto.SaveAs(path);
create.seksi_foto = "~/Content/Image/" + fileName;
}
else
{
ModelState.AddModelError("", "Foto harus berformat (.jpg)");
ViewBag.bidang_id = new SelectList(db.t_bidang.ToList(), "bidang_id", "bidang_title");
return(View(t_seksi));
}
}
else
{
ModelState.AddModelError("", "Ukuran foto tidak boleh lebih dari 2 MB");
ViewBag.bidang_id = new SelectList(db.t_bidang.ToList(), "bidang_id", "bidang_title");
return(View(t_seksi));
}
}
else
{
ModelState.AddModelError("", "Foto harus diisi");
ViewBag.bidang_id = new SelectList(db.t_bidang.ToList(), "bidang_id", "bidang_title");
return(View(t_seksi));
}
if (t_seksi.seksi_desc_foto != null)
{
if (t_seksi.seksi_desc_foto.ContentLength < 2048000)
{
var fileName = Path.GetFileName(t_seksi.seksi_desc_foto.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
t_seksi.seksi_desc_foto.SaveAs(path);
create.seksi_desc_foto = "~/Content/Image/" + fileName;
}
else
{
ModelState.AddModelError("", "Gambar harus berformat (.jpg)");
ViewBag.bidang_id = new SelectList(db.t_bidang.ToList(), "bidang_id", "bidang_title");
return(View(t_seksi));
}
}
else
{
ModelState.AddModelError("", "Ukuran gambar tidak boleh lebih dari 2 MB");
ViewBag.bidang_id = new SelectList(db.t_bidang.ToList(), "bidang_id", "bidang_title");
return(View(t_seksi));
}
}
else
{
ViewBag.bidang_id = new SelectList(db.t_bidang.ToList(), "bidang_id", "bidang_title");
create.seksi_desc_foto = "Kosong";
}
db.t_seksi.Add(create);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.bidang_id = new SelectList(db.t_bidang.ToList(), "bidang_id", "bidang_title");
return(View(t_seksi));
}
}
public ActionResult Create(admin.Models.BeritaCreate t_news)
{
if (ModelState.IsValid)
{
using (var db = new db_esosEntities())
{
var valid = 0;
var create = db.t_news.Create();
var createFile = db.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 = DateTime.Now;
create.news_title = t_news.news_title;
create.news_content = t_news.news_content;
create.news_status = t_news.news_status;
create.news_modified = DateTime.Now;
create.news_parent = 0;
create.news_type = t_news.news_type;
create.news_url = "Kosong";
create.news_category = t_news.news_category;
if (t_news.gambar != null)
{
if (t_news.gambar.ContentLength < 2048000)
{
var fileName = Path.GetFileName(t_news.gambar.FileName);
var ex = Path.GetExtension(fileName);
if (ex == ".jpg")
{
var path = Path.Combine(Server.MapPath("~/Content/Image"), fileName);
t_news.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));
}
}
db.t_news.Add(create);
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();
}
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.news_category = new SelectList(db.t_news_category.ToList(), "news_category_id", "category_title");
return(View(t_news));
}
}
