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;
}
