public async Task <IActionResult> Edit(int id, [Bind("Kehadiran,Id")] Absensi absensi) { if (id != absensi.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(absensi); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AbsensiExists(absensi.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(absensi)); }
public Absensi GetAbsensiSiswa(string nisn, string semester) { Absensi absensi; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM absensi WHERE nisn = '{nisn}' AND semester = '{semester}'"; DataTable dt = dB.GetDataRaport(query); if (dt.Rows.Count > 0) { absensi = new Absensi { IdAbsen = dt.Rows[0][0].ToString(), Nisn = dt.Rows[0][1].ToString(), Sakit = Convert.ToInt32(dt.Rows[0][2]), Ijin = Convert.ToInt32(dt.Rows[0][3]), Alpha = Convert.ToInt32(dt.Rows[0][4]), Semester = dt.Rows[0][5].ToString() }; } else { absensi = new Absensi { IdAbsen = "", Nisn = "", Sakit = 0, Ijin = 0, Alpha = 0, Semester = "" }; } return(absensi); }
private bool SimpanEditAbsensi() { bool isWork = false; AbsensiCRUD acrd = new AbsensiCRUD(); Absensi ab = new Absensi(); ab.IdAbsen = _idabsenSet; ab.Nisn = _nisnSet; ab.Semester = _semesterSet; ab.Sakit = Convert.ToInt32(SakitBox.Value); ab.Ijin = Convert.ToInt32(IzinBox.Value); ab.Alpha = Convert.ToInt32(AlphaBox.Value); try { if (acrd.Ubah(ab)) { isWork = true; } } catch (SQLiteException ex) { if (ex.ErrorCode == 19) { ErrorMessage = "Absen Siswa sudah ada!"; } else { ErrorMessage = "Terjadi kesalahan! Silahkan periksa data kembali!"; } } return(isWork); }
private async void DelSikapDll_Click(object sender, RoutedEventArgs e) { DataRowView drv = (DataRowView)((Button)e.Source).DataContext; SikapCRUD scrd = new SikapCRUD(); EkskulCRUD ecrd = new EkskulCRUD(); AbsensiCRUD acrd = new AbsensiCRUD(); MessageDialogResult res = await this.ShowMessageAsync("Sikap, Ekskul dan Absensi", "Anda akan menghapus data Sikap, Ekskul, dan Absensi. Apa anda yakin ingin melanjutkan?", MessageDialogStyle.AffirmativeAndNegative); if (res == MessageDialogResult.Affirmative) { NilaiSikap ns = new NilaiSikap(); NilaiEkskul ne = new NilaiEkskul(); Absensi ab = new Absensi(); ns.IdSikap = drv.Row[3].ToString(); ne.IdEks = drv.Row[6].ToString(); ab.IdAbsen = drv.Row[9].ToString(); try { if (scrd.Hapus(ns) && ecrd.Hapus(ne) && acrd.Hapus(ab)) { await this.ShowMessageAsync("Sikap, Ekskul dan Absensi", "Data berhasil dihapus!"); LoadSikapDll(); } } catch (SQLiteException ex) { await this.ShowMessageAsync("Sikap, Ekskul dan Absensi", $"Error! {ex.Message}"); } } }
public async Task <ActionResult> Put(int id, [FromBody] Absensi Absensi) { try { VerifyUser(); _validateService.Validate(Absensi); Absensi employeeToUpdate = await _AbsensiService.GetSingleById(id); await _AbsensiService.Update(employeeToUpdate, Absensi); return(NoContent()); } catch (ServiceValidationExeption e) { var result = new ResultFormatter(API_VERSION, General.BAD_REQUEST_STATUS_CODE, General.BAD_REQUEST_MESSAGE) .Fail(e); return(BadRequest(result)); } catch (Exception e) { var result = new ResultFormatter(API_VERSION, General.INTERNAL_ERROR_STATUS_CODE, e.Message) .Fail(); return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, result)); } }
public async Task <ActionResult> Post([FromBody] Absensi Absensi) { try { VerifyUser(); _validateService.Validate(Absensi); await _AbsensiService.Create(Absensi); return(CreatedAtRoute( "Get", new { Id = Absensi.Id }, Absensi)); //var result = new ResultFormatter(API_VERSION, General.CREATED_STATUS_CODE, General.OK_MESSAGE) // .Ok(); //return Created(string.Concat(Request.Path, "/", 0), result); } catch (ServiceValidationExeption e) { var result = new ResultFormatter(API_VERSION, General.BAD_REQUEST_STATUS_CODE, General.BAD_REQUEST_MESSAGE) .Fail(e); return(BadRequest(result)); } catch (Exception e) { var result = new ResultFormatter(API_VERSION, General.INTERNAL_ERROR_STATUS_CODE, e.Message) .Fail(); return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, result)); } }
public async Task <IActionResult> Edit(int id, [Bind("Kd_absen,Kd_anggota,Kd_wilayah,Keterangan,Tanggal,Selesai")] Absensi absensi) { if (id != absensi.Kd_absen) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(absensi); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AbsensiExists(absensi.Kd_absen)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["Kd_anggota"] = new SelectList(_context.Anggota, "Kd_anggota", "Nama", absensi.Kd_anggota); ViewData["Kd_wilayah"] = new SelectList(_context.Wilayah, "Kd_wilayah", "Kd_wilayah", absensi.Kd_wilayah); return(View(absensi)); }
private void GetDataAbsen() { AbsensiCRUD acrd = new AbsensiCRUD(); Absensi ab = acrd.GetAbsensi(_idabsenSet); SakitBox.Value = Convert.ToInt32(ab.Sakit); IzinBox.Value = Convert.ToInt32(ab.Ijin); AlphaBox.Value = Convert.ToInt32(ab.Alpha); }
public IActionResult Get(long id) { Absensi employee = _dataRepository.Get(id); if (employee == null) { return(NotFound("The Employee record couldn't be found.")); } return(Ok(employee)); }
public async Task <IActionResult> Create([Bind("Kehadiran,Id")] Absensi absensi) { if (ModelState.IsValid) { _context.Add(absensi); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(absensi)); }
public IActionResult Delete(long id) { Absensi employee = _dataRepository.Get(id); if (employee == null) { return(NotFound("The Employee record couldn't be found.")); } _dataRepository.Delete(employee); return(NoContent()); }
public IActionResult Post([FromBody] Absensi employee) { if (employee == null) { return(BadRequest("Employee is null.")); } _dataRepository.Add(employee); return(CreatedAtRoute( "Get2", new { Id = employee.id_absensi }, employee)); }
public bool Hapus(Absensi abs) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "DELETE FROM absensi WHERE id_absen = @idabsen"; var args = new Dictionary <string, object> { { "@idabsen", abs.IdAbsen } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public async Task <IActionResult> Create([Bind("Kd_absen,Kd_anggota,Kd_wilayah,Keterangan,Tanggal,Selesai")] Absensi absensi) { if (ModelState.IsValid) { _context.Add(absensi); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["Kd_anggota"] = new SelectList(_context.Anggota, "Kd_anggota", "Kd_anggota", absensi.Kd_anggota); ViewData["Kd_wilayah"] = new SelectList(_context.Wilayah, "Kd_wilayah", "Kd_wilayah", absensi.Kd_wilayah); return(View(absensi)); }
public IActionResult Put(long id, [FromBody] Absensi employee) { if (employee == null) { return(BadRequest("Employee is null.")); } Absensi employeeToUpdate = _dataRepository.Get(id); if (employeeToUpdate == null) { return(NotFound("The Employee record couldn't be found.")); } _dataRepository.Update(employeeToUpdate, employee); return(NoContent()); }
public bool Ubah(Absensi abs) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "UPDATE absensi SET sakit = @sakit, ijin = @ijin, alpha = @alpha, semester = @semester WHERE id_absen = @idabsen"; var args = new Dictionary <string, object> { { "@idabsen", abs.IdAbsen }, { "@sakit", abs.Sakit }, { "@ijin", abs.Ijin }, { "@alpha", abs.Alpha }, { "@semester", abs.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Tambah(Absensi abs) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "INSERT INTO absensi VALUES(@idabsen, @nisn, @sakit, @ijin, @alpha, @semester)"; var args = new Dictionary <string, object> { { "@idabsen", abs.IdAbsen }, { "@nisn", abs.Nisn }, { "@sakit", abs.Sakit }, { "@ijin", abs.Ijin }, { "@alpha", abs.Alpha }, { "@semester", abs.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public Absensi GetAbsensi(string idabs) { Absensi absensi; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM absensi WHERE id_absen = '{idabs}'"; DataTable dt = dB.GetDataRaport(query); absensi = new Absensi { IdAbsen = idabs, Nisn = dt.Rows[0][1].ToString(), Sakit = Convert.ToInt32(dt.Rows[0][2]), Ijin = Convert.ToInt32(dt.Rows[0][3]), Alpha = Convert.ToInt32(dt.Rows[0][4]), Semester = dt.Rows[0][5].ToString() }; return(absensi); }
public Task <int> Update(Absensi employee, Absensi model) { EntityExtension.FlagForUpdate(model, _identityService.Username, USER_AGENT); //_AbsensiDbSet.Update(model); employee.Username = model.Username; employee.Name = model.Name; employee.CheckIn = model.CheckIn; employee.State = model.State; employee.Location = model.Location; employee.CheckOut = model.CheckOut; employee.Approval = model.Approval; employee.Photo = model.Photo; employee.Note = model.Note; employee.ProjectName = model.ProjectName; employee.HeadDivision = model.HeadDivision; employee.ApprovalByAdmin = model.ApprovalByAdmin; employee.CompanyName = model.CompanyName; employee.ClientName = model.ClientName; return(_dbContext.SaveChangesAsync()); }
public Dictionary <string, string> GetRaportView(string nisn, string semester) { //Nama dan Sekolah SiswaCRUD sw = new SiswaCRUD(); SekolahCRUD sk = new SekolahCRUD(); SikapCRUD si = new SikapCRUD(); EkskulCRUD es = new EkskulCRUD(); AbsensiCRUD ab = new AbsensiCRUD(); PengetahuanCRUD pe = new PengetahuanCRUD(); KeterampilanCRUD ke = new KeterampilanCRUD(); DataSiswa dsw = sw.GetDataSiswa(nisn); DataSekolah dsk = sk.GetDataSekolah(); NilaiSikap dns = si.GetNilaiSikapSiswa(nisn, semester); NilaiEkskul dne = es.GetNilaiEkskulSiswa(nisn, semester); Absensi dab = ab.GetAbsensiSiswa(nisn, semester); NilaiPengetahuan nag = new NilaiPengetahuan(); NilaiKeterampilan kag = new NilaiKeterampilan(); if (dsw.Agama.ToString() == "Islam") { nag = pe.GetNilaiPengetahuanSiswa(nisn, semester, 1); kag = ke.GetNilaiKeterampilanSiswa(nisn, semester, 1); } else if (dsw.Agama.ToString() == "Kristen") { nag = pe.GetNilaiPengetahuanSiswa(nisn, semester, 2); kag = ke.GetNilaiKeterampilanSiswa(nisn, semester, 2); } else if (dsw.Agama.ToString() == "Katolik") { nag = pe.GetNilaiPengetahuanSiswa(nisn, semester, 3); kag = ke.GetNilaiKeterampilanSiswa(nisn, semester, 3); } else if (dsw.Agama.ToString() == "Hindu") { nag = pe.GetNilaiPengetahuanSiswa(nisn, semester, 4); kag = ke.GetNilaiKeterampilanSiswa(nisn, semester, 4); } else if (dsw.Agama.ToString() == "Buddha") { nag = pe.GetNilaiPengetahuanSiswa(nisn, semester, 5); kag = ke.GetNilaiKeterampilanSiswa(nisn, semester, 5); } else if (dsw.Agama.ToString() == "Konghuchu") { nag = pe.GetNilaiPengetahuanSiswa(nisn, semester, 6); kag = ke.GetNilaiKeterampilanSiswa(nisn, semester, 6); } NilaiPengetahuan npkn = pe.GetNilaiPengetahuanSiswa(nisn, semester, 7); NilaiKeterampilan kkpkn = ke.GetNilaiKeterampilanSiswa(nisn, semester, 7); NilaiPengetahuan nbi = pe.GetNilaiPengetahuanSiswa(nisn, semester, 8); NilaiKeterampilan kbi = ke.GetNilaiKeterampilanSiswa(nisn, semester, 8); NilaiPengetahuan nmtk = pe.GetNilaiPengetahuanSiswa(nisn, semester, 9); NilaiKeterampilan kmtk = ke.GetNilaiKeterampilanSiswa(nisn, semester, 9); NilaiPengetahuan nsbk = pe.GetNilaiPengetahuanSiswa(nisn, semester, 12); NilaiKeterampilan ksbk = ke.GetNilaiKeterampilanSiswa(nisn, semester, 12); NilaiPengetahuan npen = pe.GetNilaiPengetahuanSiswa(nisn, semester, 13); NilaiKeterampilan kpen = ke.GetNilaiKeterampilanSiswa(nisn, semester, 13); var hasil = new Dictionary <string, string> { { "NamaSiswa", dsw.NmSiswa.ToString() }, { "Nisn", dsw.Nisn.ToString() }, { "NoInduk", dsw.NoInduk.ToString() }, { "Kelas", dsk.Kelas }, { "NamaSekolah", dsk.NmSekolah }, { "Alamat", dsk.Alamat }, { "TahunAjar", dsk.Tahunajar }, { "DSpiritual", dns.DeskripsiKi1 }, { "DSosial", dns.DeskripsiKi2 }, { "NPAgama", nag.NilaiAkhir.ToString() }, { "PPAgama", nag.PredikatPengetahuan }, { "DPAgama", nag.DeskripsiPengetahuan }, { "NKAgama", kag.NilaiAkhir.ToString() }, { "PKAgama", kag.PredikatKeterampilan }, { "DKAgama", kag.DeskripsiKeterampilan }, { "NPPkn", npkn.NilaiAkhir.ToString() }, { "PPPkn", npkn.PredikatPengetahuan }, { "DPPkn", npkn.DeskripsiPengetahuan }, { "NKPkn", kkpkn.NilaiAkhir.ToString() }, { "PKPkn", kkpkn.PredikatKeterampilan }, { "DKPkn", kkpkn.DeskripsiKeterampilan }, { "NPBi", nbi.NilaiAkhir.ToString() }, { "PPBi", nbi.PredikatPengetahuan }, { "DPBi", nbi.DeskripsiPengetahuan }, { "NKBi", kbi.NilaiAkhir.ToString() }, { "PKBi", kbi.PredikatKeterampilan }, { "DKBi", kbi.DeskripsiKeterampilan }, { "NPMtk", nmtk.NilaiAkhir.ToString() }, { "PPMtk", nmtk.PredikatPengetahuan }, { "DPMtk", nmtk.DeskripsiPengetahuan }, { "NKMtk", kmtk.NilaiAkhir.ToString() }, { "PKMtk", kmtk.PredikatKeterampilan }, { "DKMtk", kmtk.DeskripsiKeterampilan }, { "NPSbk", nsbk.NilaiAkhir.ToString() }, { "PPSbk", nsbk.PredikatPengetahuan }, { "DPSbk", nsbk.DeskripsiPengetahuan }, { "NKSbk", ksbk.NilaiAkhir.ToString() }, { "PKSbk", ksbk.PredikatKeterampilan }, { "DKSbk", ksbk.DeskripsiKeterampilan }, { "NPPenjas", npen.NilaiAkhir.ToString() }, { "PPPenjas", npen.PredikatPengetahuan }, { "DPPenjas", npen.DeskripsiPengetahuan }, { "NKPenjas", kpen.NilaiAkhir.ToString() }, { "PKPenjas", kpen.PredikatKeterampilan }, { "DKPenjas", kpen.DeskripsiKeterampilan }, { "Eks1", dne.Eskul1 }, { "Eks2", dne.Eskul2 }, { "Eks3", dne.Eskul3 }, { "NEks1", dne.Nilai1 }, { "NEks2", dne.Nilai2 }, { "NEks3", dne.Nilai3 }, { "TB1", dsw.Tinggi1 }, { "TB2", dsw.Tinggi2 }, { "BB1", dsw.Berat1 }, { "BB2", dsw.Berat2 }, { "Dengar", dsw.Pendengaran }, { "Lihat", dsw.Penglihatan }, { "Gigi", dsw.Gigi }, { "Sakit", dab.Sakit.ToString() }, { "Ijin", dab.Ijin.ToString() }, { "Alpa", dab.Alpha.ToString() }, { "NamaAyah", dsw.NmAyah }, { "NMGuru", dsk.GuruKelas }, { "NIPGuru", dsk.NipGuru }, { "NMKepsek", dsk.NmKepsek }, { "NIPKepsek", dsk.NipKepsek } }; return(hasil); }
public Task <int> Create(Absensi model) { EntityExtension.FlagForCreate(model, _identityService.Username, USER_AGENT); _AbsensiDbSet.Add(model); return(_dbContext.SaveChangesAsync()); }