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