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();
}
