private void BindCounterParty() { CounterPartyBL counterPartyBL = new CounterPartyBL(); ddlCounterPartyA.DataSource = counterPartyBL.GetCounterParty(); ddlCounterPartyA.DataTextField = "Name"; ddlCounterPartyA.DataValueField = "Name"; ddlCounterPartyA.DataBind(); ddlCounterPartyB.DataSource = counterPartyBL.GetCounterParty(); ddlCounterPartyB.DataTextField = "Name"; ddlCounterPartyB.DataValueField = "Name"; ddlCounterPartyB.DataBind(); ddlCounterPartyC.DataSource = counterPartyBL.GetCounterParty(); ddlCounterPartyC.DataTextField = "Name"; ddlCounterPartyC.DataValueField = "Name"; ddlCounterPartyC.DataBind(); ddlCounterPartyA.SelectedValue = "CounterPartyA"; ddlCounterPartyB.SelectedValue = "CounterPartyB"; ddlCounterPartyC.SelectedValue = "CounterPartyC"; }
protected void grdQuotesAndTrades_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item.IsInEditMode) { GridEditableItem item = (GridEditableItem)e.Item; if (!(e.Item is IGridInsertItem)) { CounterPartyBL counterPartyBL = new CounterPartyBL(); RadDropDownList ddlCounterParty = (RadDropDownList)item.FindControl("ddlQCounterParty"); ddlCounterParty.DataSource = counterPartyBL.GetCounterParty(); ddlCounterParty.DataTextField = "Name"; ddlCounterParty.DataValueField = "Name"; ddlCounterParty.DataBind(); ddlCounterParty.SelectedValue = ((DAL.QuotesAndTrades)((e.Item).DataItem)).CounterParty; CountryBL countryBL = new CountryBL(); RadDropDownList ddlCountry = (RadDropDownList)item.FindControl("ddlQCountry"); ddlCountry.DataSource = countryBL.GetCountry(); ddlCountry.DataTextField = "Name"; ddlCountry.DataValueField = "Name"; ddlCountry.DataBind(); ddlCountry.SelectedValue = ((DAL.QuotesAndTrades)((e.Item).DataItem)).Country; } } }
protected void btnCPSave_Click(object sender, EventArgs e) { CounterParty model = new CounterParty(); CounterPartyBL bl = new CounterPartyBL(); model.Type = txtCPType.SelectedValue.Trim(); model.Name = txtCPName.Text.Trim(); model.Region = txtCPRegion.SelectedValue; if (!string.IsNullOrEmpty(hfCPID.Value)) { model.ID = Convert.ToInt32(hfCPID.Value); LogActivity("CounterParty Updated", "Email has been updated", string.Empty); } else { LogActivity("CounterParty Created", "Email has been created", string.Empty); } string str = bl.SavecounterParty(model); BindCounterParties(); if (str != "Entry of the same Name is already exists.") { hfCPID.Value = string.Empty; } RadWindowManager1.RadAlert(str, 330, 180, "realedge associates", "alertCallBackFn"); }
private void BindCounterParties() { CounterPartyBL bl = new CounterPartyBL(); grdCounterParty.DataSource = bl.GetCounterParty().OrderBy(c => c.Name).ToList(); grdCounterParty.DataBind(); }
protected void Import() { try { string filename = Path.GetFileName(fuFile.FileName); string csv_file_path = Server.MapPath("~/Temp/tempfile.csv"); //fuFile.SaveAs(csv_file_path); DataTable csvData = null; List<string> columnNames = null; if (ddlImportType.SelectedValue != "EUR Curve" || ddlImportType.SelectedValue != "US Curve") { csvData = CSVHelper.GetDataTabletFromCSVFile(csv_file_path, GetDelimeters()); // Get Header column names list columnNames = csvData.Columns.Cast<DataColumn>().Select(c => c.ColumnName).ToList(); LogActivity("File Uploaded", "Upload the file to import loan/quotesAndtrades", string.Empty); } if (ddlImportType.SelectedValue == "Loan") { //ExtractLoanList(csvData, columnNames); List<Loans> importedList = ExtractLoanList(csvData, columnNames); // ExtractLoanList(csvData, columnNames); // Save it to database ApplicationHub.RefreshLoans(importedList); LogActivity("Loans Imported", "Import the loans", string.Empty); } else if (ddlImportType.SelectedValue == "Quotes") { List<QuotesAndTrades> importedList = ExtractQuotesAndTradesList(csvData, columnNames); // Save it to database if (importedList.Count > 0) { QuotesAndTradesBLL bll = new QuotesAndTradesBLL(); bll.AddImportedQuotesAndTrades(importedList); ApplicationHub.RefreshQuotesAndTrade(importedList); LogActivity("QuotesAndTrades Imported", "Import the quotesAndtrades", string.Empty); } else { RadWindowManager1.RadAlert("No Data found", 330, 180, "realedge associates", "alertCallBackFn"); return; } } else if (ddlImportType.SelectedValue == "Counterparties") { List<CounterParty> importedList = ExtractCounterPartyList(csvData, columnNames); if (importedList.Count > 0) { CounterPartyBL bll = new CounterPartyBL(); bll.AddImportedQuotesAndTrades(importedList); LogActivity("Counterparties Imported", "Counterparties", string.Empty); } else { RadWindowManager1.RadAlert("No Data found", 330, 180, "realedge associates", "alertCallBackFn"); return; } } else if (ddlImportType.SelectedValue == "EUR Curve") { //importdatafromexcel(csv_file_path); List<EURCurve> importedList = ExtractEURCurveList(csvData, columnNames); if (importedList.Count > 0) { EURCurvesBL bll = new EURCurvesBL(); bll.UpdateCurve(); bll.ImportEURCurves(importedList); LogActivity("EURCurves Imported", "EURCurves", string.Empty); } else { RadWindowManager1.RadAlert("No Data found", 330, 180, "realedge associates", "alertCallBackFn"); return; } } else if (ddlImportType.SelectedValue == "US Curve") { List<USDCurve> importedList = ExtractUSDCurveList(csvData, columnNames); if (importedList.Count > 0) { USDCurveBL bll = new USDCurveBL(); bll.UpdateCurve(); bll.ImportUSDCurves(importedList); LogActivity("USDCurve Imported", "USDCurves", string.Empty); } else { RadWindowManager1.RadAlert("No Data found", 330, 180, "realedge associates", "alertCallBackFn"); return; } } //ShowMessage("Message", "Data has been imported successfully"); RadWindowManager1.RadAlert("Data has been imported successfully", 330, 180, "realedge associates", "alertCallBackFn"); } catch (Exception ex) { LogActivity("File Upload(Unsuccessfull)", "Unable to upload the file", ex.Message); //lblImportStatus.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message; RadWindowManager1.RadAlert("Data import failed", 330, 180, "realedge associates", "alertCallBackFn"); } }
protected void grdCounterParty_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { CounterPartyBL bll = new CounterPartyBL(); if (e.CommandName == "RemoveCP") { int id = Convert.ToInt32(e.CommandArgument); bll.Delete(id); BindCounterParties(); LogActivity("CounterParty Removed", "CounterParty has been removed", string.Empty); } else if (e.CommandName == "EditCP") { int id = Convert.ToInt32(e.CommandArgument); CounterParty model = bll.GetByID(id); txtCPName.Text = model.Name; BindRegions(); txtCPRegion.SelectedValue = model.Region; txtCPType.SelectedValue = model.Type; hfCPID.Value = model.ID.ToString(); } //else if (e.CommandName == "SendEmail") //{ // string str = ReportHelper.GenerateAndSendPDFReport(e.CommandArgument.ToString()); // if (str != string.Empty) // { // lblEmailError.Visible = true; // lblEmailError.InnerText = str; // } // ShowMessage("Message", "Emails has been set to all the addresses in the group(" + e.CommandArgument.ToString() + ")"); //} BindCounterParties(); }