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