/*
* Method to display all members present in the application
* Used in tab Members
*/
private void DisplayAllMembers()
{
List <Member> list = new List <Member>();
//Clear listView before to add items
listViewUsers.Items.Clear();
try
{
//Called method to select all members in DAOMember
list = DAOMember.SelectAllMembers();
foreach (Member m in list)
{
//Add items in listView for each member presents
ListViewItem item = new ListViewItem(m.MemberID.ToString());
item.SubItems.Add(m.Username);
item.SubItems.Add(m.Age.ToString());
item.SubItems.Add(m.Email);
item.SubItems.Add(m.Gender);
item.SubItems.Add(m.Nationality);
item.SubItems.Add(m.CategoryOfKnowledge);
item.SubItems.Add(m.Newsletter);
item.SubItems.Add(m.TypeOfMember);
listViewUsers.Items.Add(item);
}
}
catch
{
MessageBox.Show("There is not any users register in the application");
}
}
private void buttonLogin_Click(object sender, EventArgs e)
{
if (DAOMember.Login(textBoxUsername.Text, textBoxPassword.Text))
{
this.Hide();
ITTraleeCK mainForm = new ITTraleeCK();
mainForm.Show();
}
}
/**
* Method to register a new member in database
*
*/
private void buttonRegister_Click(object sender, EventArgs e)
{
//The type of member is per default "user"
string typeOfMember = "user";
string newsletter;
if (checkBoxNewsletter.Checked)
{
newsletter = "y";
}
else
{
newsletter = "f";
}
if (textBoxPassword.Text.Equals(textBoxConfirmPassword.Text))
{
try
{
DAOMember.CreateMember(textBoxUsername.Text, textBoxPassword.Text, int.Parse(textBoxAge.Text), textBoxEmail.Text, comboBoxGender.Text, comboBoxNationality.Text, comboBoxCatKnowledge.Text, newsletter, typeOfMember);
MessageBox.Show("Welcome " + textBoxUsername.Text);
textBoxUsername.Text = "";
textBoxPassword.Text = "";
textBoxConfirmPassword.Text = "";
textBoxAge.Text = "";
textBoxEmail.Text = "";
comboBoxGender.Text = "";
comboBoxNationality.Text = "";
comboBoxCatKnowledge.Text = "";
newsletter = "";
typeOfMember = "";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Your password isn't the same");
}
}
/*
* Method to update information of user when the user click on "save" button
* Used in tab Information
*/
private void buttonUpdate_Click(object sender, EventArgs e)
{
Member member = new Member();
string newsletter;
List <Category> categories = new List <Category>();
foreach (Category c in categories)
{
comboBoxCategory.Items.Add(c.CategoryName);
}
if (checkBoxNewsletter.Checked)
{
newsletter = "y";
}
else
{
newsletter = "f";
}
try
{
DAOMember.UpdateMemberConnected(label2Username.Text,
textBoxPassword.Text,
int.Parse(textBoxAge.Text),
textBoxEmail.Text,
comboBoxGender.Text,
comboBoxNationality.Text,
comboBoxCatKnowledge.Text,
label2TypeOfMember.Text,
newsletter);
MessageBox.Show("Saved successfully");
}
catch
{
MessageBox.Show("Impossible to save your changing");
}
}
/*
* Method to display all informations of the member who is connected
* Used in tab Information
*/
private void DisplayMemberConnected()
{
Member member = new Member();
member = DAOMember.SelectMemberConnected();
label2Username.Text = member.Username;
textBoxPassword.Text = member.MemberPassword;
textBoxAge.Text = member.Age.ToString();
textBoxEmail.Text = member.Email;
comboBoxGender.Text = member.Gender;
comboBoxNationality.Text = member.Nationality;
comboBoxCatKnowledge.Text = member.CategoryOfKnowledge;
label2TypeOfMember.Text = member.TypeOfMember;
if (member.Newsletter.ToString().Equals('y'))
{
checkBoxNewsletter.CheckState = CheckState.Checked;
}
else
{
checkBoxNewsletter.CheckState = CheckState.Unchecked;
}
}
