public List<RoomAccount> getRoomList() { List<RoomAccount> RoomList = new List<RoomAccount>(); conn.Open(); DataSet setdata = new DataSet(); SqlCeCommand cmd = new SqlCeCommand("select * from RoomInformation", conn); SqlCeDataAdapter adapter = new SqlCeDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(setdata); RoomAccount _RoomAccount = new RoomAccount(); for (int i = 0; i < setdata.Tables[0].Rows.Count; i++) { _RoomAccount = new RoomAccount(); _RoomAccount.ID = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[30].ToString()); _RoomAccount.ApartName = setdata.Tables[0].Rows[i].ItemArray[0].ToString(); _RoomAccount.RoomForSale = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[1].ToString()); _RoomAccount.RoomForRent = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[2].ToString()); _RoomAccount.RoomType = setdata.Tables[0].Rows[i].ItemArray[3].ToString(); _RoomAccount.RoomSize = setdata.Tables[0].Rows[i].ItemArray[4].ToString(); _RoomAccount.RoomPriceMax = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[5].ToString()); _RoomAccount.RoomPriceMin = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[6].ToString()); _RoomAccount.AddDistrict = setdata.Tables[0].Rows[i].ItemArray[7].ToString(); _RoomAccount.FullAddress = setdata.Tables[0].Rows[i].ItemArray[8].ToString(); _RoomAccount.ElecPerUnit = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[9].ToString()); _RoomAccount.WaterPerUnit = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[10].ToString()); _RoomAccount.AirCon = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[11].ToString()); _RoomAccount.Fridge = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[12].ToString()); _RoomAccount.Balcony = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[13].ToString()); _RoomAccount.Tv = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[14].ToString()); _RoomAccount.Internet = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[15].ToString()); _RoomAccount.Heater = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[16].ToString()); _RoomAccount.Pets = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[17].ToString()); _RoomAccount.Fitness = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[18].ToString()); _RoomAccount.Swimming = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[19].ToString()); _RoomAccount.Laundry = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[20].ToString()); _RoomAccount.Store = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[21].ToString()); _RoomAccount.Elevator = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[22].ToString()); _RoomAccount.Parking = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[23].ToString()); _RoomAccount.FrontDesk = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[24].ToString()); _RoomAccount.SecurityKeyCard = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[25].ToString()); _RoomAccount.SecurityFingerPrint = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[26].ToString()); _RoomAccount.SecurityCCTV = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[27].ToString()); _RoomAccount.SecurityGuard = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[28].ToString()); _RoomAccount.SecurityFireAlarm = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[29].ToString()); RoomList.Add(_RoomAccount); } conn.Close(); return RoomList; }
public RoomAccountRepository(RoomAccount _roominformation) { this.roominformation = _roominformation; }