public static int InsertSchoolStream(SchoolStream stream)
{
//create DBContext object
using (var smsDB = new SMSEntities())
{
smsDB.SchoolStreams.Add(stream);
return(smsDB.SaveChanges());
}
}
public static int EditSchoolStream(SchoolStream stream)
{
//create DBContext object
using (var smsDB = new SMSEntities())
{
SchoolStream schoolStream = smsDB.SchoolStreams.Find(stream.SchoolStreamID);
schoolStream.SchoolID = stream.SchoolID;
schoolStream.StreamID = stream.StreamID;
return(smsDB.SaveChanges());
}
}
public static int DeleteSchoolStream(SchoolStream stream)
{
using (var smsDB = new SMSEntities())
{
SchoolStream schoolStream = smsDB.SchoolStreams.Find(stream);
if (schoolStream != null)
{
smsDB.SchoolStreams.Remove(schoolStream);
return(smsDB.SaveChanges());
}
else
{
return(0); // no record found
}
}
}
