public async Task <IActionResult> Create([FromBody] TRIALSpEntry pModel)
{
// Validation
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Validate(pModel, false) == false)
{
return(BadRequest(ModelState));
}
else
{
// Execution of concrete process
SQLResult result = new SQLResult();
result = await _repo.Create(pModel);
if (result.ErrorNo > 0)
{
return(BadRequest(result));
}
else
{
return(Ok(result));
}
}
}
public async Task <SQLResult> Edit(TRIALSpEntry pModel)
{
SQLResult result = new SQLResult();
_Context.Database.BeginTransaction();
try
{
string csql = @" EXEC spmTRIALSpUpdate
@pi_mTRIALSpId
, @pi_Name
, @pi_Active
, @pi_UserId
, @pi_HostName
, @pi_IPAddress
, @pi_DeviceType
, @pi_MACAddress
" ;
List <SqlParameter> sqlparam = new List <SqlParameter>()
{
new SqlParameter("@pi_mTRIALSpId", pModel.TRIALSpId),
new SqlParameter("@pi_Name", pModel.Name),
new SqlParameter("@pi_Active", pModel.Active),
new SqlParameter("@pi_UserId", pModel.AuditColumns.UserId),
new SqlParameter("@pi_HostName", pModel.AuditColumns.HostName),
new SqlParameter("@pi_IPAddress", pModel.AuditColumns.IPAddress),
new SqlParameter("@pi_DeviceType", pModel.AuditColumns.DeviceType),
new SqlParameter("@pi_MACAddress", pModel.AuditColumns.MACAddress),
};
result = await _Context.DBResult.FromSql(csql, sqlparam.ToArray()).SingleOrDefaultAsync();
if (result.ErrorNo != 0)
{
_Context.Database.RollbackTransaction();
}
else
{
_Context.Database.CommitTransaction();
}
}
catch (Exception ex)
{
_Context.Database.RollbackTransaction();
result.ErrorNo = 9999999999;
result.ErrorMessage = ex.Message.ToString();
result.SQLErrorNumber = ex.HResult;
result.SQLErrorMessage = ex.Source.ToString();
}
return(result);
}
private bool Validate(TRIALSpEntry pModel, bool isUpdateValidation)
{
if (isUpdateValidation == true)
{
if (pModel.TRIALSpId <= 0)
{
ModelState.AddModelError("", Messages.Blank("TRIALSp entry"));
return(false);
}
}
if (pModel.Name.Trim().Length == 0)
{
ModelState.AddModelError("", Messages.Blank("Name"));
return(false);
}
return(true);
}
