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 Microsoft.EntityFrameworkCore; using CertAuth.Data; using CertAuth.Domain; //using CertAuthAdmin.Controllers; //using CertAuthAPI.Controllers; using CertAuthAdmin.Models; using System.Media; using DevExtreme.AspNet.Data; using DevExtreme.AspNet.Mvc; //using CertAuthAdmin.Controllers; using Newtonsoft.Json; using Microsoft.EntityFrameworkCore.Metadata.Internal; using Microsoft.AspNetCore.Mvc.Routing; namespace CertAuthAdmin.Pages.Users { // THIS IS A SAMPLE Version public class AddUserModel : PageModel { private readonly CertAuth.Data.CertAuthContext _context; private readonly Models.TableDtlDA TDCtrlr; [BindProperty] public User user { get; set; } public List tblDtl { get; set; } //public UsersController _UC; public SelectList slUserType { get; set; } //public List sliUType { get; set; } public SelectList slOrganizations { get; set; } //public List sliOrg { get; set; } public SelectList slEmpSecuity { get; set; } //public List sliEmpSec { get; set; } public SelectList slStatus { get; set; } //public List sliStatus { get; set; } public AddUserModel(CertAuth.Data.CertAuthContext context) { _context = context; TDCtrlr = new Models.TableDtlDA(); //slUserType = new SelectList(TDCtrlr.GetByTableCode("UserType", "Active")); //slOrganizations = new SelectList(TDCtrlr.GetByTableCode("Organization", "Active")); //slEmpSecuity = new SelectList(TDCtrlr.GetByTableCode("EmpSecurity", "Active")); //slStatus = new SelectList(TDCtrlr.GetByTableCode("Status", "Active")); //_UC = UC; } public async Task OnGetAsync() { LoadLists(); //DataSourceLoadOptions lopt = new DataSourceLoadOptions(); //var jsonUser = await _UC.GetByUserID(lopt, "lbolinger"); //_User = JsonConvert.DeserializeObject(jsonUser.ToString()); } public async Task OnPostAsync() { if (UserExists(user.UserID)) { //return Page(); ModelState.AddModelError("user.UserID", "This User Id has already been used."); } if (!ModelState.IsValid) { LoadLists(); return Page(); } //User user1 = user; user.TimeStamp = DateTime.Now; _context.Attach(user).State = EntityState.Added; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (UserExists(user.UserID)) { //return NotFound(); return BadRequest(); } //else { throw; } } return RedirectToPage("./UsersList"); } private bool UserExists(string id) { return _context.Users.Any(e => e.UserID == id); } private void LoadLists() { bool slct = false; slStatus = new SelectList(TDCtrlr.GetSlctItms("Status", "A", false, ""), "Value", "Text"); slUserType = new SelectList(TDCtrlr.GetSlctItms("UserType", "A", false, ""), "Value", "Text"); slOrganizations = new SelectList(TDCtrlr.GetSlctItms("Organization", "A", false, ""), "Value", "Text"); slEmpSecuity = new SelectList(TDCtrlr.GetSlctItms("EmpSecurity", "A", false, ""), "Value", "Text"); //tblDtl = TDCtrlr.GetRecrdByTableCode("UserType", "Active"); //sliUType = new List(); //foreach (var itm in tblDtl) //{ // //if (user.UserType == itm.DetailCode) // //{ slct = true; } // sliUType.Add(new SelectListItem() // { // Value = itm.DetailCode, // Text = itm.CodeDescShort, // Selected = slct // }); // slct = false; //}; //slUserType = new SelectList(sliUType, "Value", "Text"); //slOrganizations = new SelectList(TDCtrlr.GetByTableCode("Organization", "Active")); //slct = false; //tblDtl = TDCtrlr.GetRecrdByTableCode("Organization", "Active"); //sliOrg = new List(); //foreach (var itm in tblDtl) //{ // //if (user.OrganizationID == itm.DetailCode) // //{ slct = true; } // sliOrg.Add(new SelectListItem() // { // Value = itm.DetailCode, // Text = itm.CodeDescShort, // Selected = slct // }); // slct = false; //}; //slOrganizations = new SelectList(sliOrg, "Value", "Text"); //Employee Security //slct = false; //tblDtl = TDCtrlr.GetRecrdByTableCode("EmpSecurity", "Active"); //sliEmpSec = new List(); //foreach (var itm in tblDtl) //{ // //if (user.EmployeeSecurity == itm.DetailCode) // //{ slct = true; } // sliEmpSec.Add(new SelectListItem() // { // Value = itm.DetailCode, // Text = itm.CodeDescShort, // Selected = slct // }); // slct = false; //}; //slEmpSecuity = new SelectList(sliEmpSec, "Value", "Text"); ////Status //slct = false; //tblDtl = TDCtrlr.GetRecrdByTableCode("Status", "Active"); //sliStatus = new List(); //foreach (var itm in tblDtl) //{ // //if (user.Status == itm.DetailCode) // //{ slct = true; } // sliStatus.Add(new SelectListItem() // { // Value = itm.DetailCode, // Text = itm.CodeDescShort, // Selected = slct // }); // slct = false; //}; //slStatus = new SelectList(sliStatus, "Value", "Text"); } } }