using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; using Microsoft.AspNetCore.Mvc.Rendering; using CertAuth.Data; using CertAuth.Domain; using Microsoft.EntityFrameworkCore; namespace CertAuthAdmin.Pages.RFIDTagMaster { public class AddRFIDTagModel : PageModel { private readonly CertAuth.Data.CertAuthContext _context; private readonly Models.TableDtlDA TDCtrlr; private readonly Models.RFIDTagMstrDA RTMCtrl; [BindProperty] public RFIDTagMstr RFIDTagMstr { get; set; } public SelectList slStatus { get; set; } public List sliStatus { get; set; } public SelectList slVendor { get; set; } public List sliVendor { get; set; } public List tblDtl { get; set; } public List VenMstr { get; set; } public CertAuth.Domain.VendorMstr tblVendrMstr { get; set; } public AddRFIDTagModel(CertAuth.Data.CertAuthContext context) { _context = context; TDCtrlr = new Models.TableDtlDA(); RTMCtrl = new Models.RFIDTagMstrDA(_context); } public IActionResult OnGet() { LoadLists(); return Page(); } // To protect from overposting attacks, enable the specific properties you want to bind to, for // more details, see https://aka.ms/RazorPagesCRUD. public async Task OnPostAsync() { if (Exists(RFIDTagMstr.TagUID)) { ModelState.AddModelError("RFIDTagMstr.TagEPC", "This RFID Tag has already exists."); } //if (_context.VendorMstr.Any(e => e.VendorName == RFIDTagMstr.SoldToVendorName)) //{ ModelState.AddModelError("RFIDTagMstr.SoldToVendorName", $"Vendor {RFIDTagMstr.SoldToVendorName} already exists"); } if (!ModelState.IsValid) { LoadLists(); return Page(); } //_context.Attach(RFIDTagMstr).State = EntityState.Added; try { //tblVendrMstr = await _context.VendorMstr.FirstOrDefaultAsync(x => x.Id == RFIDTagMstr.SoldToID); //if (tblVendrMstr != null && tblVendrMstr.VendorName != null) //{ RFIDTagMstr.SoldToVendorName = tblVendrMstr.VendorName; } //else { RFIDTagMstr.SoldToVendorName = ""; } RFIDTagMstr.Id = null; RFIDTagMstr.TimeStamp = DateTime.Now; //_context.RFIDTagMstr.Add(RFIDTagMstr); RTMCtrl.InsertTagMstr(RFIDTagMstr); //await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (Exists(RFIDTagMstr.TagUID)) { return BadRequest(); } else { throw; } } return RedirectToPage("./RFIDTagList"); } private bool Exists(string pTagUID) { return _context.RFIDTagMstr.Any(e => e.TagUID == pTagUID); } private void LoadLists() { bool slct; slStatus = new SelectList(TDCtrlr.GetSlctItms("Status", "A", true, ""), "Value", "Text"); slct = false; VenMstr = _context.VendorMstr.ToList(); sliVendor = new List(); foreach (var itm in VenMstr) { //if (itm.Id == RFIDTagMstr.SoldToID) { slct = true; } sliVendor.Add(new SelectListItem() { Value = itm.Id.ToString(), Text = itm.VendorName, Selected = slct }); slct = false; }; slVendor = new SelectList(sliVendor, "Value", "Text"); } } }