public ResponseModel PutWallet([FromRoute] int id, [FromBody] Wallet wallet) { string name = wallet.Name_Wallet; float amount = wallet.Amount_Wallet; string disciption = wallet.Description; Wallet walletFind = _context.Wallets.Where(m => m.Id_Wallet == id).FirstOrDefault(); if (!ModelState.IsValid) { ResponseModel res = new ResponseModel("Update fail", null, "404"); return(res); } if (walletFind == null) { ResponseModel res = new ResponseModel("Update fail", null, "404"); return(res); } Income_Outcome income = new Income_Outcome(); walletFind.Name_Wallet = name; walletFind.Description = disciption; if (amount < walletFind.Amount_Wallet) { income.Is_Come = false; walletFind.Amount_now = walletFind.Amount_Wallet - amount; } else { income.Is_Come = true; walletFind.Amount_now = amount - walletFind.Amount_Wallet; } walletFind.Amount_Wallet = amount; income.Amount = amount; income.Description_come = "Cập nhật ví " + name; income.Id_type = "16"; income.Date_come = DateTime.Today.ToString(); income.WalletId_Wallet = id.ToString(); try { _context.Income_Outcomes.Add(income); _context.Wallets.Update(walletFind); _context.SaveChanges(); ResponseModel res = new ResponseModel("Update success", null, "200"); return(res); } catch (DbUpdateConcurrencyException) { if (!WalletExists(id)) { ResponseModel res = new ResponseModel("Not found", null, "404"); return(res); } else { throw; } } }
public ResponseModel PutPeriodic([FromRoute] int id, [FromBody] Periodic periodic) { if (!ModelState.IsValid) { ResponseModel res = new ResponseModel("Fail", null, "200"); return(res); } float amount = periodic.Amount_Per; string disciption = periodic.Desciption; DateTime date_e = periodic.date_e; DateTime date_s = periodic.date_s; string id_time = periodic.id_Time; periodic = _context.Periodic.Where(m => m.Id_Per == id).FirstOrDefault(); periodic.Amount_Per = amount; periodic.Desciption = disciption; periodic.date_e = date_e; periodic.date_s = date_s; periodic.id_Time = id_time; periodic.isComeback = false; //if (periodic.Id_Wallet == 0) //{ // periodic.Id_Wallet = 1; //} //if (periodic.Id_Cate == 0) //{ // periodic.Id_Cate = 1; //} //if (periodic.Id_Type == 0) //{ // periodic.Id_Type = 1; //} //if (periodic.id_Time == 0) //{ // periodic.id_Time = 1; //} try { _context.Entry(periodic).State = EntityState.Modified; _context.SaveChanges(); ResponseModel res = new ResponseModel("Update success", null, "200"); return(res); } catch (DbUpdateConcurrencyException) { if (!PeriodicExists(id)) { ResponseModel res = new ResponseModel("Not found", null, "200"); return(res); } else { throw; } } }
public ResponseModel PutBudget([FromRoute] int id, [FromBody] Budget budget) { if (!ModelState.IsValid) { ResponseModel res = new ResponseModel("Fail", null, "200"); return res; } float amount = budget.Amount_Budget; float remain = budget.Remain; DateTime date_e = budget.time_e; DateTime date_s = budget.time_s; bool isfinnish = budget.isFinnish; string idtime = budget.id_Time; budget = _context.Budget.Where(m => m.Id_Budget == id).FirstOrDefault(); budget.Amount_Budget = amount; budget.time_e = date_e; budget.time_s = date_s; budget.isFinnish = isfinnish; budget.id_Time = idtime; //if (budget.Id_Wallet == 0) //{ // budget.Id_Wallet = 1; //} //if (budget.Id_Cate == 0) //{ // budget.Id_Cate = 1; //} //if (budget.Id_type == 0) //{ // budget.Id_type = 1; //} budget.Remain = budget.Amount_Budget; budget.isFinnish = false; try { _context.Entry(budget).State = EntityState.Modified; _context.SaveChanges(); ResponseModel res = new ResponseModel("Update success", null, "200"); return res; } catch (DbUpdateConcurrencyException) { if (!BudgetExists(id)) { ResponseModel res = new ResponseModel("Not found", null, "200"); return res; } else { throw; } } }
public ResponseModel PutIncome_Outcome([FromRoute] int id, [FromBody] Income_Outcome income_Outcome) { if (!ModelState.IsValid) { ResponseModel res = new ResponseModel("Update fail", null, "404"); return(res); } float amount = income_Outcome.Amount; string date = income_Outcome.Date_come; string desciption = income_Outcome.Description_come; bool is_come = income_Outcome.Is_Come; string id_cate = income_Outcome.CategoryId_Cate; string id_loan = income_Outcome.LoanId_Loan; string id_trip = income_Outcome.TripId_Trip; string id_wallet = income_Outcome.WalletId_Wallet; string id_type = income_Outcome.Id_type; string id_bill = income_Outcome.Id_Bill; string id_budget = income_Outcome.Id_Budget; string id_per = income_Outcome.Id_Per; income_Outcome.Amount = amount; income_Outcome.Date_come = date; income_Outcome.Description_come = desciption; income_Outcome.Is_Come = is_come; income_Outcome.CategoryId_Cate = id_cate.ToString(); income_Outcome.LoanId_Loan = id_loan.ToString(); income_Outcome.TripId_Trip = id_trip.ToString(); income_Outcome.Id_Bill = id_bill.ToString(); income_Outcome.Id_Budget = id_budget.ToString(); income_Outcome.Id_Per = id_per.ToString(); income_Outcome.Id_type = id_type.ToString(); try { _context.Income_Outcomes.Update(income_Outcome); _context.Entry(income_Outcome).State = EntityState.Modified; _context.SaveChanges(); ResponseModel res = new ResponseModel("Update success", null, "404"); return(res); } catch (DbUpdateConcurrencyException) { if (!Income_OutcomeExists(id)) { ResponseModel res = new ResponseModel("Not found", null, "404"); return(res); } else { throw; } } }
public ResponseModel GetSavingWallet([FromQuery] string id) { var saving = _context.SavingWallet.Where(w => w.id_user.ToString() == id); var list = new ArrayList(); if (saving == null) { ResponseModel res1 = new ResponseModel("Saving wallets", null, "200"); return(res1); } foreach (SavingWallet saving1 in saving) { if (DateTime.Parse(saving1.date_e) <= DateTime.Today) { saving1.is_Finnish = true; _context.SavingWallet.Update(saving1); } } _context.SaveChanges(); var saving_ = _context.SavingWallet.Where(w => w.id_user.ToString() == id); foreach (SavingWallet savingWallet in saving_) { 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 == savingWallet.id_saving) select new { id_saving = a.id_saving, name = a.name_saving, date_e = a.date_e, date_s = a.date_s, price = a.price, price_end = a.price_end, is_Finish = a.is_Finnish, name_bank = b.Name_Bank, interest = b.Interest, id_user = a.id_user }; var get = log.Where(m => m.id_user.Equals(id)).AsEnumerable(); foreach (object l in get) { list.Add(l); } } ResponseModel res = new ResponseModel("Saving wallets", list, "200"); return(res); }
public ResponseModel PostUser([FromBody] User user) { string User_Name = user.User_Name; string password = user.Password; string full_name = user.FullName; //bool check_wallet = user.Check_Wallet; User user1 = _context.Users.Where(m => m.User_Name == user.User_Name).FirstOrDefault(); if (user1 != null) { ResponseModel res = new ResponseModel("User has existed", null, "200"); return(res); } else { user.User_Name = User_Name; user.Password = password; user.FullName = full_name; user.Check_Wallet = false; _context.Users.Add(user); _context.SaveChanges(); ResponseModel res = new ResponseModel("Create success", null, "200"); return(res); } }
public ResponseModel PostCategory([FromBody] Category category) { string name = category.NameCate; string image = category.ImageCate; int id_type = category.Id_type; UserCategory userCategory = new UserCategory(); Category category1 = _context.Categories.Where(m => m.NameCate == category.NameCate).FirstOrDefault(); try { if (category1 == null) { category.NameCate = name; category.ImageCate = image; category.Id_type = id_type; _context.Categories.Add(category); _context.SaveChanges(); ResponseModel res = new ResponseModel("Create success", null, "200"); return(res); } else { ResponseModel res = new ResponseModel("Category has existed", null, "200"); return(res); } } catch { ResponseModel res = new ResponseModel("Create fail", null, "200"); return(res); } }
public ResponseModel PostCreateWallet([FromBody] CreateWallet createWallet) { int user_Id = createWallet.User_Id; float amount = createWallet.Amount; Wallet insert = new Wallet(); var check = false; insert.Amount_Wallet = amount; insert.User_Id = user_Id.ToString(); insert.Name_Wallet = "Ví tiền mặt"; insert.Description = ""; insert.Id_Type_Wallet = "1"; User user = _context.Users.Where(x => x.User_Id == user_Id).FirstOrDefault(); user.Check_Wallet = true; try { _context.Wallets.Add(insert); _context.Users.Update(user); _context.SaveChanges(); check = true; } catch { check = false; } if (check == false) { ResponseModel res = new ResponseModel("Create fail", null, "404"); return(res); } else { ResponseModel res = new ResponseModel("Create success", null, "200"); 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 PutBill([FromRoute] int id, [FromBody] Bill bill) { if (!ModelState.IsValid) { ResponseModel res = new ResponseModel("Update fail", null, "404"); return(res); } float amount = bill.Amount_Bill; string disciption = bill.Desciption; DateTime date_e = bill.date_e; DateTime date_s = bill.date_s; bool isEdit = bill.isEdit; string id_time = bill.id_Time; bill = _context.Bill.Where(m => m.Id_Bill == id).FirstOrDefault(); bill.Amount_Bill = amount; bill.Desciption = disciption; bill.date_e = date_e; bill.date_s = date_s; bill.isEdit = isEdit; bill.id_Time = id_time; try { if (bill.isEdit == false) { bill.isPay = true; } _context.Bill.Update(bill); _context.Entry(bill).State = EntityState.Modified; _context.SaveChanges(); ResponseModel res = new ResponseModel("Update success", null, "404"); return(res); } catch (DbUpdateConcurrencyException) { if (!BillExists(id)) { ResponseModel res = new ResponseModel("Not found", null, "404"); return(res); } else { throw; } } }
public ResponseModel PutTrip([FromRoute] string id, [FromBody] Trip trip) { string name = trip.Name_Trip; trip = _context.Trips.Where(m => m.Id_Trip.ToString() == id).FirstOrDefault(); if (trip == null) { ResponseModel res1 = new ResponseModel("Update fail", null, "404"); return(res1); } trip.Name_Trip = name; _context.Trips.Update(trip); _context.SaveChanges(); ResponseModel res = new ResponseModel("Update successs", null, "404"); return(res); }
public ResponseModel PutBank([FromRoute] string id, [FromBody] Bank bank) { string name = bank.Name_Bank; float interest = bank.Interest; bank = _context.Bank.Where(m => m.Id_Bank.ToString() == id).FirstOrDefault(); if (bank == null) { ResponseModel res1 = new ResponseModel("Update fail", null, "404"); return(res1); } bank.Name_Bank = name; bank.Interest = interest; _context.Bank.Update(bank); _context.SaveChanges(); ResponseModel res = new ResponseModel("Update successs", null, "404"); return(res); }
public ResponseModel GetgetBill([FromQuery] string id) { var bills = _context.Bill.Where(w => w.Id_Wallet == id); var list = new ArrayList(); foreach (Bill bill1 in bills) { if (bill1.date_e <= DateTime.Today) { bill1.isFinnish = true; _context.Bill.Update(bill1); } } _context.SaveChanges(); var bill = _context.Bill .Where(w => w.Id_Wallet == id); foreach (Bill bill2 in bill) { if (bill2.Id_Category == null) { var log = from a in _context.Bill join c in _context.TypeCategories on a.Id_Type equals c.Id_type.ToString() join d in _context.Time_Periodic on a.id_Time equals d.id_Time.ToString() where (a.Id_Category == null && a.Id_Bill == bill2.Id_Bill) select new { idwallet = a.Id_Wallet, idBill = a.Id_Bill, name = c.Name_Type, image = c.Image_Type, amount = a.Amount_Bill, date_s = a.date_s, date_e = a.date_e, isPay = a.isPay, isFinnish = a.date_e >= DateTime.Now ? false : true, time = d.desciption, date_time_s = a.date_s, date_time_e = (a.id_Time == "1" ? a.date_s.AddDays(1) : a.id_Time == "2" ? a.date_s.AddDays(7) : a.id_Time == "3" ? DateTime.Today.AddDays(DateTime.DaysInMonth(2020, DateTime.Today.Month) - DateTime.Today.Day) : DateTime.Today.AddDays(365 - (a.date_s.DayOfYear - 1))) }; var get = log.Where(m => m.idwallet.Equals(id)).AsEnumerable(); foreach (object l in get) { list.Add(l); } } if (bill2.Id_Type == null) { var log = from a in _context.Bill join b in _context.Categories on a.Id_Category equals b.Id_Cate.ToString() join d in _context.Time_Periodic on a.id_Time equals d.id_Time.ToString() where (a.Id_Type == null && a.Id_Bill == bill2.Id_Bill) select new { idwallet = a.Id_Wallet, idBill = a.Id_Bill, name = b.NameCate, image = b.ImageCate, amount = a.Amount_Bill, date_s = a.date_s, date_e = a.date_e, isPay = a.isPay, isFinnish = a.date_e >= DateTime.Now ? false : true, time = d.desciption, date_time_s = a.date_s, date_time_e = (a.id_Time == "1" ? a.date_s.AddDays(1) : a.id_Time == "2" ? a.date_s.AddDays(7) : a.id_Time == "3" ? DateTime.Today.AddDays(DateTime.DaysInMonth(2020, DateTime.Today.Month) - DateTime.Today.Day) : DateTime.Today.AddDays(365 - (a.date_s.DayOfYear - 1))) }; var get = log.Where(m => m.idwallet.Equals(id)).AsEnumerable(); foreach (object l in get) { list.Add(l); } } //ResponseModel res = new ResponseModel("Bill", list, "200"); //return res; } ResponseModel res1 = new ResponseModel("Budget", list, "200"); return(res1); }
public ResponseModel GetgetPeriodic([FromQuery] string id) { var list = new ArrayList(); Wallet wallet = _context.Wallets.Where(m => m.Id_Wallet.ToString() == id).FirstOrDefault(); var per = _context.Periodic.Where(w => w.Id_Wallet == id.ToString()); foreach (Periodic periodic1 in per) { //thanh toán định kì theo ngày if (periodic1.id_Time == "1" && periodic1.date_s.AddDays(1) == DateTime.Today) { Income_Outcome income = new Income_Outcome(); income.Amount = periodic1.Amount_Per; income.Description_come = "Thanh toán định kì"; income.Date_come = DateTime.Today.ToString(); income.Id_Per = periodic1.Id_Per.ToString(); income.WalletId_Wallet = periodic1.Id_Wallet; wallet.Amount_now = wallet.Amount_now - periodic1.Amount_Per; _context.Income_Outcomes.Add(income); } //thanh toán định kì theo tuần if (periodic1.id_Time == "2" && periodic1.date_s.AddDays(7) == DateTime.Today) { Income_Outcome income = new Income_Outcome(); income.Amount = periodic1.Amount_Per; income.Description_come = "Thanh toán định kì"; income.Date_come = DateTime.Today.ToString(); income.Id_Per = periodic1.Id_Per.ToString(); income.WalletId_Wallet = periodic1.Id_Wallet; income.Is_Come = false; wallet.Amount_now = wallet.Amount_now - periodic1.Amount_Per; _context.Income_Outcomes.Add(income); } //thanh toán định kì theo tháng if (periodic1.id_Time == "2" && periodic1.date_s.AddDays(DateTime.DaysInMonth(periodic1.date_s.Year, periodic1.date_s.Month)) == DateTime.Today) { Income_Outcome income = new Income_Outcome(); income.Amount = periodic1.Amount_Per; income.Description_come = "Thanh toán định kì"; income.Date_come = DateTime.Today.ToString(); income.Id_Per = periodic1.Id_Per.ToString(); income.WalletId_Wallet = periodic1.Id_Wallet; income.Is_Come = false; wallet.Amount_now = wallet.Amount_now - periodic1.Amount_Per; _context.Income_Outcomes.Add(income); } //thanh toán định kì theo tháng if (periodic1.id_Time == "2" && periodic1.date_s.AddDays(365) == DateTime.Today) { Income_Outcome income = new Income_Outcome(); income.Amount = periodic1.Amount_Per; income.Description_come = "Thanh toán định kì"; income.Date_come = DateTime.Today.ToString(); income.Id_Per = periodic1.Id_Per.ToString(); income.WalletId_Wallet = periodic1.Id_Wallet; income.Is_Come = false; wallet.Amount_now = wallet.Amount_now - periodic1.Amount_Per; _context.Income_Outcomes.Add(income); } if (periodic1.date_e <= DateTime.Today) { periodic1.isFinnish = true; _context.Periodic.Update(periodic1); } } _context.Wallets.Update(wallet); _context.SaveChanges(); var per1 = _context.Periodic .Where(w => w.Id_Wallet == id); foreach (Periodic periodic in per1) { if (periodic.Id_Cate == null) { var log = from a in _context.Periodic join c in _context.TypeCategories on a.Id_Type equals c.Id_type.ToString() join d in _context.Time_Periodic on a.id_Time equals d.id_Time.ToString() where (a.Id_Cate == null && a.Id_Per == periodic.Id_Per) select new { idwallet = a.Id_Wallet, idPeriodic = a.Id_Per, name = c.Name_Type, image = c.Image_Type, amount = a.Amount_Per, date_s = a.date_s, date_e = a.date_e, time = d.desciption, is_Finish = a.date_e >= DateTime.Now ? false : true, date_time_s = a.date_s, date_time_e = (a.id_Time == "1" ? a.date_s.AddDays(1) : a.id_Time == "2" ? a.date_s.AddDays(7) : a.id_Time == "3" ? DateTime.Today.AddDays(DateTime.DaysInMonth(2020, DateTime.Today.Month) - DateTime.Today.Day) : DateTime.Today.AddDays(365 - (a.date_s.DayOfYear - 1))) }; var get = log.Where(m => m.idwallet.Equals(id)).AsEnumerable(); foreach (object l in get) { list.Add(l); } } if (periodic.Id_Type == null) { var log = from a in _context.Periodic join b in _context.Categories on a.Id_Cate equals b.Id_Cate.ToString() join d in _context.Time_Periodic on a.id_Time equals d.id_Time.ToString() where (a.Id_Type == null && a.Id_Per == periodic.Id_Per) select new { idwallet = a.Id_Wallet, idPeriodic = a.Id_Per, name = b.NameCate, image = b.ImageCate, amount = a.Amount_Per, date_s = a.date_s, date_e = a.date_e, time = d.desciption, is_Finish = a.date_e >= DateTime.Now ? false : true, date_time_s = a.date_s, date_time_e = (a.id_Time == "1" ? a.date_s.AddDays(1) : a.id_Time == "2" ? a.date_s.AddDays(7) : a.id_Time == "3" ? DateTime.Today.AddDays(DateTime.DaysInMonth(2020, DateTime.Today.Month) - DateTime.Today.Day) : DateTime.Today.AddDays(365 - (a.date_s.DayOfYear - 1))) }; var get = log.Where(m => m.idwallet.Equals(id)).AsEnumerable(); foreach (object l in get) { list.Add(l); } } } ResponseModel res1 = new ResponseModel("Periodic", list, "404"); return(res1); }
public ResponseModel PostTransfers([FromBody] Transfers transfers) { int id_chuyen = transfers.id_chuyen; int id_nhan = transfers.id_nhan; float amount = transfers.amount; string dis = transfers.desciption; Wallet wallet_chuyen = _context.Wallets.Where(x => x.Id_Wallet == id_chuyen).FirstOrDefault(); Wallet wallet_nhan = _context.Wallets.Where(x => x.Id_Wallet == id_nhan).FirstOrDefault(); try { if (wallet_chuyen != null && wallet_nhan != null) { wallet_chuyen.Amount_now = wallet_chuyen.Amount_now - amount; wallet_nhan.Amount_now = wallet_nhan.Amount_now + amount; if (transfers.desciption == "") { transfers.desciption = "Chuyển khoản"; } transfers.date = DateTime.Today; Income_Outcome income_chuyen = new Income_Outcome(); Income_Outcome income_nhan = new Income_Outcome(); income_chuyen.Amount = amount; income_chuyen.Date_come = DateTime.Today.ToString(); if (transfers.desciption == "") { income_chuyen.Description_come = "Chuyển khoản "; } else { income_chuyen.Description_come = transfers.desciption; } income_chuyen.WalletId_Wallet = id_chuyen.ToString(); income_chuyen.Is_Come = false; income_chuyen.Id_type = "16"; income_chuyen.CategoryId_Cate = null; income_chuyen.LoanId_Loan = null; income_chuyen.TripId_Trip = null; _context.Income_Outcomes.Add(income_chuyen); income_nhan.Amount = amount; income_nhan.Date_come = DateTime.Today.ToString(); income_nhan.Description_come = "Nhận chuyển khoản "; income_nhan.WalletId_Wallet = id_nhan.ToString(); income_nhan.Is_Come = true; income_nhan.Id_type = "16"; income_nhan.CategoryId_Cate = null; income_nhan.LoanId_Loan = null; income_nhan.TripId_Trip = null; _context.Income_Outcomes.Add(income_nhan); _context.Transfers.Add(transfers); _context.Wallets.Update(wallet_chuyen); _context.Wallets.Update(wallet_nhan); _context.SaveChanges(); ResponseModel res = new ResponseModel("Transfers success", null, "200"); return(res); } else { ResponseModel res = new ResponseModel("Transfers fail", null, "404"); return(res); } } catch { ResponseModel res = new ResponseModel("Transfers fail", null, "404"); return(res); } }
public ResponseModel GetgetBudget([FromQuery] string id) { var list = new ArrayList(); var budget = _context.Budget .Where(w => w.Id_Wallet == id); foreach (Budget budget1 in budget) { if (budget1.time_e < DateTime.Today) { budget1.isFinnish = true; _context.Budget.Update(budget1); } } _context.SaveChanges(); var budget_ = _context.Budget .Where(w => w.Id_Wallet == id); foreach (Budget budget1 in budget_) { if (budget1.Id_Cate == null) { var log = from a in _context.Budget join c in _context.TypeCategories on a.Id_type equals c.Id_type.ToString() //join d in _context.Time_Periodic //on a.id_Time equals d.id_Time.ToString() where (a.Id_Cate == null && a.Id_Budget == budget1.Id_Budget) select new { idwallet = a.Id_Wallet, idBudget = a.Id_Budget, name = c.Name_Type, image = c.Image_Type, amount = a.Amount_Budget, remain = a.Remain, time_s = a.time_s, time_e = a.time_e, time_remain = (a.time_e - DateTime.Now), check = a.time_e < DateTime.Now ? true : false, date_time_s = a.time_s, date_time_e = a.time_e //(a.id_Time == "1" ? a.time_s.AddDays(1) : //a.id_Time == "2" ? a.time_s.AddDays(7) : //a.id_Time == "3" ? DateTime.Today.AddDays(DateTime.DaysInMonth(2020, DateTime.Today.Month) - DateTime.Today.Day) : //DateTime.Today.AddDays(365 - (a.time_s.DayOfYear - 1))) }; var get = log.Where(m => m.idwallet.Equals(id)).AsEnumerable(); foreach (object l in get) { list.Add(l); } } if (budget1.Id_type == null) { var log = from a in _context.Budget join b in _context.Categories on a.Id_Cate equals b.Id_Cate.ToString() //join d in _context.Time_Periodic //on a.id_Time equals d.id_Time.ToString() where (a.Id_type == null && a.Id_Budget == budget1.Id_Budget) select new { idwallet = a.Id_Wallet, idBudget = a.Id_Budget, name = b.NameCate, image = b.ImageCate, amount = a.Amount_Budget, remain = a.Remain, time_s = a.time_s, time_e = a.time_e, time_remain = (a.time_e - DateTime.Now), check = a.time_e < DateTime.Now ? true : false, date_time_s = a.time_s, date_time_e = a.time_e //(a.id_Time == "1" ? a.time_s.AddDays(1) : //a.id_Time == "2" ? a.time_s.AddDays(7) : //a.id_Time == "3" ? DateTime.Today.AddDays(DateTime.DaysInMonth(2020, DateTime.Today.Month) - DateTime.Today.Day) : //DateTime.Today.AddDays(365 - (a.time_s.DayOfYear - 1))) }; var get = log.Where(m => m.idwallet.Equals(id)).AsEnumerable(); foreach (object l in get) { list.Add(l); } } } ResponseModel res1 = new ResponseModel("Budget", list, "200"); return(res1); }