public static List <LoanCharge> GetList()
{
string sqlCommandText = string.Format("SELECT * FROM {0}", TableName);
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlCommandText);
var list = new List <LoanCharge>();
foreach (DataRow row in dataTable.Rows)
{
var item = new LoanCharge();
item.SetPropertiesFromDataRow(row);
list.Add(item);
}
return(list);
}
public static List <LoanCharge> GetListByLoanProductId(int loanProductId)
{
string sqlCommandText = string.Format("SELECT * FROM {0} WHERE LoanProductId = ?LoanProductId ORDER BY AccountCode",
TableName);
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlCommandText,
new SqlParameter("?LoanProductId", loanProductId));
var list = new List <LoanCharge>();
foreach (DataRow row in dataTable.Rows)
{
var item = new LoanCharge();
item.SetPropertiesFromDataRow(row);
list.Add(item);
}
return(list);
//return (from DataRow row in dataTable.Rows
// select new LoanCharge
// ((int)row["LoanChargeId"], (int)row["LoanProductId"], (string)row["AccountCode"], (decimal)row["Rate"])).ToList();
}
