public static CommonSelectionControl CreateSelectionControl (InformationenAddOn InfoAddOn,
TemplateElementManagement ConnectedTemplateElementManagement, TemplateManagement.AuswahlSelection EntriesToShow,
TemplateManagement.AuswahlSortOrder SortOrder)
{
CommonSelectionControl SelectionControl = new CommonSelectionControl ();
SelectionControl.InfoAddOn = InfoAddOn;
SelectionControl.ConnectedTemplateElementManagement = ConnectedTemplateElementManagement;
if (SelectionControl.Create (EntriesToShow, SortOrder) == false)
return null;
return SelectionControl;
}
public bool Create (TemplateManagement.AuswahlSelection EntriesToShow, TemplateManagement.AuswahlSortOrder SortOrder)
{
FireClick = false;
SelectionGrid.BeginInit ();
String BereichToUse = TemplateManagement.GetBereichToUse (InfoAddOn.ActuallBezeichner);
SelectionGrid.SelectionMode = DataGridSelectionMode.Single;
SelectionGrid.Tag = this;
SelectionGrid.Visibility = System.Windows.Visibility.Visible;
List<TemplateManagement.AuswahlSelection> MultipleAuswahlEntries = new List<TemplateManagement.AuswahlSelection>
{
TemplateManagement.AuswahlSelection.AllFromType,
TemplateManagement.AuswahlSelection.Used,
TemplateManagement.AuswahlSelection.My,
TemplateManagement.AuswahlSelection.All
};
TemplateManagement.AuswahlSortOrder SortOrderUsed = TemplateManagement.AuswahlSortOrder.Alphabetic;
if (SelectionData != null)
SelectionData.Clear ();
while (((SelectionData == null)
|| (SelectionData.Count == 0))
&& (MultipleAuswahlEntries.Count > 0))
{
if (MultipleAuswahlEntries.Contains (EntriesToShow))
MultipleAuswahlEntries.Remove (EntriesToShow);
else
{
EntriesToShow = MultipleAuswahlEntries [0];
MultipleAuswahlEntries.RemoveAt (0);
}
if (EntriesToShow == TemplateManagement.AuswahlSelection.All)
SortOrderUsed = TemplateManagement.AuswahlSortOrder.Alphabetic;
else
SortOrderUsed = SortOrder;
SelectionData = GetSelectionData (BereichToUse, TemplateManagement.CurrentUserName, InfoAddOn,
ConnectedTemplateElementManagement, EntriesToShow, SortOrderUsed);
if (SelectionData == null)
return false;
}
SelectionGrid.ItemsSource = SelectionData;
switch (EntriesToShow)
{
case TemplateManagement.AuswahlSelection.My:
if (SortOrderUsed == TemplateManagement.AuswahlSortOrder.Alphabetic)
MyEntriesOrderByAlphabet.IsChecked = true;
else
MyEntriesOrderByOccurence.IsChecked = true;
break;
case TemplateManagement.AuswahlSelection.AllFromType:
if (SortOrderUsed == TemplateManagement.AuswahlSortOrder.Alphabetic)
TypEntriesOrderByAlphabet.IsChecked = true;
else
TypEntriesOrderByOccurence.IsChecked = true;
break;
case TemplateManagement.AuswahlSelection.Used:
if (SortOrderUsed == TemplateManagement.AuswahlSortOrder.Alphabetic)
UsedEntriesOrderByAlphabet.IsChecked = true;
else
UsedEntriesOrderByOccurence.IsChecked = true;
break;
case TemplateManagement.AuswahlSelection.All:
AllEntriesOrderByAlphabet.IsChecked = true;
break;
}
SelectionGrid.EndInit ();
FireClick = true;
if (SelectionData == null)
return false;
if (SelectionData.Count == 0)
return false;
return true;
}
private List<SelectionDataClass> LoadMyOrUsedSelectionData (InformationenAddOn InfoAddOn, String BereichToUse,
TemplateManagement.AuswahlSelection EntriesToShow, TemplateManagement.AuswahlSortOrder SortOrder)
{
String SelectClause = String.Empty;
SelectClause = TemplateManagement.GetMyOrUsedUnifiedTableIDsSelectClause (InfoAddOn, EntriesToShow);
if (String.IsNullOrEmpty (SelectClause))
return new List<SelectionDataClass> ();
WCFStandards DataAccess = new WCFStandards ();
DataSet ResultDataSet = null;
if (SortOrder == TemplateManagement.AuswahlSortOrder.Alphabetic)
ResultDataSet = DataAccess.GetCommonDataSet ("Select " + String.Join (", ", ItemsToSelectForSelection)
+ " from " + ViewNameForSelection + " where ( "
+ TemplateManagement.GetWhereClauseFromBereich (BereichToUse) + " ) and "
+ SelectClause + " order by " + String.Join (", ", SortingItemsForSelection));
else
ResultDataSet = DataAccess.GetCommonDataSet ("Select " + String.Join (", ", ItemsToSelectForSelection)
+ " from " + ViewNameForSelection + " where ( "
+ TemplateManagement.GetWhereClauseFromBereich (BereichToUse) + " ) and "
+ SelectClause );
return GetSelectionDataFormatting (ResultDataSet.Tables [ViewNameForSelection]);
}
public List<SelectionDataClass> GetSelectionData(String BereichToUse, String ActiveUser, InformationenAddOn InfoAddOnParameter,
TemplateElementManagement ConnectedTemplateElementManagement, TemplateManagement.AuswahlSelection EntriesToShow,
TemplateManagement.AuswahlSortOrder SortOrder)
{
SortingItemsForSelection =
TemplateManagement.GetInterface [InfoAddOnParameter.Tabelle].GetSortingItemsForSelection ();
ItemsToSelectForSelection =
TemplateManagement.GetInterface [InfoAddOnParameter.Tabelle].GetItemsToSelectForSelection ();
ViewNameForSelection =
TemplateManagement.GetInterface [InfoAddOnParameter.Tabelle].GetViewNameForSelection ();
ItemsToFillHinweisColumn =
TemplateManagement.GetInterface [InfoAddOnParameter.Tabelle].GetItemsToFillHinweisColumn ();
if ((SortingItemsForSelection.Length == 0)
&& (ItemsToSelectForSelection.Length == 0)
&& (ItemsToFillHinweisColumn.Length == 0)
&& (String.IsNullOrEmpty (ViewNameForSelection)))
return null;
switch (EntriesToShow)
{
case TemplateManagement.AuswahlSelection.AllFromType:
{
return LoadTypeSelectionData (InfoAddOnParameter, BereichToUse,
ConnectedTemplateElementManagement.ParentTemplateRuntime.TypID, EntriesToShow, SortOrder);
}
break;
case TemplateManagement.AuswahlSelection.Used:
case TemplateManagement.AuswahlSelection.My:
{
return LoadMyOrUsedSelectionData (InfoAddOnParameter, BereichToUse, EntriesToShow, SortOrder);
}
break;
case TemplateManagement.AuswahlSelection.All:
{
return LoadAllSelectionData (InfoAddOnParameter, BereichToUse);
}
break;
}
return null;
}
public List<SelectionDataClass> GetSelectionData (String BereichToUse, String ActiveUser, InformationenAddOn InfoAddOnParameter,
TemplateElementManagement ConnectedTemplateElementManagement, TemplateManagement.AuswahlSelection EntriesToShow,
TemplateManagement.AuswahlSortOrder SortOrder)
{
AltErlaaInfoEntities WebAccess = new AltErlaaInfoEntities ();
IQueryable<Timings> TimingsDaten = from Tim in WebAccess.Timings
where Tim.ConnectedID == InfoAddOnParameter.InformationenID
orderby Tim.TimeA descending
select Tim;
List<SelectionDataClass> Result = new List<SelectionDataClass> ();
foreach (Timings SelectionEntry in TimingsDaten)
{
SelectionDataClass SelectionData = new SelectionDataClass ();
SelectionData.ID = SelectionEntry.TimingsID;
SelectionData.ZurAuswahl = FormatFreitext (SelectionEntry, FreiTextFormat.Full);
Result.Add (SelectionData);
}
return Result;
}
public DataCollection<SelectionDataClass> GetSelectionData(
TemplateManagement.AuswahlSelection EntriesToShow,
TemplateManagement.AuswahlSortOrder SortOrder)
{
if ((SortingItemsForSelection.Length == 0)
&& (ItemsToSelectForSelection.Length == 0)
&& (ItemsToFillHinweisColumn.Length == 0)
&& (String.IsNullOrEmpty(ViewNameForSelection)))
return null;
switch (EntriesToShow)
{
case TemplateManagement.AuswahlSelection.AllFromType:
{
if (TypeToProcess == null)
return null;
return LoadTypeSelectionData(EntriesToShow, SortOrder);
}
break;
case TemplateManagement.AuswahlSelection.Used:
case TemplateManagement.AuswahlSelection.My:
{
return LoadMyOrUsedSelectionData(EntriesToShow, SortOrder);
}
break;
case TemplateManagement.AuswahlSelection.All:
{
return LoadAllSelectionData();
}
break;
}
return null;
}
public CombinedSelectionAndSortOrderEnum GetFinalSelectionAndSortCriteria
(TemplateManagement.AuswahlSelection EntriesToShow, TemplateManagement.AuswahlSortOrder SortOrder)
{
switch (EntriesToShow)
{
case TemplateManagement.AuswahlSelection.My:
if (SortOrder == TemplateManagement.AuswahlSortOrder.Alphabetic)
return CombinedSelectionAndSortOrderEnum.MyEntriesOrderByAlphabet;
else
return CombinedSelectionAndSortOrderEnum.MyEntriesOrderByOccurence;
break;
case TemplateManagement.AuswahlSelection.AllFromType:
if (SortOrder == TemplateManagement.AuswahlSortOrder.Alphabetic)
return CombinedSelectionAndSortOrderEnum.TypEntriesOrderByAlphabet;
else
return CombinedSelectionAndSortOrderEnum.TypEntriesOrderByOccurence;
break;
case TemplateManagement.AuswahlSelection.Used:
if (SortOrder == TemplateManagement.AuswahlSortOrder.Alphabetic)
return CombinedSelectionAndSortOrderEnum.UsedEntriesOrderByAlphabet;
else
return CombinedSelectionAndSortOrderEnum.UsedEntriesOrderByOccurence;
break;
case TemplateManagement.AuswahlSelection.All:
return CombinedSelectionAndSortOrderEnum.AllEntriesOrderByAlphabet;
break;
}
return CombinedSelectionAndSortOrderEnum.AllEntriesOrderByAlphabet;
}
public bool Create(TemplateManagement.AuswahlSelection EntriesToShow, TemplateManagement.AuswahlSortOrder SortOrder)
{
TemplateManagement.AuswahlSortOrder SortOrderUsed = TemplateManagement.AuswahlSortOrder.Alphabetic;
if (SelectionData != null)
SelectionData.Clear();
while (((SelectionData == null)
|| (SelectionData.Count == 0))
&& (MultipleAuswahlEntries.Count > 0))
{
if (MultipleAuswahlEntries.Contains(EntriesToShow))
MultipleAuswahlEntries.Remove(EntriesToShow);
else
{
EntriesToShow = MultipleAuswahlEntries[0];
MultipleAuswahlEntries.RemoveAt(0);
}
if (EntriesToShow == TemplateManagement.AuswahlSelection.All)
SortOrderUsed = TemplateManagement.AuswahlSortOrder.Alphabetic;
else
SortOrderUsed = SortOrder;
SelectionData = GetSelectionData (EntriesToShow, SortOrderUsed);
if (SelectionData == null)
return false;
}
if (SelectionData == null)
return false;
if (SelectionData.Count == 0)
return false;
return true;
}