public void InitializeMapParameters(Session <Entity.NullT> session, ref Server.Data.SqlService service)
{
//Map the command...
service.SqlProcedure = UserMap.Names.selectCommand;
//Map the parameters...
APLPX.Server.Data.SqlServiceParameter[] parameters =
{
new SqlServiceParameter(UserMap.Names.sqlSession, SqlDbType.VarChar, 50, ParameterDirection.Input, session.SqlKey), //Shared client key
new SqlServiceParameter(UserMap.Names.sqlMessage, SqlDbType.VarChar, 500, ParameterDirection.InputOutput, UserMap.Names.initializeMessage)
}; service.sqlParameters.List = parameters;
}
public void LoadListMapParameters(Session <List <Entity.User> > session, ref Server.Data.SqlService service)
{
//Map the command...
service.SqlProcedure = UserMap.Names.selectCommand;
//Map the parameters...
APLPX.Server.Data.SqlServiceParameter[] parameters =
{
new SqlServiceParameter(UserMap.Names.sqlSession, SqlDbType.VarChar, 50, ParameterDirection.Input, session.SqlKey), //session key
new SqlServiceParameter(UserMap.Names.sqlMessage, SqlDbType.VarChar, 500, ParameterDirection.InputOutput, UserMap.Names.loadIdentitiesMessage)
}; service.sqlParameters.List = parameters;
}
public void AuthenticateMapParameters(Session <Entity.NullT> session, ref Server.Data.SqlService service)
{
//Map the command...
service.SqlProcedure = UserMap.Names.selectCommand;
String authenticateMessage = (session.SqlAuthorization) ? UserMap.Names.authenticateSqlUserMessage : ((session.WinAuthorization) ? UserMap.Names.authenticateWinUserMessage : String.Empty);
//Map the parameters...
APLPX.Server.Data.SqlServiceParameter[] parameters =
{
new SqlServiceParameter(UserMap.Names.login, SqlDbType.VarChar, 100, ParameterDirection.Input, session.User.Credential.Login),
new SqlServiceParameter(UserMap.Names.password, SqlDbType.VarChar, 100, ParameterDirection.Input, session.User.Credential.OldPassword),
new SqlServiceParameter(UserMap.Names.sqlSession, SqlDbType.VarChar, 50, ParameterDirection.Input, session.SqlKey), //Tenant private client key
new SqlServiceParameter(UserMap.Names.sqlMessage, SqlDbType.VarChar, 500, ParameterDirection.InputOutput, authenticateMessage)
}; service.sqlParameters.List = parameters;
}
public void SavePasswordMapParameters(Session <Entity.NullT> session, ref Server.Data.SqlService service)
{
//Map the command...
service.SqlProcedure = UserMap.Names.updateCommand;
//Map the parameters...
APLPX.Server.Data.SqlServiceParameter[] parameters =
{
new SqlServiceParameter(UserMap.Names.login, SqlDbType.VarChar, 100, ParameterDirection.Input, session.User.Credential.Login),
new SqlServiceParameter(UserMap.Names.password, SqlDbType.VarChar, 100, ParameterDirection.Input, session.User.Credential.NewPassword),
new SqlServiceParameter(UserMap.Names.oldPassword, SqlDbType.VarChar, 100, ParameterDirection.Input, session.User.Credential.OldPassword),
new SqlServiceParameter(UserMap.Names.sqlSession, SqlDbType.VarChar, 50, ParameterDirection.Input, session.SqlKey), //logged in user session key
new SqlServiceParameter(UserMap.Names.sqlMessage, SqlDbType.VarChar, 500, ParameterDirection.InputOutput, UserMap.Names.savePasswordMessage)
}; service.sqlParameters.List = parameters;
}
public void SaveUserMapParameters(Session <Entity.User> session, ref Server.Data.SqlService service)
{
//Map the command...
Int16 insertId = 0;
service.SqlProcedure = UserMap.Names.updateCommand;
String updateCommandMessage = (session.Data.Id == insertId) ? UserMap.Names.saveIdentityInsertMessage : UserMap.Names.saveIdentityUpdateMessage;
//Map the parameters...
APLPX.Server.Data.SqlServiceParameter[] parameters =
{
new SqlServiceParameter(UserMap.Names.id, SqlDbType.Int, 0, ParameterDirection.Input, session.Data.Id.ToString()),
new SqlServiceParameter(UserMap.Names.roleId, SqlDbType.Int, 0, ParameterDirection.Input, session.Data.Role.Id.ToString()),
new SqlServiceParameter(UserMap.Names.login, SqlDbType.VarChar, 100, ParameterDirection.Input, session.Data.Credential.Login),
new SqlServiceParameter(UserMap.Names.firstName, SqlDbType.VarChar, 100, ParameterDirection.Input, session.Data.Identity.FirstName),
new SqlServiceParameter(UserMap.Names.lastName, SqlDbType.VarChar, 100, ParameterDirection.Input, session.Data.Identity.LastName),
new SqlServiceParameter(UserMap.Names.email, SqlDbType.VarChar, 100, ParameterDirection.Input, session.Data.Identity.Email),
new SqlServiceParameter(UserMap.Names.password, SqlDbType.VarChar, 100, ParameterDirection.Input, session.Data.Credential.NewPassword),
new SqlServiceParameter(UserMap.Names.oldPassword, SqlDbType.VarChar, 100, ParameterDirection.Input, session.Data.Credential.OldPassword),
new SqlServiceParameter(UserMap.Names.sqlSession, SqlDbType.VarChar, 50, ParameterDirection.Input, session.SqlKey), //logged on user session key
new SqlServiceParameter(UserMap.Names.sqlMessage, SqlDbType.VarChar, 500, ParameterDirection.InputOutput, updateCommandMessage)
}; service.sqlParameters.List = parameters;
}
