public void Post([FromBody] CentralPolicyEventViewModel model) { System.Console.WriteLine("1"); foreach (var id in model.CentralPolicyId) { var centralpolicyprovince = _context.CentralPolicyProvinces .Where(m => m.CentralPolicyId == id && m.ProvinceId == model.ProvinceId).FirstOrDefault(); System.Console.WriteLine("2"); var ElectronicBookdata = new ElectronicBook { CreatedBy = model.CreatedBy, Status = "ร่างกำหนดการ", }; _context.ElectronicBooks.Add(ElectronicBookdata); _context.SaveChanges(); System.Console.WriteLine("3"); var ElectronicBookGroupdata = new ElectronicBookGroup { CentralPolicyProvinceId = centralpolicyprovince.Id, ElectronicBookId = ElectronicBookdata.Id, }; _context.ElectronicBookGroups.Add(ElectronicBookGroupdata); _context.SaveChanges(); System.Console.WriteLine("4"); var centralpolicyeventdata = new CentralPolicyEvent { CentralPolicyId = id, InspectionPlanEventId = model.InspectionPlanEventId, ElectronicBookId = ElectronicBookdata.Id, }; _context.CentralPolicyEvents.Add(centralpolicyeventdata); _context.SaveChanges(); System.Console.WriteLine("5"); } }
public void Post([FromBody] InspectionPlanViewModel model) { //var test = model.UserID; //System.Console.WriteLine(test); System.Console.WriteLine("1" + model.Title); var date = DateTime.Now; System.Console.WriteLine("2" + model.Type); var centralpolicydata = new CentralPolicy { Title = model.Title, Type = model.Type, FiscalYearId = model.FiscalYearId, StartDate = model.StartDate, EndDate = model.EndDate, Status = model.Status, CreatedAt = date, CreatedBy = model.UserID, Class = "แผนการตรวจ", }; System.Console.WriteLine("3"); _context.CentralPolicies.Add(centralpolicydata); _context.SaveChanges(); System.Console.WriteLine("4"); //foreach (var id in model.ProvinceId) //{ var centralpolicyprovincedata = new CentralPolicyProvince { ProvinceId = model.ProvinceId, CentralPolicyId = centralpolicydata.Id, }; _context.CentralPolicyProvinces.Add(centralpolicyprovincedata); _context.SaveChanges(); //var inspectionplaneventdata = new InspectionPlanEvent //{ // StartDate = model.StartDate, // EndDate = model.EndDate, // ProvinceId = model.ProvinceId, // CreatedAt = date, // CreatedBy = model.UserID, //}; //_context.InspectionPlanEvents.Add(inspectionplaneventdata); //_context.SaveChanges(); var ElectronicBookdata = new ElectronicBook { CreatedBy = model.UserID, Status = "ร่างกำหนดการ", }; _context.ElectronicBooks.Add(ElectronicBookdata); _context.SaveChanges(); System.Console.WriteLine("3"); var ElectronicBookGroupdata = new ElectronicBookGroup { CentralPolicyProvinceId = centralpolicyprovincedata.Id, ElectronicBookId = ElectronicBookdata.Id, }; _context.ElectronicBookGroups.Add(ElectronicBookGroupdata); _context.SaveChanges(); var centralpolicyeventdata = new CentralPolicyEvent { CentralPolicyId = centralpolicydata.Id, InspectionPlanEventId = model.InspectionPlanEventId, ElectronicBookId = ElectronicBookdata.Id, }; _context.CentralPolicyEvents.Add(centralpolicyeventdata); _context.SaveChanges(); //} }
public async Task <IActionResult> Post([FromForm] ElectronicBookViewModel model) { var test1 = model.Detail; //var test2 = model.UserId; System.Console.WriteLine("Detail: " + test1); //System.Console.WriteLine("UserId: " + test2); var ElectronicBookdata = new ElectronicBook { Detail = model.Detail, Problem = model.Problem, Suggestion = model.Suggestion, CreatedBy = model.id, Status = model.Status }; System.Console.WriteLine("1"); _context.ElectronicBooks.Add(ElectronicBookdata); _context.SaveChanges(); System.Console.WriteLine("2"); //var CentralPolicyId = model.CentralPolicyId; //var ProvinceId = model.ProvinceId; //System.Console.WriteLine("CentralPolicyId" + CentralPolicyId); //System.Console.WriteLine("ProvinceId" + ProvinceId); //System.Console.WriteLine("3"); //var centralpolicyprovinceid = _context.CentralPolicyProvinces // .Where(m => m.CentralPolicyId == CentralPolicyId) // .Where(m => m.ProvinceId == ProvinceId) // .Select(m => m.Id).First(); //var SubjectCentralPolicyProvincesdatas = _context.SubjectCentralPolicyProvinces // .Where(m => m.CentralPolicyProvinceId == centralpolicyprovinceid).ToList(); //foreach (var itemProvincialDepartmentId in model.ProvincialDepartmentId) //{ // foreach (var SubjectCentralPolicyProvincesdata in SubjectCentralPolicyProvincesdatas) // { // var SubjectCentralPolicyProvinceGroupdata = new SubjectCentralPolicyProvinceGroup // { // ProvincialDepartmentId = itemProvincialDepartmentId, // SubjectCentralPolicyProvinceId = SubjectCentralPolicyProvincesdata.Id // }; // _context.SubjectCentralPolicyProvinceGroups.Add(SubjectCentralPolicyProvinceGroupdata); // _context.SaveChanges(); // } //} //System.Console.WriteLine("3.5" + centralpolicyprovinceid); var centralPolicyID = _context.CentralPolicyProvinces .Where(x => x.CentralPolicyId == model.CentralPolicyId) .Select(x => x.Id) .FirstOrDefault(); System.Console.WriteLine("CentralPolicyProvince: " + centralPolicyID); var ElectronicBookgroupdata = new ElectronicBookGroup { ElectronicBookId = ElectronicBookdata.Id, CentralPolicyProvinceId = centralPolicyID }; _context.ElectronicBookGroups.Add(ElectronicBookgroupdata); _context.SaveChanges(); //System.Console.WriteLine("3.8"); //foreach (var itemUserPeopleId in model.UserPeopleId) //{ // var CentralPolicyGroupdata = new CentralPolicyGroup // { // }; // _context.CentralPolicyGroups.Add(CentralPolicyGroupdata); // _context.SaveChanges(); // System.Console.WriteLine("3.9"); // System.Console.WriteLine("USERPeople: " + itemUserPeopleId); // var CentralPolicyUserdata = new CentralPolicyUser // { // CentralPolicyId = CentralPolicyId, // ProvinceId = ProvinceId, // ElectronicBookId = ElectronicBookdata.Id, // CentralPolicyGroupId = CentralPolicyGroupdata.Id, // UserId = itemUserPeopleId, // Status = "รอการตอบรับ", // DraftStatus = model.Status // }; // _context.CentralPolicyUsers.Add(CentralPolicyUserdata); // _context.SaveChanges(); //} //System.Console.WriteLine("4"); //foreach (var itemUserMinistryId in model.UserMinistryId) //{ // var CentralPolicyGroupdata2 = new CentralPolicyGroup // { // }; // _context.CentralPolicyGroups.Add(CentralPolicyGroupdata2); // _context.SaveChanges(); // System.Console.WriteLine("5"); // var CentralPolicyUserdata2 = new CentralPolicyUser // { // CentralPolicyId = CentralPolicyId, // ProvinceId = ProvinceId, // ElectronicBookId = ElectronicBookdata.Id, // CentralPolicyGroupId = CentralPolicyGroupdata2.Id, // UserId = itemUserMinistryId, // Status = "รอการตอบรับ", // DraftStatus = model.Status // }; // _context.CentralPolicyUsers.Add(CentralPolicyUserdata2); // _context.SaveChanges(); // System.Console.WriteLine("6"); //} System.Console.WriteLine("Start Upload"); if (!Directory.Exists(_environment.WebRootPath + "//Uploads//")) { Directory.CreateDirectory(_environment.WebRootPath + "//Uploads//"); //สร้าง Folder Upload ใน wwwroot } //var BaseUrl = url.ActionContext.HttpContext.Request.Scheme; // path ที่เก็บไฟล์ var filePath = _environment.WebRootPath + "//Uploads//"; if (model.files != null) { System.Console.WriteLine("Start Upload 2"); foreach (var formFile in model.files.Select((value, index) => new { Value = value, Index = index })) //foreach (var formFile in data.files) { System.Console.WriteLine("Start Upload 3"); var random = RandomString(10); string filePath2 = formFile.Value.FileName; string filename = Path.GetFileName(filePath2); string ext = Path.GetExtension(filename); if (formFile.Value.Length > 0) { System.Console.WriteLine("Start Upload 4"); // using (var stream = System.IO.File.Create(filePath + formFile.Value.FileName)) using (var stream = System.IO.File.Create(filePath + random + filename)) { await formFile.Value.CopyToAsync(stream); } System.Console.WriteLine("Start Upload 4.1"); var ElectronicBookFile = new ElectronicBookFile { ElectronicBookId = ElectronicBookdata.Id, Name = random + filename, }; System.Console.WriteLine("Start Upload 4.2"); _context.ElectronicBookFiles.Add(ElectronicBookFile); _context.SaveChanges(); System.Console.WriteLine("Start Upload 4.3"); } System.Console.WriteLine("Start Upload 5"); } } return(Ok(new { status = true })); }