/// <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> /// 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> /// 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> /// Gets a solution by ID /// </summary> /// <param name="SolutionId"></param> /// <returns></returns> public static Solution GetSolution(int SolutionId) { using (DatabaseContext db = new DatabaseContext()) { Solution solution = db.Solutions.Find(SolutionId); solution.DatabaseConnection = db.Connections.Find(solution.DatabaseConnectionId); return solution; } }
/// <summary> /// Gets a connection by id /// </summary> /// <param name="ConnectionId"></param> /// <returns></returns> public static Connection GetConnection(int ConnectionId) { using (DatabaseContext db = new DatabaseContext()) { return db.Connections.Find(ConnectionId); } }
/// <summary> /// Gets a connection by name /// </summary> /// <param name="ConnectionName"></param> /// <returns></returns> public static Connection GetConnection(string ConnectionName) { using (DatabaseContext db = new DatabaseContext()) { return db.Connections.Where(c => c.ConnectionName == ConnectionName).FirstOrDefault(); } }
/// <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(); } }