internal override bool Populate(SqlDataReader dr) { bool r = false; if (dr != null && AppShared.IsNotNull(dr[Columns.OPDInvestigationProcedureGuid])) { this.mId = AppShared.DbValueToInteger(dr[Columns.OPDInvestigationProcedureId]); this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.OPDInvestigationProcedureGuid]); this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.OPDInvestigationProcedurePatientGuid]); this.mRadiologyInvestigation = AppShared.DbValueToString(dr[Columns.RadiologyInvestigation]); this.mSpecialInvestigation = AppShared.DbValueToString(dr[Columns.SpecialInvestigation]); this.mOPDInvestigationProcedureDate = AppShared.DbValueToDateTime(dr[Columns.OPDInvestigationProcedureDate]); if (AppShared.HasColumn(dr, "MainInvestigation")) { this.mMainInvestigation = AppShared.DbValueToString(dr[Columns.MainInvestigation]); } if (AppShared.HasColumn(dr, "LabInvestigation")) { this.mLabInvestigation = AppShared.DbValueToString(dr[Columns.LabInvestigation]); } this.Status = ObjectStatus.Opened; r = true; } else { this.Reset(); } return(r); }
internal override bool Populate(SqlDataReader dr) { bool r = false; if (dr != null && AppShared.IsNotNull(dr[Columns.OPDPrescriptionProcedureGuid])) { this.mId = AppShared.DbValueToInteger(dr[Columns.OPDPrescriptionId]); this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.OPDPrescriptionProcedureGuid]); this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.OPDPrescriptionPatientGuid]); this.mDoseage = AppShared.DbValueToString(dr[Columns.Doseage]); this.mTimings = AppShared.DbValueToString(dr[Columns.Timings]); this.OPDPrescriptionDate = AppShared.DbValueToDateTime(dr[Columns.OPDPrescriptionDate]); if (AppShared.HasColumn(dr, "Medicine")) { this.mMedicine = AppShared.DbValueToString(dr[Columns.Medicine]); } this.Status = ObjectStatus.Opened; r = true; } else { this.Reset(); } return(r); }
internal override bool Populate(SqlDataReader dr) { bool r = false; if (dr != null && AppShared.IsNotNull(dr[Columns.PatientMedicineSaleGuid])) { this.mId = AppShared.DbValueToInteger(dr[Columns.PatientMedicineSaleId]); this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.PatientMedicineSaleGuid]); this.mBillGuid = AppShared.DbValueToGuid(dr[Columns.PatientMedicineSalePatientBillGuid]); this.mCategoryGuid = AppShared.DbValueToGuid(dr[Columns.PatientMedicineSaleCategoryGuid]); this.mCompanyGuid = AppShared.DbValueToGuid(dr[Columns.PatientMedicineSaleCompanyGuid]); this.mItemGuid = AppShared.DbValueToGuid(dr[Columns.PatientMedicineSaleItemGuid]); this.mQuantity = AppShared.DbValueToDecimal(dr[Columns.PatientMedicineSaleQuantity]); this.mAmount = AppShared.DbValueToDecimal(dr[Columns.PatientMedicineSaleAmount]); this.mNote = AppShared.DbValueToString(dr[Columns.PatientMedicineSaleNote]); if (AppShared.HasColumn(dr, "SrNo")) { this.mSrNo = AppShared.DbValueToString(dr[Columns.SrNo].ToString()); } this.Status = ObjectStatus.Opened; r = true; } else { this.Reset(); } return(r); }
internal override bool Populate(SqlDataReader dr) { bool r = false; if (dr != null && AppShared.IsNotNull(dr[Columns.IPDPatientTreatmentSheetDetailsGuid])) { this.mId = AppShared.DbValueToInteger(dr[Columns.IPDPatientTreatmentSheetDetailsId]); this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.IPDPatientTreatmentSheetDetailsGuid]); this.mIPDPatientTreatmentSheetGuid = AppShared.DbValueToGuid(dr[Columns.IPDPatientTreatmentSheetDetailsTreatmentSheetGuid]); this.mIpdPatientTreatmentSheetDetailsPatientGuid = AppShared.DbValueToGuid(dr[Columns.IPDPatientTreatmentSheetDetailsPatientGuid]); this.mDescription = AppShared.DbValueToString(dr[Columns.IPDPatientTreatmentSheetDetailsDescription]); this.mMorningTime = AppShared.DbValueToString(dr[Columns.IPDPatientTreatmentSheetDetailsMorningTime]); this.mNoonTime = AppShared.DbValueToString(dr[Columns.IPDPatientTreatmentSheetDetailsNoonTime]); this.EveningTime = AppShared.DbValueToString(dr[Columns.IPDPatientTreatmentSheetDetailsEveningTime]); this.NightTime = AppShared.DbValueToString(dr[Columns.IPDPatientTreatmentSheetDetailsNightTime]); if (AppShared.HasColumn(dr, "SrNo")) { this.mSrNo = AppShared.DbValueToString(dr[Columns.SrNo].ToString()); } this.Status = ObjectStatus.Opened; r = true; } else { this.Reset(); } return(r); }
internal override bool Populate(SqlDataReader dr) { bool r = false; if (dr != null && AppShared.IsNotNull(dr[Columns.HistoryProcedurePatientGuid])) { this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.HistoryProcedureGuid]); this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.HistoryProcedurePatientGuid]); this.mProblemSince = AppShared.DbValueToString(dr[Columns.ProblemSince]); this.mDate = AppShared.DbValueToDateTime(dr[Columns.Date]); this.mFamilyHistory = AppShared.DbValueToString(dr[Columns.FamilyHistory]); this.mAssociateComplainDuration = AppShared.DbValueToString(dr[Columns.AssociateComplainDuration]); this.mFamilyHistoryDuration = AppShared.DbValueToString(dr[Columns.FamilyHistoryDuration]); this.mBP = AppShared.DbValueToString(dr[Columns.BP]); this.mHR = AppShared.DbValueToString(dr[Columns.HR]); this.mRR = AppShared.DbValueToString(dr[Columns.RR]); this.mTemp = AppShared.DbValueToString(dr[Columns.Temp]); this.mECG = AppShared.DbValueToString(dr[Columns.ECG]); this.mRBS = AppShared.DbValueToString(dr[Columns.RBS]); this.mWt = AppShared.DbValueToString(dr[Columns.Wt]); this.mOther = AppShared.DbValueToString(dr[Columns.Other]); this.mMLCNo = AppShared.DbValueToString(dr[Columns.MLCNo]); this.mFollowUpDate = AppShared.DbValueToDateTime(dr[Columns.FollowUpDate]); this.mTimeHour = AppShared.DbValueToString(dr[Columns.TimeHour]); this.mTimeMinute = AppShared.DbValueToString(dr[Columns.TimeMinute]); this.mTimeAMPM = AppShared.DbValueToString(dr[Columns.TimeAMPM]); if (AppShared.HasColumn(dr, "History")) { this.mHistory = AppShared.DbValueToString(dr[Columns.History]); } if (AppShared.HasColumn(dr, "ChiefComplain")) { this.mChiefComplain = AppShared.DbValueToString(dr[Columns.ChiefComplain]); } if (AppShared.HasColumn(dr, "AssociateComplain")) { this.mAssociateComplain = AppShared.DbValueToString(dr[Columns.AssociateComplain.ToString()]); } this.Status = ObjectStatus.Opened; r = true; } return(r); }
internal override bool Populate(SqlDataReader dr) { bool r = false; if (dr != null && AppShared.IsNotNull(dr[Columns.OPDTreatmentProcedureGuid])) { this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.OPDTreatmentProcedureGuid]); this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.OPDTreatmentProcedurePatientGuid]); this.mOPDTreatmentDate = AppShared.DbValueToDateTime(dr[Columns.OPDTreatmentDate]); if (AppShared.HasColumn(dr, "Treatment")) { this.mTreatment = AppShared.DbValueToString(dr[Columns.Treatment]); } this.Status = ObjectStatus.Opened; r = true; } else { this.Reset(); } return(r); }