public bool DatTour_Update(DatTour data)
{
bool check = false;
try
{
using (SqlCommand dbCmd = new SqlCommand("sp_DatTour_Update", openConnection()))
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@ID", data.ID));
dbCmd.Parameters.Add(new SqlParameter("@IDTour", data.IDTour));
dbCmd.Parameters.Add(new SqlParameter("@IDKhachHang", data.IDKhachHang));
dbCmd.Parameters.Add(new SqlParameter("@HoTen", data.HoTen));
dbCmd.Parameters.Add(new SqlParameter("@DienThoai", data.DienThoai));
dbCmd.Parameters.Add(new SqlParameter("@Email", data.Email));
dbCmd.Parameters.Add(new SqlParameter("@SoNL", data.SoNL));
dbCmd.Parameters.Add(new SqlParameter("@SoTE", data.SoTE));
dbCmd.Parameters.Add(new SqlParameter("@ThanhTien", data.ThanhTien));
int r = dbCmd.ExecuteNonQuery();
if (r > 0)
{
check = true;
}
}
//Clear cache
System.Web.HttpContext.Current.Cache.Remove("DatTour");
}
catch
{
}
return(check);
}
public List <DatTour> DatTour_GetByTop(string Top, string Where, string Order)
{
List <DatTour> list = new List <DatTour>();
using (SqlCommand dbCmd = new SqlCommand("sp_DatTour_getByTop", openConnection()))
{
DatTour obj = new DatTour();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Top", Top));
dbCmd.Parameters.Add(new SqlParameter("@Where", Where));
dbCmd.Parameters.Add(new SqlParameter("@Order", Order));
SqlDataReader dr = dbCmd.ExecuteReader();
dr.Close();
dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.DatTourIDataReader(dr));
}
}
dr.Close();
obj = null;
}
return(list);
}
//Delete
public async Task <IActionResult> Delete(int MaDat)
{
string webRootPath = _hostingEnviroment.WebRootPath;
DatTour dattour = await _db.DatTours.FindAsync(MaDat);
_db.DatTours.Remove(dattour);
await _db.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
public IActionResult detailTour(int?id)
{
DatTour a = new DatTour();
if (id == null)
{
return(NotFound());
}
var Tourdetail = _db.Tours.Where(n => n.MaTuyenDuong == id).ToList();
var tuyenduong = _db.TuyenDuongs.SingleOrDefault(n => n.MaTuyenDuong == id);
ViewBag.image = tuyenduong.Anh;
ViewBag.noidung = tuyenduong.NoiDung;
return(View(Tourdetail));
}
public async Task <IActionResult> booking(int id, ChiTietDatTour ctdt, string giatour)
{
DatTour dattour = new DatTour();
if (ModelState.IsValid)
{
dattour.NgayDat = DateTime.Now.ToString();
dattour.MaKH = int.Parse(HttpContext.Session.GetString("khachhangid"));
_db.DatTours.Add(dattour);
await _db.SaveChangesAsync();
ctdt.MaDat = dattour.MaDat;
ctdt.MaTour = id;
ctdt.TongTien = (int.Parse(giatour) * ctdt.SoNguoiDiTour).ToString();
_db.ChiTietDatTours.Add(ctdt);
await _db.SaveChangesAsync();
int a = int.Parse(HttpContext.Session.GetString("count_tour"));
HttpContext.Session.SetString("count_tour", (a + 1).ToString());
return(RedirectToAction(nameof(Index)));
}
return(View());
}
protected void btnThanhToan_Click(object sender, EventArgs e)
{
string soNL, soTE;
if (Session["KhachHang_Login"] == null)
{
if (ValidForm(false))
{
string hoten = HoTen.Text;
string std = DienThoai.Text;
string email = Email.Text;
soNL = _SoNL.Text;
soTE = _SoTE.Text;
DatTour dt = new DatTour();
dt.HoTen = hoten;
dt.DienThoai = std;
dt.Email = email;
dt.SoNL = soNL;
dt.SoTE = soTE;
dt.IDTour = tour.ID;
dt.ThanhTien = (int.Parse(soNL) * Double.Parse(tour.GiaTourNL) + int.Parse(soTE) * Double.Parse(tour.GiaTourTE)).ToString();
if (obj.DatTour_Insert(dt))
{
string ms = "Số tiền cần thanh toán " + dt.ThanhTien + " VNĐ";
Response.Write("<script>alert('" + ms + "');</script>");
Response.Write("<script>window.location.href=\"Default.aspx\";</script>");
}
else
{
Response.Write("<script>alert('Lỗi khi đặt tour');</script>");
}
}
else
{
}
}
else
{
if (ValidForm(true))
{
soNL = SoNL.Text;
soTE = SoTE.Text;
DatTour dt = new DatTour();
try
{
string username = (string)Session["KhachHang_Login"];
KhachHang kh = new KhachHangBUS().KhachHang_GetByTop("", "TenDangNhap = '" + username + "'", "").ElementAt(0);
dt.IDKhachHang = kh.ID;
dt.SoNL = soNL;
dt.SoTE = soTE;
dt.IDTour = tour.ID;
double tien = (int.Parse(soNL) * Double.Parse(tour.GiaTourNL) + int.Parse(soTE) * Double.Parse(tour.GiaTourTE));
dt.ThanhTien = (tien * 95 / 100).ToString();
if (obj.DatTour_Insert(dt))
{
string ms = "Số tiền cần thanh toán " + dt.ThanhTien + " VNĐ. Đã giảm " + tien * 5 / 100;
Response.Write("<script>alert('" + ms + "');</script>");
Response.Write("<script>window.location.href=\"Default.aspx\";</script>");
}
else
{
Response.Write("<script>alert('Lỗi khi đặt tour');</script>");
}
}
catch { }
}
else
{
}
}
}
public bool DatTour_Update(DatTour data)
{
return(obj.DatTour_Update(data));
}
public bool DatTour_Insert(DatTour data)
{
return(obj.DatTour_Insert(data));
}
