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