internal int Deletar(clienteENT objtabela) { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = Properties.Settings.Default.Banco; SqlCommand cn = new SqlCommand(); cn.CommandType = CommandType.Text; con.Open(); cn.CommandText = "DELETE FROM cadcli WHERE ID_Cli=@ID_Cli "; cn.Parameters.Add("ID_Cli", SqlDbType.Int).Value = objtabela.ID; cn.Parameters.Add("Nome", SqlDbType.VarChar).Value = objtabela.nome; cn.Parameters.Add("CPF", SqlDbType.VarChar).Value = objtabela.cpf; cn.Parameters.Add("Convenio", SqlDbType.VarChar).Value = objtabela.convenio; cn.Parameters.Add("Idade", SqlDbType.Int).Value = objtabela.idade; cn.Parameters.Add("Sexo", SqlDbType.VarChar).Value = objtabela.sexo; cn.Parameters.Add("Endereço", SqlDbType.VarChar).Value = objtabela.endereco; cn.Parameters.Add("Telefone", SqlDbType.VarChar).Value = objtabela.telefone; cn.Parameters.Add("Celular", SqlDbType.VarChar).Value = objtabela.celular; cn.Parameters.Add("CEP", SqlDbType.VarChar).Value = objtabela.cep; cn.Connection = con; int qtd = cn.ExecuteNonQuery(); return(qtd); } }
internal int Alterar(clienteENT objtabela) { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = Properties.Settings.Default.Banco; SqlCommand cn = new SqlCommand(); cn.CommandType = CommandType.Text; con.Open(); //con conversa/instansia com bd cn estancia/recebendo a função da sqlcommand cn.CommandText = "UPDATE cadcli SET Nome=@Nome, CPF=@CPF, Convenio=@Convenio, Idade=@Idade, Sexo=@Sexo, Endereço=@Endereço, Telefone=@Telefone, Celular=@Celular, CEP=@CEP WHERE ID_Cli=@ID_Cli "; cn.Parameters.Add("ID_Cli", SqlDbType.Int).Value = objtabela.ID; cn.Parameters.Add("Nome", SqlDbType.VarChar).Value = objtabela.nome; cn.Parameters.Add("CPF", SqlDbType.VarChar).Value = objtabela.cpf; cn.Parameters.Add("Convenio", SqlDbType.VarChar).Value = objtabela.convenio; cn.Parameters.Add("Idade", SqlDbType.Int).Value = objtabela.idade; cn.Parameters.Add("Sexo", SqlDbType.VarChar).Value = objtabela.sexo; cn.Parameters.Add("Endereço", SqlDbType.VarChar).Value = objtabela.endereco; cn.Parameters.Add("Telefone", SqlDbType.VarChar).Value = objtabela.telefone; cn.Parameters.Add("Celular", SqlDbType.VarChar).Value = objtabela.celular; cn.Parameters.Add("CEP", SqlDbType.VarChar).Value = objtabela.cep; cn.Connection = con; int qtd = cn.ExecuteNonQuery(); return(qtd); //vai retornar de quem chamou! } }
internal int Inserir(clienteENT objtabela) { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = Properties.Settings.Default.Banco; SqlCommand cn = new SqlCommand(); cn.CommandType = CommandType.Text; con.Open(); cn.CommandText = "INSERT INTO cadcli ([Nome],[CPF],[Convenio],[Idade],[Sexo],[Endereço],[Telefone],[Celular],[CEP]) VALUES (@Nome, @CPF, @Convenio, @Idade, @Sexo, @Endereço, @Telefone, @Celular, @CEP)"; cn.Parameters.Add("Nome", SqlDbType.VarChar).Value = objtabela.nome; cn.Parameters.Add("CPF", SqlDbType.VarChar).Value = objtabela.cpf; cn.Parameters.Add("Convenio", SqlDbType.VarChar).Value = objtabela.convenio; cn.Parameters.Add("Idade", SqlDbType.Int).Value = objtabela.idade; cn.Parameters.Add("Sexo", SqlDbType.VarChar).Value = objtabela.sexo; cn.Parameters.Add("Endereço", SqlDbType.VarChar).Value = objtabela.endereco; cn.Parameters.Add("Telefone", SqlDbType.VarChar).Value = objtabela.telefone; cn.Parameters.Add("Celular", SqlDbType.VarChar).Value = objtabela.celular; cn.Parameters.Add("CEP", SqlDbType.VarChar).Value = objtabela.cep; cn.Connection = con; int qtd = cn.ExecuteNonQuery(); return(qtd); } }
internal List <clienteENT> Lista() { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = Properties.Settings.Default.Banco; SqlCommand cn = new SqlCommand(); cn.CommandType = CommandType.Text; con.Open(); cn.CommandText = "SELECT * FROM CADCLI"; cn.Connection = con; SqlDataReader dr; List <clienteENT> Lista = new List <clienteENT>(); dr = cn.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { clienteENT dado = new clienteENT(); dado.ID = Convert.ToInt32(dr["ID_Cli"]); dado.nome = Convert.ToString(dr["Nome"]); dado.cpf = Convert.ToString(dr["CPF"]); dado.convenio = Convert.ToString(dr["Convenio"]); dado.idade = Convert.ToInt32(dr["Idade"]); dado.sexo = Convert.ToString(dr["Sexo"]); dado.endereco = Convert.ToString(dr["Endereço"]); dado.telefone = Convert.ToString(dr["Telefone"]); dado.celular = Convert.ToString(dr["Celular"]); dado.cep = Convert.ToString(dr["CEP"]); Lista.Add(dado); } } return(Lista); } }
internal static int Deletar(clienteENT objtabela) { return(new clienteDAO().Deletar(objtabela)); }
internal static int Alterar(clienteENT objtabela) { return(new clienteDAO().Alterar(objtabela)); }
internal static int Inserir(clienteENT objtabela) { return(new clienteDAO().Inserir(objtabela)); }