void BindDeposits()
{
if (txtdate.Text == "")
{
txtdate.Text = "1/1/1900";
}
if (txtrefno.Text == "")
{
txtrefno.Text = "1/1/1900";
}
//if (ddlagentname.SelectedItem.Text == "Please Select")
//{
// ddlagentname.SelectedItem.Text = "";
//}
if (ddldeposittype.SelectedItem.Text == "Please Select")
{
ddldeposittype.SelectedItem.Text = "";
}
ClsBAL obj = new ClsBAL();
obj.FromDate = Convert.ToDateTime(txtdate.Text);
obj.ToDate = Convert.ToDateTime(txtrefno.Text);
obj.name = txtAgents.Text.Trim(); //ddlagentname.SelectedItem.Text;
obj.type = ddldeposittype.SelectedItem.Text;
DataSet ds = obj.getDepositsByAdminForAgents();
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
gvDeposits.DataSource = ds;
// ViewState["Users"] = ds.Tables[0];
gvDeposits.DataBind();
ViewState["gv"] = ds;
trpaging.Visible = true;
lblerrormsg.Visible = false;
gvDeposits.Visible = true;
}
else
{
trpaging.Visible = false;
lblerrormsg.Text = "No Data Found";
lblerrormsg.ForeColor = System.Drawing.Color.Red;
lblerrormsg.Visible = true;
gvDeposits.Visible = false;
}
}
else
{
trpaging.Visible = false;
lblerrormsg.Text = "No Data Found";
lblerrormsg.ForeColor = System.Drawing.Color.Red;
lblerrormsg.Visible = true;
gvDeposits.Visible = false;
}
}
else
{
trpaging.Visible = false;
lblerrormsg.Text = "No Data Found";
lblerrormsg.ForeColor = System.Drawing.Color.Red;
lblerrormsg.Visible = true;
gvDeposits.Visible = false;
}
if (txtdate.Text == "1/1/1900")
{
txtdate.Text = "";
}
if (txtrefno.Text == "1/1/1900")
{
txtrefno.Text = "";
}
//if (ddlagentname.SelectedItem.Text == "")
//{
// ddlagentname.SelectedItem.Text = "Please Select";
//}
if (ddldeposittype.SelectedItem.Text == "")
{
ddldeposittype.SelectedItem.Text = "Please Select";
}
}
protected void gvDeposits_Sorting(object sender, GridViewSortEventArgs e)
{
try
{
try
{
string strExpression = e.SortExpression;
string strDirection = ViewState["SortDirection"].ToString();
if (txtdate.Text == "")
{
txtdate.Text = "1/1/1900";
}
if (txtrefno.Text == "")
{
txtrefno.Text = "1/1/1900";
}
if (ddldeposittype.SelectedItem.Text == "Please Select")
{
ddldeposittype.SelectedItem.Text = "";
}
ClsBAL obj = new ClsBAL();
obj.FromDate = Convert.ToDateTime(txtdate.Text);
obj.ToDate = Convert.ToDateTime(txtrefno.Text);
obj.name = txtAgents.Text.Trim(); //ddlagentname.SelectedItem.Text;
obj.type = ddldeposittype.SelectedItem.Text;
DataSet ds = obj.getDepositsByAdminForAgents();
DataTable dt = ds.Tables[0];
DataView dv = new DataView(dt);
dv.Sort = strExpression + strDirection;
gvDeposits.DataSource = dv;
gvDeposits.DataBind();
if (strDirection == " ASC") { ViewState["SortDirection"] = " DESC"; } else { ViewState["SortDirection"] = " ASC"; }
if (txtdate.Text == "1/1/1900")
{
txtdate.Text = "";
}
if (txtrefno.Text == "1/1/1900")
{
txtrefno.Text = "";
}
}
catch (Exception ex)
{
lblMsg.InnerHtml = ex.Message;
throw;
}
}
catch (Exception ex)
{
lblMsg.InnerHtml = ex.Message;
throw;
}
}
