private void LoadGrid()
{
if (!vImReady)
{
return;
}
try
{
string vWhere = string.Empty;
int vid = 0;
if (cboProjects.SelectedItem != null)
{
vid = int.Parse(cboProjects.SelectedValue.ToString());
}
if (vid > 0)
{
vWhere += " AND ProjectID=" + vid;
}
if (cboUsers.SelectedItem != null)
{
vid = int.Parse(cboUsers.SelectedValue.ToString());
}
if (vid > 0)
{
vWhere += " AND UserID=" + vid;
}
if (cboStatus.SelectedItem != null)
{
if (cboStatus.Text == "Un Posted")
{
vWhere += " AND Selected=0";
}
else if (cboStatus.Text == "Posted")
{
vWhere += " AND Selected=1";
}
}
if (cboVoucherType.SelectedItem != null)
{
if (cboVoucherType.Text != "ALL")
{
vWhere += " AND VoucherType='" + cboVoucherType.Text.Trim() + "'";
}
}
DataTable dt = objDAL.getVouchersForAdmin(vWhere);
Grid.AutoGenerateColumns = false;
Grid.DataSource = dt;
}
catch (Exception exc)
{
MessageBox.Show(exc.Message.ToString(), "Error");
}
}
