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