public PagedItemResponse <UserSearch> Search(int pageIndex, int pageSize, string query)
{
PagedItemResponse <UserSearch> pagedItemResponse = new PagedItemResponse <UserSearch>();
List <UserSearch> userList = new List <UserSearch>();
dataProvider.ExecuteCmd(
"User_GetBySearch",
(parameters) =>
{
parameters.AddWithValue("@PageIndex", pageIndex);
parameters.AddWithValue("@PageSize", pageSize);
parameters.AddWithValue("@Search", query);
},
(reader, resultSetIndex) =>
{
UserSearch userSearch = new UserSearch
{
Id = (int)reader["Id"],
Name = (string)reader["Name"],
};
User user = MapUser(reader);
pagedItemResponse.TotalCount = (int)reader["TotalCount"];
userList.Add(userSearch);
});
pagedItemResponse.PagedItems = userList;
return(pagedItemResponse);
}
public HttpResponseMessage GetBySearch(int PageIndex, int PageSize, string query)
{
PagedItemResponse <UserSearch> pagedItemResponse = userService.Search(PageIndex, PageSize, query);
return(Request.CreateResponse(HttpStatusCode.OK, new ItemResponse <PagedItemResponse <UserSearch> >
{
Item = pagedItemResponse
}));
}
public HttpResponseMessage GetAllByUser(int PageIndex, int PageSize)
{
int userId;
if (User.Identity.GetId().HasValue)
{
userId = User.Identity.GetId().Value;
PagedItemResponse <TransactionTableItem> pagedItemResponse = transactionService.GetAllByUser(userId, PageIndex, PageSize);
return(Request.CreateResponse(HttpStatusCode.OK, pagedItemResponse));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new ItemResponse <string> {
Item = null
}));
}
}
public PagedItemResponse <TransactionTableItem> GetAllByUser(int userId, int PageIndex, int PageSize)
{
PagedItemResponse <TransactionTableItem> pagedItemResponse = new PagedItemResponse <TransactionTableItem>();
List <TransactionTableItem> transactionList = new List <TransactionTableItem>();
dataProvider.ExecuteCmd(
"Transaction_GetAllByUser",
(parameters) =>
{
parameters.AddWithValue("@UserId", userId);
parameters.AddWithValue("@PageIndex", PageIndex);
parameters.AddWithValue("@PageSize", PageSize);
},
(reader, resultsIndex) =>
{
TransactionTableItem transaction = new TransactionTableItem();
transaction.Id = (int)reader["Id"];
transaction.UserId = (int)reader["UserId"];
transaction.PurchasePrice = (decimal)reader["PurchasePrice"];
transaction.TotalCommission = (decimal)reader["TotalCommission"];
transaction.AgentCommission = reader.GetSafeDecimalNullable("AgentCommission");
transaction.SaleDate = (DateTime)reader["SaleDate"];
transaction.CloseDate = (DateTime)reader["CloseDate"];
transaction.Status = (string)reader["Status"];
transaction.StreetAddress = reader.GetSafeString("StreetAddress");
transaction.City = reader.GetSafeString("City");
transaction.State = reader.GetSafeString("State");
transaction.ZipCode = reader.GetSafeInt32Nullable("ZipCode");
transaction.Lead_Id = reader.GetSafeInt32Nullable("Lead_Id");
transaction.FullName = reader.GetSafeString("FullName");
transaction.Buyer = reader.GetSafeBoolNullable("Buyer"); //(bool)reader["Buyer"];
transaction.Seller = reader.GetSafeBoolNullable("Seller");
transaction.Lease = reader.GetSafeBoolNullable("Lease");
pagedItemResponse.TotalCount = (int)reader["TotalCount"];
transactionList.Add(transaction);
});
pagedItemResponse.PagedItems = transactionList;
return(pagedItemResponse);
}
