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> 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 static int InsertPeople(People theClass)
{
if (theClass.OrganizationId <= 0)
{
throw new ArgumentException(Resources.Organization.MessageZeroOrganizationId);
}
PeopleTableAdapter localAdapter = new PeopleTableAdapter();
int? personId = 0;
string userName = HttpContext.Current.User.Identity.Name;
try
{
localAdapter.InsertPerson(userName, theClass.OrganizationId, theClass.AreaId, theClass.Name, theClass.Id, ref personId);
}
catch (Exception exc)
{
log.Error(Resources.People.MessageErrorCreatePerson, exc);
throw new Exception(Resources.People.MessageErrorCreatePerson);
}
if ((int)personId <= 0)
{
log.Error(Resources.People.MessageErrorCreatePerson);
throw new ArgumentException(Resources.People.MessageErrorCreatePerson);
}
return((int)personId);
}
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);
}
public static void DeletePermanently(int personId)
{
PeopleTableAdapter adapter = new PeopleTableAdapter();
try
{
adapter.DeletePermanentlyPerson(personId);
}
catch (Exception ex)
{
log.Error(Resources.People.MessageErrorDeletePerson, ex);
throw new Exception(Resources.People.MessageErrorDeletePerson);
}
}
public static void UpdatePeople(People theClass)
{
if (theClass.OrganizationId <= 0)
{
throw new ArgumentException(Resources.Organization.MessageZeroOrganizationId);
}
PeopleTableAdapter localAdapter = new PeopleTableAdapter();
try
{
localAdapter.UpdatePerson(theClass.PersonId, theClass.Id, theClass.Name, theClass.OrganizationId, theClass.AreaId);
}
catch (Exception exc)
{
log.Error(Resources.People.MessageErrorUpdatePerson, exc);
throw new Exception(Resources.People.MessageErrorUpdatePerson);
}
}
public static void DeletePeople(int personId)
{
if (personId <= 0)
{
throw new ArgumentException(Resources.People.MessageIdPersonZero);
}
PeopleTableAdapter localAdapter = new PeopleTableAdapter();
string userName = HttpContext.Current.User.Identity.Name;
try
{
localAdapter.DeletePerson(personId, userName);
}
catch (Exception exc)
{
log.Error(Resources.People.MessageErrorDeletePerson, exc);
throw new Exception(Resources.People.MessageErrorDeletePerson);
}
}
