using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace Air_Reservation_System
{
public partial class Form1 : Form
{
SqlConnection con;
SqlDataReader read;
SqlCommand cmd;
public Form1()
{
con = new SqlConnection("Data Source=SAADCHIPPA\\SQLEXPRESS;Initial Catalog=air_reservation;Integrated Security=True");
}
public void clear() {
textBox1.Text = "";
textBox2.Text = "";
}
private void Form1_Load(object sender, EventArgs e)
{
this.ActiveControl = textBox1;
}
private void button1_Click(object sender, EventArgs e)
{
try
{
con.Open();
cmd = new SqlCommand("select username,password from Login where username=@user and password=@pass", con);
cmd.Parameters.AddWithValue("@user", textBox1.Text);
cmd.Parameters.AddWithValue("@pass", textBox2.Text);
read = cmd.ExecuteReader();
if (read == null)
{
MessageBox.Show("The data is not fatched by the reader", "Data Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
if (read.HasRows)
{
MessageBox.Show("Welcome" + " " + " " + textBox1.Text + " ", "Welcome", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
Search sc = new Search();
sc.Show();
}
else
{
MessageBox.Show("User Name & Password is invalid", "Information Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
con.Dispose();
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, " ", MessageBoxButtons.OK, MessageBoxIcon.Error);
MessageBox.Show(ex.StackTrace, " ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}