//If click on specific Menu Strip item then show that clicked form and hide this one. private void homeToolStripMenuItem_Click(object sender, EventArgs e) { this.Hide(); user_main ub = new user_main(label1.Text); ub.Show(); }
//login button private void button2_Click(object sender, EventArgs e) { //checks if user is already present in database or not sda = new SqlDataAdapter("Select Count(*) from Login where Username = '******' and Password = '******'", con.ActiveCon()); sda.Fill(dt); //if yes then login successful if (dt.Rows[0][0].ToString() == "1") { MessageBox.Show("Login Successful."); this.Hide(); //to show user's First name and Last Name in next all forms, passing name as value to user_main form call sda1 = new SqlDataAdapter("Select First_Name, Last_Name from Login where Username = '******' and Password = '******'", con.ActiveCon()); sda1.Fill(dt1); user_main mn = new user_main((dt1.Rows[0][0].ToString() + dt1.Rows[0][1].ToString()).ToString()); mn.Show(); } //if not then login error else { MessageBox.Show("Error! Please Check your Username or Password."); } }
//SignUp Button private void button5_Click(object sender, EventArgs e) { //datetime conversion string dateString = this.dateTimePicker1.Text; DateTime Date = Convert.ToDateTime(dateString.ToString()); SqlCommand cmd = new SqlCommand("", con.ActiveCon()); //add a new user and inserts its values in database and then login cmd.CommandText = "INSERT INTO Login (Username,Password,First_Name, Last_Name,Email, Birthday, Gender) VALUES (@username,@password,@frst_name, @lst_name, @email, @birthday,@gender)"; cmd.Parameters.AddWithValue("@username", textBox3.Text); cmd.Parameters.AddWithValue("@password", textBox4.Text); cmd.Parameters.AddWithValue("@frst_name", textBox5.Text); cmd.Parameters.AddWithValue("@lst_name", textBox6.Text); cmd.Parameters.AddWithValue("@email", textBox7.Text); cmd.Parameters.AddWithValue("@birthday", Date.ToShortDateString()); //radio buttons if (radioButton1.Checked) { cmd.Parameters.AddWithValue("@gender", "Male"); } else { cmd.Parameters.AddWithValue("@gender", "Female"); } cmd.ExecuteNonQuery(); //handling exception when mail is send try { //makes a mail message MailMessage mail = new MailMessage(); //makes a new smtp server SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"); //admins email id mail.From = new MailAddress("*****@*****.**"); //users email id mail.To.Add(textBox7.Text); //subject of mail mail.Subject = "Mobile Inventory System - Sign Up Successful"; //body of mail mail.Body = "Welcome " + textBox5.Text + ". You have been successfully signed up in Mobile Inventory System.\n\nYour username is: " + textBox3.Text + " and Password is: " + textBox4.Text; //port =25 SmtpServer.Port = 25; //username and password of admin SmtpServer.Credentials = new System.Net.NetworkCredential("faiqtestemail", "seecs@123"); SmtpServer.EnableSsl = true; //mail send SmtpServer.Send(mail); //success MessageBox.Show("Sign Up Successfull.\nA welcome mail is send to your email address also."); //redirects to main form this.Hide(); sda1 = new SqlDataAdapter("Select First_Name, Last_Name from Login where Username = '******' and Password = '******'", con.ActiveCon()); sda1.Fill(dt1); user_main mn = new user_main((dt1.Rows[0][0].ToString() + dt1.Rows[0][1].ToString()).ToString()); mn.Show(); } //exception occurs catch (Exception ex) { MessageBox.Show(ex.ToString()); } }