public DataTable GetSellsItem(SellsDate date)
{
if (date.From > date.To)
{
throw new Exception("Input should be like FromDate<ToDate");
}
return(_search.GetSellsItem(date));
}
public DataTable GetSellsItem(SellsDate date)
{
string fromDate = date.From.ToString("yyyy-MM-dd");
string toDate = date.To.ToString("yyyy-MM-dd");
int status = Convert.ToInt32(StatusEnum.Sale);
string query =
"SELECT i.Name Item, s.Quantity Sale_Quantity FROM StockOut s JOIN Items i ON i.Id = s.ItemId WHERE Status = '" + status + "' AND (Date BETWEEN '" + fromDate + "' AND '" + toDate + "') ORDER BY s.Id DESC ";
return(_mainRepository.GetAllItem(query));
}
private void searchButton_Click(object sender, EventArgs e)
{
try
{
SellsDate date = new SellsDate();
date.From = fromDatePicker.Value;
date.To = toDatePicker.Value;
sellsItemDataGrid.DataSource = _search.GetSellsItem(date);
model.AddAutoIncrementColumn(sellsItemDataGrid);
sellsItemDataGrid.Show();
exportButton.Show();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
