// GET: LoadFormats/EditFormatType
public async Task <IActionResult> EditFormatType(Guid productId, Guid loadFormatId,
string tableName, UploadFileTypes uploadFileType)
{
var formattypes = await(from r in _context.FormatTypes
where r.LoadFormatID == loadFormatId &&
r.TableName == tableName
orderby r.FieldLabel
select r).ToListAsync();
FormatTypesViewModel viewModel = new FormatTypesViewModel
{
ProductID = productId,
UploadFileType = uploadFileType,
FormatTypes = formattypes
};
return(View(viewModel));
}
// GET: FormatTypes
public async Task <IActionResult> Index(Guid loadFormatId, UploadFileTypes uploadFileType)
{
var tables = _context.FormatTypes
.Where(t => t.LoadFormatID == loadFormatId)
.Select(t => t.TableName).Distinct()
.ToList();
var _tablename = tables.FirstOrDefault();
var formattypes = await _context.FormatTypes
.Include(f => f.LoadFormat)
.AsNoTracking()
.OrderBy(c => c.FieldName)
.Where(f => f.LoadFormatID == loadFormatId &&
f.TableName == _tablename).ToListAsync();
FormatTypesViewModel viewModel = new FormatTypesViewModel
{
FormatTypes = formattypes,
UploadFileType = uploadFileType
};
return(View(viewModel));
}
