public GameSiteModel()
{
if (_db == null)
{
_db = new WGHotelsEntities();
}
}
public void Create()
{
using (var scope = new TransactionScope())
{
using (var _db = new WGHotelsEntities())
{
var Venue_ZH = new VenueZH();
Venue_ZH.Sport = SportZH;
Venue_ZH.Type = TypeZH;
Venue_ZH.Venue = VenueZH;
Venue_ZH.Deleted = Deleted;
_db.VenueZH.Add(Venue_ZH);
//_db.SaveChanges();
var Venue_EN = new VenueEN();
Venue_EN.Sport = SportEN;
Venue_EN.Type = VenueViewModel.GetTypeEN(TypeZH);
Venue_EN.Venue = VenueEN;
Venue_ZH.Deleted = Deleted;
_db.VenueEN.Add(Venue_EN);
_db.SaveChanges();
scope.Complete();
}
}
}
public List <SelectListItem> Facility(List <int> Selected = null)
{
var lang = HttpContext.Current.Request.Cookies["lang"].Value.ToLower();
var FacilityZH = new List <FacilityZH>();
var SelectList = new List <SelectListItem>();
var _db = new WGHotelsEntities();
object model = _db.FacilityZH.ToList();
//if (lang.Equals("us"))
//{
// model = _db.FacilityEN.ToList();
//}else
//{
// model = _db.FacilityZH.ToList();
//}
var Facilities = (List <FacilityZH>)model;
SelectList = new List <SelectListItem>();
foreach (var i in Facilities)
{
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 WGHotelsEntities();
object model = null;
if (lang == "us")
{
model = _db.CodeFileEN.Where(o => o.ItemType == "Bed").ToList();
}
else
{
model = _db.CodeFileZH.Where(o => o.ItemType == "Bed").ToList();
}
var Beds = (List <CodeFileZH>)model;
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)
});
}
_db.Dispose();
return(SelectList);
}
public List <SelectListItem> SelectList(List <int> Selected = null)
{
var Items = new List <GameSiteViewModel>();
var _db = new WGHotelsEntities();
object Games = null;
Games = _db.VenueZH.Where(o => o.Deleted != true).ToList();
var SelectList = new List <SelectListItem>();
foreach (var i in (List <VenueZH>)Games)
{
SelectList.Add(item: new SelectListItem
{
Text = string.Format("{0}/{1}/{2}", i.Type, i.Venue, i.Sport),
Value = i.ID.ToString(),
Selected = Selected == null
? false
: Selected.Contains(i.ID)
});
}
_db.Dispose();
return(SelectList);
}
public void Create()
{
var Today = DateTime.Now;
using (var scope = new TransactionScope())
{
var _db = new WGHotelsEntities();
var CodeFileZH = new CodeFileZH();
CodeFileZH.ItemCode = "Bed";
CodeFileZH.ItemType = "Bed";
CodeFileZH.ItemDescription = NameZH;
CodeFileZH.Created = Today;
CodeFileZH.Creator = Creator;
CodeFileZH.Modified = Today;
CodeFileZH.Modify = Creator;
CodeFileZH.Remark = "Bed Type";
_db.CodeFileZH.Add(CodeFileZH);
_db.SaveChanges();
var CodeFileEN = new CodeFileEN();
CodeFileEN.ItemCode = "Bed";
CodeFileEN.ItemType = "Bed";
CodeFileEN.ItemDescription = NameEN;
CodeFileEN.Created = Today;
CodeFileEN.Creator = Creator;
CodeFileEN.Modified = Today;
CodeFileEN.Modify = Creator;
CodeFileEN.ParentId = CodeFileZH.ID;
CodeFileEN.Remark = "Bed Type";
_db.CodeFileEN.Add(CodeFileEN);
_db.SaveChanges();
scope.Complete();
}
}
public RoomController()
{
if (_db == null)
{
_db = new WGHotelsEntities();
}
}
public object HotelImageDelete(ImageViewModel data)
{
if (HttpContext.Current.Session[data.SessionKey] != null)
{
var images = (List <ImageViewModel>)HttpContext.Current.Session[data.SessionKey];
var img = new ImageViewModel();
if (images.Count > 0)
{
img = images.Where(o => o.Name == data.Name).FirstOrDefault();
if (img != null)
{
images.Remove(images.Where(o => o.Name == img.Name).FirstOrDefault());
new ImageDAO().Delete(img.Name);
using (var db = new WGHotelsEntities())
{
var dbimg = db.ImageStore.Where(o => o.Name == img.Name).FirstOrDefault();
if (dbimg != null)
{
db.ImageStore.Remove(dbimg);
db.SaveChanges();
}
}
}
}
HttpContext.Current.Session[data.SessionKey] = images;
}
return(Json(new { success = true }));
}
public CodeFiles()
: base()
{
if (_db == null)
{
_db = new WGHotelsEntities();
}
}
private void SetDefault()
{
using (var db = new WGHotelsEntities())
{
var data = db.SysSetting.Where(o => o.Code.Equals("RoomCanEditDate")).ToList();
Begin = data.Where(o => o.Name == "Begin").FirstOrDefault().Value;
End = data.Where(o => o.Name == "End").FirstOrDefault().Value;
}
}
// GET: Base
public BaseController()
: base()
{
if (_db == null)
{
_db = new WGHotelsEntities();
}
ViewBag.Language = new LanguageModel().ListItems;
}
public void Edit()
{
using (var db = new WGHotelsEntities())
{
var data = db.SysSetting.Where(o => o.Code.Equals("RoomCanEditDate")).ToList();
var BeginId = data.Where(o => o.Name == "Begin").FirstOrDefault().ID;
var EndId = data.Where(o => o.Name == "End").FirstOrDefault().ID;
var BeginDate = db.SysSetting.Where(o => o.ID == BeginId).FirstOrDefault();
BeginDate.Value = Begin;
var EndDate = db.SysSetting.Where(o => o.ID == EndId).FirstOrDefault();
EndDate.Value = End;
db.SaveChanges();
}
}
public RoomViewModel()
{
if (_db == null)
{
_db = new WGHotelsEntities();
}
RoomTypes();
Facility();
BedTypes();
if (!Directory.Exists(HttpContext.Current.Server.MapPath("/UserFolder")))
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath("/UserFolder"));
}
;
}
public void Edit()
{
using (var _db = new WGHotelsEntities())
{
var zh = _db.GameSiteZH.Find(IDZH);
var us = _db.GameSiteEN.Where(o => o.ParentId == zh.ID).FirstOrDefault();
zh.Remark = RemarkZH;
zh.Sports = SportZH;
zh.Type = TypeZH;
zh.Venue = VenueZH;
_db.SaveChanges();
us.Venue = VenueUS;
us.Remark = RemarkUS;
us.Sports = SportUS;
us.Type = TypeUS;
_db.SaveChanges();
}
}
public List <SelectListItem> SelectListItem(List <int> Selected = null)
{
using (var db = new WGHotelsEntities())
{
var SelectListItem = new List <SelectListItem>();
var items = db.Language.ToList();
foreach (var item in items)
{
SelectListItem.Add(new SelectListItem
{
Text = item.LanguZH,
Value = item.ID.ToString(),
Selected = Selected == null ? false : Selected.Contains(item.ID)
});
}
return(SelectListItem);
}
}
public void Edit()
{
using (var db = new WGHotelsEntities())
{
if (ID > 0)
{
var model = db.Language.Find(ID);
model.LanguZH = LanguZH;
model.LanguEN = LanguEN;
db.SaveChanges();
}
else
{
db.Language.Add(new Language {
LanguZH = LanguZH, LanguEN = LanguEN, Deleted = false
});
db.SaveChanges();
}
}
}
public void Edit()
{
var FactitlyZH = new FacilityZH();
var FactitlyEN = new FacilityEN();
using (var scope = new TransactionScope())
{
using (var _db = new WGHotelsEntities())
{
FactitlyZH = _db.FacilityZH.Find(ID);
FactitlyZH.Name = NameZH;
FactitlyZH.Enabled = Enabled;
FactitlyEN = _db.FacilityEN.Where(o => o.ParentId == FactitlyZH.ID).First();
FactitlyEN.Name = NameUS;
FactitlyEN.Enabled = Enabled;
_db.SaveChanges();
scope.Complete();
}
}
}
public void Create()
{
using (var _db = new WGHotelsEntities())
{
var Model = new Report();
Model.Created = Created;
Model.Creator = Creator;
//Model.CountryID = CountryID;
var country_id = int.Parse(Country);
var country = _db.Country.Find(country_id);
Model.CountryID = country.ID;
Model.Country = country.Name;
Model.CheckInDate = CheckInDate;
Model.HotelID = HotelID;
Model.NumOfPeople = NumOfPeople;
Model.Price = Price;
Model.RoomID = RoomID;
Model.Modified = Modified;
Model.Modify = Modify;
Model.Room = Room;
Model.Food = Food;
Model.FoodCost = FoodCost;
Model.Other = Other;
Model.OtherCost = OtherCost;
Model.UserType = UserType;
var ReportRooms = new List <ReportRooms>();
for (var i = 0; i < RoomIds.Count; i++)
{
ReportRooms.Add(new ReportRooms {
Amount = Amount[i], Quantity = Quantity[i], RoomID = RoomIds[i], RoomName = RoomName[i], Deleted = false
});
}
Model.ReportRooms = ReportRooms;
_db.Report.Add(Model);
_db.SaveChanges();
}
}
//public string RemarkUS { get; set; }
public List <VenueModel> List()
{
var VenueZH = new List <VenueZH>();
using (var db = new WGHotelsEntities())
{
VenueZH = db.VenueZH.ToList();
}
var VenueEN = new List <VenueEN>();
using (var db = new WGHotelsEntities())
{
VenueEN = db.VenueEN.ToList();
}
var Venues = new List <VenueModel>();
for (var i = 0; i < VenueEN.Count; i++)
{
Venues.Add(new VenueModel
{
//RemarkZH = GameZH[i].Remark,
//RemarkUS = GameUS[i].Remark,
SportEN = VenueEN[i].Sport,
SportZH = VenueZH[i].Sport,
TypeEN = VenueEN[i].Type,
TypeZH = VenueZH[i].Type,
VenueEN = VenueEN[i].Venue,
VenueZH = VenueZH[i].Venue,
IDZH = VenueZH[i].ID,
IDEN = VenueEN[i].ID,
Deleted = !VenueZH[i].Deleted.HasValue ? false : VenueZH[i].Deleted.Value
});
}
return(Venues);
}
public List <GameSiteListModel> List()
{
var GameZH = new List <GameSiteZH>();
using (var db = new WGHotelsEntities())
{
GameZH = db.GameSiteZH.ToList();
}
var GameUS = new List <GameSiteEN>();
using (var db = new WGHotelsEntities())
{
GameUS = db.GameSiteEN.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,
IDZH = GameZH[i].ID,
IDEN = GameUS[i].ID
});
}
return(Games);
}
public void Create()
{
using (var scope = new TransactionScope())
{
using (var _db = new WGHotelsEntities())
{
var GameZH = new GameSiteZH();
GameZH.Remark = RemarkZH;
GameZH.Sports = SportZH;
GameZH.Type = TypeZH;
GameZH.Venue = VenueZH;
_db.GameSiteZH.Add(GameZH);
_db.SaveChanges();
var GameUS = new GameSiteEN();
GameUS.ParentId = GameZH.ID;
GameUS.Remark = RemarkUS;
GameUS.Sports = SportUS;
GameUS.Type = TypeUS;
GameUS.Venue = VenueUS;
_db.GameSiteEN.Add(GameUS);
_db.SaveChanges();
}
}
}
private List <SelectListItem> GetSelectListItem(List <int> Selected = null)
{
using (var db = new WGHotelsEntities())
{
var SelectListItem = new List <SelectListItem>();
var items = db.Language.ToList();
var lang = "zh";
if (HttpContext.Current.Request.Cookies["lang"] != null)
{
lang = HttpContext.Current.Request.Cookies["lang"].Value.ToLower();
}
foreach (var item in items)
{
if (lang == "us")
{
SelectListItem.Add(new SelectListItem
{
Text = item.LanguEN,
Value = item.ID.ToString(),
Selected = Selected == null ? false : Selected.Contains(item.ID)
});
}
else if (lang == "zh")
{
SelectListItem.Add(new SelectListItem
{
Text = item.LanguZH,
Value = item.ID.ToString(),
Selected = Selected == null ? false : Selected.Contains(item.ID)
});
}
}
return(SelectListItem);
}
}
public void Create()
{
var FactitlyZH = new FacilityZH();
var FacilityEN = new FacilityEN();
FactitlyZH.Name = NameZH;
FactitlyZH.Enabled = true;
using (var scope = new TransactionScope())
{
using (var _db = new WGHotelsEntities())
{
_db.FacilityZH.Add(FactitlyZH);
FacilityEN.Name = NameUS;
FacilityEN.Enabled = true;
FacilityEN.ParentId = FactitlyZH.ID;
_db.SaveChanges();
scope.Complete();
}
}
}
public void Edit()
{
using (var scope = new TransactionScope())
{
using (var _db = new WGHotelsEntities())
{
var Today = DateTime.Now;
var ZH = _db.CodeFileZH.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);
var ParentId = ZH.ID;
var EN = _db.CodeFileEN.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;
_db.SaveChanges();
scope.Complete();
}
}
}
public List <DropDownListItem> SelectSportListItem(List <int> Selected = null)
{
var lang = HttpContext.Current.Request.Cookies["lang"].Value.ToLower();
//var Items = new List<GameSiteViewModel>();
var _db = new WGHotelsEntities();
object Games = null;
if (lang.Equals("zh"))
{
Games = _db.VenueZH.Where(o => o.Deleted != true).ToList();
}
else
{
Games = _db.VenueEN.Where(o => o.Deleted != true).ToList();
}
var SelectList = new List <DropDownListItem>();
if (lang.Equals("zh"))
{
SelectList.Add(item: new DropDownListItem
{
Text = "--請選擇--",
Value = "0",
DataAttr = "",
Selected = true
});
foreach (var i in (List <VenueZH>)Games)
{
SelectList.Add(item: new DropDownListItem
{
Text = string.Format("{0}", i.Sport),
Value = i.Sport,
DataAttr = i.Type,
Selected = Selected == null
? false
: Selected.Contains(i.ID)
});
}
}
else
{
SelectList.Add(item: new DropDownListItem
{
Text = "--Please select--",
Value = "0",
DataAttr = "",
Selected = true
});
foreach (var i in (List <VenueEN>)Games)
{
SelectList.Add(item: new DropDownListItem
{
Text = string.Format("{0}", i.Sport),
Value = i.Sport,
DataAttr = i.Type,
Selected = Selected == null
? false
: Selected.Contains(i.ID)
});
}
}
return(SelectList);
}
public void Edit()
{
var Session = HttpContext.Current.Session;
using (var scope = new TransactionScope())
{
using (var _db = new WGHotelsEntities())
{
var zhHotel = _db.HotelZH.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.Language = Languages;
zhHotel.Certificate = Certificate;
var HotelEN = _db.HotelEN.Where(o => o.ParentId == zhHotel.ID).FirstOrDefault();
HotelEN.Name = Nameus;
HotelEN.Address = Addressus;
HotelEN.Area = Area;
HotelEN.City = City;
HotelEN.Facilities = Facilies;
HotelEN.Features = Featureus;
HotelEN.Enabled = true;
HotelEN.LinkUrl = LinkUrl;
HotelEN.Game = Game;
HotelEN.Tel = Tel;
HotelEN.ParentId = zhHotel.ID;
HotelEN.Language = Languages;
HotelEN.Certificate = Certificate;
#region # Images
if (Session[ImgKey] != null)
{
var Now = DateTime.Now;
var images = (List <ImageViewModel>)Session[ImgKey];
var dbImg = _db.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");
_db.ImageStore.Add(new ImageStore
{
Created = Now,
Extension = img.Extension,
Deleted = false,
ReferIdUS = HotelEN.ID,
ReferIdZH = zhHotel.ID,
Type = "Hotel",
Name = fileName,
Image = img.Image
});
}
_db.SaveChanges();
scope.Complete();
}
#endregion
}
}
}
public void Create()
{
using (var scope = new TransactionScope())
{
using (var _db = new WGHotelsEntities())
{
var zhHotel = new HotelZH();
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;
zhHotel.Language = Languages;
zhHotel.Certificate = Certificate;
_db.HotelZH.Add(zhHotel);
_db.SaveChanges();
// ZHdb.SaveChanges();
var ReferIdZH = zhHotel.ID;
var ReferIdUS = 0;
var HotelEN = new HotelEN
{
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,
Language = Languages,
Certificate = Certificate
};
_db.HotelEN.Add(HotelEN);
_db.SaveChanges();
ReferIdUS = HotelEN.ID;
#region
var Session = HttpContext.Current.Session;
if (Session[ImgKey] != null)
{
var Now = DateTime.Now;
var images = (List <ImageViewModel>)Session[ImgKey];
foreach (var img in images)
{
var fileName = Guid.NewGuid().GetHashCode().ToString("x");
_db.ImageStore.Add(new ImageStore
{
Created = Now,
Extension = img.Extension,
Deleted = false,
ReferIdUS = ReferIdUS,
ReferIdZH = ReferIdZH,
Type = "Hotel",
Name = fileName,
Image = img.Image
});
}
_db.SaveChanges();
}
#endregion
scope.Complete();
}
}
}
public void Edit()
{
using (var db = new WGHotelsEntities())
{
var Model = db.Report.Find(ID);
Model.Modified = Modified;
Model.Modify = Modify;
var country_id = int.Parse(Country);
var country = db.Country.Find(country_id);
Model.CountryID = country.ID;
Model.Country = country.Name;
Model.CheckInDate = CheckInDate;
Model.HotelID = HotelID;
Model.NumOfPeople = NumOfPeople;
Model.Price = Price;
Model.RoomID = RoomID;
Model.Room = Room;
Model.Food = Food;
Model.FoodCost = FoodCost;
Model.Other = Other;
Model.OtherCost = OtherCost;
Model.UserType = UserType;
//var ExistReprtRooms = db.ReportRooms.Where(o => o.ReportID == ID).ToList();
var ExistReprtRooms = (from o in db.ReportRooms
where o.ReportID == Model.ID && o.Deleted != true
select o).ToList();
var count = ExistReprtRooms.Count;
var NewReportRooms = new List <ReportRooms>();
var ExistExceptReportRooms = new List <ReportRooms>();
for (var i = 0; i < RoomIds.Count; i++)
{
if (!ExistReprtRooms.Any(o => o.ID == ReportOfRoomIds[i]))
{
NewReportRooms.Add(new ReportRooms {
ReportID = Model.ID, Amount = Amount[i], Quantity = Quantity[i], RoomID = RoomIds[i], RoomName = RoomName[i], Deleted = false
});
}
else
{
ExistExceptReportRooms.Add(new ReportRooms {
ReportID = Model.ID, ID = ReportOfRoomIds[i], Amount = Amount[i], Quantity = Quantity[i], RoomID = RoomIds[i], RoomName = RoomName[i], Deleted = false
});
}
}
var RemoveReportRooms = new List <ReportRooms>();
foreach (var item in ExistReprtRooms)
{
if (!ExistExceptReportRooms.Any(o => o.ID == item.ID))
{
item.Deleted = true;
}
}
//NewReportRooms 有 ExistReprtRooms 沒有 要新增
//var NewExceptReportRooms = NewReportRooms;
//ExistReprtRooms 有 NewReportRooms 沒有要 移除
//var RemoveReportRooms = ExistExceptReportRooms.Except(ExistReprtRooms).ToList();
//foreach (var item in RemoveReportRooms)
//{
// var Rroom = db.ReportRooms.Find(item.ID);
// if (Rroom != null)
// {
// Rroom.Deleted = true;
// }
//}
//db.ReportRooms.AddRange(NewExceptReportRooms);
//if (!string.IsNullOrEmpty(Room))
//{
// var RoomString = Room;
// var RoomSpilt = RoomString.Split(',');
// foreach (var ro in RoomSpilt)
// {
// var room = ro.Split('^');
// var id = int.Parse(room[0]);
// var amt = int.Parse(room[1]);
// var name = room[2];
// ReportRoomsOf.Add(new ReportRooms { ID = ID, RoomID = id, Amount = amt, RoomName = name });
// ReportRooms.Add(new ReportRooms { RoomID = id, Amount = amt, RoomName = name });
// }
// var rrIDs = ReportRoomsOf.Select(o => o.RoomID).ToList();
// var removemodel = db.ReportRooms.Where(o => o.ReportID == ID).ToList();
// db.ReportRooms.RemoveRange(removemodel);
//Model.ReportRooms = NewExceptReportRooms.ToList();
//}
db.ReportRooms.AddRange(NewReportRooms);
db.Log.Add(new Log {
TargetId = ID, Created = DateTime.Now, Creator = UserName, Remark = "ReportViewModel Edit", TargetType = "修改飯店回報資料"
});
db.SaveChanges();
}
}
