public DetailKeranjang_Class getById(int Id)
{
try
{
string query = "SELECT * FROM tb_detail_keranjang WHERE id_detail = " + Id + ";";
OpenConnection();
DetailKeranjang_Class hasil = myConn.Query <DetailKeranjang_Class>(query, new { id_cust = Id }).FirstOrDefault();
closeConnection();
return(hasil);
}
catch (Exception ex)
{
throw ex;
}
}
public void insertDetailKeranjang(DetailKeranjang_Class detail_keranjang)
{
try
{
int id_detail = detail_keranjang.Id_detail;
int id_keranjang = detail_keranjang.Id_keranjang;
int id_dvd = detail_keranjang.Id_dvd;
int qty = detail_keranjang.Qty;
int harga_jual = detail_keranjang.Harga_jual;
int total_harga = detail_keranjang.Total_harga;
string query = "INSERT INTO tb_detail_keranjang VALUES (null,'" + id_keranjang + "','" + id_dvd + "'" +
",'" + qty + "','" + harga_jual + "','" + total_harga + "');";
OpenConnection();
var hasil = myConn.Execute(query);
closeConnection();
} catch (Exception ex)
{
throw ex;
}
}
