//[6][1] 입력
public async Task <CommonValue> AddAsync(CommonValue model)
{
#region CommonValue 기능 추가
// 현재테이블의 Ref의 Max값 가져오기
int maxRef = 1;
int?max = _context.CommonValues.Max(m => m.Ref);
if (max.HasValue)
{
maxRef = (int)max + 1;
}
model.Ref = maxRef;
model.Step = 0;
model.RefOrder = 0;
#endregion
try
{
_context.CommonValues.Add(model);
await _context.SaveChangesAsync();
}
catch (Exception e)
{
_logger.LogError($"ERROR({nameof(AddAsync)}): {e.Message}");
}
return(model);
}
//[6][4] 수정
public async Task <bool> EditAsync(CommonValue model)
{
try
{
_context.CommonValues.Attach(model);
_context.Entry(model).State = EntityState.Modified;
return(await _context.SaveChangesAsync() > 0 ? true : false);
}
catch (Exception e)
{
_logger.LogError($"ERROR({nameof(EditAsync)}): {e.Message}");
}
return(false);
}
public async Task <ArticleSet <CommonValue, int> > GetArticles <TParentIdentifier>(int pageIndex, int pageSize, string searchField, string searchQuery, string sortOrder, TParentIdentifier parentIdentifier)
{
// Default Values
if (!_context.CommonValues.Any())
{
var model = new CommonValue()
{
Name = " ", Category = "Projects", SubCategory = "Vetting Steps", VariableText = "# of Signers", VariableValue = "2"
};
await AddAsync(model);
_context.SaveChanges();
}
//var items = from m in _context.CommonValues select m; // 쿼리 구문(Query Syntax)
var items = _context.CommonValues.Select(m => m); // 메서드 구문(Method Syntax)
// ParentBy
if (parentIdentifier is int parentId && parentId != 0)
{
items = items.Where(m => m.ParentId == parentId);
}