public List <KPI> GetKPIsByPerson(int personId) { if (personId <= 0) { throw new ArgumentException("The code of person cannot be zero."); } string userName = HttpContext.Current.User.Identity.Name; int firstDayOfWeek = Artexacta.App.Configuration.Configuration.GetFirstDayOfWeek(); List <KPI> theList = new List <KPI>(); KPI theData = null; try { KPIDS.KPIDataTable theTable = theAdapter.GetKPIsByPerson(personId, userName, firstDayOfWeek); if (theTable != null && theTable.Rows.Count > 0) { foreach (KPIDS.KPIRow theRow in theTable) { theData = FillRecord(theRow); theList.Add(theData); } } } catch (Exception exc) { log.Error("Error en GetKPIsByPerson para personId: " + personId.ToString() + " y userName: " + userName, exc); throw new ArgumentException(Resources.DataDetails.MessageErrorKpisByPerson); } return(theList); }
public static KPI GetKPIById(int kpiId) { if (kpiId <= 0) { throw new ArgumentException(Resources.Organization.MessageZeroAreaId); } KPI theData = null; try { KPITableAdapter localAdapter = new KPITableAdapter(); KPIDS.KPIDataTable theTable = localAdapter.GetKPIById(kpiId); if (theTable != null && theTable.Rows.Count > 0) { KPIDS.KPIRow theRow = theTable[0]; theData = FillRecord(theRow); } } catch (Exception exc) { log.Error(Resources.Kpi.MessageErrorKpiInformation + " KpiId: " + kpiId, exc); throw new Exception(Resources.Kpi.MessageErrorKpiInformation); } return(theData); }
public List <KPI> GetKPIsBySearch(string whereClause) { if (string.IsNullOrEmpty(whereClause)) { whereClause = "1=1"; } List <KPI> theList = new List <KPI>(); KPI theData = null; string username = HttpContext.Current.User.Identity.Name.ToString(); int firstDayOfWeek = Artexacta.App.Configuration.Configuration.GetFirstDayOfWeek(); try { KPIDS.KPIDataTable theTable = theAdapter.GetKPIBySearch(username, whereClause, firstDayOfWeek); if (theTable != null && theTable.Rows.Count > 0) { foreach (KPIDS.KPIRow theRow in theTable) { theData = FillRecord(theRow); theList.Add(theData); } } } catch (Exception exc) { log.Error(Resources.Kpi.MessageErrorKPIList + " by search.", exc); throw new Exception(Resources.Kpi.MessageErrorKPIList); } return(theList); }