public static string SaveIdea(string text) { string err = null; try { using (DB_125405_joeEntities context = new DB_125405_joeEntities()) { var existingIdea = context.Ideas.Where(x => x.Text.Trim().Replace(" ", "").ToUpper().Trim() == text.Trim().Replace(" ", "").ToUpper().Trim()).FirstOrDefault(); if (existingIdea != null) { throw new Exception("idea already exists "); } Idea idea = new Idea { Text = text }; context.Ideas.Add(idea); context.SaveChanges(); } } catch (Exception ex) { err = ex.Message; if ((ex.InnerException != null) && (!string.IsNullOrEmpty(ex.InnerException.Message))) { err += ex.InnerException.Message; } } return(err); }
public static List <IdeaPOCO> GetIdeas() { List <IdeaPOCO> ideas = new List <IdeaPOCO>(); using (DB_125405_joeEntities context = new DB_125405_joeEntities()) { foreach (var ideaObj in context.Ideas) { IdeaPOCO idea = new IdeaPOCO { Text = ideaObj.Text, Id = ideaObj.Id }; ideas.Add(idea); } } ideas.Reverse(); return(ideas); }
public static List <PeoplePOCO> GetPeople() { List <PeoplePOCO> people = new List <PeoplePOCO>(); { using (DB_125405_joeEntities context = new DB_125405_joeEntities()) { foreach (var peopleObj in context.people) { PeoplePOCO idea = new PeoplePOCO { FirstName = peopleObj.FirstName, Id = peopleObj.Id }; people.Add(idea); } } } return(people); }