private void button3_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
dt.Columns.Add(col.HeaderText);
}
foreach (DataGridViewRow row in dataGridView1.Rows)
{
DataRow dRow = dt.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
dRow[cell.ColumnIndex] = cell.Value;
}
dt.Rows.Add(dRow);
}
ExportToPdf(dt);
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Generating Report PDF"));
Labels.Add(MyLabel.SetOKLabel("Passed Succesfully!"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetSuccess());
}
private void button3_Click(object sender, EventArgs e)
{
if (label8.Text == "")
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("General Error"));
Labels.Add(MyLabel.SetOKLabel("Please enter location: "));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
}
else
{
try
{
using (SqlConnection connection = new SqlConnection(global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase))
{
using (SqlCommand command = new SqlCommand("UPDATE Settings SET COMM=@c,PATH=@p WHERE Id=1 ", connection))
{
int x = comboBox1.SelectedIndex + 1;
command.Parameters.AddWithValue("@c", x);
command.Parameters.AddWithValue("@p", label8.Text);
command.Connection.Open();
if (command.ExecuteNonQuery().ToString() == "1")
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Settings Changed Successfully"));
Labels.Add(MyLabel.SetOKLabel("Settings changed"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetSuccess());
}
else
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Settings change Failed"));
Labels.Add(MyLabel.SetOKLabel("Settings not changed"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetSuccess());
command.Connection.Close();
this.Close();
}
}
}
}
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 button1_Click(object sender, EventArgs e)
{
if (visibilitylevel == 1)
{
if (formbox1.Text != password)
{
formbox1.Text = "";
formbox2.Text = "";
formbox3.Text = "";
label1.Text = "Password is incorrect!";
errorProvider1.SetError(formbox1, "Password is incorrect");
}
else if (formbox2.Text.Length <= 5)
{
formbox2.Text = "";
formbox3.Text = "";
errorProvider1.SetError(formbox1, "");
label1.Text = "Password has to be longer than 5 characters!";
errorProvider1.SetError(formbox2, "Password has to be longer than 5 characters!");
}
else if (formbox2.Text != formbox3.Text)
{
formbox2.Text = "";
formbox3.Text = "";
label1.Text = "Passwords aren't equal!";
errorProvider1.SetError(formbox2, "Passwords aren't equal!");
errorProvider1.SetError(formbox3, "Passwords aren't equal!");
}
else
{
try
{
label1.Text = "";
errorProvider1.SetError(formbox2, "");
errorProvider1.SetError(formbox3, "");
using (SqlConnection connection = new SqlConnection(global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase))
{
using (SqlCommand command = new SqlCommand("UPDATE Admin SET password=@s WHERE username='******'", connection))
{
command.Parameters.AddWithValue("@s", formbox2.Text);
command.Connection.Open();
if (command.ExecuteNonQuery().ToString() == "1")
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Password Change"));
Labels.Add(MyLabel.SetOKLabel("Password changed successfully"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetSuccess());
}
else
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Password Change"));
Labels.Add(MyLabel.SetOKLabel("Password Change failed"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
}
formbox1.Text = "";
formbox2.Text = "";
formbox3.Text = "";
command.Connection.Close();
}
}
}
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());
}
}
}
else if (visibilitylevel == 2)
{
if (authLevel == "2")
{
try
{
using (SqlConnection connection2 = new SqlConnection(
global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO Admin(username, password, authLevel)" +
"VALUES(@username, @password, @authLevel)", connection2))
{
cmd.Parameters.AddWithValue("@username", formbox1.Text);
cmd.Parameters.AddWithValue("@password", formbox2.Text);
cmd.Parameters.AddWithValue("@authLevel", formbox3.Text);
cmd.Connection.Open();
if (cmd.ExecuteNonQuery().ToString() == "1")
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Created new superuser"));
Labels.Add(MyLabel.SetOKLabel("New superuser created successfully"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetSuccess());
formbox1.Text = "";
formbox2.Text = "";
formbox3.Text = "";
}
}
connection2.Close();
}
}
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());
}
}
else
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Unavailable"));
Labels.Add(MyLabel.SetOKLabel("You don't have the Auth Level of 1"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
}
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (cardIdLabel.Text == "______________________")
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Card doesn't exist"));
Labels.Add(MyLabel.SetOKLabel("Please put your card to the scanner"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
sport.Write("#ERROR: Card doesn't exist!\n");
}
else if (pictureBox1.BackgroundImage == null)
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Image is empty"));
Labels.Add(MyLabel.SetOKLabel("Please upload your image"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
sport.Write("#ERROR: Image is empty!\n");
}
else if (radioButton2.Checked == false && radioButton3.Checked == false)
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Card type empty"));
Labels.Add(MyLabel.SetOKLabel("Please select a card type"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
sport.Write("#ERROR: Card type is empty!\n");
}
else if (radioButton5.Checked == false && radioButton6.Checked == false)
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Gender is empty"));
Labels.Add(MyLabel.SetOKLabel("Please select a gender!"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
sport.Write("#ERROR: Gender is empty!\n");
}
else if (methods.CheckId(cardIdLabel.Text) == false)
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Card already exists!"));
Labels.Add(MyLabel.SetOKLabel("There is a card in the database!"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
sport.Write("#ERROR: Already a member!\n");
}
else
{
using (SqlConnection connection = new SqlConnection(
global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase))
{
using (SqlCommand command = new SqlCommand("INSERT INTO Member(Name,Surname,Address,PhoneNumber,CardId,TypeId,NumOfEntrances,Gender,LastEntrance)" +
"VALUES(@Name,@Surname,@Address,@PhoneNumber,@CardId,@TypeId,@NumOfEntrances, @Gender, @LastEntrance)", connection))
{
string cardType = " ";
string gender = " ";
if (radioButton2.Checked == true)
{
cardType = "Student";
}
if (radioButton3.Checked == true)
{
cardType = "Work";
}
if (radioButton5.Checked == true)
{
gender = "Male";
}
if (radioButton6.Checked == true)
{
gender = "Female";
}
command.Parameters.AddWithValue("Name", name.Text);
command.Parameters.AddWithValue("Surname", surname.Text);
command.Parameters.AddWithValue("Address", address.Text);
command.Parameters.AddWithValue("PhoneNumber", phoneno.Text);
command.Parameters.AddWithValue("Cardid", Convert.ToInt64(cardIdLabel.Text));
command.Parameters.AddWithValue("TypeId", cardType);
command.Parameters.AddWithValue("NumOfEntrances", 1);
command.Parameters.AddWithValue("Gender", gender);
command.Parameters.AddWithValue("LastEntrance", DateTime.Now);
command.Connection.Open();
if (command.ExecuteNonQuery().ToString() == "1")
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Member insertion."));
Labels.Add(MyLabel.SetOKLabel("Member insertion passed."));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetSuccess());
if (cardType == "Student")
{
sport.Write("#SUCCS: Your membership is 40 KM!\n");
}
else
{
sport.Write("#SUCCS: Your membership is 50 KM!\n");
}
}
else
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Member insertion."));
Labels.Add(MyLabel.SetOKLabel("Member insertion failed."));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
}
command.Connection.Close();
}
int p = methods.GetMemberId(cardIdLabel.Text);
using (SqlCommand command2 = new SqlCommand("INSERT INTO Account(PaymentDate,ExpirationDate,Price,Name,Surname,MemberId)" +
"VALUES(@PaymentDate,@ExpirationDate,@Price,@Name,@Surname,@MemberId)", connection))
{
command2.Parameters.AddWithValue("PaymentDate", DateTime.Today);
command2.Parameters.AddWithValue("ExpirationDate", DateTime.Today.AddDays(30 * (monthsno.SelectedIndex + 1)));
command2.Parameters.AddWithValue("Price", price.Text);
command2.Parameters.AddWithValue("Name", name.Text);
command2.Parameters.AddWithValue("Surname", surname.Text);
command2.Parameters.AddWithValue("MemberId", p);
command2.Connection.Open();
command2.ExecuteNonQuery();
command2.Connection.Close();
}
using (SqlCommand command3 = new SqlCommand("INSERT INTO Report(MemberId,EntranceDate,Name,Surname) VALUES(@MemberId,@EntranceDate,@Name,@Surname)", connection))
{
command3.Parameters.AddWithValue("@MemberId", p);
command3.Parameters.AddWithValue("@EntranceDate", DateTime.Now);
command3.Parameters.AddWithValue("@Name", name.Text);
command3.Parameters.AddWithValue("@Surname", surname.Text);
command3.Connection.Open();
command3.ExecuteNonQuery();
command3.Connection.Close();
}
using (SqlCommand cmd4 = new SqlCommand("SELECT PATH FROM Settings", connection))
{
cmd4.CommandType = CommandType.Text;
cmd4.Connection.Open();
SqlDataReader dr = cmd4.ExecuteReader();
while (dr.Read())
{
path = dr["PATH"].ToString();
}
cmd4.Connection.Close();
}
saveImage();
this.Close();
}
}
}
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 button1_Click_1(object sender, EventArgs e)
{
string tmp = "";
string authLevel = "";
try
{
using (SqlConnection connection = new SqlConnection(
global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase))
{
using (SqlCommand cmd = new SqlCommand("SELECT password, authLevel FROM Admin WHERE username=@user", connection))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@user", userBox.Text);
connection.Open();
SqlDataReader o = cmd.ExecuteReader();
if (o != null)
{
while (o.Read())
{
tmp = o["password"].ToString();
authLevel = o["authLevel"].ToString();
}
}
connection.Close();
}
}
if (passBox.Text != tmp || tmp == "")
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Login Failed!"));
Labels.Add(MyLabel.SetOKLabel("Incorrect Username/Password"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
userBox.Text = "";
passBox.Text = "";
}
else
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Successfull Login!"));
Labels.Add(MyLabel.SetOKLabel("Welcome Back " + userBox.Text + "!"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetSuccess());
HomeForm h = new HomeForm(authLevel, userBox.Text);
h.MaximizeBox = false;
h.MinimizeBox = false;
this.Hide();
h.ShowDialog();
this.Close();
}
}
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 button3_Click(object sender, EventArgs e)
{
try
{
using (SqlConnection connection = new SqlConnection(
global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase))
{
using (SqlCommand command2 = new SqlCommand("INSERT INTO Account(PaymentDate,ExpirationDate,Price,Name,Surname,MemberId)" +
"VALUES(@PaymentDate,@ExpirationDate,@Price,@Name,@Surname,@MemberId)", connection))
{
int x = Convert.ToInt32(noofmonthslabel.Text);
command2.Parameters.AddWithValue("PaymentDate", DateTime.Today);
command2.Parameters.AddWithValue("ExpirationDate", Convert.ToDateTime(membershipuntil.Text));
command2.Parameters.AddWithValue("Price", pricelabel.Text);
command2.Parameters.AddWithValue("Name", namelabel.Text);
command2.Parameters.AddWithValue("Surname", surnamelabel.Text);
command2.Parameters.AddWithValue("MemberId", b.id);
command2.Connection.Open();
if (command2.ExecuteNonQuery().ToString() == "1")
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Membership extension."));
Labels.Add(MyLabel.SetOKLabel("Successfully Passed"));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetSuccess());
}
else
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Membership extension."));
Labels.Add(MyLabel.SetOKLabel("Failed."));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
}
command2.Connection.Close();
this.Close();
}
}
}
catch (Exception ex)
{
List <Label> Labels = new List <Label>();
Labels.Add(MyLabel.SetOKLabel("Membership extension."));
Labels.Add(MyLabel.SetOKLabel(ex.Message));
List <Button> Buttons = new List <Button>();
Buttons.Add(MyButton.SetOKThemeButton());
MyMessageBox.Show(
Labels,
"",
Buttons,
MyImage.SetFailed());
}
}