public async Task <IHttpActionResult> PutMataKuliah(Guid id, MataKuliah mataKuliah) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != mataKuliah.Id) { return(BadRequest()); } db.Entry(mataKuliah).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MataKuliahExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public void Insert(MataKuliah mhs) { using (SqlConnection conn = new SqlConnection(GetConnStr())) { var sql = @"insert into Mata_Kuliah (Kode_matkul,Nama_makul,SKS,Semester,Harga) values(@id, @nama,@sks,@semester,@harga)"; var param = new { id = mhs.Kode_Matkul, nama = mhs.Nama_Makul, sks = mhs.SKS, semester = mhs.Semester, harga = mhs.Harga }; try { conn.Execute(sql, param); } catch (SqlException x) { throw new Exception($"error : {x.Message}"); } foreach (var grup in mhs.grup) { var sql2 = @"insert into Grup_makul (Kode_matkul,Grup,Jadwal,Sesi,Ruangan,Nik) values(@kode,@grup,@jadwal,@sesi,@ruangan,@nik)"; var param2 = new { kode = mhs.Kode_Matkul, grup = grup.Grup, jadwal = grup.Jadwal, sesi = grup.Sesi, ruangan = grup.Ruangan, nik = grup.Nik }; try { conn.Execute(sql2, param2); } catch (SqlException x) { throw new Exception($"error : {x.Message}"); } } } }
public async Task <IHttpActionResult> PostMataKuliah(MataKuliah mataKuliah) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.MataKuliahs.Add(mataKuliah); try { await db.SaveChangesAsync(); } catch (DbUpdateException) { if (MataKuliahExists(mataKuliah.Id)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = mataKuliah.Id }, mataKuliah)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Sks")] MataKuliah mataKuliah) { if (id != mataKuliah.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(mataKuliah); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MataKuliahExists(mataKuliah.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(mataKuliah)); }
public JsonResult PostCreateMataKuliah(MataKuliah data) { string response = "success"; db.MataKuliahs.Add(data); db.SaveChanges(); return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteConfirmed(string id) { MataKuliah mataKuliah = db.MataKuliah.Find(id); db.MataKuliah.Remove(mataKuliah); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <ActionResult> DeleteConfirmed(Guid id) { MataKuliah mataKuliah = await db.MataKuliahs.FindAsync(id); db.MataKuliahs.Remove(mataKuliah); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "KodeMK,Nama")] MataKuliah mataKuliah) { if (ModelState.IsValid) { db.Entry(mataKuliah).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mataKuliah)); }
public async Task <IHttpActionResult> GetMataKuliah(Guid id) { MataKuliah mataKuliah = await db.MataKuliahs.FindAsync(id); if (mataKuliah == null) { return(NotFound()); } return(Ok(mataKuliah)); }
public async Task <ActionResult> Edit([Bind(Include = "Id,KodeMataKuliah,NamaMataKuliah,SKS")] MataKuliah mataKuliah) { if (ModelState.IsValid) { db.Entry(mataKuliah).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(mataKuliah)); }
//Return Index Column berdasarkan hari matkul public int HtoC(MataKuliah MK) { if (MK.getHariSol() > 0) { return(MK.getHariSol() - 1); } else { return(0); } }
//Return Index Row berdasarkan jam matkul public int JtoR(MataKuliah MK) { if (MK.getJamSol() > 6) { return(MK.getJamSol() - 7); } else { return(0); } }
public JsonResult PostUpdateMataKuliah(MataKuliah data) { string response = "success"; db.Database.ExecuteSqlCommand("MataKuliah_Update_MataKuliah @Kode_MK, @Nama_MK, @SKS", new SqlParameter("@Kode_MK", data.Kode_MK), new SqlParameter("@Nama_MK", data.Nama_MK), new SqlParameter("@SKS", data.SKS) ); return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "KodeMK,Nama")] MataKuliah mataKuliah) { if (ModelState.IsValid) { db.MataKuliah.Add(mataKuliah); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mataKuliah)); }
public async Task <IActionResult> Create([Bind("Id,Name,Sks")] MataKuliah mataKuliah) { if (ModelState.IsValid) { _context.Add(mataKuliah); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(mataKuliah)); }
public async Task <ActionResult> Create([Bind(Include = "Id,KodeMataKuliah,NamaMataKuliah,SKS")] MataKuliah mataKuliah) { if (ModelState.IsValid) { mataKuliah.Id = Guid.NewGuid(); db.MataKuliahs.Add(mataKuliah); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(mataKuliah)); }
public IActionResult CreatePost(MataKuliah data) { try { mk.Insert(data); TempData["pesan"] = Helpers.Message.GetPesan("success", "Data Matakuliah berhasil disimpan"); return(Json(new { result = "Redirect", url = Url.Action("Index", "Matakuliah") })); } catch (Exception x) { TempData["pesan"] = Helpers.Message.GetPesan("danger", x.Message); return(Json(new { result = "Redirect", url = Url.Action("Index", "Matakuliah") })); } }
// GET: Admin/MataKuliah/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MataKuliah mataKuliah = db.MataKuliah.Find(id); if (mataKuliah == null) { return(HttpNotFound()); } return(View(mataKuliah)); }
public async Task <IHttpActionResult> DeleteMataKuliah(Guid id) { MataKuliah mataKuliah = await db.MataKuliahs.FindAsync(id); if (mataKuliah == null) { return(NotFound()); } db.MataKuliahs.Remove(mataKuliah); await db.SaveChangesAsync(); return(Ok(mataKuliah)); }
// GET: MataKuliahs/Delete/5 public async Task <ActionResult> Delete(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MataKuliah mataKuliah = await db.MataKuliahs.FindAsync(id); if (mataKuliah == null) { return(HttpNotFound()); } return(View(mataKuliah)); }
public void Update(string kode, MataKuliah mhs) { using (SqlConnection conn = new SqlConnection(GetConnStr())) { var strsql = @"update Mata_Kuliah set Kode_matkul=@kode, Nama_makul=@nama, SKS=@sks, Semester=@semester where Kode_matkul='" + kode + "'"; var param = new { kode = mhs.Kode_Matkul, nama = mhs.Nama_Makul, sks = mhs.SKS, semester = mhs.Semester }; try { conn.Execute(strsql, param); } catch (SqlException x) { throw new Exception($"error : {x.Message}"); }; foreach (var grup in mhs.grup) { var sqlcek = @"select id from Grup_makul where Kode_matkul='" + mhs.Kode_Matkul + "' and Grup='" + grup.Grup + "'"; var id = conn.QueryFirstOrDefault <string>(sqlcek); if (id == null) { var sql2 = @"insert into Grup_makul (Kode_matkul,Grup,Jadwal,Sesi,Ruangan,Nik) values(@kode,@grup,@jadwal,@sesi,@ruangan,@nik)"; var param2 = new { kode = mhs.Kode_Matkul, grup = grup.Grup, jadwal = grup.Jadwal, sesi = grup.Sesi, ruangan = grup.Ruangan, nik = grup.Nik }; try { conn.Execute(sql2, param2); } catch (SqlException x) { throw new Exception($"error : {x.Message}"); } } else { var sql2 = @"update Grup_makul set Grup=@grup, Jadwal=@jadwal, Sesi=@sesi, Ruangan=@ruangan, Nik=@nik where id=" + id; var param2 = new { grup = grup.Grup, jadwal = grup.Jadwal, sesi = grup.Sesi, ruangan = grup.Ruangan, nik = grup.Nik }; try { conn.Execute(sql2, param2); } catch (SqlException x) { throw new Exception($"error : {x.Message}"); } } } } }
public IActionResult EditPost(MataKuliah data) { var kode = TempData["kode"].ToString(); try { mk.Update(kode, data); TempData["pesan"] = Helpers.Message.GetPesan("success", "sukses mengubah data jadwal"); return(Json(new { result = "Redirect", url = Url.Action("Index", "Matakuliah") })); } catch (Exception x) { TempData["pesan"] = Helpers.Message.GetPesan("danger", x.Message); return(Json(new { result = "Redirect", url = Url.Action("Index", "Matakuliah") })); } }
public async Task <IActionResult> AddMataKuliah([FromBody] MataKuliahForCreate mataKuliahdto) { var mataKuliahToCreate = new MataKuliah { KodeMK = mataKuliahdto.KodeMK, NamaMK = mataKuliahdto.NamaMK, Sks = mataKuliahdto.Sks }; _repo.Add(mataKuliahToCreate); if (await _repo.SaveAll()) { return(StatusCode(201)); } return(BadRequest("Terjadi Kesalahan")); }
public MataKuliah GetDatabyID(string kode) { using (SqlConnection conn = new SqlConnection(GetConnStr())) { MataKuliah mk = new MataKuliah(); var strSql = @"select * from Mata_Kuliah where Kode_matkul='" + kode + "'"; var data = conn.QueryFirstOrDefault <MataKuliah>(strSql); mk.Kode_Matkul = data.Kode_Matkul; mk.Nama_Makul = data.Nama_Makul; mk.Harga = data.Harga; mk.Semester = data.Semester; mk.SKS = data.SKS; var strSql2 = @"select * from Grup_makul where Kode_matkul='" + kode + "'"; mk.grup = conn.Query <Grup_makul>(strSql2); return(mk); } }
public void initpilHari() { MataKuliah pilihanMK = new MataKuliah(); foreach (MataKuliah item in listMK) { if (splitNama(pilihanMatkul) == item.getNamaMatKul() && splitHari(pilihanMatkul) == InttoDay(item.getHariSol()) && splitJam(pilihanMatkul) == item.getJamSol()) { pilihanMK = item; } } List <int> HariRuangan = new List <int>(); foreach (Ruangan item in listR) { if (pilihanRuanganAvail == item.getNamaRuangan()) { foreach (int hariR in item.getHariAvailable()) { HariRuangan.Add(hariR); } } } List <int> HariAvail = new List <int>(); foreach (int hariM in pilihanMK.getHariDom()) { foreach (int hariR in HariRuangan) { if (hariM == hariR) { HariAvail.Add(hariM); } } } foreach (int item in HariAvail) { pilHari.Items.Add(tabel.Columns[item - 1].HeaderCell.Value.ToString()); } }
public void initpilRuangan() { MataKuliah pilihan = new MataKuliah(); foreach (MataKuliah item in listMK) { if (splitNama(pilihanMatkul) == item.getNamaMatKul() && splitHari(pilihanMatkul) == InttoDay(item.getHariSol()) && splitJam(pilihanMatkul) == item.getJamSol()) { pilihan = item; } } if (pilihan.getRuanganDom() == "-") { foreach (Ruangan item in listR) { bool found = false; string pilRuangDom = item.getNamaRuangan(); foreach (string name in pilRuangan.Items) { if (name.Equals(pilRuangDom, StringComparison.Ordinal)) { found = true; } } if (!found) { pilRuangan.Items.Add(pilRuangDom); } } } else { string pilRuangDom = pilihan.getRuanganDom(); pilRuangan.Items.Add(pilRuangDom); } }
public void initpilJam() { MataKuliah pilihanMK = new MataKuliah(); foreach (MataKuliah item in listMK) { if (splitNama(pilihanMatkul) == item.getNamaMatKul() && splitHari(pilihanMatkul) == InttoDay(item.getHariSol()) && splitJam(pilihanMatkul) == item.getJamSol()) { pilihanMK = item; } } Ruangan pilihanR = new Ruangan(); foreach (Ruangan item in listR) { if (pilihanRuanganAvail == item.getNamaRuangan()) { foreach (int hariR in item.getHariAvailable()) { if (DaytoInt(pilihanHari) == hariR) { pilihanR = item; } } } } int batasanA; int batasanB; if (pilihanMK.getJamDomAwal() > pilihanR.getjamMulai()) { batasanA = pilihanMK.getJamDomAwal(); } else { batasanA = pilihanR.getjamMulai(); } if (pilihanMK.getJamDomAkhir() < pilihanR.getjamAkhir()) { batasanB = pilihanMK.getJamDomAkhir(); } else { batasanB = pilihanR.getjamAkhir(); } batasanB = batasanB - pilihanMK.getSks(); int count = batasanB - batasanA; for (int i = 0; i <= count; i++) { bool batasanAvail = true; int tes = batasanA; for (int j = 0; j < pilihanMK.getSks(); j++) { foreach (MataKuliah MatKonflik in listMK) { if (MatKonflik.getRuanganSol() == pilihanRuanganAvail && InttoDay(MatKonflik.getHariSol()) == pilihanHari && MatKonflik.getNamaMatKul() != pilihanMatkul) { int JamKonflik = MatKonflik.getJamSol(); for (int k = 0; k < MatKonflik.getSks(); k++) { if (JamKonflik == tes) { batasanAvail = false; } JamKonflik++; } } } tes = tes + 1; } if (batasanAvail) { pilJam.Items.Add(batasanA); } batasanA = batasanA + 1; } }