private void SearchButton_Click(object sender, EventArgs e)
{
string startDate = StartDatePicker.Text;
string endDate = EndDatePicker.Text;
List <StockReport> ItemSalesList = new List <StockReport>();
SalesListView.Clear();
ItemSalesList.Clear();
string query = @"SELECT ItemName, StockOutQuantity FROM StockReport WHERE SalesFlag = 1";
SqlCommand command = new SqlCommand(query, connect);
if (connect.State == ConnectionState.Open)
{
connect.Close();
}
else
{
connect.Open();
}
SqlDataReader dataReader = command.ExecuteReader();
SalesListView.Columns.Add("SI");
SalesListView.Columns.Add("Item Name");
SalesListView.Columns.Add("Quantity");
if (dataReader.HasRows)
{
while (dataReader.Read())
{
string[] arr = new string[3];
ListViewItem itm;
arr[0] = si.ToString();
arr[1] = dataReader["ItemName"].ToString();
arr[2] = dataReader["StockOutQuantity"].ToString();
itm = new ListViewItem(arr);
SalesListView.Items.Add(itm);
si++;
}
}
else
{
}
connect.Close();
}
public async Task <SaleQueryListView> GetAllSaleTask(SaleViewListModel query)
{
SaleQueryListView queryList = new SaleQueryListView();
queryList.Count = GetAll().Count();
var saleAll = GetAll().Skip(query.Size * query.Page).Take(query.Size).ToList();
List <SalesListView> list = new List <SalesListView>();
foreach (Sale sale in saleAll)
{
var sales = new SalesListView();
sales.SaleId = sale.SaleId;
sales.NoOfProducts = sale.NoOfItem;
sales.Amount = sale.TotalAmount;
sales.SaleName = "";
sales.SaleDate = sale.Create.ToString("MM/dd/yyyy h:mm tt");
list.Add(sales);
}
queryList.listView = list;
return(queryList);
}
