public bool SaveNewPost(IncomePost post)
{
try {
using (SqlConnection conn = new SqlConnection(ConnString)) {
conn.Open();
SqlCommand cmd = new SqlCommand(Insert_Income_SQL, conn);
cmd.Parameters.AddWithValue("@BudgetId", post.BudgetId);
cmd.Parameters.AddWithValue("@IncomeDescription", post.IncomeDescription);
cmd.Parameters.AddWithValue("@IncomeAmount", post.IncomeAmount);
cmd.Parameters.AddWithValue("@IncomeCategory", post.IncomeCategory);
int rowsaffected = cmd.ExecuteNonQuery();
if (rowsaffected == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (SqlException) {
throw;
}
}
public List <IncomePost> GetAllPosts(int budgetId)
{
List <IncomePost> posts = new List <IncomePost>();
using (SqlConnection conn = new SqlConnection(ConnString)) {
conn.Open();
SqlCommand cmd = new SqlCommand(GET_ALL_Income_Streams_SQL, conn);
cmd.Parameters.AddWithValue("@BudgetId", budgetId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
IncomePost temp = new IncomePost();
temp.IncomeId = Convert.ToInt32(reader["IncomeId"]);
temp.IncomeDescription = Convert.ToString(reader["IncomeDescription"]);
temp.IncomeAmount = Convert.ToInt32(reader["IncomeAmount"]);
temp.IncomeCategory = Convert.ToString(reader["IncomeCategory"]);
temp.IsActive = Convert.ToBoolean(reader["IsActive"]);
temp.BudgetId = Convert.ToInt32(reader["BudgetId"]);
if (temp.IsActive)
{
posts.Add(temp);
}
}
return(posts);
}
}
public IActionResult NewIncome()
{
IncomePost newIncome = new IncomePost();
newIncome.BudgetId = GetTempBudgetID();
return(View(newIncome));
}
public IActionResult Index()
{
IncomePost iPost = new IncomePost();
iPost.Results = incomeDAL.GetAllPosts(GetTempBudgetID());
return(View(iPost));
}
public IActionResult RemoveIncome(IncomePost income)
{
try {
incomeDAL.RemovePost(income);
}
catch (NullReferenceException) {
throw;
}
return(RedirectToAction("Index", "Income"));
}
public bool RemovePost(IncomePost post)
{
try {
using (SqlConnection conn = new SqlConnection(ConnString)) {
conn.Open();
SqlCommand cmd = new SqlCommand(Remove_Income_SQL, conn);
cmd.Parameters.AddWithValue("@IncomeId", post.IncomeId);
int rowsaffected = cmd.ExecuteNonQuery();
if (rowsaffected == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (SqlException) {
return(false);
}
}
