public void addProjectMedium(ProjectMedium m, int projectId) { using (var db = new PortfolioUnleashedContext()) { m.ProjectId = projectId;//in case they didn't set this (not auto set by db) db.Projects.Include("ProjectMedia").Where(p => p.Id == projectId).FirstOrDefault().ProjectMedia.Add(m); db.SaveChanges(); } }
//ProjectMedium medium) public VMProjectMedium(ProjectMedium medium) { Link = medium.Link; MediaType = (MediaType)medium.MediumType; Caption = medium.Caption; Id = medium.Id; ProjectId = medium.ProjectId; //ProjectId = medium.ContributionId; }
public VMProjectMedium(ProjectMedium medium)//ProjectMedium medium) { Link = medium.Link; MediaType = (MediaType)medium.MediumType; Caption = medium.Caption; Id = medium.Id; ProjectId = medium.ProjectId; //ProjectId = medium.ContributionId; }
public void removeProjectMedium(ProjectMedium m) { using (var db = new PortfolioUnleashedContext()) { if (db.Projects.Include("ProjectMedia").Any(p => p.ProjectMedia.Any(me => me.Id == m.Id))) //if any project has this project medium { foreach (Project p in db.Projects.Include("ProjectMedia").Where(p => p.ProjectMedia.Any(me => me.Id == m.Id))) //for each project that has this project medium { db.Projects.Include("ProjectMedia").FirstOrDefault(pr => pr.Id == p.Id).ProjectMedia.Remove(p.ProjectMedia.Where(me => me.Id == m.Id).FirstOrDefault()); //remove that medium } } db.ProjectMediums.Remove(db.ProjectMediums.Where(me => me.Id == m.Id).FirstOrDefault());//remove the project medium from table db.SaveChanges(); } }
public static List <ProjectMedium> projectMediumListFromVMProjectMediumList(List <VMProjectMedium> vmMedias) { List <ProjectMedium> mediums = new List <ProjectMedium>(); foreach (VMProjectMedium vmMedium in vmMedias) { ProjectMedium medium = new ProjectMedium() { Link = vmMedium.Link, MediumType = (int)vmMedium.MediaType, Caption = vmMedium.Caption, ProjectId = vmMedium.ProjectId, Id = vmMedium.Id, }; mediums.Add(medium); } return(mediums); }
public void updateProjectMedium(ProjectMedium m) { using (var db = new PortfolioUnleashedContext()) { if (m.Link != null) { db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).Link = m.Link; } if (m.MediumType != db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).MediumType) { db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).MediumType = m.MediumType; } if (m.Caption != null) { db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).Caption = m.Caption; } db.SaveChanges(); } }
public void updateProjectMedium(ProjectMedium m) { using (var db = new PortfolioUnleashedContext()) { if (m.Link != null) db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).Link = m.Link; if (m.MediumType != db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).MediumType) db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).MediumType = m.MediumType; if (m.Caption != null) db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).Caption = m.Caption; db.SaveChanges(); } }
public void removeProjectMedium(ProjectMedium m) { using (var db = new PortfolioUnleashedContext()) { if (db.Projects.Include("ProjectMedia").Any(p => p.ProjectMedia.Any(me => me.Id == m.Id)))//if any project has this project medium { foreach (Project p in db.Projects.Include("ProjectMedia").Where(p => p.ProjectMedia.Any(me => me.Id == m.Id)))//for each project that has this project medium { db.Projects.Include("ProjectMedia").FirstOrDefault(pr => pr.Id == p.Id).ProjectMedia.Remove(p.ProjectMedia.Where(me => me.Id == m.Id).FirstOrDefault());//remove that medium } } db.ProjectMediums.Remove(db.ProjectMediums.Where(me => me.Id == m.Id).FirstOrDefault());//remove the project medium from table db.SaveChanges(); } }
public static List<ProjectMedium> projectMediumListFromVMProjectMediumList(List<VMProjectMedium> vmMedias) { List<ProjectMedium> mediums = new List<ProjectMedium>(); foreach (VMProjectMedium vmMedium in vmMedias) { ProjectMedium medium = new ProjectMedium() { Link = vmMedium.Link, MediumType = (int)vmMedium.MediaType, Caption = vmMedium.Caption, ProjectId = vmMedium.ProjectId, Id = vmMedium.Id, }; mediums.Add(medium); } return mediums; }
private bool AllProjectMediaVerified(out List<ProjectMedium> media) { bool isValidInput = true; media = new List<ProjectMedium>(); string[] mediaIds = Request.Form.GetValues("ProjectMedia.Id"); string[] mediaLinks = Request.Form.GetValues("ProjectMedia.Link"); string[] mediaMediaTypes = Request.Form.GetValues("ProjectMedia.MediaType"); string[] mediaCaptions = Request.Form.GetValues("ProjectMedia.Caption"); for (int i = 0; i < mediaIds.Count(); i++) { string[] entryInputs = new string[] { mediaIds[i], mediaLinks[i], mediaCaptions[i] }; if (!allAreNullOrEmpty(entryInputs)) { entryInputs = new string[] { mediaLinks[i], mediaCaptions[i] }; if (someAreNullOrEmpty(entryInputs)) { isValidInput = false; ModelState.AddModelError("", "If you add a Media entry, you must either complete all fields for that entry or leave all fields blank."); } else { int specifiedMediaType = (int)((MediaType)Enum.Parse(typeof(MediaType), mediaMediaTypes[i])); isValidInput = verifyMediaTypeMatchesMedia(specifiedMediaType, mediaLinks[i]); } ProjectMedium medium = new ProjectMedium(); medium.Caption = mediaCaptions[i]; medium.Link = mediaLinks[i]; medium.Id = int.Parse(mediaIds[i]); medium.MediumType = (int)((MediaType)Enum.Parse(typeof(MediaType), mediaMediaTypes[i])); media.Add(medium); } } return isValidInput; }