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);
}
}
