public List <ItemSockReport> StockOutReportByCategory(ItemSockReport item)
{
SqlConnection connection = new SqlConnection(connectionString);
query = "SELECT *FROM [ItemWithCategory] WHERE CategoryId=@CategoryId ";
connection.Open();
command = new SqlCommand(query, connection);
command.Parameters.Clear();
command.Parameters.AddWithValue("CategoryId", item.CategoryId);
reader = command.ExecuteReader();
List <ItemSockReport> items = new List <ItemSockReport>();
while (reader.Read())
{
ItemSockReport aItem = new ItemSockReport();
aItem.ItemName = reader["ItemName"].ToString();
aItem.CompanyName = reader["Companyname"].ToString();
aItem.CategoryName = reader["CategoryName"].ToString();
aItem.AvailableQuantity = Convert.ToInt32(reader["AvailableQuantity"]);
aItem.ReorderLevel = Convert.ToInt32(reader["ReorderLevel"]);
items.Add(aItem);
}
reader.Close();
connection.Close();
return(items);
}
public List <ItemSockReport> GetItemReport(ItemSockReport itemReport)
{
if (itemReport.CategoryId == -1)
{
return(aItemStockReportGateway.StockOutReportByCompany(itemReport));
}
if (itemReport.CompanyId == -1)
{
return(aItemStockReportGateway.StockOutReportByCategory(itemReport));
}
return(aItemStockReportGateway.StockOutReport(itemReport));
}
private void searchButton_Click(object sender, EventArgs e)
{
searchViewItemsSummarylistView.Items.Clear();
ItemSockReport itemReport = new ItemSockReport();
itemReport.CategoryId = (int)categoryComboBox.SelectedValue;
itemReport.CompanyId = (int)companyComboBox.SelectedValue;
itemReports = aItemReportManager.GetItemReport(itemReport);
foreach (ItemSockReport aItemReport in itemReports)
{
ListViewItem item = new ListViewItem();
item.Text = ((searchViewItemsSummarylistView.Items.Count + 1).ToString());
item.SubItems.Add(aItemReport.ItemName);
item.SubItems.Add(aItemReport.CompanyName);
item.SubItems.Add(aItemReport.CategoryName);
item.SubItems.Add(aItemReport.AvailableQuantity.ToString());
item.SubItems.Add(aItemReport.ReorderLevel.ToString());
item.Tag = aItemReport;
searchViewItemsSummarylistView.Items.Add(item);
}
}
