public async Task <Result> Handle(RegisterRestaurantCommand request, CancellationToken cancellationToken)
{
var city = await _context.Cities
.Include(x => x.Localities)
.SingleOrDefaultAsync(x => x.Id == request.CityId, cancellationToken);
if (city.HasNoValue())
{
return(Result.Failure("invalid city"));
}
var locality = city.Localities.FirstOrDefault(x => x.Id == request.LocalityId);
if (locality.HasNoValue())
{
return(Result.Failure("invalid locality"));
}
var categories = await _context.Categories.AsNoTracking()
.AsQueryable().Where(x => request.CategoryIds.Contains(x.Id))
.ToListAsync(cancellationToken: cancellationToken);
if (categories.HasNoValue() || !categories.Any())
{
return(Result.Failure("invalid category"));
}
var cuisines = await _context.Cuisines.AsNoTracking()
.AsQueryable().Where(x => request.CuisineIds.Contains(x.Id))
.ToListAsync(cancellationToken: cancellationToken);
if (cuisines.HasNoValue() || !cuisines.Any())
{
return(Result.Failure("invalid cuisine"));
}
var restaurant = new Domain.Restaurants.Restaurant(
request.Name,
request.OpeningHour,
request.ClosingHour,
request.SubscriptionType,
request.ContractStatus,
PhoneNumberValue.Of(SupportedCountryCode.Italy, request.PhoneNumber),
request.ImageUrl,
locality,
new GeographicLocation(request.Address, request.Lat, request.Lon),
description: request.Description,
descriptionEng: request.DescriptionEng
);
categories.ForEach(x => restaurant.SupportNewCategory(x));
cuisines.ForEach(x => restaurant.SupportNewCuisine(x));
_context.Restaurants.Attach(restaurant);
var result = await _unitOfWork.CommitAsync(cancellationToken);
return(result > 0
? Result.Ok("restaurant registered successfully")
: Result.Failure("failed to register restaurant"));
}
public Review(int starRate, string comment, PhoneNumberValue userPhoneNumber, long itemId)
{
StarRate = starRate;
Comment = comment;
UserPhoneNumber = userPhoneNumber;
ItemId = itemId;
}
public Restaurant(string name, int openingHour, int closingHour,
SubscriptionType subscriptionType, ContractStatus contractStatus, PhoneNumberValue phoneNumber,
string imageUrl, Locality locality, GeographicLocation location, string description,
string descriptionEng)
{
CheckRule(new OpeningAndClosingHoursAreValid(openingHour, closingHour));
CheckRule(new ConditionMustBeTrueRule(subscriptionType != SubscriptionType.Invalid,
"subscription must be valid"));
CheckRule(new ConditionMustBeTrueRule(contractStatus != ContractStatus.Invalid,
"contract must be valid"));
CheckRule(new ConditionMustBeTrueRule(phoneNumber != null,
"phone number be valid"));
ImageUrl = imageUrl;
Locality = locality;
GeographicLocation = location;
Description = description;
DescriptionEng = descriptionEng;
Name = name;
OpeningHour = openingHour;
ClosingHour = closingHour;
SubscriptionType = subscriptionType;
ContractStatus = contractStatus;
State = RestaurantState.Open;
ExpirationDate = subscriptionType.GetExpirationTime();
PhoneNumber = phoneNumber;
}
public TechnicianDTO(Guid technicianId, PersonNameValue name, PersonNameValue lastname, string cI, PhoneNumberValue phone, EmailValue email)
{
TechnicianId = technicianId;
Name = name;
Lastname = lastname;
CI = cI;
Phone = phone;
Email = email;
}
public Technician(PersonNameValue name, PersonNameValue lastname, string ci, PhoneNumberValue phone, EmailValue email)
{
CheckRule(new NotNullRule <string>(ci));
TechnicianId = Guid.NewGuid();
Name = name;
Lastname = lastname;
CI = ci;
Phone = phone;
Email = email;
}
public Client(PersonNameValue name, PersonNameValue lastname, PhoneNumberValue phone, EmailValue email, string address)
{
CheckRule(new NotNullRule <string>(address));
ClientId = Guid.NewGuid();
Name = name;
Lastname = lastname;
Phone = phone;
Email = email;
Address = address;
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity <Food>(builder =>
{
builder.Property(x => x.Name).IsRequired();
builder.Property(x => x.IsVeg).IsRequired();
builder.Property(x => x.IsNonVeg).IsRequired();
builder.Property(x => x.IsGlutenFree).IsRequired();
builder.Property(x => x.ImageUrl).IsRequired();
builder.HasIndex(u => u.Name);
builder.Property(p => p.UnitPrice)
.IsRequired()
.HasConversion(p => p.Value, p => MoneyValue.Of(p));
builder.Property(p => p.OldUnitPrice)
.IsRequired()
.HasConversion(p => p.Value, p => MoneyValue.Of(p));
builder.Property(x => x.Type)
.IsRequired()
.HasConversion <string>();
builder.Property(x => x.Status)
.IsRequired()
.HasConversion <string>();
builder.HasMany(x => x.Variants)
.WithOne(v => v.Food)
.OnDelete(DeleteBehavior.Cascade)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
builder.HasMany(x => x.AddOns)
.WithOne(v => v.Food)
.OnDelete(DeleteBehavior.Cascade)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
builder.Metadata
.FindNavigation("Tags")
.SetPropertyAccessMode(PropertyAccessMode.Field);
}
);
modelBuilder.Entity <Variant>(builder =>
{
builder.Property(x => x.Price)
.IsRequired()
.HasConversion(p => p.Value, p => MoneyValue.Of(p));
builder.Property(x => x.OldPrice)
.IsRequired()
.HasConversion(p => p.Value, p => MoneyValue.Of(p));
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.NameEng)
.IsRequired();
builder.Property(x => x.Description)
.IsRequired();
builder.Property(x => x.DescriptionEng)
.IsRequired();
});
modelBuilder.Entity <Order>(builder =>
{
builder.HasMany(x => x.Items)
.WithOne(v => v.Order)
.OnDelete(DeleteBehavior.Cascade)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
builder.HasOne(x => x.Detail);
builder.Property(x => x.State)
.IsRequired()
.HasConversion <string>();
builder.Property(x => x.Type)
.IsRequired()
.HasConversion <string>();
builder.Property(x => x.PaymentType)
.IsRequired()
.HasConversion <string>();
builder.Property(p => p.PayableAmount)
.IsRequired()
.HasConversion(p => p.Value, p => MoneyValue.Of(p));
builder.Property(p => p.TotalAmount)
.IsRequired()
.HasConversion(p => p.Value, p => MoneyValue.Of(p));
});
modelBuilder.Entity <OrderDetail>(builder =>
{
builder.Property(x => x.Address)
.IsRequired();
builder.Property(x => x.CustomerName)
.IsRequired();
builder.Property(x => x.ContactNumber)
.IsRequired();
builder.Property(x => x.DeliveryLocation)
.IsRequired()
.HasConversion(x => $"{x.Latitude},{x.Longitude}", x => new LocationValue(x));
});
modelBuilder.Entity <City>(builder =>
{
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.NameEng)
.IsRequired();
builder.Property(x => x.Code)
.IsRequired();
builder.HasIndex(u => u.Name)
.IsUnique();
builder.HasIndex(u => u.NameEng)
.IsUnique();
builder.HasIndex(u => u.Code)
.IsUnique();
builder.HasMany(x => x.Localities)
.WithOne(x => x.City)
.OnDelete(DeleteBehavior.Cascade)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
});
modelBuilder.Entity <Locality>(builder =>
{
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.NameEng)
.IsRequired();
builder.Property(x => x.Code)
.IsRequired();
builder.HasIndex(u => u.Name)
.IsUnique();
builder.HasIndex(u => u.NameEng)
.IsUnique();
builder.HasIndex(u => u.Code)
.IsUnique();
});
modelBuilder.Entity <Restaurant>(builder =>
{
builder.HasIndex(u => u.Name)
.IsUnique();
builder.HasIndex(u => u.PhoneNumber)
.IsUnique();
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.PhoneNumber)
.IsRequired()
.HasConversion(x => x.GetCompletePhoneNumber(),
p => PhoneNumberValue.Of(SupportedCountryCode.Italy, p));
builder.HasOne(x => x.Locality)
.WithMany()
.IsRequired();
builder.HasOne(x => x.GeographicLocation)
.WithOne(x => x.Restaurant)
.HasForeignKey <GeographicLocation>(b => b.RestaurantId)
.IsRequired();
builder.Property(x => x.OpeningHour)
.IsRequired();
builder.Property(x => x.ClosingHour)
.IsRequired();
builder.Property(x => x.State)
.IsRequired()
.HasConversion <string>();
builder.Property(x => x.SubscriptionType)
.IsRequired()
.HasConversion <string>();
builder.Property(x => x.ContractStatus)
.IsRequired()
.HasConversion <string>();
builder.HasOne(x => x.PricingPolicy);
builder.HasMany(x => x.Foods)
.WithOne(f => f.Restaurant)
.OnDelete(DeleteBehavior.Cascade);
builder.Metadata
.FindNavigation("Foods")
.SetPropertyAccessMode(PropertyAccessMode.Field);
builder.HasMany(x => x.Menus)
.WithOne(f => f.Restaurant)
.OnDelete(DeleteBehavior.Cascade);
builder.Metadata
.FindNavigation("Menus")
.SetPropertyAccessMode(PropertyAccessMode.Field);
builder.HasMany(x => x.Orders)
.WithOne(f => f.Restaurant)
.OnDelete(DeleteBehavior.Cascade);
builder.Metadata
.FindNavigation("Orders")
.SetPropertyAccessMode(PropertyAccessMode.Field);
builder.HasMany(x => x.Categories)
.WithOne()
.OnDelete(DeleteBehavior.NoAction)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
builder.HasMany(x => x.Cuisines)
.WithOne()
.OnDelete(DeleteBehavior.NoAction)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
}
);
modelBuilder.Entity <Menu>(builder =>
{
builder.Property(x => x.Name).IsRequired();
builder.HasIndex(u => u.Name)
.IsUnique();
builder.HasIndex(u => u.NameEng)
.IsUnique();
builder.HasMany(x => x.Items)
.WithOne(x => x.Menu)
.OnDelete(DeleteBehavior.NoAction)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
});
modelBuilder.Entity <Promotion>(builder =>
{
builder.Property(x => x.StartDate)
.IsRequired();
builder.Property(x => x.Description)
.IsRequired();
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.ImageUrl)
.IsRequired();
builder.Property(x => x.EndDate)
.IsRequired();
builder.Property(x => x.FixedDiscountAmount)
.HasColumnType("decimal(18,4)");
builder.Property(x => x.MinimumBillAmount)
.HasColumnType("decimal(18,4)");
builder.Property(x => x.MaximumDiscountAmount)
.HasColumnType("decimal(18,4)");
builder.Property(x => x.DiscountPercentage)
.HasColumnType("decimal(18,4)");
builder.HasIndex(x => x.Name)
.IsUnique();
builder.HasIndex(x => x.EndDate);
builder.Property("_items").HasColumnName("Items");
builder.HasMany(x => x.CouponCodes)
.WithOne(x => x.Promotion)
.OnDelete(DeleteBehavior.Cascade)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
});
modelBuilder.Entity <Deal>(builder =>
{
builder.Property(x => x.StartDate)
.IsRequired();
builder.Property(x => x.Description)
.IsRequired();
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.ImageUrl)
.IsRequired();
builder.Property(x => x.EndDate)
.IsRequired();
builder.Property(x => x.MinimumBillAmount)
.IsRequired();
builder.Property(x => x.MinimumItemQuantity)
.IsRequired();
builder.Property(x => x.IsFixedDiscount)
.IsRequired();
builder.Property(x => x.IsPackageDeal)
.IsRequired();
builder.Property(x => x.FixedDiscountAmount)
.HasColumnType("decimal(18,4)");
builder.Property(x => x.MinimumBillAmount)
.HasColumnType("decimal(18,4)");
builder.Property(x => x.MaximumBillAmount)
.HasColumnType("decimal(18,4)");
builder.Property(x => x.MaximumDiscountAmount)
.HasColumnType("decimal(18,4)");
builder.Property(x => x.DiscountPercentage)
.HasColumnType("decimal(18,4)");
builder.HasIndex(x => x.Name)
.IsUnique();
builder.HasIndex(x => x.EndDate);
builder.HasIndex(x => x.StartDate);
builder.HasMany(x => x.Items)
.WithOne(x => x.Deal)
.OnDelete(DeleteBehavior.SetNull)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
});
modelBuilder.Entity <CouponCode>(builder =>
{
builder.HasIndex(x => x.Code);
builder.HasIndex(x => x.Username);
builder.Property(x => x.GeneratedAt)
.IsRequired();
builder.Property(x => x.Code)
.IsRequired();
builder.Property(x => x.CreatedBy)
.IsRequired();
});
modelBuilder.Entity <Review>(builder =>
{
builder.Property(x => x.StarRate)
.IsRequired();
builder.Property(x => x.UserPhoneNumber)
.IsRequired();
builder.Property(x => x.ItemId)
.IsRequired();
builder.Property(x => x.UserPhoneNumber)
.HasConversion(x => x.GetCompletePhoneNumber(),
p => PhoneNumberValue.Of(SupportedCountryCode.Italy, p));
}
);
modelBuilder.Entity <AddOn>(builder =>
{
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.Description)
.IsRequired();
builder.Property(p => p.Price)
.IsRequired()
.HasConversion(p => p.Value, p => MoneyValue.Of(p));
});
modelBuilder.Entity <OrderItem>(builder =>
{
builder.Property(x => x.Quantity)
.IsRequired();
builder.Property(x => x.FoodId)
.IsRequired();
builder.Property(x => x.FoodName)
.IsRequired();
builder.Property(p => p.Total)
.IsRequired()
.HasColumnType("decimal(18,4)");
builder.Property(p => p.Discount)
.HasColumnType("decimal(18,4)");
});
modelBuilder.Entity <PricingPolicy>(x =>
{
x.Property(p => p.MinimumCharge)
.IsRequired()
.HasColumnType("decimal(18,4)");
x.Property(p => p.MaximumCharge)
.HasColumnType("decimal(18,4)");
x.Property(p => p.FixedCharge).IsRequired()
.HasColumnType("decimal(18,4)");
x.Property(p => p.AdditionalPrice)
.HasColumnType("decimal(18,4)");
});
modelBuilder.Entity <Tag>(builder =>
{
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.NameEng)
.IsRequired();
});
modelBuilder.Entity <FoodTag>(builder =>
{
builder.HasKey(x => new { x.FoodId, x.TagId });
builder.HasOne(x => x.Food)
.WithMany(f => f.Tags)
.HasForeignKey(x => x.FoodId);
builder.HasOne(x => x.Tag)
.WithMany(f => f.Foods)
.HasForeignKey(x => x.TagId);
});
modelBuilder.Entity <Category>(builder =>
{
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.NameEng)
.IsRequired();
builder.Property(x => x.ImageUrl)
.IsRequired();
builder.Property(x => x.Categorize)
.IsRequired()
.HasConversion <string>();
builder.HasIndex(x => x.Name).IsUnique();
builder.HasIndex(x => x.NameEng).IsUnique();
builder.HasMany(x => x.Foods)
.WithOne(x => x.Category)
.OnDelete(DeleteBehavior.SetNull)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
});
modelBuilder.Entity <Cuisine>(builder =>
{
builder.Property(x => x.Name)
.IsRequired();
builder.Property(x => x.NameEng)
.IsRequired();
builder.Property(x => x.ImageUrl)
.IsRequired();
builder.HasIndex(x => x.Name).IsUnique();
builder.HasIndex(x => x.NameEng).IsUnique();
builder.HasMany(x => x.Foods)
.WithOne(x => x.Cuisine)
.OnDelete(DeleteBehavior.SetNull)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
});
modelBuilder.Entity <RestaurantCategory>(builder =>
{
builder.HasKey(x => new { x.RestaurantId, x.CategoryId });
builder.HasOne(x => x.Category)
.WithMany(x => x.Restaurants)
.HasForeignKey(x => x.CategoryId)
.OnDelete(DeleteBehavior.Cascade)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
builder.HasOne(x => x.Restaurant)
.WithMany(x => x.Categories)
.HasForeignKey(x => x.RestaurantId)
.OnDelete(DeleteBehavior.Cascade)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
});
modelBuilder.Entity <RestaurantCuisine>(builder =>
{
builder.HasKey(x => new { x.RestaurantId, x.CuisineId });
builder.HasOne(x => x.Cuisine)
.WithMany(x => x.Restaurants)
.HasForeignKey(x => x.CuisineId)
.OnDelete(DeleteBehavior.Cascade)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
builder.HasOne(x => x.Restaurant)
.WithMany(x => x.Cuisines)
.HasForeignKey(x => x.RestaurantId)
.OnDelete(DeleteBehavior.Cascade)
.Metadata.PrincipalToDependent.SetPropertyAccessMode(PropertyAccessMode.Field);
});
base.OnModelCreating(modelBuilder);
}