public ReservationCustomer(_291CarRental.database data, string[] dataString)
{
InitializeComponent();
this.data = data;
this.dataString = dataString;
carID = Guid.Parse(dataString[0]);
}
/*remember to change back the database into _291GroupProject.database*/
public addRowCustomer(_291CarRental.database data, Guid CarID, ReservationCustomer theOpenResForm)
{
InitializeComponent();
this.data = data;
data.myCommand.CommandText = "SELECT UserID from Users where Users.username =@uname";
data.myCommand.Parameters.AddWithValue("uname", data.usr);
this.customerID = Guid.Parse(data.myCommand.ExecuteScalar().ToString());
this.CarID = CarID;
this.theOpenResForm = theOpenResForm;
}
public _291CarRental.database datab; //= new _291CarRental.database(@"Data Source=X-MK1;Initial Catalog = 291GroupProject;Integrated Security = True");
/*
* private SqlDataReader dataRead;
* private SqlCommand dataCommand;
* private SqlConnection dataConnection = new SqlConnection(@"Data Source=X-MK1;Initial Catalog = 291GroupProject;Integrated Security = True");
*/
public Form4(_291CarRental.database datab)
{
InitializeComponent();
this.datab = datab;
/*
* dataConnection.Open();
* dataCommand = new SqlCommand();
* dataCommand.Connection = dataConnection;
*/
dataString = new string[CarData.Columns.Count];
}
public addRow(_291CarRental.database data, Guid CarID, Reservation theOpenResForm)
{
InitializeComponent();
this.data = data;
//extract the userid for later use
data.myCommand.CommandText = "SELECT UserID from Users where Users.username = @uname";
data.myCommand.Parameters.AddWithValue("uname", data.usr);
customerID = (Guid)data.myCommand.ExecuteScalar();
data.myCommand.Parameters.Clear();
//this.customerID = customerID;
this.CarID = CarID;
this.theOpenResForm = theOpenResForm;
}
public Reservation(_291CarRental.database data, string[] carSelectedData)
{
InitializeComponent();
this.data = data;
this.carSelectedData = carSelectedData;
}
