'how to Get the last added value in TABalance coulmn in database and show it in TSBalance input automatically when the page loaded

my html code


                <div class="border backgroundWhite border-info">
                    <div class="row">
                        <div class="col-6">
                            <div class="form-group row">
                                <div class="col-4">
                                    <label asp-for="Shift.TSBalance"></label>
                                </div>
                                <div class="col-6">
                                    <input asp-for="Shift.TSBalance" class="form-control" id="sbalance"/>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-4">
                                    <label asp-for="Shift.TSupply"></label>
                                </div>
                                <div class="col-6">
                                    <input asp-for="Shift.TSupply" class="form-control" id="supply" value="0" onkeyup="sum()" type="text"/>
                                </div>
                                <span asp-validation-for="Shift.TSupply" class="text-danger"></span>
                            </div>
                            <div class="form-group row">
                                <div class="col-4">
                                    <label asp-for="Shift.TTotal"></label>
                                </div>
                                <div class="col-6">
                                    <input asp-for="Shift.TTotal" class="form-control" readonly id="trbalance" value="0" onkeyup="sum()" type="text"/>
                                </div>
                                <span asp-validation-for="Shift.TTotal" class="text-danger"></span>
                            </div>
                        </div>
                        <div class="col-6">
                            <div class="form-group row">
                                <div class="col-7">
                                    <label asp-for="Shift.TCBalance"></label>
                                </div>
                                <div class="col-5">
                                    <input asp-for="Shift.TCBalance" class="form-control" id="calcebalance" value="0" onkeyup="sum()" type="text" readonly/>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-7">
                                    <label asp-for="Shift.TABalance"></label>
                                </div>
                                <div class="col-5">
                                    <input asp-for="Shift.TABalance" class="form-control" id="actualebalance" value="0" onkeyup="sum()" type="text" />
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-7">
                                    <label asp-for="Shift.TDifferance" class="text-info"></label>
                                </div>
                                <div class="col-5">
                                    <input asp-for="Shift.TDifferance" class="form-control" style="background-color:blue;color:white;font-size:larger" id="differance" value="0" onkeyup="sum()" type="text" readonly />
                                </div>
                            </div>
                        </div>
                     </div>
                      
                    
                </div>

            </div>
        </div>

my page model

namespace Elwady.Pages.ShiftClosing
{
    public class CreateModel : PageModel
    {
        private readonly ApplicationDbContext _db;
        public SelectList Exlist { get; set; }
        [BindProperty]
        public Shift Shift { get; set; }
        public CreateModel(ApplicationDbContext db)
        {
            _db = db;
        }
        public IActionResult OnGet()
        {
            this.Exlist = new SelectList(_db.ExpensesList, "Id", "ExName");
            return Page();
        }
        public async Task<IActionResult> OnPostAsync()
        {
            if (!ModelState.IsValid)
            {
                return Page();
            };
            _db.Shift.Add(Shift);
            await _db.SaveChangesAsync();
            return RedirectToPage("../Index");
        }
    }
}

my data table

public class Shift
    {
        public int Id { get; set; }
        public int TSBalance { get; set; }
        public int TSupply { get; set; }
        public int TTotal { get; set; }
        public int TCBalance { get; set; }
        public int TABalance { get; set; }
        public int TDifferance { get; set; }

    }

attached image to show clearly how you can support

enter image description here

i tried to get this value through assigning it to variable in get handler but i can't and tried to Asp-for model variable but i get an error in the Ui if i need to print out this form after submit to specific printer, how can i do that?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source