internal void setRowsCountSelling()
{
try {
DataSet dataSet = CommonManagerImpl.getStockBeforeSaleForFilter(
(!String.IsNullOrWhiteSpace(oldStockBySellingInvoice.textBox_itemId.Text) ? Convert.ToInt32(oldStockBySellingInvoice.textBox_itemId.Text) : 0),
(oldStockBySellingInvoice.datePicker_dateFrom_filter.SelectedDate != null ? Convert.ToDateTime(oldStockBySellingInvoice.datePicker_dateFrom_filter.SelectedDate).ToString("yyyy-MM-dd") : null),
(oldStockBySellingInvoice.datePicker_dateTo_filter.SelectedDate != null ? Convert.ToDateTime(oldStockBySellingInvoice.datePicker_dateTo_filter.SelectedDate).ToString("yyyy-MM-dd") : null),
true, oldStockBySellingInvoice.Pagination.LimitStart, oldStockBySellingInvoice.Pagination.LimitCount);
oldStockBySellingInvoice.Pagination.RowsCount = Convert.ToInt32(dataSet.Tables[0].Rows[0][0]);
} catch (Exception) {
}
}
internal void filterSelling()
{
try {
DataSet dataSet = CommonManagerImpl.getStockBeforeSaleForFilter(
(!String.IsNullOrWhiteSpace(oldStockBySellingInvoice.textBox_itemId.Text) ? Convert.ToInt32(oldStockBySellingInvoice.textBox_itemId.Text) : 0),
(oldStockBySellingInvoice.datePicker_dateFrom_filter.SelectedDate != null ? Convert.ToDateTime(oldStockBySellingInvoice.datePicker_dateFrom_filter.SelectedDate).ToString("yyyy-MM-dd") : null),
(oldStockBySellingInvoice.datePicker_dateTo_filter.SelectedDate != null ? Convert.ToDateTime(oldStockBySellingInvoice.datePicker_dateTo_filter.SelectedDate).ToString("yyyy-MM-dd") : null),
false, oldStockBySellingInvoice.Pagination.LimitStart, oldStockBySellingInvoice.Pagination.LimitCount);
oldStockBySellingInvoice.DataTable.Rows.Clear();
//Convert.ToDouble(row[6]).ToString("#,##0.00")
foreach (DataRow row in dataSet.Tables[0].Rows)
{
oldStockBySellingInvoice.DataTable.Rows.Add(row[0], row[1], row[2], Convert.ToDateTime(row[3]).ToString("yyyy-MM-dd"),
row[4], Convert.ToDouble(row[5]).ToString("#,##0.00"), Convert.ToDouble(row[6]).ToString("#,##0.00"), Convert.ToDouble(row[7]).ToString("#,##0.00"),
Convert.ToDouble(row[8]).ToString("#,##0.00"), Convert.ToDouble(row[9]).ToString("#,##0.00"));
}
} catch (Exception) {
}
}
