internal override bool Populate(SqlDataReader dr)
{
bool r = false;
if (dr != null && AppShared.IsNotNull(dr[Columns.WardGuid]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.WardId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.WardGuid]);
this.mName = AppShared.DbValueToString(dr[Columns.WardName]);
this.mDescription = AppShared.DbValueToString(dr[Columns.WardDescription]);
//this.mCreatedBy = AppShared.DbValueToString(dr[Columns.UserCreatedBy]);
this.mCreatedByUser = AppShared.DbValueToGuid(dr[Columns.WardCreatedBy]);
this.mCreatedOn = AppShared.DbValueToDateTime(dr[Columns.WardCreatedOn]);
//this.mModifiedBy = AppShared.DbValueToString(dr[Columns.UserModifiedBy]);
this.mModifiedByUser = AppShared.DbValueToGuid(dr[Columns.WardModifiedBy]);
this.mModifiedOn = AppShared.DbValueToDateTime(dr[Columns.WardModifiedOn]);
this.Status = ObjectStatus.Opened;
r = true;
}
else
{
this.Reset();
}
return(r);
}
internal override bool Populate(System.Data.SqlClient.SqlDataReader dr)
{
bool r = false;
if (dr != null && AppShared.IsNotNull(dr[Columns.Id]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.Id]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.Guid]);
this.mCaption = AppShared.DbValueToString(dr[Columns.Caption]);
this.mGroupName = AppShared.DbValueToString(dr[Columns.GroupName]);
this.mIconLarge = AppShared.DbValueToBytes(dr, Columns.IconLarge);
this.mIconSmall = AppShared.DbValueToBytes(dr, Columns.IconSmall);
this.mListCaption = AppShared.DbValueToString(dr[Columns.ListCaption]);
this.mListTypeName = AppShared.DbValueToString(dr[Columns.ListTypeName]);
this.mName = AppShared.DbValueToString(dr[Columns.Name]);
this.mTypeName = AppShared.DbValueToString(dr[Columns.TypeName]);
this.mDescription = AppShared.DbValueToString(dr[Columns.Desc]);
this.mCreatedByUser = AppShared.DbValueToGuid(dr[Columns.CreatedBy]);
this.mCreatedOn = AppShared.DbValueToDateTime(dr[Columns.CreatedOn]);
this.mModifiedByUser = AppShared.DbValueToGuid(dr[Columns.ModifiedBy]);
this.mModifiedOn = AppShared.DbValueToDateTime(dr[Columns.ModifiedOn]);
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.PatientProcedureId]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.PatientProcedureId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.PatientProcedureGuid]);
this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.PatietProcedurePatientGuid]);
this.mProcedureGuid = AppShared.DbValueToGuid(dr[Columns.PatientProcedureProcedureGuid]);
this.mProcedureDate = AppShared.DbValueToDateTime(dr[Columns.PatientProcedureDate]);
this.mAmount = AppShared.DbValueToDecimal(dr[Columns.PatientProcedureAmount]);
this.mNotes = AppShared.DbValueToString(dr[Columns.PatientProcedureNotes]);
this.mCreatedByUser = AppShared.DbValueToGuid(dr[Columns.PatientProcedureCreatedBy]);
this.mCreatedOn = AppShared.DbValueToDateTime(dr[Columns.PatientProcedureCreatedOn]);
this.mModifiedByUser = AppShared.DbValueToGuid(dr[Columns.PatientProcedureModifiedBy]);
this.mModifiedOn = AppShared.DbValueToDateTime(dr[Columns.PatientProcedureModifiedOn]);
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.PatientVitalGuid]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.PatientVitalId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.PatientVitalGuid]);
this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.PatientVitalPatientGuid]);
this.mDate = AppShared.DbValueToDateTime(dr[Columns.PatientVitalDate]);
this.mTime = AppShared.DbValueToString(dr[Columns.PatientVitalTime]);
this.mBP = AppShared.DbValueToString(dr[Columns.PatientVitalBP]);
this.mHR = AppShared.DbValueToString(dr[Columns.PatientVitalHR]);
this.mRR = AppShared.DbValueToString(dr[Columns.PatientVitalRR]);
this.mTemp = AppShared.DbValueToString(dr[Columns.PatientVitalTemp]);
this.mRBS = AppShared.DbValueToString(dr[Columns.PatientVitalRBS]);
this.mECG = AppShared.DbValueToString(dr[Columns.PatientVitalECG]);
this.mWeight = AppShared.DbValueToString(dr[Columns.PatientVitalWeight]);
this.mHeight = AppShared.DbValueToString(dr[Columns.PatientVitalHeight]);
this.mOther = AppShared.DbValueToString(dr[Columns.PatientVitalOther]);
this.mSPO2 = AppShared.DbValueToString(dr[Columns.PatientVitalSPO2]);
this.mPULSE = AppShared.DbValueToString(dr[Columns.PatientVitalPULSE]);
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.MedicinePurchaseGuid]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.MedicinePurchaseId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.MedicinePurchaseGuid]);
this.mCategoryGuid = AppShared.DbValueToGuid(dr[Columns.MedicinePurchaseCategoryGuid]);
this.mCompanyGuid = AppShared.DbValueToGuid(dr[Columns.MedicinePurchaseCompanyGuid]);
this.mItemGuid = AppShared.DbValueToGuid(dr[Columns.MedicinePurchaseItemGuid]);
this.mBillType = AppShared.DbValueToString(dr[Columns.MedicinePurchaseBillType]);
this.mQuantity = AppShared.DbValueToInteger(dr[Columns.MedicinePurchaseQuantity]);
this.mWholesaleRate = AppShared.DbValueToDecimal(dr[Columns.MedicinePurchaseWholesaleRate]);
this.mAmount = AppShared.DbValueToDecimal(dr[Columns.MedicinePurchaseAmount]);
this.mExpiryDate = AppShared.DbValueToDateTime(dr[Columns.MedicinePurchaseExpiryDate]);
this.mMRP = AppShared.DbValueToDecimal(dr[Columns.MedicinePurchaseMRP]);
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.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 static byte[] DbValueToBytes(SqlDataReader dr, string columnName)
{
byte[] r = null;
int ordinal = dr.GetOrdinal(columnName);
if (AppShared.IsNotNull(dr[ordinal]))
{
System.Data.SqlTypes.SqlBytes sqlData = dr.GetSqlBytes(ordinal);
r = sqlData.Value;
}
return(r);
}
internal override bool Populate(SqlDataReader dr)
{
bool r = false;
if (dr != null && AppShared.IsNotNull(dr[Columns.BillId]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.BillId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.BillGuid]);
this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.PatientGuid]);
this.mPatientBillDate = AppShared.DbValueToDateTime(dr[Columns.BillDate]);
this.mOther = AppShared.DbValueToString(dr[Columns.BillOther]);
this.Status = ObjectStatus.Opened;
r = true;
}
return(r);
}
internal override bool Populate(SqlDataReader dr)
{
bool r = false;
if (dr != null && AppShared.IsNotNull(dr[Columns.OPDPrescriptionProcedurePatientGuid]))
{
this.mPrescriptionProcedureGuid = AppShared.DbValueToGuid(dr[Columns.OPDPrescriptionProcedureGuid]);
this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.OPDPrescriptionProcedurePatientGuid]);
this.mMedicineGuid = AppShared.DbValueToGuid(dr[Columns.OPDPrescriptionProcedureMedicineGuid]);
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.OPDHistoryProcedurePatientGuid]))
{
this.mHistoryProcedureGuid = AppShared.DbValueToGuid(dr[Columns.OPDHistoryProcedureGuid]);
this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.OPDHistoryProcedurePatientGuid]);
this.mChiefComplainGuid = AppShared.DbValueToGuid(dr[Columns.OPDHistoryProcedureChiefComplain]);
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.TreatmentSheetId]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.TreatmentSheetId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.TreatmentSheetGuid]);
this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.TreatmentSheetPatientGuid]);
this.mDiatAdvice = AppShared.DbValueToString(dr[Columns.TreatmentSheetDiatAdvice]);
this.mSpecialAdvice = AppShared.DbValueToString(dr[Columns.TreatmentSheetSpecialAdvice]);
this.mSOSDrug = AppShared.DbValueToString(dr[Columns.TreatmentSheetSOSDrug]);
this.mSheetDate = AppShared.DbValueToDateTime(dr[Columns.TreatmentSheetDate]);
this.Status = ObjectStatus.Opened;
r = true;
}
return(r);
}
internal override bool Populate(System.Data.SqlClient.SqlDataReader dr)
{
bool r = false;
if (dr != null && AppShared.IsNotNull(dr[Columns.Id]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.Id]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.Guid]);
this.mName = AppShared.DbValueToString(dr[Columns.Name]);
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.LabInvestigationGuid]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.LabInvestigationId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.LabInvestigationGuid]);
this.mName = AppShared.DbValueToString(dr[Columns.LabInvestigationName]);
this.mDescription = AppShared.DbValueToString(dr[Columns.LabInvestigationDescription]);
this.mCreatedByUser = AppShared.DbValueToGuid(dr[Columns.LabInvestigationCreatedBy]);
this.mCreatedOn = AppShared.DbValueToDateTime(dr[Columns.LabInvestigationCreatedOn]);
this.mModifiedByUser = AppShared.DbValueToGuid(dr[Columns.LabInvestigationModifiedBy]);
this.mModifiedOn = AppShared.DbValueToDateTime(dr[Columns.LabInvestigationModifiedOn]);
this.Status = ObjectStatus.Opened;
r = true;
}
return(r);
}
internal override bool Populate(SqlDataReader dr)
{
bool r = false;
if (dr != null && AppShared.IsNotNull(dr[Columns.CategoryGuid]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.CategoryId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.CategoryGuid]);
this.mCategoryName = AppShared.DbValueToString(dr[Columns.CategoryName]);
this.mCreatedDate = AppShared.DbValueToDateTime(dr[Columns.CategoryCreatedDate]);
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.PatientGuid]))
{
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.AppointmentGuid]);
this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.PatientGuid]);
this.mAppointmentDate = AppShared.DbValueToDateTime(dr[Columns.AppointmentDate]);
this.mAppointmentDescription = AppShared.DbValueToString(dr[Columns.AppointmentDescription]);
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.PermissionUserRoleGuid]) && AppShared.IsNotNull(dr[Columns.PermisionFieldGuid]))
{
this.mUserRoleGuid = AppShared.DbValueToGuid(dr[Columns.PermissionUserRoleGuid]);
this.mFieldGuid = AppShared.DbValueToGuid(dr[Columns.PermisionFieldGuid]);
this.mCanView = AppShared.DbValueToBoolean(dr[Columns.PermissionCanView]);
this.mCreatedByUser = AppShared.DbValueToGuid(dr[Columns.PermissionCreatedBy]);
this.mModifiedByUser = AppShared.DbValueToGuid(dr[Columns.PermissionModifiedBy]);
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.UserGuid]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.UserId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.UserGuid]);
this.mName = AppShared.DbValueToString(dr[Columns.UserName]);
this.mLoginName = AppShared.DbValueToString(dr[Columns.UserLoginName]);
this.mUserRoleGuid = AppShared.DbValueToGuid(dr[Columns.UserRoleGuid]);
this.mPassword = AppShared.DbValueToString(dr[Columns.UserPassword]);
this.mAddressLine1 = AppShared.DbValueToString(dr[Columns.UserAddressLine1]);
this.mAddressLine2 = AppShared.DbValueToString(dr[Columns.UserAddressLine2]);
this.mAddressLine3 = AppShared.DbValueToString(dr[Columns.UserAddressLine3]);
this.mPhoneNo = AppShared.DbValueToString(dr[Columns.UserPhoneNo]);
this.mMobileNo = AppShared.DbValueToString(dr[Columns.UserMobileNo]);
this.mPhoto = AppShared.DbValueToBytes(dr, Columns.UserPhoto);
this.mWindowsUserName = AppShared.DbValueToString(dr[Columns.UserWindowsUserName]);
// this.mIsBlocked = AppShared.DbValueToBoolean(dr[Columns.UserIsDisable]);
this.mIsDisabled = AppShared.DbValueToBoolean(dr[Columns.UserIsDisable]);
this.mDescription = AppShared.DbValueToString(dr[Columns.UserDesc]);
this.mDoctorShare = AppShared.DbValueToDecimal(dr[Columns.DoctorShare]);
this.mCreatedByUser = AppShared.DbValueToGuid(dr[Columns.UserCreatedBy]);
this.mCreatedOn = AppShared.DbValueToDateTime(dr[Columns.UserCreatedOn]);
this.mModifiedByUser = AppShared.DbValueToGuid(dr[Columns.UserModifiedBy]);
this.mModifiedOn = AppShared.DbValueToDateTime(dr[Columns.UserModifiedOn]);
//dr.GetBytes(dr.GetOrdinal(Columns.UserRowStamp), 0, this.mRowStamp, 0, 8);
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.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);
}
internal override bool Populate(SqlDataReader dr)
{
bool r = false;
if (dr != null && AppShared.IsNotNull(dr[Columns.MedicineGuid]))
{
this.mId = AppShared.DbValueToInteger(dr[Columns.MedicineId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.MedicineGuid]);
this.mCategoryGuid = AppShared.DbValueToGuid(dr[Columns.MedicineCategoryGuid]);
this.mCompanyGuid = AppShared.DbValueToGuid(dr[Columns.MedicineCompanyGuid]);
this.mItemGuid = AppShared.DbValueToGuid(dr[Columns.MedicineItemGuid]);
this.mCurrentStock = AppShared.DbValueToInteger(dr[Columns.MedicineCurrentStock]);
this.mReOrderLevel = AppShared.DbValueToInteger(dr[Columns.MedicineReOrderLevel]);
this.mCreatedDate = AppShared.DbValueToDateTime(dr[Columns.MedicineCreatedDate]);
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.PermissionUserRoleGuid]) && AppShared.IsNotNull(dr[Columns.PermissionEntityGuid]))
{
this.mUserRoleGuid = AppShared.DbValueToGuid(dr[Columns.PermissionUserRoleGuid]);
this.mEntityGuid = AppShared.DbValueToGuid(dr[Columns.PermissionEntityGuid]);
this.mCanView = AppShared.DbValueToBoolean(dr[Columns.PermissionCanView]);
this.mCanCreate = AppShared.DbValueToBoolean(dr[Columns.PermissionCanCreate]);
this.mCanEdit = AppShared.DbValueToBoolean(dr[Columns.PermissionCanEdit]);
this.mCanDelete = AppShared.DbValueToBoolean(dr[Columns.PermissionCanDelete]);
this.mCanSpecial = AppShared.DbValueToBoolean(dr[Columns.PermissionCanSpecial]);
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.IPDPatientTreatmentPatientGuid]))
{
//this.mId = AppShared.DbValueToInteger(dr[Columns.IPDPatientTreatmentId]);
//this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.IPDPatientTreatmentGuid]);
this.mPatientGuid = AppShared.DbValueToGuid(dr[Columns.IPDPatientTreatmentPatientGuid]);
this.mTreatmentGuid = AppShared.DbValueToGuid(dr[Columns.IPDPatientTreatmentTreatmentGuid]);
this.mCreatedByUser = AppShared.DbValueToGuid(dr[Columns.IPDPatientTreatmentCreatedBy]);
this.mCreatedOn = AppShared.DbValueToDateTime(dr[Columns.IPDPatientTreatmentCreatedOn]);
this.mModifiedByUser = AppShared.DbValueToGuid(dr[Columns.IPDPatientTreatmentModifiedBy]);
this.mModifiedOn = AppShared.DbValueToDateTime(dr[Columns.IPDPatientTreatmentModifiedOn]);
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.UserRoleGuid]))
{
this.mUserRoleId = AppShared.DbValueToInteger(dr[Columns.UserRoleId]);
this.mObjectGuid = AppShared.DbValueToGuid(dr[Columns.UserRoleGuid]);
this.mUserRoleName = AppShared.DbValueToString(dr[Columns.UserRoleName]);
this.mUserRoleLevel = AppShared.DbValueToInteger(dr[Columns.UserRoleLevel]);
this.mUserRoleDesc = AppShared.DbValueToString(dr[Columns.UserRoleDesc]);
this.mCreatedByUser = AppShared.DbValueToGuid(dr[Columns.UserRoleCreatedBy]);
this.mCreatedOn = AppShared.DbValueToDateTime(dr[Columns.UserRoleCreatedOn]);
this.mModifiedByUser = AppShared.DbValueToGuid(dr[Columns.UserRoleModifiedBy]);
this.mModifiedOn = AppShared.DbValueToDateTime(dr[Columns.UserRoleModifiedOn]);
this.Status = ObjectStatus.Opened;
r = true;
}
else
{
this.Reset();
}
return(r);
}