public void Create(SalesMan salesMan)
{
string script = @"INSERT INTO salesman VALUES(@IDSALESMAN, @NAME, @CPF, @TELEPHONE, @ADDRESS)";
try
{
command = new SqlCommand(script, con.getCon());
command.Parameters.AddWithValue("@IDSALESMAN", salesMan.IdSalesMan);
command.Parameters.AddWithValue("@NAME", salesMan.Name);
command.Parameters.AddWithValue("@CPF", salesMan.Cpf);
command.Parameters.AddWithValue("@TELEPHONE", salesMan.Telephone);
command.Parameters.AddWithValue("@ADDRESS", salesMan.Address);
con.getCon().Open();
command.ExecuteNonQuery();
}
catch (Exception erro)
{
Message.MessageError(erro.Message);
}
finally
{
con.getCon().Close();
con.CloseDB();
}
}
public string Create(Sale sale)
{
string idSale = "";
string script = @"INSERT INTO sale(total,idClient,idSaleman,date,rate)
VALUES (@TOTAL, @IDCLIENT, @IDSALESMAN, @DATA, @RATE)";
try
{
command = new SqlCommand(script, con.getCon());
command.Parameters.AddWithValue("@TOTAL", sale.Total);
command.Parameters.AddWithValue("@IDCLIENT", sale.IdClient);
command.Parameters.AddWithValue("@IDSALESMAN", sale.IdSalesMan);
command.Parameters.AddWithValue("@DATA", sale.Data);
command.Parameters.AddWithValue("@RATE", sale.Rate);
con.getCon().Open();
reader = command.ExecuteReader();
if (reader.Read())
{
idSale = reader["idSale"].ToString();
}
}
catch (Exception erro)
{
Message.MessageError(erro.Message);
}
finally
{
con.getCon().Close();
con.CloseDB();
}
return(idSale);
}
public void Create1(Client client)
{
string script = @"INSERT INTO client(name, address, telephone, cpf)
VALUES (@NAME, @ADDRESS, @TELEPHONE, @CPF)";
try
{
command = new SqlCommand(script, con.getCon());
command.Parameters.AddWithValue("@NAME", client.Name);
command.Parameters.AddWithValue("@ADDRESS", client.Address);
command.Parameters.AddWithValue("@TELEPHONE", client.Telephone);
command.Parameters.AddWithValue("@CPF", client.Cpf);
con.getCon().Open();
command.ExecuteNonQuery();
}
catch (Exception erro)
{
Message.MessageError(erro.Message);
}
finally
{
con.getCon().Close();
con.CloseDB();
}
}
public void Create(ModePay modePay)
{
string script = @"INSERT INTO modePay (name,otherDetails)
VALUES (@NAME, @OTHERDETAILS)";
try
{
command = new SqlCommand(script, con.getCon());
command.Parameters.AddWithValue("@NAME", modePay.Name);
command.Parameters.AddWithValue("@OTHERDETAILS", modePay.OtherDetails);
con.getCon().Open();
command.ExecuteNonQuery();
}
catch (Exception erro)
{
Message.MessageError(erro.Message);
}
finally
{
con.getCon().Close();
con.CloseDB();
}
}
public void CreateSql(Cliente objCliente)
{
string Create = $"INSERT INTO cliente(nome, endereco, telefone, cpf ) VALUES ({objCliente.Nome}, {objCliente.Endereco}, {objCliente.Telefone}, {objCliente.CPF})";
try
{
Comando = new SqlCommand(Create, objConexaoDB.GetConnection());
objConexaoDB.GetConnection().Open();
Comando.ExecuteNonQuery();
}
catch (Exception e)
{
objCliente.Estado = 1;
}
finally
{
objConexaoDB.CloseDB();
}
}
public void Create(Product product)
{
string script = @"INSERT INTO product VALUES(@IDPRODUCT, @NAME, @UNITPRICE, @IDCATEGORY)";
try
{
command = new SqlCommand(script, con.getCon());
command.Parameters.AddWithValue("@IDPRODUCT", product.IdProduct);
command.Parameters.AddWithValue("@NAME", product.Name);
command.Parameters.AddWithValue("@UNITPRICE", product.UnitPrice);
command.Parameters.AddWithValue("@IDCATEGORY", product.IdCategory);
con.getCon().Open();
command.ExecuteNonQuery();
}
catch (Exception erro)
{
Message.MessageError(erro.Message);
}
finally
{
con.getCon().Close();
con.CloseDB();
}
}
public void Create(Category category)
{
string script = @"INSERT INTO category VALUES(@IDCATEGORY, @NAME, @DESCRIPTION)";
try
{
command = new SqlCommand(script, con.getCon());
command.Parameters.AddWithValue("@IDCATEGORY", category.IdCategory);
command.Parameters.AddWithValue("@NAME", category.Name);
command.Parameters.AddWithValue("@DESCRIPTION", category.Description);
con.getCon().Open();
command.ExecuteNonQuery();
}
catch (Exception erro)
{
Message.MessageError(erro.Message);
}
finally
{
con.getCon().Close();
con.CloseDB();
}
}
