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