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