public ActionResult Edit()
{
ManageTransactionViewModel manageTransactionVewModel = null;
using (this.expenseRepository)
{
DataSet transactionData = this.expenseRepository.GetAllMyTransactions();
manageTransactionVewModel = new ManageTransactionViewModel
{
TransactionData = transactionData.Tables[0].AsEnumerable().Select(transaction => new TransactionViewModel
{
AmountReceivedBy = transaction.Field <string>("AmountReceivedBy"),
AmountReturned = transaction.Field <decimal>("AmountReturned"),
AmountReturnedOn = transaction.Field <DateTime>("ReturnedOn"),
AmountReturnedBy = transaction.Field <string>("AmountReturnedBy"),
SelectedExpenseName = transaction.Field <string>("Expense"),
Description = transaction.Field <string>("Description"),
TransactionId = transaction.Field <int>("TransactionId")
}).ToList(),
TransactionLookUpData = new TransactionLookUp
{
Expenses = AppDataTableExtensions.LoadLookUpsDictionary <string, string>(transactionData.Tables[1], field1: "Value", field2: "Text"),
Users = AppDataTableExtensions.LoadLookUpsDictionary <string, string>(transactionData.Tables[2], field1: "Value", field2: "Text"),
}
};
}
manageTransactionVewModel = manageTransactionVewModel ?? new ManageTransactionViewModel();
return(View("Edit", manageTransactionVewModel));
}
public ActionResult ManageExpenses()
{
using (expenseRepository)
{
DataSet expenseDetail = expenseRepository.GtExpenseDetails();
var usersInExpense = expenseDetail.Tables[1].AsEnumerable().Select(userResults => new UsersInExpense
{
UserId = userResults.Field <string>("UserId").GetDefaultValueIfNull <string>(),
UserDisplayName = userResults.Field <string>("DisplayName"),
ExpenseID = userResults.Field <int>("ExpenseId"),
GroupId = userResults.Field <int>("GroupId"),
});
List <ExpenseViewModel> expenseViewModel = expenseDetail.Tables[0].AsEnumerable().Select(results => new ExpenseViewModel
{
Description = results.Field <string>("Description"),
SpentBy = results.Field <string>("SpentBy"),
DisplaySpentDate = results.Field <DateTime>("SpentOn").GetDefaultValueIfNull <DateTime>(),
SpentAmount = results.Field <decimal>("SpentAmount").GetDefaultValueIfNull <float>(),
SelectedBudget = results.Field <string>("BudgetName"),
Id = results.Field <int>("ExpenseID").GetDefaultValueIfNull <int>(),
Users = usersInExpense.Where(users => users.GroupId == results.Field <int>("GroupId").GetDefaultValueIfNull <int>() &&
users.ExpenseID == results.Field <int>("ExpenseId").GetDefaultValueIfNull <int>())
.Select(userResults => new SelectListItem
{
Text = userResults.UserDisplayName,
Value = userResults.UserId
}),
}).ToList();
DataSet expenseDetailsDataSet = expenseRepository.GetExpenseLookUp();
ManageExpenseViewModel manageExpenseViewModel = new ManageExpenseViewModel
{
ExpenseDetails = expenseViewModel,
ExpenseLookUpData = new SharedAssembly.ApplicationLookUps.ExpenseLookUp
{
Users = AppDataTableExtensions.LoadLookUpsDictionary <string, string>(expenseDetailsDataSet.Tables[0], field1: "Value", field2: "Text"),
Category = AppDataTableExtensions.LoadLookUpsDictionary <string, string>(expenseDetailsDataSet.Tables[2], field1: "Value", field2: "Text")
}
};
return(View("ManageExpenses", manageExpenseViewModel));
}
}
