using DevExtreme.AspNet.Data; using DevExtreme.AspNet.Mvc; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.ModelBinding; using Microsoft.EntityFrameworkCore; using Newtonsoft.Json; using System; using System.Collections; using System.Collections.Generic; using System.Globalization; using System.Linq; using System.Threading.Tasks; using CertAuth.Data; using CertAuth.Domain; namespace CertAuthAdmin.Controllers { [Route("api/[controller]/[action]")] public class UsersController : Controller { private CertAuthContext _context; public UsersController(CertAuthContext context) { _context = context; } [HttpGet] public async Task Get(DataSourceLoadOptions loadOptions) { var users = _context.Users.Select(i => new { i.UserID, i.LastName, i.FirstName, i.UserType, i.OrganizationID, i.TagID, i.PhotoBLOB, i.EmployeeSecurity, i.Passphrase, i.Status, i.TimeStamp }); // If you work with a large amount of data, consider specifying the PaginateViaPrimaryKey and PrimaryKey properties. // In this case, keys and data are loaded in separate queries. This can make the SQL execution plan more efficient. // Refer to the topic https://github.com/DevExpress/DevExtreme.AspNet.Data/issues/336. // loadOptions.PrimaryKey = new[] { "UserID" }; // loadOptions.PaginateViaPrimaryKey = true; return Json(await DataSourceLoader.LoadAsync(users, loadOptions)); } [HttpGet] public async Task GetByUserID(DataSourceLoadOptions loadopt, string UID) { IList UserByID = await _context.Users.FromSqlInterpolated($"EXEC dbo.Users_GetByUserID {UID}").ToListAsync(); //return Json(DataSourceLoader.Load(UserByID, loadopt)); //return Json(UserByID); return Ok(UserByID); } [HttpPost] public async Task Post(string values) { var model = new User(); var valuesDict = JsonConvert.DeserializeObject(values); PopulateModel(model, valuesDict); if (!TryValidateModel(model)) return BadRequest(GetFullErrorMessage(ModelState)); var result = _context.Users.Add(model); await _context.SaveChangesAsync(); return Json(result.Entity.UserID); } [HttpPut] public async Task Put(string key, string values) { var model = await _context.Users.FirstOrDefaultAsync(item => item.UserID == key); int affectedRecs = 0; if (model == null) return StatusCode(409, "User not found"); var valuesDict = JsonConvert.DeserializeObject(values); PopulateModel(model, valuesDict); if (!TryValidateModel(model)) return BadRequest(GetFullErrorMessage(ModelState)); _context.Users.Update(model); affectedRecs = await _context.SaveChangesAsync(); // _context.SaveChanges(); return Ok(); } [HttpDelete] public async Task Delete(string key) { var model = await _context.Users.FirstOrDefaultAsync(item => item.UserID == key); _context.Users.Remove(model); await _context.SaveChangesAsync(); } [HttpGet] public async Task VerifyUserID(string UserID) { CertAuth.Domain.User _user; _user = await _context.Users.FirstOrDefaultAsync(u => u.UserID == UserID); if (_user == null) { return Json($"User {UserID} does not exist."); }; // 1/4/2022 - LB - commented out following if statement. Caused error when updating. // The userid is going to be already set up as a vendor. //if (_user.VendorKey != 0 || _user.UserType == "Vndr") //{ return Json($"User {UserID} is already a Vendor."); }; return Json(true); } private void PopulateModel(User model, IDictionary values) { string USER_ID = nameof(model.UserID); string LAST_NAME = nameof(model.LastName); string FIRST_NAME = nameof(model.FirstName); string USER_TYPE = nameof(model.UserType); string ORGANIZATION_ID = nameof(model.OrganizationID); string TAG_ID = nameof(model.TagID); string PHOTO_BLOB = nameof(model.PhotoBLOB); string EMPLOYEE_SECURITY = nameof(model.EmployeeSecurity); string PASSPHRASE = nameof(model.Passphrase); string STATUS = nameof(model.Status); string TIME_STAMP = nameof(model.TimeStamp); //string USER_ID = nameof(User.UserID); //string LAST_NAME = nameof(User.LastName); //string FIRST_NAME = nameof(User.FirstName); //string USER_TYPE = nameof(User.UserType); //string ORGANIZATION_ID = nameof(User.OrganizationID); //string TAG_ID = nameof(User.TagID); //string PHOTO_BLOB = nameof(User.PhotoBLOB); //string EMPLOYEE_SECURITY = nameof(User.EmployeeSecurity); //string PASSPHRASE = nameof(User.Passphrase); //string STATUS = nameof(User.Status); //string TIME_STAMP = nameof(User.TimeStamp); if (values.Contains(USER_ID)) { model.UserID = Convert.ToString(values[USER_ID]); } if(values.Contains(LAST_NAME)) { model.LastName = Convert.ToString(values[LAST_NAME]); } if(values.Contains(FIRST_NAME)) { model.FirstName = Convert.ToString(values[FIRST_NAME]); } if(values.Contains(USER_TYPE)) { model.UserType = Convert.ToString(values[USER_TYPE]); } if(values.Contains(ORGANIZATION_ID)) { model.OrganizationID = Convert.ToString(values[ORGANIZATION_ID]); } if(values.Contains(TAG_ID)) { model.TagID = Convert.ToString(values[TAG_ID]); } if(values.Contains(PHOTO_BLOB)) { model.PhotoBLOB = Convert.ToString(values[PHOTO_BLOB]); } if(values.Contains(EMPLOYEE_SECURITY)) { model.EmployeeSecurity = Convert.ToString(values[EMPLOYEE_SECURITY]); } if(values.Contains(PASSPHRASE)) { model.Passphrase = Convert.ToString(values[PASSPHRASE]); } if(values.Contains(STATUS)) { model.Status = Convert.ToString(values[STATUS]); } if(values.Contains(TIME_STAMP)) { model.TimeStamp = Convert.ToDateTime(values[TIME_STAMP]); } } private string GetFullErrorMessage(ModelStateDictionary modelState) { var messages = new List(); foreach(var entry in modelState) { foreach(var error in entry.Value.Errors) messages.Add(error.ErrorMessage); } return String.Join(" ", messages); } } }