public IActionResult activefiscalyear([FromForm] Setinspectionarea model)
{
var fiscalyeainactive = _context.FiscalYears.Where(m => m.Id != model.Id);
foreach (var Item in fiscalyeainactive)
{
var data = _context.FiscalYears.Find(Item.Id);
{
data.Active = 0;
};
_context.Entry(data).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
_context.SaveChanges();
var fiscalyea = _context.FiscalYears.Find(model.Id);
{
fiscalyea.Active = 1;
};
_context.Entry(fiscalyea).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(Ok(new { Id = model.Id }));
}
public async Task <IActionResult> Post([FromForm] Setinspectionarea model)
{
var date = DateTime.Now;
var fiscalyeardata = new FiscalYear
{
Year = model.Year,
StartDate = model.StartDate,
EndDate = model.EndDate,
Orderdate = model.Orderdate,
CreatedAt = date,
Active = 0
};
_context.FiscalYears.Add(fiscalyeardata);
_context.SaveChanges();
if (!Directory.Exists(_environment.WebRootPath + "//Setinspectionareafile//"))
{
Directory.CreateDirectory(_environment.WebRootPath + "//Setinspectionareafile//"); //สร้าง Folder Upload ใน wwwroot
}
var filePath = _environment.WebRootPath + "//Setinspectionareafile//";
if (model.files != null)
{
foreach (var formFile in model.files.Select((value, index) => new { Value = value, Index = index }))
{
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 + random + filename))
{
await formFile.Value.CopyToAsync(stream);
}
var SetinspectionareaFile = new SetinspectionareaFile
{
FiscalYearId = fiscalyeardata.Id,
Name = random + filename,
CreatedAt = date
};
_context.SetinspectionareaFiles.Add(SetinspectionareaFile);
_context.SaveChanges();
}
}
System.Console.WriteLine("testuser : 2");
}
return(Ok(new { id = fiscalyeardata.Id, title = model.Year }));
}
