/// <summary> /// 保存主题 /// </summary> /// <param name="reply"></param> public void SaveReply(TopicReply reply) { using (var trans = db.Database.BeginTransaction()) { try { db.TopicReplies.Add(reply); var topic = db.Topices.FirstOrDefault(x => x.Id == reply.TopicId); topic.LastReplyDate = DateTime.Now; topic.LastReplyUserId = reply.UserId; topic.ReplyCount = topic.ReplyCount + 1; db.SaveChanges(); trans.Commit(); base.IsSuccess = true; base.ReturnMsg = "保存成功"; } catch (Exception ex) { base.IsSuccess = true; base.ReturnMsg = "保存成功"; } } }
public void Remove(Guid id) { Article article = db.Articles.FirstOrDefault(x => x.Id == id); db.Articles.Remove(article); bool result = db.SaveChanges() > 0; base.IsSuccess = result; base.ReturnMsg = result ? "删除成功" : "删除失败"; }
public void Remove(Guid id) { Programming programming = db.Programmings.FirstOrDefault(x => x.Id == id); db.Programmings.Remove(programming); bool result = db.SaveChanges() > 0; base.IsSuccess = result; base.ReturnMsg = result ? "删除成功" : "删除失败"; }
// // GET: /Home/ public ActionResult Index() { //using (MyContext context = new MyContext()) //{ // string name= context.Set<Student>().FirstOrDefault().Name; // name = context.Set<Student>().FirstOrDefault().Courses.FirstOrDefault().Name; //} //using (MyContext context = new MyContext()) //{ // string name = context.Set<Student>().FirstOrDefault().Name; // name = context.Set<Student>().FirstOrDefault().Courses.FirstOrDefault().Name; //} using (SCContext a = new SCContext()) { a.Set <Student>().Add(new Student { Name = "1" }); a.SaveChanges(); } //using (UserRoleDbContext2 a = new UserRoleDbContext2()) //{ // a.Set<User>().Add(new User { Name = "1" }); // a.SaveChanges(); //} return(Content("")); }
public void Remove(Guid id) { bool flag = db.Articles.Where(x => x.CategoryId == id).Count() > 0; if (flag) { base.IsSuccess = false; base.ReturnMsg = "该分类下有文章不能删除"; } else { ArticleCategory category = db.ArticleCategories.FirstOrDefault(x => x.Id == id); db.ArticleCategories.Remove(category); bool result = db.SaveChanges() > 0; base.IsSuccess = result; base.ReturnMsg = result ? "删除成功" : "删除失败"; } }
public async Task <UsersExtension> SaveProfileImagePath(string username, string path, string thumbPath) { UsersExtension user = UsersExtensions.Where(p => p.Users.UserName == username).FirstOrDefault(); user.ImagePath = path; user.ImageThumbPath = thumbPath; _context.SaveChanges(); return(user); }
public Dish AddDishFromViewModel(Dish newDish) { newDish.AddDate = DateTime.Now; newDish.ModifyDate = DateTime.Now; newDish.PublishDate = DateTime.Now; newDish.Id = Guid.NewGuid(); _context.Dishes.Add(newDish); _context.SaveChanges(); return(newDish); }
/// <summary> /// 删除用户 /// </summary> /// <param name="id"></param> public void Remove(Guid id) { User user = db.Users.FirstOrDefault(x => x.Id == id); db.Users.Remove(user); bool result = db.SaveChanges() > 0; base.IsSuccess = result; base.ReturnMsg = result ? "删除成功" : "删除失败"; }
public async Task<Data.Entities.Startup> AddStartup(string title, string description, Data.Entities.User creator) { _dbcontext.Users.Update(creator); var dbStartup = new Data.Entities.Startup() { Title = title, Description = description }; var addedStartup = _dbcontext.Startups.Add(dbStartup).Entity; var dbTeamMember = new Data.Entities.TeamMember() { StartupId = addedStartup.StartupId, UserId = creator.UserId, Role = "", EditAccess = true }; _dbcontext.TeamMembers.Add(dbTeamMember); _dbcontext.SaveChanges(); return _dbcontext.Startups.Find(addedStartup.StartupId); }
/// <summary> /// 保存资料 /// </summary> /// <param name="model"></param> public void Save(Materials model) { model.CreateDate = DateTime.Now; model.IsDelete = false; db.Materialses.Add(model); bool result = db.SaveChanges() > 0; base.IsSuccess = result; base.ReturnMsg = result ? "保存成功" : "保存失败"; }