public List <Model.Servico> Select() { List <Model.Servico> listaServico = new List <Model.Servico>(); SqlConnection conexao = new SqlConnection(strCon); string sql = "Select * from Servico"; SqlCommand cmd = new SqlCommand(sql, conexao); try { conexao.Open(); SqlDataReader dados = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dados.Read()) { Model.Servico servico = new Model.Servico(); servico.id = Convert.ToInt32(dados["id"].ToString()); servico.descricao = dados["descricao"].ToString(); servico.valorServ = Convert.ToSingle(dados["valorServ"].ToString()); listaServico.Add(servico); } } catch { Console.WriteLine("Erro - Select do Servico"); } finally { conexao.Close(); } return(listaServico); }
public List <Model.Servico> SelectByDescricao(string descricao) { List <Model.Servico> lstServico = new List <Model.Servico>(); SqlConnection conexao = new SqlConnection(strCon); string sql = "Select * from Servico where (descricao like @desc);"; SqlCommand cmd = new SqlCommand(sql, conexao); cmd.Parameters.AddWithValue("@desc", "%" + descricao + "%"); try { conexao.Open(); SqlDataReader dados = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dados.Read()) { Model.Servico servico = new Model.Servico(); servico.id = Convert.ToInt32(dados["id"].ToString()); servico.descricao = dados["descricao"].ToString(); servico.valorServ = Convert.ToSingle(dados["valorServ"].ToString()); lstServico.Add(servico); } } catch { Console.WriteLine("Erro - Consulta Select de Servico"); } finally { conexao.Close(); } return(lstServico); }
public List <Model.Servico> select() { List <Model.Servico> lstServico = new List <Model.Servico>(); string sql = "SELECT * FROM servico"; Conexao conexao = new Conexao(); SqlCommand command = new SqlCommand(sql, conexao.getConexao()); try { SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { Model.Servico servico = new Model.Servico(); servico.id = Convert.ToInt32(reader["id"]); servico.descr = Convert.ToString(reader["descr"]); servico.valor = Convert.ToSingle(reader["valor"]); lstServico.Add(servico); } } catch { Console.WriteLine("Erro na seleção de serviço"); } finally { conexao.Dispose(); } return(lstServico); }
public Model.Servico selectByID(int id) { Model.Servico servico = new Model.Servico(); string sql = "SELECT * FROM servico WHERE id=@id"; Conexao conexao = new Conexao(); SqlCommand command = new SqlCommand(sql, conexao.getConexao()); try { SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection); reader.Read(); servico.id = Convert.ToInt32(reader["id"]); servico.descr = Convert.ToString(reader["descr"]); servico.valor = Convert.ToSingle(reader["valor"]); } catch { Console.WriteLine("Erro na seleção de serviço por id"); } finally { conexao.Dispose(); } return(servico); }
public void Update(Model.Servico servico) { DAL.Servico dalServ = new DAL.Servico(); if (servico.descricao != "") { dalServ.Update(servico); } }
public void Insert(Model.Servico servico) { DAL.Servico dalServ = new DAL.Servico(); if (servico.descricao != string.Empty) { dalServ.Insert(servico); } }
private Model.Servico getServico() { if (verificarCampos()) { Model.Servico servico = new Model.Servico(); servico.descr = txtDescricao.Text; servico.valor = Convert.ToSingle(txtValor.Text); return(servico); } else { return(null); } }
protected void btnAdicionar(object sender, EventArgs e) { Model.Servico servico = getServico(); if (servico != null) { if (verifEditarInserir()) { Dal.SerivcoDAL.update(servico); } else { Dal.SerivcoDAL.insert(servico); } Response.Redirect("viewServico.aspx"); } }
public void insert(Model.Servico servico) { string sql = "INSERT INTO servico VALUES (@descr, @valor)"; Conexao conexao = new Bll.Conexao(); SqlCommand command = new SqlCommand(sql, conexao.getConexao()); command.Parameters.AddWithValue("descr", servico.descr); command.Parameters.AddWithValue("valor", servico.valor); try { command.ExecuteNonQuery(); } catch { Console.WriteLine("Erro na inserção de Serviço"); } finally { conexao.Dispose(); } }
public void update(Model.Servico servico) { string sql = "UPDATE servico SET descr=@descr, valor=@valor WHERE id=@id"; Conexao conexao = new Bll.Conexao(); SqlCommand command = new SqlCommand(sql, conexao.getConexao()); command.Parameters.AddWithValue("descr", servico.descr); command.Parameters.AddWithValue("valor", servico.valor); command.Parameters.AddWithValue("id", servico.id); try { command.ExecuteNonQuery(); } catch { Console.WriteLine("Erro na atualização de serviço"); } finally { conexao.Dispose(); } }
public static void insert(Model.Servico servico) { Bll.ServicoBLL servicoBLL = new Bll.ServicoBLL(); servicoBLL.insert(servico); }
public static void update(Model.Servico servico) { Bll.ServicoBLL servicoBLL = new Bll.ServicoBLL(); servicoBLL.update(servico); }
private void carregarServico() { Model.Servico servico = Dal.SerivcoDAL.selectByID(Convert.ToInt32(Request.QueryString["id"])); txtDescricao.Text = servico.descr; txtValor.Text = servico.valor.ToString("0.00"); }