private void DeleteMoneyIncludesDetailed(int moneyIncludesId, int userId)
{
try
{
using (JakieKieszonkoweEntities db = new JakieKieszonkoweEntities())
{
var isAdmin = db.Users.FirstOrDefault(i => i.Id_user == userId).IsAdmin;
if (!isAdmin)
{
throw new Exception("Nie posiadasz wystarczających uprawnień.");
}
Pocket_money_option pocketMoneyOption = db.Pocket_money_options.FirstOrDefault(i => i.Id_pocket_money_option == moneyIncludesId);
var children = db.Children.Where(i => i.Child_pocket_money_option.Any(j => j.Id_pocket_money_option == moneyIncludesId)).Include(i => i.Child_pocket_money_option);
foreach (var child in children)
{
db.Children.Remove(child);
}
db.Pocket_money_options.Remove(pocketMoneyOption);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void EditMoneyIncludesDetailed(string moneyIncludesName, int moneyIncludesId, int userId)
{
try
{
using (JakieKieszonkoweEntities db = new JakieKieszonkoweEntities())
{
var isAdmin = db.Users.FirstOrDefault(i => i.Id_user == userId).IsAdmin;
if (!isAdmin)
{
throw new Exception("Nie posiadasz wystarczających uprawnień.");
}
Pocket_money_option pocketMoneyOption = db.Pocket_money_options.FirstOrDefault(i => i.Id_pocket_money_option == moneyIncludesId);
pocketMoneyOption.Name = moneyIncludesName;
db.Pocket_money_options.Attach(pocketMoneyOption);
db.Entry(pocketMoneyOption).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}