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