private void button3_Click(object sender, EventArgs e)
{
modelEntities2 context = new modelEntities2();
int bid = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());
var query = from x in context.bookingdetails
where x.bookingid == bid
select x;
bookingdetail bd = query.First <bookingdetail>();
context.bookingdetails.DeleteObject(bd);
context.SaveChanges();
RefreshDataGridView();
}
/// <summary>
/// Create a new bookingdetail object.
/// </summary>
/// <param name="bookingid">Initial value of the bookingid property.</param>
/// <param name="memberid">Initial value of the memberid property.</param>
/// <param name="equipmentid">Initial value of the equipmentid property.</param>
/// <param name="dateofbooking">Initial value of the dateofbooking property.</param>
/// <param name="c8_9_am">Initial value of the C8_9_am property.</param>
/// <param name="c9_10_am">Initial value of the C9_10_am property.</param>
/// <param name="c10_11_am">Initial value of the C10_11_am property.</param>
/// <param name="c11_12_noon">Initial value of the C11_12_noon property.</param>
/// <param name="c2_3_pm">Initial value of the C2_3_pm property.</param>
/// <param name="c3_4_pm">Initial value of the C3_4_pm property.</param>
/// <param name="c_4_5_pm">Initial value of the C_4_5_pm property.</param>
/// <param name="c5_6_pm">Initial value of the C5_6_pm property.</param>
/// <param name="c6_7_pm">Initial value of the C6_7_pm property.</param>
/// <param name="c7_8_pm">Initial value of the C7_8_pm property.</param>
public static bookingdetail Createbookingdetail(global::System.Int32 bookingid, global::System.Int32 memberid, global::System.Int32 equipmentid, global::System.DateTime dateofbooking, global::System.Int16 c8_9_am, global::System.Int16 c9_10_am, global::System.Int16 c10_11_am, global::System.Int16 c11_12_noon, global::System.Int16 c2_3_pm, global::System.Int16 c3_4_pm, global::System.Int16 c_4_5_pm, global::System.Int16 c5_6_pm, global::System.Int16 c6_7_pm, global::System.Int16 c7_8_pm)
{
bookingdetail bookingdetail = new bookingdetail();
bookingdetail.bookingid = bookingid;
bookingdetail.memberid = memberid;
bookingdetail.equipmentid = equipmentid;
bookingdetail.dateofbooking = dateofbooking;
bookingdetail.C8_9_am = c8_9_am;
bookingdetail.C9_10_am = c9_10_am;
bookingdetail.C10_11_am = c10_11_am;
bookingdetail.C11_12_noon = c11_12_noon;
bookingdetail.C2_3_pm = c2_3_pm;
bookingdetail.C3_4_pm = c3_4_pm;
bookingdetail.C_4_5_pm = c_4_5_pm;
bookingdetail.C5_6_pm = c5_6_pm;
bookingdetail.C6_7_pm = c6_7_pm;
bookingdetail.C7_8_pm = c7_8_pm;
return(bookingdetail);
}
private void button2_Click(object sender, EventArgs e)
{
modelEntities2 context = new modelEntities2();
DateTime bookingDate = BookingDateDTP.Value.Date;
int r = Convert.ToInt16(comboBox1.SelectedValue);
var q = (from x in context.sportfacilities
where x.equipmentid == (r)
select(x.facilityavailable));
String x1 = Convert.ToString(q.First());
Int16 temp1 = Convert.ToInt16(x1);
int temp2 = (from x in context.bookingdetails
where x.equipmentid == (r) && x.dateofbooking == bookingDate
select x.memberid).Count();
if (temp2 <= temp1)
{
int read = temp1 - temp2;
MessageBox.Show("Currently have" + "\t" + read + "\t" + "facility available");
int memId = Convert.ToInt32(MemberCombo.SelectedItem.ToString());
bookingdetail bk = new bookingdetail();
int eqId = Convert.ToInt32(comboBox1.SelectedItem.ToString());
bk.memberid = memId;
bk.equipmentid = eqId;
bk.dateofbooking = bookingDate;
if ((string)comboBox2.SelectedItem == "8-9am")
{ //used to set slot , member id,date of playing(date of booking),sports required to play
bk.C8_9_am = 1;
bk.C9_10_am = 0; bk.C10_11_am = 0; bk.C11_12_noon = 0; bk.C2_3_pm = 0;
bk.C3_4_pm = 0; bk.C_4_5_pm = 0; bk.C5_6_pm = 0; bk.C6_7_pm = 0; bk.C7_8_pm = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else if ((string)comboBox2.SelectedItem == "9-10am")
{
bk.C9_10_am = 1;
bk.C8_9_am = 0; bk.C10_11_am = 0; bk.C11_12_noon = 0; bk.C2_3_pm = 0;
bk.C3_4_pm = 0; bk.C_4_5_pm = 0; bk.C5_6_pm = 0; bk.C6_7_pm = 0; bk.C7_8_pm = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else if ((string)comboBox2.SelectedItem == "10-11am")
{
bk.C10_11_am = 1;
bk.C9_10_am = 0; bk.C8_9_am = 0; bk.C11_12_noon = 0; bk.C2_3_pm = 0;
bk.C3_4_pm = 0; bk.C_4_5_pm = 0; bk.C5_6_pm = 0; bk.C6_7_pm = 0; bk.C7_8_pm = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else if ((string)comboBox2.SelectedItem == "11-12noon")
{
bk.C11_12_noon = 1;
bk.C9_10_am = 0; bk.C10_11_am = 0; bk.C8_9_am = 0; bk.C2_3_pm = 0;
bk.C3_4_pm = 0; bk.C_4_5_pm = 0; bk.C5_6_pm = 0; bk.C6_7_pm = 0; bk.C7_8_pm = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else if ((string)comboBox2.SelectedItem == "2-3pm")
{
bk.C2_3_pm = 1;
bk.C9_10_am = 0; bk.C10_11_am = 0; bk.C11_12_noon = 0; bk.C8_9_am = 0;
bk.C3_4_pm = 0; bk.C_4_5_pm = 0; bk.C5_6_pm = 0; bk.C6_7_pm = 0; bk.C7_8_pm = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else if ((string)comboBox2.SelectedItem == "3-4pm")
{
bk.C3_4_pm = 1;
bk.C9_10_am = 0; bk.C10_11_am = 0; bk.C11_12_noon = 0; bk.C2_3_pm = 0;
bk.C8_9_am = 0; bk.C_4_5_pm = 0; bk.C5_6_pm = 0; bk.C6_7_pm = 0; bk.C7_8_pm = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else if ((string)comboBox2.SelectedItem == "4-5pm")
{
bk.C_4_5_pm = 1;
bk.C9_10_am = 0; bk.C10_11_am = 0; bk.C11_12_noon = 0; bk.C2_3_pm = 0;
bk.C3_4_pm = 0; bk.C8_9_am = 0; bk.C5_6_pm = 0; bk.C6_7_pm = 0; bk.C7_8_pm = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else if ((string)comboBox2.SelectedItem == "5-6pm")
{
bk.C5_6_pm = 1;
bk.C9_10_am = 0; bk.C10_11_am = 0; bk.C11_12_noon = 0; bk.C2_3_pm = 0;
bk.C3_4_pm = 0; bk.C_4_5_pm = 0; bk.C8_9_am = 0; bk.C6_7_pm = 0; bk.C7_8_pm = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else if ((string)comboBox2.SelectedItem == "6-7pm")
{
bk.C6_7_pm = 1;
bk.C9_10_am = 0; bk.C10_11_am = 0; bk.C11_12_noon = 0; bk.C2_3_pm = 0;
bk.C3_4_pm = 0; bk.C_4_5_pm = 0; bk.C5_6_pm = 0; bk.C8_9_am = 0; bk.C7_8_pm = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else if (Convert.ToString(comboBox2.SelectedItem) == "7-8pm")
{
bk.C7_8_pm = 1;
bk.C9_10_am = 0; bk.C10_11_am = 0; bk.C11_12_noon = 0; bk.C2_3_pm = 0;
bk.C3_4_pm = 0; bk.C_4_5_pm = 0; bk.C5_6_pm = 0; bk.C6_7_pm = 0; bk.C8_9_am = 0;
bk.equipmentid = Convert.ToInt16(comboBox1.SelectedItem);
}
else
{
MessageBox.Show("enter valid member or time slot");
}
context.AddTobookingdetails(bk);
context.SaveChanges();
}
else
{
MessageBox.Show("Cannot book all Facility are filled");
}
}
/// <summary>
/// Deprecated Method for adding a new object to the bookingdetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTobookingdetails(bookingdetail bookingdetail)
{
base.AddObject("bookingdetails", bookingdetail);
}