public int iNuevaLinea(UsuarioLinea _Linea)
{
using (SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPY))
{
SqlCommand _sqlCommand = new SqlCommand("MPYCCSPI_USUARIO_LINEA", _SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
_sqlCommand.Parameters.AddWithValue("@IdUsuario", _Linea.iIdUsuario);
_sqlCommand.Parameters.AddWithValue("@DisplayName", _Linea.sDisplayName);
_sqlCommand.Parameters.AddWithValue("@UserName", _Linea.sUserName);
_sqlCommand.Parameters.AddWithValue("@RegisterName", _Linea.sRegisterName);
_sqlCommand.Parameters.AddWithValue("@RegisterPassword", _Linea.sRegisterPassword);
_sqlCommand.Parameters.AddWithValue("@DomainHost", _Linea.sDomainHost);
_sqlCommand.Parameters.AddWithValue("@DomainPort", _Linea.iDomainPort);
var parameterReturn = _sqlCommand.Parameters.Add("@Status", SqlDbType.BigInt);
parameterReturn.Direction = ParameterDirection.ReturnValue;
try
{
_SqlConnection.Open();
_sqlCommand.ExecuteNonQuery();
return(int.Parse(parameterReturn.Value.ToString()));
}
catch (Exception)
{
return(-1);
}
}
}
public UsuarioLinea ObtenerLinea(int iIdUsuario)
{
using (SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPY))
{
UsuarioLinea linea = null;
SqlCommand _SqlCommand = new SqlCommand("MPYCCSPS_USUARIO_LINEA", _SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
_SqlCommand.Parameters.AddWithValue("@IdUsuario", iIdUsuario);
try
{
_SqlConnection.Open();
SqlDataReader _SqlDataReader = _SqlCommand.ExecuteReader();
if (_SqlDataReader.HasRows)
{
while (_SqlDataReader.Read())
{
linea = new UsuarioLinea()
{
iIdUsuario = int.Parse(_SqlDataReader["Usuario"].ToString()),
sDisplayName = _SqlDataReader["DisplayName"].ToString(),
sUserName = _SqlDataReader["UserName"].ToString(),
sRegisterName = _SqlDataReader["RegisterName"].ToString(),
sRegisterPassword = _SqlDataReader["RegisterPassword"].ToString(),
sDomainHost = _SqlDataReader["DomainHost"].ToString(),
iDomainPort = int.Parse(_SqlDataReader["DomainPort"].ToString())
};
}
}
}
catch (Exception)
{
linea = null;
}
return(linea);
}
}
