public class User
{
    string connStr = ConfigurationManager.ConnectionStrings["FoodJunkiesDataBase"].ConnectionString;
    private string _custID = null;
    private string _email = string.Empty;
    private string _password = null;
    private string _fname = "";
    private string _lname = null;
    private string _postalCode = string.Empty;
    private string _addr = "";
    private string _unitNo = null;
    private string _ctryCode = null;
    private string _hp = null;

    public User()
    {

    }

    public User(string custID, string fname, string lname, string email, string password, string hp)
    {
        _custID = custID;
        _email = email;
        _password = password;
        _fname = fname;
        _lname = lname;
        _hp = hp;
    }

    public User(string fname, string lname, string email, string password, string hp)
        : this(null, fname, lname, email, password, hp)
    {

    }

    public User(string custID)
        : this(custID, "", "", "", "", "")
    {

    }

    public string CustId
    {
        get { return _custID; }
        set { _custID = value; }
    }
    public string CustEmail
    {
        get { return _email; }
        set { _email = value; }
    }
    public string CustPassword
    {
        get { return _password; }
        set { _password = value; }
    }
    public string CustFirstName
    {
        get { return _fname; }
        set { _fname = value; }
    }
    public string CustLastName
    {
        get { return _lname; }
        set { _lname = value; }
    }
    public string CustPostalCode
    {
        get { return _postalCode; }
        set { _postalCode = value; }
    }
    public string CustAddress
    {
        get { return _addr; }
        set { _addr = value; }
    }
    public string CustUnitNo
    {
        get { return _unitNo; }
        set { _unitNo = value; }
    }
    public string CustCountryCode
    {
        get { return _ctryCode; }
        set { _ctryCode = value; }
    }
    public string CustPhone
    {
        get { return _hp; }
        set { _hp = value; }
    }

    //Get all user account
    public List<User> getUserAll()
    {
        List<User> userList = new List<User>();
        string cust_ID, first_Name, last_Name, cust_Email, cust_Password, cust_Phone;
        string queryStr = "SELECT CustId, CustFirstName, CustLastName, CustEmail, CustPassword, CustPhone FROM CustomerData Order By CustId";
        SqlConnection conn = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand(queryStr, conn);
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader();

        while (dr.Read())
        {
            cust_ID = dr["CustId"].ToString();
            first_Name = dr["CustFirstName"].ToString();
            last_Name = dr["CustLastName"].ToString();
            cust_Email = dr["CustEmail"].ToString();
            cust_Password = dr["CustPassword"].ToString();
            cust_Phone = dr["CustPhone"].ToString();
            User u = new User(cust_ID, first_Name, last_Name, cust_Email, cust_Password, cust_Phone);
            userList.Add(u);
        }
        conn.Close();
        dr.Close();
        dr.Dispose();
        return userList;
    }

    //Update user account
    public int UserUpdate(string custID, string fname, string lname, string email, string password, string hp)
    {
        string queryStr = "UPDATE CutomerData SET" +
            "CustFirstName = @fname, " +
            "CustLastName = @lname, " +
            "CustEmail = @email, " +
            "CustPassword = @password, " +
            "CustPhone = @hp" +
            "WHERE CustId = @custID";
        SqlConnection conn = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand(queryStr, conn);
        cmd.Parameters.AddWithValue("@custID", custID);
        cmd.Parameters.AddWithValue("@fname", fname);
        cmd.Parameters.AddWithValue("@lname", lname);
        cmd.Parameters.AddWithValue("@email", email);
        cmd.Parameters.AddWithValue("@password", password);
        cmd.Parameters.AddWithValue("@hp", hp);

        conn.Open();
        int nofRow = 0;
        nofRow = cmd.ExecuteNonQuery();
        conn.Close();
        return nofRow;
    }//end of update

    //Delete user account
    public int UserDelete(string ID)
    {
        string queryStr = "DELETE FROM CustomerData WHERE CustId = @custID";
        SqlConnection conn = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand(queryStr, conn);
        cmd.Parameters.AddWithValue("@custID", ID);
        conn.Open();
        int nofRow = 0;
        nofRow = cmd.ExecuteNonQuery();
        conn.Close();
        return nofRow;
    }//end of delete
}