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 void Insert(Cliente cl)
{
try
{
using (conn = new SqlConnection(connectionString))
{
conn.Open();
string doc = (cl.CPF != "" && cl.CPF != null) ? "CPF" : "CNPJ";
string q = "INSERT INTO Cliente (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.setCliente(i);
cl.endereco.setCliente(i);
DALTelefone.Insert(cl.telefone);
DALEndereco.Insert(cl.endereco);
}
}
catch (Exception)
{
throw;
}
}