public async Task <IActionResult> SearchAccount([FromBody] SearchAccountRequest request)
{
string method = nameof(SearchAccount);
LogHandler.LogMethod(LogHandler.EventType.Call, Logger, method, request);
PagedResponse <object> response = new PagedResponse <object>();
try
{
var query = await DbContext.GetAccounts(request).Paging(response, request.page_start, request.page_size)
.Include(x => x.fund).Include(x => x.accounter)
.ToListAsync();
var entity_list = query
.Select(x => new
{
x.id,
x.name,
x.fund_id,
x.fund_name,
x.accounter_id,
x.accounter_name
});
response.Model = entity_list;
response.ErrorCode = (int?)ErrorHandler.ErrorCode.OK;
}
catch (Exception ex)
{
LogHandler.LogError(Logger, response, method, ex);
}
return(response.ToHttpResponse(Logger, method));
}
public SearchAccountResponse SearchAccount(SearchAccountRequest request)
{
SearchAccountResponse res = new SearchAccountResponse();
res = dao.SearchAccount(new SearchAccountRequest()
{
AccountName = request.AccountName,
AccountType = request.AccountType,
IDNumber = request.IDNumber,
PhoneNumber = request.PhoneNumber,
Status = request.Status
});
return(res);
}
public SearchAccountResponse SearchAccount(SearchAccountRequest request)
{
SearchAccountResponse res = new SearchAccountResponse();
string strSP = SqlCommandStore.uspSearchAccount;
try
{
using (SqlCommand cmd = new SqlCommand(strSP))
{
cmd.Parameters.Add("AccountName", SqlDbType.NVarChar, 100).Value = request.AccountName;
cmd.Parameters.Add("AccountType", SqlDbType.Int).Value = (int)request.AccountType;
cmd.Parameters.Add("IDNumber", SqlDbType.NVarChar, 20).Value = request.IDNumber;
cmd.Parameters.Add("Status", SqlDbType.Int).Value = (int)request.Status;
cmd.Parameters.Add("PhoneNumber", SqlDbType.NVarChar, 20).Value = request.PhoneNumber;
cmd.Parameters.Add("@Return", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
DataSet ds = DB.ExecuteSPDataSet(cmd);
res.Code = (ReturnCode)Convert.ToInt32(cmd.Parameters["@Return"].Value);
if (res.Code != ReturnCode.Success)
{
DB.RollBackTran();
return(res);
}
DataRow[] rows = new DataRow[ds.Tables[0].Rows.Count];
rows = new DataRow[ds.Tables[0].Rows.Count];
ds.Tables[0].Rows.CopyTo(rows, 0);
res.accounts = rows.Select(row => new AccountModel(row)).ToList();
DB.CommitTran();
return(res);
}
}
catch (Exception ex)
{
LogWriter.WriteLogException(ex);
res.Code = ReturnCode.Fail;
return(res);
}
}
public async Task <IActionResult> Get([FromQuery] SearchAccountRequest request)
{
AccountModel account = new AccountModel()
{
UserName = request.Name,
Role = request.Role,
};
var result = accountRepository.Search(account, request.Page, request.PageSize);
GetAllAccountResponse response = new GetAllAccountResponse
{
Data = (IEnumerable <AccountModel>)result.Data,
Message = "",
Metadata = new Metadata()
{
Page = request.Page,
PageSize = request.PageSize,
Total = result.PageTotal
},
Success = true
};
return(Ok(response));
}
public ActionResult SearchAccount(SearchAccountRequest request)
{
return(View());
}
