/// <summary> /// Update the database with changes /// </summary> public int DBUpdate() { try { using (var db = new UberEversolContext()) { var result = db.Sessions.FirstOrDefault(s => s.id == this.id); if (result != null) { result.title = this.title; result.description = this.description; result.folderDir = this.folderDir; result.created = this.created; result.hit_count = this.hit_count; db.SaveChanges(); } } return(0); } catch (Exception e) { return(-1); } }
/// <summary> /// Remove the selected subject from db /// </summary> /// <param name="id"></param> public void DBRemove() { using (var db = new UberEversolContext()) { db.Tracks.Remove(this); db.SaveChanges(); } }
/// <summary> /// Save the object to the database /// </summary> public void DBSave() { using (var db = new UberEversolContext()) { db.Sessions.Add(this); db.SaveChanges(); } }
/// <summary> /// Increment Hit Count /// </summary> public void Hit() { this.hit_count += 1; using (var db = new UberEversolContext()) { var result = db.Subjects.FirstOrDefault(s => s.id == this.id); result.hit_count += 1; db.SaveChanges(); } }
/// <summary> /// Rating Decrement /// </summary> public void RatingMinus() { this.user_rating -= 1; using (var db = new UberEversolContext()) { var result = db.Subjects.FirstOrDefault(s => s.id == this.id); result.user_rating -= 1; db.SaveChanges(); } }
/// <summary> /// Update the database with changes /// </summary> public void DBUpdate() { using (var db = new UberEversolContext()) { var result = db.Subjects.FirstOrDefault(s => s.id == this.id); if (result != null) { result.first_name = this.first_name; result.last_name = this.last_name; result.created = this.created; result.user_rating = this.user_rating; db.SaveChanges(); } } }
/// <summary> /// Update the database with changes /// </summary> public void DBUpdate() { using (var db = new UberEversolContext()) { var result = db.Tracks.FirstOrDefault(t => t.id == this.id); if (result != null) { result.id = this.id; result.session_id = this.session_id; result.title = this.title; result.description = this.description; result.duration = this.duration; result.file_name = this.file_name; result.file_dir = this.file_dir; result.file_size = this.file_size; result.subject = this.subject; result.subject_id = this.subject_id; result.keywords = this.keywords; db.SaveChanges(); } } }