public async Task <VmGenericServiceResult> Update(VmCodeTableItem vmCodeTableItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
CodeTable r = await repo.Get(vmCodeTableItem.Id);
Copy <VmCodeTableItem, CodeTable>(vmCodeTableItem, r);
if (r.UpdatedBy.IsNullOrEmpty())
{
r.UpdatedBy = "System";
}
repo.Update(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmCodeTableItem> GetObject(int id)
{
VmCodeTableItem result = new VmCodeTableItem();
var dbCatList = await repoCate.GetAll();
if (dbCatList == null)
{
return(result);
}
result.CodeCategoryList = new List <VmCodeCategoryItem>();
foreach (var dbcat in dbCatList)
{
VmCodeCategoryItem cat = new VmCodeCategoryItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
result.CodeCategoryList.Add(cat);
}
return(result);
}
public VmGenericServiceResult Insert(VmCodeTableItem vmCodeTableItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
CodeTable r = new CodeTable();
Copy <VmCodeTableItem, CodeTable>(vmCodeTableItem, r);
r.CodeCategory_Id = (int)vmCodeTableItem.CodeCategory_Id;
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmDocumentItem> GetDocumentById(int Id)
{
var dbPageResult = await documentRepo.Get(Id);
if (dbPageResult == null)
{
return(new VmDocumentItem());
}
var resultObj = new VmDocumentItem();
Copy <Com.BudgetMetal.DBEntities.Document, VmDocumentItem>(dbPageResult, resultObj);
var dbCodeTableList = await codeTableRepo.GetAll();
if (dbCodeTableList == null)
{
return(resultObj);
}
resultObj.DocumentStatusList = new List <VmCodeTableItem>();
resultObj.DocumentTypeList = new List <VmCodeTableItem>();
foreach (var dbcat in dbCodeTableList)
{
VmCodeTableItem documentStatusandType = new VmCodeTableItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
resultObj.DocumentStatusList.Add(documentStatusandType);
resultObj.DocumentTypeList.Add(documentStatusandType);
}
var dbCompanyList = await companyRepo.GetAll();
if (dbCompanyList == null)
{
return(resultObj);
}
resultObj.CompanyList = new List <VmCompanyItem>();
foreach (var dbcat in dbCompanyList)
{
VmCompanyItem company = new VmCompanyItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
resultObj.CompanyList.Add(company);
}
return(resultObj);
}
public ActionResult Create(VmCodeTableItem codeTableItem)
{
var result = svs.Insert(codeTableItem);
if (result.IsSuccess)
{
return(RedirectToAction(nameof(Index)));
}
else
{
return(View(codeTableItem));
}
}
public async Task <VmDocumentItem> GetFormObject()
{
VmDocumentItem resultObj = new VmDocumentItem();
var dbCodeTableList = await codeTableRepo.GetAll();
if (dbCodeTableList == null)
{
return(resultObj);
}
resultObj.DocumentStatusList = new List <VmCodeTableItem>();
resultObj.DocumentTypeList = new List <VmCodeTableItem>();
foreach (var dbcat in dbCodeTableList)
{
VmCodeTableItem documentStatusandType = new VmCodeTableItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
resultObj.DocumentStatusList.Add(documentStatusandType);
resultObj.DocumentTypeList.Add(documentStatusandType);
}
var dbCompanyList = await companyRepo.GetAll();
if (dbCompanyList == null)
{
return(resultObj);
}
resultObj.CompanyList = new List <VmCompanyItem>();
foreach (var dbcat in dbCompanyList)
{
VmCompanyItem company = new VmCompanyItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
resultObj.CompanyList.Add(company);
}
return(resultObj);
}
public async Task <ActionResult> Edit(int id, VmCodeTableItem codeTableItem)
{
if (id != codeTableItem.Id)
{
return(NotFound());
}
var result = await svs.Update(codeTableItem);
if (result.IsSuccess)
{
return(RedirectToAction(nameof(Index)));
}
else
{
return(View(codeTableItem));
}
}
public async Task <VmCodeTablePage> GetCodeTableByPage(string keyword, int page, int totalRecords)
{
var dbPageResult = await repo.GetPage(keyword,
(page == 0 ? Constants.app_firstPage : page),
(totalRecords == 0 ? Constants.app_totalRecords : totalRecords));
//var dbPageResult = repo.GetCodeTableByPage(keyword,
// (page == 0 ? Constants.app_firstPage : page),
// (totalRecords == 0 ? Constants.app_totalRecords : totalRecords));
if (dbPageResult == null)
{
return(new VmCodeTablePage());
}
var resultObj = new VmCodeTablePage();
resultObj.RequestId = DateTime.Now.ToString("yyyyMMddHHmmss");
resultObj.RequestDate = DateTime.Now;
resultObj.Result = new PageResult <VmCodeTableItem>();
resultObj.Result.Records = new List <VmCodeTableItem>();
Copy <PageResult <CodeTable>, PageResult <VmCodeTableItem> >(dbPageResult, resultObj.Result, new string[] { "Records" });
foreach (var dbItem in dbPageResult.Records)
{
var resultItem = new VmCodeTableItem();
Copy <CodeTable, VmCodeTableItem>(dbItem, resultItem);
if (dbItem.CodeCategory != null)
{
resultItem.CodeCategory = new ViewModels.CodeCategory.VmCodeCategoryItem()
{
Name = dbItem.CodeCategory.Name
};
}
resultObj.Result.Records.Add(resultItem);
}
return(resultObj);
}
public async Task <VmCodeTableItem> GetCodeTableById(int Id)
{
var dbPageResult = await repo.Get(Id);
if (dbPageResult == null)
{
return(new VmCodeTableItem());
}
var resultObj = new VmCodeTableItem();
Copy <CodeTable, VmCodeTableItem>(dbPageResult, resultObj);
var dbCatList = await repoCate.GetAll();
if (dbCatList == null)
{
return(resultObj);
}
resultObj.CodeCategoryList = new List <VmCodeCategoryItem>();
foreach (var dbcat in dbCatList)
{
VmCodeCategoryItem cat = new VmCodeCategoryItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
resultObj.CodeCategoryList.Add(cat);
}
//
return(resultObj);
}
public async Task <VmUserItem> GetFormObject()
{
VmUserItem result = new VmUserItem();
var dbCList = await cRepo.GetAll();
//filter with companyId
var dbCCList = await CTrepo.GetAll();
var dbRoleList = await roleRepo.GetAll();
if (dbCList == null && dbCCList == null && dbRoleList == null)
{
return(result);
}
if (dbCList != null)
{
result.CompanyList = new List <VmCompanyItem>();
foreach (var dbcat in dbCList)
{
VmCompanyItem _company = new VmCompanyItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
result.CompanyList.Add(_company);
}
}
if (dbCCList != null)
{
result.CodeTableList = new List <VmCodeTableItem>();
foreach (var dbcat in dbCCList)
{
VmCodeTableItem _codeTable = new VmCodeTableItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
result.CodeTableList.Add(_codeTable);
}
}
if (dbRoleList != null)
{
result.RoleList = new List <VmRoleItem>();
foreach (var item in dbRoleList)
{
VmRoleItem _roleItem = new VmRoleItem()
{
Id = item.Id,
Name = item.Name
};
result.RoleList.Add(_roleItem);
}
}
return(result);
}
public async Task <VmUserItem> GetUserById(int Id)
{
var dbPageResult = await repo.GetUserById(Id);
if (dbPageResult == null)
{
return(new VmUserItem());
}
var result = new VmUserItem();
Copy <Com.BudgetMetal.DBEntities.User, VmUserItem>(dbPageResult, result);
var dbCList = await cRepo.GetAll();
//filter with companyId
var dbCCList = await CTrepo.GetAll();
var dbRoleList = await roleRepo.GetAll();
if (dbCList == null && dbCCList == null && dbRoleList == null)
{
return(result);
}
if (dbCList != null)
{
result.CompanyList = new List <VmCompanyItem>();
foreach (var dbcat in dbCList)
{
VmCompanyItem _company = new VmCompanyItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
result.CompanyList.Add(_company);
}
}
if (dbCCList != null)
{
result.CodeTableList = new List <VmCodeTableItem>();
foreach (var dbcat in dbCCList)
{
VmCodeTableItem _codeTable = new VmCodeTableItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
result.CodeTableList.Add(_codeTable);
}
}
if (dbRoleList != null)
{
result.RoleList = new List <VmRoleItem>();
foreach (var item in dbRoleList)
{
VmRoleItem _roleItem = new VmRoleItem()
{
Id = item.Id,
Name = item.Name
};
result.RoleList.Add(_roleItem);
}
}
if (dbPageResult.UserRoles != null)
{
if (dbPageResult.UserRoles.Count > 0)
{
result.SelectedRoleId = new List <int>();
foreach (var item in dbPageResult.UserRoles)
{
int roleId = item.Role_Id;
result.SelectedRoleId.Add(roleId);
}
}
else
{
//Add zero
result.SelectedRoleId = new List <int>();
result.SelectedRoleId.Add(0);
}
}
return(result);
}
