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);
}
}
