public static void Insert(Fornecedor cl) { try { using (conn = new SqlConnection(connectionString)) { conn.Open(); string doc = (cl.CPF != "" && cl.CPF != null) ? "CPF" : "CNPJ"; string q = "INSERT INTO Fornecedor (Nome, " + doc + ", Email) VALUES (@n, @d, @m) SET @ID = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(q, conn); cmd.Parameters.Add("@n", SqlDbType.VarChar).Value = cl.nome; cmd.Parameters.Add("@d", SqlDbType.VarChar).Value = (cl.CPF != "" && cl.CPF != null) ? cl.CPF : cl.CNPJ; cmd.Parameters.Add("@m", SqlDbType.VarChar).Value = cl.email; cmd.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); int i = (int)cmd.Parameters["@ID"].Value; cl.telefone.setFornecedor(i); cl.endereco.setFornecedor(i); DALTelefone.InsertFornecedor(cl.telefone); DALEndereco.InsertFornecedor(cl.endereco); } } catch (Exception) { throw; } }
public static void Insert(Funcionario fn) { try { using (conn = new SqlConnection(connectionString)) { conn.Open(); string q = "INSERT INTO Funcionario (Nome, Motorista, Tecnico, Identidade, CLT, Salario, Observacao) VALUES (@n, @m, @t, @i, @c, @s, @o) SET @ID = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(q, conn); cmd.Parameters.Add("@n", SqlDbType.VarChar).Value = fn.nome; cmd.Parameters.Add("@m", SqlDbType.Bit).Value = fn.motorista; cmd.Parameters.Add("@t", SqlDbType.Bit).Value = fn.tecnico; cmd.Parameters.Add("@i", SqlDbType.VarChar).Value = fn.identidade; cmd.Parameters.Add("@c", SqlDbType.VarChar).Value = fn.CLT; cmd.Parameters.Add("@s", SqlDbType.Float).Value = fn.salario; cmd.Parameters.Add("@o", SqlDbType.VarChar).Value = fn.observacao; cmd.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); int i = (int)cmd.Parameters["@ID"].Value; fn.telefone.setFuncionario(i); fn.endereco.setFuncionario(i); DALTelefone.Insert(fn.telefone); DALEndereco.Insert(fn.endereco); } } catch (Exception) { throw; } }
public static List <Fornecedor> SelectAll() { Fornecedor c; List <Fornecedor> cs = new List <Fornecedor>(); try { using (conn = new SqlConnection(connectionString)) { conn.Open(); string s = "SELECT * FROM Fornecedor"; SqlCommand cmd = new SqlCommand(s, conn); SqlDataReader d; using (d = cmd.ExecuteReader()) { if (d.HasRows) { while (d.Read()) { int i = Convert.ToInt32(d["id"]); string n = d["Nome"].ToString(); string cpf = (d["CPF"] != null) ? d["CPF"].ToString() : ""; string cnpj = (d["CNPJ"] != null) ? d["CNPJ"].ToString() : ""; string e = d["Email"].ToString(); Endereco end = DALEndereco.SelectFromFornecedor(i); Telefone t = DALTelefone.SelectFromFornecedor(i); c = new Fornecedor(i, n, e, end, t); if (cpf != "") { c.setCPF(cpf); } else { c.setCNPJ(cnpj); } cs.Add(c); } } } } } catch (Exception) { throw; } return(cs); }
public static Fornecedor Select(int i) { Fornecedor c = new Fornecedor(); try { using (conn = new SqlConnection(connectionString)) { conn.Open(); string s = "SELECT * FROM Fornecedor WHERE id = @id "; SqlCommand cmd = new SqlCommand(s, conn); cmd.Parameters.Add("@id", SqlDbType.Int).Value = i; SqlDataReader d; using (d = cmd.ExecuteReader()) { if (d.HasRows) { while (d.Read()) { string n = d["Nome"].ToString(); string cpf = (d["CPF"] != null) ? d["CPF"].ToString() : ""; string cnpj = (d["CNPJ"] != null) ? d["CNPJ"].ToString() : ""; string e = d["Email"].ToString(); Endereco end = DALEndereco.SelectFromFornecedor(i); Telefone t = DALTelefone.SelectFromFornecedor(i); c = new Fornecedor(i, n, e, end, t); if (cpf != "") { c.setCPF(cpf); } else { c.setCNPJ(cnpj); } } } } } } catch (Exception) { throw; } return(c); }
public static List <Funcionario> SelectAll() { Funcionario c; List <Funcionario> cs = new List <Funcionario>(); try { using (conn = new SqlConnection(connectionString)) { conn.Open(); string s = "SELECT * FROM Funcionario"; SqlCommand cmd = new SqlCommand(s, conn); SqlDataReader d; using (d = cmd.ExecuteReader()) { if (d.HasRows) { while (d.Read()) { int i = Convert.ToInt32(d["id"]); string n = d["Nome"].ToString(); string rg = d["Identidade"].ToString(); string clt = d["CLT"].ToString(); string obs = d["Observacao"].ToString(); bool m = Convert.ToBoolean(d["Motorista"]); bool t = Convert.ToBoolean(d["Tecnico"]); double sal = Convert.ToDouble(d["Salario"]); Endereco end = DALEndereco.SelectFromFuncionario(i); Telefone tel = DALTelefone.SelectFromFuncionario(i); c = new Funcionario(i, n, m, t, rg, clt, sal, obs, end, tel); cs.Add(c); } } } } } catch (Exception) { throw; } return(cs); }
public static void Delete(int i) { try { DALTelefone.DeleteFromFornecedor(i); DALEndereco.DeleteFromFornecedor(i); using (conn = new SqlConnection(connectionString)) { conn.Open(); string q = "DELETE FROM Fornecedor WHERE id = @id"; SqlCommand cmd = new SqlCommand(q, conn); cmd.Parameters.Add("@id", SqlDbType.Int).Value = i; cmd.ExecuteNonQuery(); } } catch (Exception) { throw; } }
public static Funcionario Select(int i) { Funcionario c = new Funcionario(); try { using (conn = new SqlConnection(connectionString)) { conn.Open(); string s = "SELECT * FROM Funcionario WHERE id = @id"; SqlCommand cmd = new SqlCommand(s, conn); cmd.Parameters.Add("@id", SqlDbType.Int).Value = i; SqlDataReader d; using (d = cmd.ExecuteReader()) { if (d.HasRows) { while (d.Read()) { string n = d["Nome"].ToString(); string rg = d["Identidade"].ToString(); string clt = d["CLT"].ToString(); string obs = d["Observacao"].ToString(); bool m = Convert.ToBoolean(d["Motorista"]); bool t = Convert.ToBoolean(d["Tecnico"]); double sal = Convert.ToDouble(d["Salario"]); Endereco end = DALEndereco.SelectFromFuncionario(i); Telefone tel = DALTelefone.SelectFromFuncionario(i); c = new Funcionario(i, n, m, t, rg, clt, sal, obs, end, tel); } } } } } catch (Exception) { throw; } return(c); }