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