public EditEx_Cats(ExpensesCategory expensesCategory)
{
InitializeComponent();
Ex_Cats = new ObservableCollection <ExpensesCategory>();
_ExpensesCategory = expensesCategory;
BindingContext = expensesCategory;
}
public void CreateExpensesCategory(ExpensesCategory expensesCategory)
{
using (var db = new JohannaContext())
{
db.ExpensesCategories.Add(expensesCategory);
db.SaveChanges();
}
}
public async Task CreateComunication(Expenses expenses,
ExpensesCategory expensesCategory)
{
var expCategory = new ExpCategory()
{
ExpensesId = expenses.Id,
ExpensesCategoryId = expensesCategory.Id
};
_context.ExpCategories.Add(expCategory);
await _context.SaveChangesAsync();
}
public int SaveCategory(ExpensesCategory cat)
{
lock (Locker)
{
if (cat.Id != 0)
{
database.Update(cat);
return(cat.Id);
}
else
{
return(database.Insert(cat));
}
}
}
public IEnumerable <ExpensesCategory> GetCategories()
{
lock (Locker)
{
var expenses = (from c in database.Table <ExpensesCategory>()
select c);
if (expenses.Count() == 0)
{
//seeding
ExpensesCategory expensesCategory = new ExpensesCategory()
{
Name = "Groceries"
};
ExpensesCategory expensesCategory1 = new ExpensesCategory()
{
Name = "Fuel"
};
ExpensesCategory expensesCategory2 = new ExpensesCategory()
{
Name = "Drinks"
};
ExpensesCategory expensesCategory3 = new ExpensesCategory()
{
Name = "Eating Out"
};
ExpensesCategory expensesCategory4 = new ExpensesCategory()
{
Name = "Clothes"
};
SaveCategory(expensesCategory);
SaveCategory(expensesCategory1);
SaveCategory(expensesCategory2);
SaveCategory(expensesCategory3);
SaveCategory(expensesCategory4);
expenses = (from c in database.Table <ExpensesCategory>()
select c);
}
return(expenses);
}
}
private void BtnSave_Clicked(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Ex_Cat_Name.Text))
{
ExpensesCategory expensesCategory = new ExpensesCategory
{
Name = Ex_Cat_Name.Text
};
if (_ex_cat_database.SaveCategory(expensesCategory) != 0)
{
expensesCategories.Add(expensesCategory);
DisplayAlert("Hey", "Category successfully saved", "Great");
}
}
else
{
DisplayAlert("Hey", "Please enter a Category", "Ok");
}
Clear();
}
public async Task Update(ExpensesCategory entity)
{
_context.ExpensesCategories.Update(entity);
await _context.SaveChangesAsync();
}
