public async Task <DeviceFault> Add(DeviceFault input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
const string sql = "INSERT INTO [DeviceFaults] ([Name],[Description]) VALUES(@Name, @Description) SELECT SCOPE_IDENTITY()";
var id = await conn.QueryFirstOrDefaultAsync <int>(sql, new { Name = input.Name, Description = input.Description });
return(await ById(id));
}
}
public async Task <DeviceFault> Update(DeviceFault input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
const string sql = "UPDATE [DeviceFaults] SET [Name]=@Name, [Description]=@Description, [UpdateDate]=GETDATE() WHERE id=@Id";
await conn.ExecuteAsync(sql, new { Name = input.Name, Description = input.Description, Id = input.Id });
return(await ById(input.Id));
}
}
public async Task <JsonResult> AddOrUpdate([FromBody] DeviceFault input)
{
await CheckPermission();
using (var rep = new DeviceFaultRepository(_logger))
{
if (input.Id == 0)
{
return(Json(await rep.Add(input)));
}
return(Json(await rep.Update(input)));
}
}
