private void btnSave_Click(object sender, EventArgs e)
{
try
{
//Facility entity class created by entity framework
if (txtFacName.Text == "")
{
MessageBox.Show("Please enter all the fields to save");
}
else
{
fac.FacilityId = Convert.ToInt32(txtFacilityId.Text);
fac.FacilityName = txtFacName.Text;
//DB Table name 'facilities'
sports.facilities.AddObject(fac);
var insSlotVsFacility = from x in sports.slots select x;
foreach (slot sf in insSlotVsFacility.ToList())
{
svf = new slotvsFacility();
svf.FacilityId = fac.FacilityId;
svf.SlotId = sf.SlotId;
svf.Available = "Y";
sports.slotvsFacilities.AddObject(svf);
}
sports.SaveChanges();
display();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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);
}
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 frmFacility_Load(object sender, EventArgs e)
{
sports = new SportsAllEntities();
fac = new facility();
svfDel = new slotvsFacility();
}
