public List <ReportPurchase> ShowReportPurchases(ReportPurchase _reportPurchase) { List <ReportPurchase> reportPurchases = new List <ReportPurchase>(); SqlConnection sqlConnection = new SqlConnection(connection.connectionString); string commandString = @"select Code,Products,Category,AvailableQty,UnitPrice as CurrentPrice,MRP,Profit from ProductsPurchase where Date between '" + _reportPurchase.StartDate + "' and '" + _reportPurchase.EndDate + "'"; SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection); sqlConnection.Open(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { ReportPurchase reportPurchase = new ReportPurchase(); //stock.Code = sqlDataReader["Code"].ToString(); //stock.Name = sqlDataReader["Name"].ToString(); //stock.Category = sqlDataReader["Category"].ToString(); //stock.ReOrderLevel = sqlDataReader["ReOrderLevel"].ToString(); //stock.ExpireDate = sqlDataReader["ExpireDate"].ToString(); //stock.Quantity = sqlDataReader["Quantity"].ToString(); reportPurchase.Code = sqlDataReader["Code"].ToString(); reportPurchase.Name = sqlDataReader["Products"].ToString(); reportPurchase.Category = sqlDataReader["Category"].ToString(); reportPurchase.AvailableQty = sqlDataReader["AvailableQty"].ToString(); reportPurchase.CurrentPrice = sqlDataReader["CurrentPrice"].ToString(); reportPurchase.MRP = sqlDataReader["MRP"].ToString(); reportPurchase.Profit = sqlDataReader["Profit"].ToString(); reportPurchases.Add(reportPurchase); } sqlConnection.Close(); return(reportPurchases); }
private void DisplayReportPurchaseYear() { var rNames = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("prototype2.rdlcfiles.PurchaseReport.rdlc"); ReportPurchase.DataSources.Add(new Syncfusion.Windows.Reports.ReportDataSource("PurchaseTable", GetPurchaseYear())); ReportPurchase.LoadReport(rNames); ReportPurchase.ProcessingMode = Syncfusion.Windows.Reports.Viewer.ProcessingMode.Local; ReportPurchase.RefreshReport(); }
private void ComboBoxSalesFilter_SelectionChanged(object sender, SelectionChangedEventArgs e) { Object SELECTEDINDEX = ComboBoxSalesFilter.SelectedIndex; if (SELECTEDINDEX.Equals(0)) { ReportPurchase.Reset(); ComboBoxYearSales.Visibility = Visibility.Hidden; ComboBoxMonthSales.Visibility = Visibility.Visible; MonthSales.Visibility = Visibility.Visible; YearSales.Visibility = Visibility.Hidden; SalesDateStart.Visibility = Visibility.Hidden; SalesDateEnd.Visibility = Visibility.Hidden; labelstart.Visibility = Visibility.Hidden; labelend.Visibility = Visibility.Hidden; labelweek.Visibility = Visibility.Hidden; } if (SELECTEDINDEX.Equals(1)) { ReportPurchase.Reset(); ComboBoxYearSales.Visibility = Visibility.Visible; ComboBoxMonthSales.Visibility = Visibility.Hidden; MonthSales.Visibility = Visibility.Hidden; YearSales.Visibility = Visibility.Visible; SalesDateStart.Visibility = Visibility.Hidden; SalesDateEnd.Visibility = Visibility.Hidden; labelstart.Visibility = Visibility.Hidden; labelend.Visibility = Visibility.Hidden; labelweek.Visibility = Visibility.Hidden; } if (SELECTEDINDEX.Equals(2)) { ReportPurchase.Reset(); ComboBoxYearSales.Visibility = Visibility.Hidden; ComboBoxMonthSales.Visibility = Visibility.Hidden; MonthSales.Visibility = Visibility.Hidden; YearSales.Visibility = Visibility.Hidden; SalesDateStart.Visibility = Visibility.Visible; SalesDateEnd.Visibility = Visibility.Visible; labelstart.Visibility = Visibility.Visible; labelend.Visibility = Visibility.Visible; labelweek.Visibility = Visibility.Hidden; } if (SELECTEDINDEX.Equals(3)) { } if (SELECTEDINDEX.Equals(4)) { } }
private void UserControl_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e) { if (this.IsVisible) { DisplayReport(); } else { ReportPurchase.Reset(); } }
private void btnPrint_Click(object sender, EventArgs e) { try { if (passedPid == 0) { panel3.Show(); lblError.Text = "No suck bill exists. Select valid bill."; } else { ReportPurchase rpt = new ReportPurchase(passedPid); rpt.ShowDialog(); } } catch (Exception x) { } }
public List <ReportPurchase> ShowReportPurchases(ReportPurchase _reportPurchase) { return(_reportPurchaseRepository.ShowReportPurchases(_reportPurchase)); }
public List <ReportPurchase> SearchStockProductCategory(ReportPurchase _reportPurchase) { return(_reportPurchaseRepository.SearchPurchaseDate(_reportPurchase)); }