public async Task <IActionResult> Edit(int id, [Bind("FoundationsId,LessonName")] Foundations foundations) { if (id != foundations.FoundationsId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(foundations); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FoundationsExists(foundations.FoundationsId)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(foundations)); }
public async Task <IActionResult> Create([Bind("FoundationsId,LessonName")] Foundations foundations) { if (ModelState.IsValid) { _context.Add(foundations); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(foundations)); }
private static void Main(string[] args) { Command command = new Command { SqlStatementId = "SELECT_FOUNDATION_INFO" }; DataAccess access = new DataAccess(); List <Foundations> foundationInfo = new List <Foundations>(); using (MySqlDataReader reader = access.GetReader(command)) { while (reader.Read()) { if (!reader.IsDBNull(0)) { Foundations foundations = new Foundations { FoundationId = reader.IsDBNull(0) ? -1 : reader.GetInt32(0), FoundationName = reader.GetString(1), ScholarshipValue = reader.IsDBNull(2) ? "False" : reader.GetString(2) }; foundationInfo.Add(foundations); } } } List <int> foundationIds = foundationInfo.Select(f => f.FoundationId).ToList(); List <Foundations> contactFoundations = new List <Foundations>(); foreach (var id in foundationIds) { ParameterSet parameters = new ParameterSet(); parameters.Add(DbType.Int32, "FOUNDATION_ID", id); command = new Command { SqlStatementId = "SELECT_FOUNDATION_CONTACT_EMAIL", ParameterCollection = parameters }; List <string> contactEmails = new List <string>(); using (MySqlDataReader reader = access.GetReader(command)) { while (reader.Read()) { if (!reader.IsDBNull(0)) { contactEmails.Add(reader.GetString(0)); } } } Foundations foundation = foundationInfo.First(f => f.FoundationId == id); foundation.Contacts = new List <string>(); foreach (var contact in contactEmails) { foundation.Contacts.Add(contact); } contactFoundations.Add(foundation); } var fullPathToMasterExcel = args[0]; var connString = string.Format( "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0';", fullPathToMasterExcel); DataTable newTable = ExcelReadWrite.ExcelReadWrite.GetDataTable("SELECT * from [To Chris March$]", connString); newTable.TableName = "To Chris March"; newTable.Columns.Add("Scholarship"); foreach (DataRow line in newTable.Rows) { if (line[0].ToString() != "") { continue; } List <Foundations> foundFoundations = contactFoundations.Where(f => f.FoundationName.ToLower() == line[2].ToString().ToLower()).ToList(); if (foundFoundations.Count() == 1) { line[0] = foundFoundations.First().FoundationId; line[10] = foundFoundations.First().ScholarshipValue; } else if (foundFoundations.Count > 1) { List <Foundations> nonScholarshipfoundFoundations = foundFoundations.Where(f => f.ScholarshipValue != "True").ToList(); if (nonScholarshipfoundFoundations.Count() == 1) { line[0] = nonScholarshipfoundFoundations.First().FoundationId; line[10] = nonScholarshipfoundFoundations.First().ScholarshipValue; } else if (nonScholarshipfoundFoundations.Any()) { nonScholarshipfoundFoundations = nonScholarshipfoundFoundations .Where(f => f.Contacts.Contains(line[6].ToString())) .ToList(); if (nonScholarshipfoundFoundations.Count == 1) { line[0] = nonScholarshipfoundFoundations.First().FoundationId; line[10] = nonScholarshipfoundFoundations.First().ScholarshipValue; } } else { foundFoundations = foundFoundations .Where(f => f.Contacts.Contains(line[6].ToString())) .ToList(); if (foundFoundations.Count >= 1) { line[0] = nonScholarshipfoundFoundations.First().FoundationId; line[10] = nonScholarshipfoundFoundations.First().ScholarshipValue; } } } else { List <Foundations> contactfoundFoundations = contactFoundations .Where(f => f.Contacts.Contains(line[6].ToString())) .ToList(); if (contactfoundFoundations.Count == 1) { line[0] = contactfoundFoundations.First().FoundationId; line[10] = contactfoundFoundations.First().ScholarshipValue; } else { List <Foundations> contactNonScholarshipfoundFoundations = contactfoundFoundations .Where(f => f.ScholarshipValue != "True") .ToList(); if (contactNonScholarshipfoundFoundations.Count == 1) { line[0] = contactfoundFoundations.First().FoundationId; line[10] = contactfoundFoundations.First().ScholarshipValue; } } } } List <DataTable> tableList = new List <DataTable>(); tableList.Add(newTable); WriteExcelFile(tableList, args[0]); }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new ApplicationDbContext(serviceProvider.GetRequiredService <DbContextOptions <ApplicationDbContext> >())) { var userstore = new UserStore <ApplicationUser>(context); if (!context.ApplicationUser.Any(u => u.FirstName == "admin")) { // This method will be called after migrating to the latest version. ApplicationUser user = new ApplicationUser { FirstName = "admin", LastName = "admin", StreetAddress = "123 Infinity Way", UserName = "******", NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**", EmailConfirmed = true, LockoutEnabled = false, SecurityStamp = Guid.NewGuid().ToString("D") }; var passwordHash = new PasswordHasher <ApplicationUser>(); user.PasswordHash = passwordHash.HashPassword(user, "Admin8*"); } // Seed Data for Foundations. if (context.Foundations.Any()) { return; // DB has been seeded } var foundations = new Foundations_2[] { new Foundations_2 { LessonName = "Fretboard", Images = new List <string>() { "/images/1-Foundations/Fretboard/Natural_Notes_B&W.png", "/images/1-Foundations/Fretboard/Natural_Notes_Colored.png", "/images/1-Foundations/Fretboard/Natural_Notes_Horizontal.png", "/images/1-Foundations/Fretboard/TwoCharts_Vertical.jpg" } }, new Foundations_2 { LessonName = "KeySignatures", Images = new List <string>() { "/images/1-Foundations/KeySignatures/key_signature_chart.png", "/images/1-Foundations/KeySignatures/key_signatures_notation.png", "/images/1-Foundations/KeySignatures/key_signatures_staff.png" } }, new Foundations_2 { LessonName = "MajorMinorScales", Images = new List <string>() { "/images/1-Foundations/MajorMinorScales/C_ScaleOnOneString.png", "/images/1-Foundations/MajorMinorScales/C_ScaleWithOpenStrings.png", "/images/1-Foundations/MajorMinorScales/C_ScaleWithNotation.png", "/images/1-Foundations/MajorMinorScales/MajorScalePattern.png", "/images/1-Foundations/MajorMinorScales/RelativeMinor_C.png", "/images/1-Foundations/MajorMinorScales/A_MinorScaleOpenStrings.jpeg", "/images/1-Foundations/MajorMinorScales/GMajorPattern.png", "/images/1-Foundations/MajorMinorScales/G_MinorScale.png", "/images/1-Foundations/MajorMinorScales/E_MinorScaleOpenStrings.png", "/images/1-Foundations/MajorMinorScales/C_MinorYellowDiagram.png" } }, new Foundations_2 { LessonName = "ChordBuilding", Images = new List <string>() { "/images/1-Foundations/ChordBuilding/10_C_Chord_Formulas.jpg", "/images/1-Foundations/ChordBuilding/C_MinorTriadDiagram.png", "/images/1-Foundations/ChordBuilding/Chord_Building_In_7_Keys.jpg", "/images/1-Foundations/ChordBuilding/ChordBuildingOn_C_Scale.gif", "/images/1-Foundations/ChordBuilding/ChordFormulas.jpg", "/images/1-Foundations/ChordBuilding/ConsumateChordBuilder_Diagram.jpg", "/images/1-Foundations/ChordBuilding/Triad_Formulas.png" } }, new Foundations_2 { LessonName = "Modes", Images = new List <string>() { "/images/1-Foundations/Modes/Ionian.jpg", "/images/1-Foundations/Modes/Dorian.jpg", "/images/1-Foundations/Modes/Phrygian.jpg", "/images/1-Foundations/Modes/Lydian.jpg", "/images/1-Foundations/Modes/Mixolydian.jpg", "/images/1-Foundations/Modes/Aeolian.jpg", "/images/1-Foundations/Modes/Locrian.jpg", "/images/1-Foundations/Modes/AllModes_Patterns.png", "/images/1-Foundations/Modes/Mode_Connecting_Lines.jpg" } }, new Foundations_2 { LessonName = "OtherScales", Images = new List <string>() { "/images/1-Foundations/OtherScales/5thFretPentatonicPattern.png", "/images/1-Foundations/OtherScales/A-Melodic-Minor-Scale.png", "/images/1-Foundations/OtherScales/Blues_Scale_Pattern.png", "/images/1-Foundations/OtherScales/C_HarmonicMinor.png", "/images/1-Foundations/OtherScales/C_MinorBebopAscendDescend.png" } } }; int foundationsLessonId = 1; foreach (Foundations_2 i in foundations) { Foundations newFoundations = new Foundations() { LessonName = i.LessonName }; context.Add(newFoundations); Console.WriteLine("Testing XXXSXXXXXX"); foreach (string image in i.Images) { FoundationsImages newImg = new FoundationsImages() { Path = image, FoundationsId = foundationsLessonId }; context.Add(newImg); } foundationsLessonId++; } var intermediate = new Intermediate_2[] { new Intermediate_2 { LessonName = "Arpeggios", Images = new List <string>() { "/images/2-Intermediate/Arpeggios/CMinorMajor7-Arpeggio", "/images/2-Intermediate/Arpeggios/Gmajor7_1-2-4-5.png" } }, new Intermediate_2 { LessonName = "Caged", Images = new List <string>() { "/images/2-Intermediate/Caged/CAGED_Shape_Shift.png", "/images/2-Intermediate/Caged/CAGED_ColorCoded.png" } }, new Intermediate_2 { LessonName = "Major7_Apreggios", Images = new List <string>() { "/images/2-Intermediate/Major7_Apreggios/4_Note_Chords_KeyOfC.jpg.jpeg", "/images/2-Intermediate/Major7_Apreggios/All_Arpeggios_In_C_5Strings.jpeg", "/images/2-Intermediate/Major7_Apreggios/Key_Of_C_Arpeggios.png", "/images/2-Intermediate/Major7_Apreggios/Key_Of_C_Arpeggios_Same_Position.jpeg" } }, new Intermediate_2 { LessonName = "Pentatonic", Images = new List <string>() { "/images/2-Intermediate/Pentatonic/Pentatonic_Positions_Seperate_Diagrams.png", "/images/2-Intermediate/Pentatonic/Pentatonic_Color_Code_Positions.png", "/images/2-Intermediate/Pentatonic/DotDiagram_5_PositionPentatonic.png", "/images/2-Intermediate/Pentatonic/Color_Coded_Pent_Positions.jpeg", "/images/2-Intermediate/Pentatonic/5thPosition_E_Pentatonic.png", "/images/2-Intermediate/Pentatonic/E_Pentatonic_All_Positions.png", "/images/2-Intermediate/Pentatonic/Pentatonic_Ascend_Through_Positions_Line.png" } } }; int intermediateLessonId = 1; foreach (Intermediate_2 i in intermediate) { Intermediate newIntermediate = new Intermediate() { LessonName = i.LessonName }; context.Add(newIntermediate); foreach (string image in i.Images) { IntermediateImages newImg = new IntermediateImages() { Path = image, IntermediateId = intermediateLessonId }; context.Add(newImg); } intermediateLessonId++; } var advanced = new Advanced_2[] { new Advanced_2 { LessonName = "Altered_Chords", Images = new List <string>() { "/images/3-Advanced/Altered_Chords/2-5-1_Atlered5.png", "/images/3-Advanced/Altered_Chords/Altered_C7_chords.gif", "/images/3-Advanced/Altered_Chords/Altered_C7chords_6.gif.gif", "/images/3-Advanced/Altered_Chords/Altered_G7_chords.png.gif" } }, new Advanced_2 { LessonName = "Exercises_Practice", Images = new List <string>() { "/images/3-Advanced/Exercises_Practice/Am_Sweeps.png", "/images/3-Advanced/Exercises_Practice/Jazzy2_5_1.png", "/images/3-Advanced/Exercises_Practice/UpTwoDownOne_C_Scale.png" } }, new Advanced_2 { LessonName = "JazzMinor_Over_7chords", Images = new List <string>() { "/images/3-Advanced/JazzMinor_Over_7chords/2-5-1_Key_C.png", "/images/3-Advanced/JazzMinor_Over_7chords/2-5-1_KeyOfC.jpg", "/images/3-Advanced/JazzMinor_Over_7chords/DomG7_1-4-5.png", "/images/3-Advanced/JazzMinor_Over_7chords/Gdom7_jazzVoicing.png" } }, new Advanced_2 { LessonName = "Superimposition", Images = new List <string>() { "/images/3-Advanced/Superimposition/2-5-1_with_B_Over_D7.png", "/images/3-Advanced/Superimposition/Emin_Pentatonic_Over_Am7_Chord.png", "/images/3-Advanced/Superimposition/triad_superimposition_2-5-1.png", "/images/3-Advanced/Superimposition/Triad_Superimposition_B_Over_D7.png" } }, new Advanced_2 { LessonName = "UpperPartials", Images = new List <string>() { "/images/3-Advanced/UpperPartials/2_OctaveChartForUpperPartials.png", "/images/3-Advanced/UpperPartials/Chord_Extentions_Key_C.png" } } }; int advancedLessonId = 1; foreach (Advanced_2 i in advanced) { Advanced newAdvanced = new Advanced() { LessonName = i.LessonName }; context.Add(newAdvanced); foreach (string image in i.Images) { AdvancedImages newImg = new AdvancedImages() { Path = image, AdvancedId = advancedLessonId }; context.Add(newImg); } advancedLessonId++; } var resources = new Resources_2[] { new Resources_2 { ResourceType = "Templates", Images = new List <string>() { "/images/Resources/Templates/12_fret_template.png", "/images/Resources/Templates/15_fret_diagrams.pdf", "/images/Resources/Templates/16_fret_template.png", "/images/Resources/Templates/23_fret_template.jpg", "/images/Resources/Templates/chord_diagram_templates.png", "/images/Resources/Templates/fretboard_19frets.png" } } }; int resourcesTypeId = 1; foreach (Resources_2 i in resources) { Resources newResource = new Resources() { ResourceType = i.ResourceType }; context.Add(newResource); foreach (string image in i.Images) { ResourcesImages newImg = new ResourcesImages() { Path = image, ResourcesId = resourcesTypeId }; context.Add(newImg); } advancedLessonId++; } context.SaveChanges(); } }