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