//Main function public static void Main(string[] args) { //Change file path var reader = new StreamReader(File.OpenRead(@"")); reader.ReadLine(); while (!reader.EndOfStream) { var line = reader.ReadLine(); var values = line.Split(','); int i = 0; List <float> listA = new List <float>(); while (i < 13) { float x = float.Parse(values[i]); listA.Add(x); i++; } obj = new info(listA); l1.Add(obj); line = reader.ReadLine(); values = line.Split(','); i = 0; List <float> listB = new List <float>(); while (i < 13) { float x = float.Parse(values[i]); listB.Add(x); i++; } info obj2 = new info(listB); l2.Add(obj2); } Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form1()); }
private void loginbutton_Click(object sender, EventArgs e) { pictureBox2.BackgroundImage = Properties.Resources.user1; panel1.BackColor = Color.FromArgb(233, 233, 233); usernameinput.ForeColor = Color.FromArgb(233, 233, 233); pictureBox3.BackgroundImage = Properties.Resources.lock1; panel2.BackColor = Color.FromArgb(233, 233, 233); passwordinput.ForeColor = Color.FromArgb(233, 233, 233); pictureBox4.BackgroundImage = Properties.Resources.email1; panel3.BackColor = Color.FromArgb(233, 233, 233); emailinput.ForeColor = Color.FromArgb(233, 233, 233); bool proced = true; if (string.IsNullOrEmpty(usernameinput.Text.ToString()) == true) { user_click_check = false; usernameinput.Text = "User Name"; } if (string.IsNullOrEmpty(passwordinput.Text.ToString()) == true) { pass_click_check = false; passwordinput.Text = "Password"; passwordinput.PasswordChar = '\0'; } if (string.IsNullOrEmpty(emailinput.Text.ToString()) == true) { email_click_check = false; emailinput.Text = "Email"; } if (user_click_check == false) { usernameinput.ForeColor = Color.FromArgb(100, 100, 100); panel1.BackColor = Color.FromArgb(190, 40, 40); proced = false; } if (pass_click_check == false) { passwordinput.ForeColor = Color.FromArgb(100, 100, 100); panel2.BackColor = Color.FromArgb(190, 40, 40); proced = false; } if (email_click_check == false) { emailinput.ForeColor = Color.FromArgb(100, 100, 100); panel3.BackColor = Color.FromArgb(190, 40, 40); proced = false; } if (proced == true) { string connectionString = "datasource=127.0.0.1;port=3306;username=root;password=;database=scorpio;"; // Select all string query = "SELECT * FROM user"; MySqlConnection databaseConnection = new MySqlConnection(connectionString); MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection); commandDatabase.CommandTimeout = 60; MySqlDataReader reader; try { databaseConnection.Open(); reader = commandDatabase.ExecuteReader(); // Success, now list // If there are available rows if (reader.HasRows) { while (reader.Read()) { string userName = (string)reader["User_name"]; string email = (string)reader["Email"]; if (string.Compare(userName, usernameinput.Text.ToString()) == 0 || string.Compare(email, emailinput.Text.ToString()) == 0) { if (string.Compare(userName, usernameinput.Text.ToString()) == 0) { panel1.BackColor = Color.FromArgb(190, 40, 40); } if (string.Compare(email, emailinput.Text.ToString()) == 0) { panel3.BackColor = Color.FromArgb(190, 40, 40); incorrectpanel.Text = "This email is already in use"; } incorrectpanel.Visible = true; databaseConnection.Close(); return; } } string sa = DateTime.Now.ToString("yyyy/M/dd"); string insert = "INSERT INTO `user` (`First_name`, `Last_name`, `User_name`, `Email`, `Password`, `Phone_no`, `Birth_date`,`joined`, `info_show`,`other_show`, `dp`) VALUES(NULL, NULL, '" + usernameinput.Text + "','" + emailinput.Text + "', '" + passwordinput.Text + "', NULL, NULL,'" + sa + "' ,'1','1', 'default.png')"; // MessageBox.Show(insert); MySqlConnection insertconnection = new MySqlConnection(connectionString); insertconnection.Open(); MySqlCommand insertcommand = new MySqlCommand(insert, insertconnection); MySqlDataReader myinsert = insertcommand.ExecuteReader(); //MessageBox.Show("Done"); insertconnection.Close(); user_log_in.UserID = usernameinput.Text; this.Hide(); var info = new info(); info.Closed += (s, args) => this.Close(); info.Show(); return; } else { Console.WriteLine("No rows found."); } databaseConnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }