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; using System.Runtime.Intrinsics; namespace CertAuthAdmin.Controllers { [Route("api/[controller]/[action]")] public class RFIDTagMstrController : Controller { private CertAuthContext _context; public RFIDTagMstrController(CertAuthContext context) { _context = context; } [HttpGet] public async Task Get(DataSourceLoadOptions loadOptions) { var rfidtagmstr = _context.RFIDTagMstr.Select(i => new { i.Id, i.TagUID, i.TagSignature, i.TagEncryption, i.SoldToVendorKey, 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[] { "Id" }; // loadOptions.PaginateViaPrimaryKey = true; return Json(await DataSourceLoader.LoadAsync(rfidtagmstr, loadOptions)); } [HttpPost] public async Task Post(string values) { var model = new RFIDTagMstr(); var valuesDict = JsonConvert.DeserializeObject(values); PopulateModel(model, valuesDict); if(!TryValidateModel(model)) return BadRequest(GetFullErrorMessage(ModelState)); var result = _context.RFIDTagMstr.Add(model); await _context.SaveChangesAsync(); return Json(result.Entity.Id); } [HttpPut] public async Task Put(int key, string values) { var model = await _context.RFIDTagMstr.FirstOrDefaultAsync(item => item.Id == key); if(model == null) return StatusCode(409, "RFIDTagMstr not found"); var valuesDict = JsonConvert.DeserializeObject(values); PopulateModel(model, valuesDict); if(!TryValidateModel(model)) return BadRequest(GetFullErrorMessage(ModelState)); await _context.SaveChangesAsync(); return Ok(); } [HttpDelete] public async Task Delete(int key) { var model = await _context.RFIDTagMstr.FirstOrDefaultAsync(item => item.Id == key); _context.RFIDTagMstr.Remove(model); await _context.SaveChangesAsync(); } private void PopulateModel(RFIDTagMstr model, IDictionary values) { string ID = nameof(RFIDTagMstr.Id); string TAG_UID = nameof(RFIDTagMstr.TagUID); string TAG_SIGNATURE = nameof(RFIDTagMstr.TagSignature); string TAG_ENCRYPTION = nameof(RFIDTagMstr.TagEncryption); string SOLD_TO_VENDOR_KEY = nameof(RFIDTagMstr.SoldToVendorKey); string STATUS = nameof(RFIDTagMstr.Status); string TIME_STAMP = nameof(RFIDTagMstr.TimeStamp); if(values.Contains(ID)) { model.Id = Convert.ToInt32(values[ID]); } if(values.Contains(TAG_UID)) { model.TagUID = Convert.ToString(values[TAG_UID]); } if(values.Contains(TAG_SIGNATURE)) { model.TagSignature = Convert.ToString(values[TAG_SIGNATURE]); } if(values.Contains(TAG_ENCRYPTION)) { model.TagEncryption = Convert.ToString(values[TAG_ENCRYPTION]); } if(values.Contains(SOLD_TO_VENDOR_KEY)) { model.SoldToVendorKey = Convert.ToInt32(values[SOLD_TO_VENDOR_KEY]); } 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); } [AcceptVerbs("Post", "Put")] public IActionResult CheckVndrName(string vname) { if(_context.VendorMstr.Any(e => e.VendorName == vname)) { return Json($"Vendor {vname} already exists"); } return Json(true); } } }