public void Insert(ProductDTO product)
{
string sql = string.Format($@"INSERT INTO product VALUES(NULL,'{product.Name}', '{product.Description}', '{product.ProductValue}', '{product.StockQuantify}', '{product.Photo}', '{product.ProviderID}', '{product.CategoryID}');");
connection.ExecutionSQL(sql);
}
public void Insert(ProviderDTO provider)
{
string sql = string.Format($@"INSERT INTO provider VALUES(NULL, '{provider.Name}', '{provider.Cnpj}', '{provider.Email}', '{provider.Phone}', '{provider.RepresentativeName}', '{provider.RepresentativePhone}');");
connection.ExecutionSQL(sql);
}
public void Insert(ClientDTO client)
{
string sql = string.Format($@"INSERT INTO client VALUES(NULL, '{client.Name}', '{client.Type}', '{client.Cpf}', '{client.Phone}', '{client.Email}', '{client.Password}');");
connection.ExecutionSQL(sql);
}
public void Insert(AddressDTO address)
{
string sql = string.Format($@"INSERT INTO address VALUES(NULL, '{address.Street}', '{address.Number}', '{address.Neighborhood}', '{address.City}', '{address.Cep}', '{address.ClientID}');");
connection.ExecutionSQL(sql);
}
public void Insert(CategoryDTO category)
{
string sql = string.Format($@"INSERT INTO category VALUES(NULL, '{category.Name}', '{category.Description}');");
connection.ExecutionSQL(sql);
}