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);
}
