public bool CreateSubject(string dateOfStart, string dateOfEnd, int price, bool closed, Car car, User owner)
{
CarOwn carOwn = new CarOwn();
carOwn.dateOfStart = dateOfStart;
carOwn.dateOfEnd = dateOfEnd;
carOwn.price = price;
carOwn.closed = closed;
carOwn.car = car;
carOwn.owner = owner;
subjectDao.CreateSubject(carOwn);
return(true);
}
//Insert statement
public void CreateSubject(CarOwn carOwn)
{
//open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
NpgsqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "Insert into public.carowns(dateofstart, dateofend, price, closed) values(@dateofstart, @dateofend, @price, @closed) ";
cmd.Parameters.AddWithValue("@dateofstart", carOwn.dateOfStart);
cmd.Parameters.AddWithValue("@dateofend", carOwn.dateOfEnd);
cmd.Parameters.AddWithValue("@price", carOwn.price);
cmd.Parameters.AddWithValue("@closed", carOwn.closed);
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
}
public List <CarOwn> GetSubjects()
{
string query = "SELECT * FROM carowns";
List <CarOwn> carOwns = new List <CarOwn>();
if (this.OpenConnection() == true)
{
//Create Command
NpgsqlCommand cmd = new NpgsqlCommand(query, connection);
//Create a data reader and Execute the command
NpgsqlDataReader dataReader = cmd.ExecuteReader();
string idteacher = string.Empty;
string login = string.Empty;
string password = string.Empty;
//Read the data and store them in the list
while (dataReader.Read())
{
CarOwn carOwn = new CarOwn();
string iduser = (dataReader["id"] + "");
carOwn.id = int.Parse(iduser);
carOwn.dateOfStart = (string)dataReader["dateofstart"];
carOwn.dateOfEnd = (string)dataReader["dateofend"];
carOwn.price = (int)dataReader["price"];
carOwn.closed = (bool)dataReader["closed"];
carOwns.Add(carOwn);
}
//close Data Reader
dataReader.Close();
//close Connection
this.CloseConnection();
//return list to be displayed
return(carOwns);
}
else
{
return(carOwns);
}
}
