public static void CreateTable()
{
SQLOperations.NonQuery("Erro ao criar tabela de tipo de procedimentos.",
$"create table if not exists {Name} (" +
$" {nameof(ID)} int auto_increment," +
$" {nameof(Tipo)} nvarchar(100) unique not null," +
$" primary key ({nameof(ID)})" +
$");");
}
public static void CreateTable()
{
Procedimentos.CreateTable();
SQLOperations.NonQuery("Erro ao criar exames para lista de espera.",
$"create table if not exists {Name} (" +
$" {nameof(Senha)} int," +
$" {nameof(Exame)} int," +
$" primary key ({nameof(Senha)}, {nameof(Exame)})," +
$" foreign key ({nameof(Senha)}) references {ListaEspera.Name} ({nameof(ListaEspera.Senha)}) on delete cascade on update cascade," +
$" foreign key ({nameof(Exame)}) references {Procedimentos.Name} ({nameof(Procedimentos.ID)}) on delete cascade on update cascade" +
$");");
}
public static void CreateTable()
{
var f = new Funcionarios();
var title = $"Erro ao criar a tabela {Name}.";
var q =
$"create table if not exists {Name} (" +
$" {nameof(CPF)} varchar(15)," +
$" primary key ({nameof(CPF)})," +
$" foreign key ({nameof(CPF)}) references {Funcionarios.Name} ({nameof(f.CPF)}) ON DELETE CASCADE ON UPDATE CASCADE" +
$");";
SQLOperations.NonQuery(title, q);
}
public static void CreateTable()
{
var le = new ListaEspera();
var f = new Funcionarios();
SQLOperations.NonQuery($"Erro ao criar associação de {Name}",
$"create table if not exists {Name} (" +
$" {nameof(Senha)} int, " +
$" {nameof(Funcionario)} varchar(15)," +
$" primary key ({nameof(Senha)})," +
$" foreign key ({nameof(Senha)}) references {ListaEspera.Name} ({nameof(le.Senha)}) on delete cascade on update cascade," +
$" foreign key ({nameof(Funcionario)}) references {Funcionarios.Name} ({nameof(f.CPF)}) on delete cascade on update cascade" +
$");");
}
public override Action GetCT()
{
return(() => {
string a = $"create table if not exists {TableName} (" +
" id int auto_increment," +
" nome nvarchar(200)," +
" cnpj varchar(30)," +
" registro datetime," +
" observacao mediumtext, " +
" primary key (id)" +
");";
SQLOperations.NonQuery("Erro ao criar tabela de empresa.", a);
if (Select(1).ID == -1)
{
Insert("", "", "", DateTime.MinValue);
}
});
}
public static void CreateTable()
{
SQLOperations.NonQuery($"Erro ao criar formas de pagamento",
$"create table if not exists {Name} (" +
$" {nameof(ID)} int auto_increment," +
$" {nameof(Descricao)} nvarchar(150) unique," +
$" primary key ({nameof(ID)})" +
$");");
var descrição = Select(1);
if (descrição != null)
{
return;
}
using (var c = new MySqlCommand($"insert into {Name} (Descricao) values ('Dinheiro'), ('Crédito'), ('Débito')")) {
NonQuery($"Erro ao inserir registro inicial de forma de pagamento.", c);
}
}
private static void QueryRLoop(string title, MySqlCommand c, Action <MySqlDataReader> action)
{
SQLOperations.QueryRLoop(title, c, action, Create, true);
}
private static void NonQuery(string title, Func <MySqlCommand, MySqlCommand> func)
{
SQLOperations.NonQuery(title, func, Create, true);
}
public void NonQuery(string title, string q)
{
var c = new MySqlCommand(q);
SQLOperations.NonQuery(title, c, Create, true);
}
protected void NonQuery(string title, MySqlCommand c)
{
SQLOperations.NonQuery(title, c, Create, true);
}
private static void NonQuery(string title, MySqlCommand c)
{
SQLOperations.NonQuery(title, c, Create, true);
}