public ActionResult Add(FormCollection frm) { BandDataLayer objBandDataLayer = new BandDataLayer(); Band objBand = new Band { BandNo = frm["BandNo"].ToString(), BandSLNO = frm["BandSLNO"].ToString(), NotificationType = frm["NotificationType"].ToString(), }; var Result = objBandDataLayer.InsertBand(objBand); if (Result.Status == BandStatus.Success) { ViewBag.Message = Result.Message; ViewBag.Status = "Success"; } if (Result.Status == BandStatus.Warning) { ViewBag.Message = Result.Message; ViewBag.Status = "Warning"; } if (Result.Status == BandStatus.Error) { ViewBag.Message = Result.Message; ViewBag.Status = "Error"; } return(View()); }
/// <summary> /// Add records for bands and musicians to database. /// </summary> static void SeedDatabase() { Console.WriteLine("Attempting to seed database..."); try { // check if data exists using (var db = new DB_Bands()) { var repo = new MusicianRepository(db); if (repo.GetAll().Count > 0) { Console.WriteLine("Data Exists! Retrieving data... "); Console.WriteLine(""); return; } } // Seeding database - make sure the App.config connection string is targeting a valid SQL Server instance. Console.WriteLine("Seeding database... "); using (var db = new DB_Bands()) { var musicians = BandDataLayer.GetMusicians(); var musicianRepo = new MusicianRepository(db); foreach (var musician in musicians) { musicianRepo.Add(musician); } musicianRepo.Save(); // let's check if all data was stored var seedBands = BandDataLayer.GetBands(); var bandRepo = new GenericRepository <Band>(db); var dbbands = bandRepo.GetAll().Select(y => y.Name).ToList(); foreach (var band in seedBands) { if (!dbbands.Contains(band.Name)) { bandRepo.Add(band); } } bandRepo.Save(); Console.WriteLine("Data Stored to Database!"); Console.WriteLine(""); } } catch (Exception ex) { Console.WriteLine("An error occured while trying to seed the database: " + ex.Message); } }