/// <summary>
/// Imprime el reporte de Guests Premanifest Outhouse según lo que esta visualizando el DataGrid
/// </summary>
/// <history>
/// [jorcanche] created 05/05/2016
/// </history>
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
if (dgGuestPremanifest.Items.Count > 0)
{
var remanifestOutside = BRGeneralReports.GetRptPremanifestOutSide(dtpDate.Value.Value, Context.User.LeadSource.lsID);
ReportsToExcel.PremanifestToExcel(remanifestOutside, this);
}
else
{
UIHelper.ShowMessage("There is no data");
}
}
/// <summary>
/// Realiza la consulta y obtiene los datos segun los filtros ingresados en el formulario.
/// </summary>
/// <history>
/// [edgrodriguez] 28/Abr/2016 Created
/// </history>
private async void BtnApplyFilter_OnClick(object sender, RoutedEventArgs e)
{
lstLoginsLog = ((CollectionViewSource)(FindResource("lstRptLoginsLog")));
biWait.IsBusy = true;
biWait.BusyContent = "Loading data...";
lstLoginsLog.Source = await BRGeneralReports.GetRptLoginsLog(dtmStart.Value.Value, dtmEnd.Value.Value,
cbLocation.SelectedValue.ToString(),
cbPcName.SelectedValue.ToString(),
cbPersonnel.SelectedValue.ToString());
biWait.IsBusy = false;
}
/// <summary>
/// Exporta el reporte seleccionado a un archivo de excel.
/// </summary>
/// <history>
/// [edgrodriguez] 21/Jun/2016 Created
/// [jorcanche] 01/09/2016 modified se agrego validacion si no se selecciono un reporte
/// [edgrodriguez] 05/09/2016 Modified. Se cambio el método CreateExcelCustom por CreatCustomExcel
/// [emoguel] 08/09/2016 Modified. Ahora abre el visor de reportes
/// </history>
private async void lstHostReports_Select(object sender, RoutedEventArgs e)
{
if (e.GetType() == typeof(KeyEventArgs) && ((KeyEventArgs)e).Key != Key.Enter)
{
return;
}
var filters = new List <Tuple <string, string> >();
var daterange = DateHelper.DateRange(dtpDate.Value.Value, dtpDate.Value.Value);
var dateFileName = DateHelper.DateRangeFileName(dtpDate.Value.Value, dtpDate.Value.Value);
FileInfo fileinfo = null;
if (lstHostReports.SelectedItem == null)
{
UIHelper.ShowMessage("You must select a report");
return;
}
switch ((lstHostReports.SelectedItem as ListBoxItem).Content.ToString())
{
case "Premanifest":
var lstPremanifest = await BRGeneralReports.GetRptPremanifest(dtpDate.Value.Value, salesRoom : Context.User.SalesRoom.srID);
if (lstPremanifest.Any())
{
filters.Add(Tuple.Create("Filter Range", daterange));
filters.Add(Tuple.Create("Sales Room", Context.User.SalesRoom.srID));
fileinfo = await ReportBuilder.CreateCustomExcelAsync(TableHelper.GetDataTableFromList(lstPremanifest, true, true), filters, "Premanifest", dateFileName, clsFormatReports.RptPremanifest());
}
else
{
UIHelper.ShowMessage("There is no data for make a report");
}
break;
case "Premanifest With Gifts":
var lstPremanifestWithG = await BRGeneralReports.GetRptPremanifestWithGifts(dtpDate.Value.Value, salesRoom : Context.User.SalesRoom.srID);
if (lstPremanifestWithG.Any())
{
filters.Add(Tuple.Create("Filter Range", daterange));
filters.Add(Tuple.Create("Sales Room", Context.User.SalesRoom.srID));
fileinfo = await ReportBuilder.CreateCustomExcelAsync(TableHelper.GetDataTableFromList(lstPremanifestWithG, true, true), filters, "Premanifest With Gifts", dateFileName, clsFormatReports.RptPremanifestWithGifts());
}
else
{
UIHelper.ShowMessage("There is no data for make a report");
}
break;
case "Up List End":
var lstUplistEnd = await BRReportsBySalesRoom.GetRptUplist(dtpDate.Value.Value.Date, salesRoom : Context.User.SalesRoom.srID, uplistType : 1);
if (lstUplistEnd.Any())
{
filters.Add(Tuple.Create("Filter Range", daterange));
filters.Add(Tuple.Create("Sales Room", Context.User.SalesRoom.srID));
var salesmans = lstUplistEnd.Select(c => c.Salesman).Distinct().ToList();
salesmans.ForEach(s =>
{
var first = lstUplistEnd.FirstOrDefault(u => u.Salesman == s);
var index = lstUplistEnd.IndexOf(first);
lstUplistEnd.Where(c => c.Salesman == s && lstUplistEnd.IndexOf(c) != index).ToList().ForEach(c =>
{
c.AmountM = 0;
c.AmountYtd = 0;
});
});
fileinfo = await ReportBuilder.CreateCustomExcelAsync(TableHelper.GetDataTableFromList(lstUplistEnd, true, true), filters, "Up List End", dateFileName, clsFormatReport.RptUpList(), isPivot : true, addEnumeration : true);
}
else
{
UIHelper.ShowMessage("There is no data for make a report");
}
break;
case "Up List Start":
var lstUplistStart = await BRReportsBySalesRoom.GetRptUplist(dtpDate.Value.Value, salesRoom : Context.User.SalesRoom.srID);
if (lstUplistStart.Any())
{
filters.Add(Tuple.Create("Filter Range", daterange));
filters.Add(Tuple.Create("Sales Room", Context.User.SalesRoom.srID));
var newUplist = new List <RptUpList>();
var times = new List <string> {
"08:00", "10:00", "12:00"
};
//Replicamos los registros por cada registro de la lista times
lstUplistStart.ForEach(c =>
{
times.ForEach(t =>
{
newUplist.Add(new RptUpList
{
Salesman = c.Salesman,
SalesmanN = c.SalesmanN,
SalesmanPost = c.SalesmanPost,
SalesmanPostN = c.SalesmanPostN,
DayOffList = c.DayOffList,
Language = c.Language,
Location = c.Location,
Time = c.Time,
TimeN = t,
AmountYtd = c.AmountYtd,
AmountM = c.AmountM
});
});
});
fileinfo = await ReportBuilder.CreateCustomExcelAsync(TableHelper.GetDataTableFromList(newUplist, true, true), filters, "Up List Start", dateFileName, clsFormatReport.RptUpList(), isPivot : true, addEnumeration : true);
}
else
{
UIHelper.ShowMessage("There is no data for make a report");
}
break;
}
if (fileinfo != null)
{
frmDocumentViewer documentViewver = new frmDocumentViewer(fileinfo, Context.User.HasPermission(EnumPermission.RptExcel, EnumPermisionLevel.ReadOnly), false);
documentViewver.Owner = this;
documentViewver.ShowDialog();
}
}
