private UserBase SelectByUserName(string userName, string password)
{
string PasswordRead = "";
UserBase authUser = null;
TrolliUsers trolliData = null;
string procName = "[dbo].[Troll_Users_SelectByUserName]";
_dataProvider.ExecuteCmd(procName
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@UserName", userName);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
trolliData = new TrolliUsers();
int startingIndex = 0;
authUser = new UserBase
{
Id = reader.GetSafeInt32(startingIndex++),
Name = reader.GetSafeString(startingIndex++)
};
PasswordRead = reader.GetSafeString(startingIndex++);
});
if (PasswordRead == password)
{
return(authUser);
}
return(null);
}
public TrolliUsers GetById(int Id)
{
TrolliUsers trolliData = null;
string procName = "[dbo].[Troll_Users_SelectById]";
_dataProvider.ExecuteCmd(procName
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", Id);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
trolliData = new TrolliUsers();
int startingIndex = 0;
trolliData.Id = reader.GetSafeInt32(startingIndex++);
trolliData.Password = reader.GetSafeString(startingIndex++);
trolliData.Username = reader.GetSafeString(startingIndex++);
});
return(trolliData);
}
