private void FormatPage(object sender, PrintPageEventArgs e) { graphics = e.Graphics; Font minifont = new Font("Arial", 5); Font itemfont = new Font("Arial", 6); Font smallfont = new Font("Arial", 10); Font mediumfont = new Font("Arial", 14); Font largefont = new Font("Arial", 16); int Offset = 10; int smallinc = 10, mediuminc = 12, largeinc = 17; //Getting Receipt data List <DetailedDailyReportModel> detailedDailyReportModels = new List <DetailedDailyReportModel>(); ReportViewModel reportViewModel = new ReportViewModel(); detailedDailyReportModels = reportViewModel.GetDetailedDailyByDate(FromDate, Todate); Offset = Offset + Offset; graphics.DrawString(LoginDetail.ClientName, smallfont, new SolidBrush(Color.Black), 14, Offset); Offset = Offset + mediuminc; InsertItemList(LoginDetail.OutletName, "", Offset, 5); Offset = Offset + mediuminc; Offset = Offset + mediuminc; //InsertItemList("DETAILED DAILY REPORT", "", Offset, 5); //Offset = Offset + mediuminc; //Offset = Offset + mediuminc; //InsertItemList("DATE: " + FromDate, "", Offset, 5); //Offset = Offset + mediuminc; foreach (var item in detailedDailyReportModels) { InsertItemList(item.RegisterTitle.ToString(), "", Offset, 5); InsertItemList(item.RegisterValue.ToString(), "", Offset, 175 + (50 - (item.RegisterValue.ToString().Length * 4))); Offset = Offset + mediuminc; } Offset = Offset + mediuminc; Offset = Offset + mediuminc; }
private void btnDetailedDailyExcel_Click(object sender, RoutedEventArgs e) { try { DateTime dtFrom = new DateTime(); DateTime dtTo = new DateTime(); dtFrom = (DateTime)dpDetailedDailyFromDate.Value; dtTo = (DateTime)dpDetailedDailyToDate.Value; List <DetailedDailyReportModel> detailedDailyReportModels = new List <DetailedDailyReportModel>(); ReportViewModel reportViewModel = new ReportViewModel(); detailedDailyReportModels = reportViewModel.GetDetailedDailyByDate(dtFrom.ToString("yyyy-MM-dd HH:mi:ss"), dtTo.ToString("yyyy-MM-dd HH:mi:ss")); CommonMethods commonMethods = new CommonMethods(); string path = string.Empty, firstLine = string.Empty; string fileName = "DetailedDailyReport_" + DateTime.Now.ToString("MM-dd-yyyy_HHmmss"); var saveFileDialog = new SaveFileDialog { FileName = fileName != "" ? fileName : "gpmfca-exportedDocument", DefaultExt = ".xlsx", Filter = "Common Seprated Documents (.xlsx)|*.xlsx" }; if (saveFileDialog.ShowDialog() == true) { path = saveFileDialog.FileName; DataTable table = new DataTable(); table = commonMethods.ConvertToDataTable(detailedDailyReportModels); firstLine = "Detailed Daily List for " + dtFrom.ToString("yyyy-MM-dd HH:mi:ss") + " to " + dtTo.ToString("yyyy-MM-dd HH:mi:ss"); commonMethods.WriteExcelDetailDailySalesFile(table, path, firstLine); } } catch (Exception ex) { SystemError.Register(ex); } }