//Danh sách phòng
//public static List<Room> GetRooms(int menuId)
//{
// using (var db = new MyDbDataContext())
// {
// var menu = db.Menus.FirstOrDefault(a => a.ID == menuId);
// List<Room> rooms = db.Rooms.Where(a => a.Status && a.LanguageID == menu.LanguageID).OrderBy(a => a.Index).ToList();
// foreach (var room in rooms)
// {
// room.MenuAlias = menu.Alias;
// }
// return rooms;
// }
//}
//Chi tiết phòng
//public static DetailRoom Detail_Room(int id, int menuId)
//{
// using (var db = new MyDbDataContext())
// {
// var menu = db.Menus.FirstOrDefault(a => a.ID == menuId);
// Room room = db.Rooms.FirstOrDefault(a => a.ID == id && a.Status) ?? new Room();
// List<RoomGallery> roomGalleries = db.RoomGalleries.Where(a => a.RoomId == room.ID).ToList();
// List<Room> rooms = db.Rooms.Where(a => a.Status && a.ID != room.ID && a.LanguageID == menu.LanguageID).OrderBy(a => a.Index).ToList();
// foreach (var item in rooms)
// {
// item.MenuAlias = menu.Alias;
// }
// DetailRoom detailRoom = new DetailRoom()
// {
// Room = room,
// RoomGalleries = roomGalleries,
// Rooms = rooms
// };
// return detailRoom;
// }
//}
//Danh sách dich vu
//public static List<Service> GetServices(int menuId)
//{
// using (var db = new MyDbDataContext())
// {
// List<Service> restaurants = db.Services.Where(a => a.Status && a.MenuID == menuId).OrderBy(a => a.Index).ToList();
// foreach (var restaurant in restaurants)
// {
// restaurant.MenuAlias = restaurant.Menu.Alias;
// }
// return restaurants;
// }
//}
//Chi tiết dich vu
//public static DetailService Detail_Service(int id)
//{
// using (var db = new MyDbDataContext())
// {
// Service service = db.Services.FirstOrDefault(a => a.ID == id && a.Status) ?? new Service();
// List<ServiceGallery> restaurantGalleries = db.ServiceGalleries.Where(a => a.ServiceID == service.ID).ToList();
// List<Service> restaurants = db.Services.Where(a => a.Status && a.ID != service.ID).OrderBy(a => a.Index).ToList();
// foreach (var item in restaurants)
// {
// item.MenuAlias = service.Menu.Alias;
// }
// DetailService detailRestaurant = new DetailService()
// {
// Service = service,
// ServiceGalleries = restaurantGalleries,
// Services = restaurants
// };
// return detailRestaurant;
// }
//}
//Danh sách tours
public static List <ShowObject> GetTours(int menuId)
{
using (var db = new MyDbDataContext())
{
Menu _menuDes = db.Menus.FirstOrDefault(x => x.ID == menuId);
var query = db.Tours.Where(x => x.Status)
.Join(db.ThemesMenus.Where(x => x.MenuID == menuId), a => a.ID, b => b.TourID, (a, b) => new { a, b });
var value = query.Join(db.Menus, c => c.a.ActivitiesID, d => d.ID, (c, d) => new ShowObject
{
ID = c.a.ID,
Alias = c.a.Alias,
MenuAlias = _menuDes.Alias,
Themes = d.Title,
Title = c.a.Title,
Index = c.a.Index,
Image = c.a.Image,
Location = c.a.Location,
Description = c.a.Description,
Price = (decimal)c.a.Price,
PriceSale = (decimal)c.a.PriceSale
}).Distinct().ToList();
return(value);
}
}
public JsonResult Edit(EConfigEmail model)
{
using (var db = new MyDbDataContext())
{
if (ModelState.IsValid)
{
try
{
var edit = db.ConfigWebsites.FirstOrDefault(b => b.ID == model.ID);
if (edit != null)
{
edit.Port = model.Port;
edit.Email = model.Email;
edit.Password = CryptorEngine.Encrypt(model.Password, true);
edit.Host = model.Host;
db.SubmitChanges();
return(Json(new { Result = "OK", Message = "Sửa thành công", Record = model }));
}
else
{
return(Json(new { Result = "ERROR", Message = "Bản ghi không tồn tại" }));
}
}
catch (Exception exception)
{
return(Json(new { Result = "ERROR", Message = "Fail. Error:" + exception.Message }));
}
}
return(Json(new { Result = "ERROR", Errors = ModelState.Errors(), Message = "Dữ liệu đầu vào không đúng định dạng" }));
}
}
public JsonResult Delete(int id)
{
try
{
using (var db = new MyDbDataContext())
{
Menu del = db.Menus.FirstOrDefault(c => c.ID == id);
//kiểm tra xem thằng này có menu con không
List <Menu> listMenu = db.Menus.Where(m => m.ParentID == del.ID).ToList();
if (del != null)
{
db.Menus.DeleteAllOnSubmit(listMenu);
db.SubmitChanges();
db.Menus.DeleteOnSubmit(del);
db.SubmitChanges();
return(Json(new { Result = "OK", Message = "Successful" }));
}
return(Json(new { Result = "OK", Message = "Menu not exist" }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
public JsonResult List(int menuId = 0, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
try
{
var db = new MyDbDataContext();
var listmenu = db.Menus.Where(m => m.LanguageID == Request.Cookies["lang_client"].Value).ToList();
var listTour = new List <Tour>();
if (menuId == 0)
{
listTour = db.Tours.ToList();
}
else
{
listTour = db.Tours.Where(a => a.MenuID == menuId).ToList();
}
var records = listTour.Join(db.Menus.Where(a => a.LanguageID == Request.Cookies["lang_client"].Value), a => a.MenuID, b => b.ID,
(a, b) => new
{
a.ID,
a.Title,
a.Index,
a.Status,
a.Deal,
a.Hot
}).Skip(jtStartIndex).Take(jtPageSize).OrderBy(a => a.Index).ToList();
//Return result to jTable
return(Json(new { Result = "OK", Records = records, TotalRecordCount = listTour.Count }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
public JsonResult CheckMa(string code, int IDCabin)
{
try
{
using (var db = new MyDbDataContext())
{
DateTime today = DateTime.Now;
ProjectLibrary.Database.PromotionCodeCabin del = db.PromotionCodeCabins.FirstOrDefault(c => c.Code == code && c.IDCabin == IDCabin &&
today <= c.NgayKetThuc && today >= c.NgayBatDau && c.TrangThai == true);
if (del != null)
{
/*
* 1-het ma
* 2-ok co ma va con luot dung
* 3-loi ko co ma nao
*/
if (del.DaDung >= del.SL)
{
return(Json(new { Result = "OK", Message = "1" }));
}
else
{
del.DaDung = del.DaDung + 1;
db.SubmitChanges();
return(Json(new { Result = "OK", Message = "2" }));
}
}
return(Json(new { Result = "ERROR", Message = "3" }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
public JsonResult List(int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
try
{
using (var db = new MyDbDataContext())
{
List <ELanguage> records =
db.Languages.Select(
a =>
new ELanguage
{
Icon = a.Icon,
ID = a.ID,
Default = a.Default,
Name = a.Name
}).ToList();
//Return result to jTable
return(Json(new { Result = "OK", Records = records, TotalRecordCount = records.Count }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "OK", message = ex.Message }));
}
}
public ActionResult ListTours(string slug, string item, int?page, int?pageSize)
{
using (var db = new MyDbDataContext())
{
Menu menu = db.Menus.FirstOrDefault(x => x.Alias == slug);
ViewBag.slug = slug;
ViewBag.Menu = menu;
int pagenumber = page ?? 1;
int pagesize = pageSize ?? 9;
List <ShowObject> _listActivities = CommentController.GetToursActivities(menu.ID);
switch (item)
{
case "0":
_listActivities = _listActivities.OrderBy(x => x.ID).ToList();
break;
case "1":
_listActivities = _listActivities.OrderBy(x => x.Price).ToList();
break;
case "2":
_listActivities = _listActivities.OrderByDescending(x => x.Price).ToList();
break;
default:
break;
}
IPagedList <ShowObject> _list = _listActivities.ToPagedList(pagenumber, pagesize);
return(View("Tour/SpecialTour", _list));
}
}
public ActionResult UpdateIndex()
{
int menuId;
int.TryParse(Request.Params["ListMenu"], out menuId);
if (menuId == 0)
{
TempData["Messages"] = "Please select a menu.";
return(RedirectToAction("Index"));
}
using (var db = new MyDbDataContext())
{
var records = db.ListHotels.Where(r => r.MenuID == menuId).ToList();
foreach (var record in records)
{
var itemHotel = Request.Params[string.Format("Sort[{0}].Index", record.ID)];
int index;
int.TryParse(itemHotel, out index);
record.Index = index;
db.SubmitChanges();
}
TempData["Messages"] = "Sort successfull";
return(RedirectToAction("Index"));
}
}
public JsonResult Delete(int ID)
{
try
{
using (var db = new MyDbDataContext())
{
var del = db.ListHotels.FirstOrDefault(c => c.ID == ID);
if (del != null)
{
//xóa hết hình ảnh của phòng này
db.HotelGalleries.DeleteAllOnSubmit(db.HotelGalleries.Where(a => a.HotelId == del.ID).ToList());
//Xoa het phong cua hotel
db.Rooms.DeleteAllOnSubmit(db.Rooms.Where(a => a.HotelId == del.ID).ToList());
db.ListHotels.DeleteOnSubmit(del);
db.SubmitChanges();
return(Json(new { Result = "OK", Message = "Delete successful" }));
}
return(Json(new { Result = "ERROR", Message = "Hotel is not exist" }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public ActionResult Update(int id)
{
var db = new MyDbDataContext();
Room detailRoom = db.Rooms.FirstOrDefault(a => a.ID == id);
if (detailRoom == null)
{
TempData["Messages"] = "Room is not exist";
return(RedirectToAction("Index"));
}
ViewBag.Title = "Update room";
LoadData();
ERoom room = new ERoom
{
ID = detailRoom.ID,
HotelId = detailRoom.HotelId,
Title = detailRoom.Title,
Image = detailRoom.Image,
Index = detailRoom.Index ?? 0,
Status = detailRoom.Status,
Price = detailRoom.Price,
MaxPeople = detailRoom.MaxPeople,
PriceNet = detailRoom.PriceNet ?? 0,
Description = detailRoom.Description,
Content = detailRoom.Content
};
//lấy danh sách hình ảnh
room.EGalleryITems = db.RoomGalleries.Where(a => a.RoomId == detailRoom.ID).Select(a => new EGalleryITem
{
Image = a.ImageLarge
}).ToList();
return(View(room));
}
public JsonResult List(int hotelId = 0, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
try
{
var db = new MyDbDataContext();
var listArticle = db.Rooms.Where(a => a.LanguageID == Request.Cookies["lang_client"].Value).Join(db.ListHotels, a => a.HotelId, b => b.ID, (a, b) => new { a, b }).ToList();
var menu = db.Menus.Where(a => a.LanguageID == Request.Cookies["lang_client"].Value).ToList();
if (hotelId != 0)
{
listArticle = listArticle.Where(a => a.a.HotelId == hotelId).ToList();
}
var records = listArticle.Select(a => new
{
ID = a.a.ID,
Title = a.a.Title,
HotelName = a.b.HotelName,
Index = a.a.Index,
Status = a.a.Status,
}).Skip(jtStartIndex).Take(jtPageSize).ToList();
//Return result to jTable
return(Json(new { Result = "OK", Records = records, TotalRecordCount = listArticle.Count }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public ActionResult Update(int id)
{
ViewBag.Title = "Update";
using (var db = new MyDbDataContext())
{
SendEmail sendEmail = db.SendEmails.FirstOrDefault(a => a.ID == id);
if (sendEmail == null)
{
TempData["Messages"] = "Record is exist ";
return(RedirectToAction("Index"));
}
var eSendEmail = new ESendEmail
{
ID = sendEmail.ID,
Type = sendEmail.Type,
Title = sendEmail.Title,
Content = sendEmail.Content,
Success = sendEmail.Success,
Error = sendEmail.Error
};
return(View(eSendEmail));
}
}
public ActionResult Update(ESendEmail model)
{
using (var db = new MyDbDataContext())
{
if (ModelState.IsValid)
{
try
{
SendEmail sendEmail = db.SendEmails.FirstOrDefault(b => b.ID == model.ID);
if (sendEmail != null)
{
sendEmail.Title = model.Title;
sendEmail.Content = model.Content;
sendEmail.Success = model.Success;
sendEmail.Error = model.Error;
db.SubmitChanges();
TempData["Messages"] = "Successful";
return(RedirectToAction("Index"));
}
}
catch (Exception exception)
{
ViewBag.Messages = "Lỗi: " + exception.Message;
return(View());
}
}
return(View(model));
}
}
//lay danh sach tau theo menu ID
public static List <Cruise> GetCruise(int menuId)
{
using (var db = new MyDbDataContext())
{
List <Cruise> cruises = db.Cruises.OrderBy(a => a.ID).ToList();
foreach (var item in cruises)
{
item.tabs = db.Cruisetabs.Where(a => a.IDCruise == item.ID).ToList();
}
List <Cruise> sp = new List <Cruise>();
cruises.ForEach(a =>
{
if (string.IsNullOrEmpty(a.MenuID) == false)
{
List <string> lstSubMenu = a.MenuID.Split(',').ToList();
if (lstSubMenu.Any(b => b.Contains(menuId.ToString())))
{
sp.Add(a);
}
}
});
return(sp);
}
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (Request.Cookies["LanguageID"] == null)
{
using (var db = new MyDbDataContext())
{
Language language = db.Languages.FirstOrDefault(a => a.Default);
if (language == null)
{
language = db.Languages.FirstOrDefault();
}
if (language != null)
{
HttpCookie langCookie = new HttpCookie("LanguageID");
langCookie.Value = language.ID;
langCookie.Expires = DateTime.Now.AddDays(10);
filterContext.RequestContext.HttpContext.Response.Cookies.Add(langCookie);
}
else
{
filterContext.Result =
new RedirectToRouteResult(
new RouteValueDictionary(new { controller = "Home", action = "404" }));
}
}
}
}
public JsonResult List(int menuId = 0, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
try
{
var db = new MyDbDataContext();
var listmenu = db.Menus.Where(m => m.LanguageID == Request.Cookies["lang_client"].Value).ToList();
var listPro = new List <PromotionCode>();
if (menuId == 0)
{
listPro = db.PromotionCodes.ToList();
}
else
{
listPro = db.PromotionCodes.ToList();
}
var records = listPro.Select(a => new
{
a.ID,
a.Code,
a.StartDay,
a.EndDay,
a.Total,
a.Status,
a.Rate,
a.Used,
}).Skip(jtStartIndex).Take(jtPageSize).OrderByDescending(a => a.ID).ToList();
//Return result to jTable
return(Json(new { Result = "OK", Records = records, TotalRecordCount = listPro.Count }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
public JsonResult List(int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
try
{
using (var db = new MyDbDataContext())
{
var list = db.Hotels.Where(a => a.LanguageID == Request.Cookies["lang_client"].Value).Select(a => new
{
a.ID,
a.Name,
a.Logo,
a.Image,
a.Email,
a.Tel,
a.Address,
a.Hotline,
}).ToList();
//Return result to jTable
return(Json(new { Result = "OK", Records = list, TotalRecordCount = list.Count() }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
public ActionResult Update(int id)
{
using (var db = new MyDbDataContext())
{
Slider detailSlider = db.Sliders.FirstOrDefault(a => a.ID == id);
if (detailSlider == null)
{
TempData["Messages"] = "Slide not exist";
return(RedirectToAction("Index"));
}
LoadData();
var slider = new ESlider
{
ID = detailSlider.ID,
Title = detailSlider.Title,
MenuIDs = detailSlider.MenuIDs,
//MenuID = detailSlider.MenuID,
Image = detailSlider.Image,
Link = detailSlider.Link,
ViewAll = (bool)detailSlider.ViewAll,
Status = (bool)detailSlider.Status,
Description = detailSlider.Description,
};
ViewBag.Title = "udpate slide";
ViewBag.Menus = LoadData(slider.MenuIDs, Request.Cookies["lang_client"].Value);
return(View(slider));
}
}
public JsonResult List(int menuId = 0, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
try
{
using (var db = new MyDbDataContext())
{
List <TabArticle> tabArticles = new List <TabArticle>();
tabArticles = db.TabArticles.ToList();
List <ShowTab> records = tabArticles.Select(a => new ShowTab
{
ID = a.ID,
Title = a.Title,
Alias = a.Alias,
Index = a.Index,
MetaTitle = a.MetaTitle,
}).OrderBy(a => a.Index).Skip(jtStartIndex).Take(jtPageSize).ToList();
//Return result to jTable
return(Json(new { Result = "OK", Records = records, TotalRecordCount = tabArticles.Count() }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
public JsonResult Create(EmailMarketing model)
{
//End check
using (var db = new MyDbDataContext())
{
if (ModelState.IsValid)
{
try
{
var emailmarketing = new EmailMarketing
{
Email = model.Email,
//Tel = model.Tel,
Note = model.Note,
};
db.EmailMarketings.InsertOnSubmit(emailmarketing);
db.SubmitChanges();
string message = "Insert successful";
return(Json(new { Result = "OK", Message = message, Record = model }));
}
catch (Exception exception)
{
return(Json(new { Result = "Error", Message = "Error: " + exception.Message }));
}
}
return(Json(new { Result = " Error", Errors = ModelState.Errors(), Message = "Input data are not correct in form" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Delete(int id)
{
try
{
using (var db = new MyDbDataContext())
{
Tour del = db.Tours.FirstOrDefault(c => c.ID == id);
if (del != null)
{
//xóa hết hình ảnh của tour này
db.TourGalleries.DeleteAllOnSubmit(db.TourGalleries.Where(a => a.TourID == del.ID).ToList());
//xóa hết tabtour của tour này
db.TabTours.DeleteAllOnSubmit(db.TabTours.Where(a => a.TourID == del.ID).ToList());
db.TabHotels.DeleteAllOnSubmit(db.TabHotels.Where(a => a.TourID == del.ID).ToList());
db.ThemesMenus.DeleteAllOnSubmit(db.ThemesMenus.Where(a => a.TourID == del.ID).ToList());
db.Tours.DeleteOnSubmit(del);
db.SubmitChanges();
return(Json(new { Result = "OK", Message = "Successful" }));
}
return(Json(new { Result = "ERROR", Message = "Tour not exist" }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
public JsonResult Edit(EmailMarketing model)
{
//End check
using (var db = new MyDbDataContext())
{
if (ModelState.IsValid)
{
try
{
var edit = db.EmailMarketings.FirstOrDefault(b => b.Id == model.Id);
if (edit != null)
{
edit.Email = model.Email;
//edit.Tel = model.Tel;
edit.Note = model.Note;
db.SubmitChanges();
string message = "Update successful";
return(Json(new { Result = "OK", Message = message }));
}
else
{
return(Json(new { Result = "ERROR", Message = "Video is not exist" }));
}
}
catch (Exception exception)
{
return(Json(new { Result = "Error", Message = "Error: " + exception.Message }));
}
}
return(Json(new { Result = " Error", Errors = ModelState.Errors(), Message = "Input data are not correct in form" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Messages()
{
using (var db = new MyDbDataContext())
{
SendEmail sendEmail =
db.SendEmails.FirstOrDefault(
a => a.Type == TypeSendEmail.Contact && a.LanguageID == Request.Cookies["LanguageID"].Value);
string status = Request.Params["status"];
ViewBag.Messages = "";
if (string.IsNullOrEmpty(status) == false)
{
if (status.Equals("success"))
{
ViewBag.Messages = sendEmail.Success;
}
else
{
ViewBag.Messages = sendEmail.Error;
}
}
else
{
ViewBag.Messages = sendEmail.Error;
}
return(View());
}
}
public ActionResult UpdateConfig(PaymentConfigOnePay model)
{
using (var db = new MyDbDataContext())
{
if (ModelState.IsValid)
{
try
{
PaymentConfigOnePay Config = db.PaymentConfigOnePays.FirstOrDefault();
if (Config == null)
{
Config = new PaymentConfigOnePay();
db.PaymentConfigOnePays.InsertOnSubmit(Config);
db.SubmitChanges();
ViewBag.Messages = "Thêm Payment Config OnePay thành công";
return(RedirectToAction("GoogleAnalytics"));
}
Config.AccessCode = model.AccessCode;
Config.Hashcode = model.Hashcode;
Config.MerchantId = model.MerchantId;
Config.WebSite = model.WebSite;
db.SubmitChanges();
ViewBag.Messages = "Chỉnh sửa Payment Config OnePay thành công";
return(RedirectToAction("Config"));
}
catch (Exception exception)
{
ViewBag.Messages = "Lỗi: " + exception.Message;
return(View());
}
}
return(View(model));
}
}
public JsonResult Create(EConfigEmail model)
{
using (var db = new MyDbDataContext())
{
if (db.ConfigWebsites.Any())
{
return(Json(new { Result = "ERROR", Message = "Website chỉ được phép tồn tại 1 bản cấu hình" }));
}
if (ModelState.IsValid)
{
try
{
ConfigWebsite configWebsite = new ConfigWebsite
{
Host = model.Host,
Port = model.Port,
Email = model.Email,
Password = CryptorEngine.Encrypt(model.Password, true),
};
db.ConfigWebsites.InsertOnSubmit(configWebsite);
db.SubmitChanges();
model.ID = configWebsite.ID;
return(Json(new { Result = "OK", Message = "Thêm thành công", Record = model }));
}
catch (Exception exception)
{
return(Json(new { Result = "ERROR", Message = "Fail. Error:" + exception.Message }));
}
}
return(Json(new { Result = "ERROR", Errors = ModelState.Errors(), Message = "Dữ liệu đầu vào không đúng định dạng" }));
}
}
public JsonResult SaveEmail(string emailMarketing)
{
try
{
using (var db = new MyDbDataContext())
{
var checkEmail = db.EmailMarketings.FirstOrDefault(a => a.Email == emailMarketing);
if (checkEmail != null)
{
return(Json(new { result = "Error", message = "Email is exist" }));
}
EmailMarketing marketing = new EmailMarketing
{
Email = emailMarketing,
Tel = "",
Note = "",
};
db.EmailMarketings.InsertOnSubmit(marketing);
db.SubmitChanges();
return(Json(new { result = "ok" }));
}
}
catch (Exception)
{
return(Json(new { result = "Error", message = "Error!" }));
}
}
public ActionResult Update(int id)
{
using (var db = new MyDbDataContext())
{
Menu menu = db.Menus.FirstOrDefault(m => m.ID == id);
SystemMenuLocation menuLocation = GetLocaltion(0);
if (menu != null)
{
var model = new EMenu
{
Alias = menu.Alias,
Index = menu.Index,
Level = (int)menu.Level,
Location = (int)menu.Location,
ID = menu.ID,
MetaDescription = menu.MetaDescription,
MetaTitle = menu.MetaTitle,
ParentID = menu.ParentID,
Status = (bool)menu.Status,
Title = menu.Title,
Type = (int)menu.Type,
Link = menu.Link,
Description = menu.Description,
Image = menu.Image,
Showhome = menu.Showhome ?? false,
};
ListData();
ViewBag.MenuLocation = GetLocaltion(0);
return(View(model));
}
TempData["Messages"] = "Menu not exist";
return(RedirectToAction(menuLocation.AliasMenu));
}
}
public JsonResult List(int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
try
{
using (var db = new MyDbDataContext())
{
List <EAdvertising> listAdv =
db.Advertisings.Where(a => a.LanguageID == Request.Cookies["lang_client"].Value).Select(a => new EAdvertising
{
ID = a.ID,
Title = a.Title,
Url = a.Url,
Image = a.Image,
Target = a.Target,
Index = a.Index,
Status = a.Status
}).OrderBy(a => a.Index).ToList();
//Return result to jTable
return(Json(new { Result = "OK", Records = listAdv, TotalRecordCount = listAdv.Count }));
}
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", ex.Message }));
}
}
public ActionResult UpdateIndex(int locationID)
{
SystemMenuLocation localtionMenu = GetLocaltion(locationID);
try
{
using (var db = new MyDbDataContext())
{
List <Menu> menus =
db.Menus.Where(c => c.LanguageID == Request.Cookies["lang_client"].Value).ToList();
foreach (Menu item in menus)
{
string requestIndex = Request.Params[string.Format("Sort[{0}].Index", item.ID)];
int index;
int.TryParse(requestIndex, out index);
Menu temp = db.Menus.FirstOrDefault(c => c.ID == item.ID);
if (temp != null)
{
temp.Index = index;
db.SubmitChanges();
}
}
}
TempData["Messages"] = "successful";
return(RedirectToAction(localtionMenu.AliasMenu, "Menu"));
}
catch (Exception ex)
{
TempData["Messages"] = "Error: " + ex.Message;
return(RedirectToAction(localtionMenu.AliasMenu, "Menu"));
}
}
//Danh sách tap article
public static List <TabArticle> GetTapArticles()
{
using (var db = new MyDbDataContext())
{
return(db.TabArticles.ToList());
}
}
