private void btn_teacher_save_Click(object sender, EventArgs e) { db = new PreSchoolEntities1(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_teacher_room_name.Text) .Select(a => a.id) .FirstOrDefault(); var newActivity = new tbl_subject_activity() { subject = txt_subject_subjectName.Text, date = gunaDateTimePicker1.Value, note = not_teacher_subject.Text, datetime_save = DateTime.Now, id_user_save = userClass.getUserId(), id_room_name = roomId }; db.tbl_subject_activity.Add(newActivity); db.SaveChangesAsync(); MessageBox.Show("New Activity Added"); }
private void btn_rooms_save_Click(object sender, EventArgs e) { try { if (gbActivityId > 0) { db = new PreSchoolEntities1(); var activity = db.tbl_subject_activity.Where(item => item.id == gbActivityId).First(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_teacher_room_name.Text) .Select(a => a.id) .FirstOrDefault(); activity.datetime_update = DateTime.Now; activity.id_user_update = userClass.getUserId(); activity.date = gunaDateTimePicker1.Value; activity.id_room_name = roomId; activity.subject = txt_subject_subjectName.Text; activity.note = not_teacher_subject.Text; db.SaveChangesAsync(); view(); clear(); } else if (gbActivityId == 0 && combo_teacher_room_name.SelectedIndex != -1 && !String.IsNullOrWhiteSpace(txt_subject_subjectName.Text) && !String.IsNullOrWhiteSpace(not_teacher_subject.Text)) { db = new PreSchoolEntities1(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_teacher_room_name.Text) .Select(a => a.id) .FirstOrDefault(); var newActivity = new tbl_subject_activity() { datetime_save = DateTime.Now, id_user_save = userClass.getUserId(), id_room_name = roomId, date = gunaDateTimePicker1.Value, subject = txt_subject_subjectName.Text, note = not_teacher_subject.Text, }; db.tbl_subject_activity.Add(newActivity); db.SaveChangesAsync(); view(); clear(); } else { MessageBox.Show("Please Select Some Data To Edit Or Add New Data"); } } catch (Exception) { MessageBox.Show("Error Adding New Subject Activity"); } }