public override void initForm(SynapseCore.Security.Tools.SecureAndTranslateMode Mode)
{
base.initForm(Mode);
EntityList = RoomPicker_Entity.Load("WHERE FK_MODULE=" + this.ModuleID + " AND SITE='" + _SiteCode + "'");
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_Building> _List = RoomPicker_Building.Load("WHERE SITE='" + _SiteCode + "' AND FK_MODULE=" + this.ModuleID);
olvBuilding.SetObjects(_List);
}
//---------------------------------------------------------------------------------------------
// Show the Building Creation Form
//---------------------------------------------------------------------------------------------
private void btNewBuilding_Click(object sender, EventArgs e)
{
frmBuilding fDetail = new frmBuilding();
fDetail.ModuleID = this.ModuleID;
fDetail.Mode = GlobalVariables.EditMode.New;
fDetail.PreSelectedEntity = (Int64)cbEntity.SelectedValue;
RoomPicker_Building _building = new RoomPicker_Building();
_building.SITE = _SiteCode;
fDetail.Entity = _building;
if (fDetail.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (_SelectNewAfterCreation)
{
this.SynchronizeWithBuilding(fDetail.Entity.ID);
}
else
{
_BuildingID = 0;
fillBuilding();
}
}
}
//--------------------------------------------------------------------------------------------------------
// Fill the Building combobox for the selected Entity based on properties: SiteCode, OnlyAvailable, EmptyMemberLabel & DisplayMember
//--------------------------------------------------------------------------------------------------------
private void fillBuilding()
{
IList <RoomPicker_Building> _list = new List <RoomPicker_Building>();
if (cbEntity.SelectedItem != null && ((RoomPicker_Entity)cbEntity.SelectedItem).ID != 0)
{
if (_OnlyAvailable)
{
_list = RoomPicker_Building.Load("WHERE AVAILABLE='True' AND SITE='" + _SiteCode + "' AND FK_ENTITY=" + cbEntity.SelectedValue + " AND FK_MODULE=" + _ModuleID);
}
else
{
_list = RoomPicker_Building.Load("WHERE SITE='" + _SiteCode + "' AND FK_ENTITY=" + cbEntity.SelectedValue + " AND FK_MODULE=" + _ModuleID);
}
}
RoomPicker_Building _empty = new RoomPicker_Building();
_empty.CODE = " " + _EmptyMemberLabel;
_empty.NAME = " " + _EmptyMemberLabel;
_list.Add(_empty);
cbBuilding.ValueMember = "ID";
if (_DisplayMember == GlobalVariables.DisplayMember.Code)
{
cbBuilding.DisplayMember = "CODE";
cbBuilding.DataSource = _list.OrderBy(x => x.CODE).ToList();
}
else
{
cbBuilding.DisplayMember = "NAME";
cbBuilding.DataSource = _list.OrderBy(x => x.NAME).ToList();
}
cbBuilding.SelectedValue = _BuildingID;
}
//-------------------------------------------------------------------
// Synchronize the Entity & Building List with the Building ID passed in parameter
//-------------------------------------------------------------------
public void SynchronizeWithBuilding(Int64 ID)
{
RoomPicker_Building _bd = RoomPicker_Building.LoadByID(ID);
RoomPicker_Entity _en = RoomPicker_Entity.LoadByID(_bd.FK_ENTITY);
treeList.Expand((from e in treeList.Objects.OfType <RoomPicker_Entity>().ToList() where e.ID == _en.ID select e).FirstOrDefault());
treeList.SelectObject((from e in treeList.Objects.OfType <RoomPicker_Entity>().ToList() where e.ID == _en.ID select e).FirstOrDefault());
treeList.Expand((from b in treeList.GetChildren(treeList.SelectedObject).OfType <RoomPicker_Building>().ToList() where b.ID == _bd.ID select b).FirstOrDefault());
treeList.SelectObject((from b in treeList.GetChildren(treeList.SelectedObject).OfType <RoomPicker_Building>().ToList() where b.ID == _bd.ID select b).FirstOrDefault());
}
//-------------------------------------------------------------------
// Synchronize the Entity & Building List with the Building ID passed in parameter
//-------------------------------------------------------------------
public void SynchronizeWithBuilding(Int64 ID)
{
RoomPicker_Building _bd = RoomPicker_Building.LoadByID(ID);
fillEntity();
_EntityID = _bd.FK_ENTITY;
cbEntity.SelectedValue = _EntityID;
fillBuilding();
_BuildingID = ID;
cbBuilding.SelectedValue = _BuildingID;
}
public override void initForm(SynapseCore.Security.Tools.SecureAndTranslateMode Mode)
{
base.initForm(Mode);
ckAvailable.Text = GetLabel("frmRoom.ckAvailable");
if (!_RoomNameMandatory)
{
lbName.Visible = false;
txName.Visible = false;
}
displayEntity();
switch (_Mode)
{
case GlobalVariables.EditMode.New:
//this.Text = this.Text + " - " + SynapseForm.GetLabel("global.Create");
if (_PreSelectedEntity != 0)
{
cbEntity.SelectedValue = _PreSelectedEntity;
cbBuilding.Select();
}
else
{
cbEntity.SelectedIndex = -1;
}
if (_PreSelectedBuilding != 0)
{
cbBuilding.SelectedValue = _PreSelectedBuilding;
txCode.Select();
}
else
{
cbBuilding.SelectedIndex = -1;
}
txCode.Text = "";
txName.Text = "";
ckAvailable.Checked = true;
break;
case GlobalVariables.EditMode.Edit:
_entity.dump();
//this.Text = this.Text + " - " + SynapseForm.GetLabel("global.Edit");
cbEntity.SelectedValue = RoomPicker_Building.LoadByID(_entity.FK_BUILDING).FK_ENTITY;
cbBuilding.SelectedValue = _entity.FK_BUILDING;
txCode.Text = _entity.CODE;
txName.Text = _entity.NAME;
ckAvailable.Checked = _entity.AVAILABLE;
break;
}
}
private void displayBuilding()
{
if (cbEntity.SelectedItem != null)
{
IList <RoomPicker_Building> _list = new List <RoomPicker_Building>();
_list = RoomPicker_Building.Load("WHERE SITE='" + _entity.SITE + "' AND FK_ENTITY=" + cbEntity.SelectedValue);
cbBuilding.DisplayMember = "CODE";
cbBuilding.ValueMember = "ID";
cbBuilding.DataSource = _list.OrderBy(x => x.CODE).ToList();
}
}
//---------------------------------------------------------------------------------------------
// On Building Selection, Fill the corresponding Room List & Raise the SelectionChanged Event
//---------------------------------------------------------------------------------------------
private void cbBuilding_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbBuilding.SelectedItem != null)
{
_BuildingID = ((RoomPicker_Building)cbBuilding.SelectedItem).ID;
_Building = (RoomPicker_Building)cbBuilding.SelectedItem;
}
_RoomID = 0;
fillRoom();
OnSelectionChanged(cbBuilding, EventArgs.Empty);
}
//-------------------------------------------------------------------
// 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);
}
}
//-------------------------------------------------------------------
// Synchronize the Entity, Building & Room List with the Room ID passed in parameter
//-------------------------------------------------------------------
public void SynchronizeWithRoom(Int64 ID)
{
RoomPicker_Room _rm = RoomPicker_Room.LoadByID(ID);
RoomPicker_Building _bd = RoomPicker_Building.LoadByID(_rm.FK_BUILDING);
fillEntity();
_EntityID = _bd.FK_ENTITY;
cbEntity.SelectedValue = _EntityID;
fillBuilding();
_BuildingID = _bd.ID;
cbBuilding.SelectedValue = _BuildingID;
fillRoom(ID);
_RoomID = ID;
}
private void NewBuilding()
{
frmBuilding fDetail = new frmBuilding();
fDetail.ModuleID = this.ModuleID;
fDetail.Mode = GlobalVariables.EditMode.New;
RoomPicker_Building _building = new RoomPicker_Building();
_building.SITE = _SiteCode;
fDetail.Entity = _building;
if (fDetail.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
olvBuilding.AddObject(fDetail.Entity);
}
}
//-------------------------------------------------------------------
// Synchronize the Entity, Building & Room List with the Room ID passed in parameter
//-------------------------------------------------------------------
public void SynchronizeWithRoom(Int64 ID)
{
RoomPicker_Room _rm = RoomPicker_Room.LoadByID(ID);
RoomPicker_Building _bd = RoomPicker_Building.LoadByID(_rm.FK_BUILDING);
RoomPicker_Entity _en = RoomPicker_Entity.LoadByID(_bd.FK_ENTITY);
treeList.Expand((from e in treeList.Objects.OfType <RoomPicker_Entity>().ToList() where e.ID == _en.ID select e).FirstOrDefault());
treeList.SelectObject((from e in treeList.Objects.OfType <RoomPicker_Entity>().ToList() where e.ID == _en.ID select e).FirstOrDefault());
treeList.Expand((from b in treeList.GetChildren(treeList.SelectedObject).OfType <RoomPicker_Building>().ToList() where b.ID == _bd.ID select b).FirstOrDefault());
treeList.SelectObject((from b in treeList.GetChildren(treeList.SelectedObject).OfType <RoomPicker_Building>().ToList() where b.ID == _bd.ID select b).FirstOrDefault());
treeList.SelectObject((from r in treeList.GetChildren(treeList.SelectedObject).OfType <RoomPicker_Room>().ToList() where r.ID == _rm.ID select r).FirstOrDefault());
//OnSelectionChanged(treeList, EventArgs.Empty);
}
private void treeList_SelectedIndexChanged(object sender, EventArgs e)
{
if (treeList.SelectedObject is Entities.RoomPicker_Entity)
{
_Entity = (Entities.RoomPicker_Entity)treeList.SelectedObject;
_EntityID = _Entity.ID;
_Building = new Entities.RoomPicker_Building();
_BuildingID = 0;
_Room = new Entities.RoomPicker_Room();
_RoomID = 0;
OnSelectionChanged(treeList, EventArgs.Empty);
}
if (treeList.SelectedObject is Entities.RoomPicker_Building)
{
_Entity = (Entities.RoomPicker_Entity)treeList.GetParent(treeList.SelectedObject);
_EntityID = _Entity.ID;
_Building = (Entities.RoomPicker_Building)treeList.SelectedObject;
_BuildingID = _Building.ID;
_Room = new Entities.RoomPicker_Room();
_RoomID = 0;
OnSelectionChanged(treeList, EventArgs.Empty);
}
if (treeList.SelectedObject is Entities.RoomPicker_Room)
{
_Entity = (Entities.RoomPicker_Entity)treeList.GetParent(treeList.GetParent(treeList.SelectedObject));
_EntityID = _Entity.ID;
_Building = (Entities.RoomPicker_Building)treeList.GetParent(treeList.SelectedObject);
_BuildingID = _Building.ID;
_Room = (Entities.RoomPicker_Room)treeList.SelectedObject;
_RoomID = _Room.ID;
OnSelectionChanged(treeList, EventArgs.Empty);
}
}
//---------------------------------------------------------------------------------------------
// Show the Building Creation Form
//---------------------------------------------------------------------------------------------
private void ctxNewBuilding_Click(object sender, EventArgs e)
{
frmBuilding fDetail = new frmBuilding();
fDetail.ModuleID = this.ModuleID;
fDetail.Mode = GlobalVariables.EditMode.New;
if (treeList.SelectedObject is RoomPicker_Entity)
{
fDetail.PreSelectedEntity = ((Entities.RoomPicker_Entity)treeList.SelectedObject).ID;
}
if (treeList.SelectedObject is RoomPicker_Building)
{
fDetail.PreSelectedEntity = ((Entities.RoomPicker_Entity)treeList.GetParent(treeList.SelectedObject)).ID;
}
if (treeList.SelectedObject is RoomPicker_Room)
{
fDetail.PreSelectedEntity = ((Entities.RoomPicker_Entity)treeList.GetParent(treeList.GetParent(treeList.SelectedObject))).ID;
}
RoomPicker_Building _building = new RoomPicker_Building();
_building.SITE = _SiteCode;
fDetail.Entity = _building;
if (fDetail.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
treeList.RebuildAll(true);
treeList.Expand(treeList.SelectedObject);
if (_SelectNewAfterCreation)
{
this.SynchronizeWithBuilding(fDetail.Entity.ID);
}
}
}
public frmRoomList()
{
InitializeComponent();
colEntity.AspectGetter = delegate(object x)
{
RoomPicker_Building _building = BuildingList.Where(b => b.ID == ((RoomPicker_Room)x).FK_BUILDING).FirstOrDefault();
RoomPicker_Entity _entity = EntityList.Where(e => e.ID == _building.FK_ENTITY).FirstOrDefault();
return(_entity.CODE);
};
colBuilding.AspectGetter = delegate(object x)
{
RoomPicker_Building _building = BuildingList.Where(b => b.ID == ((RoomPicker_Room)x).FK_BUILDING).FirstOrDefault();
return(_building.CODE);
};
colAvailable.AspectGetter = delegate(object x)
{
return(((RoomPicker_Room)x).AVAILABLE);
};
colAvailable.Renderer = new MappedImageRenderer(new Object[] { true, imageList.Images["True"], false, imageList.Images["False"] });
}
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());
}
};
}
