private void searchMembersButtonClick(object sender, EventArgs e) { try { sport.Close(); SearchMembersForm p = new SearchMembersForm(); p.ShowDialog(); sport.Open(); } 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 reportFormButtonClick(object sender, EventArgs e) { try { sport.Close(); InformationForm ev = new InformationForm("0"); ev.ShowDialog(); sport.Open(); } 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()); } }
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 GetInfo() { try { int i = Convert.ToInt32(globalId); using (SqlConnection connection = new SqlConnection( global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase)) { using (SqlCommand cmd2 = new SqlCommand("SELECT Name, Surname, CardId, Address, PhoneNumber, TypeId, NumOfEntrances, Gender, " + "LastEntrance FROM Member WHERE id=@id", connection)) { connection.Open(); cmd2.CommandType = CommandType.Text; cmd2.Parameters.AddWithValue("@id", i); SqlDataReader dr = cmd2.ExecuteReader(); while (dr.Read()) { string name1 = dr["Name"].ToString(); string surname1 = dr["Surname"].ToString(); string address1 = dr["Address"].ToString(); string phoneno1 = dr["PhoneNumber"].ToString(); string typeid1 = dr["TypeId"].ToString(); long cardId1 = Convert.ToInt64(dr["CardId"]); int numofentrances1 = Convert.ToInt32(dr["NumOfEntrances"]); DateTime lastEntr = Convert.ToDateTime(dr["LastEntrance"]); string gender1 = dr["Gender"].ToString(); DateTime z = methods.GetExpirationDate(i); if (lastEntr.Date != DateTime.Today) { numofentrances1++; methods.WriteEntrance(i, numofentrances1, name1, surname1); } string date = z.Day + "/" + z.Month + "/" + z.Year; methods.WriteLastEntrance(i); lastEntr = DateTime.Now; panel1.Visible = true; label14.Text = name1; label8.Text = surname1; label4.Text = gender1; label24.Text = address1; label22.Text = phoneno1; label21.Text = date; label20.Text = cardId1.ToString(); label15.Text = typeid1; label17.Text = numofentrances1.ToString(); a.Name = name1; a.Surname = surname1; a.Address = address1; a.PhoneNumber = phoneno1; a.TypeId = typeid1; a.NumOfEntrances = numofentrances1; a.ExpirationDate = z; a.CardId = cardId1; a.LastEntrance = lastEntr; a.Gender = gender1; a.id = i; } } 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()); } }
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()); } } }
public static string Show(List <Label> Labels = null, string Title = "", List <Button> Buttons = null, PictureBox Image = null) { if (Labels == null) { Labels = new List <Label>(); } if (Labels.Count == 0) { Labels.Add(MyLabel.Set("")); } if (Buttons == null) { Buttons = new List <Button>(); } if (Buttons.Count == 0) { Buttons.Add(MyButton.Set("OK")); } List <Button> buttons = new List <Button>(Buttons); buttons.Reverse(); int ImageWidth = 0; int ImageHeight = 0; int LabelWidth = 0; int LabelHeight = 0; int ButtonWidth = 0; int ButtonHeight = 0; int TotalWidth = 0; int TotalHeight = 0; MyMessageBox mb = new MyMessageBox(); mb.Text = Title; //Image if (Image != null) { mb.Controls.Add(Image); Image.MaximumSize = new Size(150, 300); ImageWidth = Image.Width + Image.Margin.Horizontal; ImageHeight = Image.Height + Image.Margin.Vertical; } //Labels List <int> il = new List <int>(); mb.panText.Location = new Point(9 + ImageWidth, 35); foreach (Label l in Labels) { mb.panText.Controls.Add(l); l.Location = new Point(200, 50); l.MaximumSize = new Size(480, 2000); il.Add(l.Width); } int mw = Labels.Max(x => x.Width); il.ToString(); Labels.ForEach(l => l.MinimumSize = new Size(Labels.Max(x => x.Width), 1)); mb.panText.Height = Labels.Sum(l => l.Height); mb.panText.MinimumSize = new Size(Labels.Max(x => x.Width) + mb.ScrollBarWidth(Labels), ImageHeight); mb.panText.MaximumSize = new Size(Labels.Max(x => x.Width) + mb.ScrollBarWidth(Labels), 300); LabelWidth = mb.panText.Width; LabelHeight = mb.panText.Height; //Buttons foreach (Button b in buttons) { mb.panButtons.Controls.Add(b); b.Location = new Point(3, 3); b.TabIndex = Buttons.FindIndex(i => i.Text == b.Text); b.Click += new EventHandler(mb.Button_Click); } ButtonWidth = mb.panButtons.Width; ButtonHeight = mb.panButtons.Height; //Set Widths if (ButtonWidth > ImageWidth + LabelWidth) { Labels.ForEach(l => l.MinimumSize = new Size(ButtonWidth - ImageWidth - mb.ScrollBarWidth(Labels), 1)); mb.panText.Height = Labels.Sum(l => l.Height); mb.panText.MinimumSize = new Size(Labels.Max(x => x.Width) + mb.ScrollBarWidth(Labels), ImageHeight); mb.panText.MaximumSize = new Size(Labels.Max(x => x.Width) + mb.ScrollBarWidth(Labels), 300); LabelWidth = mb.panText.Width; LabelHeight = mb.panText.Height; } TotalWidth = ImageWidth + LabelWidth; //Set Height TotalHeight = LabelHeight + ButtonHeight; mb.panButtons.Location = new Point(TotalWidth - ButtonWidth + 9, mb.panText.Location.Y + mb.panText.Height + 10); mb.Size = new Size(TotalWidth + 25, TotalHeight + 47); mb.ShowDialog(); return(mb.Result); }
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 HomeForm_Load(object sender, EventArgs e) { timer1.Start(); try { using (SqlConnection connection = new SqlConnection(global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase)) { bool tmp = false; using (SqlCommand cmd = new SqlCommand("SELECT PATH FROM Settings WHERE Id=1", connection)) { cmd.CommandType = CommandType.Text; connection.Open(); object o = cmd.ExecuteScalar(); if (o != null) { if (o.ToString() == "") { tmp = true; } else { tmp = false; } } else { tmp = true; } cmd.Connection.Close(); } if (tmp) { using (SqlCommand command = new SqlCommand("UPDATE Settings SET PATH=@p WHERE Id=1 ", connection)) { string wanted_path = Path.GetDirectoryName(Path.GetDirectoryName(System.IO.Directory.GetCurrentDirectory())); command.Parameters.AddWithValue("@p", wanted_path); command.Connection.Open(); command.ExecuteNonQuery(); command.Connection.Close(); } } } sport.DataReceived += new SerialDataReceivedEventHandler(DataReceivedHandler); sport.Open(); } 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()); } }
private void GetInfo() { try { Int64 i = Convert.ToInt64(id); using (SqlConnection connection = new SqlConnection( global::GymMembershipSystem.Properties.Settings.Default.GymMembershipSystemDatabase)) { using (SqlCommand cmd = new SqlCommand("SELECT id FROM Member WHERE CardId=@CardId", connection)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@CardId", i); connection.Open(); object o = cmd.ExecuteScalar(); if (o != null) { string city = o.ToString(); int k = Convert.ToInt32(city); using (SqlCommand cmd2 = new SqlCommand("SELECT Name, Surname, Address, PhoneNumber, TypeId, NumOfEntrances, Gender, " + "LastEntrance FROM Member WHERE id=@id", connection)) { cmd2.CommandType = CommandType.Text; cmd2.Parameters.AddWithValue("@id", k); SqlDataReader dr = cmd2.ExecuteReader(); while (dr.Read()) { string name1 = dr["Name"].ToString(); string surname1 = dr["Surname"].ToString(); string address1 = dr["Address"].ToString(); string phoneno1 = dr["PhoneNumber"].ToString(); string typeid1 = dr["TypeId"].ToString(); int numofentrances1 = Convert.ToInt32(dr["NumOfEntrances"]); DateTime lastEntr = Convert.ToDateTime(dr["LastEntrance"]); string gender1 = dr["Gender"].ToString(); DateTime z = methods.GetExpirationDate(k); if (lastEntr.Date != DateTime.Today) { numofentrances1++; methods.WriteEntrance(k, numofentrances1, name1, surname1); } methods.WriteLastEntrance(k); lastEntr = DateTime.Now; a.Name = name1; a.Surname = surname1; a.Address = address1; a.PhoneNumber = phoneno1; a.TypeId = typeid1; a.NumOfEntrances = numofentrances1; a.ExpirationDate = z; a.CardId = i; a.LastEntrance = lastEntr; a.Gender = gender1; a.id = k; } } } 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()); } }