public IList<RowsourceEntity> ChemicalUseRowsource() { List<RowsourceEntity> rowsources = new List<RowsourceEntity>(); List<string> values = new List<string>() { "10", "9", "8", "7", "6", "5", "4", "3", "2", "1", "0", "C" }; foreach (string s in values) { RowsourceEntity rowsource = new RowsourceEntity(); //rowsource.Key = s; rowsource.Value = s; rowsources.Add(rowsource); } return rowsources; }
public IList<RowsourceEntity> F33xRowsource() { List<RowsourceEntity> rowsources = new List<RowsourceEntity>(); List<string> values = new List<string>() { "-10", "-9", "-8", "-7", "-6", "-5", "-4", "-3", "-2", "-1", "0" }; foreach (string s in values) { RowsourceEntity rowsource = new RowsourceEntity(); //rowsource.Key = s; rowsource.Value = s; rowsources.Add(rowsource); } return rowsources; }
public IList<RowsourceEntity> ProductionSystemRowsource() { List<RowsourceEntity> rowsources = new List<RowsourceEntity>(); RowsourceEntity rowsource = new RowsourceEntity(); rowsource.Key = 1; rowsource.Value = "Net, Cages and Pens"; rowsources.Add(rowsource); rowsource = new RowsourceEntity(); rowsource.Key = 2; rowsource.Value = "Ponds"; rowsources.Add(rowsource); rowsource = new RowsourceEntity(); rowsource.Key = 3; rowsource.Value = "Raceways or Tanks"; rowsources.Add(rowsource); rowsource = new RowsourceEntity(); rowsource.Key = 4; rowsource.Value = "Other"; rowsources.Add(rowsource); return rowsources; }
public IList<RowsourceEntity> RecommendationType() { DataTable dt = DB.GetDataTable(new SQLBuilder("Select r.Id as [Key], r.Description as Value from RecommendationType r order by r.Description")); List<RowsourceEntity> rowsources = new List<RowsourceEntity>(); foreach (DataRow dr in dt.Rows) { RowsourceEntity rowsource = new RowsourceEntity(); //TODO: Find out why this isn't working //Framework.EntityPopulate(rowsource, dr); rowsource.Key = Convert.ToInt32(dr["Key"]); rowsource.Value = dr["Value"].ToString(); rowsources.Add(rowsource); } return rowsources; }
public IList<RowsourceEntity> MethodAutocomplete(string filter) { DataTable dt = DB.GetDataTable(new SQLBuilder("Select m.Id as [Key], m.Method as Value from Method m where m.Method like @0 order by m.Method", "%" + filter.ToString() + "%")); List<RowsourceEntity> rowsources = new List<RowsourceEntity>(); foreach (DataRow dr in dt.Rows) { RowsourceEntity rowsource = new RowsourceEntity(); //TODO: Figure out why the Framework.EntityPopulate methods isn't working--temporarily replacing it with direct calls to populate rowsource //Framework.EntityPopulate(rowsource, dr); rowsource.Key = Convert.ToInt32(dr["Key"]); rowsource.Value = dr["Value"].ToString(); rowsources.Add(rowsource); } return rowsources; }
public IList<RowsourceEntity> FactorType() { //excluding 3.1 and 3.2. DataTable dt = DB.GetDataTable(new SQLBuilder("Select Id as [Key], Prefix + ' : ' + isnull(Description,'') as Value from FactorType Where criteriaId <> 3 order by case when criteriaId = 4 then 10 else criteriaId end, SortOrder")); List<RowsourceEntity> rowsources = new List<RowsourceEntity>(); foreach (DataRow dr in dt.Rows) { RowsourceEntity rowsource = new RowsourceEntity(); Framework.EntityPopulate(rowsource, dr); rowsources.Add(rowsource); } return rowsources; }
public IList<RowsourceEntity> FactorScore(int factorTypeId) { DataTable dt = DB.GetDataTable(new SQLBuilder("Select Id as [Key], isnull(Description,'') as Value from FactorScore where FactorTypeId = @0 order by number", factorTypeId.ToString())); List<RowsourceEntity> rowsources = new List<RowsourceEntity>(); foreach (DataRow dr in dt.Rows) { RowsourceEntity rowsource = new RowsourceEntity(); Framework.EntityPopulate(rowsource, dr); rowsources.Add(rowsource); } return rowsources; }
public IList<RowsourceEntity> DataQuality() { List<RowsourceEntity> rowsources = new List<RowsourceEntity>(); List<string> values = new List<string>() { "0", "2.5", "5", "7.5", "10" }; foreach (string s in values) { RowsourceEntity rowsource = new RowsourceEntity(); //rowsource.Key = s; rowsource.Value = s; rowsources.Add(rowsource); } return rowsources; }