public static bool Delete(DosenViewModel model) { bool result = true; try { using (var db = new DB_UniversityEntities()) { tbl_m_dosen attributs = db.tbl_m_dosen.Where(o => o.id_dosen_pk == model.id_dosen_pk).FirstOrDefault(); if (attributs != null) { attributs.is_active = model.is_active; attributs.updated_by = model.updated_by; attributs.updated_date = model.updated_date; db.SaveChanges(); } else { result = false; Message = "Categories not found!"; } } } catch (Exception hasError) { Message = hasError.Message; result = false; } return(result); }
public static DosenViewModel GetDetailsByid(int id) { DosenViewModel result = new DosenViewModel(); using (var db = new DB_UniversityEntities()) { result = (from attributs in db.tbl_m_dosen join b in db.tbl_m_jurusan on attributs.id_jurusan_fk equals b.id_jurusan_pk join c in db.tbl_m_type_dosen on attributs.id_type_dosen_fk equals c.id_type_dosen_pk where attributs.id_dosen_pk == id select new DosenViewModel { id_dosen_pk = attributs.id_dosen_pk, kode_dosen = attributs.kode_dosen, nama_dosen = attributs.nama_dosen, id_jurusan_fk = attributs.id_jurusan_fk, id_type_dosen_fk = attributs.id_type_dosen_fk, is_active = attributs.is_active, created_by = attributs.created_by, created_date = attributs.created_date, updated_by = attributs.updated_by, updated_date = attributs.updated_date, program_studi = b.nama_jurusan, status_karyawan = c.deskripsi }).FirstOrDefault(); } return(result); }
public ActionResult UploadFiles(DosenViewModel paramModel) { // Checking no of files injected in Request object if (Request.Files.Count > 0) { List <Files> statusUpload = Models.Shared.Helper.FnFileUploadMultiple(Request.Files, Request.Browser.Browser.ToUpper(), "~/Images/"); return(Json(new { success = true, message = "sukses" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = "gagal" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(DosenViewModel paramModel) { try { paramModel.updated_by = "adit"; paramModel.updated_date = DateTime.Now; if (DosenDataAccess.Update(paramModel)) { return(Json(new { success = true, message = "Data berhasil ditambahkan!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = true, message = DosenDataAccess.Message }, JsonRequestBehavior.AllowGet)); } } catch (Exception hasError) { return(Json(new { success = true, message = hasError.Message }, JsonRequestBehavior.AllowGet)); } }
public static bool Insert(DosenViewModel model) { bool result = true; try { using (var db = new DB_UniversityEntities()) { tbl_m_dosen attributs = new tbl_m_dosen(); attributs.nama_dosen = model.nama_dosen; attributs.id_jurusan_fk = model.id_jurusan_fk; attributs.id_type_dosen_fk = model.id_type_dosen_fk; attributs.is_active = model.is_active; attributs.created_by = model.created_by; attributs.created_date = model.created_date; attributs.updated_by = model.updated_by; attributs.updated_date = model.updated_date; attributs.kode_dosen = model.kode_dosen; db.tbl_m_dosen.Add(attributs); db.SaveChanges(); } } catch (Exception hasError) { if (hasError.Message.ToLower().Contains("inner exception")) { Message = hasError.InnerException.InnerException.Message; } else { Message = hasError.Message; } result = false; } return(result); }
public ActionResult Create(DosenViewModel paramModel) { try { paramModel.created_by = "adit"; paramModel.created_date = DateTime.Now; paramModel.updated_by = "adit"; paramModel.updated_date = DateTime.Now; List <Files> statusUpload = Models.Shared.Helper.FnFileUploadMultiple(Request.Files, Request.Browser.Browser.ToUpper(), "~/Images/"); if (DosenDataAccess.Insert(paramModel)) { return(Json(new { success = true, message = "Data berhasil ditambahkan!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = DosenDataAccess.Message }, JsonRequestBehavior.AllowGet)); } } catch (Exception hasError) { return(Json(new { success = true, message = hasError.Message }, JsonRequestBehavior.AllowGet)); } }