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