public static Person PersonByName(string name)
{
using (var db = new BankingSystemEntities())
{
return(db.People.FirstOrDefault(p => p.Name == name));
}
}
public static SavingsAccount SavingsAccount(int personId)
{
using (var db = new BankingSystemEntities())
{
return(db.SavingsAccounts.FirstOrDefault(p => p.PersonId == personId));
}
}
public static Person PersonById(int id)
{
using (var db = new BankingSystemEntities())
{
return(db.People.FirstOrDefault(p => p.ID == id));
}
}
public static bool CheckingsExistsForPerson(int personId)
{
using (var db = new BankingSystemEntities())
{
return(db.CheckingsAccounts.FirstOrDefault(s => s.PersonId == personId) != null);
}
}
public static bool PersonExists(string name)
{
using (var db = new BankingSystemEntities())
{
return(db.People.FirstOrDefault(p => p.Name == name) != null);
}
}
public static void Person(int id, string name)
{
using (var db = new BankingSystemEntities())
{
var person = db.People.FirstOrDefault(p => p.ID == id);
if (person == null)
{
return;
}
person.Name = name;
db.SaveChanges();
}
}
public static void SavingsAccountAmount(Guid id, decimal amount)
{
using (var db = new BankingSystemEntities())
{
var account = db.SavingsAccounts.FirstOrDefault(a => a.AccountId == id);
if (account == null)
{
return;
}
account.Amount = amount;
db.SaveChanges();
}
}
public static int Person(string name)
{
using (var db = new BankingSystemEntities())
{
var person = new Person
{
Name = name
};
db.People.Add(person);
db.SaveChanges();
return(person.ID);
}
}
public static Guid CheckingsAccount(int personId, decimal amount)
{
using (var db = new BankingSystemEntities())
{
var account = new CheckingsAccount
{
PersonId = personId,
AccountId = Guid.NewGuid(),
Amount = amount
};
db.CheckingsAccounts.Add(account);
db.SaveChanges();
return(account.AccountId);
}
}
