public void Create()
{
var _dbZH = new WGHotelZHEntities();
var _dbEN = new WGHotelUSEntities();
var Today = DateTime.Now;
var ZH = new CodeFile();
ZH.ItemCode = "Bed";
ZH.ItemType = "Bed";
ZH.ItemDescription = NameZH;
ZH.Created = Today;
ZH.Creator = Creator;
ZH.Modified = Today;
ZH.Modify = Creator;
ZH.Remark = "Bed Type";
_dbZH.CodeFile.Add(ZH);
_dbZH.SaveChanges();
var EN = new CodeFile();
EN.ItemCode = "Bed";
EN.ItemType = "Bed";
EN.ItemDescription = NameEN;
EN.Created = Today;
EN.Creator = Creator;
EN.Modified = Today;
EN.Modify = Creator;
EN.ParentId = ZH.ID;
EN.Remark = "Bed Type";
_dbEN.CodeFile.Add(EN);
_dbEN.SaveChanges();
}
public List <SelectListItem> Facility(string lang = "zh", List <int> Selected = null)
{
var model = new List <Facility>();
var SelectList = new List <SelectListItem>();
var db = new WGHotelZHEntities();
if (lang.Equals("us"))
{
db = new WGHotelZHEntities("WGHotelUSEntities");
}
model = db.Facility.ToList();
SelectList = new List <SelectListItem>();
foreach (var i in model)
{
SelectList.Add(item: new SelectListItem
{
Text = i.Name,
Value = i.ID.ToString(),
Selected = Selected == null
? false
: Selected.Contains(i.ID)
});
}
return(SelectList);
}
public List <SelectListItem> SelectList(List <int> Selected = null)
{
var lang = HttpContext.Current.Request.Cookies["lang"].Value.ToLower();
var _db = new WGHotelZHEntities();
if (lang == "us")
{
_db = new WGHotelZHEntities("WGHotelUSEntities");
}
var Items = new List <BedViewModel>();
var Beds = _db.CodeFile.Where(o => o.ItemType == "Bed");
var SelectList = new List <SelectListItem>();
foreach (var i in Beds)
{
SelectList.Add(item: new SelectListItem
{
Text = i.ItemDescription,
Value = i.ID.ToString(),
Selected = Selected == null
? false
: Selected.Contains(i.ID)
});
}
return(SelectList);
}
public GameSiteModel()
{
if (db == null)
{
db = new WGHotelZHEntities();
}
}
public List <SelectListItem> SelectList(List <int> Selected = null)
{
var lang = HttpContext.Current.Request.Cookies["lang"].Value.ToLower();
var _db = new WGHotelZHEntities();
if (lang == "us")
{
_db = new WGHotelZHEntities("WGHotelUSEntities");
}
var Items = new List <GameSiteViewModel>();
var Games = _db.GameSite.ToList();
var SelectList = new List <SelectListItem>();
foreach (var i in Games)
{
SelectList.Add(item: new SelectListItem
{
Text = string.Format("{0}/{1}", i.Venue, i.Sports),
Value = i.ID.ToString(),
Selected = Selected == null
? false
: Selected.Contains(i.ID)
});
}
return(SelectList);
}
public List <SelectListItem> Citys(int Selected = 0)
{
var city = new List <City>();
var SelectList = new List <SelectListItem>();
using (var db = new WGHotelZHEntities())
{
city = db.City.ToList();
foreach (var i in city)
{
SelectList.Add(item: new SelectListItem
{
Text = i.Name,
Value = i.ID.ToString(),
Selected = Selected == 0
? false
: Selected.Equals(i.ID)
});
}
}
// var List = new SelectList(city,"ID", "Name",id.ToString());
return(SelectList);
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
var Requset = requestContext.HttpContext.Request;
UserId = requestContext.HttpContext.User.Identity.GetUserId <int>();
if (Request.Cookies["lang"] != null && Request.Cookies["lang"].Value.ToLower().Equals("us"))
{
_db = new WGHotelZHEntities("WGHotelUSEntities");
CurrentLanguage = Request.Cookies["lang"].Value.ToLower();
}
else
{
_db = new WGHotelZHEntities("WGHotelZHEntities");
CurrentLanguage = "zh";
if (Request.Cookies["lang"] == null)
{
HttpCookie cookie = new HttpCookie("lang", "zh");
Request.Cookies.Add(cookie);
}
else
{
Request.Cookies["lang"].Value = "zh";
}
}
ViewBag.lang = CurrentLanguage;
}
public void Edit()
{
var _dbZH = new WGHotelZHEntities();
var _dbEN = new WGHotelUSEntities();
var Today = DateTime.Now;
var ZH = _dbZH.CodeFile.Where(o => o.ID == ID && o.ItemCode == "Bed").FirstOrDefault();
ZH.ItemCode = "Bed";
ZH.ItemType = "Bed";
ZH.ItemDescription = NameZH;
ZH.Modified = Today;
ZH.Modify = Creator;
ZH.Deleted = Deleted;
//_dbZH.CodeFile.Add(ZH);
_dbZH.SaveChanges();
var ParentId = ZH.ID;
var EN = _dbEN.CodeFile.Where(o => o.ParentId == ParentId && o.ItemCode == "Bed").FirstOrDefault();
EN.ItemCode = "Bed";
EN.ItemType = "Bed";
EN.ItemDescription = NameEN;
EN.Modified = Today;
EN.Modify = Creator;
EN.Deleted = Deleted;
_dbEN.SaveChanges();
}
public CodeFiles()
: base()
{
if (_db == null)
{
_db = new WGHotelZHEntities();
}
}
// GET: Base
public BaseController()
: base()
{
_dbzh = new WGHotelZHEntities();
_dbus = new WGHotelUSEntities();
_basedb = new WGHotelBaseEntities();
//var RoomEditDate = new PRDate();
//var RoomEditBeginDate = DateTime.Parse(RoomEditDate.Begin);
//var RoomEditEndDate = DateTime.Parse(RoomEditDate.End);
//ViewBag.GameSite = new GameSiteModel().SelectList();
}
public RoomViewModel()
{
if (_db == null)
{
_db = new WGHotelZHEntities();
}
RoomTypes();
Facility();
BedTypes();
if (!Directory.Exists(HttpContext.Current.Server.MapPath("/UserFolder")))
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath("/UserFolder"));
}
;
}
public void Edit()
{
var dbZH = new WGHotelZHEntities();
var dbUS = new WGHotelUSEntities();
var zh = dbZH.GameSite.Find(ID);
var us = dbUS.GameSite.Where(o => o.ParentId == zh.ID).FirstOrDefault();
zh.Remark = RemarkZH;
zh.Sports = SportZH;
zh.Type = TypeZH;
zh.Venue = VenueZH;
dbZH.SaveChanges();
us.Venue = VenueUS;
us.Remark = RemarkUS;
us.Sports = SportUS;
us.Type = TypeUS;
dbUS.SaveChanges();
}
public void Edit()
{
var FactitlyZH = new Facility();
using (var zh = new WGHotelZHEntities())
{
FactitlyZH = zh.Facility.Find(ID);
FactitlyZH.Name = NameZH;
FactitlyZH.Enabled = Enabled;
zh.SaveChanges();
}
var FactitlyUS = new Facility();
using (var us = new WGHotelUSEntities())
{
FactitlyUS = us.Facility.Where(o => o.ParentId == FactitlyZH.ID).First();
FactitlyUS.Name = NameUS;
FactitlyUS.Enabled = Enabled;
us.SaveChanges();
}
}
public void Create()
{
var dbZH = new WGHotelZHEntities();
var dbUS = new WGHotelUSEntities();
var GameZH = new GameSite();
GameZH.Remark = RemarkZH;
GameZH.Sports = SportZH;
GameZH.Type = TypeZH;
GameZH.Venue = VenueZH;
dbZH.GameSite.Add(GameZH);
dbZH.SaveChanges();
var GameUS = new GameSite();
GameUS.ParentId = GameZH.ID;
GameUS.Remark = RemarkUS;
GameUS.Sports = SportUS;
GameUS.Type = TypeUS;
GameUS.Venue = VenueUS;
dbUS.GameSite.Add(GameUS);
dbUS.SaveChanges();
}
public void Create()
{
var FactitlyZH = new Facility();
FactitlyZH.Name = NameZH;
FactitlyZH.Enabled = true;
using (var zh = new WGHotelZHEntities())
{
zh.Facility.Add(FactitlyZH);
zh.SaveChanges();
}
var FactitlUS = new Facility();
FactitlUS.Name = NameUS;
FactitlUS.Enabled = true;
FactitlUS.ParentId = FactitlyZH.ID;
using (var us = new WGHotelUSEntities())
{
us.Facility.Add(FactitlUS);
us.SaveChanges();
}
}
public List <GameSiteListModel> List()
{
var GameZH = new List <GameSite>();
using (var db = new WGHotelZHEntities())
{
GameZH = db.GameSite.ToList();
}
var GameUS = new List <GameSite>();
using (var db = new WGHotelUSEntities())
{
GameUS = db.GameSite.ToList();
}
var Games = new List <GameSiteListModel>();
for (var i = 0; i < GameZH.Count; i++)
{
Games.Add(new GameSiteListModel
{
RemarkZH = GameZH[i].Remark,
RemarkUS = GameUS[i].Remark,
SportUS = GameUS[i].Sports,
SportZH = GameZH[i].Sports,
TypeUS = GameUS[i].Type,
TypeZH = GameZH[i].Type,
VenueUS = GameUS[i].Venue,
VenueZH = GameZH[i].Venue,
ID = GameZH[i].ID
});
}
return(Games);
}
public void Edit()
{
var ZHdb = new WGHotelZHEntities();
var zhHotel = ZHdb.Hotel.Find(ID);
zhHotel.Name = Namezh;
zhHotel.Address = Addresszh;
zhHotel.Area = Area;
zhHotel.City = City;
zhHotel.Facilities = Facilies;
zhHotel.Features = Featurezh;
zhHotel.Enabled = true;
zhHotel.LinkUrl = LinkUrl;
zhHotel.Game = Game;
zhHotel.Tel = Tel;
//zhHotel.UserId = zhHotel.UserId;
//ZHdb.Hotel.Add(zhHotel);
var ReferIdZH = zhHotel.ID;
try
{
var USdb = new WGHotelUSEntities();
var HotelUs = USdb.Hotel.Where(o => o.ParentId == ReferIdZH).FirstOrDefault();
HotelUs.Name = Nameus;
HotelUs.Address = Addressus;
HotelUs.Area = Area;
HotelUs.City = City;
HotelUs.Facilities = Facilies;
HotelUs.Features = Featureus;
HotelUs.Enabled = true;
HotelUs.LinkUrl = LinkUrl;
HotelUs.Game = Game;
//HotelUs.UserId = UserId;
HotelUs.Tel = Tel;
HotelUs.ParentId = zhHotel.ID;
// USdb.Hotel.Add(HotelUs);
USdb.SaveChanges();
ZHdb.SaveChanges();
var ReferIdUS = HotelUs.ID;
var Session = HttpContext.Current.Session;
if (Session[ImgKey] != null)
{
var Basedb = new WGHotelBaseEntities();
var Now = DateTime.Now;
var images = (List <ImageViewModel>)Session[ImgKey];
var dbImg = Basedb.ImageStore.Where(o => o.ReferIdZH == zhHotel.ID);
var ImgNames = dbImg.Select(o => o.Name).ToList();
images = images.Where(o => !ImgNames.Contains(o.Name)).ToList();
foreach (var img in images)
{
var fileName = Guid.NewGuid().GetHashCode().ToString("x");
Basedb.ImageStore.Add(new ImageStore
{
Created = Now,
Extension = img.Extension,
Deleted = false,
ReferIdUS = ReferIdUS,
ReferIdZH = ReferIdZH,
Type = "Hotel",
Name = fileName,
Image = img.Image
});
}
Basedb.SaveChanges();
}
}
catch (Exception ex)
{
}
}
public List <CalendarEvent> HotelImageUpload(int id)
{
var Room = new PRDate();
var Begin = DateTime.Parse(Room.Begin);
var End = DateTime.Parse(Room.End);
decimal Price = 0;
List <CalendarEvent> Events = new List <CalendarEvent>();
using (var _db = new WGHotelZHEntities())
{
Price = _db.Room.Find(id).Sell.Value;
}
Events = (from room in db.RoomPrice
where room.ROOMID == id
select new CalendarEvent
{
Start = room.Date,
//End = room.Date.AddDays(1),
Off = room.SaleOff,
Price = room.Price,
Quantity = room.Quantity
}).ToList();
DateTime epoc = new DateTime(1970, 1, 1);
List <CalendarEvent> events = new List <CalendarEvent>();
if (Events == null || Events.Count <= 0)
{
for (var date = Begin; date < End; date = date.AddDays(1.0))
{
var beginDay = DateTime.Parse(date.ToShortDateString());
var endDay = DateTime.Parse(date.ToShortDateString());
events.Add(new CalendarEvent {
Title = "Event" + id.ToString(),
Start = beginDay,
End = endDay,
Price = Price,
Off = true,
Quantity = 0
});
}
}
else
{
for (var date = Begin; date < End; date = date.AddDays(1.0))
{
var beginDay = DateTime.Parse(date.ToShortDateString());
var endDay = DateTime.Parse(date.ToShortDateString());
var Off = false;
decimal CurrentPrice = 0;
int Quantity = 0;
var Current = Events.Where(o => o.Start == beginDay).FirstOrDefault();
if (Current != null)
{
CurrentPrice = Current.Price;
Off = Current.Off;
Quantity = Current.Quantity;
}
else
{
CurrentPrice = Price;
Off = true;
Quantity = 0;
}
events.Add(new CalendarEvent {
Title = "Event" + id.ToString(),
Start = beginDay,
End = endDay,
Price = CurrentPrice,
Off = Off,
Quantity = Quantity
});
}
}
return(events);
}
public void Create()
{
var ZHdb = new WGHotelZHEntities();
var zhHotel = new Hotel();
zhHotel.Name = Namezh;
zhHotel.Address = Addresszh;
zhHotel.Area = Area;
zhHotel.City = City;
zhHotel.Facilities = Facilies;
zhHotel.Features = Featurezh;
zhHotel.Enabled = true;
zhHotel.LinkUrl = LinkUrl;
zhHotel.Game = Game;
zhHotel.Tel = Tel;
zhHotel.UserId = UserId;
ZHdb.Hotel.Add(zhHotel);
ZHdb.SaveChanges();
var ReferIdZH = zhHotel.ID;
var ReferIdUS = 0;
try
{
var USdb = new WGHotelUSEntities();
var HotelUs = new Hotel
{
Name = Nameus,
Address = Addressus,
Area = Area,
City = City,
Facilities = Facilies,
Features = Featureus,
Enabled = true,
LinkUrl = LinkUrl,
Game = Game,
UserId = UserId,
Tel = Tel,
ParentId = zhHotel.ID
};
USdb.Hotel.Add(HotelUs);
USdb.SaveChanges();
ReferIdUS = HotelUs.ID;
var Session = HttpContext.Current.Session;
if (Session[ImgKey] != null)
{
var Basedb = new WGHotelBaseEntities();
var Now = DateTime.Now;
var images = (List <ImageViewModel>)Session[ImgKey];
foreach (var img in images)
{
var fileName = Guid.NewGuid().GetHashCode().ToString("x");
Basedb.ImageStore.Add(new ImageStore
{
Created = Now,
Extension = img.Extension,
Deleted = false,
ReferIdUS = ReferIdUS,
ReferIdZH = ReferIdZH,
Type = "Hotel",
Name = fileName,
Image = img.Image
});
}
Basedb.SaveChanges();
}
}
catch (Exception ex)
{
var ZH = ZHdb.Hotel.Find(zhHotel.ID);
if (ZH != null)
{
ZHdb.Hotel.Remove(ZH);
ZHdb.SaveChanges();
}
}
}
public void Create()
{
var ZHID = 0;
var USID = 0;
var ZHHotelID = 0;
var BedTypes = string.Empty;
if (Beds != null && Beds.Count > 0)
{
BedTypes = string.Join(",", Beds);
}
using (var db = new WGHotelZHEntities())
{
var Room = new Room();
Room.Name = NameZh;
Room.Notice = NoticeZh;
Room.Feature = FeatureZh;
Room.BedType = BedTypes;
Room.RoomType = RoomType;
Room.Sell = Sell;
Room.Enabled = true;
Room.HasBreakfast = HasBreakfast;
Room.HOTELID = HOTELID;
Room.Facilities = string.Empty;
Room.Quantiy = Quantiy;
db.Room.Add(Room);
db.SaveChanges();
ZHID = Room.ID;
ZHHotelID = Room.HOTELID;
}
try
{
using (var db = new WGHotelUSEntities())
{
var ENBed = new List <string>();
if (Beds != null && Beds.Count > 0)
{
var ENBeds = Beds.Select(int.Parse).ToList();
foreach (var b in ENBeds)
{
var data = db.CodeFile.Where(o => o.ItemType == "Bed" && o.ParentId == b).FirstOrDefault();
if (data != null)
{
ENBed.Add(data.ID.ToString());
}
}
}
var HotelID = db.Hotel.Where(o => o.ParentId == ZHHotelID).FirstOrDefault().ID;
var Room = new Room();
Room.Name = NameUs;
Room.Feature = FeatureUs;
Room.Notice = NoticeUs;
Room.BedType = (ENBed == null || ENBed.Count <= 0) ? string.Empty : string.Join(",", ENBed);
Room.RoomType = RoomType;
Room.Sell = Sell;
Room.Enabled = true;
Room.HasBreakfast = HasBreakfast;
Room.HOTELID = HotelID;
Room.Facilities = string.Empty;
Room.Quantiy = Quantiy;
Room.ParentId = ZHID;
db.Room.Add(Room);
db.SaveChanges();
USID = Room.ID;
}
SaveImageStore(ZHID, USID);
}
catch (Exception ex)
{
using (var db = new WGHotelZHEntities())
{
var remove = db.Hotel.Where(o => o.ID == ZHID).FirstOrDefault();
if (remove != null)
{
db.Hotel.Remove(remove);
db.SaveChanges();
}
}
}
}
public ActionResult Detail(int id)
{
var currentdb = new WGHotelZHEntities();
var lang = Request.Cookies["lang"].Value;
if (CurrentLanguage.Equals("us"))
{
currentdb = new WGHotelZHEntities("WGHotelUSEntities");
}
var model = currentdb.Hotel.Find(id);
if (model == null && CurrentLanguage.Equals("us"))
{
model = _dbus.Hotel.Where(o => o.ID == id).FirstOrDefault();
}
else if (model == null && CurrentLanguage.Equals("zh"))
{
model = _dbzh.Hotel.Where(o => o.ID == id).FirstOrDefault();
}
if (model == null)
{
model = _dbus.Hotel.Where(o => o.ParentId == id).FirstOrDefault();
}
if (model == null)
{
return(RedirectToAction("Index", "Home"));
}
var detail = new HotelDetail();
detail.ID = model.ID;
detail.Images = _basedb.ImageStore.Where(o => o.ReferIdZH == model.ID && o.Type == "Hotel").ToList();
detail.LinkUrl = model.LinkUrl;
detail.Name = model.Name;
detail.Tel = model.Tel;
detail.Address = model.Address;
detail.Feature = model.Features;
var Facilities = model.Facilities.Split(',').Select(Int32.Parse).ToList();
detail.Facilities = _db.Facility.Where(o => Facilities.Contains(o.ID)).Select(p => p.Name).ToList();
detail.City = _db.City.Where(o => o.ID == model.City).FirstOrDefault().Name;
var rooms = model.Room.Select(o => o.ID).ToList();
detail.Rooms = (from r in _db.Room
where rooms.Contains(r.ID)
select new RoomViewList
{
Feature = r.Feature,
Notice = r.Notice,
ID = r.ID,
BedType = r.BedType,
LinkUrl = model.LinkUrl,
//Images = _basedb.ImageStore.Where(o => o.ID == r.ID && o.Type == "Room").ToList(),
Name = r.Name,
Quantiy = r.Quantiy,
RoomType = r.RoomType,
Sell = r.Sell,
HasBreakfast = r.HasBreakfast.Value
}).ToList();
foreach (var r in detail.Rooms)
{
if (CurrentLanguage.Equals("us"))
{
r.Images = _basedb.ImageStore.Where(o => o.ReferIdUS == r.ID && o.Type == "Room").ToList();
}
else
{
r.Images = _basedb.ImageStore.Where(o => o.ReferIdZH == r.ID && o.Type == "Room").ToList();
}
}
var gamesites = model.Game.Split(',').ToList();
var NearHotels = _db.Hotel.Where(o => gamesites.Contains(o.Game) && o.ID != model.ID)
.Select(o => new HotelDetail
{
ID = o.ID,
Address = o.Address,
Name = o.Name,
ParentId = o.ParentId == null ? 0 : o.ParentId.Value
}).OrderBy(x => Guid.NewGuid()).Take(5).ToList();
foreach (var item in NearHotels)
{
var ReferIdZH = item.ID;
if (CurrentLanguage.Equals("us"))
{
ReferIdZH = item.ParentId;
}
item.Images = _basedb.ImageStore.Where(o => o.ReferIdZH == ReferIdZH).ToList();
}
ViewBag.NearHotels = NearHotels;
return(View(detail));
}
