public object Post(long centralpolicyid, long provincevalue) { var centralpolicyprovince = _context.CentralPolicyProvinces .Where(m => m.ProvinceId == provincevalue) .Where(m => m.CentralPolicyId == centralpolicyid).FirstOrDefault(); var Subjectdatas = _context.Subjects .Where(m => m.CentralPolicyId == centralpolicyid).ToList(); var SubjectCentralPolicyProvincescheck = _context.SubjectCentralPolicyProvinces .Where(m => m.CentralPolicyProvinceId == centralpolicyprovince.Id).Count(); if (SubjectCentralPolicyProvincescheck > 0) { return(centralpolicyprovince.Id); } else { foreach (var Subjectdata in Subjectdatas) { Console.WriteLine("TEST: " + Subjectdata.Name); Console.WriteLine("TEST2: " + centralpolicyprovince.Id); var SubjectCentralPolicyProvinceData = new SubjectCentralPolicyProvince { CentralPolicyProvinceId = centralpolicyprovince.Id, Name = Subjectdata.Name }; _context.SubjectCentralPolicyProvinces.Add(SubjectCentralPolicyProvinceData); _context.SaveChanges(); Console.WriteLine("TEST3: " + Subjectdata.Id); var subjectdatedatas = _context.SubjectDates .Where(m => m.SubjectId == Subjectdata.Id).FirstOrDefault(); Console.WriteLine("TEST4: " + subjectdatedatas.CentralPolicyDateId); var centralpolicydatedatas = _context.CentralPolicyDates .Where(m => m.Id == subjectdatedatas.CentralPolicyDateId).ToList(); //Console.WriteLine("TEST5: " + centralpolicydatedatas.Id); Console.WriteLine("TEST6: " + SubjectCentralPolicyProvinceData.Id); foreach (var centralpolicydatedata in centralpolicydatedatas) { var CentralPolicyDateProvincedatas = new CentralPolicyDateProvince { StartDate = centralpolicydatedata.StartDate, EndDate = centralpolicydatedata.EndDate }; _context.CentralPolicyDateProvinces.Add(CentralPolicyDateProvincedatas); _context.SaveChanges(); var subjectdatecentralpolicyprovincedata = new SubjectDateCentralPolicyProvince { SubjectCentralPolicyProvinceId = SubjectCentralPolicyProvinceData.Id, CentralPolicyDateProvinceId = CentralPolicyDateProvincedatas.Id }; _context.SubjectDateCentralPolicyProvinces.Add(subjectdatecentralpolicyprovincedata); _context.SaveChanges(); } var Subquestiondatas = _context.Subquestions .Where(m => m.SubjectId == Subjectdata.Id).ToList(); foreach (var Subquestiondata in Subquestiondatas) { var SubquestionCentralPolicyProvincedata = new SubquestionCentralPolicyProvince { SubjectCentralPolicyProvinceId = SubjectCentralPolicyProvinceData.Id, Name = Subquestiondata.Name, Type = Subquestiondata.Type }; _context.SubquestionCentralPolicyProvinces.Add(SubquestionCentralPolicyProvincedata); _context.SaveChanges(); var Subquestiondatachoices = _context.SubquestionChoices .Where(m => m.SubquestionId == Subquestiondata.Id).ToList(); foreach (var Subquestiondatachoice in Subquestiondatachoices) { var SubquestionChoiceCentralPolicyProvincedata = new SubquestionChoiceCentralPolicyProvince { SubquestionCentralPolicyProvinceId = SubquestionCentralPolicyProvincedata.Id, Name = Subquestiondatachoice.Name, }; _context.SubquestionChoiceCentralPolicyProvinces.Add(SubquestionChoiceCentralPolicyProvincedata); _context.SaveChanges(); } } } _context.SaveChanges(); return(centralpolicyprovince.Id); } }
public IActionResult Post([FromBody] InspectionPlanViewModel model) { var userdata = _context.Users .Where(m => m.Id == model.UserID) //.Select(m => m.Role_id) .FirstOrDefault(); System.Console.WriteLine("FiscalYearId" + model.FiscalYearId); var year = _context.FiscalYearNew .Where(m => m.Year == model.FiscalYearId).FirstOrDefault(); System.Console.WriteLine("year" + year.Id); //if(year == null) //{ //} //var test = model.UserID; //System.Console.WriteLine(test); System.Console.WriteLine("111"); var date = DateTime.Now; System.Console.WriteLine("222" + model.Type); var centralpolicydata = new CentralPolicy { Title = model.Title, TypeexaminationplanId = 3, FiscalYearNewId = year.Id, 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, Step = "มอบหมายหน่วยงาน", Status = "ร่างกำหนดการ" }; _context.CentralPolicyProvinces.Add(centralpolicyprovincedata); _context.SaveChanges(); /////////////////////////////// var SubjectGroupdata = new SubjectGroup { CentralPolicyId = centralpolicydata.Id, ProvinceId = model.ProvinceId, Type = "Master", Land = "Master", Status = "Master", StatusSuggestion = "ร่างกำหนดการ", ProvincialDepartmentIdCreatedBy = userdata.ProvincialDepartmentId, CreatedBy = userdata.Id, RoleCreatedBy = userdata.Role_id, }; _context.SubjectGroups.Add(SubjectGroupdata); _context.SaveChanges(); /////////////////////////////// /// var subjectdata = new SubjectCentralPolicyProvince { Name = model.Title, CentralPolicyProvinceId = centralpolicyprovincedata.Id, Type = "Master", Status = "ใช้งานจริง", SubjectGroupId = SubjectGroupdata.Id, CreatedBy = model.UserID, }; _context.SubjectCentralPolicyProvinces.Add(subjectdata); _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, HaveSubject = 0, StartDate = model.StartDate, EndDate = model.EndDate, //ElectronicBookId = ElectronicBookdata.Id, }; _context.CentralPolicyEvents.Add(centralpolicyeventdata); _context.SaveChanges(); var logdata = new Log { UserId = model.UserID, DatabaseName = "CentralPolicyEvent", EventType = "เพิ่ม", EventDate = date, Detail = "เพิ่มแผนตรวจราชการในกำหนดการตรวจราชการ", Allid = centralpolicyeventdata.Id, }; _context.Logs.Add(logdata); _context.SaveChanges(); //} return(Ok(new { status = true })); }
public IActionResult Post([FromBody] SubjectViewModel model) { long GetSubjectID = 0; List <object> termsList = new List <object>(); //var subjectdata = new Subject //{ // Name = model.Name, // CentralPolicyId = model.CentralPolicyId, // Answer = model.Answer, //}; //_context.Subjects.Add(subjectdata); //_context.SaveChanges(); //foreach (var id in model.CentralPolicyDateId) //{ // var subjectdatedata = new SubjectDate // { // SubjectId = subjectdata.Id, // CentralPolicyDateId = id // }; // _context.SubjectDates.Add(subjectdatedata); //} //_context.SaveChanges(); //foreach (var questionopen in model.inputquestionopen) //{ // var Subquestionopendata = new Subquestion // { // SubjectId = subjectdata.Id, // Name = questionopen.questionopen, // Type = "คำถามปลายเปิด" // }; // _context.Subquestions.Add(Subquestionopendata); //} //_context.SaveChanges(); //foreach (var questionclose in model.inputquestionclose) //{ // var Subquestionclosedata = new Subquestion // { // SubjectId = subjectdata.Id, // Name = questionclose.questionclose, // Type = "คำถามปลายปิด" // }; // _context.Subquestions.Add(Subquestionclosedata); // _context.SaveChanges(); // foreach (var questionclosechoice in questionclose.inputanswerclose) // { // var Subquestionchoiceclosedata = new SubquestionChoice // { // SubquestionId = Subquestionclosedata.Id, // Name = questionclosechoice.answerclose, // }; // _context.SubquestionChoices.Add(Subquestionchoiceclosedata); // _context.SaveChanges(); // } //} long subjectid = 0; var n = 0; long box = -1; foreach (var departmentId in model.inputsubjectdepartment) { //System.Console.WriteLine("In1"); var provincialdepartmentprovicedata = _context.ProvincialDepartmentProvince .Where(m => m.ProvincialDepartmentID == departmentId.departmentId) .Select(x => x.ProvinceId) .ToList(); foreach (var provinceId in provincialdepartmentprovicedata) { System.Console.WriteLine("all" + provinceId); var centralpolicyprovinceData = _context.CentralPolicyProvinces .Where(x => x.ProvinceId == provinceId && x.CentralPolicyId == model.CentralPolicyId) .FirstOrDefault(); //System.Console.WriteLine("have" + centralpolicyprovinceData.ProvinceId); if (centralpolicyprovinceData != null) { System.Console.WriteLine("have" + centralpolicyprovinceData.ProvinceId); if (n == 0) { var subjectdata = new SubjectCentralPolicyProvince { Name = model.Name, CentralPolicyProvinceId = centralpolicyprovinceData.Id, Type = "Master", Status = model.Status }; _context.SubjectCentralPolicyProvinces.Add(subjectdata); _context.SaveChanges(); subjectid = subjectdata.Id; GetSubjectID = subjectid; //file } //var SubjectCentralPolicyProvinceGroupdata = new SubjectCentralPolicyProvinceGroup //{ // ProvincialDepartmentId = departmentId.departmentId, // //SubjectCentralPolicyProvinceId = subjectid, //}; //_context.SubjectCentralPolicyProvinceGroups.Add(SubjectCentralPolicyProvinceGroupdata); //_context.SaveChanges(); if (n == 0) { foreach (var id in model.CentralPolicyDateId) { //System.Console.WriteLine("In3"); var CentralPolicyDatedata = _context.CentralPolicyDates .Where(m => m.Id == id).FirstOrDefault(); var CentralPolicyDateProvincedata = new CentralPolicyDateProvince { StartDate = CentralPolicyDatedata.StartDate, EndDate = CentralPolicyDatedata.EndDate }; _context.CentralPolicyDateProvinces.Add(CentralPolicyDateProvincedata); _context.SaveChanges(); var subjectdatedata = new SubjectDateCentralPolicyProvince { SubjectCentralPolicyProvinceId = subjectid, CentralPolicyDateProvinceId = CentralPolicyDateProvincedata.Id, }; _context.SubjectDateCentralPolicyProvinces.Add(subjectdatedata); } _context.SaveChanges(); } var test = departmentId.inputquestionopen; foreach (var data in model.inputsubjectdepartment) { System.Console.WriteLine("TEST: " + data.inputquestionopen); } //long boxcheck = departmentId.box; if (box != departmentId.box) { foreach (var questionopen in departmentId.inputquestionopen) { System.Console.WriteLine("TEST: " + questionopen.questionopen); var Subquestionopendata = new SubquestionCentralPolicyProvince { SubjectCentralPolicyProvinceId = subjectid, Name = questionopen.questionopen, Type = "คำถามปลายเปิด", Box = departmentId.box }; _context.SubquestionCentralPolicyProvinces.Add(Subquestionopendata); _context.SaveChanges(); foreach (var box2 in model.inputsubjectdepartment) { if (box2.box == departmentId.box) { var SubjectCentralPolicyProvinceGroupdata = new SubjectCentralPolicyProvinceGroup { ProvincialDepartmentId = box2.departmentId, SubquestionCentralPolicyProvinceId = Subquestionopendata.Id, }; _context.SubjectCentralPolicyProvinceGroups.Add(SubjectCentralPolicyProvinceGroupdata); _context.SaveChanges(); } } } foreach (var questionclose in departmentId.inputquestionclose) { var Subquestionclosedata = new SubquestionCentralPolicyProvince { SubjectCentralPolicyProvinceId = subjectid, Name = questionclose.questionclose, Type = "คำถามปลายปิด", Box = departmentId.box }; _context.SubquestionCentralPolicyProvinces.Add(Subquestionclosedata); _context.SaveChanges(); foreach (var box2 in model.inputsubjectdepartment) { if (box2.box == departmentId.box) { var SubjectCentralPolicyProvinceGroupdata2 = new SubjectCentralPolicyProvinceGroup { ProvincialDepartmentId = box2.departmentId, SubquestionCentralPolicyProvinceId = Subquestionclosedata.Id, }; _context.SubjectCentralPolicyProvinceGroups.Add(SubjectCentralPolicyProvinceGroupdata2); _context.SaveChanges(); } } foreach (var questionclosechoice in questionclose.inputanswerclose) { var Subquestionchoiceclosedata = new SubquestionChoiceCentralPolicyProvince { SubquestionCentralPolicyProvinceId = Subquestionclosedata.Id, Name = questionclosechoice.answerclose, }; _context.SubquestionChoiceCentralPolicyProvinces.Add(Subquestionchoiceclosedata); _context.SaveChanges(); } } } box = departmentId.box; n++; //} } } // return subjectdata; } if (model.Status == "ใช้งานจริง") { foreach (var departmentId in model.inputsubjectdepartment) { //System.Console.WriteLine("In1"); var provincialdepartmentprovicedata = _context.ProvincialDepartmentProvince .Where(m => m.ProvincialDepartmentID == departmentId.departmentId) .Select(x => x.ProvinceId) .ToList(); foreach (var provinceId in provincialdepartmentprovicedata) { System.Console.WriteLine("all" + provinceId); var centralpolicyprovinceData = _context.CentralPolicyProvinces .Where(x => x.ProvinceId == provinceId && x.CentralPolicyId == model.CentralPolicyId) .FirstOrDefault(); //System.Console.WriteLine("have" + centralpolicyprovinceData.ProvinceId); if (centralpolicyprovinceData != null) { var subjectdata = new SubjectCentralPolicyProvince { Name = model.Name, CentralPolicyProvinceId = centralpolicyprovinceData.Id, Type = "NoMaster", Status = model.Status, //Step = "หมอบหมายให้เขต", //link = "https://localhost:5001/answersubject/outsider/" }; _context.SubjectCentralPolicyProvinces.Add(subjectdata); _context.SaveChanges(); termsList.Add(subjectdata.Id); //long test2 = subjectdata.Id; //GetSubjectID = test2; //var SubjectCentralPolicyProvinceGroupdata = new SubjectCentralPolicyProvinceGroup //{ // ProvincialDepartmentId = departmentId.departmentId, // //SubjectCentralPolicyProvinceId = subjectdata.Id, //}; //_context.SubjectCentralPolicyProvinceGroups.Add(SubjectCentralPolicyProvinceGroupdata); //_context.SaveChanges(); foreach (var id in model.CentralPolicyDateId) { //System.Console.WriteLine("In3"); var CentralPolicyDatedata = _context.CentralPolicyDates .Where(m => m.Id == id).FirstOrDefault(); var CentralPolicyDateProvincedata = new CentralPolicyDateProvince { StartDate = CentralPolicyDatedata.StartDate, EndDate = CentralPolicyDatedata.EndDate }; _context.CentralPolicyDateProvinces.Add(CentralPolicyDateProvincedata); _context.SaveChanges(); var subjectdatedata = new SubjectDateCentralPolicyProvince { SubjectCentralPolicyProvinceId = subjectdata.Id, CentralPolicyDateProvinceId = CentralPolicyDateProvincedata.Id, }; _context.SubjectDateCentralPolicyProvinces.Add(subjectdatedata); } _context.SaveChanges(); var test = departmentId.inputquestionopen; foreach (var data in model.inputsubjectdepartment) { System.Console.WriteLine("TEST: " + data.inputquestionopen); } foreach (var questionopen in model.inputsubjectdepartment[0].inputquestionopen) { System.Console.WriteLine("TEST: " + questionopen.questionopen); var Subquestionopendata = new SubquestionCentralPolicyProvince { SubjectCentralPolicyProvinceId = subjectdata.Id, Name = questionopen.questionopen, Type = "คำถามปลายเปิด" }; _context.SubquestionCentralPolicyProvinces.Add(Subquestionopendata); _context.SaveChanges(); var SubjectCentralPolicyProvinceGroupdata = new SubjectCentralPolicyProvinceGroup { ProvincialDepartmentId = departmentId.departmentId, SubquestionCentralPolicyProvinceId = Subquestionopendata.Id, }; _context.SubjectCentralPolicyProvinceGroups.Add(SubjectCentralPolicyProvinceGroupdata); _context.SaveChanges(); foreach (var questionclose in departmentId.inputquestionclose) { var Subquestionclosedata = new SubquestionCentralPolicyProvince { SubjectCentralPolicyProvinceId = subjectdata.Id, Name = questionclose.questionclose, Type = "คำถามปลายปิด" }; _context.SubquestionCentralPolicyProvinces.Add(Subquestionclosedata); _context.SaveChanges(); var SubjectCentralPolicyProvinceGroupdata2 = new SubjectCentralPolicyProvinceGroup { ProvincialDepartmentId = departmentId.departmentId, SubquestionCentralPolicyProvinceId = Subquestionclosedata.Id, }; _context.SubjectCentralPolicyProvinceGroups.Add(SubjectCentralPolicyProvinceGroupdata2); _context.SaveChanges(); foreach (var questionclosechoice in questionclose.inputanswerclose) { var Subquestionchoiceclosedata = new SubquestionChoiceCentralPolicyProvince { SubquestionCentralPolicyProvinceId = Subquestionclosedata.Id, Name = questionclosechoice.answerclose, }; _context.SubquestionChoiceCentralPolicyProvinces.Add(Subquestionchoiceclosedata); _context.SaveChanges(); } } } } } //return subjectdata; } } return(Ok(new { GetSubjectID, termsList })); }