public ResponseObjectPackage<List<Control>> GetEventsbyControls(List<Control> controls)
{
List<Event> events = new List<Event>();
RequestObjectPackage<List<Control>> eventsRequest = new RequestObjectPackage<List<Control>>()
{
requestData = controls
};
List<EventModel> eventModels = new DBUtils().RunSqlAction(EventsRepository.GetByControlsList, eventsRequest).GetDataOrExceptionIfError();
RequestObjectPackage<List<EventModel>> actionsRequest = new RequestObjectPackage<List<EventModel>>()
{
requestData = eventModels
};
List<EventAction> actions = new DBUtils().RunSqlAction(new EventActionsCRUD().GetActionsByEventsList, actionsRequest).GetDataOrExceptionIfError();
RequestObjectPackage<List<EventAction>> paramsRequest = new RequestObjectPackage<List<EventAction>>()
{
requestData = actions
};
List<EventActionParameter> parameters = new DBUtils().RunSqlAction(new EventActionsCRUD().GetActionParametersByActionsList, paramsRequest).GetDataOrExceptionIfError();
List<ActionTypeProperty> properties = new DBUtils().RunSqlAction(new EventActionsCRUD().GetActionTypePropertiesByActionsList, paramsRequest).GetDataOrExceptionIfError();
foreach (EventAction action in actions)
{
action.parameters = parameters.Where(e => e.actionID == action.ID).ToList();
action.properties = properties.Where(e => e.actionTypeID == action.actionTypeID).ToList();
}
foreach (EventModel model in eventModels)
{
Event newEvent = new Event();
newEvent.ID = model.ID;
newEvent.eventTypeID = model.eventTypeID;
newEvent.controlID = model.controlID;
newEvent.actions = actions.Where(e => e.eventID == model.ID).ToList();
events.Add(newEvent);
}
foreach (Control control in controls)
{
control.events = events.Where(e => e.controlID == control.ID).ToList();
}
return new ResponseObjectPackage<List<Control>>() { resultData = controls };
}