Pesquiza em tres camadas:
namespace business_logic
{
public class dbConnection
{
public SqlDataAdapter adapter;
public SqlConnection conection;
public SqlCommand myCommand;
public dbConnection()
{
adapter = new SqlDataAdapter();
conection = new SqlConnection(@"Data Source=LEVI-PC\SQLEXPRESS;Initial Catalog=Teste_One;Integrated Security=True");
}
private SqlConnection Abrir_conecao()
{
if (conection.State == ConnectionState.Closed || conection.State == ConnectionState.Broken)
{
conection.Open();
}
return conection;
}
public DataSet pesquizar(string procurar, SqlParameter[] parametros)
{
myCommand = new SqlCommand();
DataSet dataset = new DataSet();
try
{
myCommand.Connection = Abrir_conecao();
myCommand.CommandText = procurar;
myCommand.Parameters.AddRange(parametros);
myCommand.ExecuteNonQuery();
adapter.SelectCommand = myCommand;
adapter.Fill(dataset);
}
catch (SqlException e)
{
MessageBox.Show("Error - Connection.executeSelectQuery - Query " + procurar +
" \nException: " + e.StackTrace.ToString());
return null;
}
finally
{
}
return dataset;
}
namespace business_logic
{
public class UserDAO
{
private dbConnection conn;
/// <constructor>
/// Constructor UserDAO
/// </constructor>
public UserDAO()
{
conn = new dbConnection();
}
/// <method>
/// Get User Email By Firstname or Lastname and return DataTable
/// </method>
public DataSet searchByName(string _username)
{
string query = string.Format("SELECT * FROM Table_Copy WHERE FirstName = @firstname or LastName= @lastname");
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@firstname", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(_username);
sqlParameters[1] = new SqlParameter("@lastname", SqlDbType.VarChar);
sqlParameters[1].Value = Convert.ToString(_username);
return conn.pesquizar(query, sqlParameters);
}
namespace business_logic
{
public class UserBUS
{
private UserDAO _userDAO;
public UserBUS()
{
_userDAO = new UserDAO();
}
public DataSet getUserEmailByName(string name)
{
User_Information userVO = new User_Information();
DataSet dataTable = new DataSet();
dataTable = _userDAO.searchByName(name);
DataTable dt = new DataTable();
dt = dataTable.Tables[0];
foreach (DataRow dr in dataTable.Tables[0].Rows)
{
userVO.firstname = dr["FirstName"].ToString();
userVO.lastname = dr["LastName"].ToString();
userVO.email = dr["Address"].ToString();
userVO.idUser = Int32.Parse(dr["IDD"].ToString());
}
return dataTable;
}
private void button1_Click(object sender, EventArgs e)
{
this.dataGridView1.DataSource = _userBUS.getUserEmailByName(textBox1.Text).Tables[0];
}
One word frees us of all the weight and pain of life: that word is love.
