/// <summary>
/// Looking for a Member in CardTable Table from the Database
/// </summary>
/// <param Column Name="Para"></param>
/// <param Column Value="Value"></param>
public MemberClass FindMember(object Para, object Value)
{
string FindQuery;
if ((string)Para == "Name")
{
FindQuery = FindMemQuery + $"[{Para}] like @ParamVal " +
$"or [{Para}] like @ParamVal + CHAR(10) +'%' " +
$"or [{Para}] like @ParamVal + CHAR(13) +'%' ";
}
else
{
FindQuery = FindMemQuery + $"[{Para}] = @ParamVal ";
}
MemberClass Member = new MemberClass();
using (ServerConnect = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(FindQuery, ServerConnect))
{
ServerConnect.Open();
try
{
command.Parameters.AddWithValue("@ParamVal", Value);
SqlDataReader rd;
rd = command.ExecuteReader();
if (rd.Read())
{
object[] BufferValue = new object[13];
rd.GetValues(BufferValue);
Member.ReadMember(BufferValue);
ServerConnect.Close();
return(Member);
}
else
{
ServerConnect.Close();
return(null);
}
}
catch (Exception e)
{
ServerConnect.Close();
MessageBox.Show(e.ToString());
Application.Exit();
return(null);
}
}
}