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; }