public static Print_QuotationItemsList GetData(string p_id) { Print_QuotationItemsList list = new Print_QuotationItemsList(); // List <Upvc_Quotationitems> inv_item_list = CUpvc_Quotationitems_exten.FKId(p_id, new DAL()); for (int r = 0; r <= inv_item_list.Count - 1; r++) { Print_QuotationitemsRow row = new Print_QuotationitemsRow(); // row.QUOTATION_ITEM_ID = inv_item_list[r].Upvc_Quotationitems_id; row.QUOTATION_ID = inv_item_list[r].Upvc_Quotation_id; row.SL_NO = (r + 1).ToString(); row.PRODUCT_ID = inv_item_list[r].Product_id; row.HSN_CODE_ID = Ccoreplus.GetHsncode_name(inv_item_list[r].Product_id); row.PCRATE = inv_item_list[r].Pcrate; row.MSM = inv_item_list[r].Msm; row.QTY = ConvertTO.DecimalToS(inv_item_list[r].Qty.ToString()); row.WIDTHS = ConvertTO.DecimalToS(inv_item_list[r].Widths.ToString()); row.HEIGTHS = ConvertTO.DecimalToS(inv_item_list[r].Heights.ToString()); row.AREASQ = ConvertTO.DecimalToS(inv_item_list[r].TotalAreasq.ToString()); row.PRICE = ConvertTO.DecimalToS(inv_item_list[r].Price.ToString()); Upvc_invoiceitems obj = new Upvc_invoiceitems() { Pcrate = row.PCRATE, Msm = row.MSM, Qty = ConvertTO.Decimal(row.QTY), Widths = ConvertTO.Decimal(row.WIDTHS), Heights = ConvertTO.Decimal(row.HEIGTHS), Price = ConvertTO.Decimal(row.PRICE), Cgst_percent = inv_item_list[r].Cgst_percent, Sgst_percent = inv_item_list[r].Sgst_percent, Igst_percent = inv_item_list[r].Igst_percent }; UpvcCalculation.Calculate(obj); row.TAXABLEVALUE = ConvertTO.Decimal2d(obj.Taxable_amount.ToString()); row.CGST_PERCENT = ConvertTO.DecimalToS(obj.Cgst_percent.ToString()); row.CGST_AMOUNT = ConvertTO.Decimal2d(obj.Cgst_amount.ToString()); row.SGST_PERCENT = ConvertTO.DecimalToS(obj.Sgst_percent.ToString()); row.SGST_AMOUNT = ConvertTO.Decimal2d(obj.Sgst_amount.ToString()); row.SUB_TOTAL = ConvertTO.Decimal2d((obj.Taxable_amount + obj.Cgst_amount + obj.Sgst_amount + obj.Igst_amount).ToString()); list.Add(row); // } // return(list); }
static void localReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e) { switch (e.DataSourceNames[0]) { case "MyDataSource_Items": try { Print_QuotationItemsList data_AT = P_QuotationItem.GetData(vPId); e.DataSources.Add(new ReportDataSource("MyDataSource_Items", data_AT)); } catch (Exception ex) { MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace); } break; } }
public static void Print(ReportViewer pRptViewer, string p_id) { Print_QuotationItemsList data = GetData(p_id); LocalReport localReport = pRptViewer.LocalReport; //= Set Report Path localReport.ReportPath = Application.StartupPath + @"\PRINTS\P_InvoiceItem.rdlc"; //(1)// localReport.DisplayName = "invoice items"; //= Set Report Data Source localReport.DataSources.Add(new ReportDataSource("MyDataSource_Items", data)); //(2)// //= Refresh the report PrinterSettings v_PrinterSettings = GetPrinterSettings(); pRptViewer.PrinterSettings = v_PrinterSettings; pRptViewer.SetPageSettings(v_PrinterSettings.DefaultPageSettings); pRptViewer.RefreshReport(); }