public List <GetStockInfoView> GetDataBtnDate(string fromDate, string toDate)
{
string query = "SELECT ItemName, CompanyName, SUM(StockOutQuantity) AS StockOutQuantity FROM GetStockInfo WHERE " +
"EntryTime BETWEEN '" + fromDate + "' AND '" + toDate + "' AND (Action = 'Sell') GROUP BY ItemName, CompanyName";
command = new SqlCommand(query, connection);
connection.Open();
reader = command.ExecuteReader();
List <GetStockInfoView> getSaleBtnDateList = new List <GetStockInfoView>();
while (reader.Read())
{
GetStockInfoView getSaleBtnDate = new GetStockInfoView();
getSaleBtnDate.ItemName = reader["ItemName"].ToString();
getSaleBtnDate.CompanyName = reader["CompanyName"].ToString();
getSaleBtnDate.StockOutQuantity = Convert.ToInt32(reader["StockOutQuantity"]);
getSaleBtnDateList.Add(getSaleBtnDate);
}
connection.Close();
return(getSaleBtnDateList);
}
public SearchBetweenDateUI()
{
stockInfoView = new GetStockInfoView();
stockOutManager = new StockOutManager();
}