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