public ActionResult Create(ETour model)
{
using (var db = new MyDbDataContext())
{
if (ModelState.IsValid)
{
if (string.IsNullOrEmpty(model.Alias))
{
model.Alias = StringHelper.ConvertToAlias(model.Title);
}
try
{
var tour = new Tour
{
MenuID = model.MenuID,
ActivitiesID = model.ActivitisID,
Title = model.Title,
Alias = model.Alias,
Image = model.Image,
Index = 0,
Description = model.Description,
MetaTitle = string.IsNullOrEmpty(model.MetaTitle) ? model.Title : model.MetaTitle,
MetaDescription =
string.IsNullOrEmpty(model.MetaDescription) ? model.Title : model.MetaDescription,
Status = model.Status,
Price = model.Price,
Location = model.Location,
PriceSale = model.PriceSale,
Hot = model.Hot,
Deal = model.Deal,
Like = model.Like,
//StatusPrice = model.StatusPrice,
TourOther = model.TourOther,
TourIncluded = model.TourIncluded,
TourExcluded = model.TourExcluded,
};
db.Tours.InsertOnSubmit(tour);
db.SubmitChanges();
//Thêm tabHotel
if (model.TabHotels != null)
{
foreach (TabHotel item in model.TabHotels)
{
var tabTour = new TabHotel
{
TourID = tour.ID,
TitleTabHotel = item.TitleTabHotel,
ContentHotel = item.ContentHotel,
};
db.TabHotels.InsertOnSubmit(tabTour);
}
db.SubmitChanges();
}
if (model.Theme != null)
{
for (int i = 0; i < model.Theme.Length; i++)
{
var tabTheme = new ThemesMenu
{
TourID = tour.ID,
MenuID = int.Parse(model.Theme[i]),
Index = 0
};
db.ThemesMenus.InsertOnSubmit(tabTheme);
db.SubmitChanges();
}
}
//Thêm hình ảnh cho tour
if (model.EGalleryITems != null)
{
foreach (EGalleryITem itemGallery in model.EGalleryITems)
{
var gallery = new TourGallery
{
LargeImage = itemGallery.Image,
SmallImage = ReturnSmallImage.GetImageSmall(itemGallery.Image),
TourID = tour.ID,
};
db.TourGalleries.InsertOnSubmit(gallery);
}
db.SubmitChanges();
}
//Thêm tabtour
if (model.TabTours != null)
{
foreach (TabTour itemTabTour in model.TabTours)
{
var tabTour = new TabTour
{
TourID = tour.ID,
TitleTab = itemTabTour.TitleTab,
Content = itemTabTour.Content,
Price = itemTabTour.Price,
};
db.TabTours.InsertOnSubmit(tabTour);
}
db.SubmitChanges();
}
TempData["Messages"] = "Successful";
return(RedirectToAction("Index"));
}
catch (Exception exception)
{
LoadData();
LoadDataActivities();
ViewBag.Messages = "Error: " + exception.Message;
return(View(model));
}
}
LoadData();
LoadDataActivities();
return(View(model));
}
}
public ActionResult Update(ETour model)
{
//Kiểm tra xem alias thuộc tour này đã tồn tại chưa
var db = new MyDbDataContext();
//Kiểm tra xem đã chọn đến chuyên mục con cuối cùng chưa
//var check = db.Menus.Where(a => a.ParentID == model.ID).ToList();
//if (db.Menus.Any(a => a.ParentID == model.ID))
//{
// ModelState.AddModelError("MenuId", "Vui lòng chọn đến chuyên mục tour con cuối cùng");
//}
if (ModelState.IsValid)
{
try
{
Tour tour = db.Tours.FirstOrDefault(b => b.ID == model.ID);
if (tour != null)
{
tour.MenuID = model.MenuID;
tour.ActivitiesID = model.ActivitisID;
tour.Location = model.Location;
//tour.StatusPrice = model.StatusPrice;
tour.Like = model.Like;
tour.Deal = model.Deal;
tour.Title = model.Title;
tour.Alias = model.Alias;
tour.Image = model.Image;
tour.Description = model.Description;
tour.MetaTitle = string.IsNullOrEmpty(model.MetaTitle) ? model.Title : model.MetaTitle;
tour.MetaDescription = string.IsNullOrEmpty(model.MetaDescription)
? model.Title
: model.MetaDescription;
tour.Status = model.Status;
tour.Hot = model.Hot;
tour.Price = model.Price;
tour.PriceSale = model.PriceSale;
tour.TourOther = model.TourOther;
tour.TourIncluded = model.TourIncluded;
tour.TourExcluded = model.TourExcluded;
db.SubmitChanges();
//xóa gallery cho tour
db.TourGalleries.DeleteAllOnSubmit(db.TourGalleries.Where(a => a.TourID == tour.ID).ToList());
//Thêm hình ảnh cho tour
if (model.EGalleryITems != null)
{
foreach (EGalleryITem itemGallery in model.EGalleryITems)
{
var gallery = new TourGallery
{
LargeImage = itemGallery.Image,
SmallImage = ReturnSmallImage.GetImageSmall(itemGallery.Image),
TourID = tour.ID,
};
db.TourGalleries.InsertOnSubmit(gallery);
}
db.SubmitChanges();
}
//xóa danh sách tabtour
db.TabTours.DeleteAllOnSubmit(db.TabTours.Where(a => a.TourID == tour.ID).ToList());
db.ThemesMenus.DeleteAllOnSubmit(db.ThemesMenus.Where(a => a.TourID == tour.ID).ToList());
if (model.Theme != null)
{
for (int i = 0; i < model.Theme.Length; i++)
{
var tabTheme = new ThemesMenu
{
TourID = tour.ID,
MenuID = int.Parse(model.Theme[i]),
Index = 0
};
db.ThemesMenus.InsertOnSubmit(tabTheme);
db.SubmitChanges();
}
}
//Thêm tabtour
if (model.TabTours != null)
{
foreach (TabTour itemTabTour in model.TabTours)
{
var tabTour = new TabTour
{
TourID = tour.ID,
TitleTab = itemTabTour.TitleTab,
Content = itemTabTour.Content,
Price = itemTabTour.Price
};
db.TabTours.InsertOnSubmit(tabTour);
}
db.SubmitChanges();
}
db.TabHotels.DeleteAllOnSubmit(db.TabHotels.Where(a => a.TourID == tour.ID).ToList());
if (model.TabHotels != null)
{
foreach (TabHotel item in model.TabHotels)
{
var tabTour = new TabHotel
{
TourID = tour.ID,
TitleTabHotel = item.TitleTabHotel,
ContentHotel = item.ContentHotel,
};
db.TabHotels.InsertOnSubmit(tabTour);
}
db.SubmitChanges();
}
TempData["Messages"] = "Successful";
return(RedirectToAction("Index"));
}
}
catch (Exception exception)
{
LoadData();
LoadDataActivities();
ViewBag.Messages = "Error: " + exception.Message;
return(View());
}
}
LoadData();
LoadDataActivities();
return(View(model));
}
