public clsEntFirmEvaluation readerFirmEvaluationByEvalDate(string evaldate, string firmID, int loanID, int packageID) { clsEntFirmEvaluation objEnt = new clsEntFirmEvaluation(); try { if (objConnection.Connection.State == ConnectionState.Closed) { objConnection.Connection.Open(); } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@evaldate", evaldate), new SqlParameter("@firmID", firmID), new SqlParameter("@loanID", loanID), new SqlParameter("@packageID", packageID) }; SqlDataReader reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_FIRM_EVALUATION_CHECK_BY_EVALDATE, CommandType.StoredProcedure, param); while (reader.Read()) { objEnt.EvalDate = (reader.GetValue(6).ToString()); objEnt.CWWP = reader.GetValue(7).ToString(); objEnt.QOO = reader.GetValue(8).ToString(); objEnt.PStbl = reader.GetValue(9).ToString(); objEnt.TAvail = reader.GetValue(10).ToString(); objEnt.AR = reader.GetValue(11).ToString(); objEnt.Comments = reader.GetValue(12).ToString(); objEnt.btFinal = Convert.ToBoolean(reader.GetValue(13)); } reader.Close(); return(objEnt); } catch (Exception ex) { throw ex; } }
protected void drpDate_SelectedIndexChanged(object sender, EventArgs e) { if (drpYear.SelectedIndex > 0) { string evalDate = drpDate.SelectedItem.ToString() + drpYear.SelectedItem.ToString(); objEnt = ObjfirmEval.readerFirmEvaluationByEvalDate(evalDate, drpFirmName.SelectedValue, int.Parse(drpLoan.SelectedValue), int.Parse(drpPackage.SelectedValue)); if (objEnt.EvalDate != null) { RatingParameterLoad(); string EvalDate = objEnt.EvalDate; if (evalDate != "") { evalDate = Convert.ToDateTime(evalDate).ToString(clsConstant.DATE_FORMAT); } 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))); } //txtComments.Text = objEnt.Comments; lblMessage.Text = "Firm Already Evaluated."; btnSubmit.Visible = false; btnUpdate.Visible = true; drpFirmType.Enabled = false; } else { lblMessage.Text = ""; btnSubmit.Visible = true; btnUpdate.Visible = false; drpFirmType.Enabled = true; } } }
protected void drpYear_SelectedIndexChanged(object sender, EventArgs e) { if (drpYear.SelectedIndex > 0) { string evalDate = drpDate.SelectedItem.ToString() + drpYear.SelectedItem.ToString(); objEnt = ObjfirmEval.readerFirmEvaluationByEvalDate(evalDate, drpFirmName.SelectedValue, int.Parse(drpLoan.SelectedValue), int.Parse(drpPackage.SelectedValue)); if (objEnt.EvalDate != null) { RatingParameterLoad(); 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) == "1 Jan") { drpDate.SelectedIndex = 0; } else { drpDate.SelectedIndex = 1; } drpYear.SelectedIndex = drpYear.Items.IndexOf(drpYear.Items.FindByText(evalDate.Substring(evalDate.Length - 4, 4))); } //txtComments.Text = objEnt.Comments; lblMessage.Text = "Firm Already Evaluated."; btnSubmit.Visible = false; btnUpdate.Visible = true; drpFirmType.Enabled = false; } else { lblMessage.Text = ""; btnSubmit.Visible = true; btnUpdate.Visible = false; drpFirmType.Enabled = true; } } }
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); } }
public clsEntFirmEvaluation readerFirmEvaluation(string firmEvalID) { clsEntFirmEvaluation objEnt = new clsEntFirmEvaluation(); try { if (objConnection.Connection.State == ConnectionState.Closed) { objConnection.Connection.Open(); } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@firmEvalID", firmEvalID) }; SqlDataReader reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_FIRM_EVALUATION_CHECK, CommandType.StoredProcedure, param); while (reader.Read()) { objEnt.FirmEvalID = Convert.ToInt32(reader.GetValue(0)); objEnt.FirmID = Convert.ToInt32(reader.GetValue(1)); objEnt.LoanID = Convert.ToInt32(reader.GetValue(2)); objEnt.PackageID = Convert.ToInt32(reader.GetValue(3)); objEnt.AgencyID = Convert.ToInt32(reader.GetValue(4)); objEnt.FirmType = reader.GetValue(5).ToString(); objEnt.EvalDate = (reader.GetValue(6).ToString()); objEnt.CWWP = reader.GetValue(7).ToString(); objEnt.QOO = reader.GetValue(8).ToString(); objEnt.PStbl = reader.GetValue(9).ToString(); objEnt.TAvail = reader.GetValue(10).ToString(); objEnt.AR = reader.GetValue(11).ToString(); objEnt.Comments = reader.GetValue(12).ToString(); objEnt.btFinal = Convert.ToBoolean(reader.GetValue(13)); objEnt.FileName = reader.GetValue(14).ToString(); object objFile = reader.GetValue(16); if (DBNull.Value == objFile) { objEnt.ProgramFile = null; } else { objEnt.ProgramFile = (byte[])(objFile); } objEnt.Contenttype = reader.GetValue(15).ToString(); } return(objEnt); } catch (Exception ex) { throw ex; } }
protected void drpFirmName_SelectedIndexChanged(object sender, EventArgs e) { ObjEntType = ObjfirmEval.readFirmtypeFromFirmName(int.Parse(drpFirmName.SelectedValue)); drpFirmType.SelectedValue = ObjEntType.FirmTypeID.ToString(); //drpFirmType.Enabled = false; objEnt = ObjfirmEval.readerFirmEvaluationByFirmname(drpFirmName.SelectedValue, int.Parse(drpLoan.SelectedValue), int.Parse(drpPackage.SelectedValue)); if (objEnt.FirmID != 0) { FirmTypeLoad(); string firmtype = objEnt.FirmType.ToString(); if (firmtype == "1" || firmtype == "2") { drpFirmType.Items.FindByValue(firmtype).Selected = true; } else { drpFirmType.Items.FindByText(firmtype).Selected = true; drpFirmType.Enabled = false; } RatingParameterLoad(); string evalDate = objEnt.EvalDate; if (evalDate != "") { evalDate = Convert.ToDateTime(evalDate).ToString(clsConstant.DATE_FORMAT); } 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; } drpYear.SelectedIndex = drpYear.Items.IndexOf(drpYear.Items.FindByText(evalDate.Substring(evalDate.Length - 4, 4))); } lblMessage.Text = "Firm Already Evaluated."; btnSubmit.Visible = false; btnUpdate.Visible = true; } else { lblMessage.Text = ""; btnSubmit.Visible = true; btnUpdate.Visible = false; if (drpFirmType.SelectedValue == "0") { drpFirmType.Enabled = true; } else { drpFirmType.Enabled = false; } } }
//---------------------------------------------------------------------- // Method: btnUpdate_Click // Author: Rabindra Kumar Das // Description: Update Firm Evaluation. // Creation Date: 13-6-11 // // Inputs: loanNumber,taNo,eaName, consultantName, DateTime dateOfEvaluation, // string complianceWorkProgram, string qualityOfOutput, string personalStability, // string timelyAvailability, string averageRating,comments // Outputs: return a boolean value True if successfully executed else false // Throws: Throw a proper exception message // //--------------------------------------------------------------------- protected void btnUpdate_Click(object sender, EventArgs e) { int firmEvalID; if (isEdit) { firmEvalID = int.Parse(Request.QueryString["firmEvalID"]); } else { objEnt = ObjfirmEval.readerFirmEvaluationByFirmname(drpFirmName.SelectedValue, int.Parse(drpLoan.SelectedValue), int.Parse(drpPackage.SelectedValue)); firmEvalID = objEnt.FirmEvalID; } //Update the record. int AgencyNo = int.Parse(drpAgency.SelectedValue); int firmID = int.Parse(drpFirmName.SelectedValue); string averageRating = (drpAverageRating.SelectedItem).ToString(); string evalDate = drpDate.SelectedItem.ToString() + drpYear.SelectedItem.ToString(); string compliance = (drpCompilance.SelectedItem).ToString(); string output = (drpOutPut.SelectedItem).ToString(); string perst = drpPersonalStability.SelectedItem.ToString(); string timavail = drpTimelyAvailability.SelectedItem.ToString(); string firmType = drpFirmType.SelectedItem.ToString(); bool check = optYes.Checked; byte[] readByteFile = null; string fileName = string.Empty; string contentType = string.Empty; this.certificateUpload(out readByteFile, out fileName, out contentType); if (fileName != "") { if (ObjfirmEval.EditFirmEvaluation(firmEvalID, averageRating, firmType, evalDate, compliance, output, perst, timavail, txtComments.Text, check, fileName, contentType, readByteFile)) { lblMessage.ForeColor = System.Drawing.Color.Black; lblMessage.Text = "Information Updated Successfully."; } else { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Error is there."; } UrlParameterPasser urlWrapper = new UrlParameterPasser("FirmEvaluationList.aspx"); urlWrapper.PassParameters(); } else { if (ObjfirmEval.EditFirmEvaluation(firmEvalID, averageRating, firmType, evalDate, compliance, output, perst, timavail, txtComments.Text, check, null, null, null)) { lblMessage.ForeColor = System.Drawing.Color.Black; lblMessage.Text = "Information Updated Successfully."; } else { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Error is there."; } UrlParameterPasser urlWrapper = new UrlParameterPasser("FirmEvaluationList.aspx"); urlWrapper.PassParameters(); } }
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); } }