/// <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();
}
}
}
