/// <summary>
/// 更新角色权限
/// </summary>
/// <param name="roleId"></param>
/// <param name="powerData"></param>
/// <returns></returns>
public bool UpdateRolePower(int roleId, List <int> powerData)
{
using (var tran = _dbContext.Database.BeginTransaction())
{
try
{
//移除以前的权限
_dbContext.MangoRemove <Entity.m_ManagerPower>(m => m.RoleId == roleId);
//添加新权限
foreach (int Id in powerData)
{
Entity.m_ManagerPower model = new Entity.m_ManagerPower();
model.MenuId = Id;
model.RoleId = roleId;
_dbContext.Add(model);
}
_dbContext.SaveChanges();
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
}
}
public async Task <IActionResult> Reg([FromBody] RegistrationViewModel model)
{
//var userIdentity = _mapper.Map<DbUser>(model);
var userIdentity = new DbUser {
Email = model.Email, UserName = model.UserName, PhoneNumber = model.PhoneNumber
};
var user = await userManager.CreateAsync(userIdentity, model.Password);
if (!user.Succeeded)
{
foreach (var el in user.Errors)
{
return(new BadRequestObjectResult(Errors.AddErrorToModelState("Error", el.Description, ModelState)));
}
}
else
{
DetailedUser userDetailed = new DetailedUser
{
UserSurname = model.UserSurname,
DateOfBirth = new DateTime(2019, 11, 9), /*DateTime.Parse(model.DateOfBirth.ToShortDateString())*/
Locality = model.Locality,
User = userManager.FindByEmailAsync(model.Email).Result
};
_dbcontext.Add(userDetailed);
_dbcontext.SaveChanges();
}
model.Password = "";
return(Ok("Account Created"));
}
public async Task <ActionResult> SignIn([FromBody] SignInViewModels model)
{
//var role = _roleManager.FindByNameAsync(model.Role).Result;
//if (role == null)
//{
// role = new DbRole
// {
// Name = model.Role
// };
// var addRoleResult = _roleManager.CreateAsync(role).Result;
//}
//var userEmail = "*****@*****.**";
var user = await _userManager.FindByEmailAsync(model.Email);
if (user == null)
{
user = new DbUser
{
Email = model.Email,
UserName = model.Email
};
var result = _userManager.CreateAsync(user, model.Password).Result;
//if (result.Succeeded)
//{
// result = _userManager.AddToRoleAsync(user, model.Role).Result;
//}
}
_context.Add(user);
_context.SaveChanges();
return(Ok());
}
public TodoesController()
{
var options = new DbContextOptionsBuilder <EFDbContext>()
.UseInMemoryDatabase(databaseName: "InMemoryDatabase")
.Options;
_db = new EFDbContext(options);
if (_db.Todoes.FirstOrDefault() == null)
{
_db.Todoes.Add(new Todo
{
Id = "18kxytxr0cak4ay1nj4d",
Title = "18kxytxr0cak4ay1nj4d" + DateTime.Now,
});
_db.Add(new Todo
{
Id = "228kxytxr0cak4ay1nj4d",
Title = "228kxytxr0cak4ay1nj4d" + DateTime.Now,
IsComplete = true,
});;
try
{
_db.SaveChanges();
}
catch (System.Exception)
{
}
}
}
public async Task <bool> Create(Customer customer)
{
_context.Add(customer);
await _context.SaveChangesAsync();
return(true);
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="userModel"></param>
/// <param name="userInfoModel"></param>
/// <returns></returns>
public bool AddUser(Entity.m_User userModel)
{
using (var tran = _dbContext.Database.BeginTransaction())
{
try
{
_dbContext.Add(userModel);
_dbContext.SaveChanges();
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
}
}
public bool Insert <TEntity>(TEntity entity) where TEntity : class
{
try
{
_dbContext.Add(entity);
_dbContext.SaveChanges();
return(true);
}
catch (Exception e)
{
throw new InvalidDataException(e.Message);
}
}
public bool AddAnswer(Entity.m_PostsAnswer model, Entity.m_Message message)
{
using (var tran = _dbContext.Database.BeginTransaction())
{
try
{
_dbContext.Add(model);
_dbContext.SaveChanges();
//添加通知信息
_dbContext.Add(message);
_dbContext.SaveChanges();
//更新回答数量
_dbContext.MangoUpdate <Entity.m_Posts>(m => m.AnswerCount == m.AnswerCount + 1, m => m.PostsId == model.PostsId);
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
}
}
public async Task <IActionResult> NewFile(ImageViewModel imageVM)
{
if (ModelState.IsValid)
{
string uniqueFileName = UploadedFile(imageVM);
Image image = new Image
{
Title = imageVM.Title,
ImageDescription = imageVM.ImageDescription,
};
_context.Add(image);
await _context.SaveChangesAsync();
return(RedirectToAction("NewFileHelper"));
}
return(View());
}
public void Add(Category category)
{
_context.Add(category);
}
// GET: /<controller>/
/// <summary>
/// 设置帖子属性标签
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool SetProperty(Entity.m_Posts model)
{
_dbContext.Add(model);
return(_dbContext.SaveChanges() > 0);
}
public IActionResult Post([FromBody, Required] Employee employee)
{
_efDbContext.Add(employee);
_efDbContext.SaveChanges();
return(new OkObjectResult(employee));
}
/// <summary>
/// 添加用户点赞消息
/// </summary>
/// <param name="model"></param>
/// <param name="message"></param>
/// <returns></returns>
public int AddUserPlusRecords(Entity.m_UserPlusRecords model, Entity.m_Message message)
{
//记录类型 1 帖子点赞 2 帖子回答点赞 3 帖子评论点赞 4 文档主题点赞 5 文档点赞
int result = 0;
//加载是否已经存在点赞记录
var queryCount = _dbContext.m_UserPlusRecords.Where(m => m.ObjectId == model.ObjectId && m.UserId == model.UserId && m.RecordsType == model.RecordsType).Count();
using (var tran = _dbContext.Database.BeginTransaction())
{
try
{
if (queryCount > 0)
{
//存在则撤回点赞记录
_dbContext.MangoRemove <Entity.m_UserPlusRecords>(m => m.ObjectId == model.ObjectId && m.UserId == model.UserId && m.RecordsType == model.RecordsType);
//
switch (model.RecordsType.Value)
{
case 1:
_dbContext.MangoUpdate <Entity.m_Posts>(m => m.PlusCount == m.PlusCount - 1, m => m.PostsId == model.ObjectId);
break;
case 2:
_dbContext.MangoUpdate <Entity.m_PostsAnswer>(m => m.Plus == m.Plus - 1, m => m.AnswerId == model.ObjectId);
break;
case 3:
_dbContext.MangoUpdate <Entity.m_PostsComments>(m => m.Plus == m.Plus - 1, m => m.CommentId == model.ObjectId);
break;
case 4:
_dbContext.MangoUpdate <Entity.m_DocsTheme>(m => m.PlusCount == m.PlusCount - 1, m => m.ThemeId == model.ObjectId);
break;
case 5:
_dbContext.MangoUpdate <Entity.m_Docs>(m => m.PlusCount == m.PlusCount - 1, m => m.DocsId == model.ObjectId);
break;
}
tran.Commit();
result = -1;
}
else
{
//不存在则新增点赞记录
_dbContext.Add(message);
_dbContext.SaveChanges();
//
_dbContext.Add(model);
_dbContext.SaveChanges();
//
switch (model.RecordsType.Value)
{
case 1:
_dbContext.MangoUpdate <Entity.m_Posts>(m => m.PlusCount == m.PlusCount + 1, m => m.PostsId == model.ObjectId);
break;
case 2:
_dbContext.MangoUpdate <Entity.m_PostsAnswer>(m => m.Plus == m.Plus + 1, m => m.AnswerId == model.ObjectId);
break;
case 3:
_dbContext.MangoUpdate <Entity.m_PostsComments>(m => m.Plus == m.Plus + 1, m => m.CommentId == model.ObjectId);
break;
case 4:
_dbContext.MangoUpdate <Entity.m_DocsTheme>(m => m.PlusCount == m.PlusCount + 1, m => m.ThemeId == model.ObjectId);
break;
case 5:
_dbContext.MangoUpdate <Entity.m_Docs>(m => m.PlusCount == m.PlusCount + 1, m => m.DocsId == model.ObjectId);
break;
}
tran.Commit();
result = 1;
}
}
catch
{
tran.Rollback();
result = 0;
}
}
return(result);
}
private static void AddProduct(EFDbContext EfDbCtx)
{
EfDbCtx.Add(new Product
{
Available = EnumAvailable.Available,
Brand = new Brand {
Name = "Brac"
},
Categories = new List <Category> {
new Category {
Name = "Garden"
}, new Category {
Name = "Plant"
}
},
Code = "abcd1234",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam fringilla augue nec est tristique auctor. Donec non est at libero vulputate rutrum. Morbi ornare lectus quis justo gravida semper. Nulla tellus mi, vulputate adipiscing cursus eu, suscipit id nulla." +
"Pellentesque aliquet, sem eget laoreet ultrices, ipsum metus feugiat sem, quis fermentum turpis eros eget velit. Donec ac tempus ante. Fusce ultricies massa massa. Fusce aliquam, purus eget sagittis vulputate, sapien libero hendrerit est, sed commodo augue nisi non neque. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed tempor, lorem et placerat vestibulum, metus nisi posuere nisl, in accumsan elit odio quis mi. Cras neque metus, consequat et blandit et, luctus a nunc. Etiam gravida vehicula tellus, in imperdiet ligula euismod eget.",
Images = new List <FileImage> {
new FileImage {
FileName = "small1-1.jpg"
}, new FileImage {
FileName = "small1-2.jpg"
}, new FileImage {
FileName = "small1-3.jpg"
}, new FileImage {
FileName = "small1-4.jpg"
}
},
NewPrice = 100,
OldPrice = 120,
Ranks = 4,
Title = "Lorem ipsum indoor plants",
WithoutTax = 95,
Reviews = new List <Review> {
new Review {
Description = "enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia res eos qui ratione voluptatem sequi Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci veli", Email = "*****@*****.**", Name = "Cristopher Lee", Rank = 4
}
}
});
EfDbCtx.Add(new Product
{
Available = EnumAvailable.Available,
Brand = new Brand {
Name = "Erab"
},
Categories = new List <Category> {
new Category {
Name = "Flower"
}, new Category {
Name = "Plant"
}
},
Code = "abcd6321",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam fringilla augue nec est tristique auctor. Donec non est at libero vulputate rutrum. Morbi ornare lectus quis justo gravida semper. Nulla tellus mi, vulputate adipiscing cursus eu, suscipit id nulla." +
"Pellentesque aliquet, sem eget laoreet ultrices, ipsum metus feugiat sem, quis fermentum turpis eros eget velit. Donec ac tempus ante. Fusce ultricies massa massa. Fusce aliquam, purus eget sagittis vulputate, sapien libero hendrerit est, sed commodo augue nisi non neque. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed tempor, lorem et placerat vestibulum, metus nisi posuere nisl, in accumsan elit odio quis mi. Cras neque metus, consequat et blandit et, luctus a nunc. Etiam gravida vehicula tellus, in imperdiet ligula euismod eget.",
Images = new List <FileImage> {
new FileImage {
FileName = "small1-4.jpg"
}, new FileImage {
FileName = "small1-2.jpg"
}, new FileImage {
FileName = "small1-1.jpg"
}, new FileImage {
FileName = "small1-1.jpg"
}
},
NewPrice = 85,
OldPrice = 70,
Ranks = 4,
Title = "Lorem ipsum indoor plants",
WithoutTax = 65,
Reviews = new List <Review> {
new Review {
Description = "enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia res eos qui ratione voluptatem sequi Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci veli", Email = "*****@*****.**", Name = "Cristopher Lee", Rank = 4
}
}
});
EfDbCtx.Add(new Product
{
Available = EnumAvailable.Available,
Brand = new Brand {
Name = "Dora"
},
Categories = new List <Category> {
new Category {
Name = "Garden"
}
},
Code = "bacd4356",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam fringilla augue nec est tristique auctor. Donec non est at libero vulputate rutrum. Morbi ornare lectus quis justo gravida semper. Nulla tellus mi, vulputate adipiscing cursus eu, suscipit id nulla." +
"Pellentesque aliquet, sem eget laoreet ultrices, ipsum metus feugiat sem, quis fermentum turpis eros eget velit. Donec ac tempus ante. Fusce ultricies massa massa. Fusce aliquam, purus eget sagittis vulputate, sapien libero hendrerit est, sed commodo augue nisi non neque. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed tempor, lorem et placerat vestibulum, metus nisi posuere nisl, in accumsan elit odio quis mi. Cras neque metus, consequat et blandit et, luctus a nunc. Etiam gravida vehicula tellus, in imperdiet ligula euismod eget.",
Images = new List <FileImage> {
new FileImage {
FileName = "small1-2.jpg"
}, new FileImage {
FileName = "small1-3.jpg"
}, new FileImage {
FileName = "small1-1.jpg"
}, new FileImage {
FileName = "small1-4.jpg"
}
},
NewPrice = 170,
OldPrice = 195,
Ranks = 2,
Title = "Lorem ipsum indoor plants",
WithoutTax = 65,
Reviews = new List <Review> {
new Review {
Description = "enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia res eos qui ratione voluptatem sequi Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci veli", Email = "*****@*****.**", Name = "Cristopher Lee", Rank = 4
}
}
});
EfDbCtx.Add(new Product
{
Available = EnumAvailable.Available,
Brand = new Brand {
Name = "Sera"
},
Categories = new List <Category> {
new Category {
Name = "Plant"
}
},
Code = " abzt6521",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam fringilla augue nec est tristique auctor. Donec non est at libero vulputate rutrum. Morbi ornare lectus quis justo gravida semper. Nulla tellus mi, vulputate adipiscing cursus eu, suscipit id nulla." +
"Pellentesque aliquet, sem eget laoreet ultrices, ipsum metus feugiat sem, quis fermentum turpis eros eget velit. Donec ac tempus ante. Fusce ultricies massa massa. Fusce aliquam, purus eget sagittis vulputate, sapien libero hendrerit est, sed commodo augue nisi non neque. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed tempor, lorem et placerat vestibulum, metus nisi posuere nisl, in accumsan elit odio quis mi. Cras neque metus, consequat et blandit et, luctus a nunc. Etiam gravida vehicula tellus, in imperdiet ligula euismod eget.",
Images = new List <FileImage> {
new FileImage {
FileName = "small1-4.jpg"
}, new FileImage {
FileName = "small1-2.jpg"
}, new FileImage {
FileName = "small1-1.jpg"
}, new FileImage {
FileName = "small1-1.jpg"
}
},
NewPrice = 210,
OldPrice = 235,
Ranks = 2,
Title = "Lorem ipsum indoor plants",
WithoutTax = 200,
Reviews = new List <Review> {
new Review {
Description = "enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia res eos qui ratione voluptatem sequi Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci veli", Email = "*****@*****.**", Name = "Cristopher Lee", Rank = 4
}
}
});
EfDbCtx.Add(new Product
{
Available = EnumAvailable.Available,
Brand = new Brand {
Name = "Brac"
},
Categories = new List <Category> {
new Category {
Name = "Flower"
}, new Category {
Name = "Plant"
}
},
Code = " tbcd4321",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam fringilla augue nec est tristique auctor. Donec non est at libero vulputate rutrum. Morbi ornare lectus quis justo gravida semper. Nulla tellus mi, vulputate adipiscing cursus eu, suscipit id nulla." +
"Pellentesque aliquet, sem eget laoreet ultrices, ipsum metus feugiat sem, quis fermentum turpis eros eget velit. Donec ac tempus ante. Fusce ultricies massa massa. Fusce aliquam, purus eget sagittis vulputate, sapien libero hendrerit est, sed commodo augue nisi non neque. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed tempor, lorem et placerat vestibulum, metus nisi posuere nisl, in accumsan elit odio quis mi. Cras neque metus, consequat et blandit et, luctus a nunc. Etiam gravida vehicula tellus, in imperdiet ligula euismod eget.",
Images = new List <FileImage> {
new FileImage {
FileName = "small1-1.jpg"
}, new FileImage {
FileName = "small1-2.jpg"
}, new FileImage {
FileName = "small1-3.jpg"
}, new FileImage {
FileName = "small1-4.jpg"
}
},
NewPrice = 310,
OldPrice = 350,
Ranks = 5,
Title = "Lorem ipsum indoor plants",
WithoutTax = 320,
Reviews = new List <Review> {
new Review {
Description = "enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia res eos qui ratione voluptatem sequi Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci veli", Email = "*****@*****.**", Name = "Cristopher Lee", Rank = 4
}
}
});
EfDbCtx.Add(new Product
{
Available = EnumAvailable.Available,
Brand = new Brand {
Name = "Brac"
},
Categories = new List <Category> {
new Category {
Name = "Flower"
}, new Category {
Name = "Plant"
}
},
Code = " zbcd4321",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam fringilla augue nec est tristique auctor. Donec non est at libero vulputate rutrum. Morbi ornare lectus quis justo gravida semper. Nulla tellus mi, vulputate adipiscing cursus eu, suscipit id nulla." +
"Pellentesque aliquet, sem eget laoreet ultrices, ipsum metus feugiat sem, quis fermentum turpis eros eget velit. Donec ac tempus ante. Fusce ultricies massa massa. Fusce aliquam, purus eget sagittis vulputate, sapien libero hendrerit est, sed commodo augue nisi non neque. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed tempor, lorem et placerat vestibulum, metus nisi posuere nisl, in accumsan elit odio quis mi. Cras neque metus, consequat et blandit et, luctus a nunc. Etiam gravida vehicula tellus, in imperdiet ligula euismod eget.",
Images = new List <FileImage> {
new FileImage {
FileName = "small1-4.jpg"
}, new FileImage {
FileName = "small1-2.jpg"
}, new FileImage {
FileName = "small1-3.jpg"
}, new FileImage {
FileName = "small1-1.jpg"
}
},
NewPrice = 310,
OldPrice = 350,
Ranks = 1,
Title = "Lorem ipsum indoor plants",
WithoutTax = 320,
Reviews = new List <Review> {
new Review {
Description = "enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia res eos qui ratione voluptatem sequi Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci veli", Email = "*****@*****.**", Name = "Cristopher Lee", Rank = 4
}
}
});
}
/// <summary>
/// 添加记录
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="entity"></param>
/// <returns></returns>
public bool Add <TEntity>(TEntity entity) where TEntity : class
{
_dbContext.Add(entity);
return(_dbContext.SaveChanges() > 0);
}
public void Add(Customer customer)
{
Context.Add(customer);
Context.SaveChanges();
}
