public async Task <IActionResult> Post([FromForm] CentralPolicyProvinceViewModel model)
{
//var eiei = model.StartDate;
//System.Console.WriteLine("test: " + eiei);
//return Ok(model);
var date = DateTime.Now;
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 = model.Class,
};
_context.CentralPolicies.Add(centralpolicydata);
_context.SaveChanges();
foreach (var id in model.ProvinceId)
{
var centralpolicyprovincedata = new CentralPolicyProvince
{
ProvinceId = id,
CentralPolicyId = centralpolicydata.Id,
Step = "มอบหมายเขต"
};
_context.CentralPolicyProvinces.Add(centralpolicyprovincedata);
}
_context.SaveChanges();
int index = 0;
int indexend = 0;
foreach (var item in model.StartDate2)
{
var CentralPolicyDate = new CentralPolicyDate
{
CentralPolicyId = centralpolicydata.Id,
StartDate = item,
//EndDate = item.EndDate,
};
_context.CentralPolicyDates.Add(CentralPolicyDate);
_context.SaveChanges();
var id = _context.CentralPolicyDates.Find(CentralPolicyDate.Id);
indexend = 0;
foreach (var itemend in model.EndDate2)
{
if (index == indexend)
{
id.EndDate = itemend;
System.Console.WriteLine("END: " + indexend);
}
indexend++;
}
index++;
System.Console.WriteLine("Start: " + index);
}
//int maxSize = Int32.Parse(ConfigurationManager.AppSettings["MaxFileSize"]);
//var size = data.files.Sum(f => f.Length);
//ตรวจสอบว่ามี Folder Upload ใน wwwroot มั้ย
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)
{
foreach (var formFile in model.files.Select((value, index) => new { Value = value, Index = index }))
//foreach (var formFile in data.files)
{
var random = RandomString(10);
string filePath2 = formFile.Value.FileName;
string filename = Path.GetFileName(filePath2);
string ext = Path.GetExtension(filename);
if (formFile.Value.Length > 0)
{
// 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);
}
var CentralPolicyFile = new CentralPolicyFile
{
CentralPolicyId = centralpolicydata.Id,
Name = random + filename,
};
_context.CentralPolicyFiles.Add(CentralPolicyFile);
_context.SaveChanges();
}
}
}
return(Ok(centralpolicydata.Id));
}
public async Task <IActionResult> Put([FromForm] CentralPolicyProvinceViewModel model, long editId)
{
//var eiei = model.StartDate;
System.Console.WriteLine("test: " + editId);
var user = model.UserID;
System.Console.WriteLine("User: "******"แผนการตรวจประจำปี";
};
//_context.CentralPolicies.Add(centralpolicydata);
_context.Entry(centralpolicydata).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
var delData = _context.CentralPolicyProvinces
.Where(x => x.CentralPolicyId == editId)
.ToList();
foreach (var del in delData)
{
_context.CentralPolicyProvinces.Remove(del);
}
_context.SaveChanges();
foreach (var id in model.ProvinceId)
{
System.Console.WriteLine("in2");
var centralpolicyprovincedata = new CentralPolicyProvince
{
ProvinceId = id,
CentralPolicyId = editId,
};
_context.CentralPolicyProvinces.Add(centralpolicyprovincedata);
//_context.Entry(centralpolicyprovincedata).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
_context.SaveChanges();
var deleteDate = _context.CentralPolicyDates
.Where(x => x.CentralPolicyId == editId)
.ToList();
foreach (var delDate in deleteDate)
{
_context.CentralPolicyDates.Remove(delDate);
}
_context.SaveChanges();
int index = 0;
int indexend = 0;
foreach (var item in model.StartDate2)
{
var CentralPolicyDate = new CentralPolicyDate
{
CentralPolicyId = centralpolicydata.Id,
StartDate = item
//EndDate = item.EndDate,
};
_context.CentralPolicyDates.Add(CentralPolicyDate);
//_context.Entry(CentralPolicyDate).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
var id = _context.CentralPolicyDates.Find(CentralPolicyDate.Id);
indexend = 0;
foreach (var itemend in model.EndDate2)
{
if (index == indexend)
{
id.EndDate = itemend;
System.Console.WriteLine("END: " + indexend);
}
indexend++;
}
index++;
_context.SaveChanges();
System.Console.WriteLine("Start: " + index);
}
System.Console.WriteLine("FINISH");
//if (model.files != null) {
// var delFile = _context.CentralPolicyFiles
// .Where(x => x.CentralPolicyId == editId)
// .ToList();
// foreach (var del in delFile)
// {
// _context.CentralPolicyFiles.Remove(del);
// }
// _context.SaveChanges();
// System.Console.WriteLine("in1");
//}
//int maxSize = Int32.Parse(ConfigurationManager.AppSettings["MaxFileSize"]);
//var size = data.files.Sum(f => f.Length);
//ตรวจสอบว่ามี Folder Upload ใน wwwroot มั้ย
if (!Directory.Exists(_environment.WebRootPath + "//Uploads//"))
{
System.Console.WriteLine("in2");
Directory.CreateDirectory(_environment.WebRootPath + "//Uploads//"); //สร้าง Folder Upload ใน wwwroot
}
//var BaseUrl = url.ActionContext.HttpContext.Request.Scheme;
// path ที่เก็บไฟล์
var filePath = _environment.WebRootPath + "//Uploads//";
System.Console.WriteLine("testJa: " + model.files);
if (model.files != null)
{
foreach (var formFile in model.files.Select((value, index) => new { Value = value, Index = index }))
//foreach (var formFile in data.files)
{
var random = RandomString(10);
System.Console.WriteLine("in3");
string filePath2 = formFile.Value.FileName;
string filename = Path.GetFileName(filePath2);
string ext = Path.GetExtension(filename);
if (formFile.Value.Length > 0)
{
System.Console.WriteLine("in4");
// 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);
}
var CentralPolicyFiledata = new CentralPolicyFile
{
CentralPolicyId = centralpolicydata.Id,
Name = random + filename,
};
_context.CentralPolicyFiles.Add(CentralPolicyFiledata);
System.Console.WriteLine("in5");
_context.SaveChanges();
System.Console.WriteLine("in6");
//_context.Entry(CentralPolicyFile).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
}
}
return(Ok(new { status = true }));
}
