protected void btnAdd_Click(object sender, EventArgs e)
{
TourDLEntities db = new TourDLEntities();
QLTour.Booking obj = new Booking();
if (txtGiaTien.Text == "")
{
lbErrordangky.Text = "Bạn chưa nhập đủ thông tin!!!";
}
else
{
obj = new QLTour.Booking();
//obj.MaVe = getmave();
//obj.MaVe = int.Parse(txtMaVe.Text);
obj.MaLT = cmbMaLT.SelectedValue;
obj.MaTour = cmbMaTour.SelectedValue;
obj.GiaTien = Int32.Parse(txtGiaTien.Text);
obj.MaNV = txtMaNV.Text;
obj.MaKH = cmbMaKH.SelectedValue;
obj.MaDDDL = cmbMaDDDL.SelectedValue;
obj.SLNguoiLon = Int32.Parse(cmbSLNL.SelectedValue);
obj.SLTreEm = Int32.Parse(cmbSLTE.SelectedValue);
obj.TrangThai = Int32.Parse(cmbTrangThai.SelectedValue);
string ngaybk = cmbThangbk.SelectedValue + "/" + cmbNgaybk.SelectedValue + "/" + cmbNambk.SelectedValue;
obj.NgayBook = Convert.ToDateTime(ngaybk);
db.Booking.Add(obj);
db.SaveChanges();
Response.Redirect("BooKings.aspx");
}
}
protected void btnRating_Command(object sender, CommandEventArgs e)
{
string MaVe = e.CommandArgument.ToString();
int mave = Int32.Parse(MaVe);
QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == mave);
string matour = obj.MaTour;
string makh = obj.MaKH;
Response.Redirect("Reviews.aspx?MaTour=" + matour + "&MaVe=" + MaVe + "&MaKH=" + makh);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
// Sửa dữ liệu
int mv = Int32.Parse(txtMaVe.Text);
TourDLEntities db = new TourDLEntities();
string q = Session["username"].ToString();
QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == mv);
if (obj == null)
{
Response.Redirect("Bookings.aspx");
}
else
{
if (txtGiaTien.Text == "")
{
lbErrordangky.Text = "Bạn chưa nhập đủ thông tin!!!";
}
else
{
if (txtMaNV.Text == "" || q == txtMaNV.Text)
{
//obj.MaVe = txtMaVe.Text;
obj.MaVe = int.Parse(txtMaVe.Text);
obj.MaLT = cmbMaLT.SelectedValue;
obj.MaTour = cmbMaTour.SelectedValue;
obj.GiaTien = Int32.Parse(txtGiaTien.Text);
obj.MaNV = q;
obj.MaKH = cmbMaKH.SelectedValue;
obj.MaDDDL = cmbMaDDDL.SelectedValue;
obj.SLNguoiLon = Int32.Parse(cmbSLNL.SelectedValue);
obj.SLTreEm = Int32.Parse(cmbSLTE.SelectedValue);
obj.TrangThai = Int32.Parse(cmbTrangThai.SelectedValue);
string ngaybk = cmbThangbk.SelectedValue + "/" + cmbNgaybk.SelectedValue + "/" + cmbNambk.SelectedValue;
obj.NgayBook = Convert.ToDateTime(ngaybk);
db.SaveChanges();
Response.Redirect("Bookings.aspx");
}
else
{
lbErrordangky.Text = "Nhân viên bán tour mới có quyền sửa, Mã nhân viên: " + txtMaNV.Text;
}
}
}
}
catch
{
// Lỗi
}
}
//-------------------------------------------
//public string getIDBooking()
//{
// TourDLEntities db = new TourDLEntities();
// string maMax = db.Booking.Max(x => x.MaVe);
// //
// string ma;
// int a = int.Parse(maMax.Substring(2));
// a++;
// if (a < 10)
// {
// ma = "v00" + a;
// }
// else
// {
// ma = "v0" + a;
// }
// return ma;
// //TourDLEntities db = new TourDLEntities();
// //string maMax = db.Booking.Max(x => x.MaVe);
// ////
// //string ma;
// //int a = int.Parse(maMax.Substring(2));
// //a++;
// //if (a < 10)
// //{
// // ma = "v00" + a;
// //}
// //else
// //{
// // ma = "v0" + a;
// //}
// //return ma;
//}
//public string AutoGetma()
//{
// string matour = getIDBooking();
// int MTour = int.Parse(matour.Substring(3));
// MTour++;
// if (MTour < 10)
// {
// matour = "v00" + MTour;
// }
// else
// {
// matour = "v0" + MTour;
// }
// return matour;
//}
protected void lbtnDatTour_Click(object sender, EventArgs e)
{
try
{
TourDLEntities db = new TourDLEntities();
string matour = lbMaTour.Text.ToString();
//không cần check điều kiện
//get makh
string abc = Session["TaiKhoan"].ToString();
QLTour.KhachHang obj1 = db.KhachHang.FirstOrDefault(x => x.TaiKhoan == abc);
string makh = obj1.MaKH;
//get madddl
QLTour.CTTour obj2 = db.CTTour.FirstOrDefault(x => x.MaTour == matour);
string madddl = obj2.MaDDDL.ToString();
//get gia tour
QLTour.CTTour obj3 = db.CTTour.FirstOrDefault(x => x.MaTour == matour);
//dgvCTTour.DataSource = lst;
//dgvCTTour.DataBind();
int GiaNL = Int32.Parse(obj3.GiaveNL.ToString());
int GiaTE = Int32.Parse(obj3.GiaVeTE.ToString());
int SoNL = Int32.Parse(txtSoNL.Text);
int SoTE = Int32.Parse(txtSoTE.Text);
int GiaTour = Int32.Parse(txtGiaTour.Text);
int abcd = 0;
abcd = abcd + (GiaNL * SoNL) + (GiaTE * SoTE) + GiaTour;
QLTour.Booking obj = db.Booking.FirstOrDefault();//?
obj = new QLTour.Booking();
//obj.MaVe = AutoGetma();
obj.MaTour = lbMaTour.Text.ToString();
obj.SLNguoiLon = Int32.Parse(txtSoNL.Text);
obj.SLTreEm = Int32.Parse(txtSoTE.Text);
obj.MaLT = Request.QueryString["MaLT"].ToString();
obj.MaKH = makh;
obj.MaDDDL = madddl;
obj.MaNV = null;
obj.TrangThai = Int32.Parse("0");
obj.GiaTien = abcd;
//
db.Booking.Add(obj);
db.SaveChanges();
//Response.Write("<script>alert('đặt tour thành công. chúng tôi sẽ liên hệ với bạn sớm!');</script>");
Response.Redirect("Home.aspx");
}
catch (Exception)
{
Response.Write("<script>alert('Không thể đặt tour lúc này. vui lòng thử lại!');</script>");
}
}
public bool getVisibleDG1(string mave)
{
int abc = int.Parse(mave);
QLTour.Booking obj = db.Booking.First(x => x.MaVe == abc);
if (obj.DanhGia.Count(x => x.Diem != null) > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnXoa_Command(object sender, CommandEventArgs e)
{
try
{
int MaVe = Int32.Parse(e.CommandArgument.ToString());
TourDLEntities db = new TourDLEntities();
QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == MaVe);
if (obj != null)
{
db.Booking.Remove(obj);
db.SaveChanges();
getData();
}
}
catch
{
//
}
}
protected void btnXoa_Command(object sender, CommandEventArgs e)
{
string mave = e.CommandArgument.ToString();
int abc = Int32.Parse(mave);
QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == abc);
if (obj.TrangThai == 1)
{
Response.Redirect("Home.aspx");
//Response.Write("<script>alert('Bạn không thể xóa khi admin đã xác nhận tour thành công!');</script>");
}
else if (obj != null)
{
db.Booking.Remove(obj);
db.SaveChanges();
Response.Redirect("EditInfo.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["username"] == null || Session["username"].ToString() == "")
{
// Chưa đăng nhập
Response.Redirect("login.aspx");
}
else
{
getnambk();
getngaybk();
getthangbk();
getSLTE();
getSLNL();
getcmbmatour();
getcmbmalt();
//getcmbmanv();
//gettrangthai();
getcmbmadddl();
getcmbmakh();
// kiểm tra trường hợp sửa/thêm mới
// nếu url có dạng ?masp=123 => sửa, ngược lại là thêm mới
if (Request.QueryString["MaVe"] == null)
{
// thêm mới
txtMaVe.Text = Request.QueryString["MaVe"];
txtMaVe.Enabled = false;
btnSave.Visible = false;
btnAdd.Visible = true;
//txtMaVe.Enabled = true;
}
else
{
// Sửa
TourDLEntities db = new TourDLEntities();
btnSave.Visible = true;
btnAdd.Visible = false;
string q = Session["username"].ToString();
QLTour.NhanVien ob = db.NhanVien.FirstOrDefault(p => p.MaNV == q);
string quyen = ob.NghiepVu;
if (quyen == "SELL")
{
txtMaVe.Text = Request.QueryString["MaVe"];
txtMaVe.Enabled = false;
txtMaVe.CssClass = txtMaVe.CssClass + " form-control";
cmbMaTour.SelectedValue = Request.QueryString["MaTour"];
cmbMaTour.Enabled = false;
cmbMaTour.CssClass = cmbMaTour.CssClass + " form-control";
cmbMaLT.SelectedValue = Request.QueryString["MaLT"];
cmbMaLT.Enabled = false;
cmbMaLT.CssClass = cmbMaLT.CssClass + " form-control";
cmbMaKH.SelectedValue = Request.QueryString["MaKH"];
cmbMaKH.Enabled = false;
cmbMaKH.CssClass = cmbMaKH.CssClass + " form-control";
//--
cmbMaDDDL.SelectedValue = Request.QueryString["MaDDDL"];
cmbMaDDDL.Enabled = false;
cmbMaDDDL.CssClass = cmbMaDDDL.CssClass + " form-control";
//--
txtMaNV.Text = Request.QueryString["MaNV"];
txtMaNV.Enabled = false;
txtMaNV.CssClass = txtMaNV.CssClass + " form-control";
txtGiaTien.Text = Request.QueryString["GiaTien"];
txtGiaTien.Enabled = false;
txtGiaTien.CssClass = txtGiaTien.CssClass + " form-control";
cmbSLNL.SelectedValue = Request.QueryString["SLNguoiLon"];
cmbSLNL.Enabled = false;
cmbSLNL.CssClass = cmbSLNL.CssClass + " form-control";
cmbSLTE.SelectedValue = Request.QueryString["SLTreEm"];
cmbSLTE.Enabled = false;
cmbSLTE.CssClass = cmbSLNL.CssClass + " form-control";
// Query về db để lấy các thông tin còn lại
int mv = Int32.Parse(txtMaVe.Text);
QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == mv);
if (obj == null)
{
Response.Redirect("QLBooking.aspx");
}
else
{
cmbMaLT.Text = obj.MaLT;
cmbMaTour.Text = obj.MaTour;
txtGiaTien.Text = obj.GiaTien.ToString();
txtMaNV.Text = obj.MaNV;
cmbMaKH.SelectedValue = obj.MaKH.ToString();
cmbMaDDDL.Text = obj.MaDDDL;
cmbSLNL.SelectedValue = obj.SLNguoiLon.ToString();
cmbSLTE.SelectedValue = obj.SLTreEm.ToString();
cmbTrangThai.Text = obj.TrangThai.ToString();
cmbNambk.SelectedValue = obj.NgayBook.Value.Year.ToString();
cmbThangbk.SelectedValue = obj.NgayBook.Value.Month.ToString();
cmbNgaybk.SelectedValue = obj.NgayBook.Value.Day.ToString();
}
}
else
{
txtMaVe.Text = Request.QueryString["MaVe"];
txtMaVe.Enabled = false;
txtMaVe.CssClass = txtMaVe.CssClass + " form-control";
cmbMaTour.SelectedValue = Request.QueryString["MaTour"];
cmbMaTour.Enabled = false;
cmbMaTour.CssClass = cmbMaTour.CssClass + " form-control";
cmbMaLT.SelectedValue = Request.QueryString["MaLT"];
cmbMaLT.Enabled = false;
cmbMaLT.CssClass = cmbMaLT.CssClass + " form-control";
cmbMaKH.SelectedValue = Request.QueryString["MaKH"];
cmbMaKH.Enabled = false;
cmbMaKH.CssClass = cmbMaKH.CssClass + " form-control";
//--
cmbMaDDDL.SelectedValue = Request.QueryString["MaDDDL"];
cmbMaDDDL.Enabled = false;
cmbMaDDDL.CssClass = cmbMaDDDL.CssClass + " form-control";
//--
txtMaNV.Text = Request.QueryString["MaNV"];
txtMaNV.Enabled = false;
txtMaNV.CssClass = txtMaNV.CssClass + " form-control";
txtGiaTien.Text = Request.QueryString["GiaTien"];
txtGiaTien.Enabled = false;
txtGiaTien.CssClass = txtGiaTien.CssClass + " form-control";
cmbSLNL.SelectedValue = Request.QueryString["SLNguoiLon"];
cmbSLNL.Enabled = false;
cmbSLNL.CssClass = cmbSLNL.CssClass + " form-control";
cmbSLTE.SelectedValue = Request.QueryString["SLTreEm"];
cmbSLTE.Enabled = false;
cmbSLTE.CssClass = cmbSLNL.CssClass + " form-control";
txtMaNV.Text = Request.QueryString["MaNV"];
txtMaNV.Enabled = false;
txtMaNV.CssClass = txtMaNV.CssClass + " form-control";
cmbTrangThai.SelectedValue = Request.QueryString["TrangThai"];
cmbTrangThai.Enabled = false;
cmbTrangThai.CssClass = cmbTrangThai.CssClass + " form-control";
cmbNambk.SelectedValue = Request.QueryString["NgayBook"];
cmbNambk.Enabled = false;
cmbNambk.CssClass = cmbNambk.CssClass + " form-control";
cmbNgaybk.SelectedValue = Request.QueryString["NgayBook"];
cmbNgaybk.Enabled = false;
cmbNgaybk.CssClass = cmbNgaybk.CssClass + " form-control";
cmbThangbk.SelectedValue = Request.QueryString["NgayBook"];
cmbThangbk.Enabled = false;
cmbThangbk.CssClass = cmbThangbk.CssClass + " form-control";
// Query về db để lấy các thông tin còn lại
int mv = Int32.Parse(txtMaVe.Text);
QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == mv);
if (obj == null)
{
Response.Redirect("QLBooking.aspx");
}
else
{
txtMaVe.Text = obj.MaVe.ToString();
cmbMaLT.Text = obj.MaLT;
cmbMaTour.Text = obj.MaTour;
txtGiaTien.Text = obj.GiaTien.ToString();
txtMaNV.Text = obj.MaNV;
cmbMaKH.SelectedValue = obj.MaKH;
cmbMaDDDL.Text = obj.MaDDDL;
cmbSLNL.SelectedValue = obj.SLNguoiLon.ToString();
cmbSLTE.SelectedValue = obj.SLTreEm.ToString();
cmbTrangThai.Text = obj.TrangThai.ToString();
cmbNambk.SelectedValue = obj.NgayBook.Value.Year.ToString();
cmbThangbk.SelectedValue = obj.NgayBook.Value.Month.ToString();
cmbNgaybk.SelectedValue = obj.NgayBook.Value.Day.ToString();
}
}
}
}
}
}
