public void UpdateEmployeeTreatments(SalonContext context, string[] selectedTreatments, Employee employeeToUpdate)
{
if (selectedTreatments == null)
{
employeeToUpdate.TreatmentAssignments = new List <TreatmentAssignment>();
return;
}
var selectedTreatmentsHS = new HashSet <string>(selectedTreatments);
var employeeTreatments = new HashSet <int>
(employeeToUpdate.TreatmentAssignments.Select(t => t.Treatment.Id));
foreach (var treatment in context.Treatment)
{
if (selectedTreatmentsHS.Contains(treatment.Id.ToString()))
{
if (!employeeTreatments.Contains(treatment.Id))
{
employeeToUpdate.TreatmentAssignments.Add(
new TreatmentAssignment
{
TreatmentId = treatment.Id,
EmployeeId = employeeToUpdate.Id
});
}
}
else
{
if (employeeTreatments.Contains(treatment.Id))
{
TreatmentAssignment treatmentToRemove =
employeeToUpdate.TreatmentAssignments
.SingleOrDefault(i => i.TreatmentId == treatment.Id);
context.Remove(treatmentToRemove);
}
}
}
}
public static void Initialize(SalonContext context)
{
context.Database.EnsureCreated();
if (!context.Treatment.Any())
{
var treatments = new Treatment[]
{
new Treatment {
Name = "Manicure hybrydowy", Duration = new TimeSpan(1, 0, 0), Price = 80, Category = 1
},
new Treatment {
Name = "Manicure żelowy - założenie", Duration = new TimeSpan(2, 0, 0), Price = 120, Category = 1
},
new Treatment {
Name = "Manicure żelowy - korekta", Duration = new TimeSpan(1, 30, 0), Price = 90, Category = 1
},
new Treatment {
Name = "Manicure japoński", Duration = new TimeSpan(0, 30, 0), Price = 60, Category = 1
},
new Treatment {
Name = "Pedicure hybrydowy", Duration = new TimeSpan(1, 0, 0), Price = 80, Category = 1
},
new Treatment {
Name = "Pedicure klasyczny", Duration = new TimeSpan(1, 0, 0), Price = 60, Category = 1
},
new Treatment {
Name = "Przedłużanie rzęs - założenie", Duration = new TimeSpan(1, 30, 0), Price = 150, Category = 2
},
new Treatment {
Name = "Przedłużanie rzęs - korekta", Duration = new TimeSpan(1, 0, 0), Price = 100, Category = 2
},
new Treatment {
Name = "Henna brwi / rzęs", Duration = new TimeSpan(0, 15, 0), Price = 20, Category = 2
},
new Treatment {
Name = "Regulacja brwi", Duration = new TimeSpan(0, 15, 0), Price = 10, Category = 2
},
new Treatment {
Name = "Opalanie natryskowe", Duration = new TimeSpan(0, 45, 0), Price = 80, Category = 3
},
new Treatment {
Name = "Mikrodermabrazja", Duration = new TimeSpan(1, 0, 0), Price = 100, Category = 4
},
new Treatment {
Name = "Zabieg Anti Aging", Duration = new TimeSpan(1, 0, 0), Price = 120, Category = 4
},
new Treatment {
Name = "Zabieg Anti Acne", Duration = new TimeSpan(1, 0, 0), Price = 120, Category = 4
},
new Treatment {
Name = "Zabieg Anti Dry", Duration = new TimeSpan(1, 0, 0), Price = 120, Category = 4
},
new Treatment {
Name = "Zabieg Anti Rouge", Duration = new TimeSpan(1, 0, 0), Price = 120, Category = 4
},
new Treatment {
Name = "Masaż twarzy", Duration = new TimeSpan(0, 30, 0), Price = 60, Category = 4
},
new Treatment {
Name = "Masaż gorącymi kamieniami", Duration = new TimeSpan(1, 0, 0), Price = 100, Category = 3
}
};
foreach (Treatment t in treatments)
{
context.Treatment.Add(t);
}
context.SaveChanges();
}
if (!context.Users.Any())
{
var users = new AppUser[]
{
new AppUser {
FirstName = "Adam", LastName = "Małysz", UserName = "******",
NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**",
PasswordHash = "AQAAAAEAACcQAAAAEF2+bzkrQQJxx/o91I+qPiZo+hx5kd9BbVUsvEWk3S7s6yxnrUoyGh4GjZaxUd58VQ==",
SecurityStamp = "FD4VTY7VO3NXLA6RDQZ7UUTMICJGQAL6", ConcurrencyStamp = "f47689b9-d29c-44e4-af26-00152339e041",
PhoneNumber = "123456789", LockoutEnabled = true, AccessFailedCount = 0
},
new AppUser {
FirstName = "Robert", LastName = "Kubica", UserName = "******",
NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**",
PasswordHash = "AQAAAAEAACcQAAAAEF2+bzkrQQJxx/o91I+qPiZo+hx5kd9BbVUsvEWk3S7s6yxnrUoyGh4GjZaxUd58VQ==",
SecurityStamp = "ET5UKGXLXLEDNX54H6ZI6XYIP3PVNOKB", ConcurrencyStamp = "37d393db-0376-46d1-85fc-85cb799ec6cd",
PhoneNumber = "123456789", LockoutEnabled = true, AccessFailedCount = 0
},
new AppUser {
FirstName = "Justyna", LastName = "Kowalczyk", UserName = "******",
NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**",
PasswordHash = "AQAAAAEAACcQAAAAEF2+bzkrQQJxx/o91I+qPiZo+hx5kd9BbVUsvEWk3S7s6yxnrUoyGh4GjZaxUd58VQ==",
SecurityStamp = "JDU5TXBYQPKHLIC32L2QW5WQPMUUE2JW", ConcurrencyStamp = "48049f66-d6c3-4f3d-a6c8-3d94ccc0bd57",
PhoneNumber = "123456789", LockoutEnabled = true, AccessFailedCount = 0
},
new AppUser {
FirstName = "Basia", LastName = "Szweda", UserName = "******",
NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**",
PasswordHash = "AQAAAAEAACcQAAAAEF2+bzkrQQJxx/o91I+qPiZo+hx5kd9BbVUsvEWk3S7s6yxnrUoyGh4GjZaxUd58VQ==",
SecurityStamp = "JNVZNOMSXX63POQWXOIBZGMUSFKDTQRV", ConcurrencyStamp = "ac38b4a1-5880-41b5-ae9f-a59998608f2d",
PhoneNumber = "123456789", LockoutEnabled = true, AccessFailedCount = 0
}
};
foreach (AppUser u in users)
{
context.Users.Add(u);
}
context.SaveChanges();
}
if (!context.Employee.Any())
{
var emps = new Employee[]
{
new Employee {
UserId = 1
},
new Employee {
UserId = 2
},
new Employee {
UserId = 3
},
new Employee {
UserId = 4
}
};
foreach (Employee e in emps)
{
context.Employee.Add(e);
}
context.SaveChanges();
}
if (!context.TreatmentAssignment.Any())
{
var treatmentAssignments = new TreatmentAssignment[]
{
new TreatmentAssignment {
EmployeeId = 1, TreatmentId = 1
},
new TreatmentAssignment {
EmployeeId = 1, TreatmentId = 2
},
new TreatmentAssignment {
EmployeeId = 2, TreatmentId = 3
},
new TreatmentAssignment {
EmployeeId = 2, TreatmentId = 4
},
new TreatmentAssignment {
EmployeeId = 3, TreatmentId = 5
},
new TreatmentAssignment {
EmployeeId = 3, TreatmentId = 6
},
new TreatmentAssignment {
EmployeeId = 4, TreatmentId = 7
},
new TreatmentAssignment {
EmployeeId = 4, TreatmentId = 8
},
new TreatmentAssignment {
EmployeeId = 4, TreatmentId = 9
},
new TreatmentAssignment {
EmployeeId = 4, TreatmentId = 10
}
};
foreach (TreatmentAssignment ta in treatmentAssignments)
{
context.TreatmentAssignment.Add(ta);
}
context.SaveChanges();
}
if (!context.Enrollment.Any())
{
var enrollments = new Enrollment[]
{
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 16, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 20, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 1, 10, 0, 0), Active = false
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 2, 10, 0, 0), Active = false
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 3, 10, 0, 0), Active = false
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 5, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 14, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 23, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 24, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 28, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 2, 2, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 2, 8, 10, 0, 0), Active = true
}
};
foreach (Enrollment en in enrollments)
{
context.Enrollment.Add(en);
}
context.SaveChanges();
}
}
