public static List <KPICategoyCombination> GetCategoryItemsCombinatedByKpiId(int kpiId)
{
if (kpiId <= 0)
{
throw new ArgumentException("El ID del KPI no puede ser cero.");
}
List <KPICategoyCombination> theList = new List <KPICategoyCombination>();
KPICategoyCombination theData = null;
try
{
KPICombinationCategoryTableAdapter localAdapter = new KPICombinationCategoryTableAdapter();
KPICategoryCombinationDS.KPICombinationCategoryDataTable theTable = localAdapter.GetCategoryItemsCombinatedByKpiId(kpiId);
if (theTable != null && theTable.Rows.Count > 0)
{
foreach (KPICategoryCombinationDS.KPICombinationCategoryRow theRow in theTable)
{
theData = FillRecord(theRow);
theData.KpiId = kpiId;
theList.Add(theData);
}
}
}
catch (Exception exc)
{
log.Error("Error en GetCategoryItemsCombinatedByKpiId para kpiId: " + kpiId, exc);
throw exc;
}
return(theList);
}
public static List <KPICategoyCombination> GetKPITargetCategoriesByKpiId(List <Category> theCategories)
{
if (theCategories == null || theCategories.Count <= 0)
{
throw new ArgumentException("No se tiene la lista de categorias.");
}
string categories = "";
foreach (Category cat in theCategories)
{
categories = string.IsNullOrEmpty(categories) ? cat.ID : categories + "," + cat.ID;
}
List <KPICategoyCombination> theList = new List <KPICategoyCombination>();
KPICategoyCombination theData = null;
try
{
KPICombinationCategoryTableAdapter localAdapter = new KPICombinationCategoryTableAdapter();
KPICategoryCombinationDS.KPICombinationCategoryDataTable theTable = localAdapter.GetCombinationCategoryItems(categories);
if (theTable != null && theTable.Rows.Count > 0)
{
foreach (KPICategoryCombinationDS.KPICombinationCategoryRow theRow in theTable)
{
theData = FillRecord(theRow);
theList.Add(theData);
}
}
}
catch (Exception exc)
{
log.Error("Error en GetKPITargetCategoriesByKpiId.", exc);
throw exc;
}
return(theList);
}