public static void AddEmployeeServices(StudioDbContext context)
{
var employeeId = CommandArrangeHelper.GetEmployeeId(context, null);
var serviceId = CommandArrangeHelper.GetServiceId(context, null);
var employeeService = new EmployeeService {
EmployeeId = employeeId, ServiceId = serviceId, Price = 40.00M, DurationInMinutes = "30"
};
context.EmployeeServices.AddRange(employeeService);
context.SaveChanges();
}
public static void AddEmployees(StudioDbContext context)
{
var industryId = CommandArrangeHelper.GetIndustryId(context);
var serviceId = CommandArrangeHelper.GetServiceId(context, industryId);
var addressId = CommandArrangeHelper.GetAddressId(context, null);
var locationId = CommandArrangeHelper.GetLocationId(context, null, addressId);
var employee = new Employee {
Id = 1, FirstName = GConst.ValidName, LastName = GConst.ValidName, LocationId = locationId
};
context.Employees.Add(employee);
var employeeService = new EmployeeService {
ServiceId = serviceId, EmployeeId = employee.Id
};
context.EmployeeServices.Add(employeeService);
context.SaveChanges();
}
public static string AddAppointmentes(StudioDbContext context)
{
var userId = CommandArrangeHelper.GetUserId(context);
var employeeId = CommandArrangeHelper.GetEmployeeId(context, null);
var serviceId = CommandArrangeHelper.GetServiceId(context, null);
var appointments = new List <Appointment>
{
new Appointment {
Id = 1, Comment = "Be Happy!", ReservationDate = new DateTime(2019, 09, 15), TimeBlockHelper = "9", ReservationTime = new DateTime(2019, 09, 15, 9, 0, 0), EmployeeId = employeeId, ServiceId = serviceId, UserId = userId
},
new Appointment {
Id = 2, Comment = "Be Happy!", ReservationDate = new DateTime(2019, 09, 15), TimeBlockHelper = "9", ReservationTime = new DateTime(2019, 09, 15, 9, 0, 0), EmployeeId = employeeId, ServiceId = serviceId, UserId = userId
},
new Appointment {
Id = 3, Comment = "Be Happy!", ReservationDate = new DateTime(2019, 09, 15), TimeBlockHelper = "9", ReservationTime = new DateTime(2019, 09, 15, 9, 0, 0), EmployeeId = employeeId, ServiceId = serviceId, UserId = userId
}
};
context.Appointments.AddRange(appointments);
context.SaveChanges();
return(userId);
}
