private void dataGridView1_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
mappingid = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
tblTeacherSubjectMapping tb = db.tblTeacherSubjectMappings.Where(a => a.TeacherSubjectMappingId == mappingid).FirstOrDefault();
cboSubject.Text = tb.tblSubject.SubjectName;
cboTeacher.Text = tb.tblTeacher.TeacherName;
}
private void btnDelete_Click(object sender, EventArgs e)
{
tblTeacherSubjectMapping tb = db.tblTeacherSubjectMappings.Where(a => a.TeacherSubjectMappingId == mappingid).FirstOrDefault();
db.tblTeacherSubjectMappings.Remove(tb);
if (db.SaveChanges() > 0)
{
MessageBox.Show("Mapping Deleted");
LoadGrid();
ClearData();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
tblTeacherSubjectMapping tb = db.tblTeacherSubjectMappings.Where(a => a.TeacherSubjectMappingId == mappingid).FirstOrDefault();
tb.TeacherId = Convert.ToInt32(cboTeacher.SelectedValue);
tb.SubjectId = Convert.ToInt32(cboSubject.SelectedValue);
if (db.SaveChanges() > 0)
{
MessageBox.Show("Mapping Updated");
LoadGrid();
ClearData();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
tblTeacherSubjectMapping tb = new tblTeacherSubjectMapping();
tb.TeacherId = Convert.ToInt32(cboTeacher.SelectedValue);
tb.SubjectId = Convert.ToInt32(cboSubject.SelectedValue);
db.tblTeacherSubjectMappings.Add(tb);
if (db.SaveChanges() > 0)
{
MessageBox.Show("Mapping Added");
LoadGrid();
ClearData();
}
}
