public static int Validate(UsuarioLogIn usuario)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connection_DB"].ConnectionString))
{
int retval;
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.SPS_Usuario_Validate";
cmd.Parameters.Add("@nombre", SqlDbType.VarChar).Value = usuario.nombre;
cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = usuario.password;
cmd.Parameters.Add("@retValue", System.Data.SqlDbType.Int).Direction = System.Data.ParameterDirection.ReturnValue;
cmd.Connection = connection;
try
{
connection.Open();
cmd.ExecuteNonQuery();
retval = (int)cmd.Parameters["@retValue"].Value;
}
catch (Exception ex)
{
retval = -1;
throw;
}
finally
{
connection.Close();
}
return(retval); // execute not accomplish
}
}
public static Usuario Detail(UsuarioLogIn usuario)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connection_DB"].ConnectionString))
{
int retval;
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.SPS_Usuario_Detail";
cmd.Parameters.Add("@nombre", SqlDbType.VarChar).Value = usuario.nombre;
cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = usuario.password;
cmd.Connection = connection;
Usuario newUsuario;
try
{
connection.Open();
using (var reader = cmd.ExecuteReader())
{
reader.Read();
newUsuario = new Usuario()
{
nombre = reader.GetString(0),
password = reader.GetString(1),
tipoUsuario = reader.GetString(2)
};
}
}
catch (Exception ex)
{
retval = -1;
throw;
}
finally
{
connection.Close();
}
return(newUsuario); // execute not accomplish
}
}
