public void GetUserList(DSLUser ds)
{
sqlDAUser.SelectCommand.Parameters["@userName"].Value = null;
sqlDAUser.SelectCommand.Parameters["@password"].Value = null;
sqlDAUser.SelectCommand.Parameters["@userId"].Value = null;
sqlDAUser.Fill(ds);
}
/// <summary>
/// Retrieve user by username and password.
/// </summary>
public void GetUser(string userName, string password, DSLUser ds)
{
sqlDAUser.SelectCommand.Parameters["@userName"].Value = userName;
sqlDAUser.SelectCommand.Parameters["@password"].Value = password;
sqlDAUser.SelectCommand.Parameters["@userId"].Value = null;
sqlDAUser.Fill(ds);
}
public override DataSet Clone()
{
DSLUser cln = ((DSLUser)(base.Clone()));
cln.InitVars();
return(cln);
}
public DSLUser GetUserList()
{
DSLUser ds = new DSLUser();
sqlDAUser.SelectCommand.Parameters["@userName"].Value = null;
sqlDAUser.SelectCommand.Parameters["@password"].Value = null;
sqlDAUser.SelectCommand.Parameters["@userId"].Value = null;
sqlDAUser.Fill(ds);
return(ds);
}
/// <summary>
/// Retrieve user by username.
/// </summary>
public DSLUser GetUser(string userName)
{
DSLUser ds = new DSLUser();
sqlDAUser.SelectCommand.Parameters["@userName"].Value = userName;
sqlDAUser.SelectCommand.Parameters["@password"].Value = null;
sqlDAUser.SelectCommand.Parameters["@userId"].Value = null;
sqlDAUser.Fill(ds);
if (ds.TUsers.Count == 1)
{
return(ds);
}
else
{
return(null);
}
}