public bool CreateMeditation(SapMeditations meditation) { using (var dbConn = new SapremaFinalContext()) { meditation.MeditationId = Guid.NewGuid(); dbConn.SapMeditations.Add(meditation); dbConn.SaveChanges(); return(true); } }
/* * Come back to this need to create proper saving for audio and image * */ public bool UpdateMeditation(SapMeditations meditation) { using (var dbConn = new SapremaFinalContext()) { SapMeditations sapMeditation = dbConn.SapMeditations.Where(a => a.MeditationId == meditation.MeditationId).FirstOrDefault(); sapMeditation.MeditationName = meditation.MeditationName; sapMeditation.MeditationTheme = meditation.MeditationTheme; sapMeditation.MeditationCreator = meditation.MeditationCreator; sapMeditation.MeditationType = meditation.MeditationType; sapMeditation.MeditationDescription = meditation.MeditationDescription; dbConn.SaveChanges(); }; return(true); }
public bool UpdateMeditation(string meditationId, string meditationName, string meditationTheme, string meditationCreator, string meditationType, IHostingEnvironment hostingEnvironment, IFormFile imgFile, IFormFile audioFile) { Guid medGuid = Guid.Parse(meditationId); using (var dbConn = new SapremaFinalContext()) { SapMeditations sapMeditation = dbConn.SapMeditations.Where(medId => medId.MeditationId == medGuid).FirstOrDefault(); sapMeditation.MeditationName = meditationName; sapMeditation.MeditationTheme = meditationTheme; sapMeditation.MeditationCreator = meditationCreator; sapMeditation.MeditationType = meditationType; dbConn.SaveChanges(); }; var imgSaved = new DAL.CreateImage(hostingEnvironment).CreateMeditationImage(medGuid, imgFile); var audioSave = new DAL.CreateAudio(hostingEnvironment).CreateMeditationAudio(medGuid, audioFile); return(true); }
//Adds a meditation to db on upload public bool CreateMeditation(string meditationName, string meditationTheme, string meditationCreator, string meditationType, IHostingEnvironment hostingEnvironment, IFormFile imgFile, IFormFile audioFile) { Guid imgGuid = Guid.NewGuid(); using (var dbConn = new SapremaFinalContext()) { SapMeditations sapMeditation = new SapMeditations() { MeditationId = imgGuid, MeditationName = meditationName, MeditationTheme = meditationTheme, MeditationCreator = meditationCreator, MeditationImage = imgGuid, MeditationType = meditationType }; dbConn.SapMeditations.Add(sapMeditation); dbConn.SaveChanges(); }; var imgSaved = new DAL.CreateImage(hostingEnvironment).CreateMeditationImage(imgGuid, imgFile); var audioSave = new DAL.CreateAudio(hostingEnvironment).CreateMeditationAudio(imgGuid, audioFile); return(true); }