예제 #1
0
        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);
        }
예제 #2
0
        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);
        }
예제 #3
0
        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);
        }