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