/// <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 ? "保存成功" : "保存失败";
}