public bool DelSche(string id)
{
try
{
SyllabusSchedule delsche = db.SyllabusSchedules.Where(ss => ss.id == id).Single();
db.SyllabusSchedules.DeleteOnSubmit(delsche);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool isEdit(string id, int number)
{
try
{
SyllabusSchedule sc = db.SyllabusSchedules.Where(sz => sz.id == id).Single();
if (sc.NumberPeriods == number)
{
return(false);
}
else
{
return(true);
}
}
catch
{
return(false);
}
}
public bool EditSche(string id, DateTime date, int number, string content, string acitve, string doc, bool mid)
{
try
{
SyllabusSchedule editsche = db.SyllabusSchedules.Where(ss => ss.id == id).Single();
editsche.Day = date;
editsche.NumberPeriods = number;
editsche.LectureContent = content;
editsche.Activites = acitve;
editsche.Doc = doc;
editsche.mid = mid;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool AddSche(string idS, DateTime date, int number, string content, string acitve, string doc, bool mid)
{
try
{
SyllabusSchedule addsche = new SyllabusSchedule();
addsche.id = createScheID();
addsche.idSyllabus = idS;
addsche.Day = date;
addsche.NumberPeriods = number;
addsche.LectureContent = content;
addsche.Activites = acitve;
addsche.Doc = doc;
addsche.mid = mid;
db.SyllabusSchedules.InsertOnSubmit(addsche);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
