public void EditData() { using (var db = new ReminderModel()) { var result = db.ClassTbls.SingleOrDefault(k => k.ClassName == tbMatkul.Text); if (result != null) { if (tbMatkul.Text != "" && tbMeeting.Text != "" && tbPresensi.Text != "" && tbDrive.Text != "" && cbHari.Text != "" && cbHour.Text != "" && cbMin.Text != "") { result.MeetingLink = tbMatkul.Text; result.AttendanceLink = tbPresensi.Text; result.DriveLink = tbDrive.Text; result.Day = cbHari.Text; result.Hour = cbHour.Text; result.Min = cbMin.Text; db.SaveChanges(); MessageBox.Show("Class berhasil diperbaharui"); } else { MessageBox.Show("Semua data harus diisi"); } } } }
private void btnEdit_Click(object sender, EventArgs e) { try { newClassTbl = new ClassTbl { ClassName = tbMatkul.Text, MeetingLink = tbMeeting.Text, AttendanceLink = tbPresensi.Text, DriveLink = tbDrive.Text, Day = cbHari.Text, Hour = cbHour.Text, Min = cbMin.Text, }; using (var db = new ReminderModel()) { db.ClassTbls.AddOrUpdate(newClassTbl); db.SaveChanges(); populate(); } MessageBox.Show("Done"); }catch (Exception ezpz) { MessageBox.Show(ezpz.Message); } }
private void AddData() { if (tbMatkul.Text != "" && tbMeeting.Text != "" && tbPresensi.Text != "" && tbDrive.Text != "" && cbHari.Text != "" && cbHour.Text != "" && cbMin.Text != "") { using (var db = new ReminderModel()) { newClassTbl = new ClassTbl { ClassName = tbMatkul.Text, MeetingLink = tbMeeting.Text, AttendanceLink = tbPresensi.Text, DriveLink = tbDrive.Text, Day = cbHari.Text, Hour = cbHour.Text, Min = cbMin.Text, }; db.ClassTbls.Add(newClassTbl); db.SaveChanges(); populate(); MessageBox.Show("Class Ditambahkan"); } } else { MessageBox.Show("Semua data harus diisi!"); } }
private void btnDelete_Click(object sender, EventArgs e) { using (var db = new ReminderModel()) { db.ClassTbls.RemoveRange(db.ClassTbls.Where(item => item.ClassName == tbMatkul.Text)); db.SaveChanges(); Clear(); populate(); } }