using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Forms;
using System.Media;
using System.Data.SqlClient;
namespace AlexandriasBibliothek
{
public partial class Form1 : Form
{
private bool check_name = false;
private bool check_nachname = false;
private bool check_user_id = false;
private bool check_password = false;
private bool check_birthday = false;
private bool check_pure_intentions = false;
public Form1()
{
InitializeComponent();
SoundPlayer StartUp = new SoundPlayer(@"C:\Alexandria\Sound\320664_pizzaiolo_lovelyboot1.wav");
StartUp.Play();
textBox2.Enabled = false;
textBox3.ForeColor = System.Drawing.Color.Gray;
textBox4.ForeColor = System.Drawing.Color.Gray;
textBox5.ForeColor = System.Drawing.Color.Gray;
textBox6.ForeColor = System.Drawing.Color.Gray;
textBox7.ForeColor = System.Drawing.Color.Gray;
textBox8.ForeColor = System.Drawing.Color.Gray;
textBox9.ForeColor = System.Drawing.Color.Gray;
textBox10.ForeColor = System.Drawing.Color.Gray;
dateTimePicker1.CalendarForeColor = System.Drawing.Color.Gray;
textBox2.UseSystemPasswordChar = true;
textBox11.UseSystemPasswordChar = true;
checkBox1.Enabled = false;
checkBox2.Enabled = false;
checkBox3.Enabled = false;
checkBox4.Enabled = false;
checkBox5.Enabled = false;
checkBox6.Enabled = false;
checkBox7.Enabled = false;
checkBox8.Enabled = false;
checkBox9.Enabled = false;
radioButton1.Checked = true;
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
if (textBox1.Text != "") { textBox2.Enabled = true; checkBox5.Enabled = true; }
else { textBox2.Enabled = false; checkBox5.Enabled = false; }
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text != "" && textBox2.Text != "")
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Alexandria\Database\Database1.mdf;Integrated Security=True;";
conn.Open(); //Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Alexandria\Database\Database1.mdf;Integrated Security=True
try
{
SqlCommand SelectCommand = new SqlCommand("SELECT count(user_id) FROM USERS WHERE @0 = user_id and @1 = user_password;", conn);
SelectCommand.Parameters.Add(new SqlParameter("@0", textBox1.Text));
SelectCommand.Parameters.Add(new SqlParameter("@1", textBox2.Text));
using (SqlDataReader reader = SelectCommand.ExecuteReader())
{
reader.Read();
if (Convert.ToString(reader[0]) == "1")
{
MessageBox.Show("Welcome, " + textBox1.Text);
Form2 scd_screen = new Form2();
scd_screen.Location = this.Location;
scd_screen.Size = this.Size;
scd_screen.Show();
this.Hide();
}
else { MessageBox.Show("Wrong UserID or password!"); }
}
}
catch (SqlException)
{
MessageBox.Show("Wrong UserID or password!2");
}
}
}
else { MessageBox.Show("Wrong UserID or password!"); }
}
catch { MessageBox.Show("Wrong UserID or password!"); }
}
private void button2_Click(object sender, EventArgs e)
{
if (check_name == true && check_nachname == true && check_user_id == true && check_password == true && check_birthday)
{
int plz = 0;
int.TryParse(textBox6.Text, out plz);
using (SqlConnection conn = new SqlConnection())
{
try
{
conn.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Alexandria\Database\Database1.mdf;Integrated Security=True;";
conn.Open(); //Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Alexandria\Database\Database1.mdf;Integrated Security=True
SqlCommand insertCommand = new SqlCommand("Insert into USERS values(@a,@b,@c,@d,@e,@f,@g,@h,@i);", conn);
insertCommand.Parameters.Add(new SqlParameter("@a", textBox5.Text));
insertCommand.Parameters.Add(new SqlParameter("@b", textBox4.Text));
insertCommand.Parameters.Add(new SqlParameter("@c", textBox3.Text));
insertCommand.Parameters.Add(new SqlParameter("@d", dateTimePicker1.Text));
insertCommand.Parameters.Add(new SqlParameter("@e", textBox10.Text));
insertCommand.Parameters.Add(new SqlParameter("@f", textBox7.Text));
insertCommand.Parameters.Add(new SqlParameter("@g", plz));
insertCommand.Parameters.Add(new SqlParameter("@h", textBox9.Text));
insertCommand.Parameters.Add(new SqlParameter("@i", textBox8.Text));
if (insertCommand.ExecuteNonQuery() == 1)
{
MessageBox.Show("Willkommen " + textBox3.Text + " " + textBox4.Text + Environment.NewLine + "Du kannst dich nun einloggen und alles Spaßige tun, was man mit einer Datenbank so tun kann!");
textBox3.Text = "Name";
textBox3.ForeColor = System.Drawing.Color.Gray;
textBox4.Text = "Surname";
textBox4.ForeColor = System.Drawing.Color.Gray;
textBox5.Text = "UserID";
textBox5.ForeColor = System.Drawing.Color.Gray;
textBox6.Text = "ZIP";
textBox6.ForeColor = System.Drawing.Color.Gray;
textBox7.Text = "Town";
textBox7.ForeColor = System.Drawing.Color.Gray;
textBox8.Text = "Street";
textBox8.ForeColor = System.Drawing.Color.Gray;
textBox9.Text = "Housenumber";
textBox9.ForeColor = System.Drawing.Color.Gray;
textBox10.Text = "Password";
textBox10.ForeColor = System.Drawing.Color.Gray;
dateTimePicker1.Text = Convert.ToString(System.DateTime.Now);
}
}
catch
{
MessageBox.Show(textBox5.Text + " has alredy been taken. Sorry");
textBox5.ForeColor = System.Drawing.Color.Gray;
textBox5.Text = "UserID";
}
}
}
else
{
if (check_name != true) MessageBox.Show("Please enter a valid name");
if (check_nachname != true) MessageBox.Show("Please enter a valid surname");
if (check_user_id != true) MessageBox.Show("Please enter a valid UserID");
if (check_password != true) MessageBox.Show("Please enter a valid password");
if (check_birthday != true) MessageBox.Show("Please enter a valid birthday");
}
}
private void checkBox5_CheckedChanged(object sender, EventArgs e)
{
if (checkBox5.Checked == true)
{
textBox2.UseSystemPasswordChar = false;
}
else textBox2.UseSystemPasswordChar = true;
}
private void checkBox6_CheckedChanged(object sender, EventArgs e)
{
if (textBox10.ForeColor == System.Drawing.Color.Black && checkBox6.Checked == false)
{
textBox10.UseSystemPasswordChar = true;
}
else if (textBox10.ForeColor == System.Drawing.Color.Gray || checkBox6.Checked == true)
{
textBox10.UseSystemPasswordChar = false;
}
}
private void textBox3_Enter(object sender, EventArgs e)
{
if(textBox3.ForeColor == System.Drawing.Color.Gray)
{
textBox3.ForeColor = System.Drawing.Color.Black;
textBox3.Text = "";
}
}
private void textBox3_Leave(object sender, EventArgs e)
{
if (textBox3.Text == "")
{
textBox3.ForeColor = System.Drawing.Color.Gray;
textBox3.Text = "Name";
}
else check_name = true;
}
private void textBox4_Enter(object sender, EventArgs e)
{
if (textBox4.ForeColor == System.Drawing.Color.Gray)
{
textBox4.ForeColor = System.Drawing.Color.Black;
textBox4.Text = "";
}
}
private void textBox4_Leave(object sender, EventArgs e)
{
if (textBox4.Text == "")
{
textBox4.ForeColor = System.Drawing.Color.Gray;
textBox4.Text = "Surname";
}
else check_nachname = true;
}
private void textBox5_Enter(object sender, EventArgs e)
{
if (textBox5.ForeColor == System.Drawing.Color.Gray)
{
textBox5.ForeColor = System.Drawing.Color.Black;
textBox5.Text = "";
}
}
private void textBox5_Leave(object sender, EventArgs e)
{
if (textBox5.Text == "")
{
textBox5.ForeColor = System.Drawing.Color.Gray;
textBox5.Text = "UserID";
}
}
private void textBox6_Enter(object sender, EventArgs e)
{
if (textBox6.ForeColor == System.Drawing.Color.Gray)
{
textBox6.ForeColor = System.Drawing.Color.Black;
textBox6.Text = "";
}
}
private void textBox6_Leave(object sender, EventArgs e)
{
if (textBox6.Text == "")
{
textBox6.ForeColor = System.Drawing.Color.Gray;
textBox6.Text = "ZIP";
}
}
private void textBox7_Enter(object sender, EventArgs e)
{
if (textBox7.ForeColor == System.Drawing.Color.Gray)
{
textBox7.ForeColor = System.Drawing.Color.Black;
textBox7.Text = "";
}
}
private void textBox7_Leave(object sender, EventArgs e)
{
if (textBox7.Text == "")
{
textBox7.ForeColor = System.Drawing.Color.Gray;
textBox7.Text = "Town";
}
}
private void textBox8_Enter(object sender, EventArgs e)
{
if (textBox8.ForeColor == System.Drawing.Color.Gray)
{
textBox8.ForeColor = System.Drawing.Color.Black;
textBox8.Text = "";
}
}
private void textBox8_Leave(object sender, EventArgs e)
{
if (textBox8.Text == "")
{
textBox8.ForeColor = System.Drawing.Color.Gray;
textBox8.Text = "Street";
}
}
private void textBox9_Enter(object sender, EventArgs e)
{
if (textBox9.ForeColor == System.Drawing.Color.Gray)
{
textBox9.ForeColor = System.Drawing.Color.Black;
textBox9.Text = "";
}
}
private void textBox9_Leave(object sender, EventArgs e)
{
if (textBox9.Text == "")
{
textBox9.ForeColor = System.Drawing.Color.Gray;
textBox9.Text = "Housenumber";
}
}
private void textBox10_Enter(object sender, EventArgs e)
{
if (textBox10.ForeColor == System.Drawing.Color.Gray)
{
textBox10.ForeColor = System.Drawing.Color.Black;
textBox10.Text = "";
}
}
private void textBox10_Leave(object sender, EventArgs e)
{
if (textBox10.Text == "")
{
textBox10.ForeColor = System.Drawing.Color.Gray;
textBox10.Text = "Password";
}
}
private void dateTimePicker1_Enter(object sender, EventArgs e)
{
}
private void dateTimePicker1_Leave(object sender, EventArgs e)
{
}
private void textBox10_TextChanged(object sender, EventArgs e)
{
if (textBox10.Text == "")
{
checkBox1.Checked = false;
checkBox2.Checked = false;
checkBox3.Checked = false;
checkBox4.Checked = false;
checkBox7.Checked = false;
}
if (textBox10.ForeColor == System.Drawing.Color.Black && checkBox6.Checked == false)
{
textBox10.UseSystemPasswordChar = true;
}
else if (textBox10.ForeColor == System.Drawing.Color.Gray || checkBox6.Checked == true)
{
textBox10.UseSystemPasswordChar = false;
}
if (textBox10.Text != "" && textBox10.Text != "Password")
{
checkBox6.Enabled = true;
int pass_length = textBox10.Text.Length;
int a = 0, b = 0, c = 0, d = 0, f = 0;
for (int i = 0; i < pass_length; i++)
{
if (pass_length >= 8)
{
checkBox7.Checked = true;
}
else if (pass_length < 8) checkBox7.Checked = false;
if (Char.IsUpper(textBox10.Text[i]))
{
checkBox1.Checked = true;
b = i;
}
else if(Char.IsUpper(textBox10.Text[b]) != true) checkBox1.Checked = false;
if (Char.IsLower(textBox10.Text[i]))
{
checkBox2.Checked = true;
c = i;
}
else if (Char.IsLower(textBox10.Text[c]) != true) checkBox2.Checked = false;
if (int.TryParse(Convert.ToString(textBox10.Text[i]), out a))
{
checkBox3.Checked = true;
d = i;
}
else if (int.TryParse(Convert.ToString(textBox10.Text[d]), out a) != true) checkBox3.Checked = false;
if ((textBox10.Text[i]>32) && (textBox10.Text[i]<48))
{
checkBox4.Checked = true;
f = i;
}
else if ((textBox10.Text[f] > 32) && (textBox10.Text[f] < 48) != true) checkBox4.Checked = false;
if (checkBox1.Checked == true && checkBox2.Checked == true && checkBox3.Checked == true && checkBox4.Checked == true && checkBox7.Checked == true)
{
check_password = true;
}
else { check_password = false; }
}
}
else { checkBox6.Enabled = false; }
}
private void textBox5_TextChanged(object sender, EventArgs e)
{
int check_length = textBox5.Text.Length;
if (check_length >= 6 && check_length <= 20 && textBox5.ForeColor == System.Drawing.Color.Black)
{
checkBox8.Checked = true;
check_user_id = true;
}
else { checkBox8.Checked = false; check_user_id = false; }
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
DateTime current_time = DateTime.Now;
DateTime picked_time = Convert.ToDateTime(dateTimePicker1.Text);
int value = DateTime.Compare(current_time, picked_time);
if (value > 0) { checkBox9.Checked = true; check_birthday = true; }
else { checkBox9.Checked = false; check_birthday = false; }
}
private void groupBox2_Enter(object sender, EventArgs e)
{
}
private void button3_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection())
{
if (textBox11.Text != "" && textBox12.Text != "")
{
DialogResult returned_result = MessageBox.Show("Ya' sure, that ya' really wanna' do that?", "Sure?", MessageBoxButtons.YesNo);
if (returned_result == DialogResult.Yes)
check_pure_intentions = true;
if (check_pure_intentions)
{
conn.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Alexandria\Database\Database1.mdf;Integrated Security=True;";
conn.Open(); //Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Alexandria\Database\Database1.mdf;Integrated Security=True
try
{
SqlCommand DeleteCommand = new SqlCommand("DELETE from USERS where @0 = user_id and @1 = user_password;", conn);
DeleteCommand.Parameters.Add(new SqlParameter("@0", textBox12.Text));
DeleteCommand.Parameters.Add(new SqlParameter("@1", textBox11.Text));
if (DeleteCommand.ExecuteNonQuery() == 1)
{
MessageBox.Show("You deleted, " + textBox12.Text);
textBox11.Text = "";
textBox12.Text = "";
}
else
{
MessageBox.Show("Sorry, but we need valid informations");
}
}
catch (SqlException)
{
MessageBox.Show("Wrong UserID or password!");
}
}
else
{
textBox11.Text = "";
textBox12.Text = "";
}
}
else
{
MessageBox.Show("Damn son, just enter some valid values!");
}
}
}
private void checkBox10_CheckedChanged(object sender, EventArgs e)
{
if (checkBox10.Checked == false)
{
textBox11.UseSystemPasswordChar = true;
}
else if (checkBox10.Checked == true)
{
textBox11.UseSystemPasswordChar = false;
}
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
if(radioButton1.Checked == true)
{
groupBox1.Visible = true;
groupBox2.Visible = true;
groupBox3.Visible = false;
}
else if(radioButton2.Checked == true)
{
groupBox1.Visible = false;
groupBox2.Visible = false;
groupBox3.Visible = true;
}
}
}
}
Comments