public IActionResult Get(int id)
{
var accountManager = _accountManagerService.Get(id);
if (accountManager == null)
{
return(NotFound());
}
var accountManagerDTO = new AccountManagerDTO(accountManager);
return(Ok(accountManagerDTO));
}
public List <AccountManagerDTO> GetAccountById(string id)
{
List <AccountManagerDTO> accountManagerDTOs = new List <AccountManagerDTO>();
string query = string.Format("SELECT * FROM (SELECT PersonId,Username,Type FROM dbo.Account, dbo.AccountType " +
"WHERE dbo.Account.AcType = dbo.AccountType.ACId) AS A WHERE A.PersonId = '{0}'", id);
DataTable dataTable = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in dataTable.Rows)
{
AccountManagerDTO accountManagerDTO = new AccountManagerDTO(item);
accountManagerDTOs.Add(accountManagerDTO);
}
return(accountManagerDTOs);
}
public List <AccountManagerDTO> GetListAccountByType(int acType)
{
List <AccountManagerDTO> accountManagerDTOs = new List <AccountManagerDTO>();
string query = string.Format("SELECT Account.PersonId , Account.Username,A.Type FROM " +
"(SELECT PersonId,Username,Type FROM dbo.Account, dbo.AccountType WHERE dbo.Account.AcType = dbo.AccountType.ACId) AS A," +
"dbo.Account WHERE A.PersonId = dbo.Account.PersonId AND dbo.Account.AcType = '{0}'", acType);
DataTable dataTable = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in dataTable.Rows)
{
AccountManagerDTO accountManagerDTO = new AccountManagerDTO(item);
accountManagerDTOs.Add(accountManagerDTO);
}
return(accountManagerDTOs);
}
public IActionResult Put([FromBody] AccountManager accountManager)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var updatedAccountManager = _accountManagerService.Update(accountManager);
if (updatedAccountManager == null)
{
return(NotFound());
}
var updatedAccountManagerDTO = new AccountManagerDTO(updatedAccountManager);
return(Ok(updatedAccountManagerDTO));
}
public IActionResult Post([FromBody] AccountManager accountManager)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var createdAccountManager = _accountManagerService.Create(accountManager);
if (createdAccountManager == null)
{
return(BadRequest());
}
var createdAccountMangerDTO = new AccountManagerDTO(createdAccountManager);
return(Ok(createdAccountMangerDTO));
}
