1using System;
 2using System.Collections.Generic;
 3using System.Linq;
 4using System.Text;
 5using DAL;
 6using Entity;
 7using System.Data;
 8
 9namespace BLL
10...{
11    public class UserRoomBLL
12    ...{
13        public static int GetUserIDByHotelUser_UserNameRoom_Number(string UserName,string Number)
14        ...{
15            DataTable dt = UserRoomDAL.GetUserRoomByHotelUser_UserNameRoom_Number(UserName,Number);
16            return Convert.ToInt32(dt.Rows[0][0]);
17        }
18
19        public static DataTable GetReceptionTable()
20        ...{
21            return UserRoomDAL.GetUserReceptionTable();
22        }
23
24        public static DataTable GetUserReceptionByUserName(string UserName)
25        ...{
26            return UserRoomDAL.GetUserReceptionByUserName(UserName);  
27        }
28        public static DataTable GetUserReceptionByName(string Name)
29        ...{
30            return UserRoomDAL.GetUserReceptionByName(Name);
31        }
32        public static DataTable GetUserReceptionStateByRoomID(int RoomID)
33        ...{
34            return UserRoomDAL.GetUserReceptionStateByRoomID(RoomID);
35        }
36
37
38        public static int AddUserRoom(UserRoomEntity URE)
39        ...{
40            return UserRoomDAL.AddUserRoom(URE);
41        }
42
43        public static int UpdateUserReceptionStateByRoomID(int RoomID)
44        ...{
45            return UserRoomDAL.UpdateUserReceptionStateByRoomID(RoomID);
46        }
47
48        public static int DeleteUserRoomByUserID(int UserID,int RoomID)
49        ...{
50            return UserRoomDAL.DeleteUserRoomByUserID(UserID,RoomID);
51        }
52    }
53}
54