public IHttpActionResult GetRekamMedisById()
{
var result = new RekamMedisRequest();
var historyMedis = new VW_HISTORY_MEDIS_PASIEN();
var rekamMedis = new REKAM_MEDIS();
var identity = (ClaimsIdentity)User.Identity;
var roles = identity.Claims.Where(c => c.Type == ClaimTypes.Role).FirstOrDefault();
if (roles.Value == "Pasien")
{
var username = identity.Claims.Where(c => c.Type == ClaimTypes.Name).FirstOrDefault().Value;
var pasien = db.PASIENs.Where(x => x.USER.USERNAME == username).FirstOrDefault();
historyMedis = db.VW_HISTORY_MEDIS_PASIEN.Where(x => x.ID_PASIEN == pasien.ID_PASIEN).OrderByDescending(x => x.TGL_MASUK).FirstOrDefault();
var tKasus = db.PEMERIKSAANs.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN).FirstOrDefault();
if (tKasus.ID_REKAM_MEDIS.HasValue)
{
rekamMedis = db.REKAM_MEDIS.Where(x => x.ID_REKAM_MEDIS == tKasus.ID_REKAM_MEDIS).FirstOrDefault();
}
}
else
{
historyMedis = db.VW_HISTORY_MEDIS_PASIEN.OrderByDescending(x => x.TGL_MASUK).ThenBy(x => x.PASIEN).FirstOrDefault();
var tKasus = db.PEMERIKSAANs.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN).FirstOrDefault();
if (tKasus.ID_REKAM_MEDIS.HasValue)
{
rekamMedis = db.REKAM_MEDIS.Where(x => x.ID_REKAM_MEDIS == tKasus.ID_REKAM_MEDIS).FirstOrDefault();
}
}
if (rekamMedis == null)
{
return(Ok());
}
result.IdPemeriksaan = historyMedis.ID_PEMERIKSAAN.GetValueOrDefault();
result.IdRekamMedis = rekamMedis.ID_REKAM_MEDIS;
result.Gejala = rekamMedis.GEJALA;
result.Tindakan = rekamMedis.TINDAKAN;
result.Diagnosa = rekamMedis.DIAGNOSA;
result.HasilTestLab = rekamMedis.HASIL_TEST_LAB;
return(Ok(result));
}
public IHttpActionResult GetRekamMedisById(int idPemeriksaan)
{
var result = new REKAM_MEDIS();
var tKasus = db.PEMERIKSAANs.Where(x => x.ID_PEMERIKSAAN == idPemeriksaan).FirstOrDefault();
var rekamMedis = db.REKAM_MEDIS.Where(x => x.ID_REKAM_MEDIS == tKasus.ID_REKAM_MEDIS).FirstOrDefault();
result.ID_REKAM_MEDIS = rekamMedis.ID_REKAM_MEDIS;
result.GEJALA = rekamMedis.GEJALA;
result.DIAGNOSA = rekamMedis.DIAGNOSA;
result.TINDAKAN = rekamMedis.TINDAKAN;
result.HASIL_TEST_LAB = rekamMedis.HASIL_TEST_LAB;
if (rekamMedis == null)
{
return(Ok());
}
return(Ok(result));
}
public async Task <IHttpActionResult> PostRekamMedis(RekamMedisRequest rekamMedisRequest)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Data yang dikirim tidak lengkap"));
}
var kasusStat = new KASUS_STAT();
var pemeriksaan = db.PEMERIKSAANs.Where(x => x.ID_PEMERIKSAAN == rekamMedisRequest.IdPemeriksaan).FirstOrDefault();
var rekamMedis = new REKAM_MEDIS();
rekamMedis.GEJALA = rekamMedisRequest.Gejala;
rekamMedis.DIAGNOSA = rekamMedisRequest.Diagnosa;
rekamMedis.VONIS = rekamMedis.DIAGNOSA;
rekamMedis.TINDAKAN = rekamMedisRequest.Tindakan;
while (true)
{
rekamMedis.ID_REKAM_MEDIS = _random.Next(1, 999999999);
var count = db.REKAM_MEDIS.Where(k => k.ID_REKAM_MEDIS == rekamMedis.ID_REKAM_MEDIS).Count();
if (count == 0)
{
break;
}
}
rekamMedisRequest.IdRekamMedis = rekamMedis.ID_REKAM_MEDIS;
pemeriksaan.ID_REKAM_MEDIS = rekamMedis.ID_REKAM_MEDIS;
db.REKAM_MEDIS.Add(rekamMedis);
await db.SaveChangesAsync();
return(Ok(rekamMedisRequest));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public IHttpActionResult GetOrderMedisList(string search, string sort, int limit, int offset)
{
var pageSize = limit;
var pageNumber = offset;
var totalRecord = 0;
var result = new List <VW_ORDER_MEDIS>();
var historyMedis = new VW_HISTORY_MEDIS_PASIEN();
var rekamMedis = new REKAM_MEDIS();
var identity = (ClaimsIdentity)User.Identity;
var roles = identity.Claims.Where(c => c.Type == ClaimTypes.Role).FirstOrDefault();
if (roles.Value == "Pasien")
{
var username = identity.Claims.Where(c => c.Type == ClaimTypes.Name).FirstOrDefault().Value;
var pasien = db.PASIENs.Where(x => x.USER.USERNAME == username).FirstOrDefault();
historyMedis = db.VW_HISTORY_MEDIS_PASIEN.Where(x => x.ID_PASIEN == pasien.ID_PASIEN).OrderByDescending(x => x.TGL_MASUK).FirstOrDefault();
result = db.VW_ORDER_MEDIS.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN)
.OrderByDescending(x => x.ID_ORDER).ThenBy(x => x.ID_PEMERIKSAAN)
.Skip(GetSkip(pageNumber, pageSize))
.Take(pageSize).ToList();
totalRecord = db.VW_ORDER_MEDIS.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN).Count();
}
else
{
historyMedis = db.VW_HISTORY_MEDIS_PASIEN.OrderByDescending(x => x.TGL_MASUK).ThenBy(x => x.PASIEN).FirstOrDefault();
result = db.VW_ORDER_MEDIS.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN)
.OrderByDescending(x => x.ID_ORDER).ThenBy(x => x.ID_PEMERIKSAAN)
.Skip(GetSkip(pageNumber, pageSize))
.Take(pageSize).ToList();
totalRecord = db.VW_ORDER_MEDIS.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN).Count();
}
var totalPage = (totalRecord + pageSize - 1) / pageSize;
return(Ok(new APIListResponse <VW_ORDER_MEDIS>(false, HttpStatusCode.OK.ToString(), HttpStatusCode.OK.ToString(), result, totalRecord, totalPage)));
}
public async Task <IHttpActionResult> PutOrderMedis(int idRekamMedis, REKAM_MEDIS rekamMedis)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Data yang dikirim tidak lengkap"));
}
var rekamMedisInDB = db.REKAM_MEDIS.Where(x => x.ID_REKAM_MEDIS == idRekamMedis).FirstOrDefault();
rekamMedisInDB.HASIL_TEST_LAB = rekamMedis.HASIL_TEST_LAB;
await db.SaveChangesAsync();
return(Ok(rekamMedis));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public async Task <IHttpActionResult> PostPenjadwalanRecent(JadwalRequest jadwalRequest)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Data yang dikirim tidak lengkap"));
}
var historyMedis = new VW_HISTORY_MEDIS_PASIEN();
var rekamMedis = new REKAM_MEDIS();
var identity = (ClaimsIdentity)User.Identity;
var roles = identity.Claims.Where(c => c.Type == ClaimTypes.Role).FirstOrDefault();
if (roles.Value == "Pasien")
{
var username = identity.Claims.Where(c => c.Type == ClaimTypes.Name).FirstOrDefault().Value;
var pasien = db.PASIENs.Where(x => x.USER.USERNAME == username).FirstOrDefault();
historyMedis = db.VW_HISTORY_MEDIS_PASIEN.Where(x => x.ID_PASIEN == pasien.ID_PASIEN).OrderByDescending(x => x.TGL_MASUK).FirstOrDefault();
var tKasus = db.PEMERIKSAANs.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN).FirstOrDefault();
if (tKasus.ID_REKAM_MEDIS.HasValue)
{
rekamMedis = db.REKAM_MEDIS.Where(x => x.ID_REKAM_MEDIS == tKasus.ID_REKAM_MEDIS).FirstOrDefault();
}
}
else
{
historyMedis = db.VW_HISTORY_MEDIS_PASIEN.OrderByDescending(x => x.TGL_MASUK).ThenBy(x => x.PASIEN).FirstOrDefault();
var tKasus = db.PEMERIKSAANs.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN).FirstOrDefault();
if (tKasus.ID_REKAM_MEDIS.HasValue)
{
rekamMedis = db.REKAM_MEDIS.Where(x => x.ID_REKAM_MEDIS == tKasus.ID_REKAM_MEDIS).FirstOrDefault();
}
}
var jadwal = new JADWAL();
jadwal.MULAI = jadwalRequest.TglMulai;
jadwal.SELESAI = jadwalRequest.TglSelesai;
jadwal.ID_PEMERIKSAAN = historyMedis.ID_PEMERIKSAAN.GetValueOrDefault();
jadwal.KEPERLUAN = jadwalRequest.Keperluan;
jadwal.STATUS = 1;
while (true)
{
jadwal.ID_JADWAL = _random.Next(1, 999999999);
var count = db.JADWALs.Where(k => k.ID_JADWAL == jadwal.ID_JADWAL).Count();
if (count == 0)
{
break;
}
}
jadwalRequest.IdJadwal = jadwal.ID_JADWAL;
db.JADWALs.Add(jadwal);
await db.SaveChangesAsync();
return(Ok(jadwalRequest));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public IHttpActionResult GetListPenjadwalanRecent(string search, string sort, int limit, int offset)
{
var historyMedis = new VW_HISTORY_MEDIS_PASIEN();
var rekamMedis = new REKAM_MEDIS();
var identity = (ClaimsIdentity)User.Identity;
var roles = identity.Claims.Where(c => c.Type == ClaimTypes.Role).FirstOrDefault();
if (roles.Value == "Pasien")
{
var username = identity.Claims.Where(c => c.Type == ClaimTypes.Name).FirstOrDefault().Value;
var pasien = db.PASIENs.Where(x => x.USER.USERNAME == username).FirstOrDefault();
historyMedis = db.VW_HISTORY_MEDIS_PASIEN.Where(x => x.ID_PASIEN == pasien.ID_PASIEN).OrderByDescending(x => x.TGL_MASUK).FirstOrDefault();
var tKasus = db.PEMERIKSAANs.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN).FirstOrDefault();
if (tKasus.ID_REKAM_MEDIS.HasValue)
{
rekamMedis = db.REKAM_MEDIS.Where(x => x.ID_REKAM_MEDIS == tKasus.ID_REKAM_MEDIS).FirstOrDefault();
}
}
else
{
historyMedis = db.VW_HISTORY_MEDIS_PASIEN.OrderByDescending(x => x.TGL_MASUK).ThenBy(x => x.PASIEN).FirstOrDefault();
var tKasus = db.PEMERIKSAANs.Where(x => x.ID_PEMERIKSAAN == historyMedis.ID_PEMERIKSAAN).FirstOrDefault();
if (tKasus.ID_REKAM_MEDIS.HasValue)
{
rekamMedis = db.REKAM_MEDIS.Where(x => x.ID_REKAM_MEDIS == tKasus.ID_REKAM_MEDIS).FirstOrDefault();
}
}
var pageSize = limit;
var pageNumber = offset;
var totalRecord = 0;
var result = new List <JadwalRequest>();
var idPemeriksaan = historyMedis.ID_PEMERIKSAAN.GetValueOrDefault();
//var appUser = db.USERS.Where(x => x.USERNAME == username).FirstOrDefault();
var jadwalRequests = db.JADWALs.Where(x => x.ID_PEMERIKSAAN == idPemeriksaan)
.OrderByDescending(x => x.MULAI).ThenBy(x => x.SELESAI)
.Skip(GetSkip(pageNumber, pageSize))
.Take(pageSize).ToList();
foreach (var x in jadwalRequests)
{
var jadwal = new JadwalRequest
{
IdJadwal = x.ID_JADWAL,
IdPemeriksaan = x.ID_PEMERIKSAAN,
TglMulai = x.MULAI.GetValueOrDefault(),
TglSelesai = x.SELESAI.GetValueOrDefault(),
Keperluan = x.KEPERLUAN,
HasilPemeriksaan = x.HASIL_PEMERIKSAAN,
Status = x.STATUS.GetValueOrDefault()
};
result.Add(jadwal);
}
totalRecord = db.JADWALs.Count();
var totalPage = (totalRecord + pageSize - 1) / pageSize;
return(Ok(new APIListResponse <JadwalRequest>(false, HttpStatusCode.OK.ToString(), HttpStatusCode.OK.ToString(), result, totalRecord, totalPage)));
}
