protected void GvCertificateBin_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GvCertificateBin.PageIndex = e.NewPageIndex;
DataTable dt = (DataTable)Session["dtBinFilter"];
GvCertificateBin.DataSource = dt;
GvCertificateBin.DataBind();
AllPageCode();
string temp = string.Empty;
for (int i = 0; i < GvCertificateBin.Rows.Count; i++)
{
Label lblconid = (Label)GvCertificateBin.Rows[i].FindControl("lblCertificateId");
string[] split = lblSelectedRecord.Text.Split(',');
for (int j = 0; j < lblSelectedRecord.Text.Split(',').Length; j++)
{
if (lblSelectedRecord.Text.Split(',')[j] != "")
{
if (lblconid.Text.Trim().ToString() == lblSelectedRecord.Text.Split(',')[j].Trim().ToString())
{
((CheckBox)GvCertificateBin.Rows[i].FindControl("chkgvSelect")).Checked = true;
}
}
}
}
}
protected void GvCertificateBin_OnSorting(object sender, GridViewSortEventArgs e)
{
HDFSortbin.Value = HDFSortbin.Value == "ASC" ? "DESC" : "ASC";
DataTable dt = new DataTable();
dt = objDesg.GetCertificateMasterInactive(Session["CompId"].ToString().ToString());
DataView dv = new DataView(dt);
string Query = "" + e.SortExpression + " " + HDFSortbin.Value + "";
dv.Sort = Query;
dt = dv.ToTable();
Session["dtBinFilter"] = dt;
GvCertificateBin.DataSource = dt;
GvCertificateBin.DataBind();
AllPageCode();
lblSelectedRecord.Text = "";
}
protected void ImgbtnSelectAll_Click(object sender, ImageClickEventArgs e)
{
DataTable dtCertificate = (DataTable)Session["dtbinFilter"];
if (ViewState["Select"] == null)
{
ViewState["Select"] = 1;
foreach (DataRow dr in dtCertificate.Rows)
{
if (!lblSelectedRecord.Text.Split(',').Contains(dr["Certificate_ID"]))
{
lblSelectedRecord.Text += dr["Certificate_ID"] + ",";
}
}
for (int i = 0; i < GvCertificateBin.Rows.Count; i++)
{
string[] split = lblSelectedRecord.Text.Split(',');
Label lblconid = (Label)GvCertificateBin.Rows[i].FindControl("lblCertificateId");
for (int j = 0; j < lblSelectedRecord.Text.Split(',').Length; j++)
{
if (lblSelectedRecord.Text.Split(',')[j] != "")
{
if (lblconid.Text.Trim().ToString() == lblSelectedRecord.Text.Split(',')[j].Trim().ToString())
{
((CheckBox)GvCertificateBin.Rows[i].FindControl("chkgvSelect")).Checked = true;
}
}
}
}
}
else
{
lblSelectedRecord.Text = "";
DataTable dtCertificate1 = (DataTable)Session["dtBinFilter"];
GvCertificateBin.DataSource = dtCertificate1;
GvCertificateBin.DataBind();
ViewState["Select"] = null;
}
}
protected void btnbindBin_Click(object sender, EventArgs e)
{
string condition = string.Empty;
if (ddlOptionBin.SelectedIndex != 0)
{
if (ddlOptionBin.SelectedIndex == 1)
{
condition = "convert(" + ddlFieldNameBin.SelectedValue + ",System.String)='" + txtValueBin.Text + "'";
}
else if (ddlOptionBin.SelectedIndex == 2)
{
condition = "convert(" + ddlFieldNameBin.SelectedValue + ",System.String) like '%" + txtValueBin.Text + "%'";
}
else
{
condition = "convert(" + ddlFieldNameBin.SelectedValue + ",System.String) Like '" + txtValueBin.Text + "%'";
}
DataTable dtCust = (DataTable)Session["dtBinCertificate"];
DataView view = new DataView(dtCust, condition, "", DataViewRowState.CurrentRows);
Session["dtBinFilter"] = view.ToTable();
lblTotalRecordsBin.Text = Resources.Attendance.Total_Records + " : " + view.ToTable().Rows.Count.ToString() + "";
GvCertificateBin.DataSource = view.ToTable();
GvCertificateBin.DataBind();
lblSelectedRecord.Text = "";
if (view.ToTable().Rows.Count == 0)
{
imgBtnRestore.Visible = false;
ImgbtnSelectAll.Visible = false;
}
else
{
AllPageCode();
}
System.Web.UI.ScriptManager.GetCurrent(this).SetFocus(txtValueBin);
}
}
public void FillGridBin()
{
DataTable dt = new DataTable();
dt = objDesg.GetCertificateMasterInactive(Session["CompId"].ToString().ToString());
GvCertificateBin.DataSource = dt;
GvCertificateBin.DataBind();
Session["dtBinCertificate"] = dt;
Session["dtBinFilter"] = dt;
lblTotalRecordsBin.Text = Resources.Attendance.Total_Records + ": " + dt.Rows.Count.ToString() + "";
lblSelectedRecord.Text = "";
if (dt.Rows.Count == 0)
{
imgBtnRestore.Visible = false;
ImgbtnSelectAll.Visible = false;
}
else
{
AllPageCode();
}
}