public Trip_Started(string from_par, string to_par, DriverData Cfm, int Trip_id, int Code_id)//*********** { InitializeComponent(); code_id = Code_id; trip_id = Trip_id; from.Text = from2 = from_par; to.Text = to2 = to_par; CFM = Cfm; }
private void Accept_Request_Click_1(object sender, EventArgs e) { SqlCommand cmd; con.Open(); cmd = new SqlCommand("select weight from location where loc_name like '" + from1 + "'", con); int from_weight = (int)cmd.ExecuteScalar(); con.Close(); con.Open(); cmd = new SqlCommand("select weight from location where loc_name like '" + to1 + "'", con); int to_weight = (int)cmd.ExecuteScalar(); con.Close(); int fee = 0; if (from_weight > to_weight) { fee = ((from_weight - to_weight) * 5); } else { fee = ((from_weight - to_weight) * -5); } con.Open(); cmd = new SqlCommand("insert into Trip (Pickup_Location , Destination , Distance, Passenger_ID_FK , Driver_ID_FK, Fee)values (@Pickup_Location , @Destination , @Distance, @Passenger_ID_FK , @Driver_ID_FK,@Fee);", con); SqlParameter par; par = new SqlParameter("@Pickup_Location", from1); cmd.Parameters.Add(par); par = new SqlParameter("@Destination", to1); cmd.Parameters.Add(par); SqlCommand cmd2 = new SqlCommand("select ID from Passenger where Email like '" + pp_email + "'", con); int pp_id = (int)cmd2.ExecuteScalar(); cmd2 = new SqlCommand("select ID from Driver where Email like '" + dd_mail + "'", con); int dd_id = (int)cmd2.ExecuteScalar(); par = new SqlParameter("@Passenger_ID_FK", pp_id);// cmd.Parameters.Add(par); par = new SqlParameter("@Driver_ID_FK", dd_id); cmd.Parameters.Add(par); par = new SqlParameter("@Distance", (int)(fee / 5)); cmd.Parameters.Add(par); par = new SqlParameter("@Fee", fee); cmd.Parameters.Add(par); cmd.ExecuteNonQuery(); con.Close(); con.Open(); cmd = new SqlCommand("select max(ID)from Trip", con); int trip_id = (int)cmd.ExecuteScalar(); con.Close(); DriverData fm2 = new DriverData(dd_mail, trip_id); fm2.Show(); Trip_Started fm = new Trip_Started(from1, to1, fm2, trip_id, code_id);// fm.Show(); this.Close(); }