//ADDING DATA - Save to DB
private Boolean AddData(string dueDay, string dueHour, string dueMin, string taskName, string className, string desc)
{
try
{
if (ThisReminder == null)
{
ThisReminder = new ReminderModel2();
}
var TaskTbl = new TaskTbl()
{
DueDay = dueDay,
DueHour = dueHour,
DueMin = dueMin,
TaskName = taskName,
ClassName = className,
Desc = desc,
};
ThisReminder.TaskTbls.Add(TaskTbl);
//Persists
ThisReminder.SaveChanges();
//FILL DGV
FillDGView(ThisReminder.TaskTbls.ToList());
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
//ADDING DATA - Save to DB
private Boolean AddData(string className, string meetingLink, string attendanceLink, string driveLink, string day, string hour, string min)
{
try
{
if (ThisReminder == null)
{
ThisReminder = new ReminderModel2();
}
var classTbl = new ClassTbl()
{
ClassName = className,
MeetingLink = meetingLink,
AttendanceLink = attendanceLink,
DriveLink = driveLink,
Day = day,
Hour = hour,
Min = min,
};
ThisReminder.ClassTbls.Add(classTbl);
//Persists
ThisReminder.SaveChanges();
//FILL DGV
FillDGView(ThisReminder.ClassTbls.ToList());
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (var db = new ReminderModel2())
{
db.TaskTbls.RemoveRange(db.TaskTbls.Where(item => item.TaskName == tbTaskName.Text));
db.SaveChanges();
Clear();
retrieve(); //auto refresh table
}
}
