public static List <People> GetPeopleForAutocomplete(int organizationId, int areaId, string filter)
{
string userName = HttpContext.Current.User.Identity.Name;
List <People> theList = new List <People>();
People theData = null;
try
{
PeopleTableAdapter localAdapter = new PeopleTableAdapter();
PeopleDS.PeopleDataTable theTable = localAdapter.GetPeopleForAutocomplete(userName, organizationId, areaId, filter);
if (theTable != null && theTable.Rows.Count > 0)
{
foreach (PeopleDS.PeopleRow theRow in theTable)
{
theData = FillRecord(theRow);
theList.Add(theData);
}
}
}
catch (Exception exc)
{
throw exc;
}
return(theList);
}
public List <People> GetPeopleByOrganization(int organizationId)
{
if (organizationId <= 0)
{
throw new ArgumentException(Resources.Organization.MessageZeroOrganizationId);
}
string userName = HttpContext.Current.User.Identity.Name;
List <People> theList = new List <People>();
People theData = null;
try
{
PeopleDS.PeopleDataTable theTable = theAdapter.GetPersonByOrganization(organizationId, userName);
if (theTable != null && theTable.Rows.Count > 0)
{
foreach (PeopleDS.PeopleRow theRow in theTable)
{
theData = FillRecord(theRow);
theList.Add(theData);
}
}
}
catch (Exception exc)
{
log.Error("Error en GetPeopleByOrganization para organizationId: " + organizationId.ToString() + " y userName: " + userName, exc);
throw new ArgumentException(Resources.DataDetails.MessageErrorPeopleByOrganization);
}
return(theList);
}
public static People GetPeopleById(int personId)
{
if (personId <= 0)
{
throw new ArgumentException(Resources.Organization.MessageZeroAreaId);
}
People theData = null;
try
{
PeopleTableAdapter localAdapter = new PeopleTableAdapter();
PeopleDS.PeopleDataTable theTable = localAdapter.GetPersonById(personId);
if (theTable != null && theTable.Rows.Count > 0)
{
PeopleDS.PeopleRow theRow = theTable[0];
theData = FillRecord(theRow);
}
}
catch (Exception exc)
{
log.Error("Ocurrió un error mientras se obtenía la persona de id: " + personId, exc);
throw exc;
}
return(theData);
}
public static List <People> GetPeopleBySearch(string whereClause)
{
if (string.IsNullOrEmpty(whereClause))
{
whereClause = "1=1";
}
string userName = HttpContext.Current.User.Identity.Name;
List <People> theList = new List <People>();
People theData = null;
try
{
PeopleTableAdapter localAdapter = new PeopleTableAdapter();
PeopleDS.PeopleDataTable theTable = localAdapter.GetPeopleBySearch(userName, whereClause);
if (theTable != null && theTable.Rows.Count > 0)
{
foreach (PeopleDS.PeopleRow theRow in theTable)
{
theData = FillRecord(theRow);
theList.Add(theData);
}
}
}
catch (Exception exc)
{
log.Error("Error to obtain the people by search.");
throw exc;
}
return(theList);
}
