protected void BindDepositRequests()
{
//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("1/1/1900");
obj.ToDate = Convert.ToDateTime("1/1/1900");
obj.name = Session["UserName"].ToString();
obj.type = "";
DataSet ds = obj.getDepositrequestsforseach();
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = GetTopNRows(ds.Tables[0], 5);
GridView1.DataBind();
ViewState["gv"] = ds;
GridView1.Visible = true;
}
else
{
//trpaging.Visible = false;
//lblerrormsg.Text = "No Data Found";
//lblerrormsg.ForeColor = System.Drawing.Color.Red;
//lblerrormsg.Visible = true;
GridView1.Visible = false;
}
}
else
{
//trpaging.Visible = false;
//lblerrormsg.Text = "No Data Found";
//lblerrormsg.ForeColor = System.Drawing.Color.Red;
//lblerrormsg.Visible = true;
GridView1.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();
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.getDepositrequestsforseach();
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()
{
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 = ddlagentname.Text;
obj.type = ddldeposittype.SelectedItem.Text;
DataSet ds = obj.getDepositrequestsforseach();
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";
//}
if (ddldeposittype.SelectedItem.Text == "")
{
ddldeposittype.SelectedItem.Text = "Please Select";
}
}
