protected void Button2Export_Click(object sender, EventArgs e) { DataTable dy = null; DataTable dz = null; PatentBusiness obj = new PatentBusiness(); string MemberId = txtEmployeecode.Text; DataTable dt = obj.GetPatentWisePoints(MemberId); if (dt.Rows.Count == 0) { GridView2.Visible = false; PanelPatent.Visible = false; // noField.Visible = true; // noField.Text = "No Records Found"; } else { ViewState["GridViewStudentlist"] = dt; } // DataTable dt = (DataTable)ViewState["GridViewStudentlist"]; string filename = "PatentWisePointExcel.xls"; string headerTable = @"<table width='100%' border='1' align='center' class='TestCssStyle'><h4>Patent Wise Points Summary<br/></h4></table>"; HttpContext.Current.Response.Write(headerTable); System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); DataGrid dgGrid = new DataGrid(); dgGrid.DataSource = dt; dgGrid.DataBind(); foreach (DataGridItem item in dgGrid.Items) { for (int j = 0; j < item.Cells.Count; j++) { item.Cells[j].Attributes.Add("style", "mso-number-format:\\@"); } } dgGrid.ShowHeader = true; dgGrid.RenderControl(hw); Response.ContentType = "application/vnd.ms-excel"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ""); this.EnableViewState = false; Response.Write(tw.ToString()); Response.End(); }
protected void GridViewPatentSearch_SelectedIndexChanged(object sender, EventArgs e) { txtmemberPatent.Text = ""; TxtcurrentPatent.Text = ""; txttotalPointPatent.Text = ""; //txtBasePoint.Text = ""; //txtSNIPSJRPoint.Text = ""; //txtThresholdPoint.Text = ""; txttotalPointPatent.Text = ""; txtreferencePatent.Text = ""; btnupdatePatent.Enabled = true; GridViewPatentSearch.Visible = true; GridViewRow row = GridViewPatentSearch.SelectedRow; string memberid = row.Cells[1].Text; txtmemberPatent.Text = row.Cells[1].Text; txtreferencePatent.Text = row.Cells[3].Text; PatentBusiness busobj = new PatentBusiness(); Patent obj = new Patent(); obj = busobj.SelectPatentData(memberid, row.Cells[3].Text.Trim()); //int ThresholdPublicationNo = Convert.ToInt16(ConfigurationManager.AppSettings["ThresholdPublicationNo"]); //int count = busobj.CountThresholdPublicationPoint(obj); //point 3 (crosses 6 publication) is awarded once in a year //if (count > ThresholdPublicationNo) //{ // if (obj.MUNonMU == "M") // { // txtThresholdPoint.Enabled = true; // } // else // { // txtThresholdPoint.Enabled = false; // } //} //else //{ // txtThresholdPoint.Enabled = false; // txtThresholdPoint.Text = ""; //} //if (obj.AuthorType == "P" || obj.isCorrAuth == "Y") //{ // txtSNIPSJRPoint.Enabled = true; //} //else //{ // txtSNIPSJRPoint.Enabled = true; // txtSNIPSJRPoint.Text = ""; //} IncentivePoint obj1 = new IncentivePoint(); obj1 = busobj.SelectPatentMemberCurBalance(memberid); TxtcurrentPatent.Text = obj1.CurrentBalance.ToString(); }
protected void BtnsearchPatent_Click(object sender, EventArgs e) { Patent d = new Patent(); string Pid = txtpatentID.Text.Trim(); PatentBusiness obj = new PatentBusiness(); d = obj.fnfindpatent(Pid); txtID.Text = Pid; txtTitle.Text = d.Title; txtdescription.Text = d.description; txtfilingoffice.Text = d.Filing_Office; if (txtfilingoffice.Text == "C") { txtfilingoffice.Text = "Chennai"; } else if (txtfilingoffice.Text == "D") { txtfilingoffice.Text = "Delhi"; } else if (txtfilingoffice.Text == "K") { txtfilingoffice.Text = "Kolkata"; } else if (txtfilingoffice.Text == "M") { txtfilingoffice.Text = "Mumbai"; } if (d.Grant_Date != null) { txtgrantdate.Text = d.Grant_Date.ToShortDateString(); } txtPatentno.Text = d.Patent_Number; Gridview1.Visible = true; Gridview1.DataSourceID = "SqlDataSource6"; Gridview1.DataBind(); if (Gridview.Rows.Count == 0) { } }