public static void AddAddresses(StudioDbContext context)
{
InputAddressData addressData = new InputAddressData
{
Street = "Vasil Levski",
Number = "10",
Building = "3G",
Entrance = "B"
};
var cityId = CommandArrangeHelper.GetCityId(context, null);
var addresses = new List <Address>
{
new Address {
Id = 1, AddressFormat = (AddressFormat)addressData, Longitude = 40.35M, Latitude = 56.23M, CityId = cityId
},
new Address {
Id = 2, AddressFormat = (AddressFormat)addressData, Longitude = 40.35M, Latitude = 56.23M, CityId = cityId
},
new Address {
Id = 3, AddressFormat = (AddressFormat)addressData, Longitude = 40.35M, Latitude = 56.23M, CityId = cityId
}
};
context.Addresses.AddRange(addresses);
context.SaveChanges();
}
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 AddLocationIndustries(StudioDbContext context)
{
var locationId = CommandArrangeHelper.GetLocationId(context, null, null);
var industryId = CommandArrangeHelper.GetIndustryId(context);
var locationIndustry = new LocationIndustry {
LocationId = locationId, IndustryId = industryId, Description = "Good!"
};
context.LocationIndustries.Add(locationIndustry);
context.SaveChanges();
}
public static void AddLocations(StudioDbContext context)
{
var cityId = CommandArrangeHelper.GetCityId(context, null);
var addressId = CommandArrangeHelper.GetAddressId(context, cityId);
var clientId = CommandArrangeHelper.GetClientId(context);
var locations = new List <Location>
{
new Location {
Id = 1, Name = GConst.ValidName, StartDay = Workday.Понеделник, EndDay = Workday.Петък, StartHour = "9", EndHour = "18", Phone = "0888777666", AddressId = addressId, ClientId = clientId
}
};
context.Locations.AddRange(locations);
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 void AddServices(StudioDbContext context)
{
var industryId = CommandArrangeHelper.GetIndustryId(context);
var services = new List <Service>
{
new Service {
Id = 1, Name = "Hairstyle", IndustryId = industryId
},
new Service {
Id = 2, Name = "Colormade", IndustryId = industryId
},
new Service {
Id = 3, Name = "Massage", IndustryId = industryId
}
};
context.Services.AddRange(services);
context.SaveChanges();
}
public static void AddCities(StudioDbContext context)
{
var countryId = CommandArrangeHelper.GetCountryId(context);
var cities = new List <City>
{
new City {
Id = 1, Name = "Sofia", CountryId = countryId
},
new City {
Id = 2, Name = "Varna", CountryId = countryId
},
new City {
Id = 3, Name = "Burgas", CountryId = countryId
},
};
context.Cities.AddRange(cities);
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);
}
