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"; } }