public IActionResult DeleteReport([FromBody] RequestMessage <ReportViewModel> reqMsg) { if (ModelState.IsValid) { using (IReportService rptSrv = DIService.GetService <IReportService>()) { var result = rptSrv.DeleteReport(reqMsg); return(Json(result, JsonService.SelfLoopJsonSettings)); } } return(BadRequest()); }
public IActionResult DeleteBomNode([FromBody] RequestMessage <BomNodeViewModel> reqMsg) { if (ModelState.IsValid) { using (IBomManagerService bomSrv = DIService.GetService <IBomManagerService>()) { var result = bomSrv.DeleteBomNode(reqMsg); return(Json(result, JsonService.SelfLoopJsonSettings)); } } return(BadRequest()); }
public IActionResult CreateOrUpdateRootReport([FromBody] RequestMessage <ReportViewModel> reqMsg) { if (ModelState.IsValid) { using (IReportService rptSrv = DIService.GetService <IReportService>()) { var rpt = reqMsg.Playload.FirstOrDefault(); var result = rptSrv.CreateOrUpdateRootReport(reqMsg); return(Json(result, JsonService.SelfLoopJsonSettings)); } } return(BadRequest()); }
public IActionResult UpsertRootBomNode([FromBody] RequestMessage <BomNodeViewModel> reqMsg) { if (ModelState.IsValid) { using (IBomManagerService bomSrv = DIService.GetService <IBomManagerService>()) { var rpt = reqMsg.Playload.FirstOrDefault(); var result = bomSrv.UpsertRootBomNode(reqMsg); return(Json(result, JsonService.SelfLoopJsonSettings)); } } return(BadRequest()); }
public IActionResult Post([FromBody] RequestMessage <BlogViewModel> reqMsg) { if (ModelState.IsValid) { using (IBlogService blogService = DIService.GetService <IBlogService>()) { var blogVM = reqMsg.Playload.FirstOrDefault(); var result = blogService.CreateOrUpdateBlog2(reqMsg); return(Json(result)); } } return(BadRequest()); //CreatedAtAction("Get", new { id = 123 }, new User() { Id = new Random().Next(1, 10), Name = "myad", Sex = "男" }); // user.Id = new Random().Next(1, 10); // return CreatedAtAction("Get", new { id = user.Id }, user); }
// [TypeFilter(typeof(MyActionTypeFilter), Arguments = new object[] { "typefilter", "MyTypeFilterAction" })] public IActionResult Get(int id) { // _logger.LogInformation("This is Information Log!"); // _logger.LogWarning("This is a Warning Log!"); // _logger.LogError("This is a Error log!"); try { //DIService.GetService<IBlogService>() // Console.WriteLine(this.HttpContext.RequestServices.GetService(typeof(IBlogService))); var user = new User() { Id = id, Name = "Name:" + id, Sex = "Male" }; // this._logger.LogInformation(Json(user).ToString()); using (IBlogService blogService = DIService.GetService <IBlogService>()) { Blog blog1 = new Blog { BlogName = "我的个人博客II", Url = "http://www.xyzsoft.com" }; Post post = new Post { Title = "如何使用EFCore-xyzsoft", Content = "要想正确使用EFCORE,必须先看文档,了解有哪些东西,然后配合实践,不明白的再看文档" }; blog1.Posts.Add(post); blogService.InsertBlog(blog1); var count = blogService.AcceptAllChanges(); ResponseMessage <PostQueryViewModel> posts = blogService.GetAllPosts(); return(new ObjectResult(JsonService.SerializeObject(posts))); } } catch (System.Exception ex) { throw new Exception(ex.Message); // return new ObjectResult(ex.Message); } // Console.WriteLine(ex.Message); // // this._logger.LogError(ex.InnerException.Message); // // var jsonstr = "{ message22:" + ex.InnerException.Message + " }"; // // Console.WriteLine(jsonstr); }
public IActionResult GetBlog([FromBody] RequestMessage <BlogViewModel> reqModel) { try { if (ModelState.IsValid) { using (IBlogService blogService = DIService.GetService <IBlogService>()) { var blogvm = blogService.GetBlog(reqModel); return(Json(blogvm)); //new ObjectResult(JsonService.SerializeObject(blogvm)); } } return(new ObjectResult("{ message:" + "对象不合法" + " }")); } catch (System.Exception ex) { this._logger.LogError(ex.InnerException.Message); var jsonstr = "{ message:" + ex.InnerException.Message + " }"; return(new ObjectResult(jsonstr)); } }
public static void Main(string[] args) { DIService.RegisterService(); var dbconfig = DIService.ServiceProvider.GetService <IOptions <DatabaseConfig> >(); // var abc = DIService.services.BuildServiceProvider(); AppConfig.MasterDatabaseInfo = dbconfig.Value; // new DataService.Infrastructure.DatabaseConfig() // { // Name = "cx", // StoreType = StoreType.MySql, // ConnectionString = @"server=localhost;userid=root;pwd=99b3ad6e;port=3306;database=blogdb;sslmode=none;" // }; using (IBlogService blogService = DIService.GetService <IBlogService>()) { Blog blog1 = new Blog(); blog1.BlogName = "我的个人博客II"; blog1.Url = "http://www.xyzsoft.com"; Post post = new Post(); post.Title = "如何使用EFCore-xyzsoft"; post.Content = "要想正确使用EFCORE,必须先看文档,了解有哪些东西,然后配合实践,不明白的再看文档"; blog1.Posts.Add(post); blogService.InsertBlog(blog1); //blogService.InsertBlog(new Blog() { Url = "http://blogs.msdn.com/adonet", BlogName = "我的博客" }); var count = blogService.AcceptAllChanges(); Console.WriteLine("{0} records saved to database", count); // Console.WriteLine("All blogs in database:"); // foreach (var blog in blogService.GetAllBlogs().Where(b => b.BlogId > 0)) // { // Console.WriteLine(" - {0} - {1}", blog.Url, blog.SiteName); // } } var options = new DbContextOptionsBuilder <DbContextBase>() .UseMySql(new MySqlConnection(AppConfig.MasterDatabaseInfo.ConnectionString)) .Options; using (var context1 = new MySqlContext(options)) { using (var transaction = context1.Database.BeginTransaction()) { context1.CommittableTransaction = transaction; try { var blog2 = new Blog { Url = "http://blogs.msdn.com/visualstudio", BlogName = "新增的博客" }; // var post = context1.Set<Post>().Last(); var post = new Post(); post.Title = "学习EF CORE"; post.Content = "学习EF CORE,必须了解的细节"; blog2.Posts.Add(post); // post.BlogId = blog2.BlogId; context1.Add(blog2); // context1.Set<Blog>().Add(new Blog { BlogName = "单独实例上下文56", Url = "http://blogs.msdn.com/dotnet598" }); context1.SaveChanges(); using (var context2 = new MySqlContext(options)) { // context2.Database.UseTransaction(context1.GetDbTransaction()); context2.UseTransaction(context1); var lastblog = context2.Set <Blog>().Last(); // context2.Set<Blog>().Remove(lastblog); context2.SaveChanges(); var blogs = context2 .Set <Blog>() .FromSql("select * from Blog") .Include(b => b.Posts) .Select(blog => new { blog.BlogId, blog.Url, blog.BlogName, blog.Posts }) .OrderBy(b => b.Url) .ToList(); foreach (var blog in blogs) { Console.WriteLine(" - {0} - {1} - {2}", blog.Url, blog.BlogName, blog.Posts.Count()); } // Commit transaction if all commands succeed, transaction will auto-rollback // when disposed if either commands fails transaction.Commit(); } } catch (Exception) { // TODO: Handle failure } } } Console.ReadKey(); }