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