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; }