public DateTime?GetDischargeDetailsByPatientId(int AdmitId)
{
DateTime?dt = null;
try
{
tblDischarge objtblDischarge = (from tbl in objData.tblDischarges
where tbl.IsDelete == false &&
tbl.PatientId == AdmitId
select tbl).FirstOrDefault();
if (objtblDischarge != null)
{
dt = objtblDischarge.DischargeReceiptDate;
}
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public int Save(EntityMakeDischarge entDischarge)
{
tblDischarge tbl = new tblDischarge()
{
PatientId = entDischarge.PatientId,
TypeOfDischarge = entDischarge.TypeOfDischarge,
Diagnosis = entDischarge.Diagnosis,
NameOfSurgery = entDischarge.Surgery,
HistoryClinical = entDischarge.HistoryClinical,
XRay = entDischarge.XRay,
USG = entDischarge.USG,
Others = entDischarge.Others,
OperativeNotes = entDischarge.OperativeNotes,
TreatmentInHospitalisation = entDischarge.TreatmentInHospitalisation,
TreatmentOnDischarge = entDischarge.TreatmentOnDischarge,
FollowUp = entDischarge.FollowUp,
DischargeReceiptDate = entDischarge.DischargeReceiptDate,
HB = entDischarge.HB,
TLC = entDischarge.TLC,
PLC = entDischarge.PLC,
BUL = entDischarge.BUL,
Creat = entDischarge.Creat,
SE = entDischarge.SE,
BSL = entDischarge.BSL,
PP = entDischarge.PP,
R = entDischarge.R,
Urine = entDischarge.Urine,
HIV = entDischarge.HIV,
HBSAG = entDischarge.HBSAG,
IsDelete = false
};
objData.tblDischarges.InsertOnSubmit(tbl);
objData.SubmitChanges();
return(1);
}
public int Update(EntityMakeDischarge entDischarge, int DischargeID)
{
tblDischarge obj = new tblDischarge();
obj = (from tbl in objData.tblDischarges
where tbl.DichargeId.Equals(DischargeID) &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
obj.TypeOfDischarge = entDischarge.TypeOfDischarge;
obj.Diagnosis = entDischarge.Diagnosis;
obj.NameOfSurgery = entDischarge.Surgery;
obj.HistoryClinical = entDischarge.HistoryClinical;
obj.XRay = entDischarge.XRay;
obj.USG = entDischarge.USG;
obj.Others = entDischarge.Others;
obj.OperativeNotes = entDischarge.OperativeNotes;
obj.TreatmentInHospitalisation = entDischarge.TreatmentInHospitalisation;
obj.TreatmentOnDischarge = entDischarge.TreatmentOnDischarge;
obj.FollowUp = entDischarge.FollowUp;
obj.DischargeReceiptDate = entDischarge.DischargeReceiptDate;
obj.HB = entDischarge.HB;
obj.TLC = entDischarge.TLC;
obj.PLC = entDischarge.PLC;
obj.BUL = entDischarge.BUL;
obj.Creat = entDischarge.Creat;
obj.SE = entDischarge.SE;
obj.BSL = entDischarge.BSL;
obj.PP = entDischarge.PP;
obj.R = entDischarge.R;
obj.Urine = entDischarge.Urine;
obj.HIV = entDischarge.HIV;
obj.HBSAG = entDischarge.HBSAG;
objData.SubmitChanges();
return(1);
}