public bool AddUser(D_UserInfo userInfo, string password) { if (!CheckEmailNotDup(userInfo.email)) { ErrorMessage = "ԓEmail�ѽ��]�ԣ��������c���B��<a href=\"RecoverPassword.aspx\">\"��ӛ�ܴa?\"</a>���]��@ȡ���ܴa��"; return false; } userInfo.userId = AddNewUser(); if (userInfo.userId <= 0) { ErrorMessage = "������Ñ�ʧ����Ո�z�顣"; return false; } UpdateUserInfo(userInfo); AddLogin(userInfo.userId, password); return true; }
public void UpdateUserInfo(D_UserInfo userInfo) { string SQL_UPDATE_USERINFO = @" update userInfo set firstName=@firstName, middleName=@middleName, lastName=@lastName, address=@address, city=@city, state=@state, zip=@zip, country=@country, homephone=@homephone, cellphone=@cellphone, email=@email, mailList=@mailList where userId=@userId "; if (userInfo.firstName == null || userInfo.firstName == "") { int p = userInfo.email.IndexOf('@'); if (p > 0) userInfo.firstName = userInfo.email.Substring(0, p); } SqlParameter[] para = { new SqlParameter("@userId", userInfo.userId), new SqlParameter("@firstName", userInfo.firstName), new SqlParameter("@middleName", userInfo.middleName), new SqlParameter("@lastName", userInfo.lastName), new SqlParameter("@address", userInfo.address), new SqlParameter("@city", userInfo.city), new SqlParameter("@zip", userInfo.zip), new SqlParameter("@state", userInfo.state), new SqlParameter("@country", userInfo.country), new SqlParameter("@homephone", userInfo.homepnone), new SqlParameter("@cellphone", userInfo.cellphone), new SqlParameter("@email", userInfo.email), new SqlParameter("@mailList", userInfo.mailList) }; m_dao.ExecuteNoQuery(SQL_UPDATE_USERINFO, para); }
public D_UserInfo GetUserInfo(int userId) { D_UserInfo ui = new D_UserInfo(); string sql = @" select * from userInfo where userId=@userId "; SqlParameter[] para = { new SqlParameter("@userId", userId) }; IDataReader dr = m_dao.ExecuteReader(sql, para); if (dr.Read()) { ui.userId = (int)dr["userId"]; ui.firstName = dr["firstName"].ToString(); ui.middleName = dr["middleName"].ToString(); ui.lastName = dr["lastName"].ToString(); ui.address = dr["address"].ToString(); ui.city = dr["city"].ToString(); ui.state = dr["state"].ToString(); ui.zip = dr["zip"].ToString(); ui.country = dr["country"].ToString(); ui.homephone = dr["homephone"].ToString(); ui.cellphone = dr["cellphone"].ToString(); ui.walkyphone = dr["walkyPhone"].ToString(); ui.email = dr["email"].ToString(); ui.mailList = dr["mailList"].ToString(); } return ui; }