protected void gvDeposits_Sorting(object sender, GridViewSortEventArgs e)
{
try
{
try
{
string strExpression = e.SortExpression;
string strDirection = ViewState["SortDirection"].ToString();
ClsBAL objBal = new ClsBAL();
if (txtdate.Text == "")
{
txtdate.Text = "1/1/1900";
}
if (txtrefno.Text == "")
{
txtrefno.Text = "1/1/1900";
}
objBal.FromDate = Convert.ToDateTime(txtdate.Text);
objBal.ToDate = Convert.ToDateTime(txtrefno.Text);
DataSet ds = objBal.getdmr();
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;
}
}
void BindDepositRequests()
{
lblMsg.InnerText = "";
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 (ddlagentname.Text != "")
{
ListItem value = ddlagent1.Items.FindByText(ddlagentname.Text.ToString());
if (value != null)
{
ddlagent1.SelectedItem.Value = value.Value;
AgentId = Convert.ToInt32(ddlagent1.SelectedValue);
}
else
{
AgentId = -1;
}
}
ClsBAL obj = new ClsBAL();
obj.FromDate = Convert.ToDateTime(txtdate.Text);
obj.ToDate = Convert.ToDateTime(txtrefno.Text);
obj.createdBy = AgentId;
// obj.type = ddldeposittype.SelectedItem.Text;
DataSet ds = obj.getdmr();
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
gvDeposits.DataSource = ds;
gvDeposits.DataBind();
ViewState["gv"] = ds;
trpaging.Visible = true;
lblerrormsg.Visible = false;
gvDeposits.Visible = true;
//btnUpdateStatus.Visible = true;
}
else
{
// btnUpdateStatus.Visible = false;
trpaging.Visible = false;
lblerrormsg.Text = "No Data Found";
lblerrormsg.ForeColor = System.Drawing.Color.Red;
lblerrormsg.Visible = true;
gvDeposits.Visible = false;
}
}
else
{
// btnUpdateStatus.Visible = false;
trpaging.Visible = false;
lblerrormsg.Text = "No Data Found";
lblerrormsg.ForeColor = System.Drawing.Color.Red;
lblerrormsg.Visible = true;
gvDeposits.Visible = false;
}
}
else
{
//btnUpdateStatus.Visible = false;
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";
//}
}