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.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.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.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(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.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.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.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.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.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.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.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.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);
}
public static System.Collections.Specialized.StringCollection GetGroups()
{
System.Collections.Specialized.StringCollection r = new System.Collections.Specialized.StringCollection();
using (SqlDataReader dr = AppDAL.EntityGroupSelectAll())
{
if (dr != null)
{
string str = string.Empty;
while (dr.Read())
{
str = AppShared.DbValueToString(dr[Entity.Columns.GroupName]);
if (!string.IsNullOrEmpty(str))
{
r.Add(str);
}
}
}
}
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.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);
}