internal void setCompanyReturnRowsCount()
{
try {
DataSet dataSet = CommonManagerImpl.getCompanyReturnForFilter(companyReturnHistory.textBox_itemName.Text, companyReturnHistory.textBox_itemCode.Text,
companyReturnHistory.textBox_barcode.Text, Convert.ToInt32(companyReturnHistory.comboBox_vendor.SelectedValue),
companyReturnHistory.textBox_invoice.Text, companyReturnHistory.textBox_grn.Text,
(companyReturnHistory.datePicker_from.SelectedDate != null ? Convert.ToDateTime(companyReturnHistory.datePicker_from.SelectedDate).ToString("yyyy-MM-dd") : null),
(companyReturnHistory.datePicker_to.SelectedDate != null ? Convert.ToDateTime(companyReturnHistory.datePicker_to.SelectedDate).ToString("yyyy-MM-dd") : null),
true, companyReturnHistory.Pagination.LimitStart, companyReturnHistory.Pagination.LimitCount);
companyReturnHistory.Pagination.RowsCount = Convert.ToInt32(dataSet.Tables[0].Rows[0][0]);
} catch (Exception) {
}
}
internal void filterCompanyReturn()
{
try {
DataSet dataSet = CommonManagerImpl.getCompanyReturnForFilter(companyReturnHistory.textBox_itemName.Text, companyReturnHistory.textBox_itemCode.Text,
companyReturnHistory.textBox_barcode.Text, Convert.ToInt32(companyReturnHistory.comboBox_vendor.SelectedValue),
companyReturnHistory.textBox_invoice.Text, companyReturnHistory.textBox_grn.Text,
(companyReturnHistory.datePicker_from.SelectedDate != null ? Convert.ToDateTime(companyReturnHistory.datePicker_from.SelectedDate).ToString("yyyy-MM-dd") : null),
(companyReturnHistory.datePicker_to.SelectedDate != null ? Convert.ToDateTime(companyReturnHistory.datePicker_to.SelectedDate).ToString("yyyy-MM-dd") : null),
false, companyReturnHistory.Pagination.LimitStart, companyReturnHistory.Pagination.LimitCount);
companyReturnHistory.DataTable.Rows.Clear();
foreach (DataRow row in dataSet.Tables[0].Rows)
{
companyReturnHistory.DataTable.Rows.Add(row[0], row[1], row[2], row[3], row[4], Convert.ToDateTime(row[5]).ToString("yyyy-MM-dd"),
Convert.ToDouble(row[6]).ToString("#,##0.00"), Convert.ToDouble(row[7]).ToString("#,##0.00"), Convert.ToDouble(row[8]).ToString("#,##0.00"));
}
} catch (Exception) {
}
}
