public static Servico Select(long codigo) { Servico servico; string query = "SELECT * FROM srv_servicos WHERE srv_codigo = ?codigo;"; DBHelper dbHelper; IDataReader dataReader; try { dbHelper = new DBHelper(query); dbHelper.AddParameter("?codigo", codigo); dataReader = dbHelper.Command.ExecuteReader(); servico = new Servico(); while (dataReader.Read()) { servico.Codigo = Convert.ToInt64(dataReader["srv_codigo"]); servico.Nome = Convert.ToString(dataReader["srv_nome"]); servico.Preco = Convert.ToDouble(dataReader["srv_valor"]); servico.Estabelecimento = EstabelecimentoDB.Select(Convert.ToInt64(dataReader["est_codigo"])); servico.TipoServico = TipoServicoDB.Select(Convert.ToInt64(dataReader["tps_codigo"])); } dbHelper.Dispose(); } catch { servico = null; } return(servico); }
public static List <Servico> SelectByEstabelecimento(Estabelecimento estabelecimento) { string query = "SELECT * FROM srv_servicos WHERE est_codigo = ?estabelecimento;"; List <Servico> servicos = new List <Servico>(); DBHelper dbHelper; IDataReader reader; try { dbHelper = new DBHelper(query); dbHelper.AddParameter("?estabelecimento", estabelecimento.Codigo); reader = dbHelper.Command.ExecuteReader(); while (reader.Read()) { servicos.Add(new Servico() { Codigo = Convert.ToInt64(reader["srv_codigo"]), Nome = Convert.ToString(reader["srv_nome"]), Preco = Convert.ToDouble(reader["srv_valor"]), Estabelecimento = EstabelecimentoDB.Select(Convert.ToInt64(reader["est_codigo"])), TipoServico = TipoServicoDB.Select(Convert.ToInt64(reader["tps_codigo"])) }); } dbHelper.Dispose(); } catch (Exception ex) { Console.WriteLine(ex.Message); } return(servicos); }
public static TipoServico Select(long codigo) { TipoServico tipoServico; string query = "SELECT * FROM tps_tiposervicos WHERE tps_codigo = ?codigo;"; DBHelper dbHelper; IDataReader dataReader; try { dbHelper = new DBHelper(query); dbHelper.AddParameter("?codigo", codigo); dataReader = dbHelper.Command.ExecuteReader(); tipoServico = new TipoServico(); while (dataReader.Read()) { tipoServico.Codigo = Convert.ToInt64(dataReader["tps_codigo"]); tipoServico.Descricao = Convert.ToString(dataReader["tps_nome"]); if (dataReader["tps_tipopai"] == DBNull.Value) { tipoServico.TipoPai = null; } else { tipoServico.TipoPai = TipoServicoDB.Select(Convert.ToInt64(dataReader["tps_tipopai"])); } } dbHelper.Dispose(); } catch { tipoServico = null; } return(tipoServico); }