private void button3_Click(object sender, EventArgs e)
{
members.Clear();
string genderCheckBox = "";
string query = "";
if (radioButton5.Checked)
{
genderCheckBox = "Male";
}
else if (radioButton6.Checked)
{
genderCheckBox = "Female";
}
if (genderCheckBox != "")
{
query = "SELECT id, Name, Surname, CardId, TypeId, NumOfEntrances, Gender, " +
"LastEntrance, PhoneNumber, Address FROM Member WHERE (Name LIKE '%' + @d + '%' OR Surname LIKE '%' + @d +'%') AND Gender = @g";
}
else
{
query = "SELECT id, Name, Surname, CardId, TypeId, NumOfEntrances, Gender, " +
"LastEntrance, PhoneNumber, Address FROM Member WHERE Name LIKE '%' + @d + '%' OR Surname LIKE '%' + @d +'%'";
}
try
{
using (SqlConnection connection = new SqlConnection(
global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase))
{
using (SqlCommand cmd2 = new SqlCommand(query, connection))
{
cmd2.Parameters.AddWithValue("@d", name.Text);
if (genderCheckBox != "")
{
cmd2.Parameters.AddWithValue("@g", genderCheckBox);
}
cmd2.CommandType = CommandType.Text;
connection.Open();
SqlDataReader dr = cmd2.ExecuteReader();
while (dr.Read())
{
int id2 = Convert.ToInt32(dr["id"]);
string name = dr["Name"].ToString();
string surname = dr["Surname"].ToString();
string address = dr["Address"].ToString();
string phonenum = dr["PhoneNumber"].ToString();
string typeid = dr["TypeId"].ToString();
int numofentr = Convert.ToInt32(dr["NumOfEntrances"]);
Int64 cardid = Convert.ToInt64(dr["CardId"]);
DateTime lastEntrance = Convert.ToDateTime(dr["LastEntrance"]);
string gender = dr["Gender"].ToString();
DateTime expDate = method.GetExpirationDate(id2);
PartialMember newMember = new PartialMember();
newMember.Name = name;
newMember.Surname = surname;
newMember.Address = address;
newMember.PhoneNumber = phonenum;
newMember.TypeId = typeid;
newMember.NumOfEntrances = numofentr;
newMember.ExpirationDate = expDate;
newMember.CardId = cardid;
newMember.LastEntrance = lastEntrance;
newMember.Gender = gender;
newMember.id = id2;
newMember.NumOfDays = method.GetNumberOfEntrances(cardid.ToString());
members.Add(newMember);
}
connection.Close();
}
}
populate();
}
catch (Exception ex)
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("General Error"));
Labels.Add(MyLabel.SetOKLabel(ex.Message));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
}
}
private void GetMembers()
{
try
{
using (SqlConnection connection = new SqlConnection(
global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase))
{
using (SqlCommand cmd2 = new SqlCommand("SELECT id, Name, Surname, Address, PhoneNumber, CardId, TypeId," +
" NumOfEntrances, Gender, LastEntrance FROM Member", connection))
{
cmd2.CommandType = CommandType.Text;
connection.Open();
SqlDataReader dr = cmd2.ExecuteReader();
while (dr.Read())
{
long id = Convert.ToInt32(dr["id"]);
string name = dr["Name"].ToString();
string surname = dr["Surname"].ToString();
string address = dr["Address"].ToString();
string phonenum = dr["PhoneNumber"].ToString();
string typeid = dr["TypeId"].ToString();
int numofentr = Convert.ToInt32(dr["NumOfEntrances"]);
Int64 cardid = Convert.ToInt64(dr["CardId"]);
DateTime lastEntrance = Convert.ToDateTime(dr["LastEntrance"]);
string gender = dr["Gender"].ToString();
DateTime expDate = method.GetExpirationDate(id);
PartialMember newMember = new PartialMember();
newMember.Name = name;
newMember.Surname = surname;
newMember.Address = address;
newMember.PhoneNumber = phonenum;
newMember.TypeId = typeid;
newMember.NumOfEntrances = numofentr;
newMember.ExpirationDate = expDate;
newMember.CardId = cardid;
newMember.LastEntrance = lastEntrance;
newMember.Gender = gender;
if (gender.Trim() == "Female")
{
female++;
}
else
{
male++;
}
newMember.id = id;
newMember.NumOfDays = method.GetNumberOfEntrances(cardid.ToString());
members.Add(newMember);
}
label9.Text = members.Count.ToString();
label2.Text = male.ToString();
label10.Text = female.ToString();
connection.Close();
}
}
populate();
}
catch (Exception ex)
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("General Error"));
Labels.Add(MyLabel.SetOKLabel(ex.Message));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
}
}
public ExtendMemberShipForm(PartialMember a)
{
InitializeComponent();
b = new PartialMember();
b = a;
}
