public void DataRefresh()
{
db = new DisneyDataDataContext();
cboThemePark.DataSource = db.ThemePark;
cboThemePark.DisplayMember = "ThemeParkName";
lblHoliday.Text = "The theme party of this month is" + db.HolidayEvent.FirstOrDefault(x => x.Year == DateTime.Today.Year && x.Month == DateTime.Today.Month).HolidayEventName;
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
monthCalendar1.SelectionStart = DateTime.Today;
monthCalendar1.SelectionEnd = DateTime.Today;
monthCalendar1_DateChanged(null, null);
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
order = null;
lstTicket = null;
txtOrderId.Text = "";
}
public void DataRefresh(RoomOrder rOrder)
{
gbTicket.BringToFront();
db = new DisneyDataDataContext();
step = 0;
lstGroup = new List <GroupBox>();
lstTicket = new List <Ticket>();
dateType = GetDateType();
roomOrder = rOrder;
account = null;
order = null;
lstGroup.Add(gbTicket);
lstGroup.Add(gbTIcketInfo);
lstGroup.Add(gbOrderDetail);
lstGroup.Add(gbTicketDetail);
lstGroup.Add(gbPayMethod);
rbDay.Checked = true;
dtpVisit.MinDate = DateTime.Today;
dtpVisit.Value = DateTime.Today;
cboAnnualType.SelectedIndex = 0;
cboPayMethod.DataSource = db.PaymentMethod;
cboPayMethod.DisplayMember = "Method";
panelCredit.Visible = false;
gbSignin.BringToFront();
}
public void DataRefresh()
{
bookingRoom1.Visible = false;
Global.BookRooms = new BindingList <Room>();
db = new DisneyDataDataContext();
cboHotel.DataSource = db.Hotel;
cboHotel.DisplayMember = "HotelName";
cboHotel.SelectedIndex = -1;
lstBook.DataSource = Global.BookRooms;
lstBook.DisplayMember = "RoomId";
dtpIn.MinDate = DateTime.Today;
dtpIn.Value = DateTime.Today;
int totalGuest = db.RoomOrderDetail.ToList()
.Where(x => x.StartDate <= DateTime.Today && x.EndDate >= DateTime.Today)
.Sum(x => x.GuestNum + x.ChildrenNum);
lblTotalGuest.Text = $"Total Guest: {totalGuest}";
dgvStatus.Rows.Clear();
db.RoomStatus.ToList().ForEach(x =>
{
int num = db.Room.ToList().Where(r => r.RoomStatusNo == x.RoomStatusNo).Count();
dgvStatus.Rows.Add(new object[]
{
x.Status,
num
});
});
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
var active = db.LogRecord.ToList().Where(x => x.AccountId == Global.User.AccountId).Select(x => new { x.LoginTime }).ToList();
dgv.DataSource = active;
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
lstMaintenance.DataSource = db.MaintenanceSchedule
.ToList()
.Where(x => DateTime.Now > x.StartDateTiime && DateTime.Now < x.EndDateTime)
.Select(x => x.Attractions.AttractionsName)
.ToList();
}
private void btnLogin_Click(object sender, EventArgs e)
{
//Search account
db = new DisneyDataDataContext();
if (txtAccount.Text == "" || txtPwd.Text == "")
{
MessageBox.Show("Account or password cannot be empty.", "Disneyland", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
var user = db.Account.ToList().FirstOrDefault(x => x.AccountId == txtAccount.Text && x.Password == txtPwd.Text);
//Account or password incorrcet
if (user == null)
{
errorTimes += 1;
MessageBox.Show("Account or password incorrect.", "Disneyland", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (errorTimes >= 3)
{
MessageBox.Show("You entered the account incorrcetly more than 3 times,\n" +
"you should wait for 10 second.", "Disneyland", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnLogin.Enabled = false;
timerLock.Start();
}
return;
}
//Login successfully
try
{
Global.User = user;
db.LogRecord.InsertOnSubmit(new LogRecord()
{
AccountId = user.AccountId,
LoginTime = DateTime.Now
});
db.SubmitChanges();
gpbLogin.Visible = false;
panelMenu.Visible = true;
btnLogout.Visible = true;
if (user.GroupNo == 3 || user.GroupNo == 4)
{
btnManage.Visible = false;
}
btnResort_Click(null, null);
MessageBox.Show("Login successfully.", "Disneyland", MessageBoxButtons.OK, MessageBoxIcon.Information);
TimeSpan ts = DateTime.Now - user.LastTimeChangePwd;
if (ts.TotalDays > changePwdDay)
{
new FrmChangePwd().ShowDialog();
}
}
catch (Exception)
{
MessageBox.Show(e.ToString());
}
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
lstGroup.DataSource = db.Group;
lstGroup.DisplayMember = "GroupName";
lstAuthority.DataSource = db.Authority;
lstAuthority.DisplayMember = "Event";
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
cboGroup.DataSource = db.Group;
cboGroup.DisplayMember = "GroupName";
lstUser.DataSource = db.Account;
lstUser.DisplayMember = "Name";
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
dtpStart.MaxDate = DateTime.Today;
dtpStart.Value = DateTime.Today;
dtpEnd.MaxDate = DateTime.Today;
dtpEnd.Value = DateTime.Today;
cboRange.SelectedIndex = 0;
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
dgv.DataSource = db.Guest.Select(x => new
{
x.Name,
x.IdentityNo,
x.Gender,
x.Citizenship
}).ToList();
}
private void cboGroup_SelectedIndexChanged(object sender, EventArgs e)
{
if (lstUser.DataSource == null || cboGroup.DataSource == null)
{
return;
}
db = new DisneyDataDataContext();
var account = db.Account.ToList().Single(x => x.AccountId == ((Account)lstUser.SelectedItem).AccountId);
account.GroupNo = ((Group)cboGroup.SelectedItem).GroupNo;
db.SubmitChanges();
Global.User = db.Account.ToList().Single(x => x.AccountId == Global.User.AccountId);
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
cboStatus.DataSource = db.RoomStatus;
cboStatus.DisplayMember = "Status";
cboHotel.DataSource = db.Hotel;
cboHotel.DisplayMember = "HotelName";
dgvRoom_SelectionChanged(null, null);
}
private void HotelService_Load(object sender, EventArgs e)
{
db = new DisneyDataDataContext();
cboSerivce.DataSource = db.RoomService;
cboSerivce.DisplayMember = "ServiceName";
orderDetail = Global.OrderDetailRecord;
lstService = db.RoomServiceRecord.ToList().Where(x => x.RoomOrderDetailNo == orderDetail.RoomOrderDetailNo).ToList();
dgv.DataSource = lstService.Select(x => new
{
x.RoomService.ServiceName,
x.Quantity
}).ToList();
}
public void DataRefresh()
{
checkOut1.Visible = false;
bookTicket1.Visible = false;
db = new DisneyDataDataContext();
lstRoomId.DataSource = null;
dgvOrder.DataSource = db.RoomOrder.ToList()
.Where(x => x.PaymentMethodNo == null)
.Select(x => new
{
x.Guest.Name,
OrderTime = x.OrderDateTime.ToString("yyyy/MM/dd"),
}).ToList();
dgvOrder_SelectionChanged(null, null);
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
dtpBirthday.MaxDate = DateTime.Today;
txtAccount.Text = "";
txtCitizenship.Text = "";
txtEmail.Text = "";
txtName.Text = "";
txtPwd.Text = "";
DateTime dtNow = DateTime.Now;
dtpBirthday.MaxDate = dtNow;
dtpBirthday.Value = dtNow;
rbMen.Checked = true;
cboGroup.DataSource = db.Group;
cboGroup.DisplayMember = "GroupName";
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
cboGroup.DataSource = db.Group;
cboGroup.DisplayMember = "GroupName";
dtpBirthday.MaxDate = DateTime.Today;
var user = Global.User;
lblAccount.Text = user.AccountId;
txtCitizenship.Text = user.Citizenship;
txtEmail.Text = user.Email;
txtName.Text = user.Name;
txtPwd.Text = user.Password;
dtpBirthday.Value = user.Birthday;
(user.Gender == "M" ? rbMen : rbFemale).Checked = true;
cboGroup.SelectedIndex = db.Group.ToList().FindIndex(x => x.GroupNo == user.GroupNo);
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
lstCarousel = Global.GetCarousel();
stayTime = Properties.Settings.Default.StayTime;
this.Controls.Clear();
//Set label text
string cText = "";
db.CarouselText.ToList().ForEach(x =>
{
cText += x.CarouselText1 + " ";
});
//Create label
lblCarousel = new Label()
{
Location = new Point(1031, 655),
AutoSize = true,
Text = cText.Trim()
};
this.Controls.Add(lblCarousel);
timerMove.Start();
//Create FlowLayoutPanel
carouselNum = lstCarousel.Count(x => x == true);
flowlayout = new FlowLayoutPanel()
{
Location = new Point(0, 0),
Size = new Size(this.Width * carouselNum, this.Height - 30),
AutoScroll = false,
FlowDirection = FlowDirection.TopDown
};;
this.Controls.Add(flowlayout);
CreateCarousel(flowlayout);
timerStay.Start();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtNewPwd.Text == "")
{
MessageBox.Show("Value cannot be empty!", "Disneyland", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (txtNewPwd.Text == lblNowPwd.Text)
{
MessageBox.Show("Please change a new password!", "Disneyland", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//Save password
db = new DisneyDataDataContext();
var account = db.Account.ToList().First(x => x.AccountId == Global.User.AccountId);
account.Password = txtNewPwd.Text;
account.LastTimeChangePwd = DateTime.Now;
db.SubmitChanges();
Global.User = account;
MessageBox.Show("Change password successfully.", "Disneyland", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
lstRooms = Global.BookRooms.ToList();
lstOrderDetail = Global.OrderDetails;
lstBreakfast = Global.Breakfast;
lstStorage = Global.Storage;
lstGuests = Global.Guests;
txtCoupon.Text = "";
txtTicket.Text = "";
lblDuring.Text = $"Stay Time: {Global.CheckIn.ToString("yyyy/MM/dd")} - {Global.CheckOut.ToString("yyyy/MM/dd")}";
lblPrice.Text = $"Total Price: ${GetPrice()}";
//Show order detail
dgvReservedRoom.DataSource = lstOrderDetail.Select(x => new
{
x.Room.RoomId,
x.GuestNum,
x.ChildrenNum,
x.MainGuest
}).ToList();
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
cboTicket.DataSource = db.TicketOffer;
cboTicket.DisplayMember = "TicketName";
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
showMode = Properties.Settings.Default.ShowMode;
lstCarousel = Global.GetCarousel();
lstText = db.CarouselText.ToList();
txtCarouselText.Text = "";
(showMode == 0 ? rbGeneral : rbCarousel).Checked = true;
nudStayTime.Value = Properties.Settings.Default.StayTime;
List <System.Windows.Forms.CheckBox> checkBoxs = new List <System.Windows.Forms.CheckBox>();
foreach (Control control in this.Controls)
{
if (control is System.Windows.Forms.CheckBox)
{
checkBoxs.Add((System.Windows.Forms.CheckBox)control);
}
}
checkBoxs.Select((thisIsControl, goldCard) => new
{
Control = thisIsControl,
F**k = goldCard
}).Where(x => x.Control.Checked = lstCarousel[x.F**k])
.ToList().ForEach(x =>
{
x.Control.Visible = true;
});
//for (int i = 0; i < lstCarousel.Count; i++)
//{
// if (lstCarousel[i] == false)
// {
// continue;
// }
// switch (i)
// {
// case 0:
// cbDisneylandResort.Checked = true;
// break;
// case 1:
// cbNews.Checked = true;
// break;
// case 2:
// cbWeather.Checked = true;
// break;
// case 3:
// cbTourist.Checked = true;
// break;
// case 4:
// cbAttraction.Checked = true;
// break;
// case 5:
// cbDrama.Checked = true;
// break;
// case 6:
// cbAttractionSchedule.Checked = true;
// break;
// case 7:
// cbMaintenance.Checked = true;
// break;
// }
//}
dgvReset();
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
cboPayment.DataSource = db.PaymentMethod;
cboPayment.DisplayMember = "Method";
btnPay.Enabled = true;
order = db.RoomOrder.ToList().SingleOrDefault(x => x.RoomOrderNo == Global.OrderRecord.RoomOrderNo);
lstPay = new List <PayItem>();
var detail = db.RoomOrderDetail.ToList().Where(x => x.RoomOrderNo == order.RoomOrderNo).ToList();
detail.ForEach(x =>
{
lstPay.Add(new PayItem
{
Description = x.Room.RoomSeries.SuitesName,
UnitCost = x.Room.RoomSeries.Price,
Qty = 1,
Amount = x.Room.RoomSeries.Price
});
});
detail.ForEach(x =>
{
db.RoomServiceRecord.ToList().Where(y => y.RoomOrderDetailNo == x.RoomOrderDetailNo).ToList().ForEach(y =>
{
lstPay.Add(new PayItem
{
Description = y.RoomService.ServiceName,
UnitCost = y.RoomService.Price,
Qty = y.Quantity,
Amount = y.RoomService.Price * y.Quantity
});
});
});
lstPay = lstPay.GroupBy(x => new { x.Description, x.UnitCost })
.Select(p => new PayItem
{
Description = p.Key.Description,
UnitCost = p.Key.UnitCost,
Qty = p.Sum(q => q.Qty),
Amount = p.Sum(t => t.Qty) * p.Key.UnitCost
}).ToList();
dgv.DataSource = lstPay.Select(x => new
{
Description = x.Description,
UnitCost = "$" + x.UnitCost,
Qty = x.Qty,
Amount = "$" + x.Amount
}).ToList();
subtotal = GetSubTotal();
discount = GetDiscount();
invoiceTotal = GetInvoiceTotal();
lblSubtotal.Text = $"Subtotal: {subtotal}";
lblDiscount.Text = $"Discount: {(discount == 1 ? "" : discount.ToString())}";
lblPrice.Text = $"Total Price: {invoiceTotal}";
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
cboAttractions.DataSource = db.Attractions;
cboAttractions.DisplayMember = "AttractionsName";
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
cboAttractions.DataSource = db.Attractions.ToList().Where(x => x.isStageDrama).ToList();
cboAttractions.DisplayMember = "AttractionsName";
}
public void DataRefresh()
{
db = new DisneyDataDataContext();
cboTraffic.DataSource = db.TrafficMethod;
cboTraffic.DisplayMember = "Method";
}
