using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using System.Collections.Generic;

/// <summary>
/// Page for retrieving user information on the account page
/// </summary>
public partial class ACCOUNTS_profilePage : System.Web.UI.Page
{
    DataTable memberTable = new DataTable();
    MemberObject newMember = new MemberObject();
    DataTable wishlistTable = new DataTable();
    DataTable wishlistContentsTable = new DataTable();
    OrderObject newWishlist = new OrderObject();
    DataTable userIdTable = new DataTable();
    OrderObject newOrder = new OrderObject();


    /// <summary>
    /// Load user info and populate all controls
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Init(object sender, EventArgs e)
    {
        if (txtPhoneNumber.Text == "")
        {
            txtPhoneNumber.Text = null;
        }

        lblUserName.Text = LoginName1.Page.User.Identity.Name;

        RUFBaseSite master = (RUFBaseSite)Page.Master;
        string userNameLabel = Request.QueryString["userName"];
        master.setCurrentUser(userNameLabel);

        if (userNameLabel == "")
        {
            Response.Redirect("~/Login.aspx");
        }

        Label userLabel = (Label)master.FindControl("lblCurrentUser");
        string userLabelText = userLabel.Text;

        memberTable = PersonDAL.GetPersonInfo(userLabelText);
        DataRow memberRow = memberTable.Rows[0];

        lblUserName.Text = memberRow.Field<string>("Username");
        txtEmail.Text = memberRow.Field<string>("Email");
        txtFirstName.Text = memberRow.Field<string>("FirstName");
        txtLastName.Text = memberRow.Field<string>("LastName");
        rbGender.SelectedValue = memberRow.Field<string>("Gender");
        txtAddress.Text = memberRow.Field<string>("Address");
        txtPhoneNumber.Text = memberRow.Field<string>("PhoneNumber");
        txtBirthDate.Text = memberRow.Field<string>("DOB");
        txtPostalCode.Text = memberRow.Field<string>("PostalCode");
        txtCity.Text = memberRow.Field<string>("City");
        ddProvince.SelectedValue = memberRow.Field<string>("Province");

        if (memberRow.Field<string>("newsletter") == "1")
        {
            rbReceivePromotionalEmails.SelectedValue = "1";
        }
        else
        {
            rbReceivePromotionalEmails.SelectedValue = "2";
        }

        if (!IsPostBack)
        {
            //memberTable = PersonDAL.GetPersonInfo(lblUserName.Text);
            //DataRow memberRow = memberTable.Rows[0];

            txtEmail.Text = memberRow.Field<string>("Email");
            txtFirstName.Text = memberRow.Field<string>("FirstName");
            txtLastName.Text = memberRow.Field<string>("LastName");
            rbGender.SelectedValue = memberRow.Field<string>("Gender");
            txtAddress.Text = memberRow.Field<string>("Address");
            txtPhoneNumber.Text = memberRow.Field<string>("PhoneNumber");
            txtBirthDate.Text = memberRow.Field<string>("DOB");
            txtPostalCode.Text = memberRow.Field<string>("PostalCode");
            txtCity.Text = memberRow.Field<string>("City");
            ddProvince.SelectedValue = memberRow.Field<string>("Province");

            if (rbReceivePromotionalEmails.SelectedValue == "1")
            {
                rbReceivePromotionalEmails.SelectedValue = "1";
            }
            else
            {
                rbReceivePromotionalEmails.SelectedValue = "2";
            }
        }

    }

    // on each return to server:
    // - clear error messages
    protected void Page_Load(object sender, EventArgs e)
    {
        lblMessage.Text = "";
    }

    protected void UpdateProfile(object sender, EventArgs e)
    {
        //RUFBaseSite master = (RUFBaseSite)Page.Master;
        //string userNameLabel = Request.QueryString["userName"];
        //master.setCurrentUser(userNameLabel);

        if (rbReceivePromotionalEmails.SelectedValue == "1")
        {
            rbReceivePromotionalEmails.SelectedValue = "1";
        }
        else
        {
            rbReceivePromotionalEmails.SelectedValue = "2";
        }

        string userId = "";

        userIdTable = PersonDAL.GetMembershipInfo(lblUserName.Text);
        DataRow userIdRow = userIdTable.Rows[0];
        userId = Convert.ToString(userIdRow.Field<Guid>("UserId"));

        newMember.userName = lblUserName.Text;
        newMember.email = txtEmail.Text;
        newMember.first = txtFirstName.Text;
        newMember.last = txtLastName.Text;
        newMember.gender = rbGender.SelectedValue;
        newMember.address = txtAddress.Text;
        newMember.phoneNumber = txtPhoneNumber.Text;
        newMember.birthDate = txtBirthDate.Text;
        newMember.postalCode = txtPostalCode.Text;
        newMember.city = txtCity.Text;
        newMember.province = ddProvince.SelectedValue;
        newMember.newsletter = rbReceivePromotionalEmails.SelectedValue;
        newMember.lowerEmail = txtEmail.Text.ToLower();
        newMember.membershipId = userId;

        PersonDAL.UpdatePerson(newMember);
        PersonDAL.UpdateMembership(newMember);
        //Response.Redirect("~/ACCOUNTS/profilePage.aspx");
        Response.Redirect("~/ACCOUNTS/profilePage.aspx?userName=" + lblUserName.Text);
        //Response.Redirect("~/Home.aspx");
    }


    protected void btnRemoveAccount_Click(object sender, EventArgs e)
    {
        RUFBaseSite master = (RUFBaseSite)Page.Master;
        string userNameLabel = Request.QueryString["userName"];
        master.setCurrentUser(userNameLabel);

        Label userLabel = (Label)master.FindControl("lblCurrentUser");
        string userLabelText = userLabel.Text;

        memberTable = PersonDAL.GetPersonInfo(userLabelText);
        DataRow memberRow = memberTable.Rows[0];

        //memberTable = PersonDAL.DeletePerson(userLabelText);
        string userName = lblUserName.Text;
        newMember.userName = lblUserName.Text;
        newMember.email = txtEmail.Text;
        newMember.first = txtFirstName.Text;
        newMember.last = txtLastName.Text;
        newMember.gender = rbGender.SelectedValue;
        newMember.address = txtAddress.Text;
        newMember.phoneNumber = txtPhoneNumber.Text;
        newMember.birthDate = txtBirthDate.Text;
        newMember.postalCode = txtPostalCode.Text;
        newMember.city = txtCity.Text;
        newMember.province = ddProvince.SelectedValue;
        newMember.newsletter = rbReceivePromotionalEmails.SelectedValue;



        wishlistTable = OrderDAL.GetWishlist(Session["userName"].ToString());
        if (wishlistTable.Rows.Count == 0)
        {
            string userId = "";

            userIdTable = PersonDAL.GetMembershipInfo(userName);
            DataRow userIdRow = userIdTable.Rows[0];

            userId = Convert.ToString(userIdRow.Field<Guid>("UserId"));

            PersonDAL.DeleteUserRole(userId);
            PersonDAL.DeletePerson(userName);
            PersonDAL.DeleteMembership(userId);
            PersonDAL.DeleteUser(userId);

            Membership.DeleteUser(lblUserName.Text, true);
            FormsAuthentication.SignOut();
            Response.Redirect("~/ACCOUNTS/profilePageDeletedComplete.aspx");
        }
        else
        {
            DataRow wishListRow = wishlistTable.Rows[0];
            int wishListId = wishListRow.Field<int>("WishlistId");
            newWishlist.wishlistId = wishListId;
            newWishlist.itemId = Convert.ToInt32(wishListId);

            wishlistContentsTable = OrderDAL.GetWishlistContents(wishListId);

            if (wishlistContentsTable.Rows.Count == 0)
            {
                OrderDAL.RemoveWishList(newWishlist);

                string userId = "";

                userIdTable = PersonDAL.GetMembershipInfo(userName);
                DataRow userIdRow = userIdTable.Rows[0];

                userId = Convert.ToString(userIdRow.Field<Guid>("UserId"));

                PersonDAL.DeleteUserRole(userId);
                PersonDAL.DeletePerson(userName);
                PersonDAL.DeleteMembership(userId);
                PersonDAL.DeleteUser(userId);

                Membership.DeleteUser(lblUserName.Text, true);
                FormsAuthentication.SignOut();
                Response.Redirect("~/ACCOUNTS/profilePageDeletedComplete.aspx");
            }
            else
            {
                OrderDAL.RemoveWishListItems(newWishlist);
                OrderDAL.RemoveWishList(newWishlist);

                string userId = "";

                userIdTable = PersonDAL.GetMembershipInfo(userName);
                DataRow userIdRow = userIdTable.Rows[0];

                userId = Convert.ToString(userIdRow.Field<Guid>("UserId"));

                PersonDAL.DeleteUserRole(userId);
                PersonDAL.DeletePerson(userName);
                PersonDAL.DeleteMembership(userId);
                PersonDAL.DeleteUser(userId);

                Membership.DeleteUser(lblUserName.Text, true);
                FormsAuthentication.SignOut();
                Response.Redirect("~/ACCOUNTS/profilePageDeletedComplete.aspx");
            }
        }
    }
}














    /// <summary>
    /// Update records from the person table
    /// </summary>
    /// <param name="newMember"></param>
    public static void UpdateMembership(MemberObject newMember)
    {
        string sql = String.Format(
            "UPDATE aspnet_Membership SET Email='{1}', LoweredEmail='{2}' WHERE UserId ='{0}'",
             newMember.membershipId, newMember.email, newMember.lowerEmail);

        SqlCommand membershipCommand = new SqlCommand(sql, RUFConnection);

        try
        {
            RUFConnection.Open();
            membershipCommand.ExecuteNonQuery();
        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            RUFConnection.Close();
        }
    }













