/// <summary>
/// onclick, based on the filter condition result will be display in grid accordingly.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExecute_Click(object sender, EventArgs e)
{
if (DDUser.SelectedIndex == 0)
{
string js = "<script language='javascript' type='text/javascript'>CheckUser();</script>";
Page.ClientScript.RegisterStartupScript(GetType(), "script", js);
GrdQMSlog.Visible = false;
lblDocumentCount.Visible = false;
}
else
{
if (RdoViewAll.Checked == false && RdoViewNotRead.Checked == false)
{
getRdoViewRead();
}
else if (RdoViewNotRead.Checked == true)
{
getRdoViewNotRead();
}
else if (RdoViewAll.Checked == true)
{
getRdoViewReadAll();
}
Session["GridDataInfo"] = dsSearchResult;
Session["GridDefault"] = dsSearchResult;
GrdQMSlog.Visible = true;
lblDocumentCount.Visible = true;
GrdQMSlog.DataSource = dsSearchResult.Tables[0];
GrdQMSlog.DataBind();
lblDocumentCount.Text = dsSearchResult.Tables[0].Rows.Count + " Record Found";
}
}
protected void GrdQMSlog_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GrdQMSlog.PageIndex = e.NewPageIndex;
DataSet ds = (DataSet)Session["GridDataInfo"];
GrdQMSlog.DataSource = ds.Tables[0];
GrdQMSlog.DataBind();
}
/// <summary>
/// when the user has selected View Read(radio button) of the filter control.
/// </summary>
public void getRdoViewRead()
{
todate = ToModDate.Text.Trim();
fromDate = FromModeDate.Text.Trim();
string vMan = Manual1.Text.ToString().ToUpper();
UserDropDown = Convert.ToInt32(DDUser.SelectedValue);
dsSearchResult = objQMS.getSearchResult(UserDropDown, todate, fromDate, vMan);
Session["GridDataInfo"] = dsSearchResult;
Session["GridDefault"] = dsSearchResult;
GrdQMSlog.DataSource = dsSearchResult.Tables[0];
GrdQMSlog.DataBind();
GrdQMSlog.PageIndex = 0;
}
/// <summary>
/// when the user has selected View All(radio button) of the filter control.
/// </summary>
public void getRdoViewReadAll()
{
fromDate = ToModDate.Text.Trim();
todate = FromModeDate.Text.Trim();
string ManualReadAll = Manual1.Text.ToString().ToUpper();
UserDropDown = Convert.ToInt32(DDUser.SelectedValue);
dsSearchResult = objQMS.getDetailsgViewReadAll(UserDropDown, fromDate, todate, ManualReadAll);
Session["GridDataInfo"] = dsSearchResult;
Session["GridDefault"] = dsSearchResult;
GrdQMSlog.DataSource = dsSearchResult.Tables[0];
GrdQMSlog.DataBind();
GrdQMSlog.PageIndex = 0;
RdoViewAll.Checked = true;
}
protected void btnClear_Click(object sender, EventArgs e)
{
DataSet GridDS = new DataSet();
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.ContentType = "application/QMSLog.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.Html32TextWriter htmlWrite = new Html32TextWriter(stringWrite);
for (int i = 0; i < GrdQMSlog.Columns.Count - 1; i++)
{
GrdQMSlog.HeaderRow.Cells[i].ForeColor = Color.Black;
GrdQMSlog.HeaderRow.Cells[i].BackColor = Color.LightGray;
GrdQMSlog.HeaderStyle.BackColor = Color.LightGray;
GrdQMSlog.HeaderStyle.ForeColor = Color.Black;
GrdQMSlog.HeaderStyle.Wrap = false;
GrdQMSlog.FooterRow.Cells[i].ForeColor = Color.White;
GrdQMSlog.FooterRow.Cells[i].BackColor = Color.LightGray;
GrdQMSlog.FooterStyle.BackColor = Color.LightGray;
GrdQMSlog.FooterStyle.ForeColor = Color.Black;
GrdQMSlog.RowStyle.Wrap = false;
GrdQMSlog.PagerStyle.BackColor = Color.White;
GrdQMSlog.PagerStyle.ForeColor = Color.Black;
}
GridDS = (DataSet)Session["GridDefault"];
GrdQMSlog.DataSource = GridDS.Tables[0];
GrdQMSlog.AllowPaging = false;
GrdQMSlog.DataBind();
for (int i = 0; i < GrdQMSlog.Columns.Count - 1; i++)
{
GrdQMSlog.HeaderRow.Cells[i].ForeColor = Color.Black;
GrdQMSlog.HeaderRow.Cells[i].BackColor = Color.LightGray;
GrdQMSlog.HeaderStyle.BackColor = Color.LightGray;
GrdQMSlog.HeaderStyle.ForeColor = Color.Black;
GrdQMSlog.HeaderStyle.Wrap = false;
GrdQMSlog.FooterRow.Cells[i].ForeColor = Color.White;
GrdQMSlog.FooterRow.Cells[i].BackColor = Color.LightGray;
GrdQMSlog.FooterStyle.BackColor = Color.LightGray;
GrdQMSlog.FooterStyle.ForeColor = Color.Black;
GrdQMSlog.RowStyle.Wrap = false;
GrdQMSlog.PagerStyle.BackColor = Color.White;
GrdQMSlog.PagerStyle.ForeColor = Color.Black;
}
HtmlForm frm = new HtmlForm();
GrdQMSlog.Parent.Controls.Add(frm);// .Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(GrdQMSlog);
frm.RenderControl(htmlWrite);
System.Web.HttpContext.Current.Response.Write(stringWrite.ToString());
GrdQMSlog.AllowPaging = true;
System.Web.HttpContext.Current.Response.End();
}
