using System;
using System.Collections.Generic;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;

namespace Rkis29
{
    public partial class loferlContext : DbContext
    {
        public loferlContext()
        {
        }

        public loferlContext(DbContextOptions<loferlContext> options)
            : base(options)
        {
        }

        public virtual DbSet<Status> Statuses { get; set; } = null!;
        public virtual DbSet<Task> Tasks { get; set; } = null!;
        public virtual DbSet<User> Users { get; set; } = null!;

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            if (!optionsBuilder.IsConfigured)
            {
                optionsBuilder.UseSqlServer("Data Source=(localdb)\\mssqllocaldb; Initial Catalog=loferl;Trusted_Connection=True;");
                optionsBuilder.UseLazyLoadingProxies();
            }
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Status>(entity =>
            {
                entity.HasKey(e => e.StatusesTaskId);

                entity.Property(e => e.StatusesTaskId).HasColumnName("StatusesTaskID");

                entity.Property(e => e.Name).HasMaxLength(50);
            });

            modelBuilder.Entity<Task>(entity =>
            {
                entity.HasKey(e => e.TasksId);

                entity.Property(e => e.TasksId).HasColumnName("TasksID");

                entity.Property(e => e.Data).HasMaxLength(50);

                entity.Property(e => e.Description).HasMaxLength(50);

                entity.Property(e => e.Name).HasMaxLength(50);

                entity.Property(e => e.StatusTaskId).HasColumnName("StatusTaskID");

                entity.Property(e => e.UserCreaterId).HasColumnName("UserCreaterID");

                entity.Property(e => e.UserTakerId).HasColumnName("UserTakerID");

                entity.HasOne(d => d.StatusTask)
                    .WithMany(p => p.Tasks)
                    .HasForeignKey(d => d.StatusTaskId)
                    .OnDelete(DeleteBehavior.ClientSetNull)
                    .HasConstraintName("FK_Tasks_Statuses");

                entity.HasOne(d => d.UserCreater)
                    .WithMany(p => p.TaskUserCreaters)
                    .HasForeignKey(d => d.UserCreaterId)
                    .HasConstraintName("FK_Tasks_Users1");

                entity.HasOne(d => d.UserTaker)
                    .WithMany(p => p.TaskUserTakers)
                    .HasForeignKey(d => d.UserTakerId)
                    .HasConstraintName("FK_Tasks_Users");
            });

            modelBuilder.Entity<User>(entity =>
            {
                entity.HasKey(e => e.UsersId);

                entity.Property(e => e.UsersId).HasColumnName("UsersID");

                entity.Property(e => e.FirstName).HasMaxLength(50);

                entity.Property(e => e.LastName).HasMaxLength(50);

                entity.Property(e => e.Login).HasMaxLength(50);

                entity.Property(e => e.Name).HasMaxLength(50);

                entity.Property(e => e.Password).HasMaxLength(50);

                entity.Property(e => e.PhonNum).HasMaxLength(12);
            });

            OnModelCreatingPartial(modelBuilder);
        }

        partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
    }
}