public object UpdateFileAction(FileActionInputDto input) { SqlHelper sqlHelper = new SqlHelper(connectionString); List <SqlParameter> fileActionParams = new List <SqlParameter> { new SqlParameter("file_id", input.fileId), new SqlParameter("action", input.action), new SqlParameter("action_start_date", DateTime.UtcNow), new SqlParameter("action_end_date", DateTime.UtcNow) }; var query = $@"INSERT INTO[dbo].[file_action] ([file_id] ,[action] ,[action_start_date] ,[action_end_date]) VALUES (@file_id ,@action ,@action_start_date ,@action_end_date)"; try { sqlHelper.VerifyConnection(); sqlHelper.Insert(query, CommandType.Text, fileActionParams.ToArray()); } catch (Exception ex) { sqlHelper.CloseConnection(); return(Utils.Wrap(false)); } return(Utils.Wrap(true)); }
public object FileAction(FileActionInputDto dto) { return(controller.UpdateFileAction(dto)); }