/// <summary> /// Creates a new connection record /// </summary> /// <param name="Connection"></param> /// <returns></returns> public static Connection CreateConnection(Connection Connection) { using (DatabaseContext db = new DatabaseContext()) { db.Connections.Add(Connection); db.Entry(Connection).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); return Connection; } }
/// <summary> /// Creates a new solution record and returns the updated object /// </summary> /// <param name="solution"></param> /// <returns></returns> public static Solution CreateSolution(Solution solution) { using (DatabaseContext db = new DatabaseContext()) { db.Solutions.Add(solution); db.Entry(solution).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); return solution; } }
/// <summary> /// Updates a solution record /// </summary> /// <param name="solution"></param> /// <returns></returns> public static void UpdateSolution(Solution solution) { using (DatabaseContext db = new DatabaseContext()) { db.Solutions.Add(solution); db.Entry(solution).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Saves the settings /// </summary> /// <param name="settings"></param> public static void SaveSettings(Settings settings) { using (DatabaseContext db = new DatabaseContext()) { db.Settings.Add(settings); db.Entry(settings).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Deletes a solution /// </summary> /// <param name="solution"></param> public static void DeleteSolution(Solution solution) { using (DatabaseContext db = new DatabaseContext()) { db.Entry(solution).State = System.Data.Entity.EntityState.Deleted; db.Solutions.Remove(solution); db.SaveChanges(); } }
/// <summary> /// Deletes a connection /// </summary> /// <param name="Connection"></param> public static void DeleteConnection(Connection Connection) { using (DatabaseContext db = new DatabaseContext()) { db.Entry(Connection).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } }