public static bool Update(JurusanViewModel model)
{
bool result = true;
try
{
using (var db = new DB_UniversityEntities())
{
tbl_m_jurusan attributs = db.tbl_m_jurusan.Where(o => o.id_jurusan_pk == model.id_jurusan_pk).FirstOrDefault();
if (attributs != null)
{
attributs.kode_jurusan = model.kode_jurusan;
attributs.nama_jurusan = model.nama_jurusan;
attributs.is_active = model.is_active;
attributs.updated_by = model.updated_by;
attributs.updated_date = model.updated_date;
attributs.Akreditasi = model.akreditasi;
db.SaveChanges();
}
else
{
result = false;
Message = "Categories not found!";
}
}
}
catch (Exception hasError)
{
Message = hasError.Message;
result = false;
}
return(result);
}
public ActionResult Edit(JurusanViewModel paramModel)
{
try
{
paramModel.updated_by = "adit";
paramModel.updated_date = DateTime.Now;
if (JurusanDataAccess.Update(paramModel))
{
return(Json(new { success = true, message = "Data berhasil ditambahkan!" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = true, message = JurusanDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception hasError)
{
return(Json(new { success = true, message = hasError.Message }, JsonRequestBehavior.AllowGet));
}
}
public static JurusanViewModel GetDetailsByid(int id)
{
JurusanViewModel result = new JurusanViewModel();
using (var db = new DB_UniversityEntities())
{
result = (from attributs in db.tbl_m_jurusan
where attributs.id_jurusan_pk == id
select new JurusanViewModel
{
id_jurusan_pk = attributs.id_jurusan_pk,
kode_jurusan = attributs.kode_jurusan,
nama_jurusan = attributs.nama_jurusan,
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,
akreditasi = attributs.Akreditasi
}).FirstOrDefault();
}
return(result);
}
public static bool Insert(JurusanViewModel model)
{
bool result = true;
try
{
using (var db = new DB_UniversityEntities())
{
tbl_m_jurusan attributs = new tbl_m_jurusan();
attributs.nama_jurusan = model.nama_jurusan;
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_jurusan = model.kode_jurusan;
attributs.Akreditasi = model.akreditasi;
db.tbl_m_jurusan.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 void Seed()
{
var sekolah = new SekolahViewModel
{
Id = 1,
Name = "SMA"
};
var jur1 =
new JurusanViewModel
{
Id = "1",
Name = "MATEMATIKA DAN ILMU ALAM",
Sekolah = sekolah
};
var jur1_1 =
new JurusanViewModel
{
Id = "1-1",
Name = "Matematika",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_1);
var jur1_2 =
new JurusanViewModel
{
Id = "1-2",
Name = "Fisika",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_2);
var jur1_3 =
new JurusanViewModel
{
Id = "1-3",
Name = "Biologi",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_3);
var jur1_4 =
new JurusanViewModel
{
Id = "1-4",
Name = "Kimia",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_4);
var jur2 =
new JurusanViewModel
{
Id = "2",
Name = "ILMU-ILMU SOSIAL",
Sekolah = sekolah
};
var jur2_1 =
new JurusanViewModel
{
Id = "2-1",
Name = "Sejarah",
Parent = jur2,
Sekolah = sekolah
};
JurusanItems.Add(jur2_1);
var jur2_2 =
new JurusanViewModel
{
Id = "2-2",
Name = "Geografi",
Parent = jur2,
Sekolah = sekolah
};
JurusanItems.Add(jur2_2);
var jur2_3 =
new JurusanViewModel
{
Id = "2-3",
Name = "Sosiologi",
Parent = jur2,
Sekolah = sekolah
};
JurusanItems.Add(jur2_3);
var jur2_4 =
new JurusanViewModel
{
Id = "2-4",
Name = "Ekonomi",
Parent = jur2,
Sekolah = sekolah
};
JurusanItems.Add(jur2_4);
var jur3 =
new JurusanViewModel
{
Id = "3",
Name = "BAHASA DAN BUDAYA",
Sekolah = sekolah
};
var jur3_1 =
new JurusanViewModel
{
Id = "3-1",
Name = "Bahasa dan Sastra Indonesia",
Parent = jur3,
Sekolah = sekolah
};
JurusanItems.Add(jur3_1);
var jur3_2 =
new JurusanViewModel
{
Id = "3-2",
Name = "Bahasa dan Sastra Inggris",
Parent = jur3,
Sekolah = sekolah
};
JurusanItems.Add(jur3_2);
var jur3_3 =
new JurusanViewModel
{
Id = "3-3",
Name = "Bahasa dan Sastra Asing Lainnya",
Parent = jur3,
Sekolah = sekolah
};
JurusanItems.Add(jur3_3);
var jur3_4 =
new JurusanViewModel
{
Id = "3-4",
Name = "Antropologi",
Parent = jur3,
Sekolah = sekolah
};
JurusanItems.Add(jur3_4);
}
public void Seed()
{
var sekolah = new SekolahViewModel
{
Id = 1,
Name = "SMK"
};
var jur1 =
new JurusanViewModel
{
Id = "1",
Name = "AGRO BISNIS DAN AGRO TEKNOLOGI",
Sekolah = sekolah
};
var jur1_1 =
new JurusanViewModel
{
Id = "1-1",
Name = "Agrobisnis Tanaman",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_1);
var jur1_2 =
new JurusanViewModel
{
Id = "1-2",
Name = "Sumber Daya Perairan",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_2);
var jur1_3 =
new JurusanViewModel
{
Id = "1-3",
Name = "Agribisnis Perikanan",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_3);
var jur1_4 =
new JurusanViewModel
{
Id = "1-4",
Name = "Kehutanan",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_4);
var jur1_5 =
new JurusanViewModel
{
Id = "1-5",
Name = "Agrisbisnis Ternak Unggas",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_5);
var jur1_6 =
new JurusanViewModel
{
Id = "1-6",
Name = "Pengawasan Mutu",
Parent = jur1,
Sekolah = sekolah
};
JurusanItems.Add(jur1_6);
var jur2 =
new JurusanViewModel
{
Id = "2",
Name = "BISNIS MANAJEMEN",
Sekolah = sekolah
};
var jur2_1 =
new JurusanViewModel
{
Id = "2-1",
Name = "Akuntansi",
Parent = jur2,
Sekolah = sekolah
};
JurusanItems.Add(jur2_1);
var jur2_2 =
new JurusanViewModel
{
Id = "2-2",
Name = "Perbankan",
Parent = jur2,
Sekolah = sekolah
};
JurusanItems.Add(jur2_2);
var jur2_3 =
new JurusanViewModel
{
Id = "2-3",
Name = "Pemasaran",
Parent = jur2,
Sekolah = sekolah
};
JurusanItems.Add(jur2_3);
var jur2_4 =
new JurusanViewModel
{
Id = "2-4",
Name = "Administrasi Perkantoran",
Parent = jur2,
Sekolah = sekolah
};
JurusanItems.Add(jur2_4);
var jur3 =
new JurusanViewModel
{
Id = "3",
Name = "TEKNOLOGI INFORMASI",
Sekolah = sekolah
};
var jur3_1 =
new JurusanViewModel
{
Id = "3-1",
Name = "Rekayasa Perangkat Lunak",
Parent = jur3,
Sekolah = sekolah
};
JurusanItems.Add(jur3_1);
var jur3_2 =
new JurusanViewModel
{
Id = "3-2",
Name = "Teknik Komputer dan Jaringan",
Parent = jur3,
Sekolah = sekolah
};
JurusanItems.Add(jur3_2);
var jur3_3 =
new JurusanViewModel
{
Id = "3-3",
Name = "Multimedia",
Parent = jur3,
Sekolah = sekolah
};
JurusanItems.Add(jur3_3);
var jur4 =
new JurusanViewModel
{
Id = "4",
Name = "TEKNOLOGI DAN REKAYASA",
Sekolah = sekolah
};
var jur4_1 =
new JurusanViewModel
{
Id = "4-1",
Name = "Sepeda Motor",
Parent = jur4,
Sekolah = sekolah
};
JurusanItems.Add(jur4_1);
var jur4_2 =
new JurusanViewModel
{
Id = "4-2",
Name = "Pengelasan",
Parent = jur4,
Sekolah = sekolah
};
JurusanItems.Add(jur4_2);
var jur4_3 =
new JurusanViewModel
{
Id = "4-3",
Name = "Konstruksi",
Parent = jur4,
Sekolah = sekolah
};
JurusanItems.Add(jur4_3);
}
