public List <PatientAdmissions> getPatientadmin() { hospitalsContext db = new hospitalsContext(); return(db.PatientAdmissions.ToList()); }
public IQueryable <PatientAdmissions> getPatientadminbyID(int aid) { hospitalsContext db = new hospitalsContext(); return(db.PatientAdmissions.Where(a => a.AdminssionId == aid)); }
public DispensaryWrapper postd([FromBody] DispensaryWrapper di) { String msg = ""; hospitalsContext db = new hospitalsContext(); try { switch (di.trans) { case 1: if (descision(di.dis.AdminssionId)) { db.Dispensary.Add(di.dis); db.SaveChanges(); msg = "ok"; } else { msg = "not possible"; } break; case 2: var du = db.Dispensary.Where(a => a.Billno == di.dis.Billno).FirstOrDefault(); du.BillAmt = di.dis.BillAmt; du.Dat = di.dis.Dat; du.BillAmt = di.dis.BillAmt; db.SaveChanges(); msg = "ok"; break; case 3: if (Diss(di.dis.AdminssionId)) { var dd = db.Dispensary.Where(a => a.Billno == di.dis.Billno).FirstOrDefault(); db.Dispensary.Remove(dd); db.SaveChanges(); msg = "ok"; } else { msg = "not exists"; } break; } } catch (Exception ee) { msg = ee.Message; } di.result = msg; return(di); }
public consulationwrapper postcon([FromBody] consulationwrapper cw) { hospitalsContext db = new hospitalsContext(); string msg = ""; try { switch (cw.trans) { case 1: if (descision(cw.con.AdminssionId)) { db.Consultations.Add(cw.con); db.SaveChanges(); msg = "ok"; } else { msg = "not possible"; } break; case 2: var pat = db.Consultations.Where(a => a.ConsultationId == cw.con.ConsultationId).FirstOrDefault(); pat.AdminssionId = cw.con.AdminssionId; pat.ConsultationAmt = cw.con.ConsultationAmt; pat.Dat = cw.con.Dat; db.SaveChanges(); msg = "ok"; break; case 3: var ptd = db.Consultations.Where(a => a.ConsultationId == cw.con.ConsultationId).FirstOrDefault(); db.Consultations.Remove(ptd); db.SaveChanges(); break; } } catch (Exception ee) { msg = ee.Message; } cw.result = msg; return(cw); }
public Boolean descision(int?aid) { var b = false; hospitalsContext db = new hospitalsContext(); var y = db.PatientAdmissions.Where(a => a.AdminssionId == aid).FirstOrDefault(); if (y != null) { b = true; } return(b); }
public Boolean descision(int?pid) { var b = false; hospitalsContext db = new hospitalsContext(); var y = db.PatientRegistrations.Where(a => a.PatientId == pid).FirstOrDefault(); if (y != null) { b = true; } return(b); }
private Boolean Diss(int?aid) { hospitalsContext db = new hospitalsContext(); var x = db.PatientAdmissions.Where(a => a.AdminssionId == aid).FirstOrDefault(); if (x == null) { return(true); } else { return(false); } }
public patientRegWrapper postPat([FromBody] patientRegWrapper pr) { String msg = " "; hospitalsContext db = new hospitalsContext(); try { switch (pr.trans) { case 1: db.PatientRegistrations.Add(pr.PRW); db.SaveChanges(); msg = "ok"; break; case 2: var pat = db.PatientRegistrations.Where(a => a.PatientId == pr.PRW.PatientId).FirstOrDefault(); pat.PatientName = pr.PRW.PatientName; pat.Addr = pr.PRW.Addr; pat.City = pr.PRW.City; db.SaveChanges(); msg = "ok"; break; case 3: var ptd = db.PatientRegistrations.Where(a => a.PatientId == pr.PRW.PatientId).FirstOrDefault(); var add = db.PatientAdmissions.Where(a => a.Pos == 1).FirstOrDefault(); if (add == null) { db.PatientRegistrations.Remove(ptd); db.SaveChanges(); } else { msg = "in use"; } break; } } catch (Exception ee) { msg = ee.Message; } pr.result = msg; return(pr); }
public PatientRegWrapper getRegi([FromBody] PatientRegWrapper lc) { hospitalsContext db = new hospitalsContext(); String msg = ""; try { if (descision(lc.preg.PatientId)) { switch (lc.trans) { case 1: db.PatientRegistrations.Add(lc.preg); db.SaveChanges(); msg = "ok"; break; case 2: var ld = db.PatientRegistrations.Where(a => a.PatientId == lc.preg.PatientId).FirstOrDefault(); ld.PatientId = lc.preg.PatientId; ld.PatientName = lc.preg.PatientName; ld.Mobilenumber = lc.preg.Mobilenumber; ld.Addr = lc.preg.Addr; ld.City = lc.preg.City; db.SaveChanges(); msg = "ok"; break; case 3: var del = db.PatientRegistrations.Where(a => a.PatientId == lc.preg.PatientId).FirstOrDefault(); db.PatientRegistrations.Remove(del); db.SaveChanges(); msg = "OK"; break; } } else { msg = "not exists"; } } catch (Exception eee) { msg = eee.Message; } lc.result = msg; return(lc); }
public AdmissionWrapper getAdmissions([FromBody] AdmissionWrapper lc) { hospitalsContext db = new hospitalsContext(); String msg = ""; try { if (descision(lc.padmi.PatientId)) { switch (lc.trans) { case 1: db.PatientAdmissions.Add(lc.padmi); db.SaveChanges(); msg = "ok"; break; case 2: var ld = db.PatientAdmissions.Where(a => a.AdminssionId == lc.padmi.AdminssionId).FirstOrDefault(); ld.PatientId = lc.padmi.PatientId; ld.JoiningDate = lc.padmi.JoiningDate; ld.Roomno = lc.padmi.Roomno; ld.DailyAmt = lc.padmi.DailyAmt; db.SaveChanges(); msg = "ok"; break; case 3: var del = db.PatientAdmissions.Where(a => a.AdminssionId == lc.padmi.AdminssionId).FirstOrDefault(); db.PatientAdmissions.Remove(del); db.SaveChanges(); msg = "OK"; break; } } else { msg = "not exists"; } } catch (Exception eee) { msg = eee.Message; } lc.result = msg; return(lc); }
public LabscWrapper PostLabs([FromBody] LabscWrapper lc) { hospitalsContext db = new hospitalsContext(); String msg = ""; try { if (descision(lc.labs.AdminssionId)) { switch (lc.trans) { case 1: db.Labs.Add(lc.labs); db.SaveChanges(); msg = "ok"; break; case 2: var ld = db.Labs.Where(a => a.TestId == lc.labs.TestId).FirstOrDefault(); ld.Testname = lc.labs.Testname; ld.AdminssionId = lc.labs.AdminssionId; ld.LabAmt = lc.labs.LabAmt; ld.Dat = lc.labs.Dat; db.SaveChanges(); msg = "ok"; break; case 3: var lk = db.Labs.Where(a => a.TestId == lc.labs.TestId).FirstOrDefault(); db.Labs.Remove(lk); db.SaveChanges(); msg = "ok"; break; } } else { msg = "not exists"; } } catch (Exception eee) { msg = eee.Message; } lc.result = msg; return(lc); }
public ReceiptsWrapper PostReceiptscwrapper([FromBody] ReceiptsWrapper rw) { hospitalsContext db = new hospitalsContext(); string msg = ""; try { switch (rw.trans) { case 1: if (descision(rw.rec.AdminssionId)) { db.Receipts.Add(rw.rec); db.SaveChanges(); msg = "ok"; } else { msg = "not possible"; } break; case 2: var pat = db.Receipts.Where(a => a.ReceiptNo == rw.rec.ReceiptNo).FirstOrDefault(); pat.AdminssionId = rw.rec.AdminssionId; pat.Amt = rw.rec.Amt; pat.Dat = rw.rec.Dat; db.SaveChanges(); msg = "ok"; break; case 3: var ptd = db.Receipts.Where(a => a.ReceiptNo == rw.rec.ReceiptNo).FirstOrDefault(); db.Receipts.Remove(ptd); db.SaveChanges(); break; } } catch (Exception ee) { msg = ee.Message; } rw.result = msg; return(rw); }
public dispenswrapper getdispens([FromBody] dispenswrapper dis) { String msg = ""; hospitalsContext db = new hospitalsContext(); try { if () { switch (dis.trans) { case 1: db.Dispensary.Add(dis.dispensary); db.SaveChanges(); msg = "ok"; break; case 2: var du = db.Dispensary.Where(a => a.Billno == dis.dispensary.Billno).FirstOrDefault(); du.Dat = dis.dispensary.Dat; du.PatientId = dis.dispensary.PatientId; du.Patient = dis.dispensary.Patient; du.BillAmt = dis.dispensary.BillAmt; db.SaveChanges(); msg = "ok"; break; case 3: var dd = db.Dispensary.Where(a => a.Billno == dis.dispensary.Billno).FirstOrDefault(); db.Dispensary.Remove(dd); db.SaveChanges(); msg = "ok"; break; } } else { msg = "not exits"; } } catch (Exception ee) { msg = ee.Message; } return(dis); }
public Patientadminwrapper Postadmin([FromBody] Patientadminwrapper paw) { String msg = ""; hospitalsContext db = new hospitalsContext(); try { switch (paw.trans) { case 1: db.PatientAdmissions.Add(paw.ptad); db.SaveChanges(); msg = "ok"; break; case 2: var pu = db.PatientAdmissions.Where(a => a.AdminssionId == paw.ptad.AdminssionId).FirstOrDefault(); pu.ClosingDate = paw.ptad.ClosingDate; pu.JoiningDate = paw.ptad.JoiningDate; pu.Pos = paw.ptad.Pos; pu.Roomno = paw.ptad.Roomno; pu.DailyAmt = paw.ptad.DailyAmt; db.SaveChanges(); msg = "ok"; break; case 3: var pd = db.PatientAdmissions.Where(a => a.AdminssionId == paw.ptad.AdminssionId && a.Pos == 0).FirstOrDefault(); db.PatientAdmissions.Remove(pd); db.SaveChanges(); msg = "ok"; break; } } catch (Exception ee) { msg = ee.Message; } paw.result = msg; return(paw); }
public PatientLedgerInfoWrapper getBillingInfo(int admId) { try { hospitalsContext db = new hospitalsContext(); PatientLedgerInfoWrapper det = new PatientLedgerInfoWrapper(); List <PatientLedgerInfo> ledger = new List <PatientLedgerInfo>(); var joining = db.PatientAdmissions.Where(a => a.AdminssionId == admId).FirstOrDefault(); String patientname = ""; int? paid = 0; if (joining != null) { paid = joining.PatientId; patientname = db.PatientRegistrations.Where(a => a.PatientId == joining.PatientId).Select(b => b.PatientName).FirstOrDefault(); decimal days = Math.Ceiling((decimal)(DateTime.Now - joining.JoiningDate).Value.Days); var rent = (double)days * joining.DailyAmt; ledger.Add(new PatientLedgerInfo { pid = paid, pname = patientname, dat = DateTime.Now, account = "Room Rent", debit = (double)rent, credit = 0 }); ledger.AddRange((from a in db.Consultations.Where(a => a.AdminssionId == admId) select new PatientLedgerInfo { pid = paid, pname = patientname, dat = (DateTime)a.Dat, account = "Consultation Charges of " + a.DrName, debit = (double)a.ConsultationAmt, credit = 0 } ).ToList()); ledger.AddRange((from a in db.Labs.Where(a => a.AdminssionId == admId) select new PatientLedgerInfo { pid = paid, pname = patientname, dat = (DateTime)a.Dat, account = "Lab Charges of " + a.Testname, debit = (double)a.LabAmt, credit = 0 } ).ToList()); ledger.AddRange((from a in db.Dispensary.Where(a => a.AdminssionId == admId) select new PatientLedgerInfo { pid = paid, pname = patientname, dat = (DateTime)a.Dat, account = "Medicine Charges ", debit = (double)a.BillAmt, credit = 0 } ).ToList()); ledger.AddRange((from a in db.Receipts.Where(a => a.AdminssionId == admId) select new PatientLedgerInfo { pid = paid, pname = patientname, dat = (DateTime)a.Dat, account = "Receipt amount", debit = 0, credit = (double)a.Amt } ).ToList()); det.ledger = ledger.OrderBy(a => a.dat).ToList(); det.balanceAmt = ledger.Sum(a => a.debit - a.credit); } else { det = null; } return(det); } catch (Exception ee) { return(null); } }
public IQueryable <Dispensary> getd(int str) { hospitalsContext db = new hospitalsContext(); return(db.Dispensary.Where(a => a.Billno == str)); }
public List <PatientRegistrations> GetPatients(String pname) { hospitalsContext db = new hospitalsContext(); return(db.PatientRegistrations.Where(a => a.PatientName.Contains(pname) || a.PatientName.Contains(pname) || a.Mobilenumber.Contains(pname)).ToList()); }
public IQueryable <Consultations> getConsultancy(int coid) { hospitalsContext db = new hospitalsContext(); return(db.Consultations.Where(a => a.ConsultationId == coid)); }
public List <Labs> getl() { hospitalsContext db = new hospitalsContext(); return(db.Labs.ToList()); }
public IQueryable <Receipts> GetReceipts(int str) { hospitalsContext db = new hospitalsContext(); return(db.Receipts.Where(a => a.ReceiptNo == str)); }