private void FillData() { try { Loans loan = new Loans(); LoansBLL bll = new LoansBLL(); loan = bll.GetLoanByID(Convert.ToInt16(Session["EditLoanID"])); ddlAddLoanCode.SelectedValue = loan.CodeName; txtBoxAddLoanCode.Text = loan.CodeName; ddlBorrower.SelectedValue = loan.Borrower; // txtBoxAddSector.Text = loan.Sector; ddlSector.SelectedValue = loan.Sector; if (loan.Signing_Date != null) txtBoxAddSigningDate.SelectedDate = Convert.ToDateTime(loan.Signing_Date); if (loan.Maturity_Date != null) txtBoxAddMaturityDate.SelectedDate = Convert.ToDateTime(loan.Maturity_Date); ddlAddFixedOrFloating.SelectedValue = loan.FixedOrFloating; txtBoxAddMargin.Text = loan.Margin; ddlAddCurrency.SelectedValue = loan.Currency; bindCountry(); if (loan.Country != null) { CountryBL countryBL = new CountryBL(); int id = countryBL.GetCountryFromName(loan.Country); if (id != 0) ddlCountry.SelectedValue = Convert.ToString(id); } ddlAddCouponFrequency.SelectedValue = loan.CouponFrequency; txtBoxFacilitySize.Text = Convert.ToDecimal(loan.FacilitySize).ToString("N"); if (loan.Bilateral == true) ddlAddBilateral.SelectedValue = "Yes"; else ddlAddBilateral.SelectedValue = "No"; ddlAmortizing.SelectedValue = loan.Amortizing; CheckNodes(tvCreditRating, loan); //txtCouponDate. //txtNotional txtPP.Text = loan.PP; // txtCRating.Text = loan.CreditRating; txtStructureID.Text = loan.StructureID; txtBoxAddMargin.Text = loan.Margin; if (loan.CouponDate != null) txtCouponDate.SelectedDate = Convert.ToDateTime(loan.CouponDate); txtNotional.Text = Convert.ToDecimal(loan.Notional).ToString("N"); if (ddlAmortizing.SelectedValue == "Yes") { if (loan.AmortisationsStartPoint != null) txtAmortisationsStartDate.SelectedDate = Convert.ToDateTime(loan.AmortisationsStartPoint); txtAmortisations.Text = loan.NoOfAmortisationPoint.ToString(); trDate.Visible = true; trNo.Visible = true; tblAmortisation.Visible = true; } txtSummitCredit.Text = loan.SummitCreditEntity; txtGrid.Text = loan.Grid; txtGurantor.Text = loan.Gurantor; LoanScheduleBL scheduleBL = new LoanScheduleBL(); List<LoanSchedule> scheduleList = scheduleBL.GetLoanByID(loan.ID); if (scheduleList != null && scheduleList.Count > 0) { dt1.Clear(); //dt1.Columns.Add("ID", typeof(int)); //dt1.Columns.Add("StartDate", typeof(DateTime)); //dt1.Columns.Add("EndDate", typeof(DateTime)); //dt1.Columns.Add("Notional", typeof(long)); //dt1.Columns.Add("Factor", typeof(float)); for (int i = 0; i < scheduleList.Count; i++) { // dt1.Rows.Add(scheduleList[i].ID, scheduleList[i].StartDate, scheduleList[i].EndDate, scheduleList[i].Notation, scheduleList[i].Factor); dt1.Rows.Add(i + 1, scheduleList[i].StartDate.Value.ToShortDateString(), scheduleList[i].EndDate.Value.ToShortDateString(), scheduleList[i].CoupFrac, scheduleList[i].Notation, scheduleList[i].Amortisation, scheduleList[i].Factor); } pnlAmortizing.Visible = true; grdAmortizing.Visible = true; btnCalculatSchedule.Visible = true; grdAmortizing.DataSource = dt1; grdAmortizing.DataBind(); } hfLoanID.Value = loan.ID.ToString(); lblConfirm.Text = "Loan already exists, do you wish to overwrite?"; _operation = "Edit"; } catch (Exception) { } }
protected void btnAddNewLoan_Click(object sender, EventArgs e) { try { LoansBLL bll = new LoansBLL(); if (txtBoxAddMaturityDate.SelectedDate.ToString() != "" && txtBoxAddSigningDate.SelectedDate.ToString() != "") { DateTime dtMaturity = Convert.ToDateTime(txtBoxAddMaturityDate.SelectedDate.Value); DateTime dtSigning = Convert.ToDateTime(txtBoxAddSigningDate.SelectedDate.Value); SettingsBLL settingBL = new SettingsBLL(); Setting setting = settingBL.GetSettingyear("Loan Year Settings"); if (setting != null) { TimeSpan ts = dtMaturity - dtSigning; int differenceYear = Convert.ToInt32((ts.TotalDays) / 365); int year = Convert.ToInt16(setting.Value); if (dtMaturity.Year > dtSigning.Year && (differenceYear) > year) { lblMessage.Text = "Maturity Date is not Valid"; lblMessage.Visible = true; return; } } } else { //lblMessage.Text = "Enter the Details"; //lblMessage.Visible = true; RadWindowManager1.RadAlert("Maturity Date and Signing Date required", 300, 150, "realedge associates", "alertCallBackFn"); return; } // check to see either the loan has been added or updated bool isNewLoan = false; Loans loan = new Loans(); if (!string.IsNullOrEmpty(hfLoanID.Value)) { isNewLoan = false; loan.ID = Convert.ToInt32(hfLoanID.Value); LogActivity("Update the Loan", "Update the existing loan", string.Empty); } else { isNewLoan = true; LogActivity("New Loan Added", "Add the new loan", string.Empty); } List<RatingDetails> ratingDetails = new List<RatingDetails>(); ratingDetails = ShowCheckedNodes(tvCreditRating); foreach (var item in ratingDetails) { switch (item.agencyName) { case "Moody's": loan.CreditRatingModys = item.rating; break; case "S&P's": loan.CreditRatingSPs = item.rating; break; case "Fitch": loan.CreditRatingFitch = item.rating; break; case "ING": loan.CreditRatingING = item.rating; break; default: break; } } loan.CodeName = ddlAddLoanCode.Text; loan.Borrower = ddlBorrower.Text; loan.Sector = ddlSector.SelectedValue; //txtBoxAddSector.Text; loan.Signing_Date = txtBoxAddSigningDate.SelectedDate.Value.ToShortDateString(); loan.Maturity_Date = txtBoxAddMaturityDate.SelectedDate.Value.ToShortDateString(); loan.FixedOrFloating = ddlAddFixedOrFloating.SelectedValue; loan.Margin = txtBoxAddMargin.Text; loan.Currency = ddlAddCurrency.SelectedValue; loan.Country = ddlCountry.SelectedValue; loan.CouponFrequency = ddlAddCouponFrequency.SelectedValue; loan.Gurantor = txtGurantor.Text; loan.Grid = txtGrid.Text; loan.SummitCreditEntity = txtSummitCredit.Text; if (txtBoxFacilitySize.Text != string.Empty) { loan.FacilitySize = Convert.ToDecimal(txtBoxFacilitySize.Text).ToString("N"); } loan.Bilateral = ddlAddBilateral.SelectedValue == "Yes"; loan.Amortizing = ddlAmortizing.SelectedValue; loan.PP = txtPP.Text; // loan.CreditRating = txtCRating.Text; loan.StructureID = txtStructureID.Text; //Coupon Date and Notional are missing. if (txtCouponDate.SelectedDate != null) { loan.CouponDate = txtCouponDate.SelectedDate.Value.ToShortDateString(); } loan.Notional = Convert.ToDecimal(txtNotional.Text).ToString("N").Trim(); if (ddlAmortizing.SelectedValue == "Yes") { if (txtAmortisationsStartDate.SelectedDate != null) { loan.AmortisationsStartPoint = txtAmortisationsStartDate.SelectedDate.Value.ToShortDateString(); } if (txtAmortisations.Text != string.Empty) { loan.NoOfAmortisationPoint = Convert.ToInt16(txtAmortisations.Text); } } else { loan.Amortizing = "Yes"; DateTime cpnDT; if (txtCouponDate.SelectedDate.ToString() == string.Empty) { cpnDT = AddBusinessDays(DateTime.Now, 10); loan.AmortisationsStartPoint = cpnDT.ToShortDateString(); } else { cpnDT = Convert.ToDateTime(txtCouponDate.SelectedDate); loan.AmortisationsStartPoint = txtCouponDate.SelectedDate.Value.ToShortDateString(); } loan.NoOfAmortisationPoint = 10; LoanScheduleBL loanScheduleBL = new LoanScheduleBL(); DateTime tradeDate = DateTime.Now; DataTable dtSchedule = loanScheduleBL.GenerateTable(15, Convert.ToInt16(loan.NoOfAmortisationPoint), Convert.ToDateTime(loan.AmortisationsStartPoint), loan.CouponFrequency.ToString(), loan.Notional.ToString(), Convert.ToDateTime(loan.Maturity_Date), Convert.ToDateTime(loan.CouponDate), Convert.ToDecimal(loan.Margin), Convert.ToString(loan.Currency), Convert.ToDateTime(tradeDate), AddBusinessDays(Convert.ToDateTime(tradeDate), 10)); Session["LoanSchedule"] = dtSchedule; } DAL.Login login = Session["LogedInUser"] as DAL.Login; loan.CreatedBy = login.Name; loan.LastEdited = DateTime.Now; switch (_operation) { case "Add": if (bll.CheckForLoanCode(ddlAddLoanCode.Text.Trim())) { bll.SaveLoan(loan); login = Session["LogedInUser"] as DAL.Login; LoanHistory loanHistory = new LoanHistory(); LoanHistoryBL historyBL = new LoanHistoryBL(); loanHistory.Action = "Add"; loanHistory.LoanName = loan.CodeName; loanHistory.UserName = login.Name; loanHistory.LastModified = DateTime.Now; historyBL.SaveHistory(loanHistory); // lblAddLoanMessage.Visible = true; on 7-1 CalculateFactors(); LoanScheduleBL loanScheduleBL = new LoanScheduleBL(); if (Session["LoanSchedule"] != null) { dt1 = (DataTable)Session["LoanSchedule"]; } foreach (DataRow dr in dt1.Rows) { LoanSchedule loanSchedule = new LoanSchedule(); loanSchedule.LoanID = loan.ID; loanSchedule.StartDate = Convert.ToDateTime(dr["StartDate"]); loanSchedule.EndDate = Convert.ToDateTime(dr["EndDate"]); loanSchedule.CoupFrac = Convert.ToDecimal(dr["CoupFrac"]); loanSchedule.Notation = Convert.ToDecimal(dr["Notation"]); loanSchedule.Amortisation = Convert.ToDecimal(dr["Amortisation"]); loanSchedule.Factor = Convert.ToDecimal(dr["Factor"]); loanSchedule.Spread = Convert.ToDecimal(dr["Spread"]); loanSchedule.AllInRate = Convert.ToDecimal(dr["AllInRate"]); loanSchedule.CouponPaymentDate = Convert.ToDateTime(dr["CouponPaymentDate"]); loanSchedule.RiskFreeDP1 = Convert.ToDecimal(dr["RiskFreeDP1"]); loanSchedule.RiskFreeDP2 = Convert.ToDecimal(dr["RiskFreeDP2"]); loanSchedule.FloatingRate = Convert.ToDecimal(dr["FloatingRate"]); loanSchedule.Interest = Convert.ToDecimal(dr["Interest"]); loanSchedule.Days = Convert.ToInt16(dr["Days"]); loanSchedule.AmortisationInt = Convert.ToDecimal(dr["AmortisationInt"]); loanSchedule.CreatedOn = DateTime.UtcNow; loanScheduleBL.SaveLoanSchedule(loanSchedule); } //lblMessage.Text = "Loan added Successfully"; //lblMessage.Visible = true; RadWindowManager1.RadAlert(ddlAddLoanCode.Text + " added Successfully", 300, 150, "realedge associates", "alertCallBackFn"); } else { InsertDuplicateLoan(); } break; case "Edit": bll.EditLoan(loan, Convert.ToInt16(Session["EditLoanID"]), 2); login = Session["LogedInUser"] as DAL.Login; LoanHistory loanHis = new LoanHistory(); LoanHistoryBL historiesBL = new LoanHistoryBL(); loanHis.Action = "Edit"; loanHis.LoanName = loan.CodeName; loanHis.UserName = login.Name; loanHis.LastModified = DateTime.Now; historiesBL.SaveHistory(loanHis); CalculateFactors(); LoanScheduleBL scheduleBL = new LoanScheduleBL(); if (Session["LoanSchedule"] != null) { dt1 = (DataTable)Session["LoanSchedule"]; } scheduleBL.EditSchedule(Convert.ToInt16(Session["EditLoanID"]), dt1); // Clear(); //lblMessage.Text = "Loan updated Successfully"; //lblMessage.Visible = true; RadWindowManager1.RadAlert(ddlAddLoanCode.Text + " updated Successfully", 300, 150, "realedge associates", "alertCallBackFn"); //lblConfirm.Text = "Are you sure you want to add this loan to database?"; //_operation = "Add"; //Session.Remove("EditLoanID"); break; default: break; } // all loans List<Loans> allLoans = bll.GetLoans(); BindLoansTab(allLoans); BindLoansData(); BindHistoricalQuotesAndTradesTab(); // check to see if the loan has been added or updated if (isNewLoan) { ApplicationHub.NewLoanAdded(loan); } else { ApplicationHub.RefreshLoans(allLoans); } hdnSaved.Value = "Y"; BindLoanCode(); } catch (Exception ex) { //lblAddLoanMessage.Visible = true; on 7-1 //lblAddLoanMessage.Text = "Loan failed to save"; on 7-1 // lblMessage.Text = "Loan failed to save"; lblMessage.Text = ex.Message; lblMessage.Text = ex.InnerException.Message; lblMessage.Visible = true; LogActivity("New Loan(Unsuccessfull)", "Unable to save the loan", ex.Message); } }
private void CheckNodes(RadDropDownTree treeView, Loans loan) { //RadTreeNode nodeCollection = treeView.Nodes[0]; //foreach (var item in nodeCollection.Nodes) //{ // switch (((Telerik.Web.UI.RadTreeNode)(item)).Text) // { // case "Moody's": // foreach (var node in nodeCollection.Nodes.FindNodeByText("Moody's").Nodes) // { // if (((Telerik.Web.UI.RadTreeNode)(node)).Text == loan.CreditRatingModys) // { // ((Telerik.Web.UI.RadTreeNode)(node)).Checked = true; // } // } // break; // case "ING": // foreach (var node in nodeCollection.Nodes.FindNodeByText("ING").Nodes) // { // if (((Telerik.Web.UI.RadTreeNode)(node)).Text == loan.CreditRatingING) // { // ((Telerik.Web.UI.RadTreeNode)(node)).Checked = true; // } // } // break; // case "S&P's": // foreach (var node in nodeCollection.Nodes.FindNodeByText("S&P's").Nodes) // { // if (((Telerik.Web.UI.RadTreeNode)(node)).Text == loan.CreditRatingSPs) // { // ((Telerik.Web.UI.RadTreeNode)(node)).Checked = true; // } // } // break; // case "Fitch": // foreach (var node in nodeCollection.Nodes.FindNodeByText("Fitch").Nodes) // { // if (((Telerik.Web.UI.RadTreeNode)(node)).Text == loan.CreditRatingFitch) // { // ((Telerik.Web.UI.RadTreeNode)(node)).Checked = true; // } // } // break; // default: // break; // } //} string[] child = new string[100]; string[] parent = new string[100]; int i = 0, j = 0; string strSelectedText = string.Empty; foreach (RadTreeNode node in treeView.EmbeddedTree.Nodes) { parent[j] = node.Text; j++; switch (node.Text) { case "Moody's": if (node.GetAllNodes().Count != 0) { foreach (RadTreeNode subnode in node.GetAllNodes()) { child[i] = subnode.Text; if (subnode.Text == loan.CreditRatingModys) { subnode.Checked = true; if (strSelectedText == string.Empty) strSelectedText = subnode.Text; else strSelectedText = strSelectedText + ";" + subnode.Text; } i++; } } break; case "ING": if (node.GetAllNodes().Count != 0) { foreach (RadTreeNode subnode in node.GetAllNodes()) { child[i] = subnode.Text; if (subnode.Text == loan.CreditRatingING) { subnode.Checked = true; if (strSelectedText == string.Empty) strSelectedText = subnode.Text; else strSelectedText = strSelectedText + ";" + subnode.Text; } i++; } } break; case "S&P's": if (node.GetAllNodes().Count != 0) { foreach (RadTreeNode subnode in node.GetAllNodes()) { child[i] = subnode.Text; if (subnode.Text == loan.CreditRatingSPs) { subnode.Checked = true; if (strSelectedText == string.Empty) strSelectedText = subnode.Text; else strSelectedText = strSelectedText + ";" + subnode.Text; } i++; } } break; case "Fitch": if (node.GetAllNodes().Count != 0) { foreach (RadTreeNode subnode in node.GetAllNodes()) { child[i] = subnode.Text; if (subnode.Text == loan.CreditRatingFitch) { subnode.Checked = true; if (strSelectedText == string.Empty) strSelectedText = subnode.Text; else strSelectedText = strSelectedText + ";" + subnode.Text; } i++; } } break; } treeView.SelectedText = strSelectedText; } }
public void InsertRecord(string param, int flag) { try { string[] strSplit = param.Split(','); QuotesAndTrades model = new QuotesAndTrades(); if (!string.IsNullOrEmpty(strSplit[0].Remove(0, 10))) { model.BidPrice = Convert.ToDecimal(strSplit[0].Remove(0, 10)); } if (!string.IsNullOrEmpty(strSplit[1].Remove(0, 10))) { string strBidSpread = Convert.ToDecimal(strSplit[1].Remove(0, 10)).ToString("0.00"); model.BidSpread = Convert.ToDecimal(strBidSpread); } model.CounterParty = strSplit[2].Remove(0, 13); model.LoanName = strSplit[3].Remove(0, 9); if (!string.IsNullOrEmpty(strSplit[4].Remove(0, 11))) { model.OfferPrice = Convert.ToDecimal(strSplit[4].Remove(0, 11)); } if (!string.IsNullOrEmpty(strSplit[5].Remove(0, 12))) { string strOfferSpread = Convert.ToDecimal(strSplit[5].Remove(0, 12)).ToString("0.00"); model.OfferSpread = Convert.ToDecimal(strOfferSpread); } // model.MarketValue model.TimeStamp = DateTime.Now; if (strSplit[6].Remove(0, 9) == "true") model.Traded = true; else model.Traded = false; if (strSplit[3].Remove(0, 9) != string.Empty) { LoansBLL loanBLL = new LoansBLL(); model.Country = loanBLL.GetCoutryIDbyLoanID(strSplit[3].Remove(0, 9)); } if (!string.IsNullOrEmpty(strSplit[12].Remove(0, 10))) { string str = strSplit[12].Remove(0, 10); DateTime tradeDate = DateTime.Now; if (str.Contains('-')) { string[] strSpl = str.Split('-'); string datetime = strSpl[1] + "/" + strSpl[0] + "/" + strSpl[2] + " " + strSpl[3] + ":" + strSpl[4] + ":" + strSpl[5]; tradeDate = Convert.ToDateTime(datetime); } else tradeDate = Convert.ToDateTime(str); model.TradedDate = Convert.ToDateTime(tradeDate); } if (!string.IsNullOrEmpty(strSplit[13].Remove(0, 12))) { string avgLifeDisc = Convert.ToDecimal(strSplit[13].Remove(0, 12)).ToString("0.00"); model.AvgLifeDisc = Convert.ToDecimal(avgLifeDisc); } if (!string.IsNullOrEmpty(strSplit[14].Remove(0, 16))) { string avgLifeRiscDisc = Convert.ToDecimal(strSplit[14].Remove(0, 16)).ToString("0.00"); model.AvgLifeRiskDisc = Convert.ToDecimal(avgLifeRiscDisc); } if (!string.IsNullOrEmpty(strSplit[15].Remove(0, 15))) { string avgLifeNonDisc = Convert.ToDecimal(strSplit[15].Remove(0, 15)).ToString("0.00"); model.AvgLifeNonDisc = Convert.ToDecimal(avgLifeNonDisc); } if (!string.IsNullOrEmpty(strSplit[16].Remove(0, 15))) { DateTime settlementDate = Convert.ToDateTime(strSplit[16].Remove(0, 15)); model.SettlementDate = settlementDate; } if (!string.IsNullOrEmpty(strSplit[17].Remove(0, 7))) { string margin = Convert.ToString(strSplit[17].Remove(0, 7)); model.Margin = margin; } if (!string.IsNullOrEmpty(strSplit[18].Remove(0, 9))) { string notional = Convert.ToDecimal(Convert.ToString(strSplit[18].Remove(0, 9))).ToString("0.00"); model.MarketValue = Convert.ToDecimal(notional); } if (!string.IsNullOrEmpty(strSplit[19].Remove(0, 9))) { string averageLife = Convert.ToDecimal(Convert.ToString(strSplit[19].Remove(0, 12).Replace('}', ' '))).ToString("0.00"); model.AverageLife = Convert.ToDecimal(averageLife); } // model.CountryID = Convert.ToInt32(ddlRegionA.SelectedValue); List<QuotesAndTrades> lst = new List<QuotesAndTrades>(); lst.Add(model); QuotesAndTradesBLL bll = new QuotesAndTradesBLL(); bll.AddImportedQuotesAndTrades(lst); BindHistoricalQuotesAndTradesTab(); // broadcast that quote and trade has been added ApplicationHub.NewQuotesAndTradeAdded(model); if (string.IsNullOrEmpty(hfSelectedLoanA.Value)) { // Add the Loans as well Loans loanModel = new Loans(); //loanModel.Amortizing //loanModel.Bilateral loanModel.CodeName = strSplit[3].Remove(0, 9); //loanModel.Country loanModel.CouponFrequency = strSplit[7].Remove(0, 8); loanModel.Currency = strSplit[8].Remove(0, 9); //loanModel.FacilitySize loanModel.Margin = strSplit[9].Remove(0, 9); // loanModel.Margin = strSplit[10].Remove(0, 8); loanModel.Maturity_Date = strSplit[11].Remove(0, 8); //loanModel.Sector loanModel.Signing_Date = strSplit[12].Remove(0, 10).ToString().Trim(); // Persist in database LoansBLL loanBll = new LoansBLL(); if (loanBll.CheckForLoanCode(strSplit[3].Remove(0, 9).Trim())) { loanBll.SaveLoan(loanModel); //new loan has been added. //Broadcast it ApplicationHub.NewLoanAdded(loanModel); BindLoansTab(); ShowMessage("Message", "Quote and Loan added Successfully"); } else { int loanID = loanBll.GetLoanByCode(strSplit[3].Remove(0, 9)).ID; loanBll.EditLoan(loanModel, loanID, 1); //by nidhi for update the existing loan. DuplicateLoan duplicateLoan = new DuplicateLoan(); //loanModel.Amortizing //loanModel.Bilateral duplicateLoan.CodeName = strSplit[3].Remove(0, 9); //loanModel.Country duplicateLoan.CouponFrequency = strSplit[7].Remove(0, 8); duplicateLoan.Currency = strSplit[8].Remove(0, 9); //loanModel.FacilitySize duplicateLoan.FixedOrFloating = strSplit[9].Remove(0, 9); duplicateLoan.Margin = strSplit[10].Remove(0, 8); duplicateLoan.Maturity_Date = strSplit[11].Remove(0, 8); //loanModel.Sector duplicateLoan.Signing_Date = strSplit[12].Remove(0, 10).ToString().Trim(); loanBll.SaveDuplicateLoan(duplicateLoan); } } hdnQuoteTemp.Value = "N"; ShowMessage("Message", "Quote and Loan added Successfully"); switch (flag) { case 1: LogActivity("Quote and Loan A added", "Add the quote and trade on compact view A", string.Empty); break; case 2: LogActivity("Quote and Loan B added", "Add the quote and trade on compact view B", string.Empty); break; case 3: LogActivity("Quote and Loan C added", "Add the quote and trade on compact view C", string.Empty); break; default: break; } } catch (Exception) { } }
public void EditLoan(Loans loan, int loanID, int type) { try { using (LoanPriceEntities context = new LoanPriceEntities()) { Loans oldLoan = context.Loans.FirstOrDefault(c => c.ID == loanID); oldLoan.CodeName = loan.CodeName; oldLoan.Borrower = loan.Borrower; oldLoan.Sector = loan.Sector; oldLoan.Signing_Date = loan.Signing_Date; oldLoan.Maturity_Date = loan.Maturity_Date; oldLoan.FixedOrFloating = loan.FixedOrFloating; oldLoan.Margin = loan.Margin; oldLoan.Currency = loan.Currency; oldLoan.PP = loan.PP; oldLoan.CreditRating = loan.CreditRating; oldLoan.Country = loan.Country; oldLoan.CouponFrequency = loan.CouponFrequency; oldLoan.FacilitySize = loan.FacilitySize; oldLoan.Bilateral = loan.Bilateral; oldLoan.Amortizing = loan.Amortizing; oldLoan.AmortisationsStartPoint = loan.AmortisationsStartPoint; oldLoan.CouponDate = loan.CouponDate; oldLoan.Notional = loan.Notional; oldLoan.NoOfAmortisationPoint = loan.NoOfAmortisationPoint; oldLoan.CreditRatingFitch = loan.CreditRatingFitch; oldLoan.CreditRatingING = loan.CreditRatingING; oldLoan.CreditRatingModys = loan.CreditRatingModys; oldLoan.CreditRatingSPs = loan.CreditRatingSPs; oldLoan.StructureID = loan.StructureID; oldLoan.LastEdited = loan.LastEdited; oldLoan.CreatedBy = loan.CreatedBy; oldLoan.SummitCreditEntity = loan.SummitCreditEntity; oldLoan.Grid = loan.Grid; oldLoan.Gurantor = loan.Gurantor; context.SaveChanges(); //if type == 1 then do not add to DuplicateLoan if (CheckForLoanCode(loan.CodeName, loanID) && type != 1) { DuplicateLoan duplicateLoan = new DuplicateLoan(); duplicateLoan.CodeName = loan.CodeName; duplicateLoan.Borrower = loan.Borrower; duplicateLoan.Sector = loan.Sector; duplicateLoan.Signing_Date = loan.Signing_Date; duplicateLoan.Maturity_Date = loan.Maturity_Date; duplicateLoan.FixedOrFloating = loan.FixedOrFloating; duplicateLoan.Margin = loan.Margin; duplicateLoan.Currency = loan.Currency; duplicateLoan.Country = loan.Country; duplicateLoan.CouponFrequency = loan.CouponFrequency; duplicateLoan.FacilitySize = loan.FacilitySize; duplicateLoan.Bilateral = loan.Bilateral; duplicateLoan.Amortizing = loan.Amortizing; duplicateLoan.AmortisationsStartPoint = loan.AmortisationsStartPoint; duplicateLoan.CouponDate = loan.CouponDate; duplicateLoan.Notional = loan.Notional; duplicateLoan.NoOfAmortisationPoint = loan.NoOfAmortisationPoint; context.AddToDuplicateLoans(duplicateLoan); context.SaveChanges(); } } } catch (Exception) { } }
public void SaveLoan(Loans model) { using (LoanPriceEntities context = new LoanPriceEntities()) { if (model.ID > 0) { context.AddObject("Loans", model); } else { context.AddToLoans(model); } context.SaveChanges(); } }
public string AddImportedLoans(Loans item) { LogsBLL logBL = new LogsBLL(); string str = ""; try { using (LoanPriceEntities context = new LoanPriceEntities()) { string codeName = item.CodeName; if (CheckForLoanCode(item.CodeName)) { context.AddToLoans(item); context.SaveChanges(); //item = GetLoanByCode(codeName); LoanScheduleBL loanScheduleBL = new LoanScheduleBL(); string couponDT = item.CouponDate.ToString(); DateTime cpnDT; if (couponDT == string.Empty) cpnDT = AddBusinessDays(DateTime.Now, 10); else cpnDT = Convert.ToDateTime(item.CouponDate); DateTime tradeDate = DateTime.Now; DataTable dtSchedule = loanScheduleBL.GenerateTable(15, Convert.ToInt16(item.NoOfAmortisationPoint), Convert.ToDateTime(item.AmortisationsStartPoint), item.CouponFrequency.ToString(), item.Notional.ToString(), Convert.ToDateTime(item.Maturity_Date), Convert.ToDateTime(item.CouponDate), Convert.ToDecimal(item.Margin), Convert.ToString(item.Currency), Convert.ToDateTime(tradeDate), AddBusinessDays(Convert.ToDateTime(tradeDate), 10)); if (dtSchedule != null) { try { foreach (DataRow dr in dtSchedule.Rows) { LoanSchedule loanSchedule = new LoanSchedule(); loanSchedule.LoanID = item.ID; loanSchedule.StartDate = Convert.ToDateTime(dr["StartDate"]); loanSchedule.EndDate = Convert.ToDateTime(dr["EndDate"]); loanSchedule.Notation = Convert.ToDecimal(dr["Notation"]); loanSchedule.CoupFrac = Convert.ToDecimal(dr["CoupFrac"]); loanSchedule.Amortisation = Convert.ToDecimal(dr["Amortisation"]); loanSchedule.Factor = Convert.ToDecimal(dr["Factor"]); loanSchedule.CouponPaymentDate = Convert.ToDateTime(dr["CouponPaymentDate"]); loanSchedule.Spread = Convert.ToDecimal(dr["Spread"]); loanSchedule.RiskFreeDP1 = Convert.ToDecimal(dr["RiskFreeDP1"]); loanSchedule.RiskFreeDP2 = Convert.ToDecimal(dr["RiskFreeDP2"]); loanSchedule.FloatingRate = Convert.ToDecimal(dr["FloatingRate"]); loanSchedule.AllInRate = Convert.ToDecimal(dr["AllInRate"]); loanSchedule.Interest = Convert.ToDecimal(dr["Interest"]); loanSchedule.Days = Convert.ToInt16(dr["Days"]); loanSchedule.AmortisationInt = Convert.ToDecimal(dr["AmortisationInt"]); loanScheduleBL.SaveLoanSchedule(loanSchedule); } } catch (Exception ex) { str = ex.Message; // str = ex.Message; } } } else { DuplicateLoan loan = new DuplicateLoan(); loan.CodeName = item.CodeName; loan.Borrower = item.Borrower; loan.Country = item.Country; loan.Sector = item.Sector; loan.Maturity_Date = item.Maturity_Date; loan.Signing_Date = item.Signing_Date; loan.FixedOrFloating = item.FixedOrFloating; loan.Margin = item.Margin; loan.Currency = item.Currency; loan.CouponFrequency = item.CouponFrequency; loan.FacilitySize = item.FacilitySize; loan.Bilateral = item.Bilateral; loan.Amortizing = item.Amortizing; loan.AmortisationsStartPoint = loan.AmortisationsStartPoint; loan.CouponDate = loan.CouponDate; loan.Notional = loan.Notional; loan.NoOfAmortisationPoint = loan.NoOfAmortisationPoint; context.AddToDuplicateLoans(loan); context.SaveChanges(); } } } catch (Exception ex) { str = ex.Message; if (ex.InnerException != null) { str = str + " :: " + ex.InnerException.Message; } } return str; }
/// <summary> /// New loan get added /// </summary> /// <param name="loan"></param> public static void NewLoanAdded(Loans loan) { var context = GlobalHost.ConnectionManager.GetHubContext<ApplicationHub>(); context.Clients.All.onLoanAdded(loan); }
/// <summary> /// Deprecated Method for adding a new object to the Loans EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToLoans(Loans loans) { base.AddObject("Loans", loans); }
/// <summary> /// Create a new Loans object. /// </summary> /// <param name="id">Initial value of the ID property.</param> public static Loans CreateLoans(global::System.Int32 id) { Loans loans = new Loans(); loans.ID = id; return loans; }
private List<Loans> ExtractLoanList(DataTable csvData, List<string> columnNames) { List<Loans> importedList = new List<Loans>(); // string strMessage = ""; try { // Get All properties //PropertyInfo[] properties = model.GetType().GetProperties(); //foreach (PropertyInfo pInfo in properties) //{ // if (columnNames.Contains(pInfo.Name)) // { // object value = row[pInfo.Name]; // TypeConverter typeConverter = TypeDescriptor.GetConverter(pInfo.PropertyType); // object propValue = null; // if (typeConverter.GetType().FullName == "System.ComponentModel.NullableConverter") // { // if (value.ToString().Trim() == "1" || value.ToString().Trim() == "Yes") // { // propValue = typeConverter.ConvertFromString(("True")); // } // } // else // propValue = typeConverter.ConvertFromString((value.ToString())); // // Set value on the property // pInfo.SetValue(model, propValue, null); // } foreach (DataRow dr in csvData.Rows) { Loans model = new Loans(); model.CodeName = dr["CodeName"].ToString(); // model.AmortisationsStartPoint = dr["AmortisationsStartPoint"].ToString(); model.Borrower = dr["Borrower"].ToString(); if (dr["Gurantor"] != null ) { model.Gurantor = dr["Gurantor"].ToString(); } model.Country = dr["Country"].ToString(); model.Grid = dr["Grid"].ToString(); model.SummitCreditEntity = dr["SummitCreditEntity"].ToString(); model.CreditRatingModys = dr["CreditRatingModys"].ToString(); model.CreditRatingSPs = dr["CreditRatingSPs"].ToString(); model.CreditRatingFitch = dr["CreditRatingFitch"].ToString(); model.CreditRatingING = dr["CreditRatingING"].ToString(); model.StructureID = dr["StructureID"].ToString(); model.PP = dr["PP"].ToString(); model.Sector = dr["Sector"].ToString(); model.FacilitySize = dr["FacilitySize"].ToString(); model.Signing_Date = dr["Signing_Date"].ToString(); model.Maturity_Date = dr["Maturity_Date"].ToString(); model.CouponDate = dr["CouponDate"].ToString(); model.FixedOrFloating = dr["FixedOrFloating"].ToString(); model.Margin = dr["Margin"].ToString(); model.Notional = dr["Notional"].ToString(); model.Currency = dr["Currency"].ToString(); model.CouponFrequency = dr["CouponFrequency"].ToString(); if (dr["Bilateral"].ToString() == "Yes") model.Bilateral = true; else model.Bilateral = false; //model.Amortizing = dr["Amortizing"].ToString(); model.Amortizing = "Yes"; if (dr["AmortisationsStartPoint"].ToString() != string.Empty) { model.AmortisationsStartPoint = dr["AmortisationsStartPoint"].ToString(); } else model.AmortisationsStartPoint = dr["CouponDate"].ToString(); if (dr["NoOfAmortisationPoint"].ToString().Trim() != string.Empty) model.NoOfAmortisationPoint = Convert.ToInt16(dr["NoOfAmortisationPoint"]); else model.NoOfAmortisationPoint = GetNoOfAmortisations(); importedList.Add(model); LoansBLL bll = new LoansBLL(); string str = bll.AddImportedLoans(model); if (str != "") { RadWindowManager1.RadAlert(str, 330, 180, "realedge associates", "alertCallBackFn"); } } } catch (Exception ex) { } return importedList; }