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