public void setData(int passengerid, int sellerID, SQLConnector scon)
{
sCon = scon;
dS = new DataSet();
PassengerID = passengerid;
if (passengerid >= 0)
{
lb_id.Text = "Passenger-ID: " + passengerid;
}
//load DataSets
sDA_sellers = sCon.getSellers_List_FullName(dS, null);
sDA_customers = sCon.getCustomers_List_FullName(dS, null);
sDA_passenger = sCon.getPassenger(dS, "passenger", null, PassengerID);
//set Data to Form-Elements
lBox_customer.DataSource = dS.Tables["customers"];
lBox_customer.DisplayMember = "CustomerName";
lBox_customer.ValueMember = "CustomerID";
coB_select_seller.DataSource = dS.Tables["sellers"];
coB_select_seller.DisplayMember = "SellerName";
coB_select_seller.ValueMember = "SellerID";
if (sellerID >= 0) coB_select_seller.SelectedValue = sellerID;
if (dS.Tables["passenger"].Rows.Count > 0)
{
if (sellerID < 0)
{
sDA_passenger_seller = sCon.getPassenger_Seller(dS, "passenger_seller", null, PassengerID);
if (dS.Tables["passenger_seller"].Rows.Count > 0) coB_select_seller.SelectedValue = dS.Tables["passenger_seller"].Rows[0]["sellerID"];
}
lb_id.Text = "Passenger-ID: " + dS.Tables["passenger"].Rows[0]["ID"];
lBox_customer.SelectedValue = dS.Tables["passenger"].Rows[0]["customerID"];
lBox_transaction.SelectedValue = dS.Tables["passenger"].Rows[0]["transactionID"];
nTB_price.Text = ((decimal)dS.Tables["passenger"].Rows[0]["price"]).ToString();
//if ((byte)dS.Tables["passenger"].Rows[0]["is_paid"] == 0) cB_is_paid.Checked = false; else cB_is_paid.Checked = true;
cB_is_paid.Checked = Convert.ToBoolean((byte)dS.Tables["passenger"].Rows[0]["is_paid"]);
dTP_booked_date.Value = (DateTime)dS.Tables["passenger"].Rows[0]["booked_time"];
dTP_booked_time.Value = (DateTime)dS.Tables["passenger"].Rows[0]["booked_time"];
}
}
