public GetCustomerCartQueryHandler(
ICleanersNextDoorContext context,
IMapper mapper
)
{
_context = context;
_mapper = mapper;
}
public RemoveCartItemCommandHandler(
ICleanersNextDoorContext context,
IMapper mapper
)
{
_context = context;
_mapper = mapper;
}
public GetMerchantQueryHandler(
ICleanersNextDoorContext context,
IMapper mapper
)
{
_context = context;
_mapper = mapper;
}
public GetUserByUsernameQueryHandler(
ICleanersNextDoorContext context,
IMapper mapper
)
{
_context = context;
_mapper = mapper;
}
public CreateCustomerCommandHandler(
ICleanersNextDoorContext context,
IMapper mapper
)
{
_context = context;
_mapper = mapper;
}
public CreateUserCommandValidator(ICleanersNextDoorContext context)
{
_context = context;
RuleFor(v => v.User.Username)
.MaximumLength(50)
.NotEmpty()
.MustAsync(BeUniqueUsername)
.WithMessage("The specified username already exists.");
}
public CreateCartItemCommandValidator(ICleanersNextDoorContext context)
{
_context = context;
RuleFor(v => v.ItemID)
.NotEmpty()
.MustAsync(BeValidItem)
.WithMessage("The item does not exist or is not active.");
RuleFor(l => l.ItemID).MustAsync(BeLessThanOrEqualToMaxAllowed)
.WithMessage("Cannot exceed the maximum allowed for this item.");
}
public static void Initialize(ICleanersNextDoorContext context)
{
if (!context.EnsureCreated())
{
return; //db was already created or error occurred
}
//add merchant types
var merchantType = new MerchantType
{
Name = "Cleaner",
Description = "Cleaner Services",
Active = true,
CreatedAt = DateTime.Now
};
context.MerchantTypes.Add(merchantType);
context.SaveChanges();
//add test merchants
var merchants = new List <Merchant>
{
new Merchant
{
MerchantTypeID = merchantType.ID,
Name = "Five Star Cleaners",
Description = "Founded in 1987 by the Hernandez brothers, our establishment has been serving up rich coffee sourced from artisan farmers in various regions of South and Central America. We are dedicated to travelling the world, finding the best coffee, and bringing back to you here in our cafe.",
Street1 = "3481 Melrose Place",
City = "Beverly Hills",
StateAbbreviation = "CA",
Zip = "90210",
Phone = "(123) 456-7890",
ContactEmail = "*****@*****.**",
OperatingHours = "Monday - Friday: 9:00 AM to 5:00 PM",
WebsiteUrl = "robsmitha.com",
CallToAction = "Once you try it, our coffee will be a blissful addition to your everyday morning routine - we guarantee it!",
ShortDescription = "Every cup of our quality artisan coffee starts with locally sourced, hand picked ingredients.",
},
new Merchant
{
MerchantTypeID = merchantType.ID,
Name = "Second Base Cleaners",
Description = "Founded in 1987 by the Hernandez brothers, our establishment has been serving up rich coffee sourced from artisan farmers in various regions of South and Central America. We are dedicated to travelling the world, finding the best coffee, and bringing back to you here in our cafe.",
Street1 = "3481 Melrose Place",
City = "Beverly Hills",
StateAbbreviation = "CA",
Zip = "90210",
Phone = "(123) 456-7890",
ContactEmail = "*****@*****.**",
OperatingHours = "Monday - Friday: 9:00 AM to 5:00 PM",
WebsiteUrl = "robsmitha.com",
CallToAction = "Once you try it, our coffee will be a blissful addition to your everyday morning routine - we guarantee it!",
ShortDescription = "Every cup of our quality artisan coffee starts with locally sourced, hand picked ingredients.",
},
new Merchant
{
MerchantTypeID = merchantType.ID,
Name = "Third Time's the Charm Cleaners",
Description = "Founded in 1987 by the Hernandez brothers, our establishment has been serving up rich coffee sourced from artisan farmers in various regions of South and Central America. We are dedicated to travelling the world, finding the best coffee, and bringing back to you here in our cafe.",
Street1 = "3481 Melrose Place",
City = "Beverly Hills",
StateAbbreviation = "CA",
Zip = "90210",
Phone = "(123) 456-7890",
ContactEmail = "*****@*****.**",
OperatingHours = "Monday - Friday: 9:00 AM to 5:00 PM",
WebsiteUrl = "robsmitha.com",
CallToAction = "Once you try it, our coffee will be a blissful addition to your everyday morning routine - we guarantee it!",
ShortDescription = "Every cup of our quality artisan coffee starts with locally sourced, hand picked ingredients.",
},
new Merchant
{
MerchantTypeID = merchantType.ID,
Name = "Forty Oz Cleaners",
Description = "Founded in 1987 by the Hernandez brothers, our establishment has been serving up rich coffee sourced from artisan farmers in various regions of South and Central America. We are dedicated to travelling the world, finding the best coffee, and bringing back to you here in our cafe.",
Street1 = "3481 Melrose Place",
City = "Beverly Hills",
StateAbbreviation = "CA",
Zip = "90210",
Phone = "(123) 456-7890",
ContactEmail = "*****@*****.**",
OperatingHours = "Monday - Friday: 9:00 AM to 5:00 PM",
WebsiteUrl = "robsmitha.com",
CallToAction = "Once you try it, our coffee will be a blissful addition to your everyday morning routine - we guarantee it!",
ShortDescription = "Every cup of our quality artisan coffee starts with locally sourced, hand picked ingredients.",
},
};
context.Merchants.AddRange(merchants);
context.SaveChanges();
//add price type
var priceTypes = new List <PriceType>
{
new PriceType
{
Name = "Fixed",
Description = "Fixed Price",
CreatedAt = DateTime.UtcNow,
Active = true,
},
new PriceType
{
Name = "Variable",
Description = "Variable Cost Price",
CreatedAt = DateTime.UtcNow,
Active = true,
}
};
context.PriceTypes.AddRange(priceTypes);
//add item types
var itemTypes = new List <ItemType>
{
new ItemType
{
Active = true,
CreatedAt = DateTime.Now,
Name = "Laundry",
Description = "Laundry Services"
},
new ItemType
{
Active = true,
CreatedAt = DateTime.Now,
Name = "Suit",
Description = "Suit Services"
},
new ItemType
{
Active = true,
CreatedAt = DateTime.Now,
Name = "Dress",
Description = "Dress Services"
},
new ItemType
{
Active = true,
CreatedAt = DateTime.Now,
Name = "Alteration",
Description = "Alteration Services"
},
new ItemType
{
Active = true,
CreatedAt = DateTime.Now,
Name = "Fee",
Description = "Service Fee"
},
};
context.ItemTypes.AddRange(itemTypes);
//add card types
var cardTypes = new List <CardType>
{
new CardType
{
Active = true,
CreatedAt = DateTime.Now,
Name = "Visa",
Description = "Visa Card"
},
new CardType
{
Active = true,
CreatedAt = DateTime.Now,
Name = "America Express",
Description = "America Express"
},
};
context.CardTypes.AddRange(cardTypes);
//unit types
var unitTypes = new List <UnitType>
{
new UnitType
{
Name = "Quantity",
Description = "Unit is measured in quantities",
CreatedAt = DateTime.UtcNow,
Active = true,
}
};
context.UnitTypes.AddRange(unitTypes);
var owner = new Role
{
Name = "Owner",
Description = "Owner of the associated merchant",
CreatedAt = DateTime.UtcNow,
Active = true,
};
var onlineSignUp = new Role
{
Name = "Online User",
Description = "Online Sign up user",
CreatedAt = DateTime.UtcNow,
Active = true,
};
var roles = new List <Role>
{
owner,
onlineSignUp
};
context.Roles.AddRange(roles);
var orderStatusTypes = new List <OrderStatusType>
{
new OrderStatusType
{
Name = "Open",
Description = "Order needs to be paid for",
CreatedAt = DateTime.UtcNow,
Active = true,
},
new OrderStatusType
{
Name = "Paid",
Description = "Order has been paid for",
CreatedAt = DateTime.UtcNow,
Active = true,
},
new OrderStatusType
{
Name = "Partially Paid",
Description = "Order has been partially paid for",
CreatedAt = DateTime.UtcNow,
Active = true,
}
};
context.OrderStatusTypes.AddRange(orderStatusTypes);
var paymentStatusTypes = new List <PaymentStatusType>
{
new PaymentStatusType
{
Name = "Pending",
Description = "Payment is pending",
CreatedAt = DateTime.UtcNow,
Active = true,
},
new PaymentStatusType
{
Name = "Paid",
Description = "Payment is paid for",
CreatedAt = DateTime.UtcNow,
Active = true,
},
};
context.PaymentStatusTypes.AddRange(paymentStatusTypes);
var paymentTypes = new List <PaymentType>
{
new PaymentType
{
Name = "Credit Card Manual",
Description = "Credit Card Manually Entered",
CreatedAt = DateTime.UtcNow,
Active = true,
},
new PaymentType
{
Name = "Cash",
Description = "Cash",
CreatedAt = DateTime.UtcNow,
Active = true,
},
new PaymentType
{
Name = "Check",
Description = "Check",
CreatedAt = DateTime.UtcNow,
Active = true,
},
};
context.PaymentTypes.AddRange(paymentTypes);
context.SaveChanges();
var items = new List <Item>();
foreach (var merchant in merchants)
{
items.Add(new Item
{
ItemTypeID = itemTypes.Single(t => t.Name == "Laundry").ID,
MerchantID = merchant.ID,
Cost = 0,
Price = 1.99M,
PriceTypeID = priceTypes.First().ID,
UnitTypeID = unitTypes.First().ID,
Name = "Laundry item",
Description = "A single laundry item. Lorem ipsum dolor sit amet, consectetur adipisicing elit.",
MaxAllowed = 10
});
items.Add(new Item
{
ItemTypeID = itemTypes.Single(t => t.Name == "Alteration").ID,
MerchantID = merchant.ID,
Cost = 0,
Price = 5.99M,
PriceTypeID = priceTypes.First().ID,
UnitTypeID = unitTypes.First().ID,
Name = "Clothing Alteration",
Description = "Alteration services. Lorem ipsum dolor sit amet, consectetur adipisicing elit.",
MaxAllowed = 7
});
items.Add(new Item
{
ItemTypeID = itemTypes.Single(t => t.Name == "Dress").ID,
MerchantID = merchant.ID,
Cost = 0,
Price = 4.99M,
PriceTypeID = priceTypes.First().ID,
UnitTypeID = unitTypes.First().ID,
Name = "Dress Cleaning",
Description = "Dress cleaning services. Lorem ipsum dolor sit amet, consectetur adipisicing elit.",
MaxAllowed = 5
});
items.Add(new Item
{
ItemTypeID = itemTypes.Single(t => t.Name == "Suit").ID,
MerchantID = merchant.ID,
Cost = 0,
Price = 4.99M,
PriceTypeID = priceTypes.First().ID,
UnitTypeID = unitTypes.First().ID,
Name = "Suit & Jacket Cleaning",
Description = "Suit & Jacket Cleaning services. Lorem ipsum dolor sit amet, consectetur adipisicing elit.",
MaxAllowed = 5
});
}
context.Items.AddRange(items);
context.SaveChanges();
}