public long LoginXML(Credenciales cre)
{
DSL _connection = new DSL();
try
{
_connection.Open(ConfigurationManager.ConnectionStrings["dbLogin"].ToString(), RNConnection.DataAbstractionLayer.eProvider.SQLServer);
_connection.InitialSQLStatement("dbo.fe_Autenticarse_xml", System.Data.CommandType.StoredProcedure);
_connection.SetParameterProcedure("@nick", System.Data.ParameterDirection.Input, RNConnection.DataAbstractionLayer.eTypes.Cadena, cre.Nick);
_connection.SetParameterProcedure("@pwd", System.Data.ParameterDirection.Input, RNConnection.DataAbstractionLayer.eTypes.Cadena, cre.Password);
_connection.SetParameterProcedure("@ResultadoXML", System.Data.ParameterDirection.ReturnValue, RNConnection.DataAbstractionLayer.eTypes.XML, null);
long IdCredencial = 0;
XmlReader xmlr = _connection.ExecuteXMLReader();
XDocument XDocEsquema = XDocument.Load(xmlr);
var Cursor = from valor in XDocEsquema.Descendants("Personas")
select valor;
foreach (var item in Cursor)
{
IdCredencial = long.Parse(item.Element("Credencial").Value.ToString());
break;
}
return IdCredencial;
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message, ex);
}
}