public bool SaveNewPost(ExpensePost post)
{
try {
using (SqlConnection conn = new SqlConnection(ConnString)) {
conn.Open();
SqlCommand cmd = new SqlCommand(Insert_Expense_SQL, conn);
cmd.Parameters.AddWithValue("@ExpenseDescription", post.ExpenseDescription);
cmd.Parameters.AddWithValue("@ExpenseCategory", post.ExpenseCategory);
cmd.Parameters.AddWithValue("@ExpenseAmount", post.ExpenseAmount);
cmd.Parameters.AddWithValue("@BudgetId", post.BudgetId);
int rowsaffected = cmd.ExecuteNonQuery();
if (rowsaffected == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (SqlException ex) {
throw;
}
}
public List <ExpensePost> GetAllPosts(int budgetId)
{
List <ExpensePost> posts = new List <ExpensePost>();
using (SqlConnection conn = new SqlConnection(ConnString)) {
conn.Open();
SqlCommand cmd = new SqlCommand(GET_ALL_Expenses_SQL, conn);
cmd.Parameters.AddWithValue("@BudgetId", budgetId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ExpensePost temp = new ExpensePost();
temp.ExpenseId = Convert.ToInt32(reader["ExpenseId"]);
temp.BudgetId = Convert.ToInt32(reader["BudgetId"]);
temp.ExpenseDescription = Convert.ToString(reader["ExpenseDescription"]);
temp.ExpenseCategory = Convert.ToString(reader["ExpenseCategory"]);
temp.ExpenseAmount = Convert.ToDecimal(reader["ExpenseAmount"]);
temp.IsActive = Convert.ToBoolean(reader["IsActive"]);
if (temp.IsActive)
{
posts.Add(temp);
}
}
return(posts);
}
}
public IActionResult NewExpense()
{
ExpensePost newpost = new ExpensePost();
newpost.BudgetId = GetTempBudgetID();
return(View(newpost));
}
public IActionResult Index()
{
ExpensePost ePost = new ExpensePost();
ePost.Results = expenseDAL.GetAllPosts(GetTempBudgetID());
return(View(ePost));
}
public IActionResult RemoveExpense(ExpensePost post)
{
try {
expenseDAL.RemovePost(post);
}
catch (NullReferenceException) {
throw;
}
return(RedirectToAction("Index", "Expense"));
}
public bool RemovePost(ExpensePost post)
{
try {
using (SqlConnection conn = new SqlConnection(ConnString)) {
conn.Open();
SqlCommand cmd = new SqlCommand(Remove_Expense_SQL, conn);
cmd.Parameters.AddWithValue("@ExpenseId", post.ExpenseId);
int rowsaffected = cmd.ExecuteNonQuery();
if (rowsaffected == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (SqlException) {
return(false);
}
}
