Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void loanDetails()
- {
- Table table = new Table();
- table.Width = Unit.Percentage(100);
- table.CellPadding = 5;
- foreach (DataRow dr in ds.Tables[2].Rows)
- {
- TableRow tr = new TableRow();
- if (dr["risk_rating"] != DBNull.Value && Convert.ToInt32(dr["risk_rating"]) == 3)
- tr.ID = "badLoan";
- else if (dr["risk_rating"] != DBNull.Value && Convert.ToInt32(dr["risk_rating"]) == 4)
- tr.ID = "badLoan4";
- TableCell tc = new TableCell();
- tc.Style["padding-top"] = "50px";
- tc.Text = "Loan Count";
- tc.CssClass = "description";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["#"].ToString();
- tc.Style["padding-top"] = "50px";
- tc.ColumnSpan = 3;
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tr.ID = dr["id"].ToString();
- tc = new TableCell();
- tc.Text = "Borrower(s)";
- tc.CssClass = "description";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["last_name"].ToString().ToUpper() + ", " + dr["first_name"].ToString().ToUpper();
- tc.ColumnSpan = 3;
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- //this information should not display if the file is denied
- if (!Convert.ToBoolean(dr["loan_denied"]))
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Property Address";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.ColumnSpan = 3;
- tc.Text = dr["property_address"].ToString().ToUpper() + "<br />" + dr["property_city"].ToString().ToUpper() +
- ", " + dr["property_state"].ToString().ToUpper() + " " + dr["property_zip"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Branch/TPO";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.ColumnSpan = 3;
- tc.Text = dr["branch_tpo"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Loan/Case #";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["loan_number"].ToString() + " / " + dr["fha_va_conv_case_nbr"].ToString();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "LTV/CLTV";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["appraised_value_ltv_perc"].ToString().ToUpper() + " / " +
- dr["cltv_perc"].ToString().ToUpper() + "%";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Loan Type/Amount";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["loan_type"].ToString() +
- (dr["loan_amount"] != DBNull.Value ? "/" + Convert.ToDecimal(dr["loan_amount"]).ToString("c") : string.Empty);
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Pur/Refi";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["loan_purpose"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "First Time H/O (Y/N)";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["first_time_homebuyer_yn"].ToString().ToUpper();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Rate";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["ir_perc"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Loan Originator";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["loan_originator"].ToString().ToUpper();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Loan Processor";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["loan_processor"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Credit Rating";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["credit_scores_file"].ToString();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "QC";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["credit_scores_qc"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Ratios";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["credit_analysis_ratios_file"].ToString().ToUpper() + "% / " +
- dr["credit_analysis_ratios_file_perc"].ToString().ToUpper() + "%";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "QC";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["Credit_Analysis_Ratios_QC"].ToString().ToUpper() + "% / " +
- dr["Credit_Analysis_Ratios_QC_Perc"].ToString().ToUpper() + "%";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Underwriter Type";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["underwriter_type"].ToString().ToUpper();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Stated Income";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["stated"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Income/Assets";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["income_assets"].ToString().ToUpper();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Underwriter";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["underwriter_name"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "APR Calculation File";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["apr_file"].ToString();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "QC";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["apr_qc"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Appraiser";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["appraiser"].ToString().ToUpper();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Value";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["appraised_value"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Appraiser Company";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["company_name"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Appraisal Review Type";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = Convert.ToBoolean(dr["Field_Review"]) ? "FRA" : "Desk Review";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Appraisal Rating";
- if (Request.QueryString["edit"] == null)
- tc.Text = "Appraisal Rating";
- else
- tc.Text = "<a href=\"tabbed/auditing.aspx?id=" + dr["id"].ToString() + "&oid=" + Request.QueryString["id"] + "&tab=6\">Appraisal Rating</a>";
- tr.Cells.Add(tc);
- tc = new TableCell();
- //if (dr["avg"] != DBNull.Value && Convert.ToDouble(dr["avg"]) <= 2.5)
- //{
- // tc.Text = Convert.ToDouble(dr["avg"]).ToString("f");
- // tc.Font.Bold = true;
- // tc.ForeColor = Color.Red;
- //}
- //else if (dr["avg"] != DBNull.Value)
- // tc.Text = Convert.ToDouble(dr["avg"]).ToString("f");
- //else
- tc.Text = dr["Appraisal_rating"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Real Estate Company";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["re_co"].ToString().ToUpper();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Real Estate Agent";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["re_agent"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Closing Agent/Escrow Company";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.ColumnSpan = 3;
- tc.Text = dr["closing_agent"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Date Closed/Funded";
- tr.Cells.Add(tc);
- tc = new TableCell();
- if (dr["HUD1_Closing_Date"] != DBNull.Value)
- tc.Text = Convert.ToDateTime(dr["HUD1_Closing_Date"]).ToString("MM/dd/yyyy");
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Disbursement Date";
- tr.Cells.Add(tc);
- tc = new TableCell();
- if (dr["disb_dte"] != DBNull.Value)
- tc.Text = Convert.ToDateTime(dr["disb_dte"]).ToString("MM/dd/yyyy");
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- if (Request.QueryString["edit"] == null)
- tc.Text = "Risk/Satisfactory Rating";
- else
- tc.Text = "<a href=\"tabbed/auditing.aspx?id=" + dr["id"].ToString() + "&oid=" + Request.QueryString["id"] + "&tab=7\">Risk/Satisfactory Rating</a>";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["risk_rating"].ToString() + " / " + dr["satisfactory_risk"].ToString().ToUpper();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Investor";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dr["investor_name"].ToString().ToUpper();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- string rowFilter = "prnt_id = " + dr["id"].ToString();
- DataView dv = new DataView(ds.Tables[5], rowFilter, string.Empty, DataViewRowState.OriginalRows);
- //makes sure there are findings available
- if (dv.Count > 0)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.CssClass = "title";
- tc.Text = "Findings";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- for (int i = 0; i < dv.Count; i++)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.VerticalAlign = VerticalAlign.Top;
- if (Request.QueryString["edit"] == null)
- tc.Text = dv[i]["description"].ToString();
- else
- {
- tc.Text = "<a href=\"editFinding.aspx?id=" + dv[i]["findID"].ToString() + "&oid=" + Request.QueryString["id"]
- + "&aid=" + dr["id"].ToString() + "&edit=1\">" + dv[i]["description"].ToString() + "</a>";
- }
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.ColumnSpan = 3;
- tc.Text = dv[i]["FullDescription"].ToString().Replace("\n", "<br />");
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- //only available if displaying the response management report
- if (Request.QueryString["mgm"] != null)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Management Response";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dv[i]["ManagementResponse"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Responding Manager";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dv[i]["RespondingManager"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.Text = "Action Taken";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.Text = dv[i]["ActionTaken"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- }
- }
- //auditor is being reviewed by auditor
- if (Request.QueryString["reviewed"] != null)
- {
- rowFilter = "audit_id = " + dr["id"].ToString();
- dv = new DataView(ds.Tables[12], rowFilter, string.Empty, DataViewRowState.OriginalRows);
- //makes sure there are deleted findings available
- if (dv.Count > 0)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.CssClass = "title";
- tc.Text = "Deleted Findings";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- for (int i = 0; i < dv.Count; i++)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.CssClass = "description";
- tc.VerticalAlign = VerticalAlign.Top;
- tc.Text = dv[i]["description"].ToString();
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.ColumnSpan = 3;
- tc.Text = dv[i]["FullDescription"].ToString().Replace("\n", "<br />");
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- }
- }
- rowFilter = "prnt_id = " + dr["id"].ToString();
- dv = new DataView(ds.Tables[6], rowFilter, string.Empty, DataViewRowState.OriginalRows);
- //makes sure there are red flags available
- if (dv.Count > 0)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.CssClass = "title";
- tc.Text = "Red Flags";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- for (int i = 0; i < dv.Count; i++)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.Text = dv[i]["Flag_Description"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- }
- rowFilter = "prnt_id = " + dr["id"].ToString();
- dv = new DataView(ds.Tables[7], rowFilter, string.Empty, DataViewRowState.OriginalRows);
- //makes sure there are comments available
- if (dv.Count > 0)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.CssClass = "title";
- tc.Text = "Comments";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- for (int i = 0; i < dv.Count; i++)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- if (Request.QueryString["edit"] == null)
- tc.Text = dv[i]["fulldescription"].ToString();
- else
- {
- tc.Text = "<a href=\"editComment.aspx?id=" + dv[i]["id"].ToString() + "&oid=" + Request.QueryString["id"]
- + "&aid=" + dr["id"].ToString() + "&edit=1\">" + dv[i]["fulldescription"].ToString() + "</a>";
- }
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- }
- rowFilter = "audit_id = " + dr["id"].ToString();
- dv = new DataView(ds.Tables[8], rowFilter, string.Empty, DataViewRowState.OriginalRows);
- //makes sure there are adverse appraisal questions available
- if (dv.Count > 0)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.CssClass = "title";
- tc.Text = "Federal Regulatory Audit";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- string category = string.Empty;
- for (int i = 0; i < dv.Count; i++)
- {
- if (category == string.Empty || category != dv[i]["category"].ToString())
- {
- category = dv[i]["category"].ToString();
- tr = new TableRow();
- tc = new TableCell();
- tc.Text = category;
- tc.CssClass = "description";
- tc.ColumnSpan = 4;
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.Text = dv[i]["statement"].ToString() + "<br /> Answer: " + dv[i]["answer"].ToString() + "<br /> Rating: " +
- (Convert.ToDouble(dv[i]["risk_rating"]) <= 2.5 ? "<span class=\"adverse\">" + dv[i]["risk_rating"].ToString() + "</span>"
- : dv[i]["risk_rating"].ToString());
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- }
- rowFilter = "audit_id = " + dr["id"].ToString();
- dv = new DataView(ds.Tables[9], rowFilter, string.Empty, DataViewRowState.OriginalRows);
- //makes sure there are adverse appraisal questions available
- if (dv.Count > 0)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.CssClass = "title";
- tc.Text = "Desk Review";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- string category = string.Empty;
- for (int i = 0; i < dv.Count; i++)
- {
- if (category == string.Empty || category != dv[i]["category"].ToString())
- {
- category = dv[i]["category"].ToString();
- tr = new TableRow();
- tc = new TableCell();
- tc.Text = category;
- tc.CssClass = "description";
- tc.ColumnSpan = 4;
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.Text = dv[i]["statement"].ToString() + "<br /> Answer: " + dv[i]["answer"].ToString() + "<br /> Rating: " +
- (Convert.ToDouble(dv[i]["risk_rating"]) <= 2.5 ? "<span class=\"adverse\">" + dv[i]["risk_rating"].ToString() + "</span>"
- : dv[i]["risk_rating"].ToString());
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- }
- rowFilter = "audit_r_id = " + dr["id"].ToString();
- dv = new DataView(ds.Tables[13], rowFilter, string.Empty, DataViewRowState.OriginalRows);
- //denial audit
- if (dv.Count > 0)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.CssClass = "title";
- tc.Text = "Denial Audit";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- string category = string.Empty;
- for (int i = 0; i < dv.Count; i++)
- {
- if (category == string.Empty || category != dv[i]["category"].ToString())
- {
- category = dv[i]["category"].ToString();
- tr = new TableRow();
- tc = new TableCell();
- tc.Text = category;
- tc.CssClass = "description";
- tc.ColumnSpan = 4;
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.Text = dv[i]["statement"].ToString() + "<br />" + dv[i]["answer"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- }
- rowFilter = "first_name = '" + dr["first_name"].ToSpecialString() + "' and last_name = '" + dr["last_name"].ToSpecialString() + "'";
- dv = new DataView(ds.Tables[11], rowFilter, string.Empty, DataViewRowState.OriginalRows);
- //comments from AMS for field review appraisals
- if (dv.Count > 0 && dv[0]["IAGCompliance"].ToString() != string.Empty)
- {
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.CssClass = "title";
- tc.Text = "Inner Agency Guidance Compliance";
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- tr = new TableRow();
- tc = new TableCell();
- tc.ColumnSpan = 1;
- tc.VerticalAlign = VerticalAlign.Top;
- tc.CssClass = "description";
- if (Request.QueryString["edit"] == null)
- tc.Text = "Field Review Appraisal";
- else
- tc.Text = "<a href=\"IAGCompliance.aspx?id=" + dv[0]["id"].ToString() + "&oid=" + Request.QueryString["id"]
- + "&aid=" + dr["id"].ToString() + "&edit=1\">Field Review Appraisal</a>";
- tr.Cells.Add(tc);
- tc = new TableCell();
- tc.ColumnSpan = 4;
- tc.Text = dv[0]["IAGCompliance"].ToString();
- tr.Cells.Add(tc);
- table.Rows.Add(tr);
- }
- //add a page preak after each loan file
- table.Rows[table.Rows.Count - 1].CssClass = "breakAfter";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement