public List <Mobil> GetAll()
{
string query = "select m.mobil,m.merk,m.model,m.tahun_buat,m.no_Pol,m.harga,m.warna,m.status,r.nama from mobil m join rental r on m.id = r.id";
MySqlDataReader reader;
List <Mobil> mobil = new List <Mobil>();
try
{
conn.Open();
MySqlCommand myCommand = new MySqlCommand(query, conn);
reader = myCommand.ExecuteReader();
while (reader.Read())
{
Mobil Newmobil = new Mobil();
Newmobil.merk = (string)reader[0];
Newmobil.model = (string)reader[1];
Newmobil.tahun_buat = (DateTime)reader[2];
Newmobil.no_Pol = (string)reader[3];
Newmobil.harga = (decimal)reader[4];
Newmobil.warna = (string)reader[5];
Newmobil.status = (Boolean)reader[6];
Rental rental = new Rental();
Newmobil.nama = rental.name;
Newmobil.nama = (string)reader[7];
mobil.Add(Newmobil);
}
reader.Close();
conn.Close();
}
catch (Exception ex)
{
}
return(mobil);
}
public void Add(Mobil mobil, Rental rental)
{
MySqlCommand cmd = new MySqlCommand("insert into mobil values(NULL,@merk,@model,@tahun_buat,@no_Pol,@id_rental,@harga,@warna,@status)", conn);
conn.Open();
cmd.Parameters.AddWithValue("@merk", mobil.merk);
cmd.Parameters.AddWithValue("@model", mobil.model);
cmd.Parameters.AddWithValue("@tahun_buat", mobil.tahun_buat);
cmd.Parameters.AddWithValue("@no_Pol", mobil.no_Pol);
cmd.Parameters.AddWithValue("@id_rental", rental.id);
cmd.Parameters.AddWithValue("@harga", mobil.harga);
cmd.Parameters.AddWithValue("@warna", mobil.warna);
cmd.Parameters.AddWithValue("@status", mobil.status);
cmd.ExecuteNonQuery();
mobil.id_mobil = cmd.LastInsertedId;
conn.Close();
}
public int update(Mobil mobil)
{
int count = 0;
try
{
MySqlCommand cmd = new MySqlCommand("update mobil set merk=@merk,model=@model,tahun_buat=@tahun_buat,no_Pol=@no_Pol,harga=@harga,warna=@warna,status=@status where id_mobil=@id_mobil", conn);
conn.Open();
cmd.Parameters.AddWithValue("@merk", mobil.merk);
cmd.Parameters.AddWithValue("@model", mobil.model);
cmd.Parameters.AddWithValue("@tahun_buat", mobil.tahun_buat);
cmd.Parameters.AddWithValue("@no_Pol", mobil.no_Pol);
cmd.Parameters.AddWithValue("@harga", mobil.harga);
cmd.Parameters.AddWithValue("@warna", mobil.warna);
cmd.Parameters.AddWithValue("@status", mobil.status);
count = cmd.ExecuteNonQuery();
conn.Close();
}
catch (MySqlException ex)
{
}
return(count);
}