internal static bool ChangePassword(Guid userGuid, string oldPassword, string newPassword)
{
bool r = false;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(User_ChangePassword))
{
AppDatabase.AddInParameter(cmd, "@UserGuid", SqlDbType.UniqueIdentifier, userGuid);
AppDatabase.AddInParameter(cmd, "@UserOldPassword", SqlDbType.NVarChar, oldPassword);
AppDatabase.AddInParameter(cmd, "@UserNewPassword", SqlDbType.NVarChar, newPassword);
SqlParameter prmSucess = AppDatabase.AddOutParameter(cmd, "@IsSuccess", SqlDbType.Bit);
AppDatabase db = OpenDatabase();
r = db != null && db.ExecuteCommand(cmd) && AppShared.DbValueToBoolean(prmSucess.Value);
}
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 static bool CheckUsernameAvailibity(string userName, Guid excludeGuid)
{
bool r = false;
if (userName != string.Empty)
{
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(User_CheckName))
{
AppDatabase.AddInParameter(cmd, "@Username", SqlDbType.NVarChar, userName);
AppDatabase.AddInParameter(cmd, "@ExcludeGuid", SqlDbType.UniqueIdentifier, AppShared.ToDbValueNullable(excludeGuid));
SqlParameter prmAvailable = AppDatabase.AddOutParameter(cmd, "@IsAvailable", SqlDbType.Bit);
AppDatabase db = OpenDatabase();
if (db != null && db.ExecuteCommand(cmd))
{
r = AppShared.DbValueToBoolean(prmAvailable.Value);
}
}
}
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.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);
}