public virtual OrganisationContainer SelectChildrenByFormOfOrganisation(DBString IDVal)
{
TraceCallEnterEvent.Raise();
try
{
OrganisationContainer result;
DataSet entitySet = m_DataContext.ndihdFormOfOrganisationSelectBy(IDVal);
result = new OrganisationContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
/// <summary>
/// Fill datagrid with data
/// </summary>
private void FillDatagridOrg(DBGuid OrganisationID)
{
try
{
string sSortColumn = "Name";
int nSelectedRow = -1;
// Storing the previous sort order
if (dtgOrg.DataSource != null)
{
sSortColumn = ((DataTable) dtgOrg.DataSource).DefaultView.Sort;
}
if (m_allDataOrg == null)
{
// Retrieving Organisations
// Set filter
Organisation filter = new Organisation(Guid.Empty);
filter.FilterOnIsactive = DBInt.Null;
filter.FilterOnIsactive = 1;
filter.IsActive = true;
// Retrieving data from BusinessServices
IOrganisationService srv = ServiceFactory.GetOrganisationService();
m_allDataOrg = srv.OrganisationSelectFiltered(filter);
// Retrieving ProgramPartners
DBGuid ProgramID = new DBGuid(new Guid(m_sCurrentID));
IProgramService srvP = ServiceFactory.GetProgramService();
ProgramPartnerContainer allDataP = srvP.SelectChildrenByPartnerProgram(ProgramID);
// Hide selected Organisation items
for (int i = 0; i < allDataP.All.Count; i++)
{
DBGuid OrganisationRef = ((ProgramPartner) allDataP.All.Items[i]).OrganisationRef;
Organisation selected = (Organisation) m_allDataOrg[OrganisationRef.ToString()];
if (selected != null)
{
m_allDataOrg.Delete(selected);
}
}
}
// Fill organisation grid
DataTable dt = m_allDataOrg.CurrentAsDatatable;
dt.DefaultView.Sort = sSortColumn;
dtgOrg.DataSource = dt;
// Fill organisation "detail" grid
DataTable dtDetail = m_allDataOrg.DeletedAsDatatable;
dtDetail.DefaultView.Sort = sSortColumn;
dtgOrgDetail.DataSource = dtDetail;
// Locates the row specified by ID param
if (!OrganisationID.IsNull)
{
BindingManagerBase bm = dtgOrg.BindingContext[dtgOrg.DataSource, dtgOrg.DataMember];
int nPositionStart = bm.Position;
DataRow dr;
for (int i = 0; i < bm.Count; i++)
{
dr = ((DataRowView) bm.Current).Row;
if (OrganisationID.Value.Equals(dr["ID"]))
{
nSelectedRow = i;
break;
}
bm.Position += 1;
}
bm.Position = nPositionStart;
}
// Makes the row selected
if (nSelectedRow <= ((DataTable) dtgOrg.DataSource).DefaultView.Count && nSelectedRow > -1)
{
dtgOrg.Select(nSelectedRow);
dtgOrg.CurrentRowIndex = nSelectedRow;
}
else if (((DataTable) dtgOrg.DataSource).DefaultView.Count != 0)
{
dtgOrg.Select(0);
}
// Enabling or disabling the buttons according to record count.
// And is because of previous disable state.
bool bIsEmptyGrid = (((DataTable) dtgOrg.DataSource).DefaultView.Count == 0);
btnAddOrganisation.Enabled = ! bIsEmptyGrid;
btnDetailOrganisation.Enabled = ! bIsEmptyGrid;
bIsEmptyGrid = (((DataTable) dtgOrgDetail.DataSource).DefaultView.Count == 0);
btnRemoveOrganisation.Enabled = ! bIsEmptyGrid;
}
catch (Exception ex)
{
// --- Log exception
ExceptionManager.Publish(ex);
// --- Display Exception
ErrorHandler.DisplayError("Nem várt hiba lépett fel a szervezet lista frissítése során.", ex);
}
}
public OrganisationContainer OrganisationSelectFiltered(Organisation filter)
{
TraceCallEnterEvent.Raise();
try
{
DBInt ActivityPrevention = DBInt.Null;
if (filter.ActivityPrevention) ActivityPrevention = 1;
DBInt ActivityResearch = DBInt.Null;
if (filter.ActivityResearch) ActivityResearch = 1;
DBInt ActivityRehabilitation = DBInt.Null;
if (filter.ActivityRehabilitation) ActivityRehabilitation = 1;
DBInt ActivityOther = DBInt.Null;
if (filter.ActivityOther) ActivityOther = 1;
DBInt ActivityCoord = DBInt.Null;
if (filter.FilterOnIsKef != DBInt.Null) ActivityCoord = filter.FilterOnIsKef;
OrganisationContainer result;
DataSet entitySet = m_DataContext.ndihdOrganisationSelectFiltered(
filter.Name,
filter.RegionRef,
filter.OrganisationFormRef,
ActivityPrevention,
ActivityResearch,
ActivityRehabilitation,
ActivityOther,
filter.FilterOnIsactive,
filter.FilterOnIsKef,
filter.ValidationState);
result = new OrganisationContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public OrganisationContainer OrganisationSelectKefListFilteredByRegCode(string RegCode, bool IsActive,
bool ActivityCoord, bool IsKef)
{
TraceCallEnterEvent.Raise();
try
{
OrganisationContainer result;
DataSet entitySet = m_DataContext.ndihdOrganisationSelectKefListFilteredByRegCode(RegCode, IsActive, IsKef);
result = new OrganisationContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual OrganisationContainer OrganisationSelectAll()
{
TraceCallEnterEvent.Raise();
try
{
OrganisationContainer result;
DataSet entitySet = m_DataContext.ndihdOrganisationSelectAll();
result = new OrganisationContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
