Exemple #1
0
        private void b3_Click(object sender, EventArgs e)
        {
            psglogin p1 = new psglogin();

            p1.Tag = this;
            p1.Show(this);
            Hide();
        }
 private void b1_Click(object sender, EventArgs e)
 {
     if (c1.Text == "PASSENGER")
     {
         psglogin p = new psglogin();
         p.Tag = this;
         p.Show(this);
         Hide();
     }
     if (c1.Text == "DRIVER")
     {
         DriverLogin d = new DriverLogin();
         d.Tag = this;
         d.Show(this);
         Hide();
     }
 }
        public Psgapprovement(String Text1, String Text2)
        {
            InitializeComponent();
            SqlConnection  con = new SqlConnection();
            SqlCommand     com = new SqlCommand();
            SqlDataAdapter d   = new SqlDataAdapter();

            con.ConnectionString = "Data Source=DESKTOP-4K792AB;" + "Initial Catalog=Taxi project;" + "Integrated Security=True;";
            com.Connection       = con;
            try
            {
                con.Open();
                com.CommandType = CommandType.Text;
                com.CommandText = "Select * from Coordinate,OriginCity,DestinationCity where Coordinate.OID=OriginCity.ID and Coordinate.DID=DestinationCity.ID and OriginCity.CityName=@Ocity and DestinationCity.CityName=@Dcity";
                com.Parameters.Add("@Ocity", Text1);
                com.Parameters.Add("@Dcity", Text2);
                d.SelectCommand = com;
                DataTable dt6 = new DataTable();
                d.Fill(dt6);
                t1.Text = dt6.Rows[0]["Cost"].ToString();
                t2.Text = dt6.Rows[0]["Time"].ToString();
                String BID = dt6.Rows[0]["BID"].ToString();

                com.CommandText = "insert into Travel([BID],[TDate]) values(@BID,GetDate())";
                com.Parameters.Add("@BID", BID);
                com.ExecuteNonQuery();
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Travel provided soon!");
                psglogin p1 = new psglogin();
                p1.Tag = this;
                p1.Show(this);
                Hide();
            }
        }
Exemple #4
0
        private void button1_Click_1(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();

            con.ConnectionString = "Data Source=DESKTOP-4K792AB;" + "Initial Catalog=Taxi project;" + "Integrated Security=True;";
            SqlCommand     com = new SqlCommand();
            SqlDataAdapter da  = new SqlDataAdapter();

            com.Connection  = con;
            com.CommandText = "select * from passenger where passenger.ID=@User and Passenger.NCode=@Pass";

            try
            {
                con.Open();
                com.Parameters.AddWithValue("@User", t1.Text);
                com.Parameters.AddWithValue("@Pass", t2.Text);
                da.SelectCommand = com;
                DataTable dt1 = new DataTable();
                da.Fill(dt1);
                t1.Text = dt1.Rows[0]["ID"].ToString();
                MessageBox.Show(t1.Text + "WAS FOUND!!");
                con.Close();

                PTRequest p = new PTRequest();
                p.Tag = this;
                p.Show(this);
                Hide();
            }
            catch (Exception ex)
            {
                MessageBox.Show("National Code Is Already Available!");
                psglogin p1 = new psglogin();
                p1.Tag = this;
                p1.Show(this);
                Hide();
            }
        }