public void CadastrarAluguel(AluguelModel aluguel)
{
SqlCommand command = new() { Connection = connection };
#region Parâmetros
command.Parameters.AddWithValue("@titulo", aluguel.titulo);
command.Parameters.AddWithValue("@autor", aluguel.autor);
command.Parameters.AddWithValue("@alugadoPor", aluguel.alugadoPor);
command.Parameters.AddWithValue("@dataSaida", aluguel.dataEntrega);
command.Parameters.AddWithValue("@dataDevolucao", aluguel.dataDevolucao);
command.Parameters.AddWithValue("@status", aluguel.status);
#endregion
try
{
command.CommandText = "INSERT INTO Aluguel(Titulo, Autor, [Alugado por], [Data de saida], [Data de devolucao], Status) " +
"VALUES(@titulo, @autor, @alugadoPor, @dataSaida, @dataDevolucao, @status)";
AbrirConexaoDb();
command.ExecuteNonQuery();
FechaConecxaoDb();
command.Dispose();
MessageBox.Show(Resources.AluguelRegistrado, Resources.concluido_MessageBox,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
}
public void AtualizarAluguelNomeCliente(AluguelModel aluguel, string nomeCliente, string nomeLivro)
{
SqlCommand command = new() { Connection = connection };
#region Parâmetros
command.Parameters.AddWithValue("@titulo", aluguel.titulo);
command.Parameters.AddWithValue("@autor", aluguel.autor);
command.Parameters.AddWithValue("@alugadoPor", aluguel.alugadoPor);
command.Parameters.AddWithValue("@dataSaida", aluguel.dataEntrega);
command.Parameters.AddWithValue("@dataDevolucao", aluguel.dataDevolucao);
command.Parameters.AddWithValue("@status", aluguel.status);
#endregion
try
{
command.CommandText = "UPDATE Aluguel SET Titulo = @titulo, Autor = @autor, [Alugado por] = @alugadoPor," +
$" [Data de saida] = @dataSaida, [Data de devolucao] = @dataDevolucao, Status = @status WHERE [Alugado por] = \'{nomeCliente}\' " +
$"AND Titulo = \'{nomeLivro}\'";
AbrirConexaoDb();
command.ExecuteNonQuery();
FechaConecxaoDb();
command.Dispose();
MessageBox.Show(Resources.informações_atualizadas, Resources.concluido_MessageBox, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
}
public void AtualizarClienteId(string id, ClienteModel cliente)
{
SqlCommand command = new() { Connection = connection };
#region Parâmetros
command.Parameters.AddWithValue("@nomeCompleto", cliente.nomeCompleto);
command.Parameters.AddWithValue("@endereco", cliente.endereco);
command.Parameters.AddWithValue("@cidade", cliente.cidade);
command.Parameters.AddWithValue("@estado", cliente.estado);
command.Parameters.AddWithValue("@cep", cliente.cep);
command.Parameters.AddWithValue("@telefone1", cliente.telefone1);
command.Parameters.AddWithValue("@telefone2", cliente.telefone2);
command.Parameters.AddWithValue("@email", cliente.email);
#endregion
try
{
command.CommandText = "UPDATE Clientes SET [Nome completo] = @nomeCompleto, Endereco = @endereco, Cidade = @cidade, Estado = @estado, Cep = @cep, Telefone1 = @telefone1," +
$" Telefone2 = @telefone2, Email = @email WHERE ID = {id}";
AbrirConexaoDb();
command.ExecuteNonQuery();
FechaConecxaoDb();
command.Dispose();
MessageBox.Show(Resources.informações_atualizadas, Resources.concluido_MessageBox, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
}
#endregion
}
public void CadastrarCliente(ClienteModel cliente)
{
SqlCommand command = new() { Connection = connection };
#region Parâmetros
command.Parameters.AddWithValue("@nomeCompleto", cliente.nomeCompleto);
command.Parameters.AddWithValue("@endereco", cliente.endereco);
command.Parameters.AddWithValue("@cidade", cliente.cidade);
command.Parameters.AddWithValue("@estado", cliente.estado);
command.Parameters.AddWithValue("@cep", cliente.cep);
command.Parameters.AddWithValue("@telefone1", cliente.telefone1);
command.Parameters.AddWithValue("@telefone2", cliente.telefone2);
command.Parameters.AddWithValue("@email", cliente.email);
#endregion
try
{
command.CommandText = "INSERT INTO Clientes([Nome completo], Endereco, Cidade, Estado, Cep, Telefone1, Telefone2, Email) " +
"VALUES(@nomeCompleto, @endereco, @cidade, @estado, @cep, @telefone1, @telefone2, @email)";
AbrirConexaoDb();
command.ExecuteNonQuery();
FechaConecxaoDb();
command.Dispose();
MessageBox.Show(Resources.ClienteRegistrado, Resources.concluido_MessageBox,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
}
public static void ReiniciarPrograma()
{
AppInsightMetrics.FlushTelemetry();
UserInfo.SerializeUserInstance();
Process.Start(Application.StartupPath + Assembly.GetExecutingAssembly().GetName().Name + ".exe");
Process.GetCurrentProcess().Kill();
}
public ListaPesquisa(DataTable data)
{
InitializeComponent();
dgvLista.DataSource = data;
try
{
PrivateFontCollection privateFont = new();
privateFont.AddFontFile(Application.StartupPath + @"font\Lato-Bold.ttf");
Font lato = new(privateFont.Families[0], 8, FontStyle.Bold);
int columnQuantidade = dgvLista.ColumnCount;
for (int i = 0; i < columnQuantidade; i++)
{
dgvLista.Columns[i].DefaultCellStyle.Font = lato;
}
}
catch
{
MessageBox.Show(Resources.FaltaArquivoEscenciaisParaContinuar,
Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
Process.GetCurrentProcess().Kill();
}
#region MenuClick
mnuImprimirLista.Click += async(sender, e) =>
{
pgbAsyncTask.Visible = true;
if (!Verificadores.VerificarDataGrid(dgvLista))
{
Imprimir imprimir = new();
await imprimir.ImprimirModelo(dgvLista);
}
pgbAsyncTask.Visible = false;
};
mnuExportarExcel.Click += async(sender, e) =>
{
pgbAsyncTask.Visible = true;
if (!Verificadores.VerificarDataGrid(dgvLista))
{
await ExportToSheets();
}
pgbAsyncTask.Visible = false;
};
#endregion
Load += (_, _) => AppInsightMetrics.TrackForm("Lista");
}
public void AtualizarStatusAtrasado(string alugadoPor)
{
try
{
SqlCommand command = new() { Connection = connection };
command.CommandText = $"UPDATE Aluguel SET Status = \'{Tipos.StatusAluguel.Atrasado}\' WHERE [Alugado por] = \'{alugadoPor}\'";
AbrirConexaoDb();
command.ExecuteNonQuery();
FechaConecxaoDb();
command.Dispose();
}
catch (SqlException e) { AppInsightMetrics.SendError(e); }
}
public DataTable PegarLivroAtrassado()
{
DataTable table = new();
try
{
AbrirConexaoDb();
SqlDataAdapter adapter = new($"SELECT * FROM Aluguel WHERE Status = \'{Tipos.StatusAluguel.Atrasado}\'", connection);
FechaConecxaoDb();
adapter.Fill(table);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
return(table);
}
public DataTable BuscarAluguelLivroCliente(string titulo, string nomeCliente)
{
DataTable table = new();
try
{
AbrirConexaoDb();
SqlDataAdapter adapter = new($"SELECT * FROM Aluguel WHERE [Titulo] LIKE \'%{titulo}%\' AND [Alugado por] LIKE \'%{nomeCliente}%\'", connection);
FechaConecxaoDb();
adapter.Fill(table);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
return(table);
}
public DataTable VerTodosClientes()
{
DataTable table = new();
try
{
AbrirConexaoDb();
SqlDataAdapter adapter = new("SELECT * FROM Clientes", connection);
FechaConecxaoDb();
adapter.Fill(table);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
return(table);
}
public DataTable BuscarClienteNome(string nomeCompleto)
{
DataTable table = new();
try
{
AbrirConexaoDb();
SqlDataAdapter adapter = new($"SELECT * FROM Clientes WHERE [Nome completo] LIKE \'%{nomeCompleto}%\'", connection);
FechaConecxaoDb();
adapter.Fill(table);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.PreecherCampoBusca, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
return(table);
}
public void DeletarAluguelCliente(string nomeCliente)
{
SqlCommand command = new() { Connection = connection };
try
{
command.CommandText = $"DELETE FROM Aluguel WHERE [Alugado por] = \'{nomeCliente}\'";
AbrirConexaoDb();
command.ExecuteNonQuery();
FechaConecxaoDb();
command.Dispose();
MessageBox.Show(Resources.LivroDeletado, Resources.concluido_MessageBox,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
}
public void DeletarClienteNome(string nome)
{
SqlCommand command = new() { Connection = connection };
try
{
command.CommandText = $"DELETE FROM Clientes WHERE [Nome completo] LIKE \'%{nome}%\'";
AbrirConexaoDb();
command.ExecuteNonQuery();
FechaConecxaoDb();
command.Dispose();
MessageBox.Show(Resources.cliente_deletado_com_sucesso, Resources.concluido_MessageBox,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (SqlException e) { MessageBox.Show(e.Message, Resources.MessageBoxError, MessageBoxButtons.OK, MessageBoxIcon.Error);
AppInsightMetrics.SendError(e); }
}
public ExcluirUsuario()
{
InitializeComponent();
Load += (_, _) => AppInsightMetrics.TrackForm("ExcluirUsuario");
}