using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
/// Summary description for MemberObject
/// </summary>
public class MemberObject
{
    public int userId;
    public string userName;
    public string password;
    public string email;
    public string first;
    public string last;
    public string gender;
    public string address;
    public string phoneNumber;
    public string birthDate;
    public string postalCode;
    public string city;
    public string province;
    public string newsletter;
    public DateTime joinDate;
    public string lowerEmail;
    public string membershipId;

    public void setUserId(int userId)
    {
        this.userId = userId;
    }

    public void setUserName(string userName)
    {
        this.userName = userName;
    }

    public void setPassword(string password)
    {
        this.password = password;
    }

    public void setEmail(string email)
    {
        this.email = email;
    }

    public void setFirstName(string first)
    {
        this.first = first;
    }

    public void setLastName(string last)
    {
        this.last = last;
    }

    public void setGender(string gender)
    {
        this.gender = gender;
    }

    public void setAddress(string address)
    {
        this.address = address;
    }

    public void setPhoneNumber(string phoneNumber)
    {
        this.phoneNumber = phoneNumber;
    }

    public void setBirthDate(string birthDate)
    {
        this.birthDate = birthDate;
    }

    public void setPostalCode(string postalCode)
    {
        this.postalCode = postalCode;
    }

    public void setCity(string city)
    {
        this.city = city;
    }

    public void setProvince(string province)
    {
        this.province = province;
    }

    public void setNewsletter(string newsletter)
    {
        this.newsletter = newsletter;
    }

    public void setJoinDate(DateTime joinDate)
    {
        this.joinDate = joinDate;
    }

    public void setLowerEmail(string lowerEmail)
    {
        this.lowerEmail = lowerEmail;
    }

    public void setMembershipId(string membershipId)
    {
        this.membershipId = membershipId;
    }
}