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);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!FoundSystemAdmin())
{
MembershipCreateStatus outstatus;
MembershipUser newUser = Membership.CreateUser(AdminName, AdminPW, AdminEmail, PWQuestion, PWAnswer, true, out outstatus);
if (!Roles.RoleExists(AdminRole))
{
Roles.CreateRole(AdminRole);
}
Roles.AddUserToRole(AdminName, AdminRole);
string strUser_ID = newUser.ProviderUserKey.ToString();
Guid newUserId = new Guid(strUser_ID);
//Guid newUserId = (Guid)newUser.ProviderUserKey;
Addresses address = new Addresses();
address.Address_1 = "Grasmere";
address.Address_2 = "Findon Road";
address.Address_Town = "Findon";
address.Address_City = string.Empty;
address.Address_County = "West Sussex";
address.Address_Postcode = "BN14 0RD";
Guid? address_ID = (Guid?)address.Insert_Address(newUserId);
if (address_ID != null)
{
People person = new People();
person.Person_Forename = "Daren";
person.Person_Surname = "Cantrell";
person.Address_ID = address_ID;
person.Person_Mobile = "07880 883089";
person.Person_Landline = "01903 877336";
person.Person_Email = AdminEmail;
Guid? person_ID = person.Insert_Person(newUserId);
if (person_ID != null)
{
UserPerson userPerson = new UserPerson();
userPerson.User_ID = newUserId;
userPerson.Person_ID = (Guid)person_ID;
Guid? user_Person_ID = userPerson.Insert_User_Person(newUserId);
}
}
RunOnceMessage.Text = string.Format("System Admin setup correctly {0}", "");
}
else
RunOnceMessage.Text = string.Format("System Admin already setup {0}", "");
}
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;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(User_Person_ID))
{
MembershipUser userInfo = Membership.GetUser();
Guid user_ID = (Guid)userInfo.ProviderUserKey;
Guid person_ID = new Guid(Person_ID);
Guid user_Person_ID = new Guid(User_Person_ID);
UserPerson userPerson = new UserPerson(user_Person_ID);
if (userPerson.Person_ID.ToString() != Person_ID)
{
userPerson.User_ID = user_ID;
userPerson.Person_ID = person_ID;
bool success = userPerson.Update_User_Person(user_Person_ID, user_ID);
if (success)
MessageLabel.Text = "Updated Successfully.";
}
else
{
MessageLabel.Text = "No changes made. - Update cancelled.";
}
}
else
{
MembershipUser userInfo = Membership.GetUser();
Guid user_ID = (Guid)userInfo.ProviderUserKey;
Guid person_ID = new Guid(Person_ID);
UserPerson userPerson = new UserPerson();
userPerson.User_ID = user_ID;
userPerson.Person_ID = person_ID;
Guid? user_Person_ID = userPerson.Insert_User_Person(user_ID);
if (user_Person_ID != null)
{
User_Person_ID = user_Person_ID.ToString();
MessageLabel.Text = "Added Successfully.";
StoreCommon();
divUpdateDetails.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
MessageLabel.Text = string.Empty;
GetCommon();
if (!Page.IsPostBack)
{
Guid person_ID;
if (!string.IsNullOrEmpty(User_Person_ID))
{
divUpdateDetails.Visible = false;
}
else
{
MembershipUser userInfo = Membership.GetUser();
Guid user_ID = (Guid)userInfo.ProviderUserKey;
UserPerson userPerson = new UserPerson();
List<UserPerson> lnkUserPerson;
lnkUserPerson = userPerson.GetUser_PersonByUser_ID(user_ID);
if (lnkUserPerson.Count > 0)
{
Guid? user_Person_ID = (Guid?)lnkUserPerson[0].User_Person_ID;
Guid? newPerson_ID = (Guid?)lnkUserPerson[0].Person_ID;
if (user_Person_ID != null)
{
User_Person_ID = user_Person_ID.ToString();
Common.User_Person_ID = User_Person_ID;
}
if (newPerson_ID != null)
{
Person_ID = newPerson_ID.ToString();
Common.New_User_ID = Person_ID;
}
divUpdateDetails.Visible = false;
}
}
if (!string.IsNullOrEmpty(Person_ID))
{
person_ID = new Guid(Person_ID);
PopulatePerson(person_ID);
}
else
{
string returnChars = Common.AppendReturnChars(Request.QueryString, "upi");
Server.Transfer("~/ShowAdmin/PersonSetup.aspx?" + returnChars + "&p=nu");
}
}
}