Internship-7-EF-Dmail

Simulation of an email client.
Main focus on Entity Framework, Postgres, LINQ and design patterns.

Project setup

1. Edit App.example.config.
   • Edit the connection string within the file.
   • Rename App.example.config to App.config.
2. Apply migrations.
   • Open the Package Manager Console (Visual Studio) : View > Other Windows > Package Manager Console.
   • Make sure that the selected project is Internship-7-EF-Dmail.Data.
   • Run Update-Database in the Package Manager Console.

Database

Database diagram

erDiagram


User
Mail
Recipient
SpamFlag


User ||--|{ Mail : sends
User }|--|{ SpamFlag : has
Mail ||--|{ Recipient : has
Recipient ||--|{ User : is

Loading

Entities

classDiagram


class User {
  Id int
  Email string
  Password string
  CreatedAt DateTime
  Status UserStatus
  Rights UserRights
  LastFailedLoginAttempt DateTime
}

class Mail {
  Id int
  SenderId int
  Title string
  CreatedAt DateTime
  HiddenFromSender bool
  Format MailFormat
  Content string?
  EventStartAt DateTime?
  EventDuration TimeSpan?
}

class Recipient {
  MailId int
  UserId int
  MailStatus MailStatus
  EventStatus EventStatus?
}

class SpamFlag {
    UserId int
    FlaggedUserId int
}

class EventStatus{
    NoResponse
    Rejected
    Accepted
}

class MailFormat{
    Email
    Event
}

class MailStatus{
    Unread
    Read
}

class UserRights{
    Standard
    Elevated
}

class UserStatus{
    Disabled
    Active
}


User .. UserStatus
User .. UserRights

Mail .. MailFormat

Recipient .. MailStatus
Recipient .. EventStatus

Loading

Seed data

Users

Username	Password	Status	Rights	Flagged users
administrator@dmail.hr	administrator-password	Active	Elevated	user@dmail.hr, dario@dmail.hr
user@dmail.hr	user-password	Active	Standard	dario@dmail.hr
dario@dmail.hr	password	Active	Standard

Other

Known limitations

Limitation	Description
Exit to parent menu / app reload required to reflect database changes in UI.	Even if the database contains the recent changes, some changes seem to be missing in the user interface. A exit to the parent menu / reload of the application is needed to reflect those changes in the UI.

ToDos

Status	Title	Description
✅	Some actions directly call AuthAction.GetCurrentlyAuthenticatedUser().	Some actions are not following the dependency injection pattern. Fix by removing AuthAction.GetCurrentlyAuthenticatedUser() calls from Actions.
❎	Outbox event deletion does not cancel the event.	Add isCancelled property to Mail entity.
✅	Outbox event deletion does not cancel the event.	Use Mail.HiddenFromSender property to determine whether a event is cancelled.
✅	Outbox mail not sorted correctly.
✅	Deleting mail from inbox results in removal from the mails recipients list.	Add MailStatus Deleted and stop deleting Recipient entry on mail deletion.
✅	Add more seed data.