public CaseUserDTO GetClient(int caseId)
{
//Case _case = _database.Cases.Get(caseId);
//if (_case == null)
// throw new ValidationException("Дело не найдено", "");
Case _case = GetCase(caseId);
CaseUser caseUser = _database.CaseUsers.Find(cu => cu.CaseId == _case.Id).FirstOrDefault();
return(GetCaseUserDto(caseUser));
}
private CaseUserDTO GetCaseUserDto(CaseUser caseUser)
{
return(new CaseUserDTO
{
Id = caseUser.Id,
Name = caseUser.Name,
Surname = caseUser.Surname,
Patronymic = caseUser.Patronymic,
DateOfBirth = caseUser.DateOfBirth,
Phone = caseUser.Phone,
HomePhone = caseUser.HomePhone,
Email = caseUser.Email,
Address = caseUser.Address,
CaseId = caseUser.CaseId,
RoleInTheCaseId = caseUser.RoleInTheCaseId,
RoleInTheCase = caseUser.RoleInTheCase.Name
});
}
public void AddParticipant(int caseId, CaseUserDTO caseUserDTO)
{
Case _case = _database.Cases.Get(caseId);
if (_case == null)
{
throw new ValidationException("Дело не найдено", "");
}
CaseUser caseUser = _database.CaseUsers.Get(caseUserDTO.Id);
if (caseUser == null)
{
RoleInTheCase role = _database.CaseRoles.Get(caseUserDTO.RoleInTheCaseId);
caseUser = CreateCaseUser(caseUserDTO, _case, role);
_database.CaseUsers.Create(caseUser);
_database.Save();
}
_case.Participants.Add(caseUser);
_database.Save();
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <User>().HasOne(u => u.Role).WithMany(r => r.Users)
.HasForeignKey(u => u.RoleId);
modelBuilder.Entity <User>().HasMany(u => u.Cases).WithOne(c => c.User).HasForeignKey(c => c.UserId)
.OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <User>().HasMany(u => u.Documents).WithOne(d => d.User).HasForeignKey(c => c.UserId)
.OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <User>().HasMany(u => u.Notes).WithOne(n => n.User).HasForeignKey(c => c.UserId)
.OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <User>().HasOne(u => u.Schedule).WithMany(s => s.Users).HasForeignKey(u => u.ScheduleId);
modelBuilder.Entity <Case>().HasMany(c => c.Documents).WithOne(d => d.Case)
.HasForeignKey(u => u.CaseId).OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <CaseUser>().HasOne(c => c.Case).WithMany(c => c.Participants)
.HasForeignKey(c => c.CaseId);
modelBuilder.Entity <Case>().HasOne(c => c.Client).WithOne(cu => cu.Case)
.HasForeignKey <Client>(c => c.CaseId).OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <CaseUser>().HasOne(c => c.Client).WithOne(c => c.CaseUser)
.HasForeignKey <Client>(c => c.CaseUserId);
modelBuilder.Entity <Instance>().HasMany(i => i.Cases).WithOne(c => c.Instance)
.HasForeignKey(c => c.InstanceId).OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <KindOfCase>().HasMany(i => i.Cases).WithOne(c => c.KindOfCase)
.HasForeignKey(c => c.KindOfCaseId).OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <RoleInTheCase>().HasMany(i => i.CaseUsers).WithOne(c => c.RoleInTheCase)
.HasForeignKey(c => c.RoleInTheCaseId).OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <RoleInTheCase>().HasOne(r => r.KindOfCase).WithMany(k => k.RoleInTheCases)
.HasForeignKey(r => r.KindOfCaseId).OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <KindOfCaseInstance>()
.HasKey(k => new { k.KindOfCaseId, k.InstanceId });
modelBuilder.Entity <KindOfCaseInstance>()
.HasOne(kc => kc.KindOfCase)
.WithMany(ki => ki.KindOfCaseInstances)
.HasForeignKey(kc => kc.KindOfCaseId);
modelBuilder.Entity <KindOfCaseInstance>()
.HasOne(i => i.Instance)
.WithMany(ki => ki.KindOfCaseInstances)
.HasForeignKey(i => i.InstanceId);
modelBuilder.Entity <Question>().HasMany(q => q.Answers)
.WithOne(a => a.Question).HasForeignKey(a => a.QuestionId).OnDelete(DeleteBehavior.Cascade);
Role[] roles = new Role[]
{
new Role()
{
Id = 1, Name = "Заведующий", Design = "main-lawyer"
},
new Role()
{
Id = 2, Name = "Адвокат", Design = "lawyer"
}
};
modelBuilder.Entity <Role>().HasData(roles);
KindOfCase[] kindOfCases = new KindOfCase[]
{
new KindOfCase()
{
Id = 1, Name = "Уголовное дело"
},
new KindOfCase()
{
Id = 2, Name = "Гражданское дело"
},
new KindOfCase()
{
Id = 3, Name = "Административное дело"
},
};
Instance[] instances = new Instance[]
{
new Instance()
{
Id = 1, Name = "первая инстанция"
},
new Instance()
{
Id = 2, Name = "апелляционная инстанция"
},
new Instance()
{
Id = 3, Name = "надзорная инстанция"
},
new Instance()
{
Id = 4, Name = "областной суд"
},
new Instance()
{
Id = 5, Name = "верховный суд"
},
};
KindOfCaseInstance[] kindOfCaseInstances = new KindOfCaseInstance[]
{
new KindOfCaseInstance {
InstanceId = instances[0].Id, KindOfCaseId = kindOfCases[0].Id
},
new KindOfCaseInstance {
InstanceId = instances[0].Id, KindOfCaseId = kindOfCases[1].Id
},
new KindOfCaseInstance {
InstanceId = instances[0].Id, KindOfCaseId = kindOfCases[2].Id
},
new KindOfCaseInstance {
InstanceId = instances[1].Id, KindOfCaseId = kindOfCases[0].Id
},
new KindOfCaseInstance {
InstanceId = instances[1].Id, KindOfCaseId = kindOfCases[1].Id
},
new KindOfCaseInstance {
InstanceId = instances[2].Id, KindOfCaseId = kindOfCases[0].Id
},
new KindOfCaseInstance {
InstanceId = instances[2].Id, KindOfCaseId = kindOfCases[1].Id
},
new KindOfCaseInstance {
InstanceId = instances[3].Id, KindOfCaseId = kindOfCases[2].Id
},
new KindOfCaseInstance {
InstanceId = instances[4].Id, KindOfCaseId = kindOfCases[2].Id
}
};
modelBuilder.Entity <KindOfCase>().HasData(kindOfCases);
modelBuilder.Entity <Instance>().HasData(instances);
modelBuilder.Entity <KindOfCaseInstance>().HasData(kindOfCaseInstances);
RoleInTheCase[] roleInTheCases = new RoleInTheCase[]
{
new RoleInTheCase()
{
Id = 1, Name = "Обвиняемый", KindOfCaseId = 1
},
new RoleInTheCase()
{
Id = 2, Name = "Потерпевший", KindOfCaseId = 1
},
new RoleInTheCase()
{
Id = 3, Name = "Осуждённый", KindOfCaseId = 1
},
new RoleInTheCase()
{
Id = 4, Name = "Истец", KindOfCaseId = 2
},
new RoleInTheCase()
{
Id = 5, Name = "Ответчик", KindOfCaseId = 2
},
new RoleInTheCase()
{
Id = 6, Name = "Третье лицо", KindOfCaseId = 2
},
new RoleInTheCase()
{
Id = 7, Name = "Заявитель", KindOfCaseId = 2
},
new RoleInTheCase()
{
Id = 8, Name = "Потерпевший", KindOfCaseId = 3
},
new RoleInTheCase()
{
Id = 9, Name = "Лицо, в отшении которого ведётся дело", KindOfCaseId = 3
},
};
modelBuilder.Entity <RoleInTheCase>().HasData(roleInTheCases);
Schedule[] schedules = new Schedule[]
{
new Schedule()
{
Id = 1,
DayOfWeek = DayOfWeek.Monday
},
new Schedule()
{
Id = 2,
DayOfWeek = DayOfWeek.Tuesday
},
new Schedule()
{
Id = 3,
DayOfWeek = DayOfWeek.Wednesday
},
new Schedule()
{
Id = 4,
DayOfWeek = DayOfWeek.Thursday
},
new Schedule()
{
Id = 5,
DayOfWeek = DayOfWeek.Friday
}
};
modelBuilder.Entity <Schedule>().HasData(schedules);
Price[] prices = new Price[]
{
new Price
{
Id = 1, ForWhat = "2.1 Консультация, совет, " +
"не требующие ознакомления с документами, от двух до пяти базовых величин ",
StartSum = 54.00, FinishSum = 135.00
},
new Price
{
Id = 2, ForWhat = "2.2 Консультация, совет, требующие ознакомления с документами, " +
"либо представляющие сложность, от трех до десяти базовых величин ",
StartSum = 81.00, FinishSum = 270.00
},
new Price
{
Id = 3, ForWhat = "2.3 Составление правовых документов – от трех до пятнадцати базовых величин",
StartSum = 81.00, FinishSum = 405.00
},
new Price
{
Id = 4, ForWhat = "2.4 Составление сложных правовых документов, " +
"в том числе связанных с истребованием адвокатами дополнительных материалов " +
"и (или) ознакомлением с дополнительными материалами - от восьми до двадцати базовых величин",
StartSum = 216.00, FinishSum = 540.00
},
new Price
{
Id = 5, ForWhat = "2.5 Один день участия адвоката в предварительном следствии, " +
"дознании и в судах первой инстанции при ведении уголовных, административных " +
"и гражданских дел, в том числе изучение материалов дела, подготовка к ведению дела, " +
"посещение в местах лишения свободы, изучение протокола судебного заседания, " +
"составление замечаний на протокол судебного заседания, составление кассационной жалобы," +
" - от восьми до пятнадцати базовых величин "
, StartSum = 216.00, FinishSum = 405.00
},
new Price
{
Id = 6, ForWhat = "2.6 При сложности дела, а также по делам, связанным с выездом адвоката в командировку, " +
"- от десяти до двадцати базовых величин "
, StartSum = 270.00, FinishSum = 540.00
},
new Price
{
Id = 7, ForWhat = "2.7 Иные виды юридической помощи " +
"(участие в переговорах, подача адвокатского запроса и получение6 ответа на запрос, " +
"представление интересов в государственных и иных органах и организациях) – " +
"от пяти до двадцати базовых величин ", StartSum = 135.00, FinishSum = 540.00
},
new Price
{
Id = 8, ForWhat = "Базовая величина исчислена на 1 января 2020 года в размере ", StartSum = 27.00, FinishSum = 27.00
}
};
modelBuilder.Entity <Price>().HasData(prices);
User[] users = new User[]
{
new User()
{
Id = 1,
Login = "******",
Password = "******",
Name = "Светлана",
Surname = "Асадчая",
Patronymic = "Яковлевна",
DateOfBirth = DateTime.Parse("29.08.1969"),
Email = "*****@*****.**",
Phone = "+375(44)747-88-51",
HomePhone = "30-16-86",
RoleId = 1,
Address = "Чечерская 17",
ScheduleId = 1
},
new User()
{
Id = 2,
Login = "******",
Password = "******",
Name = "Елена",
Surname = "Пивнова",
Patronymic = "Михайловна",
DateOfBirth = DateTime.Parse("09.04.1975"),
Email = "*****@*****.**",
Phone = "+375(44)695-25-44",
HomePhone = "30-36-86",
RoleId = 2,
Address = "Пушкина 7",
ScheduleId = 2
}
};
modelBuilder.Entity <User>().HasData(users);
Case[] cases = new Case[]
{
new Case()
{
Id = 1,
Title = "Дело №1",
KindOfCaseId = 1,
InstanceId = 1,
UserId = 1,
Date = DateTime.Now.Date,
ArticleOrCategory = "122",
VerdictOrDecision = "не вынесен"
},
new Case()
{
Id = 2,
Title = "Дело №2",
KindOfCaseId = 3,
InstanceId = 4,
UserId = 1,
Date = DateTime.Now.Date,
ArticleOrCategory = "255",
VerdictOrDecision = "не вынесен"
},
new Case()
{
Id = 3,
Title = "Дело №3",
KindOfCaseId = 2,
InstanceId = 2,
UserId = 2,
Date = DateTime.Now.Date,
ArticleOrCategory = "жилищные",
VerdictOrDecision = "не вынесено"
},
};
modelBuilder.Entity <Case>().HasData(cases);
CaseUser[] caseusers = new CaseUser[]
{
new CaseUser()
{
Id = 1,
Name = "Пупкин",
Surname = "Андрей",
Patronymic = "Леонидович",
DateOfBirth = DateTime.Parse("22.05.1987"),
Email = "*****@*****.**",
Phone = "+375(44)695-25-44",
HomePhone = "10-16-86",
CaseId = 1,
RoleInTheCaseId = 2
},
new CaseUser()
{
Id = 2,
Name = "Мупкин",
Surname = "Игорь",
Patronymic = "Леонидович",
DateOfBirth = DateTime.Parse("22.05.1987"),
CaseId = 1,
RoleInTheCaseId = 1
},
new CaseUser()
{
Id = 3,
Name = "Минина",
Surname = "Ирина",
Patronymic = "Олеговна",
DateOfBirth = DateTime.Parse("22.05.1947"),
Phone = "+375(44)665-65-84",
CaseId = 2,
RoleInTheCaseId = 8
},
new CaseUser()
{
Id = 4,
Name = "Кучер",
Surname = "Магомед",
Patronymic = "Алибабович",
DateOfBirth = DateTime.Parse("22.05.1990"),
CaseId = 2,
RoleInTheCaseId = 9
},
new CaseUser()
{
Id = 5,
Name = "Морган",
Surname = "Фримен",
Patronymic = "Леонидович",
DateOfBirth = DateTime.Parse("22.05.1940"),
Email = "*****@*****.**",
CaseId = 3,
RoleInTheCaseId = 4
},
new CaseUser()
{
Id = 6,
Name = "Джарет",
Surname = "Лето",
Patronymic = "Леонидович",
DateOfBirth = DateTime.Parse("22.05.1970"),
Email = "*****@*****.**",
Phone = "+375(44)747-23-78",
CaseId = 3,
RoleInTheCaseId = 5
},
};
modelBuilder.Entity <CaseUser>().HasData(caseusers);
Client[] clients = new Client[]
{
new Client()
{
Id = 1, CaseUserId = 1, CaseId = 1, Money = 0
},
new Client()
{
Id = 2, CaseUserId = 3, CaseId = 2, Money = 0
},
new Client()
{
Id = 3, CaseUserId = 5, CaseId = 3, Money = 0
},
};
modelBuilder.Entity <Client>().HasData(clients);
}
public void StartCase(CaseDTO caseDto, CaseUserDTO caseUser)
{
KindOfCase kindOfCase = _database.KindOfCases.Find(k => k.Id == caseDto.KindOfCaseId).FirstOrDefault();
if (kindOfCase == null)
{
throw new ValidationException(caseDto.KindOfCase + "- не найден", "");
}
Instance instance = _database.Instances.Find(i => i.Id == caseDto.InstanceId).FirstOrDefault();
if (instance == null)
{
throw new ValidationException(caseDto.Instance + "- не найден", "");
}
User user = _database.Users.Get(caseDto.UserId);
if (user == null)
{
throw new ValidationException("Пользователь не найден", "");
}
//Case _case = _database.Cases.Find(c => c.Title == caseDto.Title).FirstOrDefault();
//if (_case != null)
// throw new ValidationException("Дело с таким названием уже существует", "");
Case _case = new Case
{
Title = "Дело " + caseUser.Surname + " " + caseUser.Name[0] + ". " + caseUser.Patronymic[0],
KindOfCase = kindOfCase,
Instance = instance,
User = user,
Date = caseDto.Date,
ArticleOrCategory = caseDto.ArticleOrCategory,
VerdictOrDecision = caseDto.VerdictOrDecision,
};
_database.Cases.Create(_case);
_database.Save();
CaseUser _caseUser = _database.CaseUsers.Find(c => c.Name == caseUser.Name &&
c.Patronymic == caseUser.Patronymic &&
c.Surname == caseUser.Surname &&
c.DateOfBirth == caseUser.DateOfBirth &&
c.Address == caseUser.Address).FirstOrDefault();
if (_caseUser == null)
{
RoleInTheCase role = _database.CaseRoles.Get(caseUser.RoleInTheCaseId);
_caseUser = CreateCaseUser(caseUser, _case, role);
_database.CaseUsers.Create(_caseUser);
_database.Save();
}
Client client = _database.Clients.Find(c => c.CaseUserId == _caseUser.Id).FirstOrDefault();
if (client == null)
{
client = new Client()
{
CaseUser = _caseUser,
Case = _case,
Money = 0
};
_database.Clients.Create(client);
_database.Save();
}
else
{
client.Case = _case;
_database.Save();
}
}