public Person GetUser(string name) { JongHorDBEntities1 db = new JongHorDBEntities1(); Person user = db.Person.Where(u => u.Username == name).First(); return(user); }
public RoomViewLayer GetRoomViewByRoom(int Room_ID) { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Room> RoomQuery = jonghor.Room; DbSet <Room_Reserved> RoomReservedQuery = jonghor.Room_Reserved; RoomViewLayer roomviewlayer = new RoomViewLayer(); foreach (Room room in RoomQuery) { if (room.Room_ID == Room_ID) { roomviewlayer.room = room; foreach (Person p in jonghor.Person) { if (p.Room_ID == room.Room_ID) { roomviewlayer.Reserved_num += 1; } } foreach (Room_Reserved roomreserved in RoomReservedQuery) { if (room.Room_ID == roomreserved.Room_ID) { roomviewlayer.Reserved_num += roomreserved.Count; } } } } return(roomviewlayer); }
public List <Dorm_Picture> GetDorm_Picture() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Dorm_Picture> dormDal = jonghor.Dorm_Picture; return(dormDal.ToList <Dorm_Picture>()); }
public List <Person> GetPerson() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Person> dormDal = jonghor.Person; return(dormDal.ToList <Person>()); }
public IQueryable <Message> GetMessage(string name) { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); IQueryable <Message> messages = jonghor.Message.Where(m => m.Receiver_Username == name); return(messages); }
public Dorm GetDorm(string name) { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); Dorm dorm = jonghor.Dorm.Where(d => d.Person.Username == name).First(); return(dorm); }
public List <Dorm> GetDorm() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Dorm> dormDal = jonghor.Dorm; return(dormDal.ToList <Dorm>()); }
public List <Dorm_Label> GetDorm_Label() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Dorm_Label> dormDal = jonghor.Dorm_Label; return(dormDal.ToList <Dorm_Label>()); }
/*public int RoomMax { get; set; } * public float RoomPrice { get; set; } * public string TypeRoom { get; set; } * public int TypeId { get; set; } * public string [] RoomOption { get; set; }*/ //h public List <Room_Type> GetRoom_Type() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Room_Type> dormDal = jonghor.Room_Type; return(dormDal.ToList <Room_Type>()); }
public List <Room_Reserved> GetRoomReservedByDormID(int dormId) { JongHorDBEntities1 db = new JongHorDBEntities1(); var roomReservedDB = db.Room_Reserved.Where(r => r.Room.Dorm_ID == dormId); return(roomReservedDB.ToList <Room_Reserved>()); }
public List <Room_Reserved> GetRoom_Reserved() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Room_Reserved> dormDal = jonghor.Room_Reserved; return(dormDal.ToList <Room_Reserved>()); }
public List <Dorm_Option> GetDorm_Option() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Dorm_Option> dormDal = jonghor.Dorm_Option; return(dormDal.ToList <Dorm_Option>()); }
public List <Person> GetPeople() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Person> peopleDal = jonghor.Person; return(peopleDal.ToList <Person>()); }
public List <Message> GetMessage() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Message> dormDal = jonghor.Message; return(dormDal.ToList <Message>()); }
public List<Dorm_Rate> GetDorm_Rate() { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet<Dorm_Rate> dormDal = jonghor.Dorm_Rate; return dormDal.ToList<Dorm_Rate>(); }
public Dorm GetDorm(int id) { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); IQueryable <Dorm> dorms = jonghor.Dorm.Where(d => d.Dorm_ID == id); if (dorms.ToList <Dorm>().Count != 0) { return(dorms.ToList <Dorm>()[0]); } else { return(new Dorm()); } }
public int GetDormId(string username) { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); List <Dorm> dorms = jonghor.Dorm.ToList <Dorm>(); foreach (Dorm dorm in dorms) { if (dorm.M_username == username) { return(dorm.Dorm_ID); } } return(-1); }
//for send message to unavailable room public List <Room> GetStatusRoom() { JongHorDBEntities1 jonghor1 = new JongHorDBEntities1(); DbSet <Room> RoomList = jonghor1.Room; List <Room> status = new List <Room>(); foreach (Room r in RoomList) { if (r.Status == (int)Status.NotAvaliable || r.Status == (int)Status.WaitRoomMate) { status.Add(r); } } return(status.ToList <Room>()); }
public List <RoomViewLayer> GetRoomViewByDorm(int Dorm_ID) { JongHorDBEntities1 jonghor = new JongHorDBEntities1(); DbSet <Room> RoomQuery = jonghor.Room; DbSet <Room_Type> RoomTypeQuery = jonghor.Room_Type; DbSet <Room_Reserved> RoomReservedQuery = jonghor.Room_Reserved; List <RoomViewLayer> Roomview = new List <RoomViewLayer>(); foreach (Room room in RoomQuery) { RoomViewLayer roomviewlayer = new RoomViewLayer(); if (room.Dorm_ID == Dorm_ID) { roomviewlayer.room = room; foreach (Person p in jonghor.Person) { if (p.Room_ID == room.Room_ID) { roomviewlayer.Reserved_num += 1; } } foreach (Room_Reserved roomreserved in RoomReservedQuery) { if (room.Room_ID == roomreserved.Room_ID) { roomviewlayer.Reserved_num += roomreserved.Count; } } if (Reserved_num < roomviewlayer.room.Room_Type.Max) { filter = roomviewlayer.room.Status; Roomview.Add(roomviewlayer); } } } return(Roomview); }
public List <Room_Type> GetRoomTypes(Dorm dorm) { JongHorDBEntities1 db = new JongHorDBEntities1(); IQueryable <Room> rooms = db.Room.Where(r => r.Dorm_ID == dorm.Dorm_ID); List <Room_Type> types = new List <Room_Type>(); foreach (Room room in rooms) { if (!types.Contains(room.Room_Type)) { types.Add(room.Room_Type); } } return(types); }