public dynamic GetAllDsn(string npp) { OutPutApi output = new OutPutApi(); output.status = true; using (SqlConnection conn = new SqlConnection(DBKoneksi.koneksi)) { try { string query = @"SELECT D.NPP, D.NAMA_DOSEN_LENGKAP FROM MST_DOSEN D WHERE KD_STATUS_DOSEN ='A'"; var data = conn.Query <dynamic>(query, new { npp = npp }).ToList(); output.data = data; return(output); } catch (Exception ex) { output.status = false; output.pesan = ex.Message; output.data = new List <string>(); return(output); } finally { conn.Dispose(); } } }
public dynamic GetAllMhs(string npm) { OutPutApi output = new OutPutApi(); output.status = true; using (SqlConnection conn = new SqlConnection(DBKoneksi.koneksi)) { try { string query = @"SELECT m.NPM, m.NAMA_MHS FROM dbo.MST_MHS_AKTIF m WHERE m.KD_STATUS_MHS ='A'"; var data = conn.Query <dynamic>(query, new { npm = npm }).ToList(); output.data = data; return(output); } catch (Exception ex) { output.status = false; output.pesan = ex.Message; output.data = new List <string>(); return(output); } finally { conn.Dispose(); } } }
public OutPutApi GetDsnProfil(string npp) { OutPutApi dt = new OutPutApi(); dt.status = true; dt.pesan = "Berhasil Mengambil data"; var data = dao.GetAllDsn(npp);; if (data != null) { dt.data = data; } else { dt.status = false; dt.pesan = "Tidak ada data"; } return(dt); }
public DsnBM() { dao = new DsnDAO(); output = new OutPutApi(); }
public AuthBM() { dao = new AuthDAO(); output = new OutPutApi(); }
public MhsBM() { dao = new MhsDAO(); output = new OutPutApi(); }