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 TableMstrController : Controller { private CertAuthContext _context; public TableMstrController(CertAuthContext context) { _context = context; } [HttpGet] public async Task Get(DataSourceLoadOptions loadOptions) { var tablemstr = _context.TableMstr.Select(i => new { i.Id, i.TableCode, i.TableDescShort, i.TableDescLong, 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(tablemstr, loadOptions)); } [HttpPost] public async Task Post(string values) { var model = new TableMstr(); var valuesDict = JsonConvert.DeserializeObject(values); PopulateModel(model, valuesDict); //if(!TryValidateModel(model)) // return BadRequest(GetFullErrorMessage(ModelState)); var result = _context.TableMstr.Add(model); await _context.SaveChangesAsync(); return Json(result.Entity.Id); } [HttpPut] public async Task Put(int key, string values) { var model = await _context.TableMstr.FirstOrDefaultAsync(item => item.Id == key); int affectedRecs = 0; if (model == null) return StatusCode(409, "TableMstr not found"); var valuesDict = JsonConvert.DeserializeObject(values); PopulateModel(model, valuesDict); if(!TryValidateModel(model)) return BadRequest(GetFullErrorMessage(ModelState)); model.TimeStamp = DateTime.Now; _context.TableMstr.Update(model); affectedRecs = await _context.SaveChangesAsync(); return Ok(); } [HttpDelete] public async Task Delete(int key) { var model = await _context.TableMstr.FirstOrDefaultAsync(item => item.Id == key); _context.TableMstr.Remove(model); await _context.SaveChangesAsync(); } private void PopulateModel(TableMstr model, IDictionary values) { string ID = nameof(TableMstr.Id); string TABLE_CODE = nameof(TableMstr.TableCode); string TABLE_DESC_SHORT = nameof(TableMstr.TableDescShort); string TABLE_DESC_LONG = nameof(TableMstr.TableDescLong); string STATUS = nameof(TableMstr.Status); string TIME_STAMP = nameof(TableMstr.TimeStamp); if(values.Contains(ID)) { model.Id = Convert.ToInt32(values[ID]); } if(values.Contains(TABLE_CODE)) { model.TableCode = Convert.ToString(values[TABLE_CODE]); } if(values.Contains(TABLE_DESC_SHORT)) { model.TableDescShort = Convert.ToString(values[TABLE_DESC_SHORT]); } if(values.Contains(TABLE_DESC_LONG)) { model.TableDescLong = Convert.ToString(values[TABLE_DESC_LONG]); } 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); } } }