Project Introduction
The Health Monitoring Wearable Project aims to develop a comprehensive application that integrates with wearable health devices to monitor and analyze users' health data. Built using ASP.NET and SQL Server, this application will allow users to track vital health metrics such as heart rate, blood pressure, and activity levels. The system will also provide insights through health reports, alerts for abnormal readings, and a community platform for users to share experiences and feedback. The goal is to empower users to take control of their health and wellness through data-driven insights.
Project Objectives
- To create a secure user authentication system for managing user accounts and roles.
- To enable users to register and manage their wearable devices.
- To collect and store health data from wearable devices, including heart rate, blood pressure, and activity levels.
- To provide users with detailed health reports summarizing their health metrics and trends.
- To implement alert notifications for abnormal health readings or significant changes in health data.
- To facilitate user feedback collection for continuous improvement of the application.
- To create a community platform for users to share health-related posts and experiences.
- To ensure data security and privacy for all user health information.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Device Management Module: Allows users to register and manage their wearable health devices.
- Health Data Management Module: Collects and stores health data from devices, including heart rate and blood pressure.
- Activity Tracking Module: Monitors and records user activities, including duration and calories burned.
- Sleep Data Management Module: Tracks and analyzes users' sleep patterns and quality.
- Health Reporting Module: Generates health reports with summaries and recommendations based on collected data.
- Alert Management Module: Sends alerts to users for abnormal health readings or significant changes.
- Feedback Module: Collects user feedback and ratings to improve the application.
- Community Module: Facilitates community posts and interactions among users.
SQL Server Database Tables
-- Users Table
CREATE TABLE Users (
UserId INT PRIMARY KEY IDENTITY(1,1),
Username NVARCHAR(50) NOT NULL UNIQUE,
PasswordHash NVARCHAR(255) NOT NULL,
Email NVARCHAR(100) NOT NULL UNIQUE,
Phone NVARCHAR(15),
RoleId INT,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (RoleId) REFERENCES Roles(RoleId)
);
-- Roles Table
CREATE TABLE Roles (
RoleId INT PRIMARY KEY IDENTITY(1,1),
RoleName NVARCHAR(50) NOT NULL UNIQUE
);
-- Devices Table
CREATE TABLE Devices (
DeviceId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
DeviceName NVARCHAR(100) NOT NULL,
DeviceType NVARCHAR(50), -- e.g., Smartwatch, Fitness Band
SerialNumber NVARCHAR(100) UNIQUE,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- HealthData Table
CREATE TABLE HealthData (
HealthDataId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
Timestamp DATETIME DEFAULT GETDATE(),
HeartRate INT,
BloodPressure NVARCHAR(20), -- e.g., "120/80"
BloodOxygenLevel DECIMAL(5, 2), -- e.g., 98.5
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- HeartRate Table
CREATE TABLE HeartRate (
HeartRateId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
Timestamp DATETIME DEFAULT GETDATE(),
HeartRate INT,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Activity Table
CREATE TABLE Activities (
ActivityId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
ActivityType NVARCHAR(50), -- e.g., Walking, Running
Duration INT, -- Duration in minutes
CaloriesBurned INT,
Timestamp DATETIME DEFAULT GETDATE(),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- SleepData Table
CREATE TABLE SleepData (
SleepDataId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
SleepStart DATETIME,
SleepEnd DATETIME,
Duration INT, -- Duration in minutes
Quality NVARCHAR(50), -- e.g., Good, Fair, Poor
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- HealthReports Table
CREATE TABLE HealthReports (
HealthReportId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
ReportDate DATETIME DEFAULT GETDATE(),
Summary NVARCHAR(MAX),
Recommendations NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Alerts Table
CREATE TABLE Alerts (
AlertId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
AlertType NVARCHAR(50), -- e.g., Heart Rate Alert, Activity Alert
Message NVARCHAR(MAX),
IsAcknowledged BIT DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Feedback Table
CREATE TABLE Feedbacks (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
Comments NVARCHAR(MAX),
Rating INT CHECK (Rating >= 1 AND Rating <= 5),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- CommunityPosts Table
CREATE TABLE CommunityPosts (
PostId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
PostContent NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
Explanation of Tables
Users: Stores user information, including credentials and roles.
Roles: Defines different roles within the system (e.g., admin, user).
Devices: Manages information about wearable devices associated with users.
HealthData: Records various health metrics collected from the wearable device.
HeartRate: Specifically tracks heart rate data over time.
Activities: Logs user activities, including type, duration, and calories burned.
SleepData: Tracks sleep patterns, including start and end times, duration, and quality of sleep.
HealthReports: Generates health reports summarizing user health data and providing recommendations.
Alerts: Manages alerts for users based on health metrics, allowing acknowledgment of alerts.
Feedback: Collects user feedback regarding the application, including ratings and comments.
CommunityPosts: Allows users to create posts within a community, fostering interaction and support.
Creating a Model and Repository Pattern
To create a model and repository pattern using ADO.NET for the provided SQL Server tables in an ASP.NET application, we will follow these steps:
Step 1: Create Models
Define C# classes that represent each table.
Here are the C# model classes for each of the tables:
public class User
{
public int UserId { get; set; }
public string Username { get; set; }
public string PasswordHash { get; set; }
public string Email { get; set; }
public string Phone { get; set; }
public int? RoleId { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Role
{
public int RoleId { get; set; }
public string RoleName { get; set; }
}
public class Device
{
public int DeviceId { get; set; }
public int UserId { get; set; }
public string DeviceName { get; set; }
public string DeviceType { get; set; }
public string SerialNumber { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class HealthData
{
public int HealthDataId { get; set; }
public int UserId { get; set; }
public DateTime Timestamp { get; set; }
public int? HeartRate { get; set; }
public string BloodPressure { get; set; }
public decimal? BloodOxygenLevel { get; set; }
public DateTime CreatedAt { get; set; }
}
public class HeartRate
{
public int HeartRateId { get; set; }
public int UserId { get; set; }
public DateTime Timestamp { get; set; }
public int HeartRate { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Activity
{
public int ActivityId { get; set; }
public int UserId { get; set; }
public string ActivityType { get; set; }
public int Duration { get; set; }
public int CaloriesBurned { get; set; }
public DateTime Timestamp { get; set; }
public DateTime CreatedAt { get; set; }
}
public class SleepData
{
public int SleepDataId { get; set; }
public int UserId { get; set; }
public DateTime SleepStart { get; set; }
public DateTime SleepEnd { get; set; }
public int Duration { get; set; }
public string Quality { get; set; }
public DateTime CreatedAt { get; set; }
}
public class HealthReport
{
public int HealthReportId { get; set; }
public int UserId { get; set; }
public DateTime ReportDate { get; set; }
public string Summary { get; set; }
public string Recommendations { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Alert
{
public int AlertId { get; set; }
public int UserId { get; set; }
public string AlertType { get; set; }
public string Message { get; set; }
public bool IsAcknowledged { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public string Comments { get; set; }
public int Rating { get; set; }
public DateTime CreatedAt { get; set; }
}
public class CommunityPost
{
public int PostId { get; set; }
public int UserId { get; set; }
public string PostContent { get; set; }
public DateTime CreatedAt { get; set; }
}
Step 2: Create Repositories
Next, we will create a generic repository interface and a concrete implementation for each model. Below is an example of a generic repository interface and a concrete repository for the User model.
Generic Repository Interface
public interface IRepository<T>
{
IEnumerable<T> GetAll();
T GetById(int id);
void Add(T entity);
void Update(T entity);
void Delete(int id);
}
User Repository Implementation
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository : IRepository<User>
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<User> GetAll()
{
var users = new List<User>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
users.Add(new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader ["Email"].ToString(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return users;
}
public User GetById(int id)
{
User user = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
user = new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return user;
}
public void Add(User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, Phone, RoleId) VALUES (@Username, @PasswordHash, @Email, @Phone, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", user.Phone);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, Phone = @Phone, RoleId = @RoleId, UpdatedAt = GETDATE() WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", user.UserId);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", user.Phone);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This pattern can be replicated for other models such as Role, Device, HealthData, etc., by creating similar repository classes for each model. Each repository will implement the IRepository
Repository Implementations
Below are the repository implementations for the remaining models: Role, Device, HealthData, HeartRate, Activity, SleepData, HealthReport, Alert, Feedback, and CommunityPost. Each repository will follow the same pattern as the User Repository.
Role Repository
public class RoleRepository : IRepository<Role>
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Role> GetAll()
{
var roles = new List<Role>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
roles.Add(new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
});
}
}
}
return roles;
}
public Role GetById(int id)
{
Role role = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
role = new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
};
}
}
}
return role;
}
public void Add(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Roles (RoleName) VALUES (@RoleName)", connection);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Device Repository
public class DeviceRepository : IRepository<Device>
{
private readonly string _connectionString;
public DeviceRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Device> GetAll()
{
var devices = new List<Device>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Devices", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
devices.Add(new Device
{
DeviceId = (int)reader["DeviceId"],
UserId = (int)reader["User Id"],
DeviceName = reader["DeviceName"].ToString(),
DeviceType = reader["DeviceType"].ToString(),
SerialNumber = reader["SerialNumber"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return devices;
}
public Device GetById(int id)
{
Device device = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Devices WHERE DeviceId = @DeviceId", connection);
command.Parameters.AddWithValue("@DeviceId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
device = new Device
{
DeviceId = (int)reader["DeviceId"],
UserId = (int)reader["User Id"],
DeviceName = reader["DeviceName"].ToString(),
DeviceType = reader["DeviceType"].ToString(),
SerialNumber = reader["SerialNumber"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return device;
}
public void Add(Device device)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Devices (User Id, DeviceName, DeviceType, SerialNumber) VALUES (@User Id, @DeviceName, @DeviceType, @SerialNumber)", connection);
command.Parameters.AddWithValue("@User Id", device.UserId);
command.Parameters.AddWithValue("@DeviceName", device.DeviceName);
command.Parameters.AddWithValue("@DeviceType", device.DeviceType);
command.Parameters.AddWithValue("@SerialNumber", device.SerialNumber);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Device device)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Devices SET UserId = @User Id, DeviceName = @DeviceName, DeviceType = @DeviceType, SerialNumber = @SerialNumber, UpdatedAt = GETDATE() WHERE DeviceId = @DeviceId", connection);
command.Parameters.AddWithValue("@DeviceId", device.DeviceId);
command.Parameters.AddWithValue("@User Id", device.UserId);
command.Parameters.AddWithValue("@DeviceName", device.DeviceName);
command.Parameters.AddWithValue("@DeviceType", device.DeviceType);
command.Parameters.AddWithValue("@SerialNumber", device.SerialNumber);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Devices WHERE DeviceId = @DeviceId", connection);
command.Parameters.AddWithValue("@DeviceId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
HealthData Repository
public class HealthDataRepository : IRepository<HealthData>
{
private readonly string _connectionString;
public HealthDataRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<HealthData> GetAll()
{
var healthDataList = new List<HealthData>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM HealthData", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
healthDataList.Add(new HealthData
{
HealthDataId = (int)reader["HealthDataId"],
UserId = (int)reader["User Id"],
Timestamp = (DateTime)reader["Timestamp"],
HeartRate = reader["HeartRate"] as int?,
BloodPressure = reader["BloodPressure"].ToString(),
BloodOxygenLevel = reader["BloodOxygenLevel"] as decimal?,
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return healthDataList;
}
public HealthData GetById(int id)
{
HealthData healthData = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM HealthData WHERE HealthDataId = @HealthDataId", connection);
command.Parameters.AddWithValue("@HealthDataId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
healthData = new HealthData
{
HealthDataId = (int)reader["HealthDataId"],
UserId = (int)reader["User Id"],
Timestamp = (DateTime)reader["Timestamp"],
HeartRate = reader["HeartRate"] as int?,
BloodPressure = reader["BloodPressure"].ToString(),
BloodOxygenLevel = reader["BloodOxygenLevel"] as decimal?,
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return healthData;
}
public void Add(HealthData healthData)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO HealthData (User Id, Timestamp, HeartRate, BloodPressure, BloodOxygenLevel) VALUES (@User Id, @Timestamp, @HeartRate, @BloodPressure, @BloodOxygenLevel)", connection);
command.Parameters.AddWithValue("@User Id", healthData.UserId);
command.Parameters.AddWithValue("@Timestamp", healthData.Timestamp);
command.Parameters.AddWithValue("@HeartRate", healthData.HeartRate);
command.Parameters.AddWithValue("@BloodPressure", healthData.BloodPressure);
command.Parameters.AddWithValue("@BloodOxygenLevel", healthData.BloodOxygenLevel);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(HealthData healthData)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE HealthData SET UserId = @User Id, Timestamp = @Timestamp, HeartRate = @HeartRate, BloodPressure = @BloodPressure, BloodOxygenLevel = @BloodOxygenLevel, CreatedAt = GETDATE() WHERE HealthDataId = @HealthDataId", connection);
command.Parameters.AddWithValue("@HealthDataId", healthData.HealthDataId);
command.Parameters.AddWithValue("@User Id", healthData.UserId);
command.Parameters.AddWithValue("@Timestamp", healthData.Timestamp);
command.Parameters.AddWithValue("@HeartRate", healthData .HeartRate);
command.Parameters.AddWithValue("@BloodPressure", healthData.BloodPressure);
command.Parameters.AddWithValue("@BloodOxygenLevel", healthData.BloodOxygenLevel);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM HealthData WHERE HealthDataId = @HealthDataId", connection);
command.Parameters.AddWithValue("@HealthDataId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
HeartRate Repository
public class HeartRateRepository : IRepository<HeartRate>
{
private readonly string _connectionString;
public HeartRateRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<HeartRate> GetAll()
{
var heartRates = new List<HeartRate>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM HeartRate", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
heartRates.Add(new HeartRate
{
HeartRateId = (int)reader["HeartRateId"],
UserId = (int)reader["User Id"],
Timestamp = (DateTime)reader["Timestamp"],
HeartRate = (int)reader["HeartRate"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return heartRates;
}
public HeartRate GetById(int id)
{
HeartRate heartRate = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM HeartRate WHERE HeartRateId = @HeartRateId", connection);
command.Parameters.AddWithValue("@HeartRateId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
heartRate = new HeartRate
{
HeartRateId = (int)reader["HeartRateId"],
UserId = (int)reader["User Id"],
Timestamp = (DateTime)reader["Timestamp"],
HeartRate = (int)reader["HeartRate"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return heartRate;
}
public void Add(HeartRate heartRate)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO HeartRate (User Id, Timestamp, HeartRate) VALUES (@User Id, @Timestamp, @HeartRate)", connection);
command.Parameters.AddWithValue("@User Id", heartRate.UserId);
command.Parameters.AddWithValue("@Timestamp", heartRate.Timestamp);
command.Parameters.AddWithValue("@HeartRate", heartRate.HeartRate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(HeartRate heartRate)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE HeartRate SET UserId = @User Id, Timestamp = @Timestamp, HeartRate = @HeartRate, CreatedAt = GETDATE() WHERE HeartRateId = @HeartRateId", connection);
command.Parameters.AddWithValue("@HeartRateId", heartRate.HeartRateId);
command.Parameters.AddWithValue("@User Id", heartRate.UserId);
command.Parameters.AddWithValue("@Timestamp", heartRate.Timestamp);
command.Parameters.AddWithValue("@HeartRate", heartRate.HeartRate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM HeartRate WHERE HeartRateId = @HeartRateId", connection);
command.Parameters.AddWithValue("@HeartRateId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Activity Repository
public class ActivityRepository : IRepository<Activity>
{
private readonly string _connectionString;
public ActivityRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Activity> GetAll()
{
var activities = new List<Activity>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Activities", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
activities.Add(new Activity
{
ActivityId = (int)reader["ActivityId"],
UserId = (int )reader["User Id"],
ActivityType = reader["ActivityType"].ToString(),
Duration = (int)reader["Duration"],
CaloriesBurned = (int)reader["CaloriesBurned"],
Timestamp = (DateTime)reader["Timestamp"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return activities;
}
public Activity GetById(int id)
{
Activity activity = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Activities WHERE ActivityId = @ActivityId", connection);
command.Parameters.AddWithValue("@ActivityId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
activity = new Activity
{
ActivityId = (int)reader["ActivityId"],
UserId = (int)reader["User Id"],
ActivityType = reader["ActivityType"].ToString(),
Duration = (int)reader["Duration"],
CaloriesBurned = (int)reader["CaloriesBurned"],
Timestamp = (DateTime)reader["Timestamp"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return activity;
}
public void Add(Activity activity)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Activities (User Id, ActivityType, Duration, CaloriesBurned) VALUES (@User Id, @ActivityType, @Duration, @CaloriesBurned)", connection);
command.Parameters.AddWithValue("@User Id", activity.UserId);
command.Parameters.AddWithValue("@ActivityType", activity.ActivityType);
command.Parameters.AddWithValue("@Duration", activity.Duration);
command.Parameters.AddWithValue("@CaloriesBurned", activity.CaloriesBurned);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Activity activity)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Activities SET UserId = @User Id, ActivityType = @ActivityType, Duration = @Duration, CaloriesBurned = @CaloriesBurned, CreatedAt = GETDATE() WHERE ActivityId = @ActivityId", connection);
command.Parameters.AddWithValue("@ActivityId", activity.ActivityId);
command.Parameters.AddWithValue("@User Id", activity.UserId);
command.Parameters.AddWithValue("@ActivityType", activity.ActivityType);
command.Parameters.AddWithValue("@Duration", activity.Duration);
command.Parameters.AddWithValue("@CaloriesBurned", activity.CaloriesBurned);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Activities WHERE ActivityId = @ActivityId", connection);
command.Parameters.AddWithValue("@ActivityId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
SleepData Repository
public class SleepDataRepository : IRepository<SleepData>
{
private readonly string _connectionString;
public SleepDataRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<SleepData> GetAll()
{
var sleepDataList = new List<SleepData>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM SleepData", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
sleepDataList.Add(new SleepData
{
SleepDataId = (int)reader["SleepDataId"],
UserId = (int)reader["User Id"],
SleepStart = (DateTime)reader["SleepStart"],
SleepEnd = (DateTime)reader["SleepEnd"],
Duration = (int)reader["Duration"],
Quality = reader["Quality"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return sleepDataList;
}
public SleepData GetById(int id)
{
SleepData sleepData = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM SleepData WHERE SleepDataId = @SleepDataId", connection);
command.Parameters.AddWithValue("@SleepDataId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
sleepData = new SleepData
{
SleepDataId = (int)reader["SleepDataId"],
UserId = (int)reader[" User Id"],
SleepStart = (DateTime)reader["SleepStart"],
SleepEnd = (DateTime)reader["SleepEnd"],
Duration = (int)reader["Duration"],
Quality = reader["Quality"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return sleepData;
}
public void Add(SleepData sleepData)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO SleepData (User Id, SleepStart, SleepEnd, Duration, Quality) VALUES (@User Id, @SleepStart, @SleepEnd, @Duration, @Quality)", connection);
command.Parameters.AddWithValue("@User Id", sleepData.UserId);
command.Parameters.AddWithValue("@SleepStart", sleepData.SleepStart);
command.Parameters.AddWithValue("@SleepEnd", sleepData.SleepEnd);
command.Parameters.AddWithValue("@Duration", sleepData.Duration);
command.Parameters.AddWithValue("@Quality", sleepData.Quality);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(SleepData sleepData)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE SleepData SET UserId = @User Id, SleepStart = @SleepStart, SleepEnd = @SleepEnd, Duration = @Duration, Quality = @Quality, CreatedAt = GETDATE() WHERE SleepDataId = @SleepDataId", connection);
command.Parameters.AddWithValue("@SleepDataId", sleepData.SleepDataId);
command.Parameters.AddWithValue("@User Id", sleepData.UserId);
command.Parameters.AddWithValue("@SleepStart", sleepData.SleepStart);
command.Parameters.AddWithValue("@SleepEnd", sleepData.SleepEnd);
command.Parameters.AddWithValue("@Duration", sleepData.Duration);
command.Parameters.AddWithValue("@Quality", sleepData.Quality);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM SleepData WHERE SleepDataId = @SleepDataId", connection);
command.Parameters.AddWithValue("@SleepDataId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
HealthReport Repository
public class HealthReportRepository : IRepository<HealthReport>
{
private readonly string _connectionString;
public HealthReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<HealthReport> GetAll()
{
var healthReports = new List<HealthReport>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM HealthReports", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
healthReports.Add(new HealthReport
{
HealthReportId = (int)reader["HealthReportId"],
UserId = (int)reader["User Id"],
ReportDate = (DateTime)reader["ReportDate"],
Summary = reader["Summary"].ToString(),
Recommendations = reader["Recommendations"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return healthReports;
}
public HealthReport GetById(int id)
{
HealthReport healthReport = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM HealthReports WHERE HealthReportId = @HealthReportId", connection);
command.Parameters.AddWithValue("@HealthReportId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
healthReport = new HealthReport
{
HealthReportId = (int)reader["HealthReportId"],
UserId = (int)reader["User Id"],
ReportDate = (DateTime)reader["ReportDate"],
Summary = reader["Summary"].ToString(),
Recommendations = reader["Recommendations"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return healthReport;
}
public void Add(HealthReport healthReport)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO HealthReports (User Id, ReportDate, Summary, Recommendations) VALUES (@User Id, @ReportDate, @Summary, @Recommendations)", connection);
command.Parameters.AddWithValue("@User Id", healthReport.UserId);
command.Parameters.AddWithValue("@ ReportDate", healthReport.ReportDate);
command.Parameters.AddWithValue("@Summary", healthReport.Summary);
command.Parameters.AddWithValue("@Recommendations", healthReport.Recommendations);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(HealthReport healthReport)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE HealthReports SET UserId = @User Id, ReportDate = @ReportDate, Summary = @Summary, Recommendations = @Recommendations, CreatedAt = GETDATE() WHERE HealthReportId = @HealthReportId", connection);
command.Parameters.AddWithValue("@HealthReportId", healthReport.HealthReportId);
command.Parameters.AddWithValue("@User Id", healthReport.UserId);
command.Parameters.AddWithValue("@ReportDate", healthReport.ReportDate);
command.Parameters.AddWithValue("@Summary", healthReport.Summary);
command.Parameters.AddWithValue("@Recommendations", healthReport.Recommendations);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM HealthReports WHERE HealthReportId = @HealthReportId", connection);
command.Parameters.AddWithValue("@HealthReportId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Alert Repository
public class AlertRepository : IRepository<Alert>
{
private readonly string _connectionString;
public AlertRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Alert> GetAll()
{
var alerts = new List<Alert>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Alerts", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
alerts.Add(new Alert
{
AlertId = (int)reader["AlertId"],
UserId = (int)reader["User Id"],
AlertType = reader["AlertType"].ToString(),
Message = reader["Message"].ToString(),
IsAcknowledged = (bool)reader["IsAcknowledged"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return alerts;
}
public Alert GetById(int id)
{
Alert alert = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Alerts WHERE AlertId = @AlertId", connection);
command.Parameters.AddWithValue("@AlertId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
alert = new Alert
{
AlertId = (int)reader["AlertId"],
UserId = (int)reader["User Id"],
AlertType = reader["AlertType"].ToString(),
Message = reader["Message"].ToString(),
IsAcknowledged = (bool)reader["IsAcknowledged"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return alert;
}
public void Add(Alert alert)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Alerts (User Id, AlertType, Message, IsAcknowledged) VALUES (@User Id, @AlertType, @Message, @IsAcknowledged)", connection);
command.Parameters.AddWithValue("@User Id", alert.UserId);
command.Parameters.AddWithValue("@AlertType", alert.AlertType);
command.Parameters.AddWithValue("@Message", alert.Message);
command.Parameters.AddWithValue("@IsAcknowledged", alert.IsAcknowledged);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Alert alert)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Alerts SET UserId = @User Id, AlertType = @AlertType, Message = @Message, IsAcknowledged = @IsAcknowledged, CreatedAt = GETDATE() WHERE AlertId = @AlertId", connection);
command.Parameters.AddWithValue("@AlertId", alert.AlertId);
command.Parameters.AddWithValue("@User Id", alert.UserId);
command.Parameters.AddWithValue("@AlertType", alert.AlertType);
command.Parameters.AddWithValue("@Message", alert.Message);
command.Parameters.AddWithValue("@IsAcknowledged", alert.IsAcknowledged);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Alerts WHERE AlertId = @AlertId", connection);
command.Parameters.AddWithValue("@AlertId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Feedback Repository
public class FeedbackRepository : IRepository<Feedback>
{
private readonly string _connectionString;
public FeedbackRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Feedback> GetAll()
{
var feedbacks = new List<Feedback>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
feedbacks.Add(new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return feedbacks;
}
public Feedback GetById(int id)
{
Feedback feedback = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
feedback = new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return feedback;
}
public void Add(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedbacks (User Id, Comments, Rating) VALUES (@User Id, @Comments, @Rating)", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedbacks SET UserId = @User Id, Comments = @Comments, Rating = @Rating, CreatedAt = GETDATE() WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
CommunityPost Repository
public class CommunityPostRepository : IRepository<CommunityPost>
{
private readonly string _connectionString;
public CommunityPostRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<CommunityPost> GetAll()
{
var posts = new List<CommunityPost>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CommunityPosts", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
posts.Add(new CommunityPost
{
PostId = (int)reader["PostId"],
UserId = (int)reader["User Id"],
PostContent = reader["PostContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return posts;
}
public CommunityPost GetById(int id)
{
CommunityPost post = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CommunityPosts WHERE PostId = @PostId", connection command.Parameters.AddWithValue("@PostId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
post = new CommunityPost
{
PostId = (int)reader["PostId"],
UserId = (int)reader["User Id"],
PostContent = reader["PostContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return post;
}
public void Add(CommunityPost post)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO CommunityPosts (User Id, PostContent) VALUES (@User Id, @PostContent)", connection);
command.Parameters.AddWithValue("@User Id", post.UserId);
command.Parameters.AddWithValue("@PostContent", post.PostContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(CommunityPost post)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE CommunityPosts SET UserId = @User Id, PostContent = @PostContent, CreatedAt = GETDATE() WHERE PostId = @PostId", connection);
command.Parameters.AddWithValue("@PostId", post.PostId);
command.Parameters.AddWithValue("@User Id", post.UserId);
command.Parameters.AddWithValue("@PostContent", post.PostContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM CommunityPosts WHERE PostId = @PostId", connection);
command.Parameters.AddWithValue("@PostId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This completes the repository implementations for all the models. Each repository follows the same pattern, providing methods for CRUD operations tailored to the specific model. You can now use these repositories in your ASP.NET application to interact with the database effectively.
Creating Controllers
To create controllers for each repository in an ASP.NET MVC application, we will follow the standard pattern of creating a controller for each model. Each controller will handle HTTP requests, interact with the corresponding repository, and return views or data as needed.
Below are the controller implementations for each model: User, Role, Device, HealthData, HeartRate, Activity, SleepData, HealthReport, Alert, Feedback, and CommunityPost.
Base Controller
First, let's create a base controller that can be inherited by all other controllers. This will help in managing common functionalities like dependency injection for the repositories.
using Microsoft.AspNetCore.Mvc;
public class BaseController : Controller
{
protected readonly string _connectionString;
public BaseController(string connectionString)
{
_connectionString = connectionString;
}
}
User Controller
public class UserController : BaseController
{
private readonly UserRepository _userRepository;
public UserController(string connectionString) : base(connectionString)
{
_userRepository = new UserRepository(connectionString);
}
public IActionResult Index()
{
var users = _userRepository.GetAll();
return View(users);
}
public IActionResult Details(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.Add(user);
return RedirectToAction("Index");
}
return View(user);
}
public IActionResult Edit(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost]
public IActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.Update(user);
return RedirectToAction("Index");
}
return View(user);
}
public IActionResult Delete(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_userRepository.Delete(id);
return RedirectToAction("Index");
}
}
Role Controller
public class RoleController : BaseController
{
private readonly RoleRepository _roleRepository;
public RoleController(string connectionString) : base(connectionString)
{
_roleRepository = new RoleRepository(connectionString);
}
public IActionResult Index()
{
var roles = _roleRepository.GetAll();
return View(roles);
}
public IActionResult Details(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Add(role);
return RedirectToAction("Index");
}
return View(role);
}
public IActionResult Edit(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost]
public IActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Update(role);
return RedirectToAction("Index");
}
return View(role);
}
public IActionResult Delete(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_roleRepository.Delete(id);
return RedirectToAction("Index");
}
}
Device Controller
public class DeviceController : BaseController
{
private readonly DeviceRepository _deviceRepository;
public DeviceController(string connectionString) : base(connectionString)
{
_deviceRepository = new DeviceRepository(connectionString);
}
public IActionResult Index()
{
var devices = _deviceRepository.GetAll();
return View(devices);
}
public IActionResult Details(int id)
{
var device = _deviceRepository.GetById(id);
return View(device);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Device device)
{
if (ModelState.IsValid)
{
_deviceRepository.Add(device);
return RedirectToAction("Index");
}
return View(device);
}
public IActionResult Edit(int id)
{
var device = _deviceRepository.GetById(id);
return View(device);
}
[HttpPost]
public IActionResult Edit(Device device)
{
if (ModelState.IsValid)
{
_deviceRepository.Update(device);
return RedirectToAction("Index");
}
return View(device);
}
public IActionResult Delete(int id)
{
var device = _deviceRepository.GetById(id);
return View(device);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_deviceRepository.Delete(id);
return RedirectToAction("Index");
}
}
HealthData Controller
public class HealthDataController : BaseController
{
private readonly HealthDataRepository _healthDataRepository;
public HealthDataController(string connectionString) : base(connectionString)
{
_healthDataRepository = new HealthDataRepository(connectionString);
}
public IActionResult Index()
{
var healthDataList = _healthDataRepository.GetAll();
return View(healthDataList);
}
public IActionResult Details(int id)
{
var healthData = _healthDataRepository.GetById(id);
return View(healthData);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(HealthData healthData)
{
if (ModelState.IsValid)
{
_healthDataRepository.Add(healthData);
return RedirectToAction("Index");
}
return View(healthData);
}
public IActionResult Edit(int id)
{
var healthData = _healthDataRepository.GetById(id);
return View(healthData);
}
[HttpPost]
public IActionResult Edit(HealthData healthData)
{
if (ModelState.IsValid)
{
_healthDataRepository.Update(healthData);
return RedirectToAction("Index");
}
return View(healthData);
}
public IActionResult Delete(int id)
{
var healthData = _healthDataRepository.GetById(id);
return View(healthData);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_healthDataRepository.Delete(id);
return RedirectToAction("Index");
}
}
HeartRate Controller
public class HeartRateController : BaseController
{
private readonly HeartRateRepository _heartRateRepository;
public HeartRateController(string connectionString) : base(connectionString)
{
_heartRateRepository = new HeartRateRepository(connectionString);
}
public IActionResult Index()
{
var heartRates = _heartRateRepository.GetAll();
return View(heartRates);
}
public IActionResult Details(int id)
{
var heartRate = _heartRateRepository.GetById(id);
return View(heartRate);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(HeartRate heartRate)
{
if (ModelState.IsValid)
{
_heartRateRepository.Add(heartRate);
return RedirectToAction("Index");
}
return View(heartRate);
}
public IActionResult Edit(int id)
{
var heartRate = _heartRateRepository.GetById(id);
return View(heartRate);
}
[HttpPost]
public IActionResult Edit(HeartRate heartRate)
{
if (ModelState.IsValid)
{
_heartRateRepository.Update(heartRate);
return RedirectToAction("Index");
}
return View(heartRate);
}
public IActionResult Delete(int id)
{
var heartRate = _heartRateRepository.GetById(id);
return View(heartRate);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_heartRateRepository.Delete(id);
return RedirectToAction("Index");
}
}
Activity Controller
public class ActivityController : BaseController
{
private readonly ActivityRepository _activityRepository;
public ActivityController(string connectionString) : base(connectionString)
{
_activityRepository = new ActivityRepository(connectionString);
}
public IActionResult Index()
{
var activities = _activityRepository.GetAll();
return View(activities);
}
public IActionResult Details(int id)
{
var activity = _activityRepository.GetById(id);
return View(activity);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Activity activity)
{
if (ModelState.IsValid)
{
_activityRepository.Add(activity);
return RedirectToAction("Index");
}
return View(activity);
}
public IActionResult Edit(int id)
{
var activity = _activityRepository.GetById(id);
return View(activity);
}
[HttpPost]
public IActionResult Edit(Activity activity)
{
if (ModelState.IsValid)
{
_activityRepository.Update(activity);
return RedirectToAction("Index");
}
return View(activity);
}
public IActionResult Delete(int id)
{
var activity = _activityRepository.GetById(id);
return View(activity);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_activityRepository.Delete(id);
return RedirectToAction("Index");
}
}
SleepData Controller
csharp public class SleepDataController : BaseController { private readonly SleepDataRepository _sleepDataRepository;
public SleepDataController(string connectionString) : base(connectionString)
{
_sleepDataRepository = new SleepDataRepository(connectionString);
}
public IActionResult Index()
{
var sleepDataList = _sleepDataRepository.GetAll();
return View(sleepDataList);
}
public IActionResult Details(int id)
{
var sleepData = _sleepDataRepository.GetById(id);
return View(sleepData);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(SleepData sleepData)
{
if (ModelState.IsValid)
{
_sleepDataRepository.Add(sleepData);
return RedirectToAction("Index");
}
return View(sleepData);
}
public IActionResult Edit(int id)
{
var sleepData = _sleepDataRepository.GetById(id);
return View(sleepData);
}
[HttpPost]
public IActionResult Edit(SleepData sleepData)
{
if (ModelState.IsValid)
{
_sleepDataRepository.Update(sleepData);
return RedirectToAction("Index");
}
return View(sleepData);
}
public IActionResult Delete(int id)
{
var sleepData = _sleepDataRepository.GetById(id);
return View(sleepData);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_sleepDataRepository.Delete(id);
return RedirectToAction("Index");
}
}
HealthReport Controller
public class HealthReportController : BaseController
{
private readonly HealthReportRepository _healthReportRepository;
public HealthReportController(string connectionString) : base(connectionString)
{
_healthReportRepository = new HealthReportRepository(connectionString);
}
public IActionResult Index()
{
var healthReports = _healthReportRepository.GetAll();
return View(healthReports);
}
public IActionResult Details(int id)
{
var healthReport = _healthReportRepository.GetById(id);
return View(healthReport);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(HealthReport healthReport)
{
if (ModelState.IsValid)
{
_healthReportRepository.Add(healthReport);
return RedirectToAction("Index");
}
return View(healthReport);
}
public IActionResult Edit(int id)
{
var healthReport = _healthReportRepository.GetById(id);
return View(healthReport);
}
[HttpPost]
public IActionResult Edit(HealthReport healthReport)
{
if (ModelState.IsValid)
{
_healthReportRepository.Update(healthReport);
return RedirectToAction("Index");
}
return View(healthReport);
}
public IActionResult Delete(int id)
{
var healthReport = _healthReportRepository.GetById(id);
return View(healthReport);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_healthReportRepository.Delete(id);
return RedirectToAction("Index");
}
}
Alert Controller
public class AlertController : BaseController
{
private readonly AlertRepository _alertRepository;
public AlertController(string connectionString) : base(connectionString)
{
_alertRepository = new AlertRepository(connectionString);
}
public IActionResult Index()
{
var alerts = _alertRepository.GetAll();
return View(alerts);
}
public IActionResult Details(int id)
{
var alert = _alertRepository.GetById(id);
return View(alert);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Alert alert)
{
if (ModelState.IsValid)
{
_alertRepository.Add(alert);
return RedirectToAction("Index");
}
return View(alert);
}
public IActionResult Edit(int id)
{
var alert = _alertRepository.GetById(id);
return View(alert);
}
[HttpPost]
public IActionResult Edit(Alert alert)
{
if (ModelState.IsValid)
{
_alertRepository.Update(alert);
return RedirectToAction("Index");
}
return View(alert);
}
public IActionResult Delete(int id)
{
var alert = _alertRepository.GetById(id);
return View(alert);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_alertRepository.Delete(id);
return RedirectToAction("Index");
}
}
Feedback Controller
public class FeedbackController : BaseController
{
private readonly FeedbackRepository _feedbackRepository;
public FeedbackController(string connectionString) : base(connectionString)
{
_feedbackRepository = new FeedbackRepository(connectionString);
}
public IActionResult Index()
{
var feedbacks = _feedbackRepository.GetAll();
return View(feedbacks);
}
public IActionResult Details(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Add(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public IActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost]
public IActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Update(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public IActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_feedbackRepository.Delete(id);
return RedirectToAction("Index");
}
}
CommunityPost Controller
public class CommunityPostController : BaseController
{
private readonly CommunityPostRepository _communityPostRepository;
public CommunityPostController(string connectionString) : base(connectionString)
{
_communityPostRepository = new CommunityPostRepository(connectionString);
}
public IActionResult Index()
{
var posts = _communityPostRepository.GetAll();
return View(posts);
}
public IActionResult Details(int id)
{
var post = _communityPostRepository.GetById(id);
return View(post);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(CommunityPost post)
{
if (ModelState.IsValid)
{
_communityPostRepository.Add(post);
return RedirectToAction("Index");
}
return View(post);
}
public IActionResult Edit(int id)
{
var post = _communityPostRepository.GetById(id);
return View(post);
}
[HttpPost]
public IActionResult Edit(CommunityPost post)
{
if (ModelState.IsValid)
{
_communityPostRepository.Update(post);
return RedirectToAction("Index");
}
return View(post);
}
public IActionResult Delete(int id)
{
var post = _communityPostRepository.GetById(id);
return View(post);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_communityPostRepository.Delete(id);
return RedirectToAction("Index");
}
}
This completes the controller implementations for all the models. Each controller provides methods for handling CRUD operations and interacts with the corresponding repository to manage data effectively. You can now use these controllers in your ASP.NET MVC application to create views for each model and manage them through the user interface.
Creating Views
Creating views for each controller in an ASP.NET MVC application involves creating Razor view files that correspond to the actions in the controllers. Below, I will provide the basic structure for the views for each controller: User, Role, Device, HealthData, HeartRate, Activity, SleepData, HealthReport, Alert, Feedback, and CommunityPost.
Folder Structure
Assuming you have a standard ASP.NET MVC project structure, the views for each controller will be placed in their respective folders under the Views directory. For example, the views for the User Controller will be in Views/User.
User Views
Views/User/Index.cshtml
@model IEnumerable<YourNamespace.Models.User>
<h2>Users</h2>
<a href='@Url.Action("Create")'>Create New User</a>
<table>
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>Phone</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.Username</td>
<td>@user.Email</td>
<td>@user.Phone</td>
<td>
<a href='@Url.Action("Details", new { id = user.UserId })">Details</a> |
<a href='@Url.Action("Edit", new { id = user.UserId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = user.UserId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/User/Details.cshtml
@model YourNamespace.Models.User
<h2>User Details</h2>
<div>
<h4>@Model.Username</h4>
<p>Email: @Model.Email</p>
<p>Phone: @Model.Phone</p>
<p>Created At: @Model.CreatedAt</p>
<p>Updated At: @Model.UpdatedAt</p>
</div>
<a href='@Url.Action("Edit", new { id = Model.UserId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/User/Create.cshtml
@model YourNamespace.Models.User
<h2>Create User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.Username)
@Html.TextBoxFor(m => m.Username)
</div>
<div>
@Html.LabelFor(m => m.PasswordHash)
@Html.TextBoxFor(m => m.PasswordHash)
</div>
<div>
@Html.LabelFor(m => m.Email)
@Html.TextBoxFor(m => m.Email)
</div>
<div>
@Html.LabelFor(m => m.Phone)
@Html.TextBoxFor(m => m.Phone)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/User/Edit.cshtml
@model YourNamespace.Models.User
<h2>Edit User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.UserId)
<div>
@Html.LabelFor(m => m.Username)
@Html.TextBoxFor(m => m.Username)
</div>
<div>
@Html.LabelFor(m => m.Email)
@Html.TextBoxFor(m => m.Email)
</div>
<div>
@Html.LabelFor(m => m.Phone)
@Html.TextBoxFor(m => m.Phone)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/User/Delete.cshtml
@model YourNamespace.Models.User
<h2>Delete User</h2>
<div>
<h4>Are you sure you want to delete this user?</h4>
<h4>@Model.Username</h4>
<p>Email: @Model.Email</p>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.UserId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
Role Views
Views/Role/Index.cshtml
@model IEnumerable<YourNamespace.Models.Role>
<h2>Roles</h2>
<a href='@Url.Action("Create")'>Create New Role</a>
<table>
<thead>
<tr>
<th>Role Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@role.RoleName</td>
<td>
<a href='@Url.Action("Details", new { id = role.RoleId })">Details</a> |
<a href='@Url.Action("Edit", new { id = role.RoleId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = role .RoleId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Role/Details.cshtml
@model YourNamespace.Models.Role
<h2>Role Details</h2>
<div>
<h4>@Model.RoleName</h4>
</div>
<a href='@Url.Action("Edit", new { id = Model.RoleId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/Role/Create.cshtml
@model YourNamespace.Models.Role
<h2>Create Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.RoleName)
@Html.TextBoxFor(m => m.RoleName)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Role/Edit.cshtml
@model YourNamespace.Models.Role
<h2>Edit Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.RoleId)
<div>
@Html.LabelFor(m => m.RoleName)
@Html.TextBoxFor(m => m.RoleName)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Role/Delete.cshtml
@model YourNamespace.Models.Role
<h2>Delete Role</h2>
<div>
<h4>Are you sure you want to delete this role?</h4>
<h4>@Model.RoleName</h4>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.RoleId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
Device Views
Views/Device/Index.cshtml
@model IEnumerable<YourNamespace.Models.Device>
<h2>Devices</h2>
<a href='@Url.Action("Create")'>Create New Device</a>
<table>
<thead>
<tr>
<th>Device Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var device in Model)
{
<tr>
<td>@device.DeviceName</td>
<td>
<a href='@Url.Action("Details", new { id = device.DeviceId })">Details</a> |
<a href='@Url.Action("Edit", new { id = device.DeviceId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = device.DeviceId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Device/Details.cshtml
@model YourNamespace.Models.Device
<h2>Device Details</h2>
<div>
<h4>@Model.DeviceName</h4>
</div>
<a href='@Url.Action("Edit", new { id = Model.DeviceId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/Device/Create.cshtml
@model YourNamespace.Models.Device
<h2>Create Device</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.DeviceName)
@Html.TextBoxFor(m => m.DeviceName)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Device/Edit.cshtml
@model YourNamespace.Models.Device
<h2>Edit Device</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.DeviceId)
<div>
@Html.LabelFor(m => m.DeviceName)
@Html.TextBoxFor(m => m.DeviceName)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Device/Delete.cshtml
@model YourNamespace.Models.Device
<h2>Delete Device</h2>
<div>
<h4>Are you sure you want to delete this device?</h4>
<h4>@Model.DeviceName</h4>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken
@Html.HiddenFor(m => m.DeviceId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
HealthData Views
Views/HealthData/Index.cshtml
@model IEnumerable<YourNamespace.Models.HealthData>
<h2>Health Data</h2>
<a href='@Url.Action("Create")'>Create New Health Data</a>
<table>
<thead>
<tr>
<th>Data Type</th>
<th>Value</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var data in Model)
{
<tr>
<td>@data.DataType</td>
<td>@data.Value</td>
<td>
<a href='@Url.Action("Details", new { id = data.HealthDataId })">Details</a> |
<a href='@Url.Action("Edit", new { id = data.HealthDataId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = data.HealthDataId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/HealthData/Details.cshtml
@model YourNamespace.Models.HealthData
<h2>Health Data Details</h2>
<div>
<h4>Data Type: @Model.DataType</h4>
<p>Value: @Model.Value</p>
</div>
<a href='@Url.Action("Edit", new { id = Model.HealthDataId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/HealthData/Create.cshtml
@model YourNamespace.Models.HealthData
<h2>Create Health Data</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.DataType)
@Html.TextBoxFor(m => m.DataType)
</div>
<div>
@Html.LabelFor(m => m.Value)
@Html.TextBoxFor(m => m.Value)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/HealthData/Edit.cshtml
@model YourNamespace.Models.HealthData
<h2>Edit Health Data</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.HealthDataId)
<div>
@Html.LabelFor(m => m.DataType)
@Html.TextBoxFor(m => m.DataType)
</div>
<div>
@Html.LabelFor(m => m.Value)
@Html.TextBoxFor(m => m.Value)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/HealthData/Delete.cshtml
@model YourNamespace.Models.HealthData
<h2>Delete Health Data</h2>
<div>
<h4>Are you sure you want to delete this health data?</h4>
<h4>Data Type: @Model.DataType</h4>
<p>Value: @Model.Value</p>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.HealthDataId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
HeartRate Views
Views/HeartRate/Index.cshtml
@model IEnumerable<YourNamespace.Models.HeartRate>
<h2>Heart Rates</h2>
<a href='@Url.Action("Create")'>Create New Heart Rate</a>
<table>
<thead>
<tr>
<th>Rate</th>
<th>Timestamp</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var heartRate in Model)
{
<tr>
<td>@heartRate.Rate</td>
<td>@heartRate.Timestamp</td>
<td>
<a href='@Url.Action("Details", new { id = heartRate.HeartRateId })">Details</a> |
<a href='@Url.Action("Edit", new { id = heartRate.HeartRateId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = heartRate.HeartRateId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/HeartRate/Details.cshtml
@model YourNamespace.Models.HeartRate
<h2>Heart Rate Details</h2>
<div>
<h4>Rate: @Model.Rate</h4>
<p>Timestamp: @Model.Timestamp</p>
</div>
<a href='@Url.Action("Edit", new { id = Model.HeartRateId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/HeartRate/Create.cshtml
@model YourNamespace.Models.HeartRate
<h2>Create Heart Rate</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.Rate)
@Html.TextBoxFor(m => m.Rate)
</div>
<div>
@Html.LabelFor(m => m.Timestamp)
@Html.TextBoxFor(m => m.Timestamp)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/HeartRate/Edit.cshtml
@model YourNamespace.Models.HeartRate
<h2>Edit Heart Rate</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.HeartRateId)
<div>
@Html.LabelFor(m => m.Rate)
@Html.TextBoxFor(m => m.Rate)
</div>
<div>
@Html.LabelFor(m => m.Timestamp)
@Html.TextBoxFor(m => m.Timestamp)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/HeartRate/Delete.cshtml
@model YourNamespace.Models.HeartRate
<h2>Delete Heart Rate</h2>
<div>
<h4>Are you sure you want to delete this heart rate?</h4>
<h4>Rate: @Model.Rate</h4>
<p>Timestamp: @Model.Timestamp</p>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.HeartRateId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
Activity Views
Views/Activity/Index.cshtml
@model IEnumerable<YourNamespace.Models.Activity>
<h2>Activities</h2>
<a href='@Url.Action("Create")'>Create New Activity</a>
<table>
<thead>
<tr>
<th>Activity Name</th>
<th>Duration</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var activity in Model)
{
<tr>
<td>@activity.ActivityName</td>
<td>@activity.Duration</td>
<td>
<a href='@Url.Action("Details", new { id = activity.ActivityId })">Details</a> |
<a href='@Url.Action("Edit", new { id = activity.ActivityId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = activity.ActivityId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Activity/Details.cshtml
@model YourNamespace.Models.Activity
<h2>Activity Details</h2>
<div>
<h4>Activity Name: @Model.ActivityName</h4>
<p>Duration: @Model.Duration</p>
</div>
<a href='@Url.Action("Edit", new { id = Model.ActivityId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/Activity/Create.cshtml
@model YourNamespace.Models.Activity
<h2>Create Activity</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.ActivityName)
@Html.TextBoxFor(m => m.ActivityName)
</div>
<div>
@Html.LabelFor(m => m.Duration)
@Html.TextBoxFor(m => m.Duration)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Activity/Edit.cshtml
@model YourNamespace.Models.Activity
<h2>Edit Activity</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.ActivityId)
<div>
@Html.LabelFor(m => m.ActivityName)
@Html.TextBoxFor(m => m.ActivityName)
</div>
<div>
@Html.LabelFor(m => m.Duration)
@Html.TextBoxFor(m => m.Duration)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Activity/Delete.cshtml
@model YourNamespace.Models.Activity
<h2>Delete Activity</h2>
<div>
<h4>Are you sure you want to delete this activity?</h4>
<h4>Activity Name: @Model.ActivityName</h4>
<p>Duration: @Model.Duration</p>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.ActivityId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
SleepData Views
Views/SleepData/Index.cshtml
@model IEnumerable<YourNamespace.Models.SleepData>
<h2>Sleep Data</h2>
<a href='@Url.Action("Create")'>Create New Sleep Data</a>
<table>
<thead>
<tr>
<th>Sleep Duration</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var sleepData in Model)
{
<tr>
<td>@sleepData.Duration</td>
<td>@sleepData.Date</td>
<td>
<a href='@Url.Action("Details", new { id = sleepData.SleepDataId })">Details</a> |
<a href='@Url.Action("Edit", new { id = sleepData.SleepDataId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = sleepData.SleepDataId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/SleepData/Details.cshtml
@model YourNamespace.Models.SleepData
<h2>Sleep Data Details</h2>
<div>
<h4>Duration: @Model.Duration</h4>
<p>Date: @Model.Date</p>
</div>
<a href='@Url.Action("Edit", new { id = Model.SleepDataId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/SleepData/Create.cshtml
@model YourNamespace.Models.SleepData
<h2>Create Sleep Data</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.Duration)
@Html.TextBoxFor(m => m.Duration)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/SleepData/Edit.cshtml
@model YourNamespace.Models.SleepData
<h2>Edit Sleep Data</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.SleepDataId)
<div>
@Html.LabelFor(m => m.Duration)
@Html.TextBoxFor(m => m.Duration)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/SleepData/Delete.cshtml
@model YourNamespace.Models.SleepData
<h2>Delete Sleep Data</h2>
<div>
<h4>Are you sure you want to delete this sleep data?</h4>
<h4>Duration: @Model.Duration</h4>
<p>Date: @Model.Date</p>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.SleepDataId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
HealthReport Views
Views/HealthReport/Index.cshtml
@model IEnumerable<YourNamespace.Models.HealthReport>
<h2>Health Reports</h2>
<a href='@Url.Action("Create")'>Create New Health Report</a>
<table>
<thead>
<tr>
<th>Report Title</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var report in Model)
{
<tr>
<td>@report.Title</td>
<td>@report.Date</td>
<td>
<a href='@Url.Action("Details", new { id = report.HealthReportId })">Details</a> |
<a href='@Url.Action("Edit", new { id = report.HealthReportId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = report.HealthReportId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/HealthReport/Details.cshtml
@model YourNamespace.Models.HealthReport
<h2>Health Report Details</h2>
<div>
<h4>Title: @Model.Title</h4>
<p>Date: @Model.Date</p>
<p>Content: @Model.Content</p>
</div>
<a href='@Url.Action("Edit", new { id = Model.HealthReportId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/HealthReport/Create.cshtml
@model YourNamespace.Models.HealthReport
<h2>Create Health Report</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.Title)
@Html.TextBoxFor(m => m.Title)
</div>
<div>
@Html.LabelFor(m => m.Content)
@Html.TextAreaFor(m => m.Content)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/HealthReport/Edit.cshtml
@model YourNamespace.Models.HealthReport
<h2>Edit Health Report</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.HealthReportId)
<div>
@Html.LabelFor(m => m.Title)
@Html.TextBoxFor(m => m.Title)
</div>
<div>
@Html.LabelFor(m => m.Content)
@Html.TextAreaFor(m => m.Content)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/HealthReport/Delete.cshtml
@model YourNamespace.Models.HealthReport
<h2>Delete Health Report</h2>
<div>
<h4>Are you sure you want to delete this health report?</h4>
<h4>Title: @Model.Title</h4>
<p>Date: @Model.Date</p>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.HealthReportId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
Alert Views
Views/Alert/Index.cshtml
@model IEnumerable<YourNamespace.Models.Alert>
<h2>Alerts</h2>
<a href='@Url.Action("Create")'>Create New Alert</a>
<table>
<thead>
<tr>
<th>Alert Message</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var alert in Model)
{
<tr>
<td>@alert.Message</td>
<td>@alert.Date</td>
<td>
<a href='@Url.Action("Details", new { id = alert.AlertId })">Details</a> |
<a href='@Url.Action("Edit", new { id = alert.AlertId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = alert.AlertId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Alert/Details.cshtml
@model YourNamespace.Models.Alert
<h2>Alert Details</h2>
<div>
<h4>Message: @Model.Message</h4>
<p>Date: @Model.Date</p>
</div>
<a href='@Url.Action("Edit", new { id = Model.AlertId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/Alert/Create.cshtml
@model YourNamespace.Models.Alert
<h2>Create Alert</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.Message)
@Html.TextBoxFor(m => m.Message)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Alert/Edit.cshtml
@model YourNamespace.Models.Alert
<h2>Edit Alert</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.AlertId)
<div>
@Html.LabelFor(m => m.Message)
@Html.TextBoxFor(m => m.Message)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Alert/Delete.cshtml
@model YourNamespace.Models.Alert
<h2>Delete Alert</h2>
<div>
<h4>Are you sure you want to delete this alert?</h4>
<h4>Message: @Model.Message</h4>
<p>Date: @Model.Date</p>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.AlertId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
Feedback Views
Views/Feedback/Index.cshtml
@model IEnumerable<YourNamespace.Models.Feedback>
<h2>Feedbacks</h2>
<a href='@Url.Action("Create")'>Create New Feedback</a>
<table>
<thead>
<tr>
<th>Feedback Message</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@feedback.Message</td>
<td>@feedback.Date</td>
<td>
<a href='@Url.Action("Details", new { id = feedback.FeedbackId })">Details</a> |
<a href='@Url.Action("Edit", new { id = feedback.FeedbackId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = feedback.FeedbackId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Feedback/Details.cshtml
@model YourNamespace.Models.Feedback
<h2>Feedback Details</h2>
<div>
<h4>Message: @Model.Message</h4>
<p>Date: @Model.Date</p>
</div>
<a href='@Url.Action("Edit", new { id = Model.FeedbackId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/Feedback/Create.cshtml
@model YourNamespace.Models.Feedback
<h2>Create Feedback</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.Message)
@Html.TextAreaFor(m => m.Message)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Feedback/Edit.cshtml
@model YourNamespace.Models.Feedback
<h2>Edit Feedback</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.FeedbackId)
<div>
@Html.LabelFor(m => m.Message)
@Html.TextAreaFor(m => m.Message)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/Feedback/Delete.cshtml
@model YourNamespace.Models.Feedback
<h2>Delete Feedback</h2>
<div>
<h4>Are you sure you want to delete this feedback?</h4>
<h4>Message: @Model.Message</h4>
<p>Date: @Model.Date</p>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.FeedbackId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
CommunityPost Views
Views/CommunityPost/Index.cshtml
@model IEnumerable<YourNamespace.Models.CommunityPost>
<h2>Community Posts</h2>
<a href='@Url.Action("Create")'>Create New Post</a>
<table>
<thead>
<tr>
<th>Title</th>
<th>Content</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var post in Model)
{
<tr>
<td>@post.Title</td>
<td>@post.Content</td>
<td>@post.Date</td>
<td>
<a href='@Url.Action("Details", new { id = post.CommunityPostId })">Details</a> |
<a href='@Url.Action("Edit", new { id = post.CommunityPostId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = post.CommunityPostId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/CommunityPost/Details.cshtml
@model YourNamespace.Models.CommunityPost
<h2>Post Details</h2>
<div>
<h4>Title: @Model.Title</h4>
<p>Content: @Model.Content</p>
<p>Date: @Model.Date</p>
</div>
<a href='@Url.Action("Edit", new { id = Model.CommunityPostId })'>Edit</a> |
<a href='@Url.Action("Index")">Back to List</a>
Views/CommunityPost/Create.cshtml
@model YourNamespace.Models.CommunityPost
<h2>Create Post</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
@Html.LabelFor(m => m.Title)
@Html.TextBoxFor(m => m.Title)
</div>
<div>
@Html.LabelFor(m => m.Content)
@Html.TextAreaFor(m => m.Content)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Create</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/CommunityPost/Edit.cshtml
@model YourNamespace.Models.CommunityPost
<h2>Edit Post</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.CommunityPostId)
<div>
@Html.LabelFor(m => m.Title)
@Html.TextBoxFor(m => m.Title)
</div>
<div>
@Html.LabelFor(m => m.Content)
@Html.TextAreaFor(m => m.Content)
</div>
<div>
@Html.LabelFor(m => m.Date)
@Html.TextBoxFor(m => m.Date)
</div>
<button type="submit">Save</button>
}
<a href='@Url.Action("Index")">Back to List</a>
Views/CommunityPost/Delete.cshtml
@model YourNamespace.Models.CommunityPost
<h2>Delete Post</h2>
<div>
<h4>Are you sure you want to delete this post?</h4>
<h4>Title: @Model.Title</h4>
<p>Content: @Model.Content</p>
<p>Date: @Model.Date</p>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(m => m.CommunityPostId)
<button type="submit">Delete</button>
}
<a href='@Url.Action("Index")'>Cancel</a>
This completes the view implementations for all the controllers. Each view provides a user interface for performing CRUD operations on the respective models, allowing users to create, read, update, and delete records effectively. You can now integrate these views into your ASP.NET MVC application to enhance user interaction with the data.
Creating a Dashboard Page
Creating a dashboard page in an ASP.NET MVC application involves aggregating data from various models and presenting it in a user-friendly format. Below, I will outline how to create a dashboard view that consolidates data from the different repositories (e.g., Users, Devices, Health Data, etc.) and displays it on a single page.
Step 1: Create a Dashboard ViewModel
First, we need to create a ViewModel that will hold the consolidated data for the dashboard.
public class DashboardViewModel
{
public int TotalUsers { get; set; }
public int TotalDevices { get; set; }
public int TotalHealthDataEntries { get; set; }
public int TotalHeartRates { get; set; }
public int TotalActivities { get; set; }
public int TotalSleepDataEntries { get; set; }
public int TotalHealthReports { get; set; }
public int TotalAlerts { get; set; }
public int TotalFeedbacks { get; set; }
public int TotalCommunityPosts { get; set; }
}
Step 2: Create a Dashboard Controller
Next, we will create a controller that will handle requests to the dashboard page and populate the ViewModel with data from the repositories.
public class DashboardController : BaseController
{
private readonly UserRepository _userRepository;
private readonly DeviceRepository _deviceRepository;
private readonly HealthDataRepository _healthDataRepository;
private readonly HeartRateRepository _heartRateRepository;
private readonly ActivityRepository _activityRepository;
private readonly SleepDataRepository _sleepDataRepository;
private readonly HealthReportRepository _healthReportRepository;
private readonly AlertRepository _alertRepository;
private readonly FeedbackRepository _feedbackRepository;
private readonly CommunityPostRepository _communityPostRepository;
public DashboardController(string connectionString) : base(connectionString)
{
_userRepository = new UserRepository(connectionString);
_deviceRepository = new DeviceRepository(connectionString);
_healthDataRepository = new HealthDataRepository(connectionString);
_heartRateRepository = new HeartRateRepository(connectionString);
_activityRepository = new ActivityRepository(connectionString);
_sleepDataRepository = new SleepDataRepository(connectionString);
_healthReportRepository = new HealthReportRepository(connectionString);
_alertRepository = new AlertRepository(connectionString);
_feedbackRepository = new FeedbackRepository(connectionString);
_communityPostRepository = new CommunityPostRepository(connectionString);
}
public IActionResult Index()
{
var model = new DashboardViewModel
{
TotalUsers = _userRepository.GetAll().Count(),
TotalDevices = _deviceRepository.GetAll().Count(),
TotalHealthDataEntries = _healthDataRepository.GetAll().Count(),
TotalHeartRates = _heartRateRepository.GetAll().Count(),
TotalActivities = _activityRepository.GetAll().Count(),
TotalSleepDataEntries = _sleepDataRepository.GetAll().Count(),
TotalHealthReports = _healthReportRepository.GetAll().Count(),
TotalAlerts = _alertRepository.GetAll().Count(),
TotalFeedbacks = _feedbackRepository.GetAll().Count(),
TotalCommunityPosts = _communityPostRepository.GetAll().Count()
};
return View(model);
}
}
Step 3: Create the Dashboard View
Now, we will create the view for the dashboard. This view will display the consolidated data in a user-friendly format.
Views/Dashboard/Index.cshtml
@model YourNamespace.ViewModels.DashboardViewModel
<h2>Dashboard</h2>
<div class="dashboard">
<div class="card">
<h3>Total Users</h3>
<p>@Model.TotalUsers</p>
</div>
<div class="card">
<h3>Total Devices</h3>
<p>@Model.TotalDevices</p>
</div>
<div class="card">
<h3>Total Health Data Entries</h3>
<p>@Model.TotalHealthDataEntries</p>
</div>
<div class="card">
<h3>Total Heart Rates</h3>
<p>@Model.TotalHeartRates</p>
</div>
<div class="card">
<h3>Total Activities</h3>
<p>@Model.TotalActivities</p>
</div>
<div class="card">
<h3>Total Sleep Data Entries</h3>
<p>@Model.TotalSleepDataEntries</p>
</div>
<div class="card">
<h3>Total Health Reports</h3>
<p>@Model.TotalHealthReports</p>
</div>
<div class="card">
<h3>Total Alerts</h3>
<p>@Model.TotalAlerts</p>
</div>
<div class="card">
<h3>Total Feedbacks</h3>
<p>@Model.TotalFeedbacks</p>
</div>
<div class="card">
<h3>Total Community Posts</h3>
<p>@Model.TotalCommunityPosts</p>
</div>
</div>
<style>
.dashboard {
display: grid;
grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));
gap: 20px;
}
.card {
border: 1px solid #ccc;
padding: 20px;
border-radius: 5px;
text-align: center;
}
</style>
Step 4: Add a Route for the Dashboard
To access the dashboard, you need to add a route in your Startup.cs or RouteConfig.cs file, depending on your project setup.
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "dashboard",
pattern: "Dashboard",
defaults: new { controller = "Dashboard", action = "Index" });
});
Step 5: Accessing the Dashboard
You can now access the dashboard by navigating to /Dashboard in your web application. This will display the consolidated data related to the project, providing a quick overview of the key metrics.
AI 
ASP.NET API 
ASP.NET CLI 
ASP.NET Core 
ASP.NET MVC 
ASP.NET Projects With Source Code 
ASP.NET Web Forms 
ASP.NET Web Pages 
AWS 
Angular 10 
Bash 
Bitcoin 
Blockchain 
C Tutorial 
C# 
CPP 
Chat GPT 
Cheat Sheet 
Cyber Security 
Dart 
Django 
Docker 
Ether.js 
Ethereum 
Flask 
Flask Projects With Source Code 
GEN AI 
Git 
Go Language 
Google Cloud Platform 
GraphQL 
Hardhat 
INI 
JSON 
Java 
JavaScript 
Kotlin 
Kubernetes 
LaTeX 
Laravel 
Laravel 10 E-Commerce Project 
Laravel 11 E-Commerce Project 
Laravel 9 E-Commerce Project 
Laravel 9 React Tutorial 
Laravel E-Commerce Project 
Laravel Home Services Project 
Laravel Projects With Source Code 
Laravel Tutorial Advanced 
Laravel Tutorial Beginners 
Livewire 
Markdown 
Matlab 
Metamask 
Microsoft Azure 
MongoDB Tutorial Advanced 
MongoDB Tutorial Beginners 
MySql Tutorial Advanced 
MySql Tutorial Beginners 
NextJS 
Node JS 
Node JS Projects With Source Code 
PHP Projects With Source Code 
PHP Tutorial Advanced 
PHP Tutorial Beginners 
Project Database Schema 
Python 
React JS 
Ruby 
Rust 
SQL Server Queries 
SQL Server Tutorial Advanced 
SQL Server Tutorial Beginners 
Sass 
Solidity 
Spring Boot 
Truffle 
TypeScript 
VueJS 
Web3.js 
WordPress Tutorial Advanced 
WordPress Tutorial Beginners 
YAML