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);
}
public HttpResponseMessage GetById(int id)
{
TransactionTableItem transaction = new TransactionTableItem();
int userId;
if (User.Identity.GetId().HasValue)
{
userId = User.Identity.GetId().Value;
transaction = transactionService.GetById(id, userId);
return(Request.CreateResponse(HttpStatusCode.OK, new ItemResponse <TransactionTableItem> {
Item = transaction
}));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, new ErrorResponse("No Agent Detected")));
}
}
public TransactionTableItem GetById(int id, int userId)
{
TransactionTableItem transaction = new TransactionTableItem();
dataProvider.ExecuteCmd(
"Transaction_GetById",
(parameters) =>
{
parameters.AddWithValue("@Id", id);
parameters.AddWithValue("@UserId", userId);
},
(reader, resultSetIndex) =>
{
transaction.Id = id;
transaction.UserId = (int)reader["UserId"];
transaction.PurchasePrice = (decimal)reader["PurchasePrice"];
transaction.TotalCommission = (decimal)reader["TotalCommission"];
transaction.Fees = reader.GetSafeDecimalNullable("Fees");
transaction.AgentCommission = reader.GetSafeDecimalNullable("AgentCommission");
transaction.BrokerCommission = reader.GetSafeDecimalNullable("BrokerCommission");
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");
}
);
return(transaction);
}
