/// <summary>
/// Busca UsuarioLoginProvider por id do usuário
/// </summary>
/// <param name="usu_id">Id do usuário</param>
/// <returns>DataTable de UsuarioLoginProvider</returns>
public SYS_UsuarioLoginProvider SelectBy_usu_id_LoginProvider(Guid usu_id, string loginProvider)
{
var lstUsuarioLoginProvider = new List <SYS_UsuarioLoginProvider>();
QuerySelectStoredProcedure qs = new QuerySelectStoredProcedure("NEW_STP_SYS_UsuarioLoginProvider_SelectBy_usu_id_loginProvider", _Banco);
try
{
#region PARAMETROS
Param = qs.NewParameter();
Param.DbType = DbType.Guid;
Param.ParameterName = "@usu_id";
Param.Size = 16;
if (usu_id != Guid.Empty)
{
Param.Value = usu_id;
}
else
{
Param.Value = DBNull.Value;
}
qs.Parameters.Add(Param);
Param = qs.NewParameter();
Param.DbType = DbType.String;
Param.ParameterName = "@LoginProvider";
Param.Size = 128;
Param.Value = loginProvider;
qs.Parameters.Add(Param);
#endregion PARAMETROS
qs.Execute();
if (qs.Return.Rows.Count > 0)
{
foreach (DataRow dr in qs.Return.Rows)
{
SYS_UsuarioLoginProvider entity = new SYS_UsuarioLoginProvider();
lstUsuarioLoginProvider.Add(DataRowToEntity(dr, entity));
}
}
return(lstUsuarioLoginProvider.FirstOrDefault());
}
catch
{
throw;
}
finally
{
qs.Parameters.Clear();
}
}
public SYS_UsuarioLoginProvider SelectBy_LoginProvider_ProviderKey(string providerName, string providerKey)
{
List <SYS_UsuarioLoginProvider> lt = new List <SYS_UsuarioLoginProvider>();
QuerySelectStoredProcedure qs = new QuerySelectStoredProcedure("NEW_STP_SYS_UsuarioLoginProvider_LOADBy_LoginProvider_ProviderKey", _Banco);
try
{
#region PARAMETROS
Param = qs.NewParameter();
Param.DbType = DbType.String;
Param.ParameterName = "@LoginProvider";
Param.Size = 128;
Param.Value = providerName;
qs.Parameters.Add(Param);
Param = qs.NewParameter();
Param.DbType = DbType.String;
Param.ParameterName = "@ProviderKey";
Param.Size = 512;
Param.Value = providerKey;
qs.Parameters.Add(Param);
#endregion PARAMETROS
qs.Execute();
if (qs.Return.Rows.Count > 0)
{
foreach (DataRow dr in qs.Return.Rows)
{
SYS_UsuarioLoginProvider entity = new SYS_UsuarioLoginProvider();
lt.Add(this.DataRowToEntity(dr, entity));
}
}
return(lt.FirstOrDefault());
}
catch
{
throw;
}
finally
{
qs.Parameters.Clear();
}
}
