public List <ManagementCheckList> GetManagementCheckLists() { List <ManagementCheckList> managementCheckLists = new List <ManagementCheckList>(); SqlCommand Selectcommand = GetSqlCommand(); oasisconnectionString.Open(); int counter = 0; using (SqlDataReader rd = Selectcommand.ExecuteReader()) { while (rd.Read()) { ManagementCheckList checkList = new ManagementCheckList(); checkList.Id = Convert.ToInt32(rd["Id"]); checkList.date = Convert.ToDateTime(rd["date"]); checkList.TDs_clean = Convert.ToDecimal(rd["TDs_clean"]); checkList.TDs_Main = Convert.ToDecimal(rd["TDs_Main"]); checkList.Ozone = rd["Ozone"].ToString(); checkList.Silcone_Crystal_Color = rd["Silcone_Crystal_Color"].ToString(); checkList.Mun_Tank_level = Convert.ToDecimal(rd["Mun_Tank_level"]); checkList.Clean_tank_level = Convert.ToDecimal(rd["Clean_tank_level"]); checkList._1_PF_10_Micron = Convert.ToDecimal(rd["_1_PF_10_Micron"]); checkList._2_PF_5_Micron = Convert.ToDecimal(rd["_2_PF_5_Micron"]); checkList._3_Sand_Filter = Convert.ToDecimal(rd["_3_Sand_Filter"]); checkList._4_Softner = Convert.ToDecimal(rd["_4_Softner"]); checkList._5_1_Micron_Preasure = Convert.ToDecimal(rd["_5_1_Micron_Preasure"]); checkList._6_Membrane_Preasure = Convert.ToDecimal(rd["_6_Membrane_Preasure"]); checkList._7_Flow_Rate_RAW = Convert.ToDecimal(rd["_7_Flow_Rate_RAW"]); checkList._8_Flow_Rate_Clean = rd["_8_Flow_Rate_Clean"].ToString(); checkList._9_Pump_Functional = rd["_9_Pump_Functional"].ToString(); checkList.Conductive = Convert.ToDecimal(rd["Conductive"]); checkList.Clean_Water_Meter_Reading = Convert.ToDecimal(rd["Clean_Water_Meter_Reading"]); checkList.Litres_Purified_Since_Previous_Reading = Convert.ToDecimal(rd["Litres_Purified_Since_Previous_Reading"]); checkList.CheckListType = rd["CheckListType"].ToString(); managementCheckLists.Add(checkList); counter += 1; } } oasisconnectionString.Close(); return(managementCheckLists); }
//my constructors public CheckList(ManagementCheckList Item, string key) { this.Item = Item; this.key = key; }