public int bayar(int id_tiket) { pinguin_airEntities3 pinguin = new pinguin_airEntities3(); tiket tkt = pinguin.tiket.Find(id_tiket); tkt.status = "Lunas"; string path = Path.GetRandomFileName(); path = path.Replace(".", ""); tkt.kode_booking = path; pinguin.SaveChanges(); return(1); }
public int booking(int id_penerbangan, List <penumpang> penumpangs, int user_id) { pinguin_airEntities3 pinguin = new pinguin_airEntities3(); tiket tkt = new tiket(); tkt.id_penerbangan = id_penerbangan; string path = Path.GetRandomFileName(); path = path.Replace(".", ""); tkt.kode_bayar = path; tkt.kode_booking = "NULL"; tkt.status = "Belum Bayar"; tkt.user_id = user_id; tkt.waktu_booking = DateTime.Now; tkt.batas_waktu_bayar_atm = DateTime.Now.AddMinutes(60); tkt.batas_waktu_bayar_internet_banking = DateTime.Now.AddMinutes(30); penerbangan p = pinguin.penerbangan.Find(id_penerbangan); tkt.total_harga = penumpangs.Count() * p.harga; pinguin.tiket.Add(tkt); pinguin.SaveChanges(); penumpang pn; foreach (var a in penumpangs) { pn = new penumpang(); pn.id_tiket = tkt.id; pn.nama = a.nama; pn.nomor_identitas = a.nomor_identitas; pinguin.penumpang.Add(pn); pinguin.SaveChanges(); } return(0); }