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());
}
}
