public List <FinalizarServico> buscarFServico() { string con = "User ID=sa;Password=1234567;Data Source=LAPTOP-9O51ARGN;Database=GenesysDB"; SqlConnection conexao = new SqlConnection(con); conexao.Open(); SqlCommand comando = new SqlCommand("select * from FINALIZAR_SERVICO", conexao); SqlDataReader executar = comando.ExecuteReader(); List <FinalizarServico> listaFServico = new List <FinalizarServico>(); while (executar.Read()) { FinalizarServico itemFServico = new FinalizarServico(); itemFServico.IDFinalizacao = int.Parse(executar["IDFINALIZACAO"].ToString()); itemFServico.IDServico = int.Parse(executar["IDSERVICO"].ToString()); itemFServico.Relatorio = (executar["RELATORIO"].ToString()); itemFServico.DtEncerramento = (executar["DTENCERRAMENTO"].ToString()); itemFServico.FormaPagamento = (executar["FORMAPAGAMENTO"].ToString()); itemFServico.Valor = (executar["VALOR"].ToString()); itemFServico.Pago = bool.Parse(executar["PAGO"].ToString()); listaFServico.Add(itemFServico); } conexao.Close(); return(listaFServico); }
public void cadastrar(FinalizarServico fservico) { string con = "User ID=sa;Password=1234567;Data Source=LAPTOP-9O51ARGN;Database=GenesysDB"; SqlConnection conexao = new SqlConnection(con); SqlCommand comando = new SqlCommand("INSERT INTO FINALIZAR_SERVICO VALUES('" + fservico.IDServico + "' , '" + fservico.Relatorio + "', '" + fservico.DtEncerramento + "', '" + fservico.FormaPagamento + "' , '" + fservico.Valor + "' , '" + fservico.Pago + "');", conexao); conexao.Open(); SqlDataReader executar = comando.ExecuteReader(); }
public void atualizar(FinalizarServico fservico) { string con = "User ID=sa;Password=1234567;Data Source=LAPTOP-9O51ARGN;Database=GenesysDB"; SqlConnection conexao = new SqlConnection(con); conexao.Open(); SqlCommand comando = new SqlCommand("UPDATE FINALIZAR_SERVICO SET IDSERVICO='" + fservico.IDServico + "', RELATORIO='" + fservico.Relatorio + "', DTENCERRAMENTO='" + fservico.DtEncerramento + "', FORMAPAGAMENTO='" + fservico.FormaPagamento + "', VALOR='" + fservico.Valor + "', PAGO='" + fservico.Pago + "' WHERE IDFINALIZACAO = " + fservico.IDFinalizacao, conexao); SqlDataReader executar = comando.ExecuteReader(); conexao.Close(); }
public void excluir(FinalizarServico fservico) { string con = "User ID=sa;Password=1234567;Data Source=LAPTOP-9O51ARGN;Database=GenesysDB"; SqlConnection conexao = new SqlConnection(con); conexao.Open(); SqlCommand comando = new SqlCommand("DELETE FROM FINALIZAR_SERVICO WHERE IDFINALIZACAO = " + fservico.IDFinalizacao, conexao); SqlDataReader executar = comando.ExecuteReader(); conexao.Close(); }
public void excluir(FinalizarServico fservico) { data.excluir(fservico); }
public void atualizar(FinalizarServico fservico) { data.atualizar(fservico); }
public void cadastrar(FinalizarServico fservico) { data.cadastrar(fservico); }