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