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