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 } }