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));
}
