private void DGVSchedule_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { DataGridViewRow row = DGVSchedule.Rows[e.RowIndex]; using (SampleDataContext db = new SampleDataContext()) { ds = db.DetailSchedules.Where(d => d.DetailId == Convert.ToInt32(row.Cells["DetailId"].Value.ToString())).FirstOrDefault(); } } }
private void BtnDelete_Click(object sender, EventArgs e) { if (GlobalUse.GetChoiceMessage("Are you sure you want to delete this schedule?") == false) { return; } using (SampleDataContext db = new SampleDataContext()) { DetailSchedule ds = db.DetailSchedules.Where(d => d.DetailId == this.ds.DetailId).FirstOrDefault(); db.DetailSchedules.DeleteOnSubmit(ds); db.SubmitChanges(); } RefreshDGV(); }
public DetailSchedule getAllInfoCaThi(int idcathi) { DetailSchedule ca = (from a in db.CATHIs join b in db.ChiTietCaThis on a.ID equals b.IDCa join c in db.Subjects on b.SubjectID equals c.SubjectID where a.ID == idcathi select new DetailSchedule() { ID = a.ID, MaKhoaThi = a.MaKhoaThi, IDChiTietCa = b.ID, MaChiTietCa = b.MaChiTietCa, SubjectID = b.SubjectID, IDMon = c.idSub, NameSubject = c.Descr }).SingleOrDefault(); return(ca); }