private void btnSave_Click(object sender, EventArgs e) { try { bfc = new BookingFacilityControl(); sports = new SportsAllEntities(); book = new booking(); svf = new slotvsFacility(); book.BookingId = Convert.ToInt32(txtbookingId.Text); book.MemberId = Convert.ToInt32(txtMemId.Text); book.FacilityId = GetSelectedFacility; book.SlotID = Convert.ToInt32(HiddenSlotIdLabel.Text); book.DateOfUse = dateOfUseddtp.Value.ToShortDateString(); book.WeekdayName = dateOfUseddtp.Value.DayOfWeek.ToString(); book.confirmed = "Y"; bfc.saveBooking(book); DialogResult r = MessageBox.Show("Do you want a Booking Receipt", "Booking Receipt", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (r == System.Windows.Forms.DialogResult.Yes) { bfc.showBookingReceipt(book.BookingId); } displayControlValues(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public bool processCancelBooking(booking bookObj) { sports = new SportsAllEntities(); book = new booking(); svf = new slotvsFacility(); var bookingRec = from y in sports.bookings where y.BookingId == bookObj.BookingId select y; book = bookingRec.First <booking>(); var slotFacId = from z in sports.slotvsFacilities where z.FacilityId == book.FacilityId && z.SlotId == book.SlotID select z; svf = slotFacId.First <slotvsFacility>(); svf.Available = "Y"; book.confirmed = "N"; using (TransactionScope ts = new TransactionScope()) { sports.SaveChanges(); sports.SaveChanges(); ts.Complete(); return(true); } //return false; }
private void frmBookingFacility_Load(object sender, EventArgs e) { sports = new SportsAllEntities(); book = new booking(); fac = new facility(); svf = new slotvsFacility(); dateOfUseddtp.Value = DateTime.Now.AddDays(1); }
private void ViewFacilities_Load(object sender, EventArgs e) { sports = new SportsAllEntities(); fac = new facility(); var selectAll = from x in sports.facilities orderby x.FacilityId select x; FacilityGrid.DataSource = selectAll.ToList(); }
public string getFacilityName(int facID) { sports = new SportsAllEntities(); fac = new facility(); var SelfacilityName = from x in sports.facilities where x.FacilityId == facID select x; fac = SelfacilityName.First <facility>(); return(fac.FacilityName.ToString()); }
public void viewCancelledBooking() { sports = new SportsAllEntities(); cancelledBook = new CancelledBooking(); var cancelledBooking = from y in sports.CancelledBookings select y; ViewBooking vb = new ViewBooking("Cancel"); vb.collectList = cancelledBooking.ToList <CancelledBooking>(); vb.ShowDialog(); }
public slot getSlotTime(int slotId) { sports = new SportsAllEntities(); slotTimings = new slot(); var SelSlotTime = from x in sports.slots where x.SlotId == slotId select x; slotTimings = SelSlotTime.First <slot>(); return(slotTimings); }
public string getFacilityIdAndName(int bookId) { sports = new SportsAllEntities(); bookFacId = new booking(); var SelfacilityId = from x in sports.bookings where x.BookingId == bookId select x; bookFacId = SelfacilityId.First <booking>(); string facName = getFacilityName(bookFacId.FacilityId); return(facName); }
public slot getSlotIdAndTime(int bookId) { sports = new SportsAllEntities(); bookSlotId = new booking(); var SelSlotId = from x in sports.bookings where x.BookingId == bookId select x; bookSlotId = SelSlotId.First <booking>(); slot slotTime = getSlotTime(bookSlotId.SlotID); return(slotTime); }
private void SlotLookUpForm_Load(object sender, EventArgs e) { sports = new SportsAllEntities(); fac = new facility(); var selectAll = from f in sports.facilities join svsf in sports.slotvsFacilities on f.FacilityId equals svsf.FacilityId where svsf.Available == "Y" && svsf.FacilityId == SelFac join s in sports.slots on svsf.SlotId equals s.SlotId select new { s.SlotId, s.StartTime, s.EndTime }; SlotGrid.DataSource = selectAll.ToList(); }
private void FacilityNameComboBox_SelectedIndexChanged(object sender, EventArgs e) { context = new SportsAllEntities(); FacilityNameComboBox.Items.Clear(); var records = from x in context.facilities select x; foreach (facility f in records.ToList()) { FacilityNameComboBox.Items.Add(f.FacilityName); } }
private void frmMemberLookup_Load(object sender, EventArgs e) { sports = new SportsAllEntities(); if (GetBookingType.Equals("cancel")) { var selectAll = collectList; MemberGrid.DataSource = selectAll.ToList(); } else { var selectAll = from x in sports.members orderby x.MemberId select x; MemberGrid.DataSource = selectAll.ToList(); } }
private void btnUpdate_Click(object sender, EventArgs e) { sports = new SportsAllEntities(); int facId = Convert.ToInt32(txtFacilityId.Text); fac = new facility(); var facilityUpdate = from x in sports.facilities where x.FacilityId == facId select x; fac = facilityUpdate.First <facility>(); fac.FacilityName = txtFacName.Text; sports.SaveChanges(); display(); }
public string display() { sports = new SportsAllEntities(); var selectId = from x in sports.bookings orderby x.BookingId descending select x; int recordCount = selectId.Count <booking>(); if (recordCount == 0) { return("1"); } else { book = selectId.First <booking>(); return((book.BookingId + 1).ToString()); } }
public List <member> getBookedMembers() { sports = new SportsAllEntities(); bookMem = new BookedMember(); List <member> BookedMems = new List <member>(); var selectBookedMem = from x in sports.BookedMembers select x; foreach (BookedMember boo in selectBookedMem.ToList <BookedMember>()) { member mem = new member(); mem.MemberId = boo.MemberId; mem.MemberName = boo.MemberName; BookedMems.Add(mem); } return(BookedMems.ToList <member>()); }
public List <booking> GetBookingIds(int membId) { sports = new SportsAllEntities(); List <booking> bookingIdList = new List <booking>(); var facilityBooked = from x in sports.bookings where x.MemberId == membId && x.confirmed == "Y" select x; foreach (booking boo in facilityBooked.ToList <booking>()) { booking book = new booking(); book.BookingId = boo.BookingId; bookingIdList.Add(book); } return(bookingIdList); }
private void ViewBooking_Load(object sender, EventArgs e) { sports = new SportsAllEntities(); if (cancelBook.Equals("Cancel")) { bookingGrid.DataSource = cb; } else { var selectAll = from x in sports.CurrentBookings select x; bookingGrid.DataSource = selectAll.ToList(); } bookingGrid.Columns[0].HeaderText = "Booking Id"; bookingGrid.Columns[1].HeaderText = "Member Name"; bookingGrid.Columns[2].HeaderText = "Start Time"; bookingGrid.Columns[3].HeaderText = "End Time"; bookingGrid.Columns[4].HeaderText = "Facility Name"; bookingGrid.Columns[5].HeaderText = "Date Of Use"; }
public void saveBooking(booking book) { sports = new SportsAllEntities(); svf = new slotvsFacility(); int facId = book.FacilityId; int slotId = book.SlotID; var updateSlotVsFacility = from x in sports.slotvsFacilities where x.FacilityId == facId && x.SlotId == slotId select x; svf = updateSlotVsFacility.First <slotvsFacility>(); svf.Available = "N"; using (TransactionScope ts = new TransactionScope()) { sports.SaveChanges(); sports.bookings.AddObject(book); sports.SaveChanges(); ts.Complete(); } }
private void LoginButton_Click(object sender, EventArgs e) { SportsAllEntities context = new SportsAllEntities(); var q = from x in context.users select x; foreach (var x in q) { if ((x.username == UsernameTextBox.Text) && (x.passwords == PasswordTextBox.Text)) { LaunchPadForm f = new LaunchPadForm(); f.Show(); this.Hide(); } else { MessageBox.Show("The username or password you entered is incorrect"); } } }
private void CheckAvailabilityButton_Click(object sender, EventArgs e) { context = new SportsAllEntities(); FacilityNameComboBox.Items.Clear(); string facname = FacilityNameComboBox.Text; var records = from s in context.slots join sf in context.slotvsFacilities on s.SlotId equals sf.SlotId where sf.Available == "Y" join f in context.facilities on sf.FacilityId equals f.FacilityId where f.FacilityName == facname select new { s.SlotId, s.StartTime, s.EndTime }; SearchDataGrid.DataSource = records.ToList(); }
private void frmFacility_Load(object sender, EventArgs e) { sports = new SportsAllEntities(); fac = new facility(); svfDel = new slotvsFacility(); }