private void BindDataGridView() { DEInvoiceReturnDetail invoiceReturnDetail = new DEInvoiceReturnDetail(); invoiceReturnDetail.Invoice_Id = invoice.Invoice_Id; BLLInvoiceReturnDetail obj_BLLInvoiceReturnDetail = new BLLInvoiceReturnDetail(); DataTable dt_InvoiceReturnDetail; dt_InvoiceReturnDetail = obj_BLLInvoiceReturnDetail.LoadInvoiceReturnDetailTableForAllDataByInvoiceId(invoiceReturnDetail); dgv_ProductList.DataSource = dt_InvoiceReturnDetail; NumberingTableForDataGridView(dt_InvoiceReturnDetail); this.dt_ProductList = dt_InvoiceReturnDetail; FormatDataGridView(); calculateTotal(dt_InvoiceReturnDetail); }
private void bindInvoiceReport() { DataTable dt_Invoice; DataTable dt_InvoiceDetail; DataTable dt_InvoiceReturnDetail; DEInvoice invoice = new DEInvoice(); invoice.Invoice_Id = invoice_Id; DEInvoiceDetail invoiceDetail = new DEInvoiceDetail(); invoiceDetail.Invoice_Id = invoice_Id; DEInvoiceReturnDetail invoiceReturnDetail = new DEInvoiceReturnDetail(); invoiceReturnDetail.Invoice_Id = invoice_Id; BLLInvoice obj_BLLInvoice = new BLLInvoice(); BLLInvoiceDetail obj_BLLInvoiceDetail = new BLLInvoiceDetail(); BLLInvoiceReturnDetail obj_BLLInvoiceReturnDetail = new BLLInvoiceReturnDetail(); dt_Invoice = obj_BLLInvoice.LoadInvoiceTableForAllDataByInvoice_Id(invoice); dt_InvoiceDetail = obj_BLLInvoiceDetail.LoadInvoiceDetailTableForAllDataByInvoiceId(invoiceDetail); dt_InvoiceReturnDetail = obj_BLLInvoiceReturnDetail.LoadInvoiceReturnDetailTableForAllDataByInvoiceId(invoiceReturnDetail); NumberingTableForDataGridView(dt_InvoiceDetail); NumberingTableForDataGridView(dt_InvoiceReturnDetail); rptv_ConsignInvoiceReport.Clear(); rptv_ConsignInvoiceReport.Reset(); rptv_ConsignInvoiceReport.ProcessingMode = ProcessingMode.Local; LocalReport localReport = rptv_ConsignInvoiceReport.LocalReport; if (chb_SmallSize.Checked == false) { localReport.ReportEmbeddedResource = "StockAndSale.WinUI.Reports.Classes.Rpt_ConsignInvoiceReport.rdlc"; } else { localReport.ReportEmbeddedResource = "StockAndSale.WinUI.Reports.Classes.Rpt_ConsignInvoiceA5Report.rdlc"; } ReportDataSource ds_Invoice = new ReportDataSource(); ds_Invoice.Name = "DS_InvoiceReport_dt_Invoice"; ds_Invoice.Value = dt_Invoice; ReportDataSource ds_InvoiceDetail = new ReportDataSource(); ds_InvoiceDetail.Name = "DS_InvoiceReport_dt_InvoiceDetail"; ds_InvoiceDetail.Value = dt_InvoiceDetail; ReportDataSource ds_InvoiceReturnDetail = new ReportDataSource(); ds_InvoiceReturnDetail.Name = "DS_InvoiceReport_dt_InvoiceReturnDetail"; ds_InvoiceReturnDetail.Value = dt_InvoiceReturnDetail; ReportParameter parTotal = new ReportParameter(); parTotal.Name = "parTotal"; ReportParameter parAdvance = new ReportParameter(); parAdvance.Name = "parAdvance"; ReportParameter parDiscount = new ReportParameter(); parDiscount.Name = "parDiscount"; ReportParameter parCommercialTax = new ReportParameter(); parCommercialTax.Name = "parCommercialTax"; ReportParameter parDeliveryDiscount = new ReportParameter(); parDeliveryDiscount.Name = "parDeliveryDiscount"; ReportParameter parReturnAmount = new ReportParameter(); parReturnAmount.Name = "parReturnAmount"; ReportParameter parDifferenceTotal = new ReportParameter(); parDifferenceTotal.Name = "parDifferenceTotal"; ReportParameter parGrandTotal = new ReportParameter(); parGrandTotal.Name = "parGrandTotal"; ReportParameter parInvoiceNo = new ReportParameter(); parInvoiceNo.Name = "parInvoiceNo"; ReportParameter parInvoiceDate = new ReportParameter(); parInvoiceDate.Name = "parInvoiceDate"; ReportParameter parCustomerName = new ReportParameter(); parCustomerName.Name = "parCustomerName"; ReportParameter parCustomerShop = new ReportParameter(); parCustomerShop.Name = "parCustomerShop"; ReportParameter parAddress = new ReportParameter(); parAddress.Name = "parAddress"; ReportParameter parPhone = new ReportParameter(); parPhone.Name = "parPhone"; ReportParameter parPONumber = new ReportParameter(); parPONumber.Name = "parPONumber"; ReportParameter parPromDesc = new ReportParameter(); parPromDesc.Name = "parPromDesc"; ReportParameter parIsPromotion = new ReportParameter(); parIsPromotion.Name = "parIsPromotion"; ReportParameter parPaymentStatus = new ReportParameter(); parPaymentStatus.Name = "parPaymentStatus"; ReportParameter parPaymentDate = new ReportParameter(); parPaymentDate.Name = "parPaymentDate"; ReportParameter parInvoiceDueDate = new ReportParameter(); parInvoiceDueDate.Name = "parInvoiceDueDate"; ReportParameter parShowReturn = new ReportParameter(); parShowReturn.Name = "parShowReturn"; ReportParameter parShow = new ReportParameter(); parShow.Name = "parShowLetterHead"; parShow.Values.Add(chb_ShowLetterHead.Checked.ToString()); ReportParameter parShowFooter = new ReportParameter(); parShowFooter.Name = "parShowLetterFooter"; parShowFooter.Values.Add(chb_ShowLetterFooter.Checked.ToString()); if (chb_Return.Checked == true) { parShowReturn.Values.Add("true"); } else { parShowReturn.Values.Add("false"); } Boolean bool_HasRow = obj_BLLInvoice.LoadInvoiceRow(invoice); if (true) { if (invoice.isPaid == true) { parPaymentStatus.Values.Add("Paid on :"); parPaymentDate.Values.Add(invoice.PayDate.ToLongDateString()); } else { parPaymentStatus.Values.Add("No Paid :"); parPaymentDate.Values.Add(""); } parInvoiceDueDate.Values.Add(invoice.Invoice_Due_Date.ToString()); parTotal.Values.Add(invoice.Total.ToString()); parAdvance.Values.Add(invoice.Advance.ToString()); parDiscount.Values.Add(invoice.Discount.ToString()); parCommercialTax.Values.Add(invoice.CommercialTax.ToString()); parDeliveryDiscount.Values.Add(invoice.DeliveryDiscount.ToString()); parGrandTotal.Values.Add(invoice.GrandTotal.ToString()); parInvoiceNo.Values.Add(invoice.Invoice_No.ToString()); parInvoiceDate.Values.Add(invoice.Invoice_Date.ToString()); parCustomerName.Values.Add(invoice.Customer_Name); parCustomerShop.Values.Add(invoice.Customer_Description); parAddress.Values.Add(invoice.Address); parPhone.Values.Add(invoice.Phone); parPONumber.Values.Add(invoice.PONumber); parPromDesc.Values.Add(invoice.PromDesc); parIsPromotion.Values.Add(invoice.IsPromotion.ToString()); Decimal dec_RetTotal = 0; Decimal dec_DiffTotal = 0; for (int i = 0; i < dt_InvoiceReturnDetail.Rows.Count; i++) { dec_RetTotal += Convert.ToDecimal(dt_InvoiceReturnDetail.Rows[i]["RAmount"].ToString()); } if (dec_RetTotal != 0) { dec_DiffTotal = invoice.GrandTotal - dec_RetTotal; } parReturnAmount.Values.Add(dec_RetTotal.ToString()); parDifferenceTotal.Values.Add(dec_DiffTotal.ToString()); } rptv_ConsignInvoiceReport.LocalReport.SetParameters(new ReportParameter[] { parTotal, parAdvance, parDiscount, parGrandTotal, parInvoiceNo, parInvoiceDate, parCustomerName, parCustomerShop, parAddress, parPhone, parInvoiceDueDate, parPaymentStatus, parPaymentDate, parShowReturn, parShow, parShowFooter, parPONumber, parPromDesc, parIsPromotion, parDeliveryDiscount, parCommercialTax, parReturnAmount, parDifferenceTotal }); // parPaymentStatus, parPaymentDate, parInvoiceDueDate }); localReport.DataSources.Add(ds_InvoiceDetail); localReport.DataSources.Add(ds_Invoice); localReport.DataSources.Add(ds_InvoiceReturnDetail); rptv_ConsignInvoiceReport.RefreshReport(); }