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"; }