public void DeleteSpecEvent(int id)
{
var db = new MyDatabaseEntities();
var specEve = db.SpecEvents.Find(id);
db.SpecEvents.Remove(specEve);
db.SaveChanges();
db.Dispose();
}
public void DeleteTask(int id)
{
var db = new MyDatabaseEntities();
var task = db.Tasks.Find(id);
db.Tasks.Remove(task);
db.SaveChanges();
db.Dispose();
}
public void DeleteHabit(int id)
{
var db = new MyDatabaseEntities();
var habit = db.Routines.Find(id);
db.Routines.Remove(habit);
db.SaveChanges();
db.Dispose();
}
public void EditPrioHabit(int id, bool prio)
{
var db = new MyDatabaseEntities();
var habit = db.Routines.Find(id);
habit.Prio = prio;
db.Entry(habit).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
public void EditPrioEvent(int id, bool prio)
{
var db = new MyDatabaseEntities();
var speEvent = db.SpecEvents.Find(id);
speEvent.Prio = prio;
db.Entry(speEvent).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
public void EditPrioTask(int id, bool prio)
{
var db = new MyDatabaseEntities();
var task = db.Tasks.Find(id);
task.Prio = prio;
db.Entry(task).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
public void EditHabit(int id, string title, string detail)
{
var db = new MyDatabaseEntities();
var habit = db.Routines.Find(id);
habit.Title = title;
habit.Details = detail;
db.Entry(habit).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
public void EditTask(int id, string title, string detail)
{
var db = new MyDatabaseEntities();
var task = db.Tasks.Find(id);
task.Title = title;
task.Details = detail;
db.Entry(task).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
public void CreateHabit(string title, string detail, bool prio, bool status)
{
var habit = new Routine();
habit.Title = title;
habit.Details = detail;
habit.Prio = prio;
habit.Status = status;
var db = new MyDatabaseEntities();
db.Routines.Add(habit);
db.SaveChanges();
db.Dispose();
}
public void EditSpecEvent(int id, string title, string detail, string location, string start, string end)
{
var db = new MyDatabaseEntities();
var specEve = db.SpecEvents.Find(id);
specEve.Title = title;
specEve.Location = location;
specEve.Start = start;
specEve.EndTime = end;
specEve.Details = detail;
db.Entry(specEve).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
public void CreateTask(DateTime datetime, string title, string detail, bool prio, bool status)
{
var task = new Task();
task.DateTime = datetime;
task.Title = title;
task.Details = detail;
task.Prio = prio;
task.Status = status;
var db = new MyDatabaseEntities();
db.Tasks.Add(task);
db.SaveChanges();
db.Dispose();
}
public void CreateSpecEvent(DateTime datetime, string title, string location, string start, string end, string detail, bool prio, bool status)
{
var specEve = new SpecEvent();
specEve.DateTime = datetime;
specEve.Title = title;
specEve.Location = location;
specEve.Start = start;
specEve.EndTime = end;
specEve.Details = detail;
specEve.Prio = prio;
specEve.Status = status;
var db = new MyDatabaseEntities();
db.SpecEvents.Add(specEve);
db.SaveChanges();
db.Dispose();
}
public List <Routine> GetHabits()
{
var db = new MyDatabaseEntities();
return(db.Routines.ToList());
}
public List <SpecEvent> GetSpecEvents()
{
var db = new MyDatabaseEntities();
return(db.SpecEvents.ToList());
}
public List <Task> GetTasks()
{
var db = new MyDatabaseEntities();
return(db.Tasks.ToList());
}