private Result Register(User user) { if (user != null) { User existingUser = _db.Users.SingleOrDefault(u => u.Username == user.Username); if (existingUser != null) { return(new Result(false) { Message = "username already in use" }); } else { // no transactions so may fail user.CreatedDate = DateTime.UtcNow; _db.Users.Add(user); _db.SaveChanges(); return(new Result(true)); } } return(new Result(false) { Message = "invalid input" }); }
public LessonComment AddComment(LessonComment comment) { LessonComment insertComment = _ctx.LessonComments.Add(comment); _ctx.SaveChanges(); return(insertComment); }
public void ImportSuburbs(MyHobbyContext context) { List <Suburb> suburbs = new List <Suburb>(); StreamReader sr = null; try { City hk = context.Cities.SingleOrDefault(c => c.EnglishName == "Hong Kong"); if (hk != null) { return; } hk = new City() { Name = "香港", EnglishName = "Hong Kong" }; context.Cities.Add(hk); Assembly resourceAssembly = Assembly.GetAssembly(typeof(MyHobby.Resources.LocateThisAssembly)); Stream stream = resourceAssembly.GetManifestResourceStream("MyHobby.Resources.Suburbs_HK.txt"); sr = new StreamReader(stream); if (sr != null) { string line = sr.ReadLine(); SuburbGroup group = null; while (!string.IsNullOrEmpty(line)) { string[] fields = SplitCSV(line); //line.Split(','); if (fields.Length == 3) { group = new SuburbGroup() { Name = fields[1], EnglishName = fields[2], City = hk }; context.SuburbGroups.Add(group); } else { Suburb suburb = new Suburb() { Name = fields[0], EnglishName = fields[1], SuburbGroup = group }; context.Suburbs.Add(suburb); } line = sr.ReadLine(); } context.SaveChanges(); } } catch (Exception ex) { throw ex; } finally { if (sr != null) { sr.Close(); } } }
public void AddReview(BusinessReview review) { _ctx.BusinessReviews.Add(review); _ctx.SaveChanges(); }