public bool UpdateLiveVideos(LiveVideo lv)
{
DataClassesDBDataContext db = new DataClassesDBDataContext();
db.LiveVideos.Attach(lv, GetLiveVideoById(lv.id));
db.SubmitChanges();
return true;
}
public List<LiveVideo> GetLiveVideos()
{
DataClassesDBDataContext db = new DataClassesDBDataContext();
var mLiveVideos = from livevideo in db.LiveVideos
select livevideo;
return mLiveVideos.ToList();
}
public bool UpdateLiveVideosDesc(String desc, int id)
{
DataClassesDBDataContext db = new DataClassesDBDataContext();
LiveVideo lv = new LiveVideo();
lv.desc = desc;
lv.id = id;
db.LiveVideos.Attach(lv, GetLiveVideoById(id));
db.SubmitChanges();
return true;
}
public LiveVideo GetLiveVideoById(int id)
{
DataClassesDBDataContext db = new DataClassesDBDataContext();
return db.LiveVideos.Single(c => c.id == id);
}
