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