public static void UpdatePayments(decimal newBill = 0) { var data = LoadBills(); var numRoommates = RoommateProcessor.LoadRoommates().Count; decimal newPayments = newBill; foreach (var item in data) { newPayments += item.AmountDue; } newPayments /= numRoommates; //TODO this may need to go now too string sql = $"sp_UpdatePayment '{newPayments}'"; SqlDataAccess.SaveData(sql, newPayments); }
public static int CreatePayment(int billId, int roommateId, decimal amountPaid) { var bills = BillProcessor.GetBillById(billId); var roommates = RoommateProcessor.GetRoommateById(roommateId); var data = new PaymentModel { RoommateId = roommateId, BillId = billId, AmountPaid = amountPaid }; //display payment string sql = $"sp_AddPayment '{billId}', '{roommateId}', '{amountPaid}'"; SqlDataAccess.SaveData(sql, data); decimal newAmount = bills.AmountDue - amountPaid; ApplyPayment(newAmount, billId); RemoveAssignedBill(billId, roommateId); Utilities.OnBillPaid(billId); return(0); }