/// <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;
}
