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 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 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 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 HttpResponseMessage RoomPriceSave(List <CalendarPost> data)
{
HttpResponseMessage response = new HttpResponseMessage()
{
StatusCode = HttpStatusCode.OK,
Content = new StringContent(JsonConvert.SerializeObject(new { message = "ok" }))
};
if (data.Count <= 0)
{
return(response);
}
try
{
foreach (var item in data)
{
if (_db.RoomPrice.Any(o => o.Date == item.date && o.ROOMID == item.roomid))
{
var obj = _db.RoomPrice.Where(o => o.Date == item.date && o.ROOMID == item.roomid).FirstOrDefault();
obj.ROOMID = item.roomid;
obj.Date = item.date;
obj.Price = item.price;
obj.Quantity = item.quantity;
obj.SaleOff = item.off;
}
else
{
_db.RoomPrice.Add(new RoomPrice
{
SaleOff = item.off,
Quantity = item.quantity,
Price = item.price,
Date = item.date,
ROOMID = item.roomid
});
}
_db.SaveChanges();
}
}
catch (Exception ex)
{
response = new HttpResponseMessage()
{
StatusCode = HttpStatusCode.NotFound,
Content = new StringContent(JsonConvert.SerializeObject(new { message = ex.Message.ToString() }))
};
return(response);
}
return(response);
}
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()
{
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 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();
}
}
}
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 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 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 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();
}
}
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();
}
}
}