public List<Loans> BindLoansData()
{
LoansBLL bll = new LoansBLL();
List<Loans> lst = bll.GetLoans();
PopulateLoanGrid = lst;
return lst;
}
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 BindLoansTab(List<Loans> lst = null)
{
if (lst == null)
{
LoansBLL bll = new LoansBLL();
lst = bll.GetLoans();
}
//grdLoans.DataSource = lst;
//grdLoans.DataBind();
}
protected void grdQuotesAndTrades_FilterCheckListItemsRequested(object sender, GridFilterCheckListItemsRequestedEventArgs e)
{
DataTable data = new DataTable();
switch (e.Column.DataField)
{
case "LoanName":
data.Columns.Add("CodeName");
LoansBLL loansBLL = new LoansBLL();
List<Loans> loans = loansBLL.GetLoans();
for (int i = 0; i < loans.Count - 1; i++)
{
data.Rows.Add(loans[i].CodeName);
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "CodeName";
e.ListBox.DataTextField = "CodeName";
e.ListBox.DataValueField = "CodeName";
e.ListBox.DataBind();
break;
default:
break;
}
}
protected void grdLoans_FilterCheckListItemsRequested(object sender, GridFilterCheckListItemsRequestedEventArgs e)
{
DataTable data = new DataTable();
switch (e.Column.DataField)
{
case "CodeName":
data.Columns.Add("CodeName");
LoansBLL loansBLL = new LoansBLL();
List<Loans> loans = loansBLL.GetLoans();
for (int i = 0; i <= loans.Count - 1; i++)
{
data.Rows.Add(loans[i].CodeName);
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "CodeName";
e.ListBox.DataTextField = "CodeName";
e.ListBox.DataValueField = "CodeName";
e.ListBox.DataBind();
break;
case "Borrower":
data = new DataTable();
data.Columns.Add("Borrower");
BorrowersBL borrowerBL = new BorrowersBL();
List<Borrower> borrower = borrowerBL.GetBorrowers();
for (int i = 0; i < borrower.Count - 1; i++)
{
data.Rows.Add(borrower[i].Name);
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "Borrower";
e.ListBox.DataTextField = "Borrower";
e.ListBox.DataValueField = "Borrower";
e.ListBox.DataBind();
break;
case "Country":
data = new DataTable();
data.Columns.Add("Country");
CountryBL CountryBL = new CountryBL();
List<tblCountry> country = CountryBL.GetCountry();
for (int i = 0; i < country.Count - 1; i++)
{
data.Rows.Add(country[i].Name);
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "Country";
e.ListBox.DataTextField = "Country";
e.ListBox.DataValueField = "Country";
e.ListBox.DataBind();
break;
case "CreditRating":
data = new DataTable();
data.Columns.Add("CreditRating");
CreditRatingsBL CreditRatingsBL = new CreditRatingsBL();
List<CreditRating> CreditRating = CreditRatingsBL.GetRatings();
for (int i = 0; i < CreditRating.Count - 1; i++)
{
data.Rows.Add(CreditRating[i].Rating);
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "CreditRating";
e.ListBox.DataTextField = "CreditRating";
e.ListBox.DataValueField = "CreditRating";
e.ListBox.DataBind();
break;
case "Sector":
data = new DataTable();
data.Columns.Add("Sector");
LoansBLL loansBll = new LoansBLL();
List<Sectors> sector = loansBll.GetSector();
for (int i = 0; i < sector.Count; i++)
{
if (sector[i] != null)
{
data.Rows.Add(sector[i].Sector);
}
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "Sector";
e.ListBox.DataTextField = "Sector";
e.ListBox.DataValueField = "Sector";
e.ListBox.DataBind();
break;
case "PP":
data = new DataTable();
data.Columns.Add("PP");
loansBll = new LoansBLL();
List<PP> pp = loansBll.GetPP();
for (int i = 0; i < pp.Count; i++)
{
if (pp[i] != null)
{
data.Rows.Add(pp[i].pp);
}
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "PP";
e.ListBox.DataTextField = "PP";
e.ListBox.DataValueField = "PP";
e.ListBox.DataBind();
break;
case "FixedOrFloating":
data = new DataTable();
data.Columns.Add("FixedOrFloating");
loansBll = new LoansBLL();
List<BLL.FixedOrFloating> fof = loansBll.GetFixedFloating();
for (int i = 0; i < fof.Count; i++)
{
if (fof[i] != null)
{
data.Rows.Add(fof[i].fixedorfloating);
}
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "FixedOrFloating";
e.ListBox.DataTextField = "FixedOrFloating";
e.ListBox.DataValueField = "FixedOrFloating";
e.ListBox.DataBind();
break;
case "Notional":
data = new DataTable();
data.Columns.Add("Notional");
loansBll = new LoansBLL();
List<BLL.Notional> notional = loansBll.GetNotional();
for (int i = 0; i < notional.Count; i++)
{
if (notional[i] != null)
{
data.Rows.Add(notional[i].notional);
}
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "Notional";
e.ListBox.DataTextField = "Notional";
e.ListBox.DataValueField = "Notional";
e.ListBox.DataBind();
break;
case "Margin":
data = new DataTable();
data.Columns.Add("Margin");
loansBll = new LoansBLL();
List<BLL.Margin> margin = loansBll.GetMargin();
for (int i = 0; i < margin.Count; i++)
{
if (margin[i] != null)
{
data.Rows.Add(margin[i].margin);
}
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "Margin";
e.ListBox.DataTextField = "Margin";
e.ListBox.DataValueField = "Margin";
e.ListBox.DataBind();
break;
case "Currency":
data = new DataTable();
data.Columns.Add("Currency");
CurrenciesBL currencyBL = new CurrenciesBL();
List<Currency> currency = currencyBL.GetCurrency();
for (int i = 0; i < currency.Count; i++)
{
if (currency[i].Currancy != null)
{
data.Rows.Add(currency[i].Currancy);
}
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "Currency";
e.ListBox.DataTextField = "Currency";
e.ListBox.DataValueField = "Currency";
e.ListBox.DataBind();
break;
case "CouponFrequency":
data = new DataTable();
data.Columns.Add("CouponFrequency");
loansBll = new LoansBLL();
List<BLL.CouponFrequency> couponFreq = loansBll.GetCouponFrequency();
for (int i = 0; i < couponFreq.Count; i++)
{
if (couponFreq[i] != null)
{
data.Rows.Add(couponFreq[i].coupon);
}
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "CouponFrequency";
e.ListBox.DataTextField = "CouponFrequency";
e.ListBox.DataValueField = "CouponFrequency";
e.ListBox.DataBind();
break;
case "FacilitySize":
data = new DataTable();
data.Columns.Add("FacilitySize");
loansBll = new LoansBLL();
List<BLL.FacilitySize> facility = loansBll.GetFacilitySize();
for (int i = 0; i < facility.Count; i++)
{
if (facility[i] != null)
{
data.Rows.Add(facility[i].facility);
}
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "FacilitySize";
e.ListBox.DataTextField = "FacilitySize";
e.ListBox.DataValueField = "FacilitySize";
e.ListBox.DataBind();
break;
case "CreditRatingModys":
data = new DataTable();
data.Columns.Add("CreditRatings");
loansBll = new LoansBLL();
List<CreditRating> creditRatingModdys = loansBll.GetCreditRatingModdys();
for (int i = 0; i < creditRatingModdys.Count; i++)
{
data.Rows.Add(creditRatingModdys[i].Rating);
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "CreditRatings";
e.ListBox.DataTextField = "CreditRatings";
e.ListBox.DataValueField = "CreditRatings";
e.ListBox.DataBind();
break;
case "CreditRatingSPs":
data = new DataTable();
data.Columns.Add("CreditRatings");
loansBll = new LoansBLL();
List<CreditRating> creditRatingSPs = loansBll.GetCreditRatingSP();
for (int i = 0; i < creditRatingSPs.Count; i++)
{
data.Rows.Add(creditRatingSPs[i].Rating);
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "CreditRatings";
e.ListBox.DataTextField = "CreditRatings";
e.ListBox.DataValueField = "CreditRatings";
e.ListBox.DataBind();
break;
case "CreditRatingFitch":
data = new DataTable();
data.Columns.Add("CreditRatings");
loansBll = new LoansBLL();
List<CreditRating> creditRatingFitch = loansBll.GetCreditRatingFitch();
for (int i = 0; i < creditRatingFitch.Count; i++)
{
data.Rows.Add(creditRatingFitch[i].Rating);
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "CreditRatings";
e.ListBox.DataTextField = "CreditRatings";
e.ListBox.DataValueField = "CreditRatings";
e.ListBox.DataBind();
break;
case "CreditRatingING":
data = new DataTable();
data.Columns.Add("CreditRatings");
loansBll = new LoansBLL();
List<CreditRating> creditRatingING = loansBll.GetCreditRatingING();
for (int i = 0; i < creditRatingING.Count; i++)
{
data.Rows.Add(creditRatingING[i].Rating);
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "CreditRatings";
e.ListBox.DataTextField = "CreditRatings";
e.ListBox.DataValueField = "CreditRatings";
e.ListBox.DataBind();
break;
//case "NoOfAmortisation":
// data = new DataTable();
// data.Columns.Add("NoOfAmortrization");
// loansBll = new LoansBLL();
// List<BLL.NoOfAmortrization> noOfAmort = loansBll.GetNoOfAmortrization();
// for (int i = 0; i < noOfAmort.Count; i++)
// {
// if (noOfAmort[i] != null)
// {
// data.Rows.Add(noOfAmort[i].noofAmort);
// }
// }
// e.ListBox.DataSource = data;
// e.ListBox.DataKeyField = "noofAmort";
// e.ListBox.DataTextField = "noofAmort";
// e.ListBox.DataValueField = "noofAmort";
// e.ListBox.DataBind();
// break;
case "StructureID":
data = new DataTable();
data.Columns.Add("StructureID");
loansBll = new LoansBLL();
List<BLL.StructureID> structure = loansBll.GetStructureID();
for (int i = 0; i < structure.Count; i++)
{
if (structure[i] != null)
{
data.Rows.Add(structure[i].structureID);
}
}
e.ListBox.DataSource = data;
e.ListBox.DataKeyField = "StructureID";
e.ListBox.DataTextField = "StructureID";
e.ListBox.DataValueField = "StructureID";
e.ListBox.DataBind();
break;
default:
break;
}
//// sector
//data = new DataTable();
//data.Columns.Add("CreditRating");
//CreditRatingsBL CreditRatingsBL = new CreditRatingsBL();
//List<CreditRating> CreditRating = CreditRatingsBL.GetRatings();
//for (int i = 0; i < CreditRating.Count - 1; i++)
//{
// data.Rows.Add(CreditRating[i].Rating);
//}
//e.ListBox.DataSource = data;
//e.ListBox.DataKeyField = "CreditRating";
//e.ListBox.DataTextField = "CreditRating";
//e.ListBox.DataValueField = "CreditRating";
//e.ListBox.DataBind();
}
protected void ExportToCSV()
{
string csv_file_path = Server.MapPath("~/Temp/tempfile1.csv");
if (ddlImportType.SelectedValue == "Loan")
{
LoansBLL bll = new LoansBLL();
var loanList = bll.GetLoans().Select(x => new { LoanName = x.CodeName, Borrower = x.Borrower, Country = x.Country, Sector = x.Sector, SigingDate = x.Signing_Date, MaturityDate = x.Maturity_Date, FixedOrFloating = x.FixedOrFloating, Margin = x.Margin, Currency = x.Currency, CouponFrequency = x.CouponFrequency, FacilitySize = x.FacilitySize, Bilateral = x.Bilateral, Amortizing = x.Amortizing, CouponDate = x.CouponDate, Notional = x.Notional, AmortisationsStartPoint = x.AmortisationsStartPoint, NoOfAmortisationPoint = x.NoOfAmortisationPoint, StructureID = x.StructureID, PP = x.PP, FixedFloating = x.Fixed_Floating, CreditRatingModys = x.CreditRatingModys, CreditRatingSPs = x.CreditRatingSPs, CreditRatingFitch = x.CreditRatingFitch, CreditRatingING = x.CreditRatingING, Gurantor = x.Gurantor, Grid = x.Grid, SummitCreditEntity = x.SummitCreditEntity });
List<LoanTable> loanTable = new List<LoanTable>();
foreach (var item in loanList)
{
loanTable.Add(new LoanTable(item.LoanName, item.Borrower, item.Country, Convert.ToDateTime(item.SigingDate), Convert.ToDateTime(item.MaturityDate), item.FixedOrFloating, item.Margin, item.Currency, item.CouponFrequency, item.FacilitySize, Convert.ToBoolean(item.Bilateral), item.Amortizing, Convert.ToDateTime(item.CouponDate), item.Notional, item.AmortisationsStartPoint, Convert.ToInt16(item.NoOfAmortisationPoint), item.StructureID, item.PP, item.FixedFloating, item.CreditRatingModys, item.CreditRatingSPs, item.CreditRatingFitch, item.CreditRatingING, item.Gurantor, item.Grid, item.SummitCreditEntity));
}
BLL.CsvExport<LoanTable> exportHelper = new CsvExport<LoanTable>(loanTable);
exportHelper.ExportToFile(csv_file_path);
LogActivity("Loans Exported", "Export the Loans", string.Empty);
}
else if (ddlImportType.SelectedValue == "Quotes")
{
QuotesAndTradesBLL bll = new QuotesAndTradesBLL();
var quotesList = bll.GetQuotesAndTrades().Select(x => new { LoanName = x.LoanName, TimeStamp = x.TimeStamp, CounterParty = x.CounterParty, BidPrice = x.BidPrice, OfferPrice = x.OfferPrice, BidSpread = x.BidSpread, OfferSpread = x.OfferSpread, Traded = x.Traded, MarketValue = x.MarketValue, Country = x.Country, AverageLife = x.AverageLife, AvgLifeDisc = x.AvgLifeDisc, AvgLifeRiskDisc = x.AvgLifeRiskDisc, AvgLifeNonDisc = x.AvgLifeNonDisc, SettlementDate = x.SettlementDate, Margin = x.Margin });
List<HistoricalQuote> quotes = new List<HistoricalQuote>();
foreach (var item in quotesList)
{
quotes.Add(new HistoricalQuote(item.LoanName, Convert.ToDateTime(item.TimeStamp.Value), item.CounterParty, Convert.ToDecimal(item.BidPrice), Convert.ToDecimal(item.OfferPrice), Convert.ToDecimal(item.BidSpread), Convert.ToDecimal(item.OfferSpread), Convert.ToBoolean(item.Traded), Convert.ToDecimal(item.MarketValue), item.Country, Convert.ToDecimal(item.AverageLife), Convert.ToDecimal(item.AvgLifeDisc), Convert.ToDecimal(item.AvgLifeRiskDisc), Convert.ToDecimal(item.AvgLifeNonDisc), Convert.ToDateTime(item.SettlementDate), item.Margin));
}
BLL.CsvExport<HistoricalQuote> exportHelper = new CsvExport<HistoricalQuote>(quotes);
exportHelper.ExportToFile(csv_file_path);
LogActivity("QuotesAndTrades Exported", "Export the quotesAndtrades", string.Empty);
}
else if (ddlImportType.SelectedValue == "EUR Curve")
{
EURCurvesBL bll = new EURCurvesBL();
var list = bll.GetEURCurve().Select(x => new { UploadDate = x.UploadDate, SummitGenDate = x.SummitGenDate, CCY = x.CCY, Index = x.CurveIndex, Days = x.Days, Rate = x.Rate, DiscFreq = x.DiscFreq });
List<EURCurveTable> eurTable = new List<EURCurveTable>();
foreach (var item in list)
{
eurTable.Add(new EURCurveTable(Convert.ToDateTime(item.UploadDate), Convert.ToDateTime(item.SummitGenDate), item.CCY, item.Index, Convert.ToInt16(item.Days), Convert.ToDecimal(item.Rate), Convert.ToDecimal(item.DiscFreq)));
}
BLL.CsvExport<EURCurveTable> exportHelper = new CsvExport<EURCurveTable>(eurTable);
exportHelper.ExportToFile(csv_file_path);
LogActivity("EURCurve Exported", "Export the EURCurve", string.Empty);
}
else if (ddlImportType.SelectedValue == "US Curve")
{
USDCurveBL bll = new USDCurveBL();
var list = bll.GetUSCurve().Select(x => new { UploadDate = x.UploadDate, SummitGenDate = x.SummitGenDate, CCY = x.CCY, Index = x.CurveIndex, Days = x.Days, Rate = x.Rate, DiscFreq = x.DiscFreq });
List<USDCurveTable> eurTable = new List<USDCurveTable>();
foreach (var item in list)
{
eurTable.Add(new USDCurveTable(Convert.ToDateTime(item.UploadDate), Convert.ToDateTime(item.SummitGenDate), item.CCY, item.Index, Convert.ToInt16(item.Days), Convert.ToDecimal(item.Rate), Convert.ToDecimal(item.DiscFreq)));
}
BLL.CsvExport<USDCurveTable> exportHelper = new CsvExport<USDCurveTable>(eurTable);
exportHelper.ExportToFile(csv_file_path);
LogActivity("USCurve Exported", "Export the USCurve", string.Empty);
}
FileInfo file = new FileInfo(csv_file_path);
if (file.Exists)
{
ShowMessage("Message", "Data has been exported successfully");
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "text/plain";
Response.Flush();
Response.TransmitFile(file.FullName);
Response.End();
}
}
protected void btnRemoveLoan_Click(object sender, EventArgs e)
{
LoansBLL bll = new LoansBLL();
bool result = bll.RemoveAllLoans();
if (result)
{
// all loans
List<Loans> allLoans = bll.GetLoans();
// check to see if the loan has been added or updated
ApplicationHub.RefreshLoans(allLoans);
ShowMessage("Message", "All loans deleted successfully");
LogActivity("Delete All Loans", "Remove all the quotes", string.Empty);
}
else
{
LogActivity("Delete All Loans(Unsuccessfull)", "Remove all the quotes", string.Empty);
lblRemoveLoanMessage.Text = "Unable to delete the loans";
}
}
