// Initialize the data in the ConditionCodes table. // The set of condition codes came from: https://www.mycomicshop.com/help/grading // I chose the simplere basic grading scale. This is something I would normally discuss with the client. private static void InitializeConditionCodes(SidekickContext context) { if (!context.ConditionCodes.Any()) { var conditionCodes = new ConditionCode[] { new ConditionCode { Name = "NM Near Mint" }, new ConditionCode { Name = "VF Very Fine" }, new ConditionCode { Name = "FN Fine" }, new ConditionCode { Name = "VG Very Good" }, new ConditionCode { Name = "GD Good" }, new ConditionCode { Name = "FR Fair" }, new ConditionCode { Name = "PR Poor" } }; foreach (ConditionCode conditionCode in conditionCodes) { context.ConditionCodes.Add(conditionCode); } context.SaveChanges(); } }
// Initialize the data in the StateCodes table. // The set of state codes came from: https://abbreviations.yourdictionary.com/articles/state-abbrev.html private static void InitializeStateCodes(SidekickContext context) { if (!context.StateCode.Any()) { var stateCodes = new StateCode[] { new StateCode { Abbreviation = "AL", Name = "Alabama" }, new StateCode { Abbreviation = "AK", Name = "Alaska" }, new StateCode { Abbreviation = "AZ", Name = "Arizona" }, new StateCode { Abbreviation = "AR", Name = "Arkansas" }, new StateCode { Abbreviation = "CA", Name = "California" }, new StateCode { Abbreviation = "CO", Name = "Colorado" }, new StateCode { Abbreviation = "CT", Name = "Connecticut" }, new StateCode { Abbreviation = "DE", Name = "Delaware" }, new StateCode { Abbreviation = "FL", Name = "Florida" }, new StateCode { Abbreviation = "GA", Name = "Georgia" }, new StateCode { Abbreviation = "HI", Name = "Hawaii" }, new StateCode { Abbreviation = "ID", Name = "Idaho" }, new StateCode { Abbreviation = "IL", Name = "Illinois" }, new StateCode { Abbreviation = "IN", Name = "Indiana" }, new StateCode { Abbreviation = "IA", Name = "Iowa" }, new StateCode { Abbreviation = "KS", Name = "Kansas" }, new StateCode { Abbreviation = "KY", Name = "Kentucky" }, new StateCode { Abbreviation = "LA", Name = "Louisiana" }, new StateCode { Abbreviation = "ME", Name = "Maine" }, new StateCode { Abbreviation = "MD", Name = "Maryland" }, new StateCode { Abbreviation = "MA", Name = "Massachusetts" }, new StateCode { Abbreviation = "MI", Name = "Michigan" }, new StateCode { Abbreviation = "MN", Name = "Minnesota" }, new StateCode { Abbreviation = "MS", Name = "Mississippi" }, new StateCode { Abbreviation = "MO", Name = "Missouri" }, new StateCode { Abbreviation = "MT", Name = "Montana" }, new StateCode { Abbreviation = "NE", Name = "Nebraska" }, new StateCode { Abbreviation = "NV", Name = "Nevada" }, new StateCode { Abbreviation = "NH", Name = "New Hampshire" }, new StateCode { Abbreviation = "NJ", Name = "New Jersey" }, new StateCode { Abbreviation = "NM", Name = "New Mexico" }, new StateCode { Abbreviation = "NY", Name = "New York" }, new StateCode { Abbreviation = "NC", Name = "North Carolina" }, new StateCode { Abbreviation = "ND", Name = "North Dakota" }, new StateCode { Abbreviation = "OH", Name = "Ohio" }, new StateCode { Abbreviation = "OK", Name = "Oklahoma" }, new StateCode { Abbreviation = "OR", Name = "Oregon" }, new StateCode { Abbreviation = "PA", Name = "Pennsylvania" }, new StateCode { Abbreviation = "RI", Name = "Rhode Island" }, new StateCode { Abbreviation = "SC", Name = "South Carolina" }, new StateCode { Abbreviation = "SD", Name = "South Dakota" }, new StateCode { Abbreviation = "TN", Name = "Tennessee" }, new StateCode { Abbreviation = "TX", Name = "Texas" }, new StateCode { Abbreviation = "UT", Name = "Utah" }, new StateCode { Abbreviation = "VT", Name = "Vermont" }, new StateCode { Abbreviation = "VA", Name = "Virginia" }, new StateCode { Abbreviation = "WA", Name = "Washington" }, new StateCode { Abbreviation = "WV", Name = "West Virginia" }, new StateCode { Abbreviation = "WI", Name = "Wisconsin" }, new StateCode { Abbreviation = "WY", Name = "Wyoming" } }; foreach (StateCode stateCode in stateCodes) { context.StateCode.Add(stateCode); } context.SaveChanges(); } }