public long Save(CLayer.Rooms room)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pRoomId", DataPlug.DataType._BigInt, room.RoomId));
param.Add(Connection.GetParameter("pRoomTypeId", DataPlug.DataType._Int, room.RoomTypeId));
param.Add(Connection.GetParameter("pRoomCount", DataPlug.DataType._Int, room.RoomCount));
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, room.PropertyId));
param.Add(Connection.GetParameter("pDescription", DataPlug.DataType._Varchar, room.Description));
object result = Connection.ExecuteQueryScalar("room_Save", param);
return(Connection.ToLong(result));
}
public CLayer.Rooms Get(long roomid)
{
CLayer.Rooms room = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pRoomId", DataPlug.DataType._BigInt, roomid));
DataTable dt = Connection.GetTable("room_Get", param);
if (dt.Rows.Count > 0)
{
room = new CLayer.Rooms();
room.RoomId = Connection.ToLong(dt.Rows[0]["RoomId"]);
room.RoomTypeId = Connection.ToInteger(dt.Rows[0]["RoomTypeId"]);
room.RoomCount = Connection.ToInteger(dt.Rows[0]["RoomCount"]);
room.PropertyId = Connection.ToLong(dt.Rows[0]["PropertyId"]);
room.Description = Connection.ToString(dt.Rows[0]["Description"]);
}
return(room);
}
public static long Save(CLayer.Rooms room)
{
DataLayer.Rooms rooms = new DataLayer.Rooms();
return(rooms.Save(room));
}
