예제 #1
0
 public void AddTransactionPassenger(TransactionPassenger t)
 {
     string date = string.Format("{0}-{1}-{2}", t.Tanggal.Year, t.Tanggal.Month, t.Tanggal.Day);
     string cmd = string.Format("INSERT INTO passanger (notransaction,tanggal,jenis,gate,maskapai,amount,passengername,flightno) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",
             t.TransactionNo, date, t.JenisPenerbangan, t.Gate, t.Maskapai, t.Amount, t.PassengerName, t.FlightNo);
     MySqlConnection conn = new MySqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);
     conn.Open();
     MySqlCommand command = new MySqlCommand(cmd, conn);
     command.ExecuteReader();
     conn.Close();
 }
예제 #2
0
 public JsonResult Bayar(TransactionPassenger transaction)
 {
     try
     {
         transaction.TransactionNo = Guid.NewGuid().ToString().GetHashCode().ToString("x");
         passengerRepo.AddTransactionPassenger(transaction);
         return Json(new { error = false, data = transaction }, JsonRequestBehavior.AllowGet);
     }
     catch (ApplicationException ex)
     {
         return Json(new { error = true, data = ex.Message }, JsonRequestBehavior.AllowGet);
     }
 }