//public List<RoomPoco> GetRoom()
//{
// List<ROOMVIEW> roomdblist = (from x in db.ROOMVIEW
// orderby x.ODANO
// select x).ToList();
// List<RoomPoco> roomlistPoco = new List<RoomPoco>();
// foreach (var roomdb in roomdblist)
// {
// string odano = roomdb.ODANO;
// RoomPoco roomPoco = new RoomPoco
// {
// OdaNo = roomdb.ODANO,
// OdaTip = roomdb.ODATIP,
// No = Convert.ToInt32(roomdb.NO),
// Title = roomdb.TITLE,
// FirstName = roomdb.FIRSTNAME,
// LastName = roomdb.LASTNAME,
// FromDate = roomdb.FROMDATE,
// ToDate = roomdb.TODATE
// };
// roomlistPoco.Add(roomPoco);
// }
// return roomlistPoco;
//}
public List <RoomPoco> GetRoom()
{
List <ROOMVIEW> roomdblist = (from x in db.ROOMVIEW
orderby x.ODANO
select x).ToList();
THEDATE theDate = (from x in db.THEDATE
orderby x.ODEONDATE descending
select x).First();
List <RoomPoco> roomlistPoco = new List <RoomPoco>();
foreach (var roomdb in roomdblist)
{
bool IsEndDate = false;
bool IsFromDate = false;
if (roomdb.TODATE == theDate.ODEONDATE)
{
IsEndDate = true;
}
if (roomdb.FROMDATE == theDate.ODEONDATE)
{
IsFromDate = true;
}
RoomPoco roomPoco = new RoomPoco
{
OdaNo = roomdb.ODANO,
OdaTip = roomdb.ODATIP,
No = Convert.ToInt32(roomdb.NO),
Title = roomdb.TITLE,
FirstName = roomdb.FIRSTNAME,
LastName = roomdb.LASTNAME,
FromDate = roomdb.FROMDATE,
ToDate = roomdb.TODATE,
IsEndDate = IsEndDate,
IsFromDate = IsFromDate
};
roomlistPoco.Add(roomPoco);
}
return(roomlistPoco);
}
public List <RoomPoco> GetRoomsByFilter(string roomsfilter, string name)
{
List <ROOMVIEW> roomdblist = new List <ROOMVIEW>();
switch (roomsfilter)
{
case "1":
roomdblist = (from x in db.ROOMVIEW
orderby x.ODANO
select x).ToList();
break;
case "2":
roomdblist = (from x in db.ROOMVIEW
where (x.LASTNAME == "" || x.LASTNAME == null)
orderby x.ODANO
select x).ToList();
break;
case "3":
roomdblist = (from x in db.ROOMVIEW
where (x.LASTNAME != "" || x.LASTNAME != null)
orderby x.ODANO
select x).ToList();
break;
case "4":
roomdblist = (from x in db.ROOMVIEW
from y in db.THEDATE
where ((x.LASTNAME != "" || x.LASTNAME != null) && (x.FROMDATE == y.ODEONDATE))
orderby x.ODANO
select x).ToList();
break;
case "5":
roomdblist = (from x in db.ROOMVIEW
from y in db.THEDATE
where ((x.LASTNAME != "" || x.LASTNAME != null) && (x.TODATE == y.ODEONDATE))
orderby x.ODANO
select x).ToList();
break;
}
if (string.IsNullOrEmpty(name) == false)
{
roomdblist = (from x in roomdblist
where (x.FIRSTNAME.Contains(name) || x.LASTNAME.Contains(name))
select x).ToList();
}
THEDATE theDate = (from x in db.THEDATE
orderby x.ODEONDATE descending
select x).First();
List <RoomPoco> roomlistPoco = new List <RoomPoco>();
foreach (var roomdb in roomdblist)
{
//string odano = roomdb.ODANO;
bool IsEndDate = false;
bool IsFromDate = false;
if (roomdb.TODATE == theDate.ODEONDATE)
{
IsEndDate = true;
}
if (roomdb.FROMDATE == theDate.ODEONDATE)
{
IsFromDate = true;
}
RoomPoco roomPoco = new RoomPoco
{
OdaNo = roomdb.ODANO,
OdaTip = roomdb.ODATIP,
No = Convert.ToInt32(roomdb.NO),
Title = roomdb.TITLE,
FirstName = roomdb.FIRSTNAME,
LastName = roomdb.LASTNAME,
FromDate = roomdb.FROMDATE,
ToDate = roomdb.TODATE,
IsEndDate = IsEndDate,
IsFromDate = IsFromDate
};
roomlistPoco.Add(roomPoco);
}
return(roomlistPoco);
}
