public IActionResult ValidateName([FromBody] MoistureReader model)
{
if (model == null)
{
return(NotFound());
}
if (General.IsDevelopment)
{
logger.LogDebug(ModelState.ToJson());
}
var existing = repository.Get().FirstOrDefault(a => a.Description == model.Description);
if (existing == null)
{
return(Accepted(true));
}
if (existing.MoistureReaderId != model.MoistureReaderId)
{
return(UnprocessableEntity(Constants.ErrorMessages.EntityExists("Description")));
}
else
{
return(Accepted(true));
}
}
public MoistureReader Update(MoistureReader model)
{
var entity = dbContext.MoistureReaders.Find(model.MoistureReaderId);
if (entity == null)
{
throw new Exception("Selected Record does not exists.");
}
if (entity.Description.Trim() != model.Description?.Trim())
{
var qry = $@"UPDATE PurchaseTransactions SET
{nameof(PurchaseTransaction.MoistureReaderDesc)} = '{model.Description}'
WHERE {nameof(PurchaseTransaction.MoistureReaderId)} = {entity.MoistureReaderId}";
dbContext.Database.ExecuteSqlRaw(qry);
qry = $@"UPDATE SaleTransactions SET
{ nameof(SaleTransaction.MoistureReaderDesc)} = '{model.Description}'
WHERE { nameof(SaleTransaction.MoistureReaderId)} = { entity.MoistureReaderId}";
dbContext.Database.ExecuteSqlRaw(qry);
}
entity.Description = (model.Description ?? "").ToUpper();
dbContext.MoistureReaders.Update(entity);
dbContext.SaveChanges();
return(entity);
}
public bool ValidateName(MoistureReader model)
{
var existing = Get().FirstOrDefault(a => a.Description == model.Description);
if (existing == null)
{
return(true);
}
return(existing.MoistureReaderId == model.MoistureReaderId);
}
private bool validateEntity(MoistureReader model)
{
var validName = repository.ValidateName(model);
if (!validName)
{
ModelState.AddModelError(nameof(MoistureReader.Description), Constants.ErrorMessages.EntityExists("MC Reader"));
}
return(ModelState.ErrorCount == 0);
}
public IActionResult Get([FromQuery] MoistureReader parameters = null)
{
try
{
var model = repository.Get(parameters);
return(Ok(model));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.FetchError));
}
}
public IActionResult Post([FromBody] MoistureReader model)
{
try
{
if (!ModelState.IsValid)
{
return(InvalidModelStateResult());
}
if (!validateEntity(model))
{
return(InvalidModelStateResult());
}
return(Accepted(repository.Create(model)));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.CreateError));
}
}
public IActionResult Put([FromBody] MoistureReader model)
{
try
{
if (!ModelState.IsValid)
{
return(InvalidModelStateResult());
}
if (!validateEntity(model))
{
return(InvalidModelStateResult());
}
if (repository.Get().Count(a => a.MoistureReaderId.Equals(model.MoistureReaderId)) == 0)
{
return(NotFound(Constants.ErrorMessages.NotFoundEntity));
}
return(Accepted(repository.Update(model)));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.UpdateError));
}
}
public bool ValidateCode(MoistureReader model)
{
throw new NotFiniteNumberException();
}
public IQueryable <MoistureReader> Get(MoistureReader parameters = null)
{
return(dbContext.MoistureReaders.AsNoTracking());
}
public bool Delete(MoistureReader model)
{
dbContext.MoistureReaders.Remove(model);
dbContext.SaveChanges();
return(true);
}
public MoistureReader Create(MoistureReader model)
{
dbContext.MoistureReaders.Add(model);
dbContext.SaveChanges();
return(model);
}
public SqlRawParameter GetSqlRawParameter(MoistureReader parameters)
{
throw new NotImplementedException();
}
