public static string taoDonDatTour(string idTour, string idNgay, string idKH, string soTE, string soNL, string tien) { Debug.WriteLine(idTour + " " + idNgay + " " + idKH + " " + soTE + " " + soNL + " " + tien + " "); DonDatTour donDatTour = new DonDatTour(); donDatTour.ChoNL = Convert.ToInt32(soNL); donDatTour.ChoTE = Convert.ToInt32(soTE); donDatTour.MaTour = Convert.ToInt32(idTour); donDatTour.NgayDat = DateTime.Now; //DateTime.UtcNow.Date; donDatTour.TienDaThanhToan = Convert.ToInt32(tien); donDatTour.MaNgaydi = Convert.ToInt32(idNgay); donDatTour.TrangThai = 0; donDatTour.MaKH = Convert.ToInt32(idKH); DonDatTourModel donDatTourModel = new DonDatTourModel(); if (donDatTourModel.taoDonDatTour_NV(donDatTour)) { // Response.Redirect("toanthanhthanhtoan.aspx?id=1"); return("true"); } else { return("false"); } // return "ok"; }
public int ThemDonDatTour(DonDatTour donDatTour, int tien) { //Debug.WriteLine("ma ngay di ___ " + donDatTour.MaNgaydi); try { SqlCommand cmd = new SqlCommand("taoDonHang", cn.connect()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idtour", donDatTour.MaTour); cmd.Parameters.AddWithValue("@ngay", donDatTour.NgayDat); cmd.Parameters.AddWithValue("@idkh", donDatTour.MaKH); // cmd.Parameters.AddWithValue("@tien", donDatTour.TienDaThanhToan); // cmd.Parameters.AddWithValue("@tt", donDatTour.TrangThai); cmd.Parameters.AddWithValue("@ghichu", xuLy.locKiTu(donDatTour.GhiChu)); cmd.Parameters.AddWithValue("@maThoiGian", donDatTour.MaNgaydi); cmd.Parameters.AddWithValue("@iMaDonDatTour", SqlDbType.Int).Direction = ParameterDirection.Output; //cnn.Open(); int c = cmd.ExecuteNonQuery(); // Debug.WriteLine("cmd1 " + c); String maDonDatTour = cmd.Parameters["@iMaDonDatTour"].Value.ToString(); // Debug.WriteLine("id don dat tour: " + maDonDatTour); SqlCommand cmd2 = new SqlCommand("taoChiTietDonHang", cn.connect()); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@madon", maDonDatTour); cmd2.Parameters.AddWithValue("@nl", donDatTour.ChoNL); cmd2.Parameters.AddWithValue("@te", donDatTour.ChoTE); int k1 = cmd2.ExecuteNonQuery(); sp_capNhatTrangThaiDonHang(maDonDatTour, "", 0); SqlCommand cmd3 = new SqlCommand("themGiaoDich", cn.connect()); cmd3.CommandType = CommandType.StoredProcedure; cmd3.Parameters.AddWithValue("@iMaDonTOur", maDonDatTour); cmd3.Parameters.AddWithValue("@trangThai", 0); cmd3.Parameters.AddWithValue("@thoigian", donDatTour.NgayDat); cmd3.Parameters.AddWithValue("@tien", tien); cmd3.Parameters.AddWithValue("@iMaGiaoDich", SqlDbType.Int).Direction = ParameterDirection.Output; // int k = cmd3.ExecuteNonQuery(); int x3 = cmd3.ExecuteNonQuery(); // Debug.WriteLine("cmd3 " + x3); int maGiaoDich = Convert.ToInt32(cmd3.Parameters["@iMaGiaoDich"].Value.ToString()); // Debug.WriteLine("Ma Giao Dich " + maGiaoDich); return(maGiaoDich); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("messeage: loi xxx " + ex.Message); return(0); } }
protected void btnDatChuaThanhToan_Click(object sender, EventArgs e) { DonDatTour donDatTour = new DonDatTour(); donDatTour.ChoNL = Convert.ToInt32(iNL.Value); donDatTour.ChoTE = Convert.ToInt32(iTE.Value); donDatTour.MaTour = Convert.ToInt32(tour.Value); Debug.WriteLine("ma tour" + tour.Value); donDatTour.GhiChu = txtGhiChu.Text; donDatTour.NgayDat = DateTime.Now; //DateTime.UtcNow.Date; donDatTour.TienDaThanhToan = Convert.ToInt32(tien_tt.Value); //tienThanhToan_(tour.Value.ToString(), Convert.ToInt32(iTE.Value), Convert.ToInt32(iNL.Value)); donDatTour.MaNgaydi = Convert.ToInt32(maTG.Value); donDatTour.TrangThai = 0; donDatTour.MaKH = 1; if (datTourController.ThemDonDatTour_chuaThanhToan(donDatTour)) { Response.Redirect("toanthanhthanhtoan.aspx?id=1"); } else { Response.Redirect("toanthanhthanhtoan.aspx?id=0"); } }
protected void btnDatVe_Click(object sender, EventArgs e) { if (tour.Value != null && maTG.Value != null && iNL.Value != null && iTE.Value != null) { int i = Convert.ToInt32(tourController.kiemTraSoChoCon(tour.Value, maTG.Value)); int s = Convert.ToInt32(iTE.Value); Debug.WriteLine("idso " + i + " " + (Convert.ToInt32(iNL.Value) + Convert.ToInt32(iTE.Value))); if (i >= (Convert.ToInt32(iNL.Value) + Convert.ToInt32(iTE.Value))) { //Get Config Info string vnp_Returnurl = ConfigurationManager.AppSettings["vnp_Returnurl"]; //URL nhan ket qua tra ve string vnp_Url = ConfigurationManager.AppSettings["vnp_Url"]; //URL thanh toan cua VNPAY string vnp_TmnCode = ConfigurationManager.AppSettings["vnp_TmnCode"]; //Ma website string vnp_HashSecret = ConfigurationManager.AppSettings["vnp_HashSecret"]; //Chuoi bi mat if (!phanTramDat.Text.Equals("none")) { // Debug.WriteLine(Convert.ToInt32(tienThanhToan_)); DonDatTour donDatTour = new DonDatTour(); donDatTour.ChoNL = Convert.ToInt32(iNL.Value); donDatTour.ChoTE = Convert.ToInt32(iTE.Value); donDatTour.MaTour = Convert.ToInt32(tour.Value); donDatTour.GhiChu = txtGhiChu.Text; donDatTour.NgayDat = DateTime.Now; //DateTime.UtcNow.Date; donDatTour.TienDaThanhToan = Convert.ToInt32(tien_tt.Value); //tienThanhToan_(tour.Value.ToString(), Convert.ToInt32(iTE.Value), Convert.ToInt32(iNL.Value)); donDatTour.MaNgaydi = Convert.ToInt32(maTG.Value); donDatTour.TrangThai = 0; donDatTour.MaKH = Convert.ToInt32(Session["maKH"].ToString()); float phantram = (float)Convert.ToDouble(phanTramDat.SelectedValue); float tien_1 = Convert.ToInt32(tien_tt.Value) * phantram; int tien_ = Convert.ToInt32(tien_1); Debug.WriteLine(Convert.ToInt32(tien_tt.Value) + " tien " + tien_1 + " ma thoi gian : " + maTG.Value); int maThanhToan = datTourController.themDonDatTour(donDatTour, tien_); if (maThanhToan != 0) { //Build URL for VNPAY VnPayLibrary vnpay = new VnPayLibrary(); vnpay.AddRequestData("vnp_Version", "2.0.0"); vnpay.AddRequestData("vnp_Command", "pay"); vnpay.AddRequestData("vnp_TmnCode", vnp_TmnCode); vnpay.AddRequestData("vnp_Locale", "vn"); vnpay.AddRequestData("vnp_CurrCode", "VND"); vnpay.AddRequestData("vnp_TxnRef", maThanhToan.ToString()); vnpay.AddRequestData("vnp_OrderInfo", "ghi chu"); vnpay.AddRequestData("vnp_OrderType", "other"); //default value: other vnpay.AddRequestData("vnp_Amount", (tien_ * 100).ToString()); vnpay.AddRequestData("vnp_ReturnUrl", vnp_Returnurl); vnpay.AddRequestData("vnp_IpAddr", Utils.GetIpAddress()); vnpay.AddRequestData("vnp_CreateDate", DateTime.Now.ToString("yyyyMMddHHmmss")); if (bank.SelectedItem != null && !string.IsNullOrEmpty(bank.SelectedItem.Value)) { vnpay.AddRequestData("vnp_BankCode", bank.SelectedItem.Value); Debug.WriteLine("bank " + bank.SelectedItem.Value); } string paymentUrl = vnpay.CreateRequestUrl(vnp_Url, vnp_HashSecret); // log.InfoFormat("VNPAY URL: {0}", paymentUrl); Debug.WriteLine(paymentUrl); Response.Redirect(paymentUrl); Debug.WriteLine("Dat TOur thanh Cong."); } else { Debug.WriteLine("Dat Tour THat Bai"); } } } else { Response.Redirect("loi.aspx?id=0"); } } else { Response.Redirect("loi.aspx?id=1"); } }
public int themDonDatTour(DonDatTour donDatTour, int tien) { return donDatTourModel.ThemDonDatTour(donDatTour, tien); }
public Boolean ThemDonDatTour_chuaThanhToan(DonDatTour donDatTour) { return donDatTourModel.ThemDonDatTour_chuaThanhToan(donDatTour); }