private void button5_Click(object sender, EventArgs e) { String filename; Boolean fileExists; for (int day = 1; day <= 31; day++) { filename = PrintLogFile.MountName(@"C:\Work\PrintLogs", day, 12, 2010); fileExists = File.Exists(filename); if (fileExists) { MessageBox.Show("Importando arquivo: " + filename); PrintLogPersistence persistence = new PrintLogPersistence(4, dataAccess.GetConnection(), this, false); persistence.ImportFile(filename); } } }
private void button3_Click(object sender, EventArgs e) { String filename = PrintLogFile.MountName(@"C:\PaperCut Print Logger\logs\csv\daily", 10, 04, 2013); CSVReader csvReader = new CSVReader(filename, null); dataGridView1.DataSource = csvReader.Read(); /* * dataGridView1.Columns.Add("hora", "Hora"); * dataGridView1.Columns.Add("usuario", "Usuário"); * dataGridView1.Columns.Add("impressora", "Impressora"); * dataGridView1.Columns.Add("quantidade_paginas", "Quant. Páginas"); * * CopiedDocumentDAO copiedDocumentDAO = new CopiedDocumentDAO(dataAccess.GetConnection()); * List<Object> copiedDocuments = copiedDocumentDAO.GetCopiedDocuments(10, new DateTime(2010, 11, 17), new DateTime(2010, 11, 20), null, null); * foreach (CopiedDocument copy in copiedDocuments) * { * Object[] values = new Object[] { copy.jobTime, copy.userName, copy.printerName, copy.pageCount }; * dataGridView1.Rows.Add(values); * } */ }
private void btnImport_Click(object sender, EventArgs e) { if (!OpenConnection()) { return; } DateTime?fileDate = PrintLogFile.GetDate(txtFileToImport.Text); if (fileDate == null) { MessageBox.Show("Arquivo inválido"); return; } DateTime startDate = fileDate.Value; DateTime endDate = startDate.Add(new TimeSpan(23, 59, 59)); DateRange dateRange = new DateRange(true); dateRange.SetRange(startDate, endDate); DBQuery query = new DBQuery(sqlConnection); query.Query = "use Accounting"; query.Execute(false); query.Query = "SELECT" + Environment.NewLine + " PRN_LOG.id jobId," + Environment.NewLine + " PRN_LOG.tenantId," + Environment.NewLine + " PRN_LOG.jobTime," + Environment.NewLine + " USR.alias userName," + Environment.NewLine + " PRN.alias printerName," + Environment.NewLine + " PRN_LOG.documentName name," + Environment.NewLine + " PRN_LOG.pageCount," + Environment.NewLine + " PRN_LOG.copyCount," + Environment.NewLine + " PRN_LOG.duplex," + Environment.NewLine + " PRN_LOG.color" + Environment.NewLine + "FROM" + Environment.NewLine + " tb_printLog PRN_LOG" + Environment.NewLine + " INNER JOIN tb_printer PRN WITH (NOLOCK)" + Environment.NewLine + " ON PRN_LOG.printerId = PRN.id" + Environment.NewLine + " INNER JOIN tb_user USR WITH (NOLOCK)" + Environment.NewLine + " ON PRN_LOG.userId = USR.id"; query.Execute(true); DataTable printLog = query.ExtractFromResultset(typeof(PrintedDocument), "tb_ptintLog"); //dataGridView1.DataSource = printLog.DefaultView; if (printLog.Rows.Count > 0) { //MessageBox.Show("Erro. Já existem registros correspondentes a data do arquivo!"); //return; } Boolean imported = ImportFile(txtFileToImport.Text); CloseConnection(); if (imported) { MessageBox.Show("Arquivo importado com sucesso."); } }