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"); }