public void MakeReport3()
{
List <Product> Products = GetProductData().ToList();
DataProcessor dp = new DataProcessor();
dp.BeforeGroup = (x, d) =>
{
if (1 == d)
{
var groupColor = x as IGrouping <string, Product>;
TemplateRow tmp = new TemplateRow();
tmp.RowStyle = "styleFullBlueCover";
tmp.RowContent.AddRange(new List <TemplateCell>()
{
"Color:", groupColor.Key, groupColor.AsEnumerable().Count()
});
dp.Result.Add(tmp);
}
};
dp.Process(Products.GroupBy(a => a.Color));
ReportMakerHelper reportMakerHelper = new ReportMakerHelper();
var styleSheet = reportMakerHelper.GetSheet("Template2.xlsx", "Styles");
ReportMaker reportMaker = new ReportMaker(new StylesManager(styleSheet));
Dictionary <string, List <TemplateRow> > dict = new Dictionary <string, List <TemplateRow> >()
{
{ "Products", dp.Result }
};
var image = reportMaker.FillDataInTemplate("Template2.xlsx", dict);
File.WriteAllBytes("Test3.xlsx", image.ToArray());
}
public void MakeReport2()
{
List <Product> Products = GetProductData().ToList();
DataProcessor dp = new DataProcessor();
dp.BeforeGroup = (x, d) =>
{
if (1 == d)
{
var groupColor = x as IGrouping <string, Product>;
TemplateRow tmp = new TemplateRow();
TemplateCell colorTemplateCell = new TemplateCell()
{
content = "Color:", cellStyle = "B2"
};
tmp.RowContent.AddRange(new List <TemplateCell>()
{
colorTemplateCell, groupColor.Key, groupColor.AsEnumerable().Count()
});
dp.Result.Add(tmp);
}
};
dp.Process(Products.GroupBy(a => a.Color));
ReportMaker reportMaker = new ReportMaker();
Dictionary <string, List <TemplateRow> > dict = new Dictionary <string, List <TemplateRow> >()
{
{ "Products", dp.Result }
};
var image = reportMaker.FillDataInTemplate("Template1.xlsx", dict);
File.WriteAllBytes("Test2.xlsx", image.ToArray());
}
private void ListaDeElementos_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
this.mapa.Markers.Clear();
if (this.listaDeElementos.SelectedItem != null)
{
var vendedor = this.listaDeElementos.SelectedItem as Vendedor;
try
{
SeleccionarMarcador(vendedor);
var reporte = ReportMaker.CrearReporte(vendedor);
this.posicionesUC.FechaDelReporte = this.dtpFecha.SelectedDate.Value.ToString("dddd, dd MMMM yyyy");
this.posicionesUC.Posiciones = new ObservableCollection <ItemReporte>(reporte);
this.posicionesUC.NombreVendedor = vendedor.Nombre;
this.posicionesUC.CodigoVendedor = vendedor.Codigo;
this.VisibilidadColumnaClientes = GridLength.Auto;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
this.VisibilidadColumnaClientes = new GridLength(0);
}
}
private void cargaPosicionesFleteroWorker_Complete(object sender, RunWorkerCompletedEventArgs e)
{
if (e.Result != null)
{
var fletero = (Fletero)e.Result;
var cargaClientesWorker = new CargarClientesFleteroWorker(this.mapa, fletero, diaSeleccionado.Value);
cargaClientesWorker.RunWorkerCompleted += CargaClientesWorker_RunWorkerCompleted;
cargaClientesWorker.RunWorkerAsync();
ControladorMapa.ImprimirCamino(this.mapa, fletero.Posiciones);
var reporte = ReportMaker.CrearReporte(fletero);
this.posicionesUC.FechaDelReporte = this.dtpFecha.SelectedDate.Value.ToString("dddd, dd MMMM yyyy");
this.posicionesUC.Posiciones = new ObservableCollection <ItemReporte>(reporte);
this.posicionesUC.NombreVendedor = fletero.Nombre;
this.posicionesUC.CodigoVendedor = fletero.Codigo;
this.VisibilidadColumnaClientes = GridLength.Auto;
}
}
public void Setup()
{
WeSayWordsProject.InitializeForTests();
_addin = new ReportMaker();
_addin.LaunchAfterTransform = false;
}
