private List<Loans> ExtractLoanList(DataTable csvData, List<string> columnNames)
{
List<Loans> importedList = new List<Loans>();
// string strMessage = "";
try
{
// Get All properties
//PropertyInfo[] properties = model.GetType().GetProperties();
//foreach (PropertyInfo pInfo in properties)
//{
// if (columnNames.Contains(pInfo.Name))
// {
// object value = row[pInfo.Name];
// TypeConverter typeConverter = TypeDescriptor.GetConverter(pInfo.PropertyType);
// object propValue = null;
// if (typeConverter.GetType().FullName == "System.ComponentModel.NullableConverter")
// {
// if (value.ToString().Trim() == "1" || value.ToString().Trim() == "Yes")
// {
// propValue = typeConverter.ConvertFromString(("True"));
// }
// }
// else
// propValue = typeConverter.ConvertFromString((value.ToString()));
// // Set value on the property
// pInfo.SetValue(model, propValue, null);
// }
foreach (DataRow dr in csvData.Rows)
{
Loans model = new Loans();
model.CodeName = dr["CodeName"].ToString();
// model.AmortisationsStartPoint = dr["AmortisationsStartPoint"].ToString();
model.Borrower = dr["Borrower"].ToString();
if (dr["Gurantor"] != null )
{
model.Gurantor = dr["Gurantor"].ToString();
}
model.Country = dr["Country"].ToString();
model.Grid = dr["Grid"].ToString();
model.SummitCreditEntity = dr["SummitCreditEntity"].ToString();
model.CreditRatingModys = dr["CreditRatingModys"].ToString();
model.CreditRatingSPs = dr["CreditRatingSPs"].ToString();
model.CreditRatingFitch = dr["CreditRatingFitch"].ToString();
model.CreditRatingING = dr["CreditRatingING"].ToString();
model.StructureID = dr["StructureID"].ToString();
model.PP = dr["PP"].ToString();
model.Sector = dr["Sector"].ToString();
model.FacilitySize = dr["FacilitySize"].ToString();
model.Signing_Date = dr["Signing_Date"].ToString();
model.Maturity_Date = dr["Maturity_Date"].ToString();
model.CouponDate = dr["CouponDate"].ToString();
model.FixedOrFloating = dr["FixedOrFloating"].ToString();
model.Margin = dr["Margin"].ToString();
model.Notional = dr["Notional"].ToString();
model.Currency = dr["Currency"].ToString();
model.CouponFrequency = dr["CouponFrequency"].ToString();
if (dr["Bilateral"].ToString() == "Yes")
model.Bilateral = true;
else
model.Bilateral = false;
//model.Amortizing = dr["Amortizing"].ToString();
model.Amortizing = "Yes";
if (dr["AmortisationsStartPoint"].ToString() != string.Empty)
{
model.AmortisationsStartPoint = dr["AmortisationsStartPoint"].ToString();
}
else
model.AmortisationsStartPoint = dr["CouponDate"].ToString();
if (dr["NoOfAmortisationPoint"].ToString().Trim() != string.Empty)
model.NoOfAmortisationPoint = Convert.ToInt16(dr["NoOfAmortisationPoint"]);
else
model.NoOfAmortisationPoint = GetNoOfAmortisations();
importedList.Add(model);
LoansBLL bll = new LoansBLL();
string str = bll.AddImportedLoans(model);
if (str != "")
{
RadWindowManager1.RadAlert(str, 330, 180, "realedge associates", "alertCallBackFn");
}
}
}
catch (Exception ex)
{
}
return importedList;
}
