public void PerformDatabaseOperations(int accountId, string name, string type)
{
using (var db = new AccountDbContext())
{
if (type == "savings")
{
var person = new Account
{
Account_Number = accountId,
Full_Name = name,
Amount = 1000,
Account_Type = type
};
db.SetAccount.Add(person);
db.SaveChanges();
}
else
{
var person = new Account
{
Account_Number = accountId,
Full_Name = name,
Amount = 0,
Account_Type = type
};
db.SetAccount.Add(person);
db.SaveChanges();
}
}
Console.WriteLine();
}
public void PerformDatabaseWithdrawl(int id, int money)
{
using (var db = new AccountDbContext())
{
var entity = db.SetAccount.Find(id);
if (entity != null)
{
if (entity.Account_Type == "savings" && entity.Amount > (1000 + money))
{
entity.Amount = entity.Amount - money;
Console.WriteLine("Amount Withdrawl");
}
else if (entity.Account_Type == "current" && entity.Amount > money)
{
entity.Amount = entity.Amount - money;
Console.WriteLine("Amount Withdrawl");
}
else
{
Console.WriteLine("Amount can not be less than 0 for current account type or 1000 for savings account type");
}
db.SaveChanges();
}
}
Console.WriteLine();
Console.WriteLine();
}
public void PerformDatabaseUpdate(int id, int money)
{
using (var db = new AccountDbContext())
{
var entity = db.SetAccount.Find(id);
if (entity != null)
{
entity.Amount = entity.Amount + money;
db.SaveChanges();
}
}
Console.WriteLine();
Console.WriteLine("Amount Deposited");
Console.WriteLine();
}