//--------------------------------------------------------------------------------------------------------
// Fill the Room combobox for the selected BNuilding based on properties: SiteCode, OnlyAvailable, EmptyMemberLabel & DisplayMember
//--------------------------------------------------------------------------------------------------------
private void fillRoom()
{
IList <RoomPicker_Room> _list = new List <RoomPicker_Room>();
if (cbBuilding.SelectedItem != null && ((RoomPicker_Building)cbBuilding.SelectedItem).ID != 0)
{
if (_OnlyAvailable)
{
_list = RoomPicker_Room.Load("WHERE AVAILABLE='True' AND SITE='" + _SiteCode + "' AND FK_BUILDING=" + cbBuilding.SelectedValue + " AND FK_MODULE=" + _ModuleID);
}
else
{
_list = RoomPicker_Room.Load("WHERE SITE='" + _SiteCode + "' AND FK_BUILDING=" + cbBuilding.SelectedValue + " AND FK_MODULE=" + _ModuleID);
}
}
RoomPicker_Room _empty = new RoomPicker_Room();
_empty.CODE = " " + _EmptyMemberLabel;
_empty.NAME = " " + _EmptyMemberLabel;
_list.Add(_empty);
cbRoom.ValueMember = "ID";
if (_DisplayMember == GlobalVariables.DisplayMember.Code)
{
cbRoom.DisplayMember = "CODE";
cbRoom.DataSource = _list.OrderBy(x => x.CODE).ToList();
}
else
{
cbRoom.DisplayMember = "NAME";
cbRoom.DataSource = _list.OrderBy(x => x.NAME).ToList();
}
cbRoom.SelectedValue = _RoomID;
}
//-------------------------------------------------------------------
// Get the ID of the encoded Room or create a new one if it does not exists
//-------------------------------------------------------------------
public Int64 GetRoomID()
{
string Code = txRoom.Text.Trim().ToUpper();
if (Code != string.Empty && cbBuilding.SelectedItem != null && ((RoomPicker_Building)cbBuilding.SelectedItem).ID != 0)
{
RoomPicker_Building _bd = (RoomPicker_Building)cbBuilding.SelectedItem;
RoomPicker_Room _rm = RoomPicker_Room.Load("WHERE UPPER(CODE)='" + Code + "' AND FK_BUILDING=" + _bd.ID).FirstOrDefault();
if (_rm == null || _rm.ID == 0)
{
if (_AllowNewRoom)
{
SynapseCore.Database.DBFunction.StartTransaction();
try
{
RoomPicker_Room newRoom = new RoomPicker_Room();
newRoom.CODE = Code;
newRoom.NAME = _bd.CODE + Code;
newRoom.FK_BUILDING = _bd.ID;
newRoom.AVAILABLE = true;
newRoom.FK_MODULE = _ModuleID;
newRoom.SITE = _SiteCode;
newRoom.save();
SynapseCore.Database.DBFunction.CommitTransaction();
return(newRoom.ID);
}
catch (Exception ex)
{
SynapseCore.Database.DBFunction.RollbackTransaction();
GlobalFunctions.showMessage("ERR", "Err.9999", ex.Message);
return(0);
}
}
else
{
return(0);
}
}
else
{
return(_rm.ID);
}
}
else
{
return(0);
}
}
public override void initForm(SynapseCore.Security.Tools.SecureAndTranslateMode Mode)
{
base.initForm(Mode);
EntityList = RoomPicker_Entity.Load("WHERE FK_MODULE=" + this.ModuleID + " AND SITE='" + _SiteCode + "'");
BuildingList = RoomPicker_Building.Load("WHERE FK_MODULE=" + this.ModuleID + " AND SITE='" + _SiteCode + "'");
if (!_RoomNameMandatory)
{
colName.FillsFreeSpace = false;
colName.Searchable = false;
colName.IsVisible = false;
colCode.FillsFreeSpace = true;
olvRoom.RebuildColumns();
}
updateSearchCheckboxes();
tsbOpen.Enabled = false;
tsbDelete.Enabled = false;
ctxOpen.Enabled = false;
ctxDelete.Enabled = false;
if (!AllowDelete)
{
tsbDelete.Enabled = false;
ctxDelete.Enabled = false;
tsbDelete.Visible = false;
ctxDelete.Visible = false;
}
IList <RoomPicker_Room> _List = RoomPicker_Room.Load("WHERE SITE='" + _SiteCode + "' AND FK_MODULE=" + this.ModuleID);
olvRoom.SetObjects(_List);
}
public RoomPickerTree()
{
InitializeComponent();
colCode.ImageGetter = delegate(object x)
{
if (_ShowImage)
{
if (x is RoomPicker_Entity)
{
return("entity");
}
else
if (x is RoomPicker_Building)
{
return("building");
}
else
if (x is RoomPicker_Room)
{
return("room2");
}
}
return(null);
};
treeList.CanExpandGetter = delegate(object x)
{
if (x is Entities.RoomPicker_Entity)
{
if (_PickerType == GlobalVariables.PickerType.Building || _PickerType == GlobalVariables.PickerType.Room)
{
return(true);
}
else
{
return(false);
}
}
if (x is Entities.RoomPicker_Building)
{
if (_PickerType == GlobalVariables.PickerType.Room)
{
return(true);
}
else
{
return(false);
}
}
return(false);
};
treeList.ChildrenGetter = delegate(object x)
{
if (x is Entities.RoomPicker_Entity)
{
Entities.RoomPicker_Entity _ent = (Entities.RoomPicker_Entity)x;
IList <RoomPicker_Building> _list = new List <RoomPicker_Building>();
if (_OnlyAvailable)
{
_list = RoomPicker_Building.Load("WHERE AVAILABLE='True' AND SITE='" + _SiteCode + "' AND FK_ENTITY=" + _ent.ID + " AND FK_MODULE=" + _ModuleID);
}
else
{
_list = RoomPicker_Building.Load("WHERE SITE='" + _SiteCode + "' AND FK_ENTITY=" + _ent.ID + " AND FK_MODULE=" + _ModuleID);
}
return(_list.OrderBy(y => y.CODE).ToList());
}
else
{
Entities.RoomPicker_Building _bld = (Entities.RoomPicker_Building)x;
IList <RoomPicker_Room> _list = new List <RoomPicker_Room>();
if (_OnlyAvailable)
{
_list = RoomPicker_Room.Load("WHERE AVAILABLE='True' AND SITE='" + _SiteCode + "' AND FK_BUILDING=" + _bld.ID + " AND FK_MODULE=" + _ModuleID);
}
else
{
_list = RoomPicker_Room.Load("WHERE SITE='" + _SiteCode + "' AND FK_BUILDING=" + _bld.ID + " AND FK_MODULE=" + _ModuleID);
}
return(_list.OrderBy(y => y.CODE).ToList());
}
};
}
