public async Task <IActionResult> Create([Bind("bill_id,date_generated,due_date,cust_ids,cust_id,premise_id,address,amount,status")] Bill_Information bill_Information)
        {
            if (ModelState.IsValid)
            {
                JPSUser data = await userManager.FindByIdAsync(bill_Information.cust_id);

                bill_Information.premise_id = data.premise_number;

                var address = await _context.PREMISE_DETAILS.FirstOrDefaultAsync(m => m.ID == "PREPJPS200");

                bill_Information.address = address.LOCATION_ADDRESS;

                BillDatabaseModel model = new BillDatabaseModel
                {
                    address        = bill_Information.address,
                    amount         = bill_Information.amount,
                    bill_id        = bill_Information.bill_id,
                    cust_id        = bill_Information.cust_id,
                    date_generated = bill_Information.date_generated,
                    due_date       = bill_Information.due_date,
                    premise_id     = bill_Information.premise_id,
                    status         = bill_Information.status
                };

                _context.Bill_Information.Add(model);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(bill_Information));
        }
        public async Task <IActionResult> Edit(string id, [Bind("bill_id,date_generated,due_date,cust_id,premise_id,address,amount,status")] Bill_Information bill_Information)
        {
            if (id != bill_Information.bill_id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    BillDatabaseModel model = new BillDatabaseModel
                    {
                        address        = bill_Information.address,
                        amount         = bill_Information.amount,
                        bill_id        = bill_Information.bill_id,
                        cust_id        = bill_Information.cust_id,
                        date_generated = bill_Information.date_generated,
                        due_date       = bill_Information.due_date,
                        premise_id     = bill_Information.premise_id,
                        status         = bill_Information.status
                    };

                    _context.Update(model);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!Bill_InformationExists(bill_Information.bill_id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(bill_Information));
        }