private IExpenseType GetExpenseTypeFromDataRow(DataRow dr) { IExpenseType expenseTypes = new MyDiary.Domain.Domains.ExpenseType(null); foreach (DataColumn dc in dr.Table.Columns) { switch (dc.ColumnName) { case Constants.StoredProcedures.ExpenseTypes.Parameters.ExpenseTypeId: expenseTypes.TypeId = Convert.ToInt32(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.ExpenseTypes.Parameters.ExpenseType: expenseTypes.Type = Convert.ToString(dr[dc.ColumnName].ToString()); break; } } return(expenseTypes); //throw new NotImplementedException(); }
private IExpense GetExpenseFromDataRow(DataRow dr) { IExpense expense = new MyDiary.Domain.Domains.Expense(); IExpenseType expenseType = new MyDiary.Domain.Domains.ExpenseType(); IPeople currentUser = new MyDiary.Domain.Domains.People(); foreach (DataColumn dc in dr.Table.Columns) { switch (dc.ColumnName) { case Constants.StoredProcedures.Expenses.Parameters.ExpenseId: expense.Id = Convert.ToInt32(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.ExpenseType: expenseType.Type = Convert.ToString(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.ExpenseTypeId: expenseType.TypeId = Convert.ToInt32(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.ExpenseDate: expense.ExpenseDate = Convert.ToDateTime(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.Description: expense.Description = Convert.ToString(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.Comments: expense.Comments = Convert.ToString(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.Amount: expense.Amount = float.Parse(dr[dc.ColumnName].ToString(), System.Globalization.CultureInfo.InvariantCulture); break; case Constants.StoredProcedures.ExpenseTypes.Parameters.UserId: currentUser.UserId = Convert.ToInt32(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.CREATEDBY: expense.CreatedBy = Convert.ToInt32(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.CREATEDDATE: expense.CreatedDate = Convert.ToDateTime(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.MODIFIEDBY: expense.ModifiedBy = (dr[dc.ColumnName]) == DBNull.Value ? (int?)null : Convert.ToInt32(dr[dc.ColumnName].ToString()); break; case Constants.StoredProcedures.Expenses.Parameters.MODIFIEDDATE: expense.ModifiedDate = (dr[dc.ColumnName]) == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(dr[dc.ColumnName].ToString()); break; } } expense.ExpenseType = expenseType; expense.CurrentUser = currentUser; return(expense); }