public IActionResult Post(long SubjectCentralPolicyProvinceId, string Name, long Box, long[] departmentId) { System.Console.WriteLine("in"); var Subquestionopendata = new SubquestionCentralPolicyProvince { SubjectCentralPolicyProvinceId = SubjectCentralPolicyProvinceId, Name = Name, Type = "คำถามปลายเปิด", Box = Box }; _context.SubquestionCentralPolicyProvinces.Add(Subquestionopendata); _context.SaveChanges(); foreach (var departmentIddata in departmentId) { System.Console.WriteLine("in2"); var SubjectCentralPolicyProvinceGroupdata = new SubjectCentralPolicyProvinceGroup { ProvincialDepartmentId = departmentIddata, SubquestionCentralPolicyProvinceId = Subquestionopendata.Id, }; _context.SubjectCentralPolicyProvinceGroups.Add(SubjectCentralPolicyProvinceGroupdata); _context.SaveChanges(); } return(Ok(new { status = true })); }
public IActionResult Post3(long SubjectCentralPolicyProvinceId, string Name, long Box, string[] answerclose) { System.Console.WriteLine("Start"); var Subquestionopendata = new SubquestionCentralPolicyProvince { SubjectCentralPolicyProvinceId = SubjectCentralPolicyProvinceId, Name = Name, Type = "คำถามปลายปิด", Box = Box, }; System.Console.WriteLine("in"); _context.SubquestionCentralPolicyProvinces.Add(Subquestionopendata); _context.SaveChanges(); var subquestiondata = _context.SubquestionCentralPolicyProvinces .Where(m => m.SubjectCentralPolicyProvinceId == SubjectCentralPolicyProvinceId).FirstOrDefault(); var SubjectCentralPolicyProvinceGroupdatas = _context.SubjectCentralPolicyProvinceGroups .Where(m => m.SubquestionCentralPolicyProvinceId == subquestiondata.Id).ToList(); foreach (var SubjectCentralPolicyProvinceGroupdata in SubjectCentralPolicyProvinceGroupdatas) { var SubjectCentralPolicyProvinceGroup = new SubjectCentralPolicyProvinceGroup { SubquestionCentralPolicyProvinceId = Subquestionopendata.Id, ProvincialDepartmentId = SubjectCentralPolicyProvinceGroupdata.ProvincialDepartmentId, }; _context.SubjectCentralPolicyProvinceGroups.Add(SubjectCentralPolicyProvinceGroup); _context.SaveChanges(); } foreach (var answerclosedata in answerclose) { System.Console.WriteLine("in3"); var Subquestionchoiceclosedata = new SubquestionChoiceCentralPolicyProvince { SubquestionCentralPolicyProvinceId = Subquestionopendata.Id, Name = answerclosedata }; _context.SubquestionChoiceCentralPolicyProvinces.Add(Subquestionchoiceclosedata); _context.SaveChanges(); } return(Ok(new { status = true })); }
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] 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 })); }