private void GetData()
{
DataTable dt = null;
dgvData.DataSource = dt;
DateTime? startDate = dtpStartDate.Value;
DateTime? endDate = dtpEndDate.Value;
if (chkAllDates.Checked)
{
startDate = null;
endDate = null;
}
string strId = string.IsNullOrEmpty(cbSelect.ValueMember) ? string.Empty : Convert.ToString(((DataRowView)(cbSelect.SelectedItem)).Row[cbSelect.ValueMember]);//Convert.ToString(cbSelect.SelectedValue);
long Id = 0;
if (long.TryParse(strId, out Id) && Id >= 0)
{
if (IsCutomerReport)
{
FetchCustomerTransaction(dt, startDate, endDate, strId);
}
else
{
Company comp = new Company();
dt = comp.SelectCompanyTransactions(Common.FormateDateForDB(startDate), Common.FormateDateForDB(endDate), strId);
dgvData.DataSource = dt;
dgvData.Columns["TransactionId"].Visible = false;
dgvData.Columns["TransactionDate"].HeaderText = "Date";
dgvData.Columns["TransactionDate"].DefaultCellStyle.Format = "dd-MM-yyyy HH:mm";
dgvData.Columns["Name"].HeaderText = "Supplier";
Common.FormatCurrencyColumn(dgvData, "Debit,Credit,Amount,Balance");
}
FormatGrid();
}
if (dt != null)
{
dgvData.DataSource = dt;
}
}
