public ResponseModel PostSavingWallet([FromBody] SavingWallet savingWallet)
{
string name = savingWallet.name_saving;
string date_s = savingWallet.date_s;
string date_e = savingWallet.date_e;
float price = savingWallet.price;
string id_bank = savingWallet.id_bank;
string id_user = savingWallet.id_user;
if (savingWallet == null)
{
ResponseModel res1 = new ResponseModel("Create fail", null, "404");
return(res1);
}
if (id_user == null)
{
savingWallet.id_user = "******";
}
savingWallet.name_saving = name;
savingWallet.date_e = date_e;
savingWallet.date_s = date_s;
savingWallet.price = price;
savingWallet.price_end = 0;
savingWallet.is_Finnish = false;
savingWallet.id_bank = id_bank;
savingWallet.id_user = id_user;
_context.SavingWallet.Add(savingWallet);
_context.SaveChanges();
ResponseModel res = new ResponseModel("Create success", null, "404");
return(res);
}
public ResponseModel DeleteSavingWallet([FromQuery] int id)
{
if (!ModelState.IsValid)
{
ResponseModel res = new ResponseModel("Delete fail", null, "404");
return(res);
}
SavingWallet savingWallet = _context.SavingWallet.Find(id);
var trans = _context.Transactions
.Where(w => w.id_saving == id.ToString());
foreach (Transactions transactions in trans)
{
_context.Transactions.Remove(transactions);
}
if (savingWallet != null)
{
_context.SavingWallet.Remove(savingWallet);
_context.SaveChanges();
ResponseModel res = new ResponseModel("Delete success", null, "404");
return(res);
}
else
{
ResponseModel res = new ResponseModel("Delete fail", null, "404");
return(res);
}
}
public ResponseModel PostTransactions([FromBody] Transactions transactions)
{
float price = transactions.price_trans;
string name = transactions.name_trans;
string date = transactions.date_trans;
string id_saving = transactions.id_saving;
bool is_Income = transactions.is_Income;
SavingWallet savingWallet = _context.SavingWallet.Where(m => m.id_saving.ToString() == id_saving).FirstOrDefault();
if (savingWallet == null)
{
ResponseModel res1 = new ResponseModel("Transactions fail", null, "404");
return(res1);
}
transactions.price_trans = price;
transactions.date_trans = date;
transactions.id_saving = id_saving;
transactions.is_Income = is_Income;
if (is_Income == true)
{
savingWallet.price = savingWallet.price + price;
}
if (is_Income == false)
{
savingWallet.price = savingWallet.price - price;
}
_context.SavingWallet.Update(savingWallet);
_context.Transactions.Add(transactions);
_context.SaveChanges();
ResponseModel res = new ResponseModel("Transactions success", null, "404");
return(res);
}
public ResponseModel PutSavingWallet([FromQuery] string id, [FromBody] SavingWallet savingWallet)
{
string id_saving = savingWallet.id_saving.ToString();
//string date = savingWallet.date_s;
savingWallet.is_Finnish = true;
var log = from a in _context.SavingWallet
join b in _context.Bank
on a.id_bank equals b.Id_Bank.ToString()
where (a.id_saving.ToString() == id_saving)
select new SavingWallet
{
id_saving = a.id_saving,
is_Finnish = true,
date_e = DateTime.Today.ToString(),
price_end = (DateTime.Parse(a.date_s).Year == DateTime.Today.Year) ? a.price :
((365 - DateTime.Parse(a.date_s).DayOfYear) + DateTime.Today.DayOfYear) < 365 ? a.price :
(DateTime.Today.Year - (DateTime.Parse(a.date_s).Year)) *
((float)b.Interest) * (a.price) + a.price
};
SavingWallet saving = log.Where(m => m.id_saving.ToString() == id_saving).FirstOrDefault();
savingWallet = _context.SavingWallet.Where(m => m.id_saving.ToString() == id_saving).FirstOrDefault();
if (savingWallet == null)
{
ResponseModel res = new ResponseModel("Fail", null, "404");
return(res);
}
savingWallet.date_e = saving.date_e;
savingWallet.price_end = saving.price_end;
savingWallet.is_Finnish = saving.is_Finnish;
_context.SavingWallet.Update(savingWallet);
_context.SaveChanges();
ResponseModel res1 = new ResponseModel("Success", null, "404");
return(res1);
}
