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