private void PopulateModel(Siswa model, IDictionary values)
{
string ID = nameof(Siswa.Id);
string NIM = nameof(Siswa.NIM);
string NAMA = nameof(Siswa.Nama);
string KELAS_ID = nameof(Siswa.KelasId);
if (values.Contains(ID))
{
model.Id = Convert.ToInt32(values[ID]);
}
if (values.Contains(NIM))
{
model.NIM = Convert.ToInt32(values[NIM]);
}
if (values.Contains(NAMA))
{
model.Nama = Convert.ToString(values[NAMA]);
}
if (values.Contains(KELAS_ID))
{
model.KelasId = Convert.ToInt32(values[KELAS_ID]);
}
}
public async Task <IActionResult> PutSiswa([FromRoute] int id, [FromBody] Siswa siswa)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != siswa.SiswaId)
{
return(BadRequest());
}
_context.Entry(siswa).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SiswaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IHttpActionResult UpdateData([FromBody] Siswa req)
{
try
{
if (req != null)
{
using (var dc = new Makers1DataContext())
{
var data = dc.Siswas.FirstOrDefault(o => o.Username == req.Username);
data.Username = req.Username;
data.Password = req.Password;
data.Firstname = req.Firstname;
data.Lastname = req.Lastname;
dc.SubmitChanges();
return(Ok(data));
}
}
else
{
return(Unauthorized());
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <IActionResult> Edit(int id, [Bind("SiswaID,SiswaNim,SiswaNama,SiswaAlamat,KelasID")] Siswa siswa)
{
if (id != siswa.SiswaID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(siswa);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SiswaExists(siswa.SiswaID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["KelasID"] = new SelectList(_context.Kelas, "KelasID", "KelasNama", siswa.KelasID);
return(View(siswa));
}
private void KeluargaDependencies()
{
/* Status ortu */
cmb_status_ayah.DataSource = Siswa.get_status_ayah();
cmb_status_ayah.DisplayMember = "Text";
cmb_status_ayah.ValueMember = "Value";
cmb_status_ibu.DataSource = Siswa.get_status_ibu();
cmb_status_ibu.DisplayMember = "Text";
cmb_status_ibu.ValueMember = "Value";
/* Status hubungan */
cmb_status_hubungan.DataSource = Siswa.get_status_hubungan();
/* Status Wali */
cmb_hubungan_wali.DataSource = Siswa.get_hubungan_wali();
/* Pekerjaan ortu */
cmb_pekerjaan_ayah.DataSource = SimpleQuery.get_list_pekerjaan();
cmb_pekerjaan_ayah.DisplayMember = "NAMA_PEKERJAAN";
cmb_pekerjaan_ayah.ValueMember = "KODE_PEKERJAAN";
cmb_pekerjaan_ibu.DataSource = SimpleQuery.get_list_pekerjaan();
cmb_pekerjaan_ibu.DisplayMember = "NAMA_PEKERJAAN";
cmb_pekerjaan_ibu.ValueMember = "KODE_PEKERJAAN";
/* Pendidikan ortu */
cmb_pendidikan_ayah.DataSource = SimpleQuery.get_list_pendidikan();
cmb_pendidikan_ayah.DisplayMember = "NAMA_PENDIDIKAN";
cmb_pendidikan_ayah.ValueMember = "KODE_PENDIDIKAN";
cmb_pendidikan_ibu.DataSource = SimpleQuery.get_list_pendidikan();
cmb_pendidikan_ibu.DisplayMember = "NAMA_PENDIDIKAN";
cmb_pendidikan_ibu.ValueMember = "KODE_PENDIDIKAN";
}
void fingerprintBoard_DataReceived(object sender, SerialDataReceivedEventArgs e)
{
Console.WriteLine("STATUS FINGERPRInt");
string data = fingerprintBoard.ReadTo("\x03");
string[] dataArray = data.Split(new string[] { "\x02", "$" }, StringSplitOptions.RemoveEmptyEntries);
string alamat = ConfigurationSettings.AppSettings["AlamatApi"];
foreach (string item in dataArray.ToList())
{
//Siswa sis = new Siswa();
RestClient json = new RestClient(alamat + "siswa-by-id/" + item + "?api_token=$2y$10$v1njqriEy6ndnru7BuCQru4f9d2SAUpC2Cz40KlTjH7ApV78V5EUS&kategori=csharp", "POST", "api_token=$2y$10$v1njqriEy6ndnru7BuCQru4f9d2SAUpC2Cz40KlTjH7ApV78V5EUS");
string dataSiswa = json.GetResponse();
try
{
Console.WriteLine(json.GetResponse());
//string djson = @"{""siswa"":{""nis"":""151610005"",""nama"":""AYU NOVIYANTI"",""telepon"": ""0897""}}";
Siswa siswa = new Siswa(dataSiswa);
siswaItems.Add(siswa);
}
catch (WebException)
{ }
}
if (NewDataReceived != null)
{
NewDataReceived(this, new EventArgs());
}
}
public ActionResult DeleteConfirmed(int id)
{
Siswa siswa = db.Siswaa.Find(id);
db.Siswaa.Remove(siswa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public SiswaDashBoard(Siswa siswa, List <AngkatanModel> listAngkatan, List <KompiModel> listKompi, List <PletonModel> listPleton)
{
this.siswa = siswa;
this.listAngkatan = listAngkatan;
this.listKompi = listKompi;
this.listPleton = listPleton;
InitializeComponent();
loadProfile();
loadOpenTest();
}
//public ActionResult Index()
//{
// var siswaa = db.Siswaa.Include(s => s.Sekolah);
// return View(siswaa.ToList());
//}
//
// GET: /Siswa/Details/5
public ActionResult Details(int id = 0)
{
Siswa siswa = db.Siswaa.Find(id);
if (siswa == null)
{
return(HttpNotFound());
}
return(View(siswa));
}
//
// GET: /Siswa/Delete/5
public ActionResult Delete(int id = 0)
{
Siswa siswa = db.ParaSiswa.Find(id);
if (siswa == null)
{
return(HttpNotFound());
}
return(View(siswa));
}
public TestFuzzy(TestOpen testOpen, Siswa siswa, List <AngkatanModel> listAngkatan, List <KompiModel> listKompi, List <PletonModel> listPleton)
{
InitializeComponent();
this.testOpen = testOpen;
this.Shown += new System.EventHandler(this.TestFuzzy_Shown);
loadTimerTest(testOpen);
this.siswa = siswa;
this.listAngkatan = listAngkatan;
this.listKompi = listKompi;
this.listPleton = listPleton;
}
private void InsertSiswa(Siswa newSiswa)
{
string sqlInsertSiswa = @"INSERT INTO Siswa(CalonSiswaId, TanggalMasuk, Nis, Status)
VALUES(@CalonSiswaId, @TanggalMasuk, @Nis, @Status)";
using (var connection = new SqlConnection(_connectionHelper.GetConnectionString()))
{
connection.Open();
connection.Execute(sql: sqlInsertSiswa, param: newSiswa);
}
}
public ActionResult Edit(Siswa siswa)
{
if (ModelState.IsValid)
{
db.Entry(siswa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.KelasID = new SelectList(db.KelasKelas, "KelasID", "NamaKelas", siswa.KelasID);
return(View(siswa));
}
//
// GET: /Siswa/Edit/5
public ActionResult Edit(int id = 0)
{
Siswa siswa = db.ParaSiswa.Find(id);
if (siswa == null)
{
return(HttpNotFound());
}
ViewBag.KelasID = new SelectList(db.KelasKelas, "KelasID", "NamaKelas", siswa.KelasID);
return(View(siswa));
}
public ActionResult Edit(Siswa siswa)
{
if (ModelState.IsValid)
{
db.Entry(siswa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDSekolah = new SelectList(db.Sekolahh, "IDSekolah", "NamaSekolah", siswa.IDSekolah);
return(View(siswa));
}
//
// GET: /Siswa/Edit/5
public ActionResult Edit(int id = 0)
{
Siswa siswa = db.Siswaa.Find(id);
if (siswa == null)
{
return(HttpNotFound());
}
ViewBag.IDSekolah = new SelectList(db.Sekolahh, "IDSekolah", "NamaSekolah", siswa.IDSekolah);
return(View(siswa));
}
public ActionResult Create(Siswa siswa)
{
if (ModelState.IsValid)
{
db.ParaSiswa.Add(siswa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.KelasID = new SelectList(db.KelasKelas, "KelasID", "NamaKelas", siswa.KelasID);
return(View(siswa));
}
public ActionResult Create(Siswa siswa)
{
if (ModelState.IsValid)
{
db.Siswaa.Add(siswa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDSekolah = new SelectList(db.Sekolahh, "IDSekolah", "NamaSekolah", siswa.IDSekolah);
return(View(siswa));
}
private Siswa CreateSiswa(AkunPendaftaran akun)
{
var siswa = new Siswa()
{
CalonSiswaId = akun.CalonSiswaId,
TanggalMasuk = DateTime.Now,
Status = "Aktif",
Nis = CreateNis()
};
return(siswa);
}
//
// GET: /Siswa/
public ActionResult Index(String searchNama)
{
var siswaa = db.Siswaa.Include(s => s.Sekolah);
var siswa = new Siswa();
if (!String.IsNullOrEmpty(searchNama))
{
siswaa = siswaa.Where(n => n.NamaLengkap.Contains(searchNama));
}
return(View(siswaa.ToList()));
}
public async Task <IActionResult> Create([Bind("SiswaID,SiswaNim,SiswaNama,SiswaAlamat,KelasID")] Siswa siswa)
{
if (ModelState.IsValid)
{
_context.Add(siswa);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["KelasID"] = new SelectList(_context.Kelas, "KelasID", "KelasNama", siswa.KelasID);
return(View(siswa));
}
private void btn_next_biodata_Click(object sender, EventArgs e)
{
string nopendaftaran = Algoritma.GenerateNoPendaftaran(LoginInfo.getNPSN());
string kodeakses = Algoritma.GenerateKodeAksesSiswa(txt_noinduk.Text, LoginInfo.getNPSN());
SQLiteDatabase db = new SQLiteDatabase();
Dictionary <String, String> siswa = new Dictionary <String, String>();
siswa.Add("NO_INDUK", LoginInfo.getNPSN() + txt_noinduk.Text);
siswa.Add("NISN", txt_nisn.Text);
siswa.Add("NPSN", LoginInfo.getNPSN());
siswa.Add("NAMA_SISWA", txt_namasiswa.Text);
siswa.Add("TEMPAT_LAHIR", txt_tempatlahir.Text);
siswa.Add("TANGGAL_LAHIR", DateTime.ParseExact("10/03/2014", "M/d/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd"));
siswa.Add("JENIS_KELAMIN", Siswa._kelamin(pnl_kelamin.Controls.OfType <RadioButton>().FirstOrDefault(r => r.Checked).Text));
siswa.Add("NAMA_IBU", txt_namagadis.Text);
siswa.Add("ANGKATAN_LULUS", cmb_tahunlulus.SelectedValue.ToString());
siswa.Add("STATUS_REKOMENDASI", Siswa.DIREKOMENDASI);
Dictionary <String, String> data = new Dictionary <String, String>();
data.Add("NO_PENDAFTARAN", nopendaftaran);
data.Add("NO_INDUK", LoginInfo.getNPSN() + txt_noinduk.Text);
data.Add("KODE_AKSES", kodeakses);
data.Add("KODE_ROLE", Siswa.ROLE);
data.Add("TAHUN_BEASISWA", Program.TAHUN.ToString());
data.Add("ALAMAT", txt_alamat.Text);
data.Add("KOTA", cmb_kota.SelectedValue.ToString());
data.Add("KODE_POS", txt_kodepos.Text);
data.Add("NO_TELEPON", txt_notelp.Text);
data.Add("NO_HANDPHONE", txt_nohp.Text);
data.Add("EMAIL", txt_email.Text);
try
{
db.Insert("siswa", siswa);
db.Insert("berkas", data);
MessageBox.Show("Data siswa baru tersimpan", "Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
tc_siswa.SelectedTab = tp_akademik;
if (MODE_ISIAN == Siswa.DATA_BARU)
{
EnabledTab(true);
IsianSiswa.MODE_ISIAN = Siswa.EDIT_DATA;
IsianSiswa.NO_INDUK = LoginInfo.getNPSN() + txt_noinduk.Text;
IsianSiswa.NO_PENDAFTARAN = nopendaftaran;
}
}
catch (Exception crap)
{
MessageBox.Show(crap.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
//
// GET: /Siswa/
public ActionResult Index(string searchName, string searchKelas)
{
var parasiswa = db.ParaSiswa.Include(s => s.Kelas);
var siswa = new Siswa();
if (!String.IsNullOrEmpty(searchName))
{
parasiswa = parasiswa.Where(n => n.NamaSiswa.Contains(searchName));
}
return(View(parasiswa.ToList()));
}
public async Task <IActionResult> PostSiswa([FromBody] Siswa siswa)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Siswa.Add(siswa);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSiswa", new { id = siswa.SiswaId }, siswa));
}
private void IsianSiswa_Load(object sender, EventArgs e)
{
/* Provinsi */
cmb_provinsi.DataSource = SimpleQuery.get_provinsi();
cmb_provinsi.DisplayMember = "NAMA_PROVINSI";
cmb_provinsi.ValueMember = "KODE_PROVINSI";
/* Tahun lulus */
cmb_tahunlulus.DataSource = Siswa.get_tahun_lulus();
KeluargaDependencies();
RumahDependencies();
}
public TestSession(TestOpen testOpen, List <ListSoal> listSoal, Siswa siswa, List <AngkatanModel> listAngkatan, List <KompiModel> listKompi, List <PletonModel> listPleton)
{
this.testOpen = testOpen;
this.listSoal = listSoal;
this.siswa = siswa;
this.listAngkatan = listAngkatan;
this.listKompi = listKompi;
this.listPleton = listPleton;
scores = new double[listSoal.Count];
answers = new LockedAnswer[listSoal.Count];
isAnswer = new bool[listSoal.Count];
InitializeComponent();
loadTestInformation(testOpen);
loadTimerTest(testOpen);
}
private void RumahDependencies()
{
/* Kepemilikan */
cmb_kepemilikan.DataSource = SimpleQuery.get_list_kepemilikan();
cmb_kepemilikan.DisplayMember = "KEPEMILIKAN";
cmb_kepemilikan.ValueMember = "KODE_KEPEMILIKAN";
/* Tahun perolehan */
cmb_tahun_perolehan.DataSource = Siswa.get_tahun_kepemilikan();
cmb_tahun_perolehan.DisplayMember = "Text";
cmb_tahun_perolehan.ValueMember = "Value";
cmb_sumber_listrik.DataSource = SimpleQuery.get_list_listrik();
cmb_sumber_listrik.DisplayMember = "SUMBER";
cmb_sumber_listrik.ValueMember = "KODE_LISTRIK";
cmb_daya_listrik.DataSource = Siswa.get_daya_listrik();
cmb_daya_listrik.DisplayMember = "Text";
cmb_daya_listrik.ValueMember = "Value";
cmb_luas_bangunan.DataSource = SimpleQuery.get_list_luas();
cmb_luas_bangunan.DisplayMember = "LUAS";
cmb_luas_bangunan.ValueMember = "KODE_LUAS";
cmb_luas_tanah.DataSource = SimpleQuery.get_list_luas();
cmb_luas_tanah.DisplayMember = "LUAS";
cmb_luas_tanah.ValueMember = "KODE_LUAS";
cmb_bahan_atap.DataSource = Siswa.get_bahan_atap();
cmb_bahan_atap.DisplayMember = "Text";
cmb_bahan_atap.ValueMember = "Value";
cmb_bahan_lantai.DataSource = Siswa.get_bahan_lantai();
cmb_bahan_lantai.DisplayMember = "Text";
cmb_bahan_lantai.ValueMember = "Value";
cmb_bahan_tembok.DataSource = Siswa.get_bahan_tembok();
cmb_bahan_tembok.DisplayMember = "Text";
cmb_bahan_tembok.ValueMember = "Value";
cmb_sumber_air.DataSource = Siswa.get_sumber_air();
cmb_sumber_air.DisplayMember = "Text";
cmb_sumber_air.ValueMember = "Value";
cmb_mck.DataSource = SimpleQuery.get_list_mck();
cmb_mck.DisplayMember = "MCK";
cmb_mck.ValueMember = "KODE_MCK";
}
public async Task <IActionResult> Post(string values)
{
var model = new Siswa();
var valuesDict = JsonConvert.DeserializeObject <IDictionary>(values);
PopulateModel(model, valuesDict);
if (!TryValidateModel(model))
{
return(BadRequest(GetFullErrorMessage(ModelState)));
}
var result = _context.Siswa.Add(model);
await _context.SaveChangesAsync();
return(Json(result.Entity.Id));
}
public Siswa GetByNIS(string nis)
{
Siswa siswa = null;
try
{
var sql = @"select nis, nama
from siswa
where nis = @nis";
siswa = _context.db.QuerySingleOrDefault <Siswa>(sql, new { nis });
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(siswa);
}
public IHttpActionResult Create([FromBody] Siswa req)
{
var result = new List <SelectResult>();
using (var dc = new Makers1DataContext())
{
var data = new Siswa()
{
Username = req.Username,
Password = req.Password,
Firstname = req.Firstname,
Lastname = req.Lastname
};
dc.Siswas.InsertOnSubmit(data);
dc.SubmitChanges();
}
return(Ok(result));
}
