private void dgvFacilityList_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
FacilityDetailForm fdl = new FacilityDetailForm();
fdl.TXTFacilityID = SelectedFac;
var query = from x in ctx.Facilities where x.FacilityId == fdl.TXTFacilityID select x;
SA41Team_10B_SportsBookingFacility.Facility fac = new SA41Team_10B_SportsBookingFacility.Facility();
fac = query.First();
fdl.TXTFacilityID = fac.FacilityId;
fdl.TXTName = fac.Name;
fdl.TXTRemarks = fac.Remarks;
fdl.ShowDialog();
}
private void BtnSave_Click(object sender, EventArgs e)
{
SA41Team_10B_SportsBookingFacility.Facility f1 = new SA41Team_10B_SportsBookingFacility.Facility();
// ctx .Facilities.Add
//////f1.Name = textBox1.Text;
////////var query = from x in ctx.Facilities where x .Name == textBox1 .Text select x .FacilityId.Max () ;
//////var query = from x in ctx.Facilities select x.FacilityId.Max();
//////MessageBox.Show(query.ToString());
////////f1.FacilityId = query.ToString()+ 1;
//////var query = from x in ctx.Customers select new { x.CustomerID, x.DOB, x.Email };
//var cus = query.ToList();
//dataGridView1.DataSource = cus;
//f1.FacilityId = txtFacilityID.Text;
f1.FacilityId = "6001";
f1.Name = txtFacilityID.Text;
ctx.Facilities.Add(f1);
ctx.SaveChanges();
}
