public List <UserPerson> GetUser_PersonByPerson_ID(Guid person_ID)
{
List <UserPerson> retVal = new List <UserPerson>();
try
{
UserPersonBL person = new UserPersonBL(_connString);
lnkUserPerson = person.GetUser_PersonByPerson_ID(person_ID);
if (lnkUserPerson != null && lnkUserPerson.Rows.Count > 0)
{
foreach (DataRow row in lnkUserPerson.Rows)
{
UserPerson userPerson = new UserPerson(_connString, Utils.DBNullToGuid(row["User_Person_ID"]));
retVal.Add(userPerson);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public UserPerson(Guid user_Person_ID)
{
UserPersonBL userPerson = new UserPersonBL();
lnkUserPerson = userPerson.GetUser_PersonByUser_Person_ID(user_Person_ID);
User_Person_ID = user_Person_ID;
User_ID = lnkUserPerson[0].User_ID;
Person_ID = lnkUserPerson[0].Person_ID;
}
public bool Update_User_Person(Guid original_ID, Guid userID)
{
bool retVal = false;
try
{
UserPersonBL userPerson = new UserPersonBL(_connString);
retVal = userPerson.Update_User_Person(original_ID, User_ID, Person_ID, DeleteUserPerson, userID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public Guid?Insert_User_Person(Guid userID)
{
Guid?retVal = null;
try
{
UserPersonBL userPerson = new UserPersonBL(_connString);
retVal = (Guid?)userPerson.Insert_User_Person(_user_ID, _person_ID, userID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public List<UserPerson> GetUser_PersonByPerson_ID(Guid person_ID)
{
List<UserPerson> userPersonList = new List<UserPerson>();
UserPersonBL person = new UserPersonBL();
lnkUserPerson = person.GetUser_PersonByUser_Person_ID(person_ID);
if (lnkUserPerson != null && lnkUserPerson.Count > 0)
{
foreach (sss.lnkUser_PersonRow row in lnkUserPerson)
{
UserPerson userPerson = new UserPerson(row.User_Person_ID);
userPersonList.Add(userPerson);
}
}
return userPersonList;
}
public UserPerson(string connString, Guid user_Person_ID)
{
_connString = connString;
try
{
UserPersonBL userPerson = new UserPersonBL(_connString);
lnkUserPerson = userPerson.GetUser_PersonByUser_Person_ID(user_Person_ID);
DataRow row = lnkUserPerson.Rows[0];
_user_Person_ID = user_Person_ID;
_user_ID = Utils.DBNullToGuid(row["User_ID"]);
_person_ID = Utils.DBNullToGuid(row["Person_ID"]);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update_User_Person(Guid original_ID, Guid userID)
{
bool success = false;
UserPersonBL userPerson = new UserPersonBL();
success = userPerson.Update_User_Person(original_ID, User_ID, Person_ID, DeleteUserPerson, userID);
return success;
}
public Guid? Insert_User_Person(Guid userID)
{
UserPersonBL userPerson = new UserPersonBL();
Guid? newID = (Guid?)userPerson.Insert_User_Person(User_ID, Person_ID, userID);
return newID;
}