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