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 }));
}
