static public Library.Setor FindById(long idSetor) { SqlDataReader rdr = null; SqlConnection conexao = null; SqlCommand comando = null; try { conexao = new SqlConnection(global::Connection.Connection.String()); comando = new SqlCommand(); string query = "SELECT * FROM Setor WHERE id='" + idSetor + "'"; comando.CommandText = query; comando.Connection = conexao; conexao.Open(); rdr = comando.ExecuteReader(); while (rdr.Read()) { Library.Setor setor = new Setor(); setor.Id = (long)rdr["id"]; setor.Nome = rdr["nome"].ToString(); setor.Descricao = rdr["descricao"].ToString(); setor.DataCadastro = (DateTime)rdr["dataCadastro"]; return(setor); } } catch (SqlException ex) { Library.Diagnostics.Logger.Error(ex); } catch (Exception ex) { Library.Diagnostics.Logger.Error(ex); } finally { conexao.Close(); comando.Dispose(); } return(null); }
static public Library.Setor FindById(long idSetor) { SqlConnection conexao = null; SqlDataAdapter dap = null; DataSet ds = null; Library.Setor setor = null; try { conexao = new SqlConnection(global::Connection.Connection.String()); dap = new SqlDataAdapter("SELECT * FROM Setor WHERE id='" + idSetor + "'", conexao); ds = new DataSet(); dap.Fill(ds, "Setor"); if (ds.Tables["Setor"].Rows.Count == 1) { //throw new ApplicationException("DataSet está vazio!"); setor = new Setor(); setor.Id = (long)ds.Tables["Setor"].Rows[0]["id"]; setor.Nome = ds.Tables["Setor"].Rows[0]["nome"].ToString(); setor.Descricao = ds.Tables["Setor"].Rows[0]["descricao"].ToString(); setor.DataCadastro = (DateTime)ds.Tables["Setor"].Rows[0]["dataCadastro"]; } return(setor); } catch (SqlException ex) { Library.Diagnostics.Logger.Error(ex);; } catch (Exception ex) { Library.Diagnostics.Logger.Error(ex);; } finally { conexao.Close(); dap.Dispose(); ds.Dispose(); } return(null); }
static public List <Library.Setor> FindAdvanced(params Library.Classes.QItem[] args) { SqlDataReader rdr = null; SqlConnection conexao = null; SqlCommand comando = null; try { conexao = new SqlConnection(global::Connection.Connection.String()); comando = new SqlCommand(); string query = "SELECT * FROM Setor AS s "; int p = 0; string pre = ""; foreach (Library.Classes.QItem qi in args) { if (p == 0) { pre = "WHERE "; } else { pre = " AND "; } p++; switch (qi.Campo) { case "s.id": query += pre + "(s.id = @id)"; comando.Parameters.AddWithValue("@id", qi.Objeto); break; case "s.nome": query += pre + "(s.nome = @nome)"; comando.Parameters.AddWithValue("@nome", qi.Objeto); break; case "s.descricao": query += pre + "(s.descricao = @descricao)"; comando.Parameters.AddWithValue("@descricao", qi.Objeto); break; case "s.dataCadastro": query += pre + "(s.dataCadastro = @dataCadastro)"; comando.Parameters.AddWithValue("@dataCadastro", qi.Objeto); break; case "s.nome LIKE %%": query += pre + "(s.nome LIKE '%' + @nome + '%')"; comando.Parameters.AddWithValue("@nome", qi.Objeto); break; case "ORDER BY": query += " ORDER BY " + qi.Objeto; break; } } comando.CommandText = query; comando.Connection = conexao; conexao.Open(); rdr = comando.ExecuteReader(); List <Library.Setor> setores = new List <Library.Setor>(); while (rdr.Read()) { Library.Setor setor = new Setor(); setor.Id = (long)rdr["id"]; setor.Nome = rdr["nome"].ToString(); setor.Descricao = rdr["descricao"].ToString(); setor.DataCadastro = (DateTime)rdr["dataCadastro"]; setores.Add(setor); } return(setores); } catch (Exception ex) { Library.Diagnostics.Logger.Error(ex); } finally { conexao.Close(); comando.Dispose(); } return(null); }