private List <ParameterInfo> initParameters(TransferLimitAdj model)
{
var parameters = new List <ParameterInfo>();
parameters.Add(new ParameterInfo()
{
ParameterName = nameof(TransferLimitAdj.TransferLimitAdjId).Parameterize(), ParameterValue = model.TransferLimitAdjId
});
parameters.Add(new ParameterInfo()
{
ParameterName = nameof(TransferLimitAdj.TransferLimitId).Parameterize(), ParameterValue = model.TransferLimitId
});
parameters.Add(new ParameterInfo()
{
ParameterName = nameof(TransferLimitAdj.AdjDate).Parameterize(), ParameterValue = model.AdjDate, ParameterDbType = System.Data.DbType.Date
});
parameters.Add(new ParameterInfo()
{
ParameterName = nameof(TransferLimitAdj.AdjLimit).Parameterize(), ParameterValue = model.AdjLimit
});
parameters.Add(new ParameterInfo()
{
ParameterName = nameof(TransferLimitAdj.AdjRemarks).Parameterize(), ParameterValue = (model.AdjRemarks ?? string.Empty).ToUpper()
});
parameters.Add(new ParameterInfo()
{
ParameterName = nameof(TransferLimitAdj.AdjCreatedById).Parameterize(), ParameterValue = model.AdjCreatedById
});
return(parameters);
}
public TransferLimitAdj Update(TransferLimitAdj modelChanges)
{
var parameters = initParameters(modelChanges);
StringBuilder qry = new StringBuilder();
qry.AppendLine("Update TransferLimitAdjs set");
qry.AppendLine($"{nameof(modelChanges.AdjLimit)}={nameof(modelChanges.AdjLimit).Parameterize()}" + (char)44);
qry.AppendLine($"{nameof(modelChanges.AdjRemarks)}={nameof(modelChanges.AdjRemarks).Parameterize()}");
qry.AppendLine($"where {nameof(modelChanges.TransferLimitAdjId)} = {nameof(modelChanges.TransferLimitAdjId).Parameterize()}");
int success = DBContext.ExecuteQuery(qry.ToString(), parameters);
return(modelChanges);
}
public IActionResult Put(long id, [FromBody] TransferLimitAdj model)
{
if (ModelState.IsValid)
{
model.TransferLimitAdjId = id;
_tlAdjRepo.Update(model);
return(Ok(model));
}
else
{
return(new ResponseResult(Response)
{
StatusCode = (int)StatusCodes.Status400BadRequest, ResponseObject = ModelState.ToJson()
}.ToJsonResult());
}
}
public IActionResult Post([FromBody] TransferLimitAdj model)
{
model.AdjDate = DateTime.Now;
ModelState.Remove(nameof(TransferLimitAdj.AdjDate));
if (ModelState.IsValid)
{
_tlAdjRepo.Create(model);
return(Ok(model));
}
else
{
return(new ResponseResult(Response)
{
StatusCode = (int)StatusCodes.Status400BadRequest, ResponseObject = ModelState.ToJson()
}.ToJsonResult());
}
}
public TransferLimitAdj Create(TransferLimitAdj model)
{
var parameters = initParameters(model);
StringBuilder qry = new StringBuilder();
qry.AppendLine("insert into TransferLimitAdjs (");
qry.AppendLine(nameof(model.AdjDate) + (char)44);
qry.AppendLine(nameof(model.TransferLimitId) + (char)44);
qry.AppendLine(nameof(model.AdjLimit) + (char)44);
qry.AppendLine(nameof(model.AdjRemarks) + (char)44);
qry.AppendLine(nameof(model.AdjCreatedById));
qry.AppendLine(") values (");
qry.AppendLine(nameof(model.AdjDate).Parameterize() + (char)44);
qry.AppendLine(nameof(model.TransferLimitId).Parameterize() + (char)44);
qry.AppendLine(nameof(model.AdjLimit).Parameterize() + (char)44);
qry.AppendLine(nameof(model.AdjRemarks).Parameterize() + (char)44);
qry.AppendLine(nameof(model.AdjCreatedById).Parameterize());
qry.AppendLine(")");
qry.AppendLine("select @@identity");
model.TransferLimitId = DBContext.ExecuteQueryWithIdentityInt64(qry.ToString(), parameters);
return(model);
}
