public class BizAcc
{
    string connStr = ConfigurationManager.ConnectionStrings["FoodJunkiesDataBase"].ConnectionString;
    private string _bizID = null;
    private string _bizEmail = null;
    private string _bizPassword = null;
    private string _bizName = null;
    private string _bizHp = null;
    private string _bizPostalCode = null;
    private string _bizAddr = null;
    private string _bizUnitNo = null;

    public BizAcc()
    {

    }

    public BizAcc(string bizID, string bizEmail, string bizPassword, string bizName, string bizHp, string bizPostalCode, string bizAddr, string bizUnitNo)
    {
        _bizID = bizID;
        _bizEmail = bizEmail;
        _bizPassword = bizPassword;
        _bizName = bizName;
        _bizHp = bizHp;
        _bizPostalCode = bizPostalCode;
        _bizAddr = bizAddr;
        _bizUnitNo = bizUnitNo;
    }

    public BizAcc(string bizEmail, string bizPassword, string bizName, string bizHp, string bizPostalCode, string bizAddr, string bizUnitNo)
        : this(null, bizEmail, bizPassword, bizName, bizHp, bizPostalCode, bizAddr, bizUnitNo)
    {

    }

    public BizAcc(string bizID)
        : this(bizID, "", "", "", "", "", "", "")
    {

    }

    public string BizId
    {
        get { return _bizID; }
        set { _bizID = value; }
    }
    public string BizEmail
    {
        get { return _bizEmail; }
        set { _bizEmail = value; }
    }
    public string BizPassword
    {
        get { return _bizPassword; }
        set { _bizPassword = value; }
    }
    public string BizName
    {
        get { return _bizName; }
        set { _bizName = value; }
    }
    public string BizPhone
    {
        get { return _bizHp; }
        set { _bizHp = value; }
    }
    public string BizPostalCode
    {
        get { return _bizPostalCode; }
        set { _bizPostalCode = value; }
    }
    public string BizAddress
    {
        get { return _bizAddr; }
        set { _bizAddr = value; }
    }
    public string BizUnitNo
    {
        get { return _bizUnitNo; }
        set { _bizUnitNo = value; }
    }

    public List<BizAcc> getBizAll()
    {
        List<BizAcc> bizList = new List<BizAcc>();
        string biz_ID, biz_Email, biz_Password, biz_Name, biz_Hp, biz_PostalCode, biz_Addr, biz_UnitNo;
        string queryStr = "SELECT BizId, BizEmail, BizPassword, BizName, BizPhone, BizPostalCode, BizAddress, BizUnitNo FROM BusinessData Order By BizId";
        SqlConnection conn = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand(queryStr, conn);
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader();

        while (dr.Read())
        {
            biz_ID = dr["BizId"].ToString();
            biz_Email = dr["BizEmail"].ToString();
            biz_Password = dr["BizPassword"].ToString();
            biz_Name = dr["BizName"].ToString();
            biz_Hp = dr["BizPhone"].ToString();
            biz_PostalCode = dr["BizPostalCode"].ToString();
            biz_Addr = dr["BizAddress"].ToString();
            biz_UnitNo = dr["BizUnitNo"].ToString();
            BizAcc b = new BizAcc(biz_ID, biz_Email, biz_Password, biz_Name, biz_Hp, biz_PostalCode, biz_Addr, biz_UnitNo);
            bizList.Add(b);
        }
        conn.Close();
        dr.Close();
        dr.Dispose();
        return bizList;
    }

    public int BizUpdate(string bizID, string bizEmail, string bizPassword, string bizName, string bizHp, string bizPostalCode, string bizAddr, string bizUnitNo)
    {
        string queryStr = "UPDATE BusinessData SET" +
            "BizEmail = @bEmail, " +
            "BizPassword = @bPassword, " +
            "BizName = @bName, " +
            "BizPhone = @bPhone, " +
            "BizPostalCode = @bPostalCode, " +
            "BizAddress = @bAddr, " +
            "BizUnitNo = @bUnitNo" +
            "WHERE BizId = @bizID";
        SqlConnection conn = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand(queryStr, conn);
        cmd.Parameters.AddWithValue("@bEmail", bizID);
        cmd.Parameters.AddWithValue("@bPassword", bizPassword);
        cmd.Parameters.AddWithValue("@bName", bizName);
        cmd.Parameters.AddWithValue("@bPhone", bizHp);
        cmd.Parameters.AddWithValue("@bPostalCode", bizPostalCode);
        cmd.Parameters.AddWithValue("@bAddr", bizAddr);
        cmd.Parameters.AddWithValue("@bUnitNo", bizUnitNo);

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

    public int BizDelete(string ID)
    {
        string queryStr = "DELETE FROM BusinessData WHERE BizId = @bizID";
        SqlConnection conn = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand(queryStr, conn);
        cmd.Parameters.AddWithValue("@bizID", ID);
        conn.Open();
        int nofRow = 0;
        nofRow = cmd.ExecuteNonQuery();
        conn.Close();
        return nofRow;
    }//end delete
}