public void getCountCmt(string MaTour)
{
TourDLEntities db = new TourDLEntities();
QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour);
lbCountCmt.Text = obj.Comment.Count(x => x.ID_comment > 0).ToString();
}
//public void getData()
//{
// TourDLEntities db = new TourDLEntities();
// List<QLTour.Tour> lstSP = db.Tour.Take(1).ToList();
// rpAnhDaiDien.DataSource = lstSP;
// rpAnhDaiDien.DataBind();
//}
void getMoTa(string MaTour)
{
TourDLEntities db = new TourDLEntities();
QLTour.Tour obj = db.Tour.First(x => x.MaTour == MaTour);
if (db.Tour.FirstOrDefault(x => x.MaTour == MaTour) != null)
{
//Load anh Dai dien
List <QLTour.Media> lst = db.Media.Where(x => x.MaTour == MaTour).Take(1).ToList();
rpAnhDaiDien.DataSource = lst;
rpAnhDaiDien.DataBind();
//Load Mo Ta
List <QLTour.Tour> mt = db.Tour.Where(x => x.MaTour == MaTour).ToList();
rpMoTa.DataSource = mt;
rpMoTa.DataBind();
//Load Anh Tour
List <QLTour.Media> lst1 = db.Media.Where(x => x.MaTour == MaTour).ToList();
rpAnhTour.DataSource = lst1;
rpAnhTour.DataBind();
////Load Max user
//List<QLTour.Tour> max = db.Tour.Where(x => x.MaTour == MaTour).ToList();
//rpLichTrinh.DataSource = max;
//rpLichTrinh.DataBind();
}
else
{
Response.Redirect("Offers.aspx");
}
}
public void getPoint(string MaTour)
{
TourDLEntities db = new TourDLEntities();
QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour);
lbPoint.Text = obj.DanhGia.Average(x => x.Diem).ToString();
}
public string getPoint(string MaTour)
{
TourDLEntities db = new TourDLEntities();
QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour);
return(obj.DanhGia.Average(x => x.Diem).ToString());
}
//void getcmbLoaitour()
//{
// TourDLEntities db = new TourDLEntities();
// List<QLTour.LoaiTour> lst = db.LoaiTour.ToList();
// cmbMaLoaiTour.DataSource = lst;
// cmbMaLoaiTour.DataTextField = "TenLoaiTour";
// cmbMaLoaiTour.DataValueField = "MaLoaiTour";
// cmbMaLoaiTour.DataBind();
//}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
// Sửa dữ liệu
TourDLEntities db = new TourDLEntities();
QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == txtMaTour.Text);
if (obj == null)
{
Response.Redirect("Tours.aspx");
}
else
{
//obj.MaTour = txtMaTour.Text;
obj.TenTour = txtTenTour.Text;
obj.MaLoaiTour = cmbMaLoaiTour.SelectedValue;
obj.GiaTien = Int32.Parse(txtGiaTour.Text);
obj.Maxuser = Int32.Parse(txtMaxUser.Text);
obj.Minuser = Int32.Parse(txtMinUser.Text);
obj.MoTa = txtMieuTaNgan.Text;
db.SaveChanges();
Response.Redirect("Tours.aspx");
}
}
catch
{
// Lỗi
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//getcmbLoaitour();
// 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["Matour"] == null)
{
// thêm mới
btnSave.Visible = false;
btnAdd.Visible = true;
txtMaTour.Enabled = true;
//txtMaTour.Text = Request.QueryString["MaTour"];
txtMaTour.Enabled = false;
txtMaTour.CssClass = txtMaTour.CssClass + " form-control";
}
else
{
// Sửa
btnSave.Visible = true;
btnAdd.Visible = false;
txtMaTour.Text = Request.QueryString["MaTour"];
txtMaTour.Enabled = false;
txtMaTour.CssClass = txtMaTour.CssClass + " form-control";
// Query về db để lấy các thông tin còn lại
TourDLEntities db = new TourDLEntities();
string manv = Session["username"].ToString();
QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == txtMaTour.Text);
if (obj == null)
{
Response.Redirect("QLTours.aspx");
}
else
{
QLTour.NhanVien ob = db.NhanVien.FirstOrDefault(p => p.MaNV == manv);
string quyen = ob.NghiepVu;
if (quyen == "CSKH" || quyen == "SELL")
{
btnSave.Visible = false;
txtTenTour.Text = obj.TenTour;
txtGiaTour.Text = obj.GiaTien.ToString();
cmbMaLoaiTour.SelectedValue = obj.MaTour;
txtMaxUser.Text = obj.Maxuser.ToString();
txtMinUser.Text = obj.Minuser.ToString();
txtMieuTaNgan.Text = obj.MoTa;
}
else
{
txtTenTour.Text = obj.TenTour;
txtGiaTour.Text = obj.GiaTien.ToString();
cmbMaLoaiTour.SelectedValue = obj.MaTour;
txtMaxUser.Text = obj.Maxuser.ToString();
txtMinUser.Text = obj.Minuser.ToString();
txtMieuTaNgan.Text = obj.MoTa;
}
}
}
}
}
public string getAnhDaiDien(string MaTour)
{
TourDLEntities db = new TourDLEntities();
QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour);
if (obj.Media.Count(x => x.Main == true) > 0)
{
return(obj.Media.First(x => x.Main == true).Url);
}
else
{
return("");
}
}
protected void btnXoa_Command(object sender, CommandEventArgs e)
{
try
{
string MaTour = e.CommandArgument.ToString();
TourDLEntities db = new TourDLEntities();
QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour);
if (obj != null)
{
db.Tour.Remove(obj);
db.SaveChanges();
getData();
}
}
catch
{
// lỗi
lbErrorxoa.Text = "Bạn không thể xóa khi chưa xóa ảnh!";
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
TourDLEntities db = new TourDLEntities();
QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == txtMaTour.Text);
if (obj != null)
{
// Cảnh báo mã sản phẩm đã tồn tại
}
else
{
if (txtTenTour.Text == "" || txtGiaTour.Text == "")
{
lbloi.Text = "bạn chưa nhập đủ thông tin!";
}
else
{
obj = new QLTour.Tour();
obj.MaTour = getmatour();
obj.TenTour = txtTenTour.Text;
obj.MaLoaiTour = cmbMaLoaiTour.SelectedValue;
obj.GiaTien = Int32.Parse(txtGiaTour.Text);
obj.Maxuser = Int32.Parse(txtMaxUser.Text);
obj.Minuser = Int32.Parse(txtMinUser.Text);
obj.MoTa = txtMieuTaNgan.Text;
db.Tour.Add(obj);
db.SaveChanges();
Response.Redirect("Tours.aspx");
}
}
}
catch
{
// Lỗi
}
}
public string getAnhDaiDien(string Matour)
{
TourDLEntities db = new TourDLEntities();
QLTour.Tour obj = db.Tour.First(x => x.MaTour == Matour);
//var idanh = obj.Media.Where(p => p.MaTour == Matour && p.Main == true).Max(p => p.IDMedia);
if (obj != null)
{
if (obj.Media.Count(x => x.Main == true) > 0)
{
return(obj.Media.First(x => x.Main == true).Url);
//return idanh;
}
else
{
return("");
}
}
else
{
return("");
}
}
