private void simpleButton6_Click(object sender, EventArgs e)
{
rpPhieuban = new report.phieuban();
using (ReportPrintTool printTool = new ReportPrintTool(rpPhieuban))
{
// Invoke the Ribbon Print Preview form modally,
// and load the report document into it.
printTool.ShowRibbonPreviewDialog();
// Invoke the Ribbon Print Preview form
// with the specified look and feel setting.
printTool.ShowRibbonPreviewDialog(UserLookAndFeel.Default);
}
}
private void UiBarButtonConsolidado_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var devolucionesConsolidadas = RecepcionesPorDevoluciones
.Where(d => d.QTY > 0)
.GroupBy(d => new { d.INVOICE_DOC_NUM })
.Select(dc => new ReporteRecepcionPorDevolucion
{
INVOICE_DOC_NUM = dc.Key.INVOICE_DOC_NUM
, ERP_REFERENCE_DOC_NUM = dc.First().ERP_REFERENCE_DOC_NUM
, CLIENT_CODE = dc.First().CLIENT_CODE
, CLIENT_NAME = dc.First().CLIENT_NAME
, QTY = dc.Sum(d => d.QTY)
});
var cantidadNotasDeCredito =
devolucionesConsolidadas.Where(d => d.ERP_REFERENCE_DOC_NUM != null).ToList().Count;
var reporte = new Reportes.ReporteDevolucionesConsolidado()
{
DataSource = devolucionesConsolidadas,
RequestParameters = false
};
reporte.Parameters["ParametroUsuario"].Value = InteraccionConUsuarioServicio.ObtenerUsuario();
reporte.Parameters["ImagenLogo"].Value = InteraccionConUsuarioServicio.ObtenerLogo();
reporte.Parameters["CantidadNotasDeCredito"].Value = cantidadNotasDeCredito;
reporte.FillDataSource();
using (var printTool = new ReportPrintTool(reporte))
{
printTool.ShowRibbonPreviewDialog();
}
}
private void UiBtnImprimirReporte_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (UiVistaInventarioPorAcuerdoComercial.DataSource == null)
{
InteraccionConUsuarioServicio.Mensaje(
"No se encontraron datos para generar el reporte, por favor, verifique y vuelva a intentar.");
}
else
{
var listaDeInventarioPorAcuerdoComercial = new List <AcuerdoComercial>();
for (var i = 0; i < UiVistaInventarioPorAcuerdoComercial.Views[0].RowCount; i++)
{
listaDeInventarioPorAcuerdoComercial.Add((AcuerdoComercial)UiVistaInventarioPorAcuerdoComercial.Views[0].GetRow(i));
}
var reporte = new Reportes.AcuerdoComercialPorInventario
{
DataSource = ListToDataTableClass.ListToDataTable(listaDeInventarioPorAcuerdoComercial),
DataMember = "AcuerdoComercial",
RequestParameters = false
};
reporte.Parameters["ImagenLogo"].Value = InteraccionConUsuarioServicio.ObtenerLogo();
reporte.FillDataSource();
using (var printTool = new ReportPrintTool(reporte))
{
printTool.ShowRibbonPreviewDialog();
}
}
}
private void UiBotonReportePorDocumento_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//if (PolizasMaestroDetalle == null || PolizasMaestroDetalle.IsEmpty() || PolizasMaestroDetalle.Count(x => x.IS_SELECTED) == 0)
if (PolizasMaestroDetalle == null || PolizasMaestroDetalle.Count(x => x.IS_SELECTED) == 0)
{
return;
}
var documentosSeleccionados = PolizasMaestroDetalle.Where(detalle => detalle.IS_SELECTED).Select(x => new { x.DOC_ID }).Distinct().ToList();
var reporte = new Reportes.ConsultaCosteosPorDocumento
{
DataSource = ListToDataTableClass.ListToDataTable(PolizasMaestroDetalle.Where(detalle => documentosSeleccionados.Exists(s => s.DOC_ID == detalle.DOC_ID)).ToList()),
DataMember = "COSTEOS_POR_DOCUMENTO",
RequestParameters = false
};
reporte.Parameters["ImagenLogo"].Value = InteraccionConUsuarioServicio.ObtenerLogo();
reporte.FillDataSource();
using (var printTool = new ReportPrintTool(reporte))
{
printTool.ShowRibbonPreviewDialog();
}
}
private void UiBarButtonImprimir_ItemClick(object sender, ItemClickEventArgs e)
{
if (SolicitudesDeTraslado == null)
{
return;
}
var listaSolicitudes = new List <SolicitudDeTrasladoEncabezado>();
for (var i = 0; i < UiVistaSolicitud.RowCount; i++)
{
listaSolicitudes.Add((SolicitudDeTrasladoEncabezado)UiVistaSolicitud.GetRow(i));
}
var reporte = new Reportes.ReporteDeSolicitudDeTraslado
{
DataSource = ListToDataTableClass.ListToDataTable(listaSolicitudes)
,
RequestParameters = false
};
reporte.Parameters["ImagenLogo"].Value = InteraccionConUsuarioServicio.ObtenerLogo();
reporte.FillDataSource();
using (var printTool = new ReportPrintTool(reporte))
{
printTool.ShowRibbonPreviewDialog();
}
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Print.Barcode barcode = new Print.Barcode();
ReportPrintTool printTool = new ReportPrintTool(barcode);
printTool.ShowRibbonPreviewDialog();
}
private void TsbtnPrint_Click(object sender, EventArgs e)
{
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
printTool.ShowRibbonPreviewDialog();
}
}
public static void ShowReport(Decimal dptid)
{
SqlConnection con = new SqlConnection(Properties.Settings.Default.strCon);
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
DispatchReport rpt = new DispatchReport();
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand("Select * from DispatchHeader where DptId=" + dptid.ToString(), con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds, "DispatchHeader");
cmd = new SqlCommand("Select * from DispatchLine where DptId=" + dptid.ToString(), con);
adp = new SqlDataAdapter(cmd);
adp.Fill(ds, "DispatchLine");
ds.Relations.Add("DispatchHeaderDispatchLine", ds.Tables["DispatchHeader"].Columns["DptId"], ds.Tables["DispatchLine"].Columns["DptId"]);
rpt.DataSource = ds;
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
// printTool.Print("TSC TA210");
printTool.ShowRibbonPreviewDialog();
//or printTool.PrintDialog();
}
cmd.Dispose();
con.Dispose();
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "PRNX files|*.prnx";
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
ReportPrintTool printTool = new ReportPrintTool(new XtraReport());
// Access the Print Tool's Printing System and load the report document.
if (System.IO.File.Exists(openFileDialog.FileName))
{
printTool.PrintingSystem.LoadDocument(openFileDialog.FileName);
}
else
{
System.Console.WriteLine("The source file does not exist.");
}
// Load a Print Preview in a dialog window.
// printTool.ShowPreviewDialog()
printTool.ShowRibbonPreviewDialog();
}
}
/// <summary>
/// 레포트 출력 버튼 클릭
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Report_Click(object sender, EventArgs e)
{
if (string.Empty == txt_Remark.Text) // 비고란 빈칸 검증
{
MessageBox.Show("비고란을 입력해주세요.", "오류");
txt_Remark.Focus();
return;
}
else if (gridView1.RowCount == 0)
{
MessageBox.Show("조회 후 출력이 가능합니다. 조회 먼저 실행해 주세요.", "오류");
txt_Remark.Text = string.Empty;
return;
}
string startDate = date_StartDate.Value.ToString("yyyy-MM-dd");
string endDate = date_EndDate.Value.ToString("yyyy-MM-dd");
string remark = txt_Remark.Text;
DataSet ds = GetChartBarInfo(); // DB에서 바 차트 정보 가져오기
Report1 report1 = new Report1(startDate, endDate, remark); // 시작일, 종료일, 비고 전달해서 바로 출력하기 위해 값 같이 넘김
report1.DataSource = ds; // 레포트 datasource에 가져온 dataset 설정
//report1.DataMember = "DATA";
using (ReportPrintTool printTool = new ReportPrintTool(report1)) // 레포트 미리보기 팝업
{
printTool.ShowRibbonPreviewDialog();
}
txt_Remark.Text = string.Empty; // 비고란 지우기
}
private void UiBotonReporte_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (Cajas == null)
{
return;
}
UiVistaPrincipal.ExpandAllGroups();
var listaCajas = GetFilteredData <Caja>(UiVistaPrincipal);
var reporte = new Reportes.ConsultaLineaPicking(false)
{
DataSource = ListToDataTableClass.ListToDataTable(listaCajas),
RequestParameters = false
};
reporte.Parameters["ImagenLogo"].Value = InteraccionConUsuarioServicio.ObtenerLogo();
reporte.FillDataSource();
using (var printTool = new ReportPrintTool(reporte))
{
printTool.ShowRibbonPreviewDialog();
}
}
catch (Exception ex)
{
InteraccionConUsuarioServicio.MensajeErrorDialogo(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
List <string> chkList = new List <string>();
for (int i = 0; i < dgvBORList.Rows.Count; i++)
{
bool isCellChecked = (bool)dgvBORList.Rows[i].Cells[0].EditedFormattedValue;
if (isCellChecked)
{
chkList.Add(dgvBORList.Rows[i].Cells[1].Value.ToString());
}
}
if (chkList.Count == 0)
{
MessageBox.Show("출력할 바코드를 선택해주세요.");
return;
}
string strChkBarCodes = string.Join(",", chkList);
BORService service = new BORService();
XtraBORList rpt = new XtraBORList();
DataTable dt = service.GetBaCodeBORList(strChkBarCodes);
rpt.Parameters["uName"].Value = LoginInfo.UserInfo.LI_NAME;
rpt.DataSource = dt;
rpt.CreateDocument();
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
printTool.ShowRibbonPreviewDialog();
}
}
private void button1_Click(object sender, EventArgs e)
{
using (XtraReport report = new XtraReport1())
using (ReportPrintTool printTool = new ReportPrintTool(report)) {
printTool.ShowRibbonPreviewDialog();
}
}
private void UiBarButtonReporte_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
var reporte = new Reportes.ConsultaDeInventarioDiario()
{
DataSource = ListToDataTableClass.ListToDataTable(Inventario.ToList()),
RequestParameters = false
};
reporte.Parameters["Usuario"].Value = InteraccionConUsuarioServicio.ObtenerNombreUsuario();
reporte.Parameters["ImagenLogo"].Value = InteraccionConUsuarioServicio.ObtenerLogo();
reporte.FillDataSource();
using (var printTool = new ReportPrintTool(reporte))
{
printTool.ShowRibbonPreviewDialog();
}
Cursor.Current = Cursors.Default;
}
catch (Exception ex)
{
InteraccionConUsuarioServicio.MensajeErrorDialogo(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (XtraReport report = CreateTreeListReport())
{
ReportPrintTool pt = new ReportPrintTool(report);
pt.ShowRibbonPreviewDialog();
}
}
public BarCode(XtraReport rpt)
{
InitializeComponent();
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
printTool.ShowRibbonPreviewDialog();
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
// Show the report's Print Preview
XtraReport1 report = new XtraReport1();
ReportPrintTool printTool = new ReportPrintTool(report);
printTool.ShowRibbonPreviewDialog();
}
private void radButtonElement2_Click(object sender, EventArgs e)
{
ReportPrintTool printTool = new ReportPrintTool(new RevenueReport());
// Invoke the Ribbon Print Preview form modally
// with the specified look and feel settings.
printTool.ShowRibbonPreviewDialog(UserLookAndFeel.Default);
}
private void button1_Click(object sender, EventArgs e)
{
// Create a cross-tab report.
using (XtraReport report = CreateReport())
using (ReportPrintTool tool = new ReportPrintTool(report)) {
// Show its Print Preview.
tool.ShowRibbonPreviewDialog();
}
}
private void button1_Click(object sender, EventArgs e)
{
XtraReport1 report = new XtraReport1();
using (ReportPrintTool tool = new ReportPrintTool(report)) {
report.PrintControl = tool.PreviewRibbonForm.PrintControl;
tool.ShowRibbonPreviewDialog();
}
}
public void ExibirNaTela()
{
var rpt = AtualizarLogoDoBancoNoModelo();
var pt = new ReportPrintTool(rpt);
pt.AutoShowParametersPanel = true;
pt.ShowRibbonPreviewDialog();
}
public void ShowReport()
{
XtraReport report = ReportGenerator.GenerateReport(gridView);
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
// phiếu rút tiền
private void barButtonItem_phieuthu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
PhieuRutTien phieuChi = new PhieuRutTien();
ReportPrintTool reportPrintTool = new ReportPrintTool(phieuChi);
UserLookAndFeel userLookAndFeel = new UserLookAndFeel(this);
userLookAndFeel.UseDefaultLookAndFeel = false;
userLookAndFeel.SkinName = "Office 2016 colorful";
reportPrintTool.ShowRibbonPreviewDialog(userLookAndFeel);
}
private void TsbtnPrint_Click(object sender, EventArgs e)
{
ProductionRequest rpt = new ProductionRequest();
rpt.DataSource = dt;
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
printTool.ShowRibbonPreviewDialog();
}
}
private void btnReport_Click(object sender, EventArgs e)
{
TwitReport order = new TwitReport();
order.DataSource = CreateData(twits);
ReportPrintTool tool = new ReportPrintTool(order);
tool.ShowRibbonPreviewDialog();
btnReport.Enabled = false;
}
// xuất ra phiếu gửi tiền
private void btn_phieuguitien_Click(object sender, EventArgs e)
{
PhieuGuiTien phieuChi = new PhieuGuiTien();
ReportPrintTool reportPrintTool = new ReportPrintTool(phieuChi);
UserLookAndFeel userLookAndFeel = new UserLookAndFeel(this);
userLookAndFeel.UseDefaultLookAndFeel = false;
userLookAndFeel.SkinName = "Office 2016 colorful";
reportPrintTool.ShowRibbonPreviewDialog(userLookAndFeel);
}
private void GenerarReporte()
{
try
{
Cursor.Current = Cursors.WaitCursor;
var listaDeEncabezadosSeleccionados =
InventarioComprometidoEncabezados.Where(enc => enc.IS_SELECTED).ToList();
if (listaDeEncabezadosSeleccionados.Count == 0)
{
return;
}
var listaDeReporte = (from encabezado in listaDeEncabezadosSeleccionados
let listaDetalles = InventarioComprometidoTodosDetalles.Where(det => det.WAVE_PICKING_ID == encabezado.WAVE_PICKING_ID).ToList()
from detalle in listaDetalles
select new InventarioComprometidoParaReporte
{
DOC_NUM = encabezado.DOC_NUM,
CLIENT_CODE = encabezado.CLIENT_CODE,
CLIENT_NAME = encabezado.CLIENT_NAME,
WAVE_PICKING_ID = encabezado.WAVE_PICKING_ID,
ERP_DOCUMENT = encabezado.ERP_DOCUMENT,
LABEL_ID = detalle.LABEL_ID,
LOCATION_SPOT = detalle.LOCATION_SPOT,
MATERIAL_ID = detalle.MATERIAL_ID,
MATERIAL_NAME = detalle.MATERIAL_NAME,
QTY = detalle.QTY,
DELIVERY_STATUS = detalle.DELIVERY_STATUS
}).ToList();
var reporte = new ReporteInventarioComprometido()
{
DataSource = ListToDataTableClass.ListToDataTable(listaDeReporte),
RequestParameters = false
};
reporte.Parameters["ImagenLogo"].Value = InteraccionConUsuarioServicio.ObtenerLogo();
reporte.Parameters["Usuario"].Value = InteraccionConUsuarioServicio.ObtenerUsuario();
reporte.FillDataSource();
using (var printTool = new ReportPrintTool(reporte))
{
printTool.ShowRibbonPreviewDialog();
}
}
catch (Exception ex)
{
InteraccionConUsuarioServicio.MensajeErrorDialogo(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void Report_Print_Preview(string action)
{
XtraReport_EmployeeAttendance Xtra_Report_EmployeeAttendanceList = new XtraReport_EmployeeAttendance();
DynamicParameters paramSalary = new DynamicParameters();
paramSalary.Add("@Emp_Code_Processing", txtEmpCode.EditValue);
paramSalary.Add("@Salary_Month", DtStartDate.EditValue);
paramSalary.Add("@Deduct_Advance", 1);
paramSalary.Add("@Deduct_Loan", 1);
paramSalary.Add("@TeaRate", 0);
paramSalary.Add("@NoOfCups", 0);
DynamicParameters param = new DynamicParameters();
param.Add("@EmpCode", txtEmpCode.EditValue);
param.Add("@Attendance_Month", DtStartDate.EditValue);
DynamicParameters paramEmp = new DynamicParameters();
paramEmp.Add("@EmpCode", txtEmpCode.EditValue);
ProgramMasterModel programMaster = ProgramMasterData.GetProgramMasterModel(GlobalVariables.ProgCode);
EmployeeAttendanceDetails_Model employeeAttendanceDetails_Model = new EmployeeAttendanceDetails_Model
{
EmpCode = txtEmpCode.EditValue + string.Empty,
AttendanceMonth = ConvertTo.DateTimeVal(DtStartDate.EditValue),
EmployeeAttendance_Get_List = EmployeeData.EmployeeAttendance_Get(programMaster.ProgProcName + "_v2", param),
EmployeesSalaryList = EmployeeData.GetEmployeesSalaryList("sp_Salary_Process", paramSalary),
EmployeeMasterDataList = EmployeeData.GetEmployeeMasterDataList("sp_LoadEmpMstFEditing", paramEmp)
};
//EmployeeMasterModel
attendanceBindingSource.DataSource = employeeAttendanceDetails_Model;
Xtra_Report_EmployeeAttendanceList.DataSource = attendanceBindingSource;
//MessageBox.Show(employeeAttendanceDetails_Model.EmployeesSalaryList.Count + "");
ReportPrintTool tool = new ReportPrintTool(Xtra_Report_EmployeeAttendanceList);
if (action.Equals("preview"))
{
tool.ShowRibbonPreviewDialog();
}
if (action.Equals("print"))
{
tool.PrintDialog();
}
}
private void attendantListToolStripMenuItem_Click(object sender, EventArgs e)
{
var source = _db.Attendants.Where(a => !a.IsInactive).OrderBy(a => a.AgeGroupID).ThenBy(a => a.LastName).ThenBy(a => a.FirstName).ToList();
var report = new AttendantListReport();
report.DataSource = source;
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
private void familySummaryToolStripMenuItem_Click(object sender, EventArgs e)
{
var source = AttendantSummary.Load(_db, Properties.Settings.Default.StartDate, Properties.Settings.Default.EndDate);
var report = new FamilySummaryReport();
report.DataSource = source;
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
private void fRpt_Load(object sender, EventArgs e)
{
rptDonDatHang _rptDonDatHang = new rptDonDatHang();
_rptDonDatHang.obj = objDonDatHang;
_rptDonDatHang.DataSource = dtDonDatHangCT;
_rptDonDatHang.DataMember = "ChiTietDonHang";
using (ReportPrintTool printTool = new ReportPrintTool(_rptDonDatHang))
{
printTool.ShowRibbonPreviewDialog();
printTool.ShowRibbonPreview(UserLookAndFeel.Default);
}
this.Close();
}
private void btnGraphReport_Click(object sender, RoutedEventArgs e)
{
DashboardReportDesign.seriesList1.Clear();
DashboardReportDesign.seriesList2.Clear();
DashboardReportDesign.seriesList3.Clear();
using (var context = new DatabaseContext())
{
List<DashboardReportData> dataList = new List<DashboardReportData>();
#region Leads per month
var leads = (from c in context.Leads.ToList() select c).Distinct().ToList();
int LeadsMonth = 0;
DateTime[] months = { DateTime.Now.AddMonths(-2), DateTime.Now.AddMonths(-1), DateTime.Now };
if (months[0].Month >= DateTime.Now.Month && months[1].Month >= DateTime.Now.Month)
{
months[0].AddYears(-1);
months[1].AddYears(-1);
}
int countLeads = 0;
DevExpress.XtraCharts.Series leadSeries = new DevExpress.XtraCharts.Series();
foreach (var month in months)
{
foreach (var lead in leads)
{
leadSeries = new DevExpress.XtraCharts.Series(month.ToString("MMM"), ViewType.StackedBar);
if (Convert.ToDateTime(lead.DateAdded).Month == month.Month && Convert.ToDateTime(lead.DateAdded).Year == month.Year)
{
countLeads++;
LeadsMonth++;
}
}
leadSeries.Points.Add(new DevExpress.XtraCharts.SeriesPoint(month.ToString("MMM yyyy"), countLeads));
leadSeries.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative;
DashboardReportDesign.seriesList1.Add(leadSeries);
countLeads = 0;
}
#endregion
#region Leads per year
leads = (from c in context.Leads.ToList() select c).Distinct().ToList();
DateTime[] years = { DateTime.Now.AddYears(-2), DateTime.Now.AddYears(-1), DateTime.Now };
countLeads = 0; int LeadsYear = 0;
DevExpress.XtraCharts.Series leadSeriesPerYear = new DevExpress.XtraCharts.Series();
foreach (var year in years)
{
foreach (var lead in leads)
{
leadSeriesPerYear = new DevExpress.XtraCharts.Series(year.ToString("yyyy"), ViewType.StackedBar);
if (Convert.ToDateTime(lead.DateAdded).Year == year.Year)
{
countLeads++;
LeadsYear++;
}
}
leadSeriesPerYear.Points.Add(new DevExpress.XtraCharts.SeriesPoint(year.ToString("yyyy"), countLeads));
leadSeriesPerYear.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative;
DashboardReportDesign.seriesList2.Add(leadSeriesPerYear);
countLeads = 0;
}
#endregion
#region Leads per Sales Stage
leads = (from c in context.Leads.ToList() select c).Distinct().ToList();
var salesStages = context.SalesStages.ToList();
countLeads = 0; int LeadsStatus = 0;
DevExpress.XtraCharts.Series leadSeriesPerStage = new DevExpress.XtraCharts.Series();
leadSeriesPerStage = new DevExpress.XtraCharts.Series("Sales Stages", ViewType.Doughnut);
foreach (var salesStage in salesStages)
{
foreach (var lead in leads)
{
if (lead.Status == salesStage.SalesStageName)
{
countLeads++;
LeadsStatus++;
}
}
leadSeriesPerStage.Points.Add(new DevExpress.XtraCharts.SeriesPoint(salesStage.SalesStageName, countLeads));
leadSeriesPerStage.LegendTextPattern = "{A} : {V}";
countLeads = 0;
}
leadSeriesPerStage.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative;
DashboardReportDesign.seriesList3.Add(leadSeriesPerStage);
#endregion
#region Overall Leads
leads = context.Leads.ToList();
List<string> statuses = new List<string>() {"Engaged client", "Active", "Not active"};
countLeads = 0; int overAll = leads.Count(); string percent = "";
foreach (var status in statuses)
{
foreach (var item in leads)
{
var customerAccount = context.Customers.FirstOrDefault(c => c != null && c.LeadID == item.LeadID);
if (item.IsActive == true && status == statuses[0] && customerAccount != null && item.Status == "New Customer")
{
countLeads++;
}
else if (item.IsActive == true && status == statuses[1] && customerAccount == null)
{
countLeads++;
}
else if (item.IsActive == false && status == statuses[2] && customerAccount == null)
{
countLeads++;
}
}
Compute(countLeads, overAll, out percent);
countLeads = 0;
if (status == statuses[0])
{
if (Convert.ToInt32(percent) < 10)
{
DashboardReportDesign.lblEngaged.Text = "0" + percent + "%";
}
else
{
DashboardReportDesign.lblEngaged.Text = percent + "%";
}
}
else if (status == statuses[1])
{
if (Convert.ToInt32(percent) < 10)
{
DashboardReportDesign.lblActive.Text = "0" + percent + "%";
}
else
{
DashboardReportDesign.lblActive.Text = percent + "%";
}
}
else if (status == statuses[2])
{
if (Convert.ToInt32(percent) < 10)
{
DashboardReportDesign.lblNotActive.Text = "0" + percent + "%";
}
else
{
DashboardReportDesign.lblNotActive.Text = percent + "%";
}
}
}
#endregion
dataList.Add(new DashboardReportData
{
ReportHeader = "NSPIRE INC.",
ReportTitle = "GRAPH REPORT as of " + DateTime.Now.ToString("MMMM d, yyyy"),
TotalLeads = overAll,
TotalLeadsMonth = LeadsMonth,
TotalLeadsSalesStage = LeadsStatus,
TotalLeadsYear = LeadsYear
});
var report = new DashboardReportDesign()
{
DataSource = dataList.Distinct(),
Name = "GRAPH REPORT as of " + DateTime.Now.ToString("MMMM d, yyyy")
};
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
}
private void GenerarFicheroFacturaPdfToolStripMenuItemClick(object sender, EventArgs e)
{
if (!DatosLineaValido()) return;
bsFactura.EndEdit();
Factura factura = bsFactura.Current as Factura;
ActualizarContadoresLineas();
try
{
XtraReportFactura xtraReport=new XtraReportFactura
{
Factura=factura
};
xtraReport.Parameters["licenciaMunicipal"].Value = Settings.Default.licencia;
xtraReport.Parameters["email"].Value = Settings.Default.email;
xtraReport.Parameters["Movil"].Value = Settings.Default.movil;
xtraReport.Parameters["Nif"].Value = Settings.Default.nif;
xtraReport.Parameters["Telefono"].Value = Settings.Default.telefono;
xtraReport.Parameters["nombre"].Value = Settings.Default.nombre;
xtraReport.Parameters["direccion"].Value = Settings.Default.direccion;
xtraReport.Parameters["poblacion"].Value = Settings.Default.poblacionCP;
if (!string.IsNullOrEmpty(Settings.Default.Iban))
{
xtraReport.Parameters["poblacion"].Value = string.Format("IBAN: {0}", Settings.Default.Iban);
}
else
{
xtraReport.Parameters["poblacion"].Value = string.Format("IBAN: {0}", Settings.Default.ccc);
}
SetTextWatermark(xtraReport);
using (ReportPrintTool printTool = new ReportPrintTool(xtraReport))
{
// Invoke the Ribbon Print Preview form modally,
// and load the report document into it.
printTool.ShowRibbonPreviewDialog();
// Invoke the Ribbon Print Preview form
// with the specified look and feel setting.
printTool.ShowRibbonPreview(UserLookAndFeel.Default);
}
//(new PdfGenerador(factura)).Run();
}
catch (Exception exception)
{
XtraMessageBox.Show(exception.Message, "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
if (factura != null) Settings.Default.ultimaFactura = factura.Numero;
Settings.Default.Save();
}
private void btnPrintContact_Click(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
int itemNo = 0;
if (contactsList.Count() > 0)
{
List<ContactsReportData> dataList = new List<ContactsReportData>();
List<ContactsReportDetail> detailsList = new List<ContactsReportDetail>();
foreach (var contact in contactsList)
{
itemNo++;
var detail = new ContactsReportDetail();
detail.CompanyName = contact.Company;
detail.ContactNo = itemNo;
detail.ContactPerson = contact.ContactPersonName;
detail.PhoneNo = contact.PhoneNo;
detail.Position = contact.Position;
detailsList.Add(detail);
}
dataList.Add(new ContactsReportData()
{
ReportHeader = "CONTACT PERSONS",
ReportTitle = "CONTACT PERSONS as of " + DateTime.Now.ToString("MMMM dd, yyyy"),
TotalContacts = detailsList.Count(),
details = detailsList
});
var report = new ContactsReportDesign
{
DataSource = dataList.Distinct(),
Name = "CONTACT PERSONS as of "
+ DateTime.Now.ToString("MMMM dd, yyyy")
};
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
else
{
var windows = new NoticeWindow();
NoticeWindow.message = "No details to print.";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
}
private void btnPrintLead_Click(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
int itemNo = 0;
if (leadsList.Count() > 0)
{
List<LeadsReportData> dataList = new List<LeadsReportData>();
List<LeadsReportDetail> detailsList = new List<LeadsReportDetail>();
foreach (var lead in leadsList)
{
itemNo++;
var detail = new LeadsReportDetail();
detail.Address = lead.CompanyAddress;
detail.CompanyName = lead.CompanyName;
detail.LeadNo = itemNo;
detail.SalesStageStatus = lead.SalesStageStatus;
detail.Territory = lead.TerritoryName;
detailsList.Add(detail);
}
dataList.Add(new LeadsReportData()
{
ReportHeader = "LEADS",
ReportTitle = "LEADS as of " + DateTime.Now.ToString("MMMM dd, yyyy"),
TotalLeads = detailsList.Count(),
details = detailsList
});
var report = new LeadsReportDesign
{
DataSource = dataList.Distinct(),
Name = "LEADS as of "
+ DateTime.Now.ToString("MMMM dd, yyyy")
};
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
else
{
var windows = new NoticeWindow();
NoticeWindow.message = "No data to print.";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
var activities = activityList.ToList();
int itemNo = 0;
var lead = context.Leads.FirstOrDefault(c => c.LeadID == LeadId);
if (activities.Count() > 0)
{
List<LeadActivityReportData> dataList = new List<LeadActivityReportData>();
List<LeadActivityReportDetail> detailsList = new List<LeadActivityReportDetail>();
foreach (var leadActivity in activities)
{
var contact = context.Contacts.FirstOrDefault(c => c.ContactPersonName == leadActivity.ContactPerson);
if (leadActivity.CompanyName == lead.CompanyName)
{
itemNo++;
var detail = new LeadActivityReportDetail();
detail.ActivityDate = leadActivity.ActivityDate;
detail.ActivityNo = itemNo;
detail.ActivityTime = leadActivity.ActivityTime;
detail.ClientResponse = leadActivity.ClientResponse;
detail.CompanyName = leadActivity.CompanyName;
detail.Cost = leadActivity.Cost;
detail.Description = leadActivity.Description;
detail.DetailsOfTransaction = leadActivity.TransactionDetails;
detail.DueDateOfNextStep = leadActivity.NextStepDueDate;
detail.MarketingVoucherNo = leadActivity.MarketingVoucher;
detail.NextStep = leadActivity.NextStep;
detail.SalesRep = leadActivity.SalesRep;
if (contact != null) { detail.ContactPerson = contact.ContactPersonName; }
else { detail.ContactPerson = ""; }
detailsList.Add(detail);
}
}
dataList.Add(new LeadActivityReportData()
{
ReportHeader = "LEAD ACTIVITIES",
ReportTitle = "LEAD ACTIVITIES of " + lead.CompanyName.ToUpper()
+ " as of " + DateTime.Now.ToString("MMMM dd, yyyy"),
TotalActivities = detailsList.Count(),
details = detailsList
});
var report = new LeadActivityReportDesign
{
DataSource = dataList.Distinct(),
Name = "LEAD ACTIVITIES of " + lead.CompanyName.ToUpper()
+ " as of " + DateTime.Now.ToString("MMMM dd, yyyy")
};
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
else
{
var windows = new NoticeWindow();
NoticeWindow.message = "No data to print.";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
}
private void btnGenerate_Click(object sender, EventArgs e)
{
if (!validator.Validate())
return;
try
{
SplashScreenManager.ShowForm(this, typeof(PleaseWaitForm), false, false, false);
DateTime first = new DateTime(Convert.ToInt32(cbYear.EditValue), Convert.ToInt32(cbMonth.EditValue), 1);
DateTime last = new DateTime(Convert.ToInt32(cbYear.EditValue), Convert.ToInt32(cbMonth.EditValue),
DateTime.DaysInMonth(Convert.ToInt32(cbYear.EditValue), Convert.ToInt32(cbMonth.EditValue)));
driver d = driver.SingleOrDefault(Convert.ToInt64(cbDriver.EditValue));
List<FeesDriverList> fdl = new List<FeesDriverList>();
string sql = String.Format("WHERE driver_id = {0} AND start::date BETWEEN '{1:yyyy-MM-dd}' AND '{2:yyyy-MM-dd}' ORDER BY start",
d.id, first, last);
List<freight> fre = freight.Fetch(sql);
if (fre.Count <= 0)
{
SplashScreenManager.CloseForm(false);
XtraMessageBox.Show("Não foi encontrado resultados para este período!");
return;
}
foreach (freight fr in fre)
{
fdl.Add(new FeesDriverList()
{
date = Convert.ToDateTime(fr.start),
driver = d.full_name,
freight_id = fr.id.ToString(),
value = fr.value_comission
});
}
FeesDriverModel f = new FeesDriverModel();
f.feesList = fdl;
f.document_driver = d.cpf;
f.driver = d.full_name;
f.emission_at = String.Format("Emitido em {0:dd/MM/yyyy HH:mm}", driver.Now());
f.reference = String.Format("Referente à {0} de {1}", cbMonth.Text, cbYear.EditValue);
f.signature = "Emitido por CadoreTecnologia";
FeesDriverReport report = new FeesDriverReport();
report.bdgFees.DataSource = f;
foreach (DevExpress.XtraReports.Parameters.Parameter p in report.Parameters)
{
p.Visible = false;
}
/*PdfExportOptions po = new PdfExportOptions() {ImageQuality = PdfJpegImageQuality.Highest, Compressed = true };
report.ExportToPdf("C:\\Users\\William\\Desktop\\testePDF.pdf", po);*/
/*HtmlExportOptions htmlOptions = report.ExportOptions.Html;
htmlOptions.CharacterSet = "UTF-8";
htmlOptions.TableLayout = false;
htmlOptions.RemoveSecondarySymbols = false;
htmlOptions.Title = "Teste relatório HTML";
htmlOptions.ExportMode = HtmlExportMode.SingleFilePageByPage;
htmlOptions.PageBorderColor = Color.Blue;
htmlOptions.PageBorderWidth = 3;
report.ExportToHtml("C:\\Users\\William\\Desktop\\testeHTML.html");*/
ReportPrintTool tool = new ReportPrintTool(report);
SplashScreenManager.CloseForm(false);
tool.ShowRibbonPreviewDialog();
//this.Close();
}
catch (Exception ex)
{
SplashScreenManager.CloseForm(false);
XtraMessageBox.Show(String.Format("Ocorreu um erro:\n{0}\n{1}", ex.Message, ex.InnerException));
}
}
private void btnGenerate_Click(object sender, EventArgs e)
{
if (!validator.Validate())
return;
List<freight> llf = null;
truck _truck = null;
driver _driver = null;
long truck_id = Convert.ToInt64(cbTruck.EditValue);
long driver_id = Convert.ToInt64(cbDriver.EditValue);
DateTime start = dtStart.DateTime;
DateTime end = dtEnd.DateTime;
bool isTruck = ckTruck.Checked;
if(isTruck)
{
_truck = truck.SingleOrDefault(truck_id);
llf = freight.Fetch(String.Format("WHERE truck_id={0} AND start BETWEEN '{1:yyyy-MM-dd}' AND '{2:yyyy-MM-dd}' ORDER BY start",
_truck.id, start, end));
_driver = driver.SingleOrDefault(_truck.driver_id);
}
else if (ckDriver.Checked)
{
driver dri = driver.SingleOrDefault(driver_id);
_truck = truck.SingleOrDefault("WHERE driver_id=@0", driver_id);
llf = freight.Fetch(String.Format("WHERE driver_id={0} AND start BETWEEN '{1:yyyy-MM-dd}' AND '{2:yyyy-MM-dd}' ORDER BY start",
dri.id, start, end));
_driver = dri;
if (_truck == null)
_truck = new truck();
}
if (llf.Count <= 0)
{
XtraMessageBox.Show("Nenhum resultado encontrado para o período informado!");
return;
}
decimal value_gross = 0;
SplashScreenManager.ShowForm(this, typeof(PleaseWaitForm), false, false, false);
trailer t1 = new trailer();
trailer t2 = new trailer();
trailer t3 = new trailer();
if (_truck.id > 0)
{
t1 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", _truck.id, 1);
t2 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", _truck.id, 2);
t3 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", _truck.id, 3);
}
FreightsByTruckModel fm = new FreightsByTruckModel()
{
emission_at = String.Format("Emitido em {0:dd/MM/yyyy HH:mm}", freight.Now()),
reference = String.Format("Período de {0:dd/MM/yyyy} à {1:dd/MM/yyyy}", start, end),
signature = "Emitido por CadoreTecnologia",
truck = String.Format("{0} - {1}{2}{3}",
_truck.board, (t1 != null ? t1.board : ""), (t2 != null ? "/" + t2.board : ""), (t3 != null ? "/" + t3.board : "")),
driver = _driver.full_name
};
if (_truck.id <= 0 && (t1.id <= 0) && (t2.id <= 0) && (t3.id <= 0))
{
fm.truck = "Motorista não cadastrado para nenhum veículo.";
if (_driver.inactive)
fm.truck += " Motorista inativo.";
}
List<ListFreights> lf = new List<ListFreights>();
foreach (freight f in llf)
{
decimal value_fueleds = 0, value_outputs = 0;
List<ListFueleds> lfueled = new List<ListFueleds>();
List<fueled> llfueled = fueled.Fetch("WHERE freight_id = @0", f.id);
foreach (fueled fu in llfueled)
{
value_fueleds += fu.total;
lfueled.Add(new ListFueleds()
{
date = Convert.ToDateTime(fu.date),
liters = fu.liters,
discont = fu.discount,
value_liters = fu.value_liters,
value_total = fu.total,
gas_station = customer.SingleOrDefault(fu.gas_station_id).corporate_name
});
}
List<ListOutputs> loutputs = new List<ListOutputs>();
List<output> lloutputs = output.Fetch("WHERE freight_id = @0", f.id);
foreach (output o in lloutputs)
{
value_outputs += o.value;
loutputs.Add(new ListOutputs()
{
date = Convert.ToDateTime(o.date),
description = o.description,
value = o.value,
customer = customer.SingleOrDefault(o.customer_id).corporate_name
});
}
lf.Add(new ListFreights()
{
comission = f.value_comission,
date = Convert.ToDateTime(f.start),
id = f.id,
listFueleds = lfueled,
listOutputs = loutputs,
driver = isTruck ? driver.SingleOrDefault(f.driver_id).full_name : truck.SingleOrDefault(f.truck_id).board,
outputs = value_outputs,
fueleds = value_fueleds,
product = f.product,
value_ton = f.value_ton,
gross = (f.value_ton * f.weight),
liquid = ((f.value_ton * f.weight) - (f.value_comission + value_fueleds + value_outputs))
});
value_gross += (f.value_ton * f.weight);
}
fm.gross = value_gross;
fm.listFreights = lf;
FreightsByTruckReport report = new FreightsByTruckReport();
report.bdgFreigths.DataSource = fm;
report.list.Value = isTruck ? "Motorista" : "Placa";
report.start_page.Value = isTruck ? "Veículo" : "Motorista";
ReportPrintTool tool = new ReportPrintTool(report);
SplashScreenManager.CloseForm(false);
tool.ShowRibbonPreviewDialog();
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
int customerNo = 0;
if (customersList.Count() > 0)
{
List<CustomersReportData> dataList = new List<CustomersReportData>();
List<CustomersReportDetail> detailsList = new List<CustomersReportDetail>();
foreach (var customer in customersList.OrderBy(c => c.CustomerID))
{
customerNo++;
var detail = new CustomersReportDetail();
var lead = context.Leads.FirstOrDefault
(c => c.CompanyName.ToLower() == customer.CompanyName.ToLower());
detail.CompanyAddress = customer.CompanyAddress;
detail.CompanyName = customer.CompanyName;
detail.CustomerID = customerNo;
detail.DateSigned = customer.DateSigned;
detail.Email = customer.Email;
if (lead != null) { detail.FromLead = "FROM LEAD"; } else { detail.FromLead = ""; }
detail.PhoneNo = customer.PhoneNo;
detail.Website = customer.Website;
detailsList.Add(detail);
}
dataList.Add(new CustomersReportData()
{
ReportHeader = "CUSTOMERS",
ReportTitle = "CUSTOMERS as of " + DateTime.Now.ToString("MMMM dd, yyyy"),
TotalCustomers = detailsList.Count(),
details = detailsList
});
var report = new CustomersReportDesign
{
DataSource = dataList.Distinct(),
Name = "CUSTOMERS as of "
+ DateTime.Now.ToString("MMMM dd, yyyy")
};
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
else
{
var windows = new Shared.Windows.NoticeWindow();
Shared.Windows.NoticeWindow.message = "No data to print.";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
int productNo = 0;
if (productsList.Count() > 0)
{
List<ProductsReportData> dataList = new List<ProductsReportData>();
List<ProductsReportDetails> detailsList = new List<ProductsReportDetails>();
List<LeadsPerProducts> leadsList = new List<LeadsPerProducts>();
var leads = context.Leads.ToList();
foreach (var product in productsList)
{
if (product != null)
{
productNo++;
var detail = new ProductsReportDetails();
detail.Category = product.Category;
detail.Cost = product.Cost;
detail.ProductId = productNo;
detail.ProductName = product.ProductName;
detailsList.Add(detail);
}
if (leads != null)
{
foreach (var lead in leads)
{
var toReport = new LeadsPerProducts();
toReport.LeadName = lead.CompanyName;
leadsList.Add(toReport);
}
}
}
dataList.Add(new ProductsReportData()
{
ReportHeader = "PRODUCTS",
ReportTitle = "PRODUCTS OF as of " + DateTime.Now.ToString("MMMM dd, yyyy"),
TotalProducts = detailsList.Count(),
details = detailsList,
leads = leadsList
});
var report = new ProductsReportDesign
{
DataSource = dataList.Distinct(),
Name = "LEAD ACTIVITIES OF as of " + DateTime.Now.ToString("MMMM dd, yyyy")
};
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
else
{
var windows = new NoticeWindow();
NoticeWindow.message = "No data to print.";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
var accounts = context.CustomerAccounts.ToList();
int accountNo = 0;
if (accounts.Count() > 0)
{
List<CustomerAccountsReportData> dataList = new List<CustomerAccountsReportData>();
List<CustomerAccountsReportDetail> detailsList = new List<CustomerAccountsReportDetail>();
foreach (var account in accounts)
{
accountNo++;
var detail = new CustomerAccountsReportDetail();
var territory = context.Territories.FirstOrDefault(c => c.TerritoryID == account.TerritoryID);
var customer = context.Customers.FirstOrDefault(c => c.CustomerID == account.CustomerID);
var product = context.Products.FirstOrDefault(c => c.ProductID == account.ProductID);
detail.AccountNumber = Convert.ToString(accountNo);
detail.Customer = customer.CompanyName;
detail.Discount = account.Discount;
detail.Gross = account.Gross;
detail.ModeOfPayment = account.ModeOfPayment;
detail.NetValue = account.NetValue;
detail.Product = product.ProductName;
detail.ServiceCharge = account.ServiceCharge;
detail.Territory = territory.TerritoryName;
detailsList.Add(detail);
}
dataList.Add(new CustomerAccountsReportData()
{
ReportHeader = "CUSTOMER ACCOUNTS",
ReportTitle = "CUSTOMER ACCOUNTS as of " + DateTime.Now.ToString("MMMM dd, yyyy"),
TotalCustomerAccounts = detailsList.Count(),
details = detailsList
});
var report = new CustomerAccountsReportDesign
{
DataSource = dataList.Distinct(),
Name = "CUSTOMER ACCOUNTS as of "
+ DateTime.Now.ToString("MMMM dd, yyyy")
};
using (ReportPrintTool printTool = new ReportPrintTool(report))
{
printTool.ShowRibbonPreviewDialog();
}
}
else
{
var windows = new Shared.Windows.NoticeWindow();
Shared.Windows.NoticeWindow.message = "No data to print.";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
}