public List <S_Room> GetRoomsInStation(string id)
{
SqlParameter[] parms = { new SqlParameter("@StationId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
var entities = new List <S_Room>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_S_Room_Repository_GetRoomsInStation, parms)) {
while (rdr.Read())
{
var entity = new S_Room();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new C_RoomType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeName"])
};
entity.Vendor = SqlTypeConverter.DBNullStringHandler(rdr["Vendor"]);
entity.Floor = SqlTypeConverter.DBNullInt32Handler(rdr["Floor"]);
entity.PropertyId = SqlTypeConverter.DBNullInt32Handler(rdr["PropertyId"]);
entity.Address = SqlTypeConverter.DBNullStringHandler(rdr["Address"]);
entity.Length = SqlTypeConverter.DBNullStringHandler(rdr["Length"]);
entity.Width = SqlTypeConverter.DBNullStringHandler(rdr["Width"]);
entity.Heigth = SqlTypeConverter.DBNullStringHandler(rdr["Heigth"]);
entity.FloorLoad = SqlTypeConverter.DBNullStringHandler(rdr["FloorLoad"]);
entity.LineHeigth = SqlTypeConverter.DBNullStringHandler(rdr["LineHeigth"]);
entity.Square = SqlTypeConverter.DBNullStringHandler(rdr["Square"]);
entity.EffeSquare = SqlTypeConverter.DBNullStringHandler(rdr["EffeSquare"]);
entity.FireFighEuip = SqlTypeConverter.DBNullStringHandler(rdr["FireFighEuip"]);
entity.Owner = SqlTypeConverter.DBNullStringHandler(rdr["Owner"]);
entity.QueryPhone = SqlTypeConverter.DBNullStringHandler(rdr["QueryPhone"]);
entity.PowerSubMain = SqlTypeConverter.DBNullStringHandler(rdr["PowerSubMain"]);
entity.TranSubMain = SqlTypeConverter.DBNullStringHandler(rdr["TranSubMain"]);
entity.EnviSubMain = SqlTypeConverter.DBNullStringHandler(rdr["EnviSubMain"]);
entity.FireSubMain = SqlTypeConverter.DBNullStringHandler(rdr["FireSubMain"]);
entity.AirSubMain = SqlTypeConverter.DBNullStringHandler(rdr["AirSubMain"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["Contact"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public static void C_RoomHandler(PacketSession session, IMessage packet)
{
Console.WriteLine("Room Give Please");
ClientSession clientSession = session as ClientSession;
S_Room roomPacket = new S_Room();
for (int i = 1; i < RoomManager.Instance._roomId; i++)
{
RoomInfo roomInfo = new RoomInfo();
roomInfo.PlayerNumber = RoomManager.Instance.Find(i).PlayerNumber;
roomInfo.RoomId = i;
roomInfo.Name = RoomManager.Instance.Find(i).RoomName;
roomInfo.Password = RoomManager.Instance.Find(i).Password;
if (!RoomManager.Instance.Find(i).isCreating&& !RoomManager.Instance.Find(i).isPlaying)
{
roomPacket.Room.Add(roomInfo);
}
}
clientSession.Send(roomPacket);
}
