public MemberVO FindMember(string input, int mode)
{
MemberVO member = null;
connection.Open();
command = connection.CreateCommand();
switch (mode)
{
case Constants.SEARCH_WITH_EMAIL:
command.CommandText = "select * from member where email = @email";
command.Parameters.Add("@email", MySqlDbType.VarChar).Value = input;
break;
case Constants.SEARCH_WITH_ID:
command.CommandText = "select * from member where id = @id";
command.Parameters.Add("@id", MySqlDbType.VarChar).Value = input;
break;
}
reader = command.ExecuteReader();
while (reader.Read())
{
member = new MemberVO();
member.Id = reader.GetString(0);
member.Password = reader.GetString(1);
member.Name = reader.GetString(2);
member.ResidentNumber = reader.GetString(3);
member.AddressNumber = reader.GetString(4);
member.Address = reader.GetString(5);
member.AddressDetail = reader.GetString(6);
member.PhoneNumber = reader.GetString(7);
member.Email = reader.GetString(8);
}
reader.Close();
connection.Close();
if (member == null)
{
return(null);
}
else
{
return(member);
}
}
/// <summary>
/// 회원의 전화번호를 수정하는 역할을 한다.
/// </summary>
/// <param name="id">회원의 아이디</param>
/// <param name="phone">수정할 전화번호</param>
public void EditMemberInfo(MemberVO member)
{
connection.Open();
command = connection.CreateCommand();
command.CommandText = "UPDATE member SET password = @password, name = @name,residentNumber = @residentNumber, " +
"addressNumber = @addressNumber,address = @address, addressdetail = @addressDetail,phoneNumber = @phoneNumber,email = @email where id = @id";
command.Parameters.Add("@name", MySqlDbType.VarChar).Value = member.Name;
command.Parameters.Add("@residentNumber", MySqlDbType.VarChar).Value = member.ResidentNumber;
command.Parameters.Add("@id", MySqlDbType.VarChar).Value = member.Id;
command.Parameters.Add("@password", MySqlDbType.VarChar).Value = member.Password;
command.Parameters.Add("@phoneNumber", MySqlDbType.VarChar).Value = member.PhoneNumber;
command.Parameters.Add("@address", MySqlDbType.VarChar).Value = member.Address;
command.Parameters.Add("@addressDetail", MySqlDbType.VarChar).Value = member.AddressDetail;
command.Parameters.Add("@addressNumber", MySqlDbType.VarChar).Value = member.AddressNumber;
command.Parameters.Add("@email", MySqlDbType.VarChar).Value = member.Email;
command.ExecuteNonQuery();
connection.Close();
}
public void AddMember(MemberVO member)
{
connection.Open();
command = connection.CreateCommand();
command.CommandText = "INSERT INTO member values(@id,@password,@name,@residentNumber,@addressNumber,@address,@addressDetail,@phoneNumber,@email)";
command.Parameters.Add("@name", MySqlDbType.VarChar).Value = member.Name;
command.Parameters.Add("@residentNumber", MySqlDbType.VarChar).Value = member.ResidentNumber;
command.Parameters.Add("@id", MySqlDbType.VarChar).Value = member.Id;
command.Parameters.Add("@password", MySqlDbType.VarChar).Value = member.Password;
command.Parameters.Add("@phoneNumber", MySqlDbType.VarChar).Value = member.PhoneNumber;
command.Parameters.Add("@address", MySqlDbType.VarChar).Value = member.Address;
command.Parameters.Add("@addressDetail", MySqlDbType.VarChar).Value = member.AddressDetail;
command.Parameters.Add("@addressNumber", MySqlDbType.VarChar).Value = member.AddressNumber;
command.Parameters.Add("@email", MySqlDbType.VarChar).Value = member.Email;
command.ExecuteNonQuery();
connection.Close();
}
public void InitTextBoxes(MemberVO member)
{
id.Text = member.Id;
pw.Text = member.Password;
pw.BorderBrush = Brushes.Black;
pw2.Text = member.Password;
pw2.BorderBrush = Brushes.Black;
name.Text = member.Name;
frontResiNum.Text = member.ResidentNumber.Substring(0, 6);
behindResiNum.Text = member.ResidentNumber.Substring(6, 7);
addressNumber.Text = member.AddressNumber;
addressNumber.BorderBrush = Brushes.Black;
frontAddress.Text = member.Address;
behindAddress.Text = member.AddressDetail;
phone1.BorderBrush = Brushes.Black;
phone2.BorderBrush = Brushes.Black;
phone3.BorderBrush = Brushes.Black;
if (member.PhoneNumber.Length.Equals(11))
{
phone1.Text = member.PhoneNumber.Substring(0, 3);
phone2.Text = member.PhoneNumber.Substring(3, 4);
phone3.Text = member.PhoneNumber.Substring(7, 4);
}
else if (member.PhoneNumber.Length.Equals(10))
{
phone1.Text = member.PhoneNumber.Substring(0, 3);
phone2.Text = member.PhoneNumber.Substring(3, 3);
phone3.Text = member.PhoneNumber.Substring(6, 4);
}
int index = member.Email.IndexOf('@');
emailFront.Text = member.Email.Substring(0, index);
emailBehind.Text = member.Email.Substring(index + 1, member.Email.Length - index - 1);
}
