private async Task SeedCustomerAndAppliances()
{
if (!_tmContext.CustomerApplianceTypes.Any())
{
var customerApplianceType1 = new CustomerApplianceType()
{
Name = "Air Conditioner",
Sequence = 1,
CreatedBy = "SYSTEM",
DateCreated = DateTime.UtcNow,
CustomerApplianceBrands = new List <CustomerApplianceBrand>()
{
new CustomerApplianceBrand()
{
Name = "American Standard", Sequence = 1, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Carrier", Sequence = 2, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Crosley", Sequence = 3, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Danby", Sequence = 4, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Delonghi", Sequence = 5, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Modern-Aire", Sequence = 6, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Sterling", Sequence = 7, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Tappan", Sequence = 8, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Other", Sequence = 999, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
}
}
};
_tmContext.CustomerApplianceTypes.Add(customerApplianceType1);
_tmContext.CustomerApplianceBrands.AddRange(customerApplianceType1.CustomerApplianceBrands);
var customerApplianceType2 = new CustomerApplianceType()
{
Name = "BBQ",
Sequence = 2,
CreatedBy = "SYSTEM",
DateCreated = DateTime.UtcNow,
CustomerApplianceBrands = new List <CustomerApplianceBrand>()
{
new CustomerApplianceBrand()
{
Name = "Bertazzoni", Sequence = 1, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Bosh", Sequence = 2, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Brown", Sequence = 3, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Chambers", Sequence = 4, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Dacor", Sequence = 5, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Danby", Sequence = 6, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Delonghi", Sequence = 7, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Dynasty", Sequence = 8, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Dynasty", Sequence = 9, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Frigidaire", Sequence = 10, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "KitchenAid", Sequence = 11, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Samsung", Sequence = 12, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Viking", Sequence = 13, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Wold", Sequence = 14, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Zephyr", Sequence = 15, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Other", Sequence = 999, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
}
}
};
_tmContext.CustomerApplianceTypes.Add(customerApplianceType2);
_tmContext.CustomerApplianceBrands.AddRange(customerApplianceType2.CustomerApplianceBrands);
var customerApplianceType3 = new CustomerApplianceType()
{
Name = "Cooktop",
Sequence = 3,
CreatedBy = "SYSTEM",
DateCreated = DateTime.UtcNow,
CustomerApplianceBrands = new List <CustomerApplianceBrand>()
{
new CustomerApplianceBrand()
{
Name = "Avanti", Sequence = 1, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Bertazzoni", Sequence = 2, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Bosch", Sequence = 3, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Brown", Sequence = 4, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Caloric", Sequence = 5, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Chambers", Sequence = 6, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Dacor", Sequence = 7, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "DCS", Sequence = 8, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Delonghi", Sequence = 9, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Dynasty", Sequence = 10, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Electrolux", Sequence = 11, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Frigidaire", Sequence = 12, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "KitchenAid", Sequence = 13, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Samsung", Sequence = 14, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Viking", Sequence = 15, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Wold", Sequence = 16, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Zephyr", Sequence = 17, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
},
new CustomerApplianceBrand()
{
Name = "Other", Sequence = 999, CreatedBy = "SYSTEM", DateCreated = DateTime.UtcNow
}
}
};
_tmContext.CustomerApplianceTypes.Add(customerApplianceType3);
_tmContext.CustomerApplianceBrands.AddRange(customerApplianceType3.CustomerApplianceBrands);
await _tmContext.SaveChangesAsync();
}
if (!_tmContext.Customers.Any())
{
var tcustomer = new Customer()
{
DateCreated = DateTime.UtcNow,
FirstName = "Timur",
LastName = "Alayev",
Email = "*****@*****.**",
PhoneNumber = "7145293374",
CreatedBy = "*****@*****.**",
City = "La Habra",
PostalCode = "92788",
State = "CA",
Address = "1241 Robin Way",
CustomerApplianceProblems = new List <CustomerApplianceProblem>()
{
new CustomerApplianceProblem()
{
CustomerApplianceTypeId = 1,
CustomerApplianceBrandId = 1,
DateCreated = DateTime.UtcNow,
Problem = "Gas leaking",
ModelNumber = "123123123SDfR",
ModelSerial = "sdfsldkjfSDF",
CreatedBy = "SYSTEM",
DesiredScheduleTime = DateTime.UtcNow.AddDays(1),
ProblemStatus = "NEW"
},
new CustomerApplianceProblem()
{
CustomerApplianceTypeId = 2,
CustomerApplianceBrandId = 3,
DateCreated = DateTime.UtcNow,
Problem = "Water leaking",
ModelNumber = "2344422333123SDfR",
ModelSerial = "aaasddffSDF",
CreatedBy = "SYSTEM",
DesiredScheduleTime = DateTime.UtcNow.AddDays(1),
ProblemStatus = "NEW"
},
new CustomerApplianceProblem()
{
CustomerApplianceTypeId = 3,
CustomerApplianceBrandId = 2,
DateCreated = DateTime.UtcNow,
Problem = "Stop working",
ModelNumber = "12asd3123SDfR",
ModelSerial = "ddddddaaakjfSDF",
CreatedBy = "SYSTEM",
DesiredScheduleTime = DateTime.UtcNow.AddDays(1),
ProblemStatus = "NEW"
}
}
};
_tmContext.Customers.Add(tcustomer);
_tmContext.CustomerApplianceProblems.AddRange(tcustomer.CustomerApplianceProblems);
var acustomer = new Customer()
{
DateCreated = DateTime.UtcNow,
FirstName = "Andrey",
LastName = "GoodEvening",
Email = "*****@*****.**",
PhoneNumber = "7143453374",
CreatedBy = "*****@*****.**",
City = "Garden Grove",
PostalCode = "93744",
State = "CA",
Address = "14455 Yankee Way",
CustomerApplianceProblems = new List <CustomerApplianceProblem>()
{
new CustomerApplianceProblem()
{
CustomerApplianceTypeId = 1,
CustomerApplianceBrandId = 1,
DateCreated = DateTime.UtcNow,
Problem = "Terrible noise",
ModelNumber = "123123123SDfR",
ModelSerial = "sdfsldkjfSDF",
CreatedBy = "SYSTEM",
DesiredScheduleTime = DateTime.UtcNow.AddDays(1),
ProblemStatus = "APPROVED"
},
new CustomerApplianceProblem()
{
CustomerApplianceTypeId = 2,
CustomerApplianceBrandId = 3,
DateCreated = DateTime.UtcNow,
Problem = "No idea, need you to check",
ModelNumber = "2344422333123SDfR",
ModelSerial = "aaasddffSDF",
CreatedBy = "SYSTEM",
DesiredScheduleTime = DateTime.UtcNow.AddDays(1),
ProblemStatus = "APPROVED"
},
new CustomerApplianceProblem()
{
CustomerApplianceTypeId = 3,
CustomerApplianceBrandId = 2,
DateCreated = DateTime.UtcNow,
Problem = "Need to replace filter",
ModelNumber = "12asd3123SDfR",
ModelSerial = "ddddddaaakjfSDF",
CreatedBy = "SYSTEM",
DesiredScheduleTime = DateTime.UtcNow.AddDays(1),
ProblemStatus = "CANCELLED"
}
}
};
_tmContext.Customers.Add(acustomer);
_tmContext.CustomerApplianceProblems.AddRange(acustomer.CustomerApplianceProblems);
var bcustomer = new Customer()
{
DateCreated = DateTime.UtcNow,
FirstName = "Michael",
LastName = "Smith",
Email = "*****@*****.**",
PhoneNumber = "7145223374",
CreatedBy = "*****@*****.**",
City = "Fullerton",
PostalCode = "92783",
State = "CA",
Address = "2344 Russki Way",
CustomerApplianceProblems = new List <CustomerApplianceProblem>()
{
new CustomerApplianceProblem()
{
CustomerApplianceTypeId = 1,
CustomerApplianceBrandId = 1,
DateCreated = DateTime.UtcNow,
Problem = "Terrible noise",
ModelNumber = "asdg23SDfR",
ModelSerial = "AAAAAfSDF",
CreatedBy = "SYSTEM",
DesiredScheduleTime = DateTime.UtcNow.AddDays(1),
ProblemStatus = "NEW"
},
new CustomerApplianceProblem()
{
CustomerApplianceTypeId = 2,
CustomerApplianceBrandId = 3,
DateCreated = DateTime.UtcNow,
Problem = "Water leaking",
ModelNumber = "RRRRRRR123SDfR",
ModelSerial = "EEEEEEEdffSDF",
CreatedBy = "SYSTEM",
DesiredScheduleTime = DateTime.UtcNow.AddDays(3),
ProblemStatus = "NEW"
},
new CustomerApplianceProblem()
{
CustomerApplianceTypeId = 3,
CustomerApplianceBrandId = 2,
DateCreated = DateTime.UtcNow,
Problem = "Shaking",
ModelNumber = "EERRTTYYYY3SDfR",
ModelSerial = "WERRTYakjfSDF",
DesiredScheduleTime = DateTime.UtcNow.AddDays(2),
ProblemStatus = "NEW"
}
}
};
_tmContext.Customers.Add(bcustomer);
_tmContext.CustomerApplianceProblems.AddRange(bcustomer.CustomerApplianceProblems);
var customerCoupons = new List <CustomerCoupon>()
{
new CustomerCoupon()
{
Name = "5% OFF LABOR",
Description = "On repair, service and installation.Please visit our site for new coupons.",
ExpirationDate = DateTime.UtcNow.AddDays(30),
Sequence = 1
},
new CustomerCoupon()
{
Name = "SENIOR DISCOUNT 10%",
Description = "On repair, service and installation.Please visit our site for new coupons.",
ExpirationDate = DateTime.UtcNow.AddDays(120),
Sequence = 2
},
new CustomerCoupon()
{
Name = "5% OFF VISIT",
Description = "On repair, service and installation.Please visit our site for new coupons.",
ExpirationDate = DateTime.UtcNow.AddDays(30),
Sequence = 3
},
new CustomerCoupon()
{
Name = "5% DISCOUNT FOR PARTS",
Description = "On repair, service and installation.Please visit our site for new coupons.",
ExpirationDate = DateTime.UtcNow.AddDays(120),
Sequence = 4
}
};
_tmContext.CustomerCoupons.AddRange(customerCoupons);
await _tmContext.SaveChangesAsync();
}
}
public void Update(CustomerApplianceType newCustomerApplianceType)
{
_context.Update(newCustomerApplianceType);
}
public void Remove(CustomerApplianceType newCustomerApplianceType)
{
_context.Remove(newCustomerApplianceType);
}
public void Add(CustomerApplianceType newCustomerApplianceType)
{
_context.Add(newCustomerApplianceType);
}
