private static CsvFileWriter AbrirArchivo()
{
string filepath = @"C:\Users\Angela\Desktop\estadisticasSimulacion.csv";
CsvFileWriter writer = new CsvFileWriter(@filepath);
//Escribo encabezados de las columnas del archivo
CsvRow header = new CsvRow();
header.Add("Reloj");
header.Add("Promedio clientes en cola");
header.Add("Uso servidor");
header.Add("Clientes atendidos");
header.Add("Demora promedio en cola");
writer.WriteRow(header);
return writer;
}
public int BeginScrape()
{
List<Models.Website> websites = websiteDb.Websites.Where(x => x.Domain == HostField).ToList();
string guid = websites[0].GUID;
List<Models.Filter> filters = filterDb.Filters.Where(x => x.GUID == guid).ToList();
BrowserDriver driver = new BrowserDriver();
//filters = filters.OrderBy(x => x.Id)
//.ThenBy(x => x.Column).ToList(); //Orders the list so that the primarykey is first, if not specified it will organize by column
string folderPath = "~/Downloads/" + guid;
DirectoryInfo directory = new DirectoryInfo(HttpContext.Current.Server.MapPath(folderPath));
if (directory.Exists)
{
foreach (FileInfo file in directory.GetFiles())
{
file.Delete();
}
foreach (DirectoryInfo dir in directory.GetDirectories())
{
dir.Delete(true);
}
directory.Delete(true);
System.Threading.Thread.Sleep(1000);
}
directory.Create();
System.Threading.Thread.Sleep(1000);
using (CsvFileWriter writer =
new CsvFileWriter(directory.ToString() + "/Output.csv"))
{
CsvRow row = new CsvRow();
foreach (Models.Filter filter in filters.Where(x => x.Action == 0))
row.Add(filter.Column);
writer.WriteRow(row);
int rowindex = 2;
foreach (string link in LinksField)
{
driver.GoTo(link);
row = new CsvRow();
foreach(Models.Filter filter in filters)
{
bool skip = false;
switch (filter.Action)
{
case 0:
string result = driver.GetElement(filter.Selector, false);
if(result != null)
{
string downloadlink = isFile(result);
if(downloadlink != null)
{
DownloadFile(downloadlink, guid, rowindex, filter.Column);
}
foreach (Models.Filter igfilter in filterDb.Filters.Where(x => x.Action == 1))
{
string ignoreexists = driver.GetElement(igfilter.Selector, true);
if(ignoreexists != null)
{
result = result.Replace(ignoreexists, "");
}
}
result = Regex.Replace(result, @"\s*(?<capture><(?<markUp>\w+)>.*<\/\k<markUp>>)\s*", "${capture}", RegexOptions.Singleline);
result = result.Replace("\t", "");
result = result.Replace("\r", "");
result = result.Replace("\n", "");
row.Add(result);
}
else
{
if (filter.Required)
skip = true;
else
row.Add("");
}
break;
case 1://make this work for the new engine
break;
case 2:
bool didClick = driver.Click(filter.Selector);
if (!didClick)
if (filter.Required)
skip = true;
break;
default:
break;
}
if (skip)
{
row = null;
break;
}
}
if (row != null)
{
writer.WriteRow(row);
rowindex++;
}
}
}
driver.Close();
return 0;
}
private void btnToCSV_Click(object sender, EventArgs e)
{
try
{
// Displays a SaveFileDialog so the user can save the Image
// assigned to Button2.
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "CSV|*.csv";
saveFileDialog1.Title = "Guardar como csv...";
saveFileDialog1.ShowDialog();
if (saveFileDialog1.FileName != "")
{
Cursor = Cursors.WaitCursor;
System.IO.FileStream fs = (System.IO.FileStream)saveFileDialog1.OpenFile();
fs.Close();
CsvFileWriter file = new CsvFileWriter(saveFileDialog1.FileName);
CsvRow header = new CsvRow();
foreach (DataGridViewColumn col in dgvParte4Final.Columns)
{
header.Add(col.Name);
}
file.WriteRow(header);
foreach (Source.citParte4Final item in _result)
{
file.WriteRow(item.ToCsv());
}
file.Flush();
file.Close();
MessageBox.Show("Ficheiro guardado.");
}
}
catch (Exception ex)
{
MessageBox.Show("Erro\n" + ex.Message);
}
finally
{
Cursor = Cursors.Default;
}
}
private static void CerrarArchivo(CsvFileWriter writer)
{
writer.Close();
writer.Dispose();
}
private static void calcularEstadisticos(int n, CsvFileWriter writer, int n_corrida, Excel._Workbook workbook)
{
double q = 0, b = 0, d = 0;
//Promedio de clientes en cola
q = delta_q / reloj; //Se mide en [clientes]
//% uso del servidor
b = delta_b / reloj;
if (cli_at > 0)
{
//Demora promedio en cola
d = (delta_d / (double)cli_at) / (double)60; //Se mide en [minutos/cliente]
}
//Escribo en el archivo CSV los estadisticos calculados
//CsvRow fila = new CsvRow();
//fila.Add(reloj.ToString());
//fila.Add(q.ToString());
//fila.Add(b.ToString());
//fila.Add(cli_at.ToString());
//fila.Add(d.ToString());
//writer.WriteRow(fila);
//Escribo en Excel los estadisticos calculados
//Demora promedio en cola
workbook.Sheets[1].Cells[n + 2, n_corrida + 1] = d;
//% uso del servidor
workbook.Sheets[2].Cells[n + 2, n_corrida + 1] = b;
//Promedio de clientes en cola
workbook.Sheets[3].Cells[n + 2, n_corrida + 1] = q;
}
