/// <summary> /// Create a new USDCurve object. /// </summary> /// <param name="id">Initial value of the ID property.</param> public static USDCurve CreateUSDCurve(global::System.Int32 id) { USDCurve uSDCurve = new USDCurve(); uSDCurve.ID = id; return uSDCurve; }
/// <summary> /// Deprecated Method for adding a new object to the USDCurves EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToUSDCurves(USDCurve uSDCurve) { base.AddObject("USDCurves", uSDCurve); }
public static List<USDCurve> ExtractUSDCurveList(DataTable csvData, List<string> columnNames) { List<USDCurve> importedList = new List<USDCurve>(); for (int i = 9; i < csvData.Rows.Count; i++) { try { USDCurve model = new USDCurve(); model.UploadDate = DateTime.Now; string strSummitText = csvData.Columns[0].ToString(); string[] strSplit = strSummitText.Replace(" ", "").Replace("Runat", " ").Split('/'); string strDay = strSplit[1].ToString(); string strMonth = strSplit[0].ToString(); string[] str = strSplit[2].ToString().Split(' '); string strYear = str[0].ToString(); if (Convert.ToInt16(strYear) > 50) { strYear = "19" + strYear; } else if (strYear.Length == 1) { strYear = "200" + strYear; } else if (strYear.Length == 4) { strYear = strYear; } else strYear = "20" + strYear; DateTime summitGenDate = Convert.ToDateTime(strYear + "/" + strMonth + "/" + strDay); model.SummitGenDate = summitGenDate; model.CCY = csvData.Rows[3].ItemArray[0].ToString().Replace("Ccy:", "").Trim(); model.CurveIndex = csvData.Rows[3].ItemArray[2].ToString().Replace("Index:", "").Trim(); if (csvData.Rows[i].ItemArray[2].ToString() != string.Empty) model.DiscFreq = Convert.ToDecimal(csvData.Rows[i].ItemArray[2].ToString()); if (csvData.Rows[i].ItemArray[0].ToString() != string.Empty) model.RateDate = Convert.ToDateTime(csvData.Rows[i].ItemArray[0].ToString()); if (csvData.Rows[i].ItemArray[1].ToString() != string.Empty) model.Rate = Convert.ToDecimal(csvData.Rows[i].ItemArray[1].ToString()); if (csvData.Rows[i].ItemArray[0].ToString().Trim() != string.Empty) { if (csvData.Rows[i].ItemArray[0].ToString().Contains('*')) { } else { model.Days = (Convert.ToDateTime(csvData.Rows[i].ItemArray[0]) - summitGenDate).Days; } } model.IsNew = true; if ((csvData.Rows[i].ItemArray[0].ToString() != string.Empty && csvData.Rows[i].ItemArray[1].ToString() != string.Empty) && csvData.Rows[i].ItemArray[2].ToString() != string.Empty) { importedList.Add(model); } } catch (Exception ex) { } } return importedList; }