public WeighingArea Update(WeighingArea weighingAreaChanges) { weighingAreaChanges.AreaCode = weighingAreaChanges.AreaCode.ToUpperCase(); weighingAreaChanges.AreaDesc = weighingAreaChanges.AreaDesc.ToUpperCase(); var parameters = new List <ParameterInfo> { new ParameterInfo() { ParameterName = nameof(WeighingArea.WeighingAreaId).Parameterize(), ParameterValue = weighingAreaChanges.WeighingAreaId }, new ParameterInfo() { ParameterName = nameof(WeighingArea.AreaCode).Parameterize(), ParameterValue = weighingAreaChanges.AreaCode }, new ParameterInfo() { ParameterName = nameof(WeighingArea.AreaDesc).Parameterize(), ParameterValue = weighingAreaChanges.AreaDesc } }; StringBuilder qry = new StringBuilder(); qry.AppendLine("Update WeighingAreas set"); qry.AppendLine($"{nameof(weighingAreaChanges.AreaCode)}={nameof(weighingAreaChanges.AreaCode).Parameterize()}" + (char)44); qry.AppendLine($"{nameof(weighingAreaChanges.AreaDesc)}={nameof(weighingAreaChanges.AreaDesc).Parameterize()}"); qry.AppendLine($"where {nameof(weighingAreaChanges.WeighingAreaId)} = {nameof(weighingAreaChanges.WeighingAreaId).Parameterize()}"); DBContext.ExecuteQuery(qry.ToString(), parameters); return(weighingAreaChanges); }
public WeighingArea Create(WeighingArea weighingArea) { weighingArea.AreaCode = weighingArea.AreaCode.ToUpperCase(); weighingArea.AreaDesc = weighingArea.AreaDesc.ToUpperCase(); var parameters = new List <ParameterInfo> { new ParameterInfo() { ParameterName = nameof(weighingArea.WeighingAreaId).Parameterize(), ParameterValue = weighingArea.WeighingAreaId }, new ParameterInfo() { ParameterName = nameof(weighingArea.AreaCode).Parameterize(), ParameterValue = weighingArea.AreaCode }, new ParameterInfo() { ParameterName = nameof(weighingArea.AreaDesc).Parameterize(), ParameterValue = weighingArea.AreaDesc } }; var qry = new StringBuilder(); qry.AppendLine("insert into WeighingAreas ("); qry.AppendLine(nameof(weighingArea.AreaCode) + (char)44); qry.AppendLine(nameof(weighingArea.AreaDesc)); qry.AppendLine(") values ("); qry.AppendLine(nameof(weighingArea.AreaCode).Parameterize() + (char)44); qry.AppendLine(nameof(weighingArea.AreaDesc).Parameterize()); qry.AppendLine(")"); qry.AppendLine("select @@identity"); weighingArea.WeighingAreaId = DBContext.ExecuteQueryWithIdentityInt64(qry.ToString(), parameters); return(weighingArea); }
public IActionResult Post([FromBody] WeighingArea model) { if (ModelState.IsValid) { _repository.Create(model); return(Ok(model)); } else { return(new ResponseResult(Response) { StatusCode = (int)StatusCodes.Status400BadRequest, ResponseObject = ModelState.ToJson() }.ToJsonResult()); } }