protected void grdFirmEvaluation_SelectedIndexChanged(object sender, EventArgs e) { try { FirmEvalObj = new FirmEvaluation(); clsEntFirmEvaluation ObjEntFirmEvInd = new clsEntFirmEvaluation(); // Function used to for downloading the files from database for (int i = 0; i < grdFirmEvaluation.Rows.Count; i++) { //obtain selected index from GridView for the selected File if (grdFirmEvaluation.SelectedIndex == i) { string firmEvalID = grdFirmEvaluation.DataKeys[i].Value.ToString(); ObjEntFirmEvInd = FirmEvalObj.readerFirmEvaluation(firmEvalID); if (ObjEntFirmEvInd != null) { Byte[] programFile = ObjEntFirmEvInd.ProgramFile; if (ObjEntFirmEvInd.FirmEvalID.ToString() != null) { string contentType = ObjEntFirmEvInd.Contenttype; string fileName = ObjEntFirmEvInd.FileName; Response.ContentType = contentType; //The AddHeader method adds a new HTML header and value to the response sent to the client Response.AddHeader("content-disposition", "attachment;filename=" + fileName); //The Charset property appends the name of the character set (for example, ISO-8859-13) to the content-type header in the Response object //Here Blank is attached Response.Charset = ""; //Provides enumerated values that are used to set the Cache-Control HTTP header. Response.Cache.SetCacheability(HttpCacheability.NoCache); } //Provides enumerated values that are used to set the Cache-Control HTTP header. Response.BinaryWrite(programFile); //The End method causes the Web server to stop // processing the script and return the current result. Response.End(); } else { lblMessage.Text = "File DoesNot Exists"; } } } } catch (Exception ex) { logger.Error(ex); } }
protected void Page_Load(object sender, EventArgs e) { ScriptManager.GetCurrent(this).RegisterPostBackControl(this.btnRemove); try { ScriptManager.GetCurrent(this).RegisterPostBackControl(this.btnUpdate); firmEvalID = Request.QueryString["firmEvalID"]; #region Updation region if (firmEvalID != null) //Update Function { //ScriptManager.GetCurrent(this).RegisterPostBackControl(this.btnUpdate); //Check for System PostBack if (IsPostBack == false) { //Edit Mode btnSubmit.Visible = false; objEnt = ObjfirmEval.readerFirmEvaluation(firmEvalID); AgencyLoad(); int AgencyID = objEnt.AgencyID; drpAgency.SelectedValue = AgencyID.ToString(); LoanLoad(); drpLoan.SelectedValue = objEnt.LoanID.ToString(); PackageLoad(); drpPackage.SelectedValue = objEnt.PackageID.ToString(); FirmNameLoad(); string firmname = objEnt.FirmID.ToString(); drpFirmName.Items.FindByValue(firmname).Selected = true; FirmTypeLoad(); string firmtype = objEnt.FirmType.ToString(); if (firmtype == "1" || firmtype == "2") { drpFirmType.Items.FindByValue(firmtype).Selected = true; } else { drpFirmType.Items.FindByText(firmtype).Selected = true; } FirmComplianceLoad(); string compl = objEnt.CWWP.ToString(); if (compl == "1" || compl == "2" || compl == "3") { drpCompilance.Items.FindByValue(compl).Selected = true; } else { drpCompilance.Items.FindByText(compl).Selected = true; } OutputLoad(); string outp = objEnt.QOO.ToString(); if (outp == "1" || outp == "2" || outp == "3") { drpOutPut.Items.FindByValue(outp).Selected = true; } else { drpOutPut.Items.FindByText(outp).Selected = true; } PersonalstabilityLoad(); string ps = objEnt.PStbl.ToString(); if (ps == "1" || ps == "2" || ps == "3") { drpPersonalStability.Items.FindByValue(ps).Selected = true; } else { drpPersonalStability.Items.FindByText(ps).Selected = true; } TimelyAvailabilityLoad(); string tav = objEnt.TAvail.ToString(); if (tav == "1" || tav == "2" || tav == "3") { drpTimelyAvailability.Items.FindByValue(tav).Selected = true; } else { drpTimelyAvailability.Items.FindByText(tav).Selected = true; } FirmAverageratingLoad(); string avrr = objEnt.AR.ToString(); if (avrr == "1" || avrr == "2" || avrr == "3") { drpAverageRating.Items.FindByValue(avrr).Selected = true; } else { drpAverageRating.Items.FindByText(avrr).Selected = true; } string evalDate = objEnt.EvalDate; if (evalDate != "") { evalDate = Convert.ToDateTime(evalDate).ToString(clsConstant.DATE_FORMAT); } ds = new DataSet(); ds.ReadXml(HostingEnvironment.ApplicationPhysicalPath + "XML\\EvaluationDate.xml"); drpDate.DataSource = ds.Tables[0]; drpDate.DataTextField = "value"; drpDate.DataValueField = "value"; drpDate.DataBind(); YearLoad(); if (evalDate != "") { if (evalDate.Substring(0, evalDate.Length - 5) == "01 Jan" || evalDate.Substring(0, evalDate.Length - 5) == "1 Jan") { drpDate.SelectedIndex = 0; } else { drpDate.SelectedIndex = 1; } //if (evalDate.Substring(0, evalDate.Length - 5) == "01 Jul" || evalDate.Substring(0, evalDate.Length - 5) == "1 Jul") // drpDate.SelectedIndex = 0; //else // drpDate.SelectedIndex = 1; drpYear.SelectedIndex = drpYear.Items.IndexOf(drpYear.Items.FindByText(evalDate.Substring(evalDate.Length - 4, 4))); } else { evalDate = drpDate.SelectedItem.ToString() + drpYear.SelectedItem.ToString(); } if (objEnt.btFinal == true) { optYes.Checked = true; } else { optNo.Checked = true; } txtComments.Text = objEnt.Comments; if (objEnt.FileName != "") { lblFileName.Text = objEnt.FileName; btnRemove.Visible = true; CertFileUpload.Visible = false; } else { lblFileName.Text = ""; btnRemove.Visible = false; CertFileUpload.Visible = true; } DisablePrimeData(); } isEdit = true; } #endregion #region Insert region else { ScriptManager.GetCurrent(this).RegisterPostBackControl(this.btnSubmit);// register event for btnSubmit if (!IsPostBack) { if (Utility.CheckAccess("FirmEvaluationAddEdit") == false) { //UrlParameterPasser urlWrapper = new UrlParameterPasser(); //urlWrapper["pageaccesserr"] = "1"; ////urlWrapper.Url = "../Logout.aspx"; //urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx"; //urlWrapper.PassParameters(); pnlInvalid.Visible = true; MainDiv.Visible = false; } if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE])) { this.MakeReadOnly(this.Controls); } btnUpdate.Visible = false; //ScriptManager.GetCurrent(this).RegisterPostBackControl(this.btnSubmit);// register event for btnSubmit if (Session[clsConstant.TOKEN] != null) { if ((((UserDetails)Session[clsConstant.TOKEN]).SuperUser) == true) { drpAgency.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_AGENCY, param); drpAgency.DataTextField = "DisplayFieldText"; drpAgency.DataValueField = "ValueFieldText"; drpAgency.DataBind(); } else { param = new SqlParameter[] { new SqlParameter("@iAgencyID", ((UserDetails)Session[clsConstant.TOKEN]).AgencyID) }; drpAgency.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_AGENCY_USER, param); //drpEAName.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_AGENCY, null); drpAgency.DataTextField = "DisplayFieldText"; drpAgency.DataValueField = "ValueFieldText"; drpAgency.DataBind(); } drpAgency.Items.FindByValue(((UserDetails)Session[clsConstant.TOKEN]).AgencyID.ToString()).Selected = true; int SelectedIndex = int.Parse(drpAgency.SelectedValue); param = new SqlParameter[] { new SqlParameter("@selectedIndex", SelectedIndex) }; drpLoan.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_LOAN_BY_AGENCY, param); drpLoan.DataTextField = "DisplayFieldText"; drpLoan.DataValueField = "ValueFieldText"; drpLoan.DataBind(); int count = drpLoan.Items.Count; if (count == 1) { lblStatus.Text = "No Loan in" + " - " + drpAgency.SelectedItem; } else { lblStatus.Text = ""; } FirmTypeLoad(); FirmComplianceLoad(); OutputLoad(); PersonalstabilityLoad(); TimelyAvailabilityLoad(); FirmAverageratingLoad(); //txtDateOfEvaluation.Text = DateTime.Now.Date.ToString("dd MMM yyyy"); ds = new DataSet(); ds.ReadXml(HostingEnvironment.ApplicationPhysicalPath + "XML\\EvaluationDate.xml"); drpDate.DataSource = ds.Tables[0]; drpDate.DataTextField = "value"; drpDate.DataValueField = "value"; drpDate.DataBind(); YearLoad(); optNo.Checked = true; } else { UrlParameterPasser urlWrapper = new UrlParameterPasser(); urlWrapper.Url = "../Logout.aspx"; urlWrapper.PassParameters(); } } } #endregion } catch (Exception ex) { logger.Error(ex); } }